<?xml version="1.0" encoding="UTF-8"?><!-- generator="wordpress/2.0.1" -->
<rss version="0.92">
<channel>
	<title>Oracle Point, Oracle Life.</title>
	<link>http://oraclepoint.com/oralife</link>
	<description>Oracle Point, DBA, Tools, Case Study, and life sharing</description>
	<lastBuildDate>Fri, 24 Jul 2009 22:40:07 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Creating Core Repository for Oracle Designer</title>
		<description><![CDATA[Applied to: Oracle Developer Suite 10.1.2.0.2
Oracle Developer Suite As an important database design tool, Oracle Designer is used to implement oracle database design and ER planning. To have Oracle Designer working, it’s required to create a Core Repository before using it.
To create Core Repository, go Oracle Developer Suite – DevSuiteHome –&#62; Designer –&#62; Repository Administration [...]]]></description>
		<link>http://oraclepoint.com/oralife/2009/07/24/creating-core-repository-for-oracle-designer/</link>
			</item>
	<item>
		<title>Troubleshooting 01157 and 01110 errors while recreating Oracle 10g Undo tablespace</title>
		<description><![CDATA[Due to limitation of disk capacity, I was asked to resize one of our databases. Our investigation shows that the size of undo tablespace has been set to unnecessarily large, say 8G. Our junior DBA was trying to switch to newly created undo tablespace and have placed the datafile for default undo tablespace offline. After [...]]]></description>
		<link>http://oraclepoint.com/oralife/2009/06/30/how-to-recreate-oracle-undo-tablespace-in-10g/</link>
			</item>
	<item>
		<title>Using Crontab to Create Statspack Reports</title>
		<description><![CDATA[In versions before Oracle 10g, statspack is useful utility to monitor database performance and workload issues. I just came across a shell script which can automate snapshot report create and mail to DBA.
The script is re-posted as below without change.

[oracle@www1 sql]$ more backup/auto_send_perf.sh
#!/bin/sh
. ~oracle/.bash_profile
/home/oracle/product/9.2.0/bin/sqlplus -s aaa/bbb@ccc&#60;&#60;!
set head off
set timing off
spool /home/oracle/sql/backup/snap_begin.lst
select min(snap_id) snap_id
from stats$snapshot
where snap_time [...]]]></description>
		<link>http://oraclepoint.com/oralife/2009/04/23/using-crontab-to-create-statspack-reports/</link>
			</item>
	<item>
		<title>DbForge for MySQL</title>
		<description><![CDATA[DbForge studio for MYSQL is a powerful &#8220;mobile application development tool&#8221; for working with MYSQL. It is a standalone application that runs with .NET framework 1.1 or 2.0 dbForge studio for MYSQL supports all features of MYSQL versions 3.2.3 and higher. This software development tool presents a powerful visual interface for developing scripts, executing queries, [...]]]></description>
		<link>http://oraclepoint.com/oralife/2008/11/03/dbforge-for-mysql/</link>
			</item>
	<item>
		<title>Recovering Oracle Database upon losing all Control Files</title>
		<description><![CDATA[This is experimental case study about recovering oracle database upon losing all
control files. This experimental is conducted on Windows XP Professional
with Oracle database 10.2.0 in archivelog mode.
Recover Oracle Database upon losing all Control Fi.pdf

                ]]></description>
		<link>http://oraclepoint.com/oralife/2008/10/17/recovering-oracle-database-upon-losing-all-control-files/</link>
			</item>
</channel>
</rss>
