Show all queries coming to an Oracle database

oracle monitoring
user1186971 picture user1186971 · Feb 3, 2012 · Viewed 34.1k times · Source

I need to see all queries coming to database. How to do that? I could not get proper results from a Google search.

Answer

Sathyajith Bhat picture Sathyajith Bhat · Feb 3, 2012

Enable SQL Trace & all the queries coming to the database will be logged.

ALTER SESSION SET sql_trace = true;
ALTER SESSION SET tracefile_identifier = mysqltrace;

The trace file will be present in the udump directory.

If you want to audit the database, look at my previous answer.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More