DBMS package for tracing

--using dbms_system
execute dbms_system.set_sql_trace_in_session(9,190,TRUE);

--You can also initiate a TRACE for the session that you are in using the DBMS_SESSION package.

execute DBMS_SESSION.SET_SQL_TRACE (TRUE);

--10g

DBMS_MONITOR