Home » RDBMS Server » Server Administration » slave TJ process wait
slave TJ process wait [message #257637] Wed, 08 August 2007 19:09 Go to next message
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

Re: slave TJ process wait [message #257659 is a reply to message #257637] Wed, 08 August 2007 23:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORACLE: 9204,no archive,no standby


Waiting for archive but not getting.
Re: slave TJ process wait [message #257663 is a reply to message #257637] Wed, 08 August 2007 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Waiting for archive but not getting.
Please substantiate with URL & documentation
Re: slave TJ process wait [message #257664 is a reply to message #257637] Wed, 08 August 2007 23:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I am writing here. Somebody told me you don't have eye. If you have give me the proof.
Re: slave TJ process wait [message #257799 is a reply to message #257637] Thu, 09 August 2007 03:25 Go to previous message
alantany
Messages: 115
Registered: July 2007
Senior Member
Hi!Arju,
Could you tell me where you get it ?
Thanks
Alan
Previous Topic: Extract Messages from??
Next Topic: login
Goto Forum:
  


Current Time: Mon Dec 02 09:43:17 CST 2024