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.

Report message to a moderator

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: 68684
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: oracle instance creation using dbca errors out.
Next Topic: users tablespace importance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:04:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.