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,
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: 10615
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
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

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: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See AUDIT.

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


Current Time: Tue Jul 22 22:56:04 CDT 2014

Total time taken to generate the page: 0.12945 seconds