slave TJ process wait [message #257637] |
Wed, 08 August 2007 19:09 |
alantany
Messages: 115 Registered: July 2007
|
Senior Member |
|
|
Hello ,all!
Could someone tell me what's the meaning of 'slave TJ process wait' event?
I can not get it from oracle DOC.
I find it from my statspack ,the db is 9204
OS: LINUX 3.8
ORACLE: 9204,no archive,no standby
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file scattered read 38,411 0 11 0 21.7
db file sequential read 32,281 0 7 0 18.2
control file parallel write 1,172 0 5 5 0.7
log file sync 684 1 3 4 0.4
process startup 107 0 1 10 0.1
latch free 118 79 1 6 0.1
SQL*Net more data to client 16,220 0 0 0 9.2
[COLOR=blue]slave TJ process wait 9 9 0 9 0.0[/COLOR] --here it is
control file sequential read 557 0 0 0 0.3
SQL*Net break/reset to clien 14 0 0 3 0.0
log buffer space 3 0 0 8 0.0
buffer busy waits 29 0 0 0 0.0
log file parallel write 1,115 1,110 0 0 0.6
db file parallel write 77 0 0 0 0.0
direct path read (lob) 51 0 0 0 0.0
LGWR wait for redo copy 4 0 0 0 0.0
undo segment extension 1 1 0 0 0.0
SQL*Net message from client 472,522 0 91,882 194 266.8
jobq slave wait 3,101 2,930 9,071 2925 1.8
SQL*Net message to client 472,499 0 0 0 266.8
SQL*Net more data from clien 52 0 0 0 0.0
Regards!
Alan
[Updated on: Wed, 08 August 2007 19:11] Report message to a moderator
|
|
|
|
|
|
|