| Database Cleaning [message #53335] |
Thu, 12 September 2002 18:59  |
Santy
Messages: 4
Registered: September 2002
|
Junior Member |
|
|
|
How do i identify tables in my schema which have not been used for the last 6 months.
|
|
|
|
| Re: Database Cleaning [message #54712 is a reply to message #53335] |
Fri, 29 November 2002 16:23  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
There is a nice article about table, index and packages usage Here
In Oracle 9i, you can also enable MONITORING for tables and indexes with:
ALTER TABLE table_name MONITORING;
Then query DBA_TABLES to get the last date, table was modified. More information for that is provided Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
