| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7
Hello, Beko.
The results are:
refresh controlfile command 1
0
buffer deadlock 5
0
recovery read 2
0
BFILE get length 12
0
BFILE internal seek 81
0
BFILE closure 19
0
instance state change 2
0
undo segment extension 2555
1
SQL*Net more data to dblink 68
1
PX Deq: Signal ACK 1
2
checkpoint completed 1
3
kksfbc child completion 2
3
PX Deq: Join ACK 5
4
wait list latch free 5
9
slave TJ process wait 6
10
BFILE open 19
11
log file single write 30
19
BFILE read 245
29
SQL*Net message to dblink 50833
38
reliable message 1
55
row cache lock 234
94
buffer latch 1
98
sort segment request 1
99
db file single write 761
114
LGWR wait for redo copy 6187
264
local write wait 64
309
control file sequential read 12624
322
wait for stopper event to be increased 35
350
control file heartbeat 1
391
inactive session 5
492
HS message to agent 220
496
single-task message 47
549
process startup 48
640
log file switch completion 120
891
rdbms ipc reply 1031
1025
queue messages 4
1956
write complete waits 21
2073
library cache load lock 165
3756
direct path write (lob) 5829
4079
library cache pin 2138
5040
async disk IO 9341
5344
PX Deq: Txn Recovery Start 40
7335
SQL*Net break/reset to client 57835
7587
SQL*Net message to client 10334642
10889
control file parallel write 5401
12832
db file parallel read 4601
14945
direct path read (lob) 40807
15100
SQL*Net more data to client 949685
15454
SQL*Net message from dblink 50833
15702
log file sequential read 4669
22723
direct path read 60661
38085
SQL*Net more data from dblink 180900
55651
buffer busy waits 297238
84929
direct path write 35212
102555
enqueue 1590
130010
latch free 219574
290930
log file parallel write 354903
342771
SQL*Net more data from client 83295
348647
db file parallel write 71990
401167
log file sync 115297
521389
PX Idle Wait 3019
591315
PL/SQL lock timer 415
642077
db file scattered read 3248904
834524
wakeup time manager 436
1182060
smon timer 5619
1206805
pmon timer 4304
1238267
jobq slave wait 14425
3604979
db file sequential read 20479048
4342690
rdbms ipc message 313526
9989699
pipe get 38824
13604893
SQL*Net message from client 10333655
434317043
#########################################################
PL/SQL lock timer 1
SQL*Net message from client 1237
SQL*Net message to client 1
SQL*Net more data from client 1
db file parallel write 1
db file sequential read 7
jobq slave wait 3
pipe get 11
pmon timer 1
rdbms ipc message 8
smon timer 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
wakeup time manager 1
Thank you.
Edson
Received on Wed May 10 2006 - 07:47:52 CDT
![]() |
![]() |