Software

Ask something
Discussion Locked

Running sql statements in ORACLE

0 helpful
3 replies

by me

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can we access the running sql statements in ORACLE 7.3.4.3 +?

Will audit_trail=DB do the job?
Is it stored in tables?, v$[*] tables^

Yves Morin
morin.y@bimcor.ca

3 replies

by peace monger

You can query the v$sqlarea view in the data dictionary to find a given SQL statement.

There's also pertinent information in the v$sql view.

The audit trail does not need to be turned on to query that information. Enabling auditing, unless there's a sound business purpose to it, is unnecessary for tracing SQL statements and examining performance.

This discussion is closed to new replies.