Home » RDBMS Server » Server Administration » How to know which tables are used by application
How to know which tables are used by application [message #222133] Fri, 02 March 2007 00:11 Go to next message
irfanr
Messages: 11
Registered: December 2006
Location: india
Junior Member
Hello,

I have about 1500 tables in a schema,

how to find which tables are highly used by our application, and which are used less and which are not at all used.

Kinldy help..

Thanks
Re: How to know which tables are used by application [message #222277 is a reply to message #222133] Fri, 02 March 2007 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
There is no simple solution to this challenge.
Extensive use of AUDIT could be one possible solution.
Re: How to know which tables are used by application [message #222309 is a reply to message #222133] Fri, 02 March 2007 14:50 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Assuming you are in 10g the amount of usage you can find in V$SEGSTAT or it's more user friendly (and also expensive) brother V$SEGMENT_STATISTICS.
But the information there isn't absolutely precise (i.e. is updated each x seconds and not always, if I remember correctly there was a note in Metalink describing that), so if you cannot find an entry for a table, it doesn't mean the table isn't touched at all.

Gints Plivna
http://www.gplivna.eu
Previous Topic: oracle 10g server as client???
Next Topic: Consistent gets clarification (merged)
Goto Forum:
  


Current Time: Sat Dec 03 20:10:13 CST 2016

Total time taken to generate the page: 0.04493 seconds