Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7

Re: Poor Performance on Oracle9i - 9.2.0.7

From: eavanzi <eavanzi_at_romi.com.br>
Date: 10 May 2006 05:47:52 -0700
Message-ID: <1147265272.544107.118850@y43g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US