Home » RDBMS Server » Server Administration » Identifying Unused Schema/Tables
Identifying Unused Schema/Tables [message #272251] Thu, 04 October 2007 05:47 Go to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
describe to me if someone know how to check that
which schema OR tables or not used for the last 3 or 4 months...
So that I remove it to free the space back.......

[mod-edit] removed illiterate IM speak.

[Updated on: Thu, 04 October 2007 07:45] by Moderator

Report message to a moderator

Re: Identifying Unused Schema/Tables [message #272253 is a reply to message #272251] Thu, 04 October 2007 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way unless you have audit on all tables.

Regards
Michel
Re: Identifying Unused Schema/Tables [message #272260 is a reply to message #272253] Thu, 04 October 2007 06:07 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
it may be an option.
But is there no way

or it can be handled by using some sql and PL/sql ...
like we can determine by examining it by listing in the DB Buffer cache i.e what tables are accessed.
We can create the table and then create a trigger on it which will check the access tables from the buffer cache and insert it into the table and if it exists then ignore......

Can it be an option....
Re: Identifying Unused Schema/Tables [message #272265 is a reply to message #272260] Thu, 04 October 2007 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can it be an option....

No. Some table blocks may be aged out the buffer cache before you see there are in.

By the way, your application should normally be able to say which tables they used.

Another way is to remove access to all tables and see what problems come.

Regards
Michel
Re: Identifying Unused Schema/Tables [message #272497 is a reply to message #272265] Fri, 05 October 2007 04:54 Go to previous messageGo to next message
smunir362
Messages: 299
Registered: September 2007
Senior Member
ok that may be an option.....
But It have a little problem...
My apps are running 24 x 7 and I cannot do that exercise.....

Is there anther way that I adopt to fullfill my requirement....
Re: Identifying Unused Schema/Tables [message #272499 is a reply to message #272497] Fri, 05 October 2007 04:55 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: sys and system
Next Topic: Delete default Oracle Parameter
Goto Forum:
  


Current Time: Tue Dec 06 04:09:12 CST 2016

Total time taken to generate the page: 0.13344 seconds