- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Doubt to find which tables are absolete.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2007 12:15 AM
тАО05-04-2007 12:15 AM
Doubt to find which tables are absolete.
we use to run dbstats for the entire schema whenever change in structure of schema happens.i want to find out in that schema which tables are absolete.if i found which tables are absolete.i will run dbstats for the tables only.
Help appreciated..
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2007 12:23 AM
тАО05-04-2007 12:23 AM
Re: Doubt to find which tables are absolete.
Why version of database are you running?
You can use dbms_stats package to collect the statistics.
e.g
dbms_stats.gather_schema_stats( ownname => user, options => 'GATHER STALE' );
for it to work properly, you should enable "monitoring" on all tables.
if you need any further clarifications, please let us know.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2007 12:55 AM
тАО05-04-2007 12:55 AM
Re: Doubt to find which tables are absolete.
Thank u for your suggestions..
we use to run the DBSTATS with the commands u r mentioned in this forum thread.MY question is any Data Dictionary view or dynamic performance view are availbale to find out which tables are ABSOLETE.
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2007 01:54 AM
тАО05-04-2007 01:54 AM
Re: Doubt to find which tables are absolete.
there are many such data dictionary views.
one that i can think right now is col_usage$
see also:
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#sthref7885
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2007 02:55 AM
тАО05-04-2007 02:55 AM
Re: Doubt to find which tables are absolete.
l_objList dbms_stats.objectTab;
dbms_stats.gather_schema_stats(
ownname => l_schema_owner,
options => 'LIST AUTO',
objlist => l_objList
Iterate over the list and use dbms_output to
list the stale (obsolete) tables.