OraFAQ Forum: Server Administration » Number of Hits to Database

Home » RDBMS Server » Server Administration » Number of Hits to Database

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

Number of Hits to Database [message #55672]

Fri, 07 February 2003 02:49

Dev
Messages: 28
Registered: May 2001

Junior Member

Hi All,

I wanted to get the information about number of Hits on Database for a day or so.

Could you please let me know how this can be done.? Whether we have to start trace and audit ? Or there are any tools for the same.

Deven.

Report message to a moderator

Re: Number of Hits to Database [message #55677 is a reply to message #55672]

Fri, 07 February 2003 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

'HIT' in oracle terminology typically means 'LOGICAL READ OF BLOCKS '.
I am not sure, if you are looking into the same
or
are u looking into 'NUMBER TIMES THE DATABAS WAS ACCESSED BY CLIENTS OR SOMETHING LIKE THAT'?
This information can be collected from listener.log.
But there wont be any count !. so, you have set up something like AUDIT.

Report message to a moderator

Previous Topic:	storage (pctincrease 1)-
Next Topic:	Event Log Errors Oracle 734 on NT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 02:56:21 CDT 2025