RAC 一个节点HANG住

 

ALERT:

Thread 2 advanced to log sequence 98525 (LGWR switch)
  Current log# 3 seq# 98525 mem# 0: +DATA/ttdb/onlinelog/group_3.284.732386397
  Current log# 3 seq# 98525 mem# 1: +FLASH/ttdb/onlinelog/group_3.264.732386397
Wed Jan  4 09:58:34 2012
Thread 2 advanced to log sequence 98526 (LGWR switch)
  Current log# 4 seq# 98526 mem# 0: +DATA/ttdb/onlinelog/group_4.285.732386399
  Current log# 4 seq# 98526 mem# 1: +FLASH/ttdb/onlinelog/group_4.265.732386399
Wed Jan  4 10:13:27 2012
Errors in file /opt/oracle/product/10.2/db/admin/ttdb/bdump/ttdb2_j001_24903786.trc:
ORA-12012: error on auto execute of job 42780
ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process
Wed Jan  4 10:37:09 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 10:50:46 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 10:51:51 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 10:53:39 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 10:54:23 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=16
System State dumped to trace file /opt/oracle/product/10.2/db/admin/ttdb/bdump/ttdb2_smon_12976310.trc
Wed Jan  4 10:55:34 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=172
System State dumped to trace file /opt/oracle/product/10.2/db/admin/ttdb/udump/ttdb2_ora_16121904.trc
Wed Jan  4 10:55:47 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 10:59:20 2012
PMON failed to acquire latch, see PMON dump
Wed Jan  4 11:05:27 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=136
System State dumped to trace file /opt/oracle/product/10.2/db/admin/ttdb/udump/ttdb2_ora_11927704.trc
Wed Jan  4 11:08:40 2012
Trace dumping is performing id=[cdmp_20120104110835]
Wed Jan  4 11:25:42 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=243
System State dumped to trace file /opt/oracle/product/10.2/db/admin/ttdb/udump/ttdb2_ora_21561530.trc
Wed Jan  4 11:25:43 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=200
Wed Jan  4 11:25:43 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=223
Wed Jan  4 11:26:24 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=224
Wed Jan  4 11:26:37 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=239
System State dumped to trace file /opt/oracle/product/10.2/db/admin/ttdb/udump/ttdb2_ora_28377186.trc
Wed Jan  4 11:26:42 2012
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=228
Wed Jan  4 11:29:41 2012
Shutting down instance (abort)
License high water mark = 217
Instance terminated by USER, pid = 23658598
Wed Jan  4 11:31:04 2012
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 en7 192.168.0.0 configured from OCR for use as a cluster interconnect
Interface type 1 en6 10.150.0.0 configured from OCR for use as  a public interface
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 500
  sessions                 = 555
  sga_max_size             = 15737028608
  __shared_pool_size       = 5536481280
  __large_pool_size        = 16777216
  __java_pool_size         = 16777216
  __streams_pool_size      = 0
  spfile                   = +DATA/ttdb/spfilettdb.ora
  nls_language             = SIMPLIFIED CHINESE
  nls_territory            = CHINA
  sga_target               = 15737028608
  control_files            = +DATA/ttdb/controlfile/current.279.732386321, +FLASH/ttdb/controlfile/current.261.732386321
  db_block_size            = 8192
  __db_cache_size          = 10150215680
  compatible               = 10.2.0.3.0
  log_archive_dest_1       = LOCATION=+FLASH/
  log_archive_format       = %t_%s_%r.dbf
  db_file_multiblock_read_count= 16
  cluster_database         = TRUE
  cluster_database_instances= 2
  db_create_file_dest      = +DATA
  db_recovery_file_dest    = +FLASH
  db_recovery_file_dest_size= 107374182400
  thread                   = 2
  instance_number          = 2
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS2
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ttdbXDB)
  remote_listener          = LISTENERS_ttDB
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/10.2/db/admin/ttdb/bdump
  user_dump_dest           = /opt/oracle/product/10.2/db/admin/ttdb/udump
  core_dump_dest           = /opt/oracle/product/10.2/db/admin/ttdb/cdump
  audit_file_dest          = /opt/oracle/product/10.2/db/admin/ttdb/adump
  db_name                  = ttdb
  open_cursors             = 3000
  _b_tree_bitmap_plans     = FALSE
  _optimizer_skip_scan_enabled= FALSE
  optimizer_index_cost_adj = 40
  pga_aggregate_target     = 3277848576
  optimizer_dynamic_sampling= 4
  _optimizer_cartesian_enabled= FALSE
Cluster communication is configured to use the following interface(s) for this instance
  192.168.0.5
Wed Jan  4 11:31:05 2012
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=27590700
DIAG started with pid=3, OS id=10027012
PSP0 started with pid=4, OS id=29163532
LMON started with pid=5, OS id=22151418
LMD0 started with pid=6, OS id=18087954
LMS0 started with pid=7, OS id=28901382
LMS1 started with pid=8, OS id=28704880
LMS2 started with pid=9, OS id=28967048
LMS3 started with pid=10, OS id=30343224
MMAN started with pid=11, OS id=28311652
DBW0 started with pid=12, OS id=27918432
DBW1 started with pid=13, OS id=28508266
LGWR started with pid=14, OS id=27852874
CKPT started with pid=15, OS id=27787450
SMON started with pid=16, OS id=27721882
RECO started with pid=17, OS id=27656372
CJQ0 started with pid=18, OS id=27525174
MMON started with pid=19, OS id=27459672
Wed Jan  4 11:31:07 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=20, OS id=27328570
Wed Jan  4 11:31:07 2012
starting up 1 shared server(s) ...
Wed Jan  4 11:31:08 2012
lmon registered with NM - instance id 2 (internal mem no 1)
Wed Jan  4 11:31:08 2012
Reconfiguration started (old inc 0, new inc 8)
List of nodes:
 0 1

 

/opt/oracle/product/10.2/db/admin/ttdb/bdump/ttdb2_j001_24903786.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/10.2/db
System name: AIX
Node name: tt51
Release: 1
Version: 6
Machine: 00C211D54C00
Instance name: ttdb2
Redo thread mounted by this instance: 2
Oracle process number: 142
Unix process pid: 24903786, image: oracle@tt51 (J001)

*** SERVICE NAME:(SYS$USERS) 2012-01-04 10:13:27.506
*** SESSION ID:(445.125) 2012-01-04 10:13:27.506
*** 2012-01-04 10:13:27.506
ORA-12012: error on auto execute of job 42780
ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process

 

 

ASS109.AWK

 

Starting Systemstate 1
..............................................................................
...............................................................................
............................................................................
Ass.Awk Version 1.0.9 - Processing ./db2_smon_12976310.trc

System State 1
~~~~~~~~~~~~~~~~
1:                                     
2:  waiting for 'latch: shared pool'   [Latch 7000000100ee010] wait
3:  waiting for 'DIAG idle wait'        wait
4:  waiting for 'rdbms ipc message'     wait
5:  waiting for 'rdbms ipc message'     wait
6:  waiting for 'ges remote message'    wait
7:  waiting for 'gcs remote message'    wait
8:  waiting for 'gcs remote message'    wait
9:  waiting for 'gcs remote message'    wait
10: waiting for 'gcs remote message'    wait
11: waiting for 'rdbms ipc message'     wait
12: waiting for 'rdbms ipc message'     wait
13: waiting for 'rdbms ipc message'     wait
14: waiting for 'rdbms ipc message'     wait
15: waiting for 'rdbms ipc message'     wait
16: last wait for 'ksdxexeotherwait'   [Rcache bject=7000002eee5bf08,]
17: waiting for 'rdbms ipc message'     wait
18: waiting for 'rdbms ipc message'     wait
19: waiting for 'rdbms ipc reply'       wait
20: waiting for 'rdbms ipc message'     wait
21:                                    
22:                                    
23: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
24: waiting for 'PX Deq: Execution Msg' wait
     Cmd: Select
25: waiting for 'ASM background timer'  wait
26: waiting for 'rdbms ipc message'     wait
27: waiting for 'SQL*Net message from client' wait
28: waiting for 'rdbms ipc message'     wait
29: waiting for 'rdbms ipc message'     wait
30: waiting for 'SQL*Net message from client' wait
31: waiting for 'Streams AQ: qmn coordinator idle wait' wait
32: waiting for 'SQL*Net message from client' wait
33: waiting for 'SQL*Net message from client' wait
34: for 'Streams AQ: waiting for time management or cleanup tasks' wait
35: waiting for 'Streams AQ: qmn slave idle wait' wait
36: waiting for 'rdbms ipc reply'       wait
37: waiting for 'SQL*Net message from client' wait
38: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
39: waiting for 'SQL*Net message from client' wait
40: waiting for 'class slave wait'      wait
41: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
42: last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
43: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
45: waiting for 'latch: row cache objects' [DEAD] wait
46: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
47: waiting for 'SQL*Net message from client' wait
48: waiting for 'latch: row cache objects' [DEAD] wait
49: waiting for 'SQL*Net message from client' wait
     Cmd: Select
50: waiting for 'SQL*Net message from client' wait
52: waiting for 'SQL*Net message from client' wait
53: waiting for 'SQL*Net message from client' wait
54: waiting for 'SQL*Net message from client' wait
55: waiting for 'SQL*Net message from client' wait
56: waiting for 'SQL*Net message from client' wait
57: waiting for 'SQL*Net message from client' wait
58: waiting for 'SQL*Net message from client' wait
59: waiting for 'SQL*Net message from client' wait
60: waiting for 'SQL*Net message from client' wait
62: waiting for 'SQL*Net message from client' wait
63: waiting for 'SQL*Net message from client' wait
64: waiting for 'SQL*Net message from client' wait
65: waiting for 'SQL*Net message from client' wait
66: waiting for 'SQL*Net message from client' wait
67: waiting for 'SQL*Net message from client' wait
68: waiting for 'SQL*Net message from client' wait
69: waiting for 'SQL*Net message from client' wait
70: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
71: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
73: waiting for 'SQL*Net message from client' wait
74: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
75: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
77: waiting for 'SQL*Net message from client' wait
78: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
79: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
80: waiting for 'SQL*Net message from client' wait
81: waiting for 'SQL*Net message from client' wait
82: waiting for 'SQL*Net message from client' wait
83: waiting for 'SQL*Net message from client' wait
84: waiting for 'SQL*Net message from client' wait
85: waiting for 'SQL*Net message from client' wait
86: waiting for 'SQL*Net message from client' wait
87: waiting for 'SQL*Net message from client' wait
88: waiting for 'SQL*Net message from client' wait
89: waiting for 'SQL*Net message from client' wait
90: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
91: waiting for 'SQL*Net message from client' wait
92: waiting for 'reliable message'      wait
     Cmd: Select
93: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
94: waiting for 'latch: row cache objects' [DEAD] wait
     Cmd: Select
95: waiting for 'latch: row cache objects' [DEAD] wait
     Cmd: Select
96: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
97: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Insert
98: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
99: waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
100:waiting for 'SQL*Net message from client' wait
101:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
102:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
103:waiting for 'SQL*Net message from client' wait
104:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
105:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
106:waiting for 'SQL*Net message from client' wait
107:waiting for 'cursor: pin S wait on X' wait
108:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
109:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
110:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
     Cmd: Select
111:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
112:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
113:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
114:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
115:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
116:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
117:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
     Cmd: Select
118:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
119:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
120:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
121:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
122:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
123:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
124:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
125:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
126:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
127:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
128:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
129:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
130:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
131:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
132:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
133:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
134:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
135:waiting for 'PX Deq: Execution Msg' wait
136:waiting for 'row cache lock'       [Rcache bject=7000002fd1de590,] wait
     Cmd: Select
137:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
     Cmd: Select
138:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
139:waiting for 'cursor: pin S wait on X' wait
140:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
141:waiting for 'library cache lock'   [LOCK: handle=7000002f39aa250] wait
     Cmd: Unknown(22)
143:waiting for 'library cache lock'   [LOCK: handle=7000002f39aa250] wait
     Cmd: Unknown(22)
144:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
145:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
146:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
147:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
148:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
149:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
150:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
151:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
152:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
153:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
154:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
155:waiting for 'SQL*Net message from client' wait
156:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
157:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
158:waiting for 'cursor: pin S wait on X' wait
159:waiting for 'cursor: pin S wait on X' wait
160:waiting for 'cursor: pin S wait on X' wait
161:waiting for 'cursor: pin S wait on X' wait
162:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
163:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
164:waiting for 'cursor: pin S wait on X' wait
165:waiting for 'cursor: pin S wait on X' wait
166:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
167:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
168:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
169:waiting for 'cursor: pin S wait on X' wait
170:waiting for 'cursor: pin S wait on X' wait
171:waiting for 'cursor: pin S wait on X' wait
172:waiting for 'row cache lock'       [Rcache bject=70000021f9f0a70,] wait
     Cmd: Select
173:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
174:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
175:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
176:waiting for 'cursor: pin S wait on X' wait
177:waiting for 'cursor: pin S wait on X' wait
178:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
179:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
180:waiting for 'cursor: pin S wait on X' wait
181:waiting for 'cursor: pin S wait on X' wait
182:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
183:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
184:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
185:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
186:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
187:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
188:waiting for 'cursor: pin S wait on X' wait
189:waiting for 'cursor: pin S wait on X' wait
190:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
191:waiting for 'cursor: pin S wait on X' wait
193:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
194:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
195:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
196:waiting for 'cursor: pin S wait on X' wait
197:waiting for 'cursor: pin S wait on X' wait
198:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
199:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
200:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Update
201:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
202:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
203:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Insert
204:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
205:last wait for 'latch: row cache objects'[Latch 7000003a26dbe08]
206:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
207:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
208:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
209:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
210:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
211:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
212:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
213:waiting for 'cursor: pin S wait on X' wait
214:waiting for 'SQL*Net message from client' wait
215:waiting for 'cursor: pin S wait on X' wait
216:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
217:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
218:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
219:waiting for 'cursor: pin S wait on X' wait
220:waiting for 'SQL*Net message from client' wait
     Cmd: Select
221:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
222:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
223:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Update
224:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Insert
225:waiting for 'cursor: pin S wait on X' wait
227:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
228:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Insert
231:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
232:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
233:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
235:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
236:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
237:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Select
238:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
239:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Update
241:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
     Cmd: Insert
242:waiting for 'latch: row cache objects'[Latch 7000003a26dbe08] wait
243:waiting for 'row cache lock'       [Rcache bject=7000002eee5bf08,] wait
     Cmd: Insert
245:waiting for 'SQL*Net message from client' wait
247:waiting for 'SQL*Net message from client' wait
     Cmd: Select
Blockers
~~~~~~~~

 Above is a list of all the processes. If they are waiting for a resource
 then it will be given in square brackets. Below is a summary of the
 waited upon resources, together with the holder of that resource.
 Notes:
 ~~~~~
  o A process id of '???' implies that the holder was not found in the
    systemstate.

                    Resource Holder State
       Latch 7000000100ee010    ??? Blocker
Rcache bject=7000002eee5bf08,    ??? Blocker
       Latch 7000003a26dbe08    ??? Blocker
Rcache bject=7000002fd1de590,    ??? Blocker
LOCK: handle=7000002f39aa250    ??? Blocker
Rcache bject=70000021f9f0a70,    ??? Blocker

Query Co-Ordinator to Query Slave Mapping
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
QC=  92:  [Count=2]
           Communicates with Slave 0 (hex) on instance 2 (PS-02-0E0F)
           Communicates with Slave 0 (hex) on instance 1 (PS-01-0E0F)
Slave     Info Msg    State        From          To  Type  Status     Mode  Err
  24: PS-02-0E0F   1   00000,         92:         24:  DTA,     FRE     STRE    0
                         ------------------------
STATUS Key:
  DEQ = buffer has been dequeued
  EML = buffer on emergency message list
  ENQ = buffer has been enqueued
  FLST= buffer is on SGA freelist
  FRE = buffer is free (unused)
  GEB = buffer has been gotten for enqueuing
  GDB = dequeued buffer has been gotten
  INV = buffer is invalid (non-existent)
  QUE = buffer on queue message list
  RCV = buffer has been received
  NOFL= not on freelist (just removed)
                              ------------------------

Object Names
~~~~~~~~~~~~
Latch 7000000100ee010 Child shared pool            
Rcache bject=7000002eee5bf08,                              
Latch 7000003a26dbe08 Child row cache objects      
Rcache bject=7000002fd1de590,                              
LOCK: handle=7000002f39aa250 TABL:NC50.TEMQ_70387038134A66EA490
Rcache bject=70000021f9f0a70,                              

573586 Lines Processed.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-714887/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-714887/