OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Loaded Tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loaded Tables [message #62711]

Tue, 10 August 2004 21:03

ora
Messages: 47
Registered: June 2002

Member

Hi,

Can anybody tell me how to find out the most loaded or say used tables at a given time.

In short i want to know which tables of by DB get used at a given point of time.

Ora.

Report message to a moderator

Re: Loaded Tables [message #62722 is a reply to message #62711]

Tue, 10 August 2004 22:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

There are some advanced auditing possibilities in Oracle. Search the board for more info.

MHE

Report message to a moderator

Re: Loaded Tables [message #62725 is a reply to message #62722]

Tue, 10 August 2004 23:23

ora
Messages: 47
Registered: June 2002

Member

Hi,

Well, can't u provide me any script through which i can identify the most loaded tables.

I have searched that kind of script but unable to find yet.

Thanx.

Report message to a moderator

Re: Loaded Tables [message #62728 is a reply to message #62725]

Wed, 11 August 2004 00:59

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can audit all DML of any table. Given that, you can easily extract what table has been used most.

Look here and herefor info on auditing a database. It requires a free subscription.

MHE

Report message to a moderator

Previous Topic:	Internal login
Next Topic:	ora-01034

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 10:25:36 CDT 2024