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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
There is no simple solution to this challenge.
Extensive use of AUDIT could be one possible solution.

Report message to a moderator

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

Report message to a moderator

Previous Topic: oracle 10g server as client???
Next Topic: Consistent gets clarification (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:07:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.