Home » RDBMS Server » Server Administration » Detecting unused schema
Detecting unused schema [message #307064] Mon, 17 March 2008 14:44 Go to next message
DrNeko
Messages: 17
Registered: January 2007
Location: NJ
Junior Member
Is there a way to detect unused schemas? In my test environment, some schemas were created temporary for testing purposes, and a number of them are obsolete. Is there a way to determine which ones haven't been uses for the past 12 months? Thank you.
Re: Detecting unused schema [message #307067 is a reply to message #307064] Mon, 17 March 2008 14:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Detecting unused schema [message #307312 is a reply to message #307064] Tue, 18 March 2008 07:56 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use the MONITORING USAGE clause for indexes to determine when they were last used.
You can use Auditing to determine the last select on tables, but all of these needed to be set up beforehand
Re: Detecting unused schema [message #307897 is a reply to message #307064] Thu, 20 March 2008 05:05 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

One more option, Need 1 year archive log and use logminer to analyze the archivelog. A very long process and also need at least minimum level supplemental logging beforehand.
Previous Topic: oracle instance creation using dbca errors out.
Next Topic: users tablespace importance
Goto Forum:
  


Current Time: Sat Dec 03 13:53:45 CST 2016

Total time taken to generate the page: 0.08825 seconds