Oracle Database Discussions

Hi all,

I have critical production issue. I have problem with a scenario in application. I was trying to trace the queries that are fired so that i have narrow down the issue. but when i enabled trace using

Alter system set sql_trace=true scope=both;

The trace file is generated but the queries are not captured.

When we query the table that was involved the transaction happened during the Trace time...

Any ideas why the trace is not getting generated.