Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Security » audit index usage (ORACLE 11)
audit index usage [message #408666] Wed, 17 June 2009 04:54 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9777
Registered: March 2002
Location: oracleDocoVille
Senior Member
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 16:02:49 CST 2009

Total time taken to generate the page: 0.33651 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.