Home » RDBMS Server » Server Administration » Can we mailtain log file of all the queries to a DB
Can we mailtain log file of all the queries to a DB [message #55832] Wed, 19 February 2003 03:04 Go to next message
jhansi
Messages: 5
Registered: February 2003
Junior Member
Hi
I wanted to maintain the list of quieries pose to the DB by all the users of that DB Can i do that
please help me
thanx in advance
Jhansi

Report message to a moderator

Re: Can we mailtain log file of all the queries to a DB [message #55841 is a reply to message #55832] Thu, 20 February 2003 00:17 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You can audit all SELECT statements on certain table by turning the auditing on with:

AUDIT SELECT ON table_name;

However, to get a list of the exact queries is going to be hard to do it. Unless your users are allowed to connect to the db only through some application, which you can control - I don't see such magic user-spy mechanism.

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Visit our web site

Report message to a moderator

Previous Topic: quotation mark in pl/sql
Next Topic: What's the definition for Oracle?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:48:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.