OraFAQ Forum: Security » audit index usage

Home » RDBMS Server » Security » audit index usage (ORACLE 11)

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

audit index usage [message #408666]

Wed, 17 June 2009 04:54

aline
Messages: 92
Registered: February 2002

Member

Hi all,

I want to know if it's possible to audit the usage of on an index.

thk,

Report message to a moderator

Re: audit index usage [message #408689 is a reply to message #408666]

Wed, 17 June 2009 05:41

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

Senior Member
Account Moderator

For indexes you can audit only create,drop and alter statements.
May be you are looking to monitor the Usage of indexes.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/indexes004.htm#sthref2060

Report message to a moderator

Re: audit index usage [message #408905 is a reply to message #408689]

Thu, 18 June 2009 04:44

aline
Messages: 92
Registered: February 2002

Member

thk for your answer,

Yes I want to monitor the usage of an index.
I want to do the same thing than for other objects like table for example (audit select on mytable).
So, it seems it's not possible Sad

Report message to a moderator

Re: audit index usage [message #408908 is a reply to message #408905]

Thu, 18 June 2009 04:53

Michel Cadot
Messages: 66934
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

See AUDIT.

Regards
Michel

Report message to a moderator

Previous Topic:	Cobol program that accesses Oracle database
Next Topic:	audit usage of procedure in a package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 05 03:09:17 CDT 2020