OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sql statement logs

Fri, 19 August 2005 07:22

owais303
Messages: 19
Registered: July 2005
Location: India

Junior Member

hi,
Is there any way to determine the log of sql queries that were executed on a database

thanks

Fri, 19 August 2005 07:30

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

Senior Member
Account Moderator

Enable auditing.
or
Enable tracing
or
Look into using logminer

Fri, 19 August 2005 07:34

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

By default Oracle doesn't log queries. To see all queries in the DB's Shared Pool, try something like this:

SQL> SELECT sql_text FROM v$sql;

Best regards.

Frank

Previous Topic:	Login problem with system and sys
Next Topic:	Tablespace name for constraints

Goto Forum:

]

Current Time: Sun Jan 26 10:38:27 CST 2025