Третий день сравниваю загрузку дисков на двух "проблемных" серверах с САПом, с параметрами на других машинах.
Глаз ничего не режет...
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
3931085752 IZD 1 08-May-08 00:02 10.2.0.2.0 NO
Host Name: p550 Num CPUs: 8 Phys Memory (MB): 15,936
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 99 08-May-08 12:43:54 43 69.6
End Snap: 100 08-May-08 15:03:13 41 78.7
Elapsed: 139.32 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 1,552M 1,536M Std Block Size: 8K
Shared Pool Size: 400M 416M Log Buffer: 13,924K
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 9,115.64 18,589.32
Logical reads: 446.94 911.44
Block changes: 30.36 61.90
Physical reads: 6.59 13.44
Physical writes: 3.20 6.52
User calls: 40.71 83.02
Parses: 6.40 13.05
Hard parses: 0.24 0.48
Sorts: 2.10 4.29
Logons: 0.04 0.08
Executes: 44.60 90.96
Transactions: 0.49
% Blocks changed per Read: 6.79 Recursive Call %: 69.10
Rollback per transaction %: 2.37 Rows per Sort: 25.03
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 99.99
Buffer Hit %: 98.53 In-memory Sort %: 100.00
Library Hit %: 98.15 Soft Parse %: 96.28
Execute to Parse %: 85.65 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 5.84 % Non-Parse CPU: 97.24
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 86.76 85.29
% SQL with executions>1: 80.72 84.02
% Memory for SQL w/exec>1: 76.31 83.33
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
db file sequential read 50,574 390 8 37.4
log file parallel write 6,664 158 24 15.2
log file sync 5,503 131 24 12.6
CPU time 128 12.3
db file parallel write 3,591 71 20 6.8
-------------------------------------------------------------
Host CPU (CPUs:
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
0.00 0.00 2.64 1.33 96.04 5.89 4.37
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 0.40
% of busy CPU for Instance: 10.20
%DB time waiting for CPU - Resource Mgr:
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 15,936.0 15,936.0
SGA use (MB): 2,000.0 2,000.0
PGA use (MB): 142.0 150.7
% Host Mem used for SGA+PGA: 13.4 13.5
-------------------------------------------------------------
Time Model System Stats DB/Inst: IZD/IZD Snaps: 99-100
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
sql execute elapsed time 883.0 76.6
DB CPU 246.1 21.3
parse time elapsed 111.4 9.7
hard parse elapsed time 54.9 4.8
PL/SQL execution elapsed time 15.3 1.3
connection management call elapsed 0.3 .0
repeated bind elapsed time 0.1 .0
hard parse (bind mismatch) elapsed 0.1 .0
hard parse (sharing criteria) elaps 0.1 .0
PL/SQL compilation elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
DB time 1,152.7
background elapsed time 536.4
background cpu time 24.6
-------------------------------------------------------------
Wait Events DB/Inst: IZD/IZD Snaps: 99-100
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
db file sequential read 50,574 0 390 8 12.3
log file parallel write 6,664 0 158 24 1.6
log file sync 5,503 0 131 24 1.3
db file parallel write 3,591 0 71 20 0.9
control file parallel write 3,167 0 50 16 0.8
control file sequential read 11,139 0 41 4 2.7
os thread startup 167 15 31 187 0.0
latch: shared pool 55 0 10 189 0.0
log file sequential read 100 0 4 43 0.0
log file switch completion 7 0 4 529 0.0
latch: checkpoint queue latch 12 0 3 271 0.0
db file scattered read 519 0 3 6 0.1
latch: library cache 29 0 3 94 0.0
latch: redo writing 10 0 3 264 0.0
latch free 8 0 2 258 0.0
latch: redo allocation 10 0 2 190 0.0
Log archive I/O 102 0 2 18 0.0
SGA: MMAN sleep for component shr 146 99 1 10 0.0
latch: object queue header operat 6 0 1 206 0.0
SQL*Net more data to client 4,242 0 1 0 1.0
latch: cache buffers chains 8 0 1 99 0.0
read by other session 57 0 0 8 0.0
SQL*Net break/reset to client 6,062 0 0 0 1.5
direct path read 86 0 0 3 0.0
log file single write 8 0 0 8 0.0
direct path write 113 0 0 1 0.0
buffer busy waits 10 0 0 6 0.0
enq: CF - contention 1 0 0 24 0.0
cursor: pin S wait on X 2 100 0 10 0.0
LGWR wait for redo copy 47 0 0 0 0.0
rdbms ipc reply 8 0 0 1 0.0
latch: row cache objects 1 0 0 1 0.0
SQL*Net message from client 337,108 0 135,733 403 82.2
wait for unread message on broadc 8,420 99 8,158 969 2.1
Streams AQ: waiting for messages 1,699 97 8,155 4800 0.4
Streams AQ: qmn slave idle wait 297 0 8,109 27304 0.1
Streams AQ: qmn coordinator idle 608 51 8,109 13338 0.1
Streams AQ: waiting for time mana 230 73 8,045 34978 0.1
jobq slave wait 1,387 100 4,055 2924 0.3
SQL*Net message to client 337,106 0 0 0 82.2
SQL*Net more data from client 457 0 0 0 0.1
-------------------------------------------------------------
Background Wait Events DB/Inst: IZD/IZD Snaps: 99-100
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
log file parallel write 6,665 0 158 24 1.6
db file parallel write 3,591 0 71 20 0.9
control file parallel write 3,167 0 50 16 0.8
os thread startup 167 15 31 187 0.0
control file sequential read 2,650 0 14 5 0.6
events in waitclass Other 83 0 6 77 0.0
log file sequential read 100 0 4 43 0.0
latch: redo writing 10 0 3 264 0.0
Log archive I/O 102 0 2 18 0.0
SGA: MMAN sleep for component shr 146 99 1 10 0.0
db file sequential read 124 0 1 8 0.0
latch: cache buffers chains 3 0 1 255 0.0
latch: shared pool 3 0 1 186 0.0
direct path read 86 0 0 3 0.0
log file single write 8 0 0 8 0.0
direct path write 86 0 0 1 0.0
db file scattered read 45 0 0 1 0.0
rdbms ipc message 32,862 81 88,041 2679 8.0
pmon timer 2,786 100 8,160 2929 0.7
Streams AQ: qmn slave idle wait 297 0 8,109 27304 0.1
Streams AQ: qmn coordinator idle 608 51 8,109 13338 0.1
Streams AQ: waiting for time mana 230 73 8,045 34978 0.1
smon timer 46 22 8,041 ###### 0.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: IZD/IZD Snaps: 99-100
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)
Total ----------------- % of Waits ------------------
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
LGWR wait for redo copy 47 95.7 2.1 2.1
Log archive I/O 102 90.2 9.8
SGA: MMAN sleep for compon 146 .7 97.9 1.4
SQL*Net break/reset to cli 6062 100.0 .0 .0
SQL*Net more data to clien 4242 98.6 .0 .6 .4 .1 .2 .1
buffer busy waits 10 40.0 40.0 10.0 10.0
control file parallel writ 3167 52.3 46.7 1.0
control file sequential re 11K 35.8 6.1 14.0 36.3 7.4 .4 .1
cursor: pin S wait on X 2 100.0
db file parallel read 1 100.0
db file parallel write 3591 1.2 2.5 15.9 23.2 45.1 12.1
db file scattered read 519 26.0 12.5 7.9 30.3 17.7 4.8 .8
db file sequential read 50K 14.4 10.5 12.0 39.4 19.7 3.5 .3 .0
direct path read 86 97.7 2.3
direct path write 113 98.2 .9 .9
direct path write temp 12 100.0
enq: CF - contention 1 100.0
latch free 2 50.0 50.0
latch: cache buffers chain 6 16.7 16.7 16.7 16.7 16.7 16.7
latch: checkpoint queue la 2 100.0
latch: library cache 20 5.0 5.0 15.0 5.0 5.0 25.0 35.0 5.0
latch: object queue header 2 50.0 50.0
latch: redo allocation 4 25.0 25.0 50.0
latch: redo writing 3 66.7 33.3
latch: row cache objects 1 100.0
latch: shared pool 24 8.3 4.2 20.8 4.2 16.7 37.5 8.3
log file parallel write 6664 .0 27.9 56.1 16.0 .0
log file sequential read 100 6.0 4.0 6.0 36.0 48.0
log file single write 8 12.5 37.5 50.0
log file switch completion 7 100.0
log file sync 5503 .1 .0 .1 .5 28.7 52.3 18.2
os thread startup 167 51.5 48.5
rdbms ipc reply 8 87.5 12.5
read by other session 57 7.0 5.3 15.8 28.1 38.6 5.3
SQL*Net message from clien 337K 85.7 5.8 3.2 1.8 1.0 .5 .6 1.4
SQL*Net message to client 337K 100.0
SQL*Net more data from cli 457 98.9 .2 .2 .7
Streams AQ: qmn coordinato 608 48.8 51.2
Streams AQ: qmn slave idle 297 100.0
Streams AQ: waiting for me 1699 .7 99.3
Streams AQ: waiting for ti 230 8.3 22.6 69.1
class slave wait 6 100.0
jobq slave wait 1387 .1 99.9
pmon timer 2786 100.0
rdbms ipc message 32K 8.0 .6 1.6 .4 .7 .8 31.0 56.9
smon timer 46 2.2 2.2 17.4 78.3
wait for unread message on 8420 .0 100.0
-------------------------------------------------------------
SQL ordered by CPU DB/Inst: IZD/IZD Snaps: 99-100
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 246
-> Captured SQL accounts for 96.9% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
60.12 138 0.44 24.4 140.84 668,257 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
48.30 15 3.22 19.6 57.01 466,111 2087989796
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
18.03 196 0.09 7.3 30.31 493,942 4158275320
Module: SAPLSMNU_NEW
SELECT T_00 . "TREE_ID" , T_00 . "NODE_ID" , T_00 . "TEXT" FROM
"TMENU01T" T_00 INNER JOIN "TMENU01R" T_01 ON T_00 . "NODE_ID" =
T_01 . "NODE_ID" WHERE T_00 . "TREE_ID" IN ( :A0 , :A1 , :A2 ,
:A3 , :A4 ) AND T_01 . "REF_OBJECT" LIKE :A5
12.23 13,245 0.00 5.0 60.63 59,261 3334758742
Module: R3trans@p550 (TNS V1-V3)
SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TAB
NAME = :A0 ORDER BY TABNAME, BLOCKNR
9.74 15 0.65 4.0 33.11 162,457 3112898339
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_1HOUR WHERE ROWID = :B1
3.21 3,336 0.00 1.3 18.85 12,520 3632680807
Module: R3trans@p550 (TNS V1-V3)
SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT
, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFORM, REF
NAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COM
PCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0
3.12 1 3.12 1.3 7.87 5,939 2522684317
Module: sqlplus@p550 (TNS V1-V3)
BEGIN statspack.snap; END;
2.72 4,989 0.00 1.1 4.55 29,934 1396250429
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
2.64 4,869 0.00 1.1 7.58 15,421 1736253483
Module: dw.sapIZD_DVEBMGS02@p550 (TNS V1-V3)
SELECT "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SD
AT" , "STIME" , "MINOR_VERS" , "MAJOR_VERS" FROM "REPOLOAD" WHER
E "PROGNAME" = :A0 AND "R3STATE" = :A1 AND "MACH" = :A2
2.57 935 0.00 1.0 5.30 8,489 3694268570
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i
.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.
SQL ordered by CPU DB/Inst: IZD/IZD Snaps: 99-100
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 246
-> Captured SQL accounts for 96.9% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samp
lesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mo
d(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
-------------------------------------------------------------
SQL ordered by Elapsed DB/Inst: IZD/IZD Snaps: 99-100
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 1,153
-> Captured SQL accounts for 69.2% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
140.84 138 1.02 12.2 60.12 34 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
60.63 13,245 0.00 5.3 12.23 4,170 3334758742
Module: R3trans@p550 (TNS V1-V3)
SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TAB
NAME = :A0 ORDER BY TABNAME, BLOCKNR
57.01 15 3.80 4.9 48.30 1 2087989796
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
33.11 15 2.21 2.9 9.74 2 3112898339
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_1HOUR WHERE ROWID = :B1
30.31 196 0.15 2.6 18.03 4,640 4158275320
Module: SAPLSMNU_NEW
SELECT T_00 . "TREE_ID" , T_00 . "NODE_ID" , T_00 . "TEXT" FROM
"TMENU01T" T_00 INNER JOIN "TMENU01R" T_01 ON T_00 . "NODE_ID" =
T_01 . "NODE_ID" WHERE T_00 . "TREE_ID" IN ( :A0 , :A1 , :A2 ,
:A3 , :A4 ) AND T_01 . "REF_OBJECT" LIKE :A5
27.89 105 0.27 2.4 0.79 3,380 1411716045
Module: SAPLSDBORA3
INSERT INTO "D010TAB" ( "MASTER" , "TABNAME" ) VALUES ( :A0 , :A
1 )
18.85 3,336 0.01 1.6 3.21 651 3632680807
Module: R3trans@p550 (TNS V1-V3)
SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT
, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFORM, REF
NAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COM
PCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: IZD/IZD Snaps: 99-100
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 3,735,978
-> Captured SQL accounts for 90.9% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
668,257 138 4,842.4 17.9 60.12 140.84 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
493,942 196 2,520.1 13.2 18.03 30.31 4158275320
Module: SAPLSMNU_NEW
SELECT T_00 . "TREE_ID" , T_00 . "NODE_ID" , T_00 . "TEXT" FROM
"TMENU01T" T_00 INNER JOIN "TMENU01R" T_01 ON T_00 . "NODE_ID" =
T_01 . "NODE_ID" WHERE T_00 . "TREE_ID" IN ( :A0 , :A1 , :A2 ,
:A3 , :A4 ) AND T_01 . "REF_OBJECT" LIKE :A5
466,111 15 31,074.1 12.5 48.30 57.01 2087989796
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_RAW WHERE ROWID = :B1
203,370 2 101,685.0 5.4 0.92 8.07 623913478
select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t
.flags, 268435456), 268435456, t.initrans, t.pctfree$) from s
ys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag,
1048576) = 1048576) and o.obj#=t.obj# and o.owner# =
u.user#
162,457 15 10,830.5 4.3 9.74 33.11 3112898339
Module: Oracle Enterprise Manager.rollup
DELETE FROM MGMT_METRICS_1HOUR WHERE ROWID = :B1
151,974 7,579 20.1 4.1 1.49 2.77 1337134973
Module: RADBTDDF
SELECT * FROM "DD04L" WHERE "ROLLNAME" IN ( :A0 , :A1 , :A2 , :A
3 , :A4 ) AND "AS4LOCAL" = :A5
102,722 5,111 20.1 2.7 1.07 2.08 1662467684
Module: RADBTDDF
SELECT * FROM "DD04T" WHERE "ROLLNAME" IN ( :A0 , :A1 , :A2 , :A
3 , :A4 ) AND "DDLANGUAGE" = :A5 AND "AS4LOCAL" = :A6
79,722 5,313 15.0 2.1 0.84 1.19 3376212751
Module: RADBTDDF
SELECT * FROM "DD01L" WHERE "DOMNAME" IN ( :A0 , :A1 , :A2 , :A3
, :A4 ) AND "AS4LOCAL" = :A5
72,463 7,141 10.1 1.9 0.54 0.54 2946269470
Module: SAPLSHI25
SELECT * FROM "TTREE_SFW_NODES" WHERE "TREE_ID" = :A0 AND "NODE_
ID" = :A1 OR "TREE_ID" = :A2 AND "NODE_ID" = :A3 OR "TREE_ID" =
:A4 AND "NODE_ID" = :A5 OR "TREE_ID" = :A6 AND "NODE_ID" = :A7 O
R "TREE_ID" = :A8 AND "NODE_ID" = :A9
SQL ordered by Gets DB/Inst: IZD/IZD Snaps: 99-100
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 3,735,978
-> Captured SQL accounts for 90.9% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
68,204 13,641 5.0 1.8 1.56 2.13 2482976222
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where c
on#=:1
59,261 13,245 4.5 1.6 12.23 60.63 3334758742
Module: R3trans@p550 (TNS V1-V3)
SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TAB
NAME = :A0 ORDER BY TABNAME, BLOCKNR
47,764 105 454.9 1.3 0.79 27.89 1411716045
Module: SAPLSDBORA3
INSERT INTO "D010TAB" ( "MASTER" , "TABNAME" ) VALUES ( :A0 , :A
1 )
45,066 11,670 3.9 1.2 2.19 7.68 978338524
Module: SAPLHTTP_RUNTIME
SELECT "SQLX" , "EDTX" , "DBNA" , "CLAS" , "TYPE" , "OCCURS" , "
SUBC" , "APPL" , "SECU" , "CNAM" , "CDAT" , "VERN" , "LEVL" , "R
STAT" , "RMAND" , "RLOAD" , "UNAM" , "UDAT" , "UTIME" , "DATALG"
, "VARCL" , "DBAPL" , "FIXPT" , "SSET" , "SDATE" , "STIME" , "I
DATE" , "ITIME" , "LDBNAME" , "UCCHECK" , "MAXLINELN" FROM "REPO
39,752 9,800 4.1 1.1 2.35 6.50 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: IZD/IZD Snaps: 99-100
-> End Disk Reads Threshold: 1000 Total Disk Reads: 55,095
-> Captured SQL accounts for 60.6% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
4,640 196 23.7 8.4 18.03 30.31 4158275320
Module: SAPLSMNU_NEW
SELECT T_00 . "TREE_ID" , T_00 . "NODE_ID" , T_00 . "TEXT" FROM
"TMENU01T" T_00 INNER JOIN "TMENU01R" T_01 ON T_00 . "NODE_ID" =
T_01 . "NODE_ID" WHERE T_00 . "TREE_ID" IN ( :A0 , :A1 , :A2 ,
:A3 , :A4 ) AND T_01 . "REF_OBJECT" LIKE :A5
4,170 13,245 0.3 7.6 12.23 60.63 3334758742
Module: R3trans@p550 (TNS V1-V3)
SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TAB
NAME = :A0 ORDER BY TABNAME, BLOCKNR
3,380 105 32.2 6.1 0.79 27.89 1411716045
Module: SAPLSDBORA3
INSERT INTO "D010TAB" ( "MASTER" , "TABNAME" ) VALUES ( :A0 , :A
1 )
1,976 1,495 1.3 3.6 1.59 6.85 493616777
Module: SAPLSMNU_NEW
SELECT * FROM "TMENU01" WHERE "REFTREE_ID" <> :A0 AND "TREE_ID"
= :A1
1,375 1 1,375.0 2.5 0.16 6.10 2824034135
Module: SAPLSEWB
SELECT * FROM "TADIR" WHERE "PGMID" = :A0 AND "DEVCLASS" = :A1 A
ND NOT "OBJECT" IN ( :A2 , :A3 ) AND ( "DELFLAG" = :A4 OR "DELFL
AG" IS NULL ) ORDER BY "PGMID" , "OBJECT" , "OBJ_NAME"
912 308 3.0 1.7 0.50 6.87 1771578289
Module: SAPLSEWB_CONTROL
SELECT * FROM "DD04T" WHERE "ROLLNAME" IN ( :A0 , :A1 , :A2 , :A
3 , :A4 ) AND "DDLANGUAGE" = :A5
818 1,112 0.7 1.5 1.35 8.03 2663463207
Module: RSBTCRTE
SELECT * FROM "DDFTX" WHERE "TABNAME" = :A0 ORDER BY "TABNAME" ,
"FIELDNAME" , "DDLANGUAGE"
744 90 8.3 1.4 0.27 5.57 764535959
Module: SAPLSDBORA3
INSERT INTO "D010INC" ( "MASTER" , "INCLUDE" ) VALUES ( :A0 , :A
1 )
651 3,336 0.2 1.2 3.21 18.85 3632680807
Module: R3trans@p550 (TNS V1-V3)
SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT
, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFORM, REF
NAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COM
PCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0
600 160 3.8 1.1 0.49 3.48 2043958268
Module: SAPMSSY0
SQL ordered by Reads DB/Inst: IZD/IZD Snaps: 99-100
-> End Disk Reads Threshold: 1000 Total Disk Reads: 55,095
-> Captured SQL accounts for 60.6% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
SELECT * FROM "D345T" WHERE "PROGNAME" = :A0 AND "SPRACHE" = :A1
AND "TYPE" = :A2 AND "BLOCKNR" >= :A3 ORDER BY "PROGNAME" , "SP
RACHE" , "TYPE" , "BLOCKNR"
556 935 0.6 1.0 2.57 5.30 3694268570
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i
.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.
distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samp
lesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mo
d(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: IZD/IZD Snaps: 99-100
-> End Executions Threshold: 100 Total Executions: 372,845
-> Captured SQL accounts for 95.3% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
14,416 14,416 1.0 0.00 0.00 1319699032
Module: dw.sapIZD_DVEBMGS02@p550 (TNS V1-V3)
BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
13,641 13,641 1.0 0.00 0.00 2482976222
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where c
on#=:1
13,245 13,500 1.0 0.00 0.00 3334758742
Module: R3trans@p550 (TNS V1-V3)
SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TAB
NAME = :A0 ORDER BY TABNAME, BLOCKNR
11,670 9,425 0.8 0.00 0.00 978338524
Module: SAPLHTTP_RUNTIME
SELECT "SQLX" , "EDTX" , "DBNA" , "CLAS" , "TYPE" , "OCCURS" , "
SUBC" , "APPL" , "SECU" , "CNAM" , "CDAT" , "VERN" , "LEVL" , "R
STAT" , "RMAND" , "RLOAD" , "UNAM" , "UDAT" , "UTIME" , "DATALG"
, "VARCL" , "DBAPL" , "FIXPT" , "SSET" , "SDATE" , "STIME" , "I
DATE" , "ITIME" , "LDBNAME" , "UCCHECK" , "MAXLINELN" FROM "REPO
10,977 0 0.0 0.00 0.00 1794456341
Module: SAPLSEWB_CONTROL
SELECT * FROM "TRDIRTI" WHERE "NAME" = :A0 AND "SPRSL" = :A1
10,102 3,011 0.3 0.00 0.00 2174471464
Module: dw.sapIZD_DVEBMGS02@p550 (TNS V1-V3)
SELECT * FROM "TRDIRT" WHERE "NAME" = :A0 AND "SPRSL" = :A1
9,800 9,784 1.0 0.00 0.00 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
7,579 37,895 5.0 0.00 0.00 1337134973
Module: RADBTDDF
SELECT * FROM "DD04L" WHERE "ROLLNAME" IN ( :A0 , :A1 , :A2 , :A
3 , :A4 ) AND "AS4LOCAL" = :A5
7,141 1,179 0.2 0.00 0.00 2946269470
Module: SAPLSHI25
SELECT * FROM "TTREE_SFW_NODES" WHERE "TREE_ID" = :A0 AND "NODE_
ID" = :A1 OR "TREE_ID" = :A2 AND "NODE_ID" = :A3 OR "TREE_ID" =
:A4 AND "NODE_ID" = :A5 OR "TREE_ID" = :A6 AND "NODE_ID" = :A7 O
R "TREE_ID" = :A8 AND "NODE_ID" = :A9
6,282 6,267 1.0 0.00 0.00 877399156
Module: SAPMHTTP
SELECT * FROM "TFDIR" WHERE "FUNCNAME" = :A0
5,710 0 0.0 0.00 0.00 376548294
SQL ordered by Executions DB/Inst: IZD/IZD Snaps: 99-100
-> End Executions Threshold: 100 Total Executions: 372,845
-> Captured SQL accounts for 95.3% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
Module: CL_PROXY_WB_TOOL==============CP
SELECT "OBJECT" , "OBJ_NAME" , "CATEGORY" , "IFR_NAME" , "DIRECT
ION" , "IFR_NSPCE" , "IFR_GNSPCE" , "SYNCHRON" , "GEN_APPL" , "I
FR_GLOBAL" , "OBJECT_M" , "OBJ_NAME_M" FROM "SPROXHDR" WHERE "OB
J_NAME" = :A0
5,678 1,846 0.3 0.00 0.00 1649466891
Module: SAPLSDBI_DYNSQL
SELECT "TABNAME" , "VARKEY" , "DATALN" , "VARDATA" FROM "ATAB" W
HERE "TABNAME" = :A0 AND "VARKEY" = :A1 ORDER BY "TABNAME" , "VA
RKEY"
5,617 5,617 1.0 0.00 0.00 3351778219
Module: SAPLSEWB
SELECT "DATA" FROM "REPOSRC" WHERE "PROGNAME" = :A0 AND "R3STATE
" = :A1
5,372 2,599 0.5 0.00 0.00 2993721231
Module: SAPLMESS
SELECT "TABNAME" , "VARKEY" , "DATALN" , "VARDATA" FROM "ATAB" W
HERE "TABNAME" = :A0 AND "VARKEY" BETWEEN :A1 AND :A2 ORDER BY "
TABNAME" , "VARKEY"
5,313 26,565 5.0 0.00 0.00 3376212751
Module: RADBTDDF
SELECT * FROM "DD01L" WHERE "DOMNAME" IN ( :A0 , :A1 , :A2 , :A3
, :A4 ) AND "AS4LOCAL" = :A5
5,127 5,127 1.0 0.00 0.00 1667689875
Module: EM_PING
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
5,111 25,379 5.0 0.00 0.00 1662467684
Module: RADBTDDF
SELECT * FROM "DD04T" WHERE "ROLLNAME" IN ( :A0 , :A1 , :A2 , :A
3 , :A4 ) AND "DDLANGUAGE" = :A5 AND "AS4LOCAL" = :A6
4,989 4,989 1.0 0.00 0.00 1396250429
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
4,989 0 0.0 0.00 0.00 2360644236
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITER
ATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FR
OM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AN
D STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B
2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=
4,869 4,649 1.0 0.00 0.00 1736253483
Module: dw.sapIZD_DVEBMGS02@p550 (TNS V1-V3)
SELECT "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SD
SQL ordered by Executions DB/Inst: IZD/IZD Snaps: 99-100
-> End Executions Threshold: 100 Total Executions: 372,845
-> Captured SQL accounts for 95.3% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
AT" , "STIME" , "MINOR_VERS" , "MAJOR_VERS" FROM "REPOLOAD" WHER
E "PROGNAME" = :A0 AND "R3STATE" = :A1 AND "MACH" = :A2
4,454 4,439 1.0 0.00 0.00 818670798
Module: RSDBPRRM
SELECT * FROM "DD02L" WHERE "TABNAME" = :A0 AND "AS4LOCAL" = :A1
3,881 3,881 1.0 0.00 0.00 4082754702
Module: dw.sapIZD_DVEBMGS02@p550 (TNS V1-V3)
SELECT "LDATA" FROM "REPOLOAD" WHERE "PROGNAME" = :A0 AND "R3STA
TE" = :A1 AND "MACH" = :A2
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: IZD/IZD Snaps: 99-100
-> End Parse Calls Threshold: 1000 Total Parse Calls: 53,509
-> Captured SQL accounts for 83.2% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
2,319 2,319 4.33 2603645655
select /*+ rule */c.name, u.name from con$ c, cdef$ cd, user$ u
where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.use
r#
2,246 2,246 4.20 1348827743
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
VL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2
and block#=:3
2,222 2,222 4.15 2458412332
select o.name, u.name from obj$ o, user$ u where o.obj# = :1 an
d o.owner# = u.user#
1,316 1,316 2.46 3080526718
Module: SAPLSALU
INSERT INTO "ALCLASTOOL" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :
A5 , :A6 , :A7 )
1,196 45 2.24 260339297
insert into sys.col_usage$ values (
bjn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
1,196 1,196 2.24 2554034351
lock table sys.col_usage$ in exclusive mode nowait
1,196 3,340 2.24 3665763022
update sys.col_usage$ set equality_preds = equality_preds
+ decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi
n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre
ds = range_preds + decode(bitand(:flag,8),0,0,1),
1,054 1,054 1.97 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# =
bjn
1,054 1,054 1.97 2396279102
lock table sys.mon_mods$ in exclusive mode nowait
932 977 1.74 839312984
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decod
e(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180
,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedsto
rage,nvl(deflength,0),default$,rowid,col#,property, nvl(charseti
d,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$ wh
SQL ordered by Parse Calls DB/Inst: IZD/IZD Snaps: 99-100
-> End Parse Calls Threshold: 1000 Total Parse Calls: 53,509
-> Captured SQL accounts for 83.2% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
926 959 1.73 204386021
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) fro
m objauth$ where obj#=:1 and col# is not null group by privilege
#, col#, grantee# order by col#, grantee#
926 959 1.73 1937775682
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,n
vl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from c
def$ where obj#=:1
926 959 1.73 1980305124
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)
)from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(co
l#,0) order by grantee#
926 959 1.73 2065408759
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where rob
j#=:1
910 1,302 1.70 2889900621
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#
=:1
910 935 1.70 3694268570
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i
.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.
distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samp
lesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mo
d(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(
906 13,641 1.69 2482976222
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where c
on#=:1
837 9,800 1.56 4274598960
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2
769 860 1.44 2703824309
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$,
spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespa
ce=:3 and remoteowner is null and linkname is null and subname i
s null
722 772 1.35 1206412919
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
588 598 1.10 3047156589
SQL ordered by Parse Calls DB/Inst: IZD/IZD Snaps: 99-100
-> End Parse Calls Threshold: 1000 Total Parse Calls: 53,509
-> Captured SQL accounts for 83.2% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.int
cols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.i
nitrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,
-------------------------------------------------------------
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 12,775 1.5 3.1
CPU used when call started 5,438 0.7 1.3
CR blocks created 386 0.1 0.1
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 0 0.0 0.0
DB time 2,189,895 262.0 534.3
DBWR checkpoint buffers written 26,509 3.2 6.5
DBWR checkpoints 2 0.0 0.0
DBWR transaction table writes 254 0.0 0.1
DBWR undo block writes 4,969 0.6 1.2
IMU CR rollbacks 158 0.0 0.0
IMU Flushes 3,344 0.4 0.8
IMU Redo allocation size 5,654,620 676.5 1,379.5
IMU commits 2,647 0.3 0.7
IMU contention 6 0.0 0.0
IMU ktichg flush 46 0.0 0.0
IMU pool not allocated 2,706 0.3 0.7
IMU recursive-transaction flush 13 0.0 0.0
IMU undo allocation size 21,315,120 2,550.0 5,200.1
IMU- failed to get a private stra 2,706 0.3 0.7
SMON posted for undo segment shri 3 0.0 0.0
SQL*Net roundtrips to/from client 336,959 40.3 82.2
active txn count during cleanout 1,043 0.1 0.3
application wait time 40 0.0 0.0
background checkpoints completed 2 0.0 0.0
background checkpoints started 2 0.0 0.0
background timeouts 26,825 3.2 6.5
branch node splits 2 0.0 0.0
buffer is not pinned count 1,375,797 164.6 335.6
buffer is pinned count 2,723,627 325.8 664.5
bytes received via SQL*Net from c 85,402,792 10,216.9 20,835.0
bytes sent via SQL*Net to client 493,414,713 59,028.0 120,374.4
calls to get snapshot scn: kcmgss 720,447 86.2 175.8
calls to kcmgas 25,216 3.0 6.2
calls to kcmgcs 1,712 0.2 0.4
change write time 422 0.1 0.1
cleanout - number of ktugct calls 1,316 0.2 0.3
cleanouts and rollbacks - consist 54 0.0 0.0
cleanouts only - consistent read 174 0.0 0.0
cluster key scan block gets 249,874 29.9 61.0
cluster key scans 185,541 22.2 45.3
commit batch performed 7 0.0 0.0
commit batch requested 7 0.0 0.0
commit batch/immediate performed 2,252 0.3 0.6
commit batch/immediate requested 2,252 0.3 0.6
commit cleanout failures: block l 28 0.0 0.0
commit cleanout failures: callbac 120 0.0 0.0
commit cleanout failures: cannot 2 0.0 0.0
commit cleanouts 38,864 4.7 9.5
commit cleanouts successfully com 38,714 4.6 9.4
commit immediate performed 2,245 0.3 0.6
commit immediate requested 2,245 0.3 0.6
commit txn count during cleanout 904 0.1 0.2
concurrency wait time 4,523 0.5 1.1
consistent changes 849 0.1 0.2
consistent gets 3,465,915 414.6 845.6
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
consistent gets - examination 846,709 101.3 206.6
consistent gets direct 10 0.0 0.0
consistent gets from cache 3,465,905 414.6 845.6
cursor authentications 935 0.1 0.2
data blocks consistent reads - un 428 0.1 0.1
db block changes 253,738 30.4 61.9
db block gets 270,063 32.3 65.9
db block gets direct 14 0.0 0.0
db block gets from cache 270,049 32.3 65.9
deferred (CURRENT) block cleanout 18,109 2.2 4.4
dirty buffers inspected 20 0.0 0.0
enqueue conversions 1,724 0.2 0.4
enqueue releases 104,925 12.6 25.6
enqueue requests 104,925 12.6 25.6
enqueue timeouts 0 0.0 0.0
enqueue waits 1 0.0 0.0
execute count 372,845 44.6 91.0
failed probes on index block recl 0 0.0 0.0
free buffer inspected 65,748 7.9 16.0
free buffer requested 69,443 8.3 16.9
heap block compress 1,010 0.1 0.3
hot buffers moved to head of LRU 48,143 5.8 11.8
immediate (CR) block cleanout app 228 0.0 0.1
immediate (CURRENT) block cleanou 7,461 0.9 1.8
index fast full scans (full) 2,034 0.2 0.5
index fetch by key 195,954 23.4 47.8
index scans kdiixs1 417,510 50.0 101.9
leaf node 90-10 splits 36 0.0 0.0
leaf node splits 476 0.1 0.1
lob reads 10,409 1.3 2.5
lob writes 2,122 0.3 0.5
lob writes unaligned 1,511 0.2 0.4
logons cumulative 334 0.0 0.1
messages received 10,060 1.2 2.5
messages sent 10,060 1.2 2.5
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 2,151,608 257.4 524.9
opened cursors cumulative 56,461 6.8 13.8
parse count (failures) 0 0.0 0.0
parse count (hard) 1,988 0.2 0.5
parse count (total) 53,509 6.4 13.1
parse time cpu 353 0.0 0.1
parse time elapsed 6,045 0.7 1.5
physical read IO requests 50,676 6.1 12.4
physical read bytes 451,338,240 53,994.3 110,109.4
physical read total IO requests 62,439 7.5 15.2
physical read total bytes 724,976,128 86,730.0 176,866.6
physical read total multi block r 607 0.1 0.2
physical reads 55,095 6.6 13.4
physical reads cache 54,999 6.6 13.4
physical reads cache prefetch 4,420 0.5 1.1
physical reads direct 96 0.0 0.0
physical reads direct (lob) 0 0.0 0.0
physical reads direct temporary t 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 17,205 2.1 4.2
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
physical write bytes 218,873,856 26,184.2 53,396.9
physical write total IO requests 40,198 4.8 9.8
physical write total bytes 623,157,760 74,549.3 152,026.8
physical write total multi block 15,274 1.8 3.7
physical writes 26,718 3.2 6.5
physical writes direct 100 0.0 0.0
physical writes direct (lob) 10 0.0 0.0
physical writes direct temporary 4 0.0 0.0
physical writes from cache 26,618 3.2 6.5
physical writes non checkpoint 14,878 1.8 3.6
prefetch clients - default 1 0.0 0.0
prefetch warmup blocks aged out b 0 0.0 0.0
prefetched blocks aged out before 1,032 0.1 0.3
recursive calls 761,025 91.0 185.7
recursive cpu usage 8,033 1.0 2.0
redo blocks written 157,916 18.9 38.5
redo buffer allocation retries 7 0.0 0.0
redo entries 119,587 14.3 29.2
redo log space requests 7 0.0 0.0
redo log space wait time 379 0.1 0.1
redo ordering marks 5,829 0.7 1.4
redo size 76,197,608 9,115.6 18,589.3
redo synch time 13,461 1.6 3.3
redo synch writes 14,117 1.7 3.4
redo wastage 1,756,292 210.1 428.5
redo write time 16,255 1.9 4.0
redo writer latching time 0 0.0 0.0
redo writes 6,665 0.8 1.6
rollback changes - undo records a 4,672 0.6 1.1
rollbacks only - consistent read 316 0.0 0.1
rows fetched via callback 104,991 12.6 25.6
session connect time 0 0.0 0.0
session cursor cache hits 39,918 4.8 9.7
session logical reads 3,735,978 446.9 911.4
session pga memory 201,597,944 24,117.5 49,182.2
session pga memory max 217,981,944 26,077.5 53,179.3
session uga memory 597,007,264,104 71,420,895.3 ############
session uga memory max 234,920,760 28,103.9 57,311.7
shared hash latch upgrades - no w 407,172 48.7 99.3
shared hash latch upgrades - wait 11 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 17,568 2.1 4.3
sorts (rows) 439,675 52.6 107.3
sql area evicted 481 0.1 0.1
sql area purged 0 0.0 0.0
summed dirty queue length 20 0.0 0.0
switch current to new buffer 6,994 0.8 1.7
table fetch by rowid 1,773,957 212.2 432.8
table fetch continued row 6,273 0.8 1.5
table scan blocks gotten 113,639 13.6 27.7
table scan rows gotten 6,635,720 793.8 1,618.9
table scans (long tables) 0 0.0 0.0
table scans (short tables) 10,363 1.2 2.5
total number of times SMON posted 36 0.0 0.0
transaction rollbacks 2,252 0.3 0.6
undo change vector size 19,923,756 2,383.5 4,860.6
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
user I/O wait time 39,342 4.7 9.6
user calls 340,302 40.7 83.0
user commits 4,002 0.5 1.0
user rollbacks 97 0.0 0.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 6,133 0.7 1.5
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
--------------------------------- --------------- ---------------
logons current 43 41
opened cursors current 2,992 3,225
session cursor cache count 16,027 18,661
-------------------------------------------------------------
Instance Activity Stats DB/Inst: IZD/IZD Snaps: 99-100
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
--------------------------------- ------------------ ---------
log switches (derived) 2 .86
-------------------------------------------------------------
OS Statistics DB/Inst: IZD/IZD Snaps: 99-100
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name
Statistic Total
------------------------- ----------------------
BUSY_TIME 265,366
IDLE_TIME 6,429,164
IOWAIT_TIME 394,473
SYS_TIME 88,925
USER_TIME 176,441
LOAD 0
OS_CPU_WAIT_TIME 292,700
PHYSICAL_MEMORY_BYTES 16,710,107,136
NUM_CPUS 8
NUM_CPU_CORES 4
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: IZD/IZD Snaps: 99-100
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PSAPSR3700
28,439 3 7.8 1.0 9,921 1 12 5.8
PSAPSR3
20,221 2 7.7 1.2 3,328 0 45 8.0
SYSAUX
330 0 14.8 1.0 2,433 0 8 3.8
SYSTEM
1,596 0 7.5 1.1 661 0 0 0.0
PSAPUNDO
3 0 13.3 1.0 658 0 2 5.0
PSAPSR3USR
41 0 7.8 1.0 192 0 0 0.0
PSAPSR3DB
30 0 32.3 1.0 6 0 0 0.0
PSAPTEMP
4 0 5.0 1.0 6 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: IZD/IZD Snaps: 99-100
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Mx Av
Av Rd Rd Av Av Buffer BufWt
Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Waits (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
PSAPSR3 /oracle/IZD/sapdata1/sr3_1/sr3.data1
885 0 6.7 64 1.2 80 0 0
/oracle/IZD/sapdata1/sr3_2/sr3.data2
1,682 0 6.7 ### 1.2 114 0 6 13.3
/oracle/IZD/sapdata1/sr3_3/sr3.data3
1,439 0 7.7 ### 1.2 81 0 4 7.5
/oracle/IZD/sapdata1/sr3_4/sr3.data4
1,475 0 5.6 ### 1.2 106 0 5 6.0
/oracle/IZD/sapdata1/sr3_5/sr3.data5
1,441 0 5.6 ### 1.2 147 0 2 10.0
/oracle/IZD/sapdata2/sr3_10/sr3.data10
999 0 5.6 ### 1.1 200 0 2 0.0
/oracle/IZD/sapdata2/sr3_6/sr3.data6
1,433 0 7.0 ### 1.2 168 0 2 5.0
/oracle/IZD/sapdata2/sr3_7/sr3.data7
1,183 0 5.1 64 1.2 203 0 3 6.7
/oracle/IZD/sapdata2/sr3_8/sr3.data8
1,337 0 8.5 ### 1.1 311 0 1 20.0
/oracle/IZD/sapdata2/sr3_9/sr3.data9
947 0 13.2 ### 1.2 319 0 2 10.0
/oracle/IZD/sapdata3/sr3_11/sr3.data11
1,101 0 6.9 ### 1.1 181 0 5 6.0
/oracle/IZD/sapdata3/sr3_12/sr3.data12
806 0 5.4 64 1.2 152 0 3 6.7
/oracle/IZD/sapdata3/sr3_13/sr3.data13
818 0 5.5 ### 1.3 73 0 2 10.0
/oracle/IZD/sapdata3/sr3_14/sr3.data14
767 0 5.9 ### 1.2 103 0 2 10.0
/oracle/IZD/sapdata3/sr3_15/sr3.data15
563 0 7.9 64 1.1 283 0 0
/oracle/IZD/sapdata4/sr3_16/sr3.data16
700 0 7.0 6
Вход
Регистрация
FAQ пользователя
Поиск
