IPCLW:[0.0]{-}[CNCT]:RDS: [1559712222041287]ipclw_dump_cnh NO sbuf ctx:0x40008baf5fa8 pt:0x4000697677f0 sndh:0x4000697627e8 pid:192.168.10.4:51905 IPCLW:[0.1]{-}[CNCT]:RDS: [1559712222041287]ipclw_dump_cnh NO sbuf ctx:0x40008baf5fa8 pt:0x4000697677f0 sndh:0x400069763b38 pid:192.168.10.4:44710 IPCLW:[0.2]{-}[CNCT]:RDS: [1559712222041287]ipclw_dump_cnh NO sbuf ctx:0x40008baf5fa8 pt:0x4000697677f0 sndh:0x4000697634c8 pid:192.168.10.3:3853 IPCLW:[0.3]{-}[CNCT]:RDS: [1559712222041287]ipclw_dump_cnh NO sbuf ctx:0x40008baf5fa8 pt:0x4000697677f0 sndh:0x400069762e58 pid:192.168.10.4:49112 IPCLW:[0.4]{-}[CNCT]:RDS: [1559712222041287]ipclw_dump_cnh NO sbuf ctx:0x40008baf5fa8 pt:0x4000697677f0 sndh:0x400069762178 pid:192.168.10.3:2035
这套18c的RAC运行在X7-2上,exa版本18.1.13
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
SELECT CAST(extract(xmltype(confval), '/cli-output/cell/name/text()') AS VARCHAR2(20)) cv_cellname , CAST(extract(xmltype(confval), '/cli-output/cell/releaseVersion/text()') AS VARCHAR2(20)) cv_cellVersion , CAST(extract(xmltype(confval), '/cli-output/cell/kernelVersion/text()') AS VARCHAR2(30)) kernel_version , CAST(extract(xmltype(confval), '/cli-output/cell/makeModel/text()') AS VARCHAR2(50)) make_model FROM v$cell_config WHERE conftype = 'CELL' ORDER BY cv_cellname /
CV_CELLNAME CV_CELLVERSION KERNEL_VERSION MAKE_MODEL -------------------- -------------------- ------------------------------ -------------------------------------------------- xxx01 18.1.13.0.0.190210 4.1.12-124.24.3.el6uek.x86_64 Oracle Corporation ORACLE SERVER X7-2L High Capaci xxx02 18.1.13.0.0.190210 4.1.12-124.24.3.el6uek.x86_64 Oracle Corporation ORACLE SERVER X7-2L High Capaci xxx03 18.1.13.0.0.190210 4.1.12-124.24.3.el6uek.x86_64 Oracle Corporation ORACLE SERVER X7-2L High Capaci
SQL> select value from v$diag_info where NAME='Default Trace File';
VALUE ---------------------------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_255033.trc
执行一个只要本地查询的语句
1 2 3 4 5
SQL> select count(*) from v$instance;
COUNT(*) ---------- 1
检查生成的trace文件
1 2
SQL> ! cat /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_255033.trc cat: /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_255033.trc: No such file or directory
执行一个需要跨实例的语句
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
SQL> select count(*) from gv$instance;
COUNT(*) ---------- 2
SQL> ! cat /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_255033.trc Trace file /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_255033.trc Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0 Build label: RDBMS_18.1.0.0.0_LINUX.X64_180103.1 ORACLE_HOME: /u01/app/oracle/product/18.0.0.0/dbhome_1 System name: Linux
......省略
IPCLW:[0.0]{-}[CNCT]:RDS: [1559785604727267]ipclw_dump_cnh NO sbuf ctx:0x40009dafa168 pt:0x40009daf5f60 sndh:0x400094b63790 pid:192.168.10.3:4000
SQL> oradebug doc component rdbms.VOS
VOS VOS (ks)
hang_analysis Hang Analysis (ksdhng)
background_proc Background Processes (ksb, ksbt)
system_param System Parameters (ksp, kspt)
ksu Kernel Service User (ksu)
ksutac KSU Timeout Actions ((null))
ksv_trace Kernel Services Slave Management (ksv)
file File I/O (ksfd, ksfdaf)
ksq Kernel Service Enqueues (ksq)
ksolt_trace Kernel Services Lightweight Threads (ksolt)
KSIM Kernel Service Instance Management (ksim)
KSIM_GRPOP Kernel Service Instance Management Group Operation ((null))
KSIPC VOS IPC (ksipc)
KSMSQ Message queue services (ksmsq)
KSMSQ_MQL Message Queueing Layer ((null))
KSRMA ksrma (ksrma)
KSRMF ksrmf (ksrmf)
KSIPC_AM Active Messaging ((null))
KSIPC_GRP KSIPC Group Services ((null))
KSIPC_SN KSIPC Shared Nothing ((null))
KSIPC_KV KSIPC Key Value ((null))
KSIPC_TOPO KSIPC Topology Services ((null))
KSIPC_PR KSIPC Path Record ((null))
KSIPC_IPCLW IPC LightWeight ((null))
KSIPC_IPCOR IPC Core Functionality ((null))
KSIPC_SHREG KSIPC Shared Registration ((null))
LREG Listener Registration (kml)
ksupd KSU Planned Draining (ksupd)
可以通过下面的方法来关闭trace生成
1 2
ALTER SESSION SET EVENTS='trace[RDBMS.KSIPC_IPCLW] disk disable, memory disable'; ALTER SYSTEM SET EVENTS='trace[RDBMS.KSIPC_IPCLW] disk disable, memory disable';
SQL> select value from v$diag_info where NAME='Default Trace File';
VALUE ------------------------------------------------------------------------------------ /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_181480.trc
SQL> select count(*) from v$instance;
COUNT(*) ---------- 1
SQL> ! cat /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_181480.trc cat: /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_181480.trc: No such file or directory
SQL> select count(*) from gv$instance;
COUNT(*) ---------- 2
SQL> ! cat /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_181480.trc cat: /u01/app/oracle/diag/rdbms/xxx/xxx1/trace/xxx1_ora_181480.trc: No such file or directory