Re: identifying unused databases
Posted by:
Rick James
Date: December 31, 2010 08:26PM
There is not really any way to do that. Here are some clumsy suggestions:
* Drop the database (after backing it up). If no one complains, that it was dead.
* Turn on the "general log". Let the system run a week. (But watch out for the disk filling up.) Grep through the general log to find all the databases mentioned. Then assume the other databases are dead.
* Change the permissions of all the logins so that they do not have access to the suspected databases. Wait for someone to complain.
Subject
Views
Written By
Posted
6092
December 27, 2010 10:31PM
Re: identifying unused databases
2629
December 31, 2010 08:26PM
2330
January 12, 2011 10:31PM
1862
January 15, 2011 12:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.