SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

SQL Trace with Oracle Database

Enable SQL Trace for my own single session:

ALTER SESSION SET SQL_TRACE = TRUE;

Or use a pl/sql program instead:

begin
dbms_session.set_sql_trace(true);
end;

For other sessions you can use:

BEGIN
sys.DBMS_SYSTEM.set_sql_trace_in_session(,,TRUE);
END;

Bookmark It