| PMON trace file | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pmon_PID.trc | where SID is the database SID and PID is the OS process ID |
| Process Spawner Process | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pspN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Virtual Keeper of Time | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_vktm_PID.trc | where SID is the database SID and PID is the OS process ID |
| General Task Execution | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_genN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Diagnostic Capture | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_diag_PID.trc | where SID is the database SID and PID is the OS process ID |
| DB Resource Manager | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dbrm_PID.trc | where SID is the database SID and PID is the OS process ID |
| Interconnect Latency | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ping_PID.trc | where SID is the database SID and PID is the OS process ID |
| Automic CF to Memory | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_acms_PID.trc | where SID is the database SID and PID is the OS process ID |
| Diagnostic Process | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_diaN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Global ENQ Service Monitor | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmon_PID.trc | where SID is the database SID and PID is the OS process ID |
| Global ENQ Service Daemon | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmdN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Global Cache Serivce | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmsN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| RAC Management | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rmsN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Global Cache/ENQ HB Mon | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmhb_PID.trc | where SID is the database SID and PID is the OS process ID |
| Memory Manager | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mman_PID.trc | where SID is the database SID and PID is the OS process ID |
| DB Writer | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dbwN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Log Writer | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lgwr_PID.trc | where SID is the database SID and PID is the OS process ID |
| Checkpoint | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ckpt_PID.trc | where SID is the database SID and PID is the OS process ID |
| System Monitor | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_smon_PID.trc | where SID is the database SID and PID is the OS process ID |
| Recovery | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_reco_PID.trc | where SID is the database SID and PID is the OS process ID |
| ASM Rebalance Master | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rbal_PID.trc | where SID is the database SID and PID is the OS process ID |
| ASM Background | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_asmb_PID.trc | where SID is the database SID and PID is the OS process ID |
| Manageability Monitor | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mmon_PID.trc | where SID is the database SID and PID is the OS process ID |
| Manageability Monitor Lite | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mmnl_PID.trc | where SID is the database SID and PID is the OS process ID |
| Mark AU Sync Coordinator | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mark_PID.trc | where SID is the database SID and PID is the OS process ID |
| Instance ENQ Background | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lckN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| Remote Slave Monitor | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rsmn_PID.trc | where SID is the database SID and PID is the OS process ID |
| DG Broker Monitor | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dmon_PID.trc | where SID is the database SID and PID is the OS process ID |
| PQ Slave | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pxxx_PID.trc | where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| ASM Connection Pool | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_oxxx_PID.trc | where SID is the database SID, xxx is the proc No and PID is the OS process ID |
| Archiver | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_arcN_PID.trc | where SID is the database SID, N is the process No and PID is the OS process ID |
| REDO Transport | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_nsaN_PID.trc | where SID is the database SID, N is the proc No and PID is the OS process ID |
| Global Transaction | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_gtxN_PID.trc | where SID is the database SID, N is the proc No and PID is the OS process ID |
| Result Cache | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rcbg_PID.trc | where SID is the database SID and PID is the OS process ID |
| AQ Coordinator | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_qmnc_PID.trc | where SID is the database SID and PID is the OS process ID |
| AQ Server Class | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_qxxx_PID.trc | where SID is the database SID, xxx is the proc No and PID is the OS process ID |
| Space Mgmt Coordinator | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_smco_PID.trc | where SID is the database SID and PID is the OS process ID |
| Job Queue Coordinator | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_cjqN_PID.trc | where SID is the database SID, N is the proc No and PID is the OS process ID |
| Space Mgmt Slave | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_wxxx_PID.trc | where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| Space Mgmt Slave | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_wxxx_PID.trc | where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| User Process | $ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ora_PID.trc | where SID is the database SID and PID is the OS process ID |
Monday, January 6, 2020
Oracle Trace Files - Location
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment