Oracle Database: Query to List All Statistics Tables June 25, 2014 If you were a big fan of manual database upgrade steps, perhaps you would have come across this...
Should AUD$ Table Exist on System Tablespace During DB Upgrade? May 23, 2014 I see this following message on all My Oracle Support notes, which talks about database Oracle...
Purge statspack snaps of source db on test db having different DBID? January 31, 2014 As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms...
How to recover a subset of an Oracle database December 9, 2013 Today's blog post will discuss how to recover a subset of an Oracle database. Many of you would...
How to move Oracle DB to New Oracle Home on Same Windows Server November 25, 2013 I have been thinking about writing a Pythian blog for long time, and today I finally took the...