Types of Trace Files
Extended Tracing and Multitenancy
ALTER SESSION SET EVENTSSQL statement from either the root or a pluggable database (PDB) enables tracing for the current user session. If you switch from one PDB to another PDB (by using the
ALTER SESSION SET CONTAINERstatement), then tracing is still enabled for the new PDB. You cannot enable tracing for a single PDB in a multitenant container database (CDB); it applies to all PDBs and the root.
Setting Trace Events
- alter session set events '10046 trace name context forever level 8';
- DBMS_MONITOR: It is specially useful for tracing remote sessions and to enable what Oracle calls end-to-end tracing.