STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
SNAB 749366589 snab 1 9.2.0.8.0 NO dc-ora1
Snap Id Snap Time Sessions Curs/Sess Comment
--------- ------------------ -------- --------- -------------------
Begin Snap: 1193 19-Ноя-09 10:30:42 120 163.8
End Snap: 1195 19-Ноя-09 11:00:46 121 158.2
Elapsed: 30.07 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 1,408M Std Block Size: 8K
Shared Pool Size: 1,200M Log Buffer: 1,024K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 341,195.47 5,412.04
Logical reads: 173,728.06 2,755.67
Block changes: 2,431.46 38.57
Physical reads: 3,869.93 61.38
Physical writes: 119.93 1.90
User calls: 24.63 0.39
Parses: 75.16 1.19
Hard parses: 0.25 0.00
Sorts: 4,893.88 77.63
Logons: 0.11 0.00
Executes: 8,505.46 134.91
Transactions: 63.04
% Blocks changed per Read: 1.40 Recursive Call %: 99.76
Rollback per transaction %: 0.04 Rows per Sort: 2.76
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.88 Redo NoWait %: 100.00
Buffer Hit %: 97.84 In-memory Sort %: 100.00
Library Hit %: 99.99 Soft Parse %: 99.66
Execute to Parse %: 99.12 Latch Hit %: 99.94
Parse CPU to Parse Elapsd %: 41.38 % Non-Parse CPU: 99.53
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 93.33 90.76
% SQL with executions>1: 79.38 79.84
% Memory for SQL w/exec>1: 54.94 59.61
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read 3,917,024 4,921 56.00
CPU time 2,122 24.14
PL/SQL lock timer 564 1,063 12.10
buffer busy waits 391,745 406 4.62
log file parallel write 29,686 122 1.38
-------------------------------------------------------------
Wait Events for DB: SNAB Instance: snab Snaps: 1193 -1195
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read 3,917,024 0 4,921 1 34.4
PL/SQL lock timer 564 544 1,063 1885 0.0
buffer busy waits 391,745 0 406 1 3.4
log file parallel write 29,686 0 122 4 0.3
db file scattered read 238,416 0 69 0 2.1
enqueue 125 9 30 240 0.0
log file sync 3,603 0 24 7 0.0
latch free 4,983 1,758 21 4 0.0
log file sequential read 606 0 4 7 0.0
write complete waits 2 2 2 977 0.0
process startup 91 0 1 13 0.0
control file parallel write 637 0 1 2 0.0
log buffer space 17 0 1 38 0.0
control file sequential read 888 0 0 0 0.0
SQL*Net more data to client 12,432 0 0 0 0.1
log file switch completion 7 0 0 39 0.0
direct path read 131,408 0 0 0 1.2
resmgr:waiting in enter 1 1 0 141 0.0
SQL*Net break/reset to clien 106 0 0 1 0.0
LGWR wait for redo copy 273 0 0 0 0.0
direct path write 519 0 0 0 0.0
db file parallel write 4,653 0 0 0 0.0
direct path read (lob) 4,496 0 0 0 0.0
log file single write 4 0 0 4 0.0
async disk IO 1,186 0 0 0 0.0
direct path write (lob) 36 0 0 0 0.0
library cache pin 3 0 0 0 0.0
SQL*Net message from client 32,224 0 93,057 2888 0.3
jobq slave wait 2,803 2,733 8,118 2896 0.0
pipe get 1,589 443 1,769 1113 0.0
SQL*Net more data from clien 1,492 0 0 0 0.0
SQL*Net message to client 32,225 0 0 0 0.3
-------------------------------------------------------------
Background Wait Events for DB: SNAB Instance: snab Snaps: 1193 -1195
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
log file parallel write 29,695 0 122 4 0.3
log file sequential read 606 0 4 7 0.0
db file scattered read 93 0 1 13 0.0
control file parallel write 637 0 1 2 0.0
db file sequential read 265 0 1 4 0.0
control file sequential read 748 0 0 0 0.0
LGWR wait for redo copy 273 0 0 0 0.0
db file parallel write 4,653 0 0 0 0.0
log file single write 4 0 0 4 0.0
async disk IO 1,186 0 0 0 0.0
latch free 7 0 0 0 0.0
direct path read 92 0 0 0 0.0
direct path write 92 0 0 0 0.0
rdbms ipc message 61,601 1,732 10,195 165 0.5
pmon timer 602 600 1,761 2924 0.0
smon timer 3,165 0 1,743 551 0.0
-------------------------------------------------------------
SQL ordered by Gets for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
115,333,557 9 12,814,839.7 36.8 888.64 908.34 386354325
Module: Realiz
SELECT AL.RN FROM AGNLIST AL WHERE PRSF_PROP_SGET(:B3 ,'AGNLIST'
,AL.RN,'КОД КОНТРАГЕНТА R3') = :B2 AND AL.VERSION = :B1
76,915,531 9 8,546,170.1 24.5 595.99 625.27 3779561935
Module: Realiz
BEGIN P_UDO_CLNPERSONS_INSERT(:SPERS_AGENT,:STAB_NUMB,:SFIRST_NA
ME,:SMIDDLE_NAME,:SLAST_NAME,:SPHONE,:SPHONE1,:DBIRH_DATE,:SE_MA
IL,:DJOBBEGIN_DATE,:DDISMISS_DATE,:DLAST_MODIFY_DATE,:NRN); END;
74,542,521 926,835 80.4 23.8 224.20 271.13 659406500
Module: Realiz
SELECT STR_VALUE FROM V_DOCS_PROPS_VALS_SHADOW WHERE DOCS_PROP_R
N = :B3 AND UNITCODE = :B2 AND UNIT_RN = :B1
63,409,631 11 5,764,511.9 20.2 792.19 1317.71 2400299789
Module: Realiz
BEGIN PKG_PDUP.PROLOGUE; PKG_PDUP.PSIO('S#1',:S#1,1); PKG_
PDUP.PNIO('NCOMPANY',:NCOMPANY,1); PKG_PDUP.PDIO('D#1',:D#1,1)
; PKG_PDUP.PBIO('B#1',:B#1,1); PKG_PDUP.PCIO('C#1',:C#1,1);
PKG_PDUP.PSIO('SUNITCODE',:SUNITCODE,1); PKG_PDUP.PNIO('N#2'
,:N#2,1); PKG_PDUP.PDIO('D#2',:D#2,1); PKG_PDUP.PBIO('B#2',:
49,375,715 1 49,375,715.0 15.8 559.60 910.77 3306915318
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN PKG_JOBS.BROKER(6473018157,BROKEN
); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; E
ND IF; END;
38,748,137 75 516,641.8 12.4 303.07 310.26 1202299718
Module: Realiz
BEGIN P_UDO_CLNPERSONS_UPDATE(:SPERS_AGENT,:STAB_NUMB,:SFIRST_NA
ME,:SMIDDLE_NAME,:SLAST_NAME,:SPHONE,:SPHONE1,:DBIRH_DATE,:SE_MA
IL,:DJOBBEGIN_DATE,:DDISMISS_DATE,:DLAST_MODIFY_DATE,:NRN); END;
23,999,863 4,861 4,937.2 7.7 505.78 495.73 3214515009
Module: Realiz
SELECT H.OPER_TYPE,H.END_DATE FROM REPLINHIST H WHERE H.PRN = :B
1 AND H.BEGIN_DATE = ( SELECT MAX(H1.BEGIN_DATE) FROM REPLINHIST
H1 WHERE H1.PRN = :B1 )
14,432,923 3 4,810,974.3 4.6 60.12 64.73 1672555965
Module: EquipSrv
begin PKG_USERREPORTS.PROLOGUE(:iSET_PROCESS_TYPE); PKG_USERREPO
RTS.SET_REPORT_PARAM_STR(:sPARAM_NAME1, :sPARAM_VALUE1); PKG_USE
RREPORTS.SET_REPORT_PARAM_STR(:sPARAM_NAME2, :sPARAM_VALUE2); PK
G_USERREPORTS.SET_REPORT_PARAM_STR(:sPARAM_NAME3, :sPARAM_VALUE3
SQL ordered by Gets for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
); PKG_USERREPORTS.SET_REPORT_PARAM_NUM(:sPARAM_NAME4, :nPARAM_V
14,340,202 3 4,780,067.3 4.6 59.54 62.84 3316943686
Module: EquipSrv
BEGIN PKG_PDUP.PSIO('SIN_RPO',:SIN_RPO,0); PKG_PDUP.PNIO('N#
1',:N#1,0); PKG_PDUP.PDIO('D#1',:D#1,0); PKG_PDUP.PSIO('SIN_
YEAR',:SIN_YEAR,0); PKG_PDUP.PNIO('N#2',:N#2,0); PKG_PDUP.PD
IO('D#2',:D#2,0); PKG_PDUP.PSIO('SIN_SUEK_GROUP',:SIN_SUEK_GRO
UP,0); PKG_PDUP.PNIO('N#3',:N#3,0); PKG_PDUP.PDIO('D#3',:D#3
14,169,185 2,790 5,078.6 4.5 297.00 290.72 565449779
Module: Realiz
SELECT H.OPER_TYPE FROM REPLINHIST H WHERE H.PRN = :B1 AND H.BEG
IN_DATE = ( SELECT MAX(H1.BEGIN_DATE) FROM REPLINHIST H1 WHERE H
1.PRN = :B1 )
13,451,102 2,016 6,672.2 4.3 46.44 47.36 292955776
Module: EquipSrv
SELECT NVL(SUM(NVL(PHS.COASTPLAN*UDO_CMP_TIME_PERIODS(PHS.DATEPL
AN_BEG, PHS.DATEPLAN_END, :B14 , :B13 )/(86400*(PHS.DATEPLAN_END
- PHS.DATEPLAN_BEG)),0)),0) FROM VR_SNAB_MR_PLAN_HEAD PH, EQTCH
SRWRK PHS, AGNLIST AL WHERE UDO_CMP_TIME_PERIODS(PH.DEQTCHSRV_DA
TEPRD_BEG, PH.DEQTCHSRV_DATEPRD_END, :B14 , :B13 ) > 0 AND (PH.S
12,591,670 1 12,591,670.0 4.0 345.20 340.48 302061471
Module: EquipSrv
begin PKG_USERREPORTS.PROLOGUE(:iSET_PROCESS_TYPE); PKG_USERREPO
RTS.SET_REPORT_PARAM_STR(:sPARAM_NAME1, :sPARAM_VALUE1); PKG_USE
RREPORTS.SET_REPORT_PARAM_STR(:sPARAM_NAME2, :sPARAM_VALUE2); PK
G_USERREPORTS.EXEC_REPORT(:nREPORT, :nIDENT); PKG_USERREPORTS.EP
ILOGUE; end;
12,588,842 1 12,588,842.0 4.0 345.18 340.17 156882358
Module: EquipSrv
BEGIN PKG_PDUP.PSIO('SYEAR_DATE',:SYEAR_DATE,0); PKG_PDUP.PN
IO('N#1',:N#1,0); PKG_PDUP.PDIO('D#1',:D#1,0); PKG_PDUP.PSIO
('SCAT',:SCAT,0); PKG_PDUP.PNIO('N#2',:N#2,0); PKG_PDUP.PDIO
('D#2',:D#2,0); /* Begin of user defined block text. */ BEGIN
UDO_P_EQLFLENGTHJRNL_RPT_FACT(:SYEAR_DATE,:SCAT); END; /* End of
12,433,325 442,837 28.1 4.0 29.21 27.95 3783668458
Module: EquipSrv
SELECT COUNT(*) FROM UNAGNGRP AG, UNAGGRSP AGS, AGNLIST AL WHERE
AG.COMPANY = :B3 AND AG.CODE = :B2 AND AG.RN = AGS.PRN AND AGS.
AGENT = AL.RN AND AL.AGNABBR = :B1
10,261,176 90 114,013.1 3.3 184.30 183.26 2938570689
Module: EquipSrv
select * from V_EQCONFIG_EQPARENT_HIER where CRN=:"CRN" and UNI
TCODE=:"UnitCode" and COMPANY=:"Company" and (FICTSIGN = 0 or
SQL ordered by Gets for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
FICTSIGN is null)
9,960,616 384 25,939.1 3.2 273.27 267.38 3464972817
Module: EquipSrv
SELECT SUM(EL.VALUE) FROM EQLFLENGTHJRNL EJ, EQLIFELENGHT EL, EQ
LFLENGTHTYPES ET WHERE EJ.LIFELTH_DOWNTIME = 1 AND EJ.EQCONFIG =
:B6 AND EJ.UMEAS_LIFELTH = :B5 AND (EJ.EQTCHPRCKND = :B4 OR (:B
4 IS NULL AND EJ.EQTCHPRCKND IS NULL)) AND EJ.LIFELENGTH = ET.RN
AND ET.CODE IN ( 'Сутки','Месяц') AND EL.PRN = EJ.RN AND EL.LIF
9,830,562 2,071 4,746.8 3.1 210.39 238.70 1671394665
Module: Realiz
SELECT H.OPER_TYPE,H.SESSION_ID FROM REPLINHIST H WHERE H.PRN =
-------------------------------------------------------------
SQL ordered by Reads for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
1,861,709 11 169,246.3 26.7 792.19 1317.71 2400299789
Module: Realiz
BEGIN PKG_PDUP.PROLOGUE; PKG_PDUP.PSIO('S#1',:S#1,1); PKG_
PDUP.PNIO('NCOMPANY',:NCOMPANY,1); PKG_PDUP.PDIO('D#1',:D#1,1)
; PKG_PDUP.PBIO('B#1',:B#1,1); PKG_PDUP.PCIO('C#1',:C#1,1);
PKG_PDUP.PSIO('SUNITCODE',:SUNITCODE,1); PKG_PDUP.PNIO('N#2'
,:N#2,1); PKG_PDUP.PDIO('D#2',:D#2,1); PKG_PDUP.PBIO('B#2',:
1,725,014 11 156,819.5 24.7 56.86 119.98 1866034479
Module: Realiz
SELECT * FROM TR_SNAB_COMPUTEL_OBJIN T WHERE (T.CURRSTATUS > 0 A
ND T.CURRSTATUS < 5 OR T.CURRSTATUS IS NULL OR T.CURRSTATUS IN (
10,12)) AND (:B1 IS NULL OR T.UNITCODE=:B1 ) ORDER BY RN ASC
1,219,905 6 203,317.5 17.5 34.18 33.61 464436537
Module: OracleAgent.exe
SELECT T.PK,T.INXML,T.RESPXML FROM TR_SNAB_COMPUTEL_OBJIN T WHER
E T.RESPCREATEDATE IS NOT NULL AND T.RESPTRANSFERDATE IS NULL
1,162,937 90 12,921.5 16.7 184.30 183.26 2938570689
Module: EquipSrv
select * from V_EQCONFIG_EQPARENT_HIER where CRN=:"CRN" and UNI
TCODE=:"UnitCode" and COMPANY=:"Company" and (FICTSIGN = 0 or
FICTSIGN is null)
996,692 6 166,115.3 14.3 61.45 153.22 3572252308
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN PKG_JOBS.BROKER(6482935007,BROKEN
); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; E
ND IF; END;
380,425 2 190,212.5 5.4 10.24 10.06 2004304365
Module: SQLNav4.exe
select UNITCODE,CURRSTATUS,count(*) from TR_SNAB_COMPUTEL_OBJIN
T where T.RESPCREATEDATE is null --and (T.UNITCODE is not null a
nd T.UNITCODE='AGNLIST') --and T.INCREATEDATE>=to_date('151008'
,'DDMMYY') group by UNITCODE,CURRSTATUS order by CURRSTATUS,UNIT
CODE
330,897 3 110,299.0 4.7 167.27 251.94 1134889431
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN PKG_JOBS.BROKER(6428949142,BROKEN
); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; E
ND IF; END;
318,125 1 318,125.0 4.6 559.60 910.77 3306915318
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN PKG_JOBS.BROKER(6473018157,BROKEN
); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; E
ND IF; END;
304,876 5 60,975.2 4.4 52.47 80.94 2744041157
Module: EquipSrv
begin PKG_PROC_BROKER.PROLOGUE; PKG_PROC_BROKER.SET_PARAM_NU
SQL ordered by Reads for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
M('NCOMPANY', :NCOMPANY); PKG_PROC_BROKER.SET_PARAM_NUM('NCRN'
, :NCRN); PKG_PROC_BROKER.SET_PARAM_STR('SJUR_PERS', :SJUR_PER
S); PKG_PROC_BROKER.SET_PARAM_STR('SDOCTYPES', :SDOCTYPES);
PKG_PROC_BROKER.SET_PARAM_STR('SPREF', :SPREF); PKG_PROC_BROKE
304,841 5 60,968.2 4.4 52.36 80.56 4155423343
Module: EquipSrv
BEGIN P_EQTCHSRV_INSERT(:NCOMPANY,:NCRN,:SJUR_PERS,:SDOCTYPES,:S
PREF,:SNUMB,:DSTATE_DAT,:DDOCDATE,:SRESP_AGN,:SCURRENCY,:SDEPTTC
SRV,:SPERIOD,:NEQCONFIG,:NEQCONFIG_TECH,:SDEPTRESP,:DDATEPRD_BEG
,:DDATEPRD_END,:SNOTE,:NDUP_RN,:NMOVE_MODE,:NRN); END;
302,311 4 75,577.8 4.3 51.40 68.14 3910822578
Module: EquipSrv
SELECT * FROM EQTCHSRWRK WHERE PRN = :B1 START WITH EQTCHSRWRK I
S NULL CONNECT BY PRIOR RN = EQTCHSRWRK
216,658 1 216,658.0 3.1 5.77 5.97 1117930279
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN PKG_JOBS.BROKER(6473017280,BROKEN
); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; E
ND IF; END;
215,402 9 23,933.6 3.1 888.64 908.34 386354325
Module: Realiz
SELECT AL.RN FROM AGNLIST AL WHERE PRSF_PROP_SGET(:B3 ,'AGNLIST'
,AL.RN,'КОД КОНТРАГЕНТА R3') = :B2 AND AL.VERSION = :B1
202,785 17 11,928.5 2.9 33.58 133.06 538285168
Module: EquipSrv
select * from V_UNITS_ACCESS UA order by UA.NLEVEL, UA.SUNITCODE
199,667 926,835 0.2 2.9 224.20 271.13 659406500
Module: Realiz
SELECT STR_VALUE FROM V_DOCS_PROPS_VALS_SHADOW WHERE DOCS_PROP_R
N = :B3 AND UNITCODE = :B2 AND UNIT_RN = :B1
149,964 9 16,662.7 2.1 595.99 625.27 3779561935
Module: Realiz
BEGIN P_UDO_CLNPERSONS_INSERT(:SPERS_AGENT,:STAB_NUMB,:SFIRST_NA
ME,:SMIDDLE_NAME,:SLAST_NAME,:SPHONE,:SPHONE1,:DBIRH_DATE,:SE_MA
IL,:DJOBBEGIN_DATE,:DDISMISS_DATE,:DLAST_MODIFY_DATE,:NRN); END;
127,096 8,568 14.8 1.8 14.62 76.55 1965520661
Module: EquipSrv
SELECT COUNT(*) FROM DUAL WHERE EXISTS ( SELECT NULL FROM V_USER
PRIV WHERE UNITCODE = :B1 AND COMPANY = PKG_SESSION.GET_COMPANY
)
118,924 96 1,238.8 1.7 45.52 52.44 1934985088
Module: EquipSrv
select * from V_EQCONFIG_HIER where CRN=:"CRN" and UNITCODE=:"U
SQL ordered by Reads for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
---- ---------- ------------ -------------- ------ -------- --------- ----------
nitCode" and COMPANY=:"Company"
114,616 75 1,528.2 1.6 303.07 310.26 1202299718
Module: Realiz
BEGIN P_UDO_CLNPERSONS_UPDATE(:SPERS_AGENT,:STAB_NUMB,:SFIRST_NA
ME,:SMIDDLE_NAME,:SLAST_NAME,:SPHONE,:SPHONE1,:DBIRH_DATE,:SE_MA
IL,:DJOBBEGIN_DATE,:DDISMISS_DATE,:DLAST_MODIFY_DATE,:NRN); END;
-------------------------------------------------------------
SQL ordered by Executions for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------ ----- --------------- ---------------- ----------- ---------- ----------
2,734,528 2,734,528 1.0 0.00 0.00 1161402120
Module: Realiz
SELECT SIGN_SHARE,SIGN_ACCREG FROM UNITLIST WHERE UNITCODE = :B1
2,734,491 2,734,492 1.0 0.00 0.00 1503928570
Module: Realiz
SELECT UNITCODE FROM UNITLIST WHERE PARENTCODE IS NULL CONNECT B
Y PRIOR PARENTCODE = UNITCODE START WITH UNITCODE = :B1
949,463 949,464 1.0 0.00 0.00 1001732129
Module: Realiz
SELECT VERSION FROM COMPVERLIST WHERE COMPANY = :B2 AND UNITCODE
= :B1
949,441 949,441 1.0 0.00 0.00 785658401
Module: Realiz
SELECT SIGN_SHARE,SIGN_ACCREG,PARENTCODE FROM UNITLIST WHERE UNI
TCODE = :B1
939,862 939,862 1.0 0.00 0.00 1026483824
Module: Realiz
SELECT RN FROM DOCS_PROPS WHERE VERSION = :B2 AND CODE = :B1
927,949 927,949 1.0 0.00 0.00 1746108946
Module: Realiz
SELECT COUNT(*) FROM DOCS_PROPS_LINKS WHERE PRN = :B2 AND UNITCO
DE = :B1
927,948 927,943 1.0 0.00 0.00 3158840730
Module: EquipSrv
SELECT RN FROM COMPANIES WHERE RN = :B1
927,942 3 0.0 0.00 0.00 3519628608
Module: Realiz
SELECT RN FROM VERSIONS WHERE RN = :B2 AND UNITCODE = :B1
926,835 768,620 0.8 0.00 0.00 659406500
Module: Realiz
SELECT STR_VALUE FROM V_DOCS_PROPS_VALS_SHADOW WHERE DOCS_PROP_R
N = :B3 AND UNITCODE = :B2 AND UNIT_RN = :B1
903,293 903,293 1.0 0.00 0.00 3218456347
Module: Realiz
SELECT VU.VERSION FROM VERSIONS_UNIT VU_BY, VERSIONS_UNIT VU WHE
RE VU_BY.UNITCODE = :B3 AND VU_BY.VERSION = :B2 AND VU.UNITCODE
= :B1 AND VU_BY.PRN = VU.PRN
442,837 442,837 1.0 0.00 0.00 3783668458
Module: EquipSrv
SELECT COUNT(*) FROM UNAGNGRP AG, UNAGGRSP AGS, AGNLIST AL WHERE
AG.COMPANY = :B3 AND AG.CODE = :B2 AND AG.RN = AGS.PRN AND AGS.
AGENT = AL.RN AND AL.AGNABBR = :B1
SQL ordered by Executions for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------ ----- --------------- ---------------- ----------- ---------- ----------
100,970 100,970 1.0 0.00 0.00 2377420337
Module: Realiz
SELECT * FROM LICENSE_PIPE WHERE SESSION_ID = :b1
87,175 87,175 1.0 0.00 0.00 4095429386
Module: Realiz
INSERT INTO TR_SNAB_ZVV_MOV_TMC_REPORT1 T VALUES ( :B14 , USER,
:B13 , :B12 ,:B11 ,:B10 ,:B9 ,:B8 ,:B7 , :B6 ,0,0,0, 0,0,0,0, :B
5 ,:B4 ,:B3 ,0 , 0,0, :B2 ,SYSDATE,:B1 ,'' )
69,869 69,869 1.0 0.00 0.00 2032335011
Module: EquipSrv
SELECT PRN, CODE, FICT_REC, EXTRA_OBJ FROM EQCONFIG WHERE RN = :
B1
57,678 57,592 1.0 0.00 0.00 3582130883
Module: Realiz
SELECT DATA_TYPE FROM UPDATELIST_COLUMNS_CACHE WHERE TABLE_NAME
= :B2 AND COLUMN_NAME = :B1
42,581 42,581 1.0 0.00 0.00 3069888782
SELECT SEQ_UPDATELIST.NEXTVAL FROM DUAL
37,163 3,944 0.1 0.00 0.00 799275647
Module: EquipSrv
DELETE FROM ENV_VIEW_ACCESS WHERE ACTION = :B1
37,163 3,944 0.1 0.00 0.00 4172414152
Module: EquipSrv
DELETE FROM ENV_VIEW_REGISTER WHERE ACTION = :B1
36,504 1,141 0.0 0.00 0.00 3251773476
Module: EquipSrv
SELECT U.AUTHID FROM CLNPERSONS C, USERLIST U WHERE C.RN = :B1 A
ND C.PERS_AUTHID = U.AUTHID
36,502 0 0.0 0.00 0.00 3186214748
Module: Client
SELECT AD.SDOCSER||' № '||AD.SDOCNUMB FROM V_CLNPERSONS CP, V_AG
NDOCUMS AD WHERE CP.NRN = :B1 AND AD.NPRN = CP.NPERS_AGENT AND A
D.SAGNPASSTYPE = 'Водит. уд-е' AND AD.NDEFAULT_SIGN = 1
33,078 33,078 1.0 0.00 0.00 2891162846
SELECT COUNT(*) FROM DUAL WHERE EXISTS ( SELECT NULL FROM UPDATE
LIST_DISABLE WHERE TABLE_NAME IS NULL AND (:B1 IS NULL AND OPER_
TYPE IS NULL OR OPER_TYPE = :B1 ) )
33,072 33,072 1.0 0.00 0.00 2819947664
SELECT COUNT(*) FROM DUAL WHERE EXISTS ( SELECT NULL FROM UPDATE
LIST_DISABLE WHERE TABLE_NAME = :B2 AND (:B1 IS NULL AND OPER_TY
PE IS NULL OR OPER_TYPE = :B1 ) )
29,474 29,474 1.0 0.00 0.00 1107295739
Module: Realiz
SQL ordered by Executions for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------ ----- --------------- ---------------- ----------- ---------- ----------
INSERT INTO REPLDATABUFF ( PRN, ROW_ID, SCHEMA_ID, TABLE_ID, COL
UMN_ID, DATA_TYPE, STR_VALUE, NUM_VALUE, DATE_VALUE, BLOB_VALUE,
CLOB_VALUE ) VALUES ( :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5
, :B4 , :B3 , :B2 , :B1 )
29,474 29,474 1.0 0.00 0.00 3277751778
Module: Realiz
SELECT RN FROM REPLTABCOLS WHERE PRN = NVL(:B3 ,:B2 ) AND COLUMN
_NAME = :B1
28,934 28,934 1.0 0.00 0.00 1086102672
Module: EquipSrv
SELECT MAX(LEVEL) FROM UNITLIST CONNECT BY PRIOR PARENTCODE = UN
ITCODE START WITH UNITCODE = :B1
27,851 27,851 1.0 0.00 0.00 2563564778
SELECT SYS_CONTEXT(:B2 ,:B1 ) FROM SYS.DUAL
27,492 15,353 0.6 0.00 0.00 809542635
Module: EquipSrv
SELECT Q1.SEQEXTENVPRM||':'||DECODE(Q1.NVALUE_TYPE, 0, TO_CHAR(Q
1.NVALUE), Q1.SVALUE_LIST)||DECODE(Q1.NVALUE_TYPE, 0, ' '||Q1.SD
ICMUNTS, '')||'; ' A1 FROM V_EQLFLNEXTPRM Q1 WHERE Q1.NPRN = :B1
ORDER BY Q1.SEQEXTENVPRM
26,119 26,119 1.0 0.00 0.01 551431163
Module: Realiz
INSERT INTO UPDATELIST_DETAIL ( RN, PRN, REG_DATE, OPER_TYPE, TA
BLE_NAME, COLUMN_TYPE, COLUMN_KIND, COLUMN_NAME, PROPERTY, DATA_
TYPE, IS_CHANGE, IS_NULL, STR_VALUE, NUM_VALUE, DATE_VALUE, BLOB
_VALUE, CLOB_VALUE, UPD_STR_VALUE, UPD_NUM_VALUE, UPD_DATE_VALUE
, UPD_BLOB_VALUE, UPD_CLOB_VALUE ) VALUES ( :B22 , :B21 , :B20 ,
20,084 20,084 1.0 0.00 0.00 3770562338
Module: Realiz
SELECT TABLE_ID,SUBELEMENT_ID FROM REPLSCMELEMS WHERE RN = :B1
19,862 19,862 1.0 0.00 0.00 1930286316
Module: EquipSrv
INSERT INTO EXCEL_CELLS ( RN, SHEET_NAME, LINE_NAME, COLUMN_NAME
, CELL_NAME, CELL_INDEX_X, CELL_INDEX_Y, DELETED ) VALUES ( PKG_
-------------------------------------------------------------
SQL ordered by Parse Calls for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
14,717 14,717 10.85 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1
10,091 10,091 7.44 1307778841
select condition from cdef$ where rowid=:1
9,300 9,300 6.86 1676091879
select sys_nc_oid$ from xdb.xdb$resource where rowid = :1
4,836 4,836 3.57 236787672
Module: Realiz
SELECT T1.ORD_PREF ,T1.ORD_NUMB ,T2.DOCCODE FROM DELIVERYORD T1
,DOCTYPES T2 WHERE T1.RN=:FIELD AND T1.ORD_DOCTYPE=T2.RN(+)
3,893 3,893 2.87 2964322706
Module: EquipSrv
SELECT VERSION FROM COMPVERLIST WHERE COMPANY = :COMP
ANY AND UNITCODE = (SELECT UNITCODE FROM UNITLIST
WHERE PARENTCODE IS NULL CONNECT
BY PRIOR PARENTCODE = UNITCODE START WITH UNITCO
DE = :UNITCODE)
3,665 3,665 2.70 655488120
Module: Realiz
SELECT T3.CODE FROM DELIVERYORDS T1 ,NOMNMODIFPACK T2 ,NOMNPACK
T3 WHERE T1.RN=:FIELD AND T1.NOMMOD_PACK=T2.RN(+) AND T2.NOMENPA
CK=T3.RN(+)
3,664 3,664 2.70 1222872849
Module: Realiz
SELECT T2.CODE FROM DELIVERYORDS T1 ,NOMNPACK T2 WHERE T1.RN=:FI
ELD AND T1.NOM_PACK=T2.RN(+)
3,664 3,664 2.70 1286508111
Module: Realiz
SELECT T1.PERF_NUMB ,T1.PERF_DATE FROM DELIVERYORDP T1 WHERE T1.
RN=:FIELD
3,664 3,664 2.70 4196578091
Module: Realiz
SELECT T2.NOMEN_CODE FROM DELIVERYORDS T1 ,DICNOMNS T2 WHERE T1.
RN=:FIELD AND T1.NOMEN=T2.RN(+)
3,663 3,663 2.70 2715423176
Module: Realiz
SELECT T2.MODIF_CODE FROM DELIVERYORDS T1 ,NOMMODIF T2 WHERE T1.
RN=:FIELD AND T1.NOM_MODIF=T2.RN(+)
3,516 3,516 2.59 139306102
Module: Realiz
SELECT T1.COMPANY, TO_NUMBER(NULL), T1.CRN, TO_NUMBER(NULL), TO_
NUMBER(NULL) INTO :COMPANY,:VERSION,:CATALOG,:JUR_PERS,:HIERARCH
SQL ordered by Parse Calls for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
Y FROM DELIVERYORDS T1 WHERE T1.RN = :DOCUMENT
3,295 3,295 2.43 2873730499
Module: Admin
begin P_GET_LAST_ALERT(:SAUTHOR_NAME, :NRN_LAST, :SCAPTION, :S
MESSAGE); end;
2,837 2,837 2.09 2384228740
Module: Realiz
SELECT T1.ROLENAME FROM ROLES T1 WHERE T1.RN=:FIELD
2,556 2,556 1.89 3290205337
Module: Realiz
SELECT T1.VERNAME FROM VERSIONS T1 WHERE T1.RN=:FIELD
2,469 2,469 1.82 2717458194
Module: Realiz
SELECT T1.COMPANY, TO_NUMBER(NULL), T1.CRN, TO_NUMBER(NULL), TO_
NUMBER(NULL) INTO :COMPANY,:VERSION,:CATALOG,:JUR_PERS,:HIERARCH
Y FROM DELIVERYORD T1 WHERE T1.RN = :DOCUMENT
2,424 2,413 1.79 3920811615
Module: Admin
SELECT T1.NAME FROM ACATALOG T1 WHERE T1.RN=:FIELD
2,346 2,346 1.73 2218858618
Module: Realiz
SELECT T1.ROWID FROM DELIVERYORDS T1 WHERE T1.RN=:RN
2,316 2,316 1.71 1296450946
Module: EquipSrv
begin P_CLNEVENTS_ENV_CHECK_ACTION(:COMPANY, :CLNEVENTS, :UNITCO
DE, :ACTION_CODE, :RESULT ); end;
1,440 1,440 1.06 1514274355
Module: Realiz
SELECT T1.IN_PREF ,T1.IN_NUMB FROM REPLINPUT T1 WHERE T1.RN=:FIE
LD
1,233 1,233 0.91 3547647713
Module: Realiz
SELECT T1.NOMEN_CODE FROM DICNOMNS T1 WHERE T1.RN=:FIELD
1,221 1,221 0.90 4166625621
Module: Realiz
select HRN,to_char(NAME) from UDO_T_INDSFT_ACCIDENT_PLACE where
RN=:RN
1,173 1,172 0.87 1318928139
Module: Realiz
BEGIN P_UDO_DELIVERYORDS_UPDATE(:NRN,:SNUMBER,:SNOMEN_U,:NEXP_PR
ICE,:NACTM_QUANT,:SCURRENCY_U,:SORDER_NUMBER,:NDELETE_SIGN); END
;
SQL ordered by Parse Calls for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,173 1,173 0.87 2394777035
Module: Realiz
SELECT T1.MODIF_CODE FROM NOMMODIF T1 WHERE T1.RN=:FIELD
1,172 1,172 0.86 1135088251
Module: Realiz
SELECT BLOCKED FROM DELIVERYORD WHERE RN = :RN
1,172 1,172 0.86 1252402360
Module: Realiz
SELECT T1.RN FROM DELIVERYORDS T1 WHERE T1.ROWID=:VAL
1,172 1,172 0.86 2108102833
Module: Realiz
SELECT :B17 NSUMM, :B16 NSUMMWITHAXS, :B15 NSUMMWITHTAX, :B14 NS
UMMWITOUTNDS, :B13 NSUMMWITHOUTNCP, :B12 NAXCISE_SUM, :B11 NAXCI
SE_PRC, :B10 NAXCISE_RET, :B9 NNDS_SUM, :B8 NNDS_PRC, :B7 NNDS_R
ET, :B6 NGSM_SUM, :B5 NGSM_PRC, :B4 NGSM_RET, :B3 NNCP_SUM, :B2
NNCP_PRC, :B1 NNCP_RET FROM DUAL WHERE ROWNUM < 2
952 952 0.70 3468666020
select text from view$ where rowid=:1
865 865 0.64 640901649
Module: EquipSrv
select count(*) nLINK_COUNT, max(nRN) nRN, max(sEQLNKKINDS) sEQL
NKKINDS, nPREV_ELEM from V_EQTECHAINELEMLNK where NPRN = :"ELEM"
group by nPREV_ELEM
814 814 0.60 659788841
Module: EquipSrv
begin P_EQTECHAINELEM_CHANGE_COORD(:NCOMPANY, :NRN, :NCOORD_X,
:NCOORD_Y); end;
766 766 0.56 2518918765
Module: Realiz
BEGIN PKG_LICENSE.CONTROL_SERVICE_WAKEUP; END;
744 739 0.55 1757328656
Module: EquipSrv
SELECT T1.NAME ,T2.CODE FROM EQLFLENGTHJRNL T1 ,EQCONFIG T2 WHER
E T1.RN=:FIELD AND T1.EQCONFIG=T2.RN(+)
729 729 0.54 838425440
Module: PARUS_LICENSE_SERVICE
SELECT MODULE FROM SYS.V_$SESSION WHERE SID = :SID
720 720 0.53 3435944318
Module: Realiz
SELECT T1.DB_CODE FROM REPLDATABASES T1 WHERE T1.RN=:FIELD
-------------------------------------------------------------
SQL ordered by Sharable Memory for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b) Executions % Total Hash Value
---------------- ------------ ------- ------------
14,822,078 183 1.1 3868249022
Module: Realiz
SELECT XMLELEMENT("errors",XMLAGG(XMLELEMENT("error",XMLATTRIBUT
ES(STATUSAFTER "id"),TO_CHAR(T.DATELOG,'YYYY.MM.DD HH24.MI.SS ')
||T.NOTE||CR) ORDER BY T.DATELOG ) ).GETSTRINGVAL() FROM UDO_T_R
EPLLOG T WHERE T.PLCOMPUTEL = :B1 AND T.STATUSAFTER<=0 AND T.DAT
ELOG = ( SELECT MAX(T1.DATELOG) FROM UDO_T_REPLLOG T1 WHERE T1.S
8,896,990 27 0.7 950967749
Module: Admin
select sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from
V_ROLEPRIV2FUNC where sUNITCODE=:"UNITCODE" and nROLEID=:"US
ERROLEID" and nCOMPANY=:"COMPANY" and nCATALOG=:"CATALOG" an
d nJUR_PERS is null and nHIERARCHY is null union all select
sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from V_ROLEP
4,473,071 18 0.3 3403588364
Module: Admin
select sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from
V_USERPRIV2FUNC where sUNITCODE=:"UNITCODE" and sAUTHID=:"US
ERROLEID" and nCOMPANY=:"COMPANY" and nCATALOG=:"CATALOG" an
d nJUR_PERS is null and nHIERARCHY is null union all select
sUNITCODE, sFUNCCODE, sFUNCNAME, sFUNCNUMB, nACCESS from V_USERP
2,013,964 36 0.2 2273959552
Module: Admin
select * from V_PRIV2UNIT where NCOMPANY = :"Company" and SMASTE
RCODE = :"MasterCode" order by NLEVEL, SUNITCODE
1,396,846 2 0.1 2294764654
Module: Client
SELECT DISTINCT SADDR_CODE FROM (SELECT CN.CODE SADDR_CODE FROM
CONTACTS CN ,USERROLES R ,CLNPERSONS P ,AGNLIST A ,V_WARNMSGADDR
_SHADOW WS WHERE R.ROLEID = WS.NADDR_ROLE AND P.PERS_AUTHID = R.
AUTHID AND P.PERS_AGENT = A.RN AND CN.PRN = A.RN AND NOT EXISTS
(SELECT US.RN FROM UNAGGRSP US WHERE US.AGENT = A.RN AND US.PRN
1,146,586 193 0.1 197767729
Module: EquipSrv
select * from V_DOCS_PROPS_VALS_SHADOW where UNITCODE=:"UnitCode
" and UNIT_RN=:"Document"
1,110,256 5 0.1 1407035102
Module: EquipSrv
select * from V_EQCONFIG_HIER where SIGNS <= 1 and UNITCODE=:"U
nitCode" and COMPANY=:"Company" order by SIGNS, CRN, NAME
1,106,155 1 0.1 430222185
Module: EquipSrv
select M.*, substr(uf_eqconfig_get_eqobj_kind(NRN), 1, 240) S650
4961748, substr(UF_EQCONFIG_GET_PR_OBJ_NAME(NRN), 1, 240) S65049
61745, substr(UF_EQCONFIG_GET_ROUTE(NRN, SROUTE), 1, 240) S65049
61746, substr(UF_EQCONFIG_GET_OBJKIND_ROUTE(NRN, SOBJ_FULLCODE),
1, 240) S6504961742, UDO_F_EQCONFIG_CURR_DATE_SO(NRN) D65049617
SQL ordered by Sharable Memory for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b) Executions % Total Hash Value
---------------- ------------ ------- ------------
1,077,903 5 0.1 3401563689
Module: EquipSrv
select M.*, substr(F_DOCS_PROPS_GET_STR_VALUE(6483867837, 'AGNLI
ST', RN), 1, 240) S6483867837, substr(F_DOCS_PROPS_GET_STR_VALUE
(6531505603, 'AGNLIST', RN), 1, 240) S6531505603 from V_AGNLIST
M where CRN in (:"RN") and VERSION=:"VERSION" order by AGNABB
R
1,076,096 6 0.1 342151927
Module: EquipSrv
select * from V_INS_DEPARTMENT_HIER where SIGNS <= 1 and UNITCO
DE=:"UnitCode" and COMPANY=:"Company" order by SIGNS, CRN, NAME
1,070,268 343 0.1 2488509356
Module: Realiz
INSERT INTO DOCS_PROPS_VALS ( RN, UNITCODE, COMPANY, VERSION, CA
TALOG, JUR_PERS, HIERARCHY, UNIT_RN, DOCS_PROP_RN, SOURCE, SOURC
E_EXT, STR_VALUE, NUM_VALUE, DATE_VALUE ) VALUES ( :B1 , :B14 ,
:B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B2 , :B3 , :B4 , :B5 ,
:B6 , :B7 )
1,059,380 1 0.1 3808857757
Module: EquipSrv
select * from V_EQOBJKIND_HIER where SIGNS <= 1 and UNITCODE=:"
UnitCode" and COMPANY=:"Company" order by SIGNS, CRN, NAME
-------------------------------------------------------------
SQL ordered by Version Count for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Version Count Threshold: 20
Version
Count Executions Hash Value
-------- ------------ ------------
191 183 3868249022
Module: Realiz
SELECT XMLELEMENT("errors",XMLAGG(XMLELEMENT("error",XMLATTRIBUT
ES(STATUSAFTER "id"),TO_CHAR(T.DATELOG,'YYYY.MM.DD HH24.MI.SS ')
||T.NOTE||CR) ORDER BY T.DATELOG ) ).GETSTRINGVAL() FROM UDO_T_R
EPLLOG T WHERE T.PLCOMPUTEL = :B1 AND T.STATUSAFTER<=0 AND T.DAT
ELOG = ( SELECT MAX(T1.DATELOG) FROM UDO_T_REPLLOG T1 WHERE T1.S
61 343 2488509356
Module: Realiz
INSERT INTO DOCS_PROPS_VALS ( RN, UNITCODE, COMPANY, VERSION, CA
TALOG, JUR_PERS, HIERARCHY, UNIT_RN, DOCS_PROP_RN, SOURCE, SOURC
E_EXT, STR_VALUE, NUM_VALUE, DATE_VALUE ) VALUES ( :B1 , :B14 ,
:B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B2 , :B3 , :B4 , :B5 ,
:B6 , :B7 )
29 80 3042648048
Module: Realiz
UPDATE AGNLIST SET AGNABBR = :B57 , AGNTYPE = :B56 , AGNNAME = :
B55 , AGNIDNUMB = :B54 , ECONCODE = :B53 , ORGCODE = :B52 , AGNF
AMILYNAME = :B51 , AGNFIRSTNAME = :B50 , AGNLASTNAME = :B49 , AG
NFAMILYNAME_TO = :B48 , AGNFIRSTNAME_TO = :B47 , AGNLASTNAME_TO
= :B46 , AGNFAMILYNAME_FR = :B45 , AGNFIRSTNAME_FR = :B44 , AGNL
27 298 1603942766
Module: EquipSrv
SELECT SM_NM.TEXT, UL_NM.TEXT FROM UNIT_SHOWMETHODS SM, (SELECT
RN, TEXT FROM V_RESOURCES_LOCAL WHERE TABLE_NAME = 'UNIT_SHOWMET
HODS' AND COLUMN_NAME = 'METHOD_NAME') SM_NM, UNITLIST UL, (SELE
CT RN, TEXT FROM V_RESOURCES_LOCAL WHERE TABLE_NAME = 'UNITLIST'
AND COLUMN_NAME = 'UNITNAME') UL_NM WHERE SM.RN = SM_NM.RN(+) A
23 2,316 886669831
Module: EquipSrv
SELECT COUNT(*) FROM DUAL WHERE NOT EXISTS ( SELECT NULL FROM CL
NEVENTACTION A, CLNEVENTUNIT U WHERE A.UNITFUNC = :B3 AND A.PRN
= U.RN AND U.UNITCODE = :B2 AND U.COMPANY = :B1 )
22 26,119 551431163
Module: Realiz
INSERT INTO UPDATELIST_DETAIL ( RN, PRN, REG_DATE, OPER_TYPE, TA
BLE_NAME, COLUMN_TYPE, COLUMN_KIND, COLUMN_NAME, PROPERTY, DATA_
TYPE, IS_CHANGE, IS_NULL, STR_VALUE, NUM_VALUE, DATE_VALUE, BLOB
_VALUE, CLOB_VALUE, UPD_STR_VALUE, UPD_NUM_VALUE, UPD_DATE_VALUE
, UPD_BLOB_VALUE, UPD_CLOB_VALUE ) VALUES ( :B22 , :B21 , :B20 ,
22 2 623262490
Module: Realiz
INSERT INTO UPDATELIST_DETAIL ( RN, PRN, REG_DATE, OPER_TYPE, TA
BLE_NAME, COLUMN_TYPE, COLUMN_KIND, COLUMN_NAME, PROPERTY, DATA_
TYPE, IS_CHANGE, IS_NULL, STR_VALUE, NUM_VALUE, DATE_VALUE, BLOB
_VALUE, CLOB_VALUE, UPD_STR_VALUE, UPD_NUM_VALUE, UPD_DATE_VALUE
, UPD_BLOB_VALUE, UPD_CLOB_VALUE ) VALUES ( :B16 , :B15 , :B14 ,
SQL ordered by Version Count for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Version Count Threshold: 20
Version
Count Executions Hash Value
-------- ------------ ------------
-------------------------------------------------------------
Instance Activity Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
active txn count during cleanout 152,669 84.6 1.3
background checkpoints completed 2 0.0 0.0
background checkpoints started 2 0.0 0.0
background timeouts 2,199 1.2 0.0
branch node splits 11 0.0 0.0
buffer is not pinned count 196,081,551 108,692.7 1,724.1
buffer is pinned count 5,417,188,834 3,002,876.3 47,631.6
bytes received via SQL*Net from c 8,537,474 4,732.5 75.1
bytes received via SQL*Net from d 0 0.0 0.0
bytes sent via SQL*Net to client 36,742,674 20,367.3 323.1
bytes sent via SQL*Net to dblink 0 0.0 0.0
calls to get snapshot scn: kcmgss 16,396,874 9,089.2 144.2
calls to kcmgas 223,775 124.0 2.0
calls to kcmgcs 21,024 11.7 0.2
change write time 1,217 0.7 0.0
cleanout - number of ktugct calls 126,332 70.0 1.1
cleanouts and rollbacks - consist 76,353 42.3 0.7
cleanouts only - consistent read 21,355 11.8 0.2
cluster key scan block gets 127,194 70.5 1.1
cluster key scans 19,421 10.8 0.2
commit cleanout failures: block l 37,042 20.5 0.3
commit cleanout failures: buffer 24 0.0 0.0
commit cleanout failures: callbac 285 0.2 0.0
commit cleanout failures: cannot 160 0.1 0.0
commit cleanout failures: hot bac 0 0.0 0.0
commit cleanouts 572,372 317.3 5.0
commit cleanouts successfully com 534,861 296.5 4.7
commit txn count during cleanout 102,754 57.0 0.9
consistent changes 1,000,361 554.5 8.8
consistent gets 302,663,110 167,773.3 2,661.2
consistent gets - examination 133,411,875 73,953.4 1,173.1
CPU used by this session 212,164 117.6 1.9
CPU used when call started 130,776 72.5 1.2
CR blocks created 80,231 44.5 0.7
current blocks converted for CR 221 0.1 0.0
cursor authentications 307 0.2 0.0
data blocks consistent reads - un 322,879 179.0 2.8
db block changes 4,386,345 2,431.5 38.6
db block gets 10,747,571 5,957.6 94.5
DBWR buffers scanned 2,799,740 1,552.0 24.6
DBWR checkpoint buffers written 2,706 1.5 0.0
DBWR checkpoints 2 0.0 0.0
DBWR free buffers found 2,733,036 1,515.0 24.0
DBWR lru scans 3,302 1.8 0.0
DBWR make free requests 5,946 3.3 0.1
DBWR revisited being-written buff 0 0.0 0.0
DBWR summed scan depth 2,799,740 1,552.0 24.6
DBWR transaction table writes 23 0.0 0.0
DBWR undo block writes 28,118 15.6 0.3
deferred (CURRENT) block cleanout 271,881 150.7 2.4
dirty buffers inspected 10,345 5.7 0.1
enqueue conversions 2,793 1.6 0.0
enqueue deadlocks 0 0.0 0.0
enqueue releases 2,184,224 1,210.8 19.2
enqueue requests 2,184,208 1,210.8 19.2
enqueue timeouts 15 0.0 0.0
Instance Activity Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
enqueue waits 115 0.1 0.0
exchange deadlocks 0 0.0 0.0
execute count 15,343,856 8,505.5 134.9
failed probes on index block recl 111 0.1 0.0
free buffer inspected 12,514 6.9 0.1
free buffer requested 6,889,339 3,818.9 60.6
hot buffers moved to head of LRU 1,242,542 688.8 10.9
immediate (CR) block cleanout app 97,709 54.2 0.9
immediate (CURRENT) block cleanou 66,056 36.6 0.6
index crx upgrade (found) 1 0.0 0.0
index crx upgrade (positioned) 146,514 81.2 1.3
index fast full scans (full) 196 0.1 0.0
index fetch by key 80,560,864 44,656.8 708.4
index scans kdiixs1 6,389,126 3,541.6 56.2
leaf node splits 3,946 2.2 0.0
leaf node 90-10 splits 838 0.5 0.0
logons cumulative 203 0.1 0.0
messages received 66,875 37.1 0.6
messages sent 66,875 37.1 0.6
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 168,118,222 93,191.9 1,478.2
opened cursors cumulative 135,140 74.9 1.2
Parallel operations downgraded to 0 0.0 0.0
parse count (failures) 1 0.0 0.0
parse count (hard) 459 0.3 0.0
parse count (total) 135,589 75.2 1.2
parse time cpu 996 0.6 0.0
parse time elapsed 2,407 1.3 0.0
physical reads 6,981,361 3,869.9 61.4
physical reads direct 219,026 121.4 1.9
physical reads direct (lob) 5,252 2.9 0.1
physical writes 216,346 119.9 1.9
physical writes direct 137,928 76.5 1.2
physical writes direct (lob) 296 0.2 0.0
physical writes non checkpoint 213,404 118.3 1.9
pinned buffers inspected 838 0.5 0.0
prefetch clients - default 0 0.0 0.0
prefetched blocks 2,601,718 1,442.2 22.9
prefetched blocks aged out before 534 0.3 0.0
process last non-idle time 1,804 1.0 0.0
PX local messages recv'd 0 0.0 0.0
PX local messages sent 0 0.0 0.0
recovery blocks read 0 0.0 0.0
recursive aborts on index block r 0 0.0 0.0
recursive calls 18,316,670 10,153.4 161.1
recursive cpu usage 151,774 84.1 1.3
redo blocks written 1,256,543 696.5 11.1
redo buffer allocation retries 23 0.0 0.0
redo entries 2,121,823 1,176.2 18.7
redo log space requests 8 0.0 0.0
redo log space wait time 27 0.0 0.0
redo ordering marks 4 0.0 0.0
redo size 615,516,624 341,195.5 5,412.0
redo synch time 2,471 1.4 0.0
redo synch writes 3,956 2.2 0.0
redo wastage 7,612,488 4,219.8 66.9
Instance Activity Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
redo write time 12,476 6.9 0.1
redo writer latching time 8 0.0 0.0
redo writes 29,711 16.5 0.3
rollback changes - undo records a 10,516 5.8 0.1
rollbacks only - consistent read 4,176 2.3 0.0
rows fetched via callback 27,487,604 15,237.0 241.7
session connect time 0 0.0 0.0
session cursor cache count 93 0.1 0.0
session cursor cache hits 117,016 64.9 1.0
session logical reads 313,405,419 173,728.1 2,755.7
session pga memory 112,933,888 62,601.9 993.0
session pga memory max 187,161,072 103,747.8 1,645.7
session uga memory 81,620,667,368 45,244,272.4 717,664.2
session uga memory max 543,408,888 301,224.4 4,778.0
shared hash latch upgrades - no w 911,744 505.4 8.0
shared hash latch upgrades - wait 49 0.0 0.0
sorts (disk) 4 0.0 0.0
sorts (memory) 8,828,555 4,893.9 77.6
sorts (rows) 24,410,334 13,531.2 214.6
SQL*Net roundtrips to/from client 32,141 17.8 0.3
SQL*Net roundtrips to/from dblink 0 0.0 0.0
summed dirty queue length 78,022 43.3 0.7
switch current to new buffer 4,202 2.3 0.0
table fetch by rowid 2,765,547,628 1,533,008.7 24,316.6
table fetch continued row 2,384,273 1,321.7 21.0
table scan blocks gotten 13,378,032 7,415.8 117.6
table scan rows gotten 297,962,928 165,167.9 2,619.9
table scans (cache partitions) 0 0.0 0.0
table scans (long tables) 3,675 2.0 0.0
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 284,243 157.6 2.5
transaction rollbacks 83 0.1 0.0
transaction tables consistent rea 11 0.0 0.0
transaction tables consistent rea 8,858 4.9 0.1
user calls 44,427 24.6 0.4
user commits 113,687 63.0 1.0
user rollbacks 44 0.0 0.0
workarea executions - multipass 0 0.0 0.0
workarea executions - onepass 8 0.0 0.0
workarea executions - optimal 17,138,427 9,500.2 150.7
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 69 0.0 0.0
-------------------------------------------------------------
Tablespace IO Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PARUS
3,388,867 1,879 1.0 1.8 7,228 4 330,929 0.5
PARUS_IND
710,978 394 1.9 1.0 15,283 8 60,667 3.9
PARUS_TEMP
138,665 77 0.1 1.6 9,014 5 0 0.0
PARUS_UPDL_IND
22,011 12 6.9 1.0 17,465 10 11 0.0
UNDOTBS1
1,973 1 1.1 1.0 28,152 16 124 0.2
SYSTEM
24,803 14 2.0 1.1 140 0 14 0.7
PARUS_UPDATELIST
4,540 3 6.4 1.0 4,299 2 0 0.0
PERFSTAT
1,975 1 4.1 1.0 2,691 1 0 0.0
PARUS_LOB
499 0 3.8 1.0 10 0 0 0.0
DRSYS
6 0 10.0 1.0 6 0 0 0.0
XDB
6 0 10.0 1.0 2 0 0 0.0
FINEREPORTS
2 0 10.0 1.0 2 0 0 0.0
MMDATA
2 0 0.0 1.0 2 0 0 0.0
MMINDEX
2 0 5.0 1.0 2 0 0 0.0
OEM_REPOSITORY
2 0 0.0 1.0 2 0 0 0.0
PARUS2
2 0 5.0 1.0 2 0 0 0.0
PARUS3
2 0 15.0 1.0 2 0 0 0.0
PARUS4
2 0 5.0 1.0 2 0 0 0.0
PARUS_BPHIST
2 0 5.0 1.0 2 0 0 0.0
TOOLS
2 0 5.0 1.0 2 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DRSYS /u/oradata/dbs/snab/drsys01.dbf
2 0 5.0 1.0 2 0 0
/u/oradata/dbs/snab/parus_lob05.dbf
2 0 20.0 1.0 2 0 0
/u01/oradata/dbs/snab/parus_updatelist08.dbf
2 0 5.0 1.0 2 0 0
FINEREPORTS /u/oradata/dbs/snab/finereports01.dbf
2 0 10.0 1.0 2 0 0
MMDATA /u/oradata/dbs/snab/mmdata01.dbf
2 0 0.0 1.0 2 0 0
MMINDEX /u/oradata/dbs/snab/mmindex01.dbf
2 0 5.0 1.0 2 0 0
OEM_REPOSITORY /u/oradata/dbs/snab/oem_repository01.dbf
2 0 0.0 1.0 2 0 0
PARUS /u/oradata/dbs/snab/parus01.dbf
860,070 477 1.1 1.7 2,202 1 89,087 0.6
/u/oradata/dbs/snab/parus02.dbf
1,049,904 582 0.8 1.8 1,783 1 105,660 0.5
/u/oradata/dbs/snab/parus03.dbf
770,598 427 1.1 1.7 1,771 1 78,052 0.5
/u/oradata/dbs/snab/parus04.dbf
708,295 393 1.3 1.8 1,472 1 58,130 0.7
PARUS_BPHIST /u/oradata/dbs/snab/parus_bphist01.dbf
2 0 5.0 1.0 2 0 0
PARUS_IND /u/oradata/dbs/snab/parus_ind01.dat
162,765 90 2.0 1.0 4,517 3 16,825 3.7
/u/oradata/dbs/snab/parus_ind02.dat
195,628 108 1.8 1.0 3,361 2 18,324 4.1
/u/oradata/dbs/snab/parus_ind03.dat
166,368 92 1.7 1.0 4,221 2 12,414 3.9
/u/oradata/dbs/snab/parus_ind04.dat
186,217 103 1.9 1.0 3,184 2 13,104 4.1
PARUS_LOB /u/oradata/dbs/snab/parus_lob01.dbf
186 0 3.3 1.0 2 0 0
/u/oradata/dbs/snab/parus_lob02.dbf
93 0 2.6 1.0 2 0 0
/u/oradata/dbs/snab/parus_lob03.dbf
150 0 4.8 1.0 2 0 0
/u/oradata/dbs/snab/parus_lob04.dbf
2 0 10.0 1.0 2 0 0
/u/oradata/dbs/snab/parus_lob06.dbf
68 0 4.9 1.0 2 0 0
PARUS_TEMP /u/oradata/dbs/snab/parus_temp01.dbf
File IO Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
138,665 77 0.1 1.6 9,014 5 0
PARUS_UPDATELIST /u/oradata/dbs/snab/parus_updatelist01.dbf
30 0 6.0 1.0 16 0 0
/u/oradata/dbs/snab/parus_updatelist02.dbf
143 0 6.5 1.0 162 0 0
/u/oradata/dbs/snab/parus_updatelist03.dbf
193 0 8.4 1.0 178 0 0
/u/oradata/dbs/snab/parus_updatelist04.dbf
640 0 5.2 1.0 649 0 0
/u/oradata/dbs/snab/parus_updatelist05.dbf
293 0 7.6 1.0 272 0 0
/u/oradata/dbs/snab/parus_updatelist06.dbf
3,222 2 6.4 1.0 3,016 2 0
/u01/oradata/dbs/snab/parus_updatelist07.dbf
2 0 5.0 1.0 2 0 0
/u01/oradata/dbs/snab/parus_updatelist09.dbf
2 0 10.0 1.0 2 0 0
/u01/oradata/dbs/snab/parus_updatelist10.dbf
15 0 4.0 1.0 2 0 0
PARUS_UPDL_IND /u/oradata/dbs/snab/parus_updl_ind01.dbf
4,817 3 6.6 1.0 3,997 2 1 0.0
/u/oradata/dbs/snab/parus_updl_ind02.dbf
6,196 3 6.2 1.0 5,950 3 5 0.0
/u/oradata/dbs/snab/parus_updl_ind03.dbf
5,299 3 6.2 1.0 4,869 3 2 0.0
/u/oradata/dbs/snab/parus_updl_ind04.dbf
3,403 2 7.1 1.0 2,320 1 3 0.0
/u/oradata/dbs/snab/parus_updl_ind05.dbf
629 0 9.7 1.0 102 0 0
/u/oradata/dbs/snab/parus_updl_ind06.dbf
458 0 12.6 1.0 68 0 0
/u/oradata/dbs/snab/parus_updl_ind07.dbf
708 0 10.0 1.0 85 0 0
/u/oradata/dbs/snab/parus_updl_ind08.dbf
501 0 9.5 1.0 74 0 0
PARUS2 /u/oradata/dbs/snab/parus2_01.dbf
2 0 5.0 1.0 2 0 0
PARUS3 /u/oradata/dbs/snab/parus3_01.dbf
2 0 15.0 1.0 2 0 0
PARUS4 /u/oradata/dbs/snab/parus4_01.dbf
2 0 5.0 1.0 2 0 0
PERFSTAT /u/oradata/dbs/snab/perfstat01.dbf
1,975 1 4.1 1.0 2,691 1 0
SYSTEM /u/oradata/dbs/snab/system01.dbf
24,803 14 2.0 1.1 140 0 14 0.7
File IO Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
TOOLS /u/oradata/dbs/snab/tools01.dbf
2 0 5.0 1.0 2 0 0
UNDOTBS1 /u/oradata/dbs/snab/undotbs1_01.dbf
1,973 1 1.1 1.0 28,152 16 124 0.2
XDB /u/oradata/dbs/snab/xdb01.dbf
6 0 10.0 1.0 2 0 0
-------------------------------------------------------------
Buffer Pool Statistics for DB: SNAB Instance: snab Snaps: 1193 -1195
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Write Buffer
Number of Cache Buffer Physical Physical Buffer Complete Busy
P Buffers Hit % Gets Reads Writes Waits Waits Waits
--- ---------- ----- ----------- ----------- ---------- ------- -------- ------
D 174,680 97.8 313,435,309 6,757,174 78,140 0 2 391,745
-------------------------------------------------------------
Instance Recovery Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
-> B: Begin snapshot, E: End snapshot
Targt Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- ---------- ---------- ---------- ---------- ----------
B 300 23 3961 553171 552960 552960 954431
E 300 23 13272 569603 552960 552960 1257637
-------------------------------------------------------------
Buffer Pool Advisory for DB: SNAB Instance: snab End Snap: 1195
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate (default block size first)
Size for Size Buffers for Est Physical Estimated
P Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D 144 .1 17,865 3.18 9,676,232,066
D 288 .2 35,730 1.94 5,897,152,121
D 432 .3 53,595 1.34 4,073,996,288
D 576 .4 71,460 1.22 3,700,018,534
D 720 .5 89,325 1.13 3,428,587,243
D 864 .6 107,190 1.10 3,333,800,176
D 1,008 .7 125,055 1.08 3,284,353,052
D 1,152 .8 142,920 1.06 3,224,480,406
D 1,296 .9 160,785 1.03 3,139,841,905
D 1,408 1.0 174,680 1.00 3,040,988,210
D 1,440 1.0 178,650 0.99 3,006,216,292
D 1,584 1.1 196,515 0.90 2,751,655,791
D 1,728 1.2 214,380 0.77 2,350,454,386
D 1,872 1.3 232,245 0.61 1,850,769,698
D 2,016 1.4 250,110 0.49 1,478,523,751
D 2,160 1.5 267,975 0.39 1,188,137,073
D 2,304 1.6 285,840 0.32 984,772,405
D 2,448 1.7 303,705 0.28 848,692,484
D 2,592 1.8 321,570 0.25 757,560,427
D 2,736 1.9 339,435 0.23 693,324,270
D 2,880 2.0 357,300 0.21 630,642,982
-------------------------------------------------------------
Buffer wait Statistics for DB: SNAB Instance: snab Snaps: 1193 -1195
-> ordered by wait time desc, waits desc
Tot Wait Avg
Class Waits Time (s) Time (ms)
------------------ ----------- ---------- ---------
data block 391,621 417 1
undo block 26 0 1
undo header 98 0 0
-------------------------------------------------------------
PGA Aggr Target Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem - percentage of workarea memory under manual control
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
97.3 56,744 1,585
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 3,906 2,361 1,545.8 81.5 5.3 100.0 .0 102,400
E 3,906 2,383 1,574.1 124.0 7.9 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram for DB: SNAB Instance: snab Snaps: 1193 -1195
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
2K 4K 17,119,139 17,119,139 0 0
4K 8K 14,860 14,860 0 0
8K 16K 616 616 0 0
16K 32K 489 489 0 0
32K 64K 97 97 0 0
64K 128K 253 253 0 0
128K 256K 113 113 0 0
256K 512K 90 90 0 0
512K 1024K 1,663 1,663 0 0
1M 2M 62 62 0 0
2M 4M 4 4 0 0
4M 8M 217 217 0 0
8M 16M 200 200 0 0
16M 32M 2 2 0 0
32M 64M 2 2 0 0
128M 256M 8 0 8 0
-------------------------------------------------------------
PGA Memory Advisory for DB: SNAB Instance: snab End Snap: 1195
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr Processed Written to Disk Hit % Count
---------- ------- ---------------- ---------------- -------- ----------
488 0.1 115,822,108.5 11,217,635.2 91.0 554,441
977 0.3 115,822,108.5 10,070,428.5 92.0 506,620
1,953 0.5 115,822,108.5 8,477,215.5 93.0 450,273
2,930 0.8 115,822,108.5 7,046,959.6 94.0 224,695
3,906 1.0 115,822,108.5 2,325,912.5 98.0 215,835
4,688 1.2 115,822,108.5 2,271,923.4 98.0 80,466
5,469 1.4 115,822,108.5 2,251,158.1 98.0 13,824
6,250 1.6 115,822,108.5 2,249,323.5 98.0 564
7,031 1.8 115,822,108.5 2,249,323.5 98.0 0
7,813 2.0 115,822,108.5 2,249,323.5 98.0 0
11,719 3.0 115,822,108.5 2,249,323.5 98.0 0
15,625 4.0 115,822,108.5 2,249,323.5 98.0 0
23,438 6.0 115,822,108.5 2,249,323.5 98.0 0
31,250 8.0 115,822,108.5 2,249,323.5 98.0 0
-------------------------------------------------------------
Enqueue activity for DB: SNAB Instance: snab Snaps: 1193 -1195
-> Enqueue stats gathered prior to 9i should not be compared with 9i data
-> ordered by Wait Time desc, Waits desc
Avg Wt Wait
Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s)
-- ------------ ------------ ----------- ----------- ------------- ------------
TX 136,012 136,012 0 51 602.82 31
SQ 14,801 14,801 0 64 .28 0
-------------------------------------------------------------
Rollback Segment Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->A high value for "Pct Waits" suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
managment, as RBS may be dynamically created and dropped as needed
Trans Table Pct Undo Bytes
RBS No Gets Waits Written Wraps Shrinks Extends
------ -------------- ------- --------------- -------- -------- --------
0 14.0 0.00 0 0 0 0
1 41,211.0 0.00 26,992,320 4 0 4
2 25,755.0 0.00 51,226,508 7 0 6
3 48,066.0 0.00 21,498,952 0 0 0
4 31,964.0 0.00 19,024,048 3 0 3
5 177.0 0.00 110,414 0 0 0
6 57,978.0 0.01 42,344,776 6 0 5
7 26,087.0 0.00 19,506,052 2 0 2
8 30,558.0 0.00 24,013,304 3 0 3
9 19,458.0 0.00 15,965,886 2 0 2
10 20,756.0 0.00 14,235,804 2 0 2
-------------------------------------------------------------
Rollback Segment Storage for DB: SNAB Instance: snab Snaps: 1193 -1195
->Optimal Size should be larger than Avg Active
RBS No Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- --------------- ---------------
0 401,408 0 401,408
1 536,993,792 26,466,077 2,728,517,632
2 302,112,768 10,406,672 2,495,733,760
3 260,169,728 92,841,874 2,583,814,144
4 948,035,584 160,633,326 1,911,676,928
5 513,925,120 40,246,721 2,915,164,160
6 369,221,632 16,512,836 1,973,542,912
7 302,112,768 10,054,392 2,957,107,200
8 335,667,200 9,168,556 2,166,480,896
9 335,667,200 21,093,712 1,952,571,392
10 272,752,640 13,224,709 1,819,402,240
-------------------------------------------------------------
Undo Segment Summary for DB: SNAB Instance: snab Snaps: 1193 -1195
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS# Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- -------------- ---------- -------- ---------- -------- ------ -------------
1 45,903 ########## 61,052 5 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
-> ordered by Time desc
Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/
End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------ -------- ------- -------- ------- ------ -------------
19-Ноя 11:01 18,444 ######## 61,052 3 0 0 0/0/0/0/0/0
19-Ноя 10:51 11,695 ######## 60,354 5 0 0 0/0/0/0/0/0
19-Ноя 10:41 6,414 ######## 60,266 4 0 0 0/0/0/0/0/0
19-Ноя 10:31 9,350 ######## 59,453 3 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB: SNAB Instance: snab Snaps: 1193 -1195
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
active checkpoint queue 37,761 0.0 0 0
alert log latch 8 0.0 0 0
archive control 68 0.0 0 0
archive process latch 56 0.0 0 0
begin backup scn array 296 0.0 0 0
cache buffer handles 206,087 0.0 0.0 0 0
cache buffers chains 513,052,719 0.0 0.0 19 10,059,556 0.0
cache buffers lru chain 180,939 0.6 0.0 0 17,478,681 0.3
channel handle pool latc 7,545 0.0 0 0
channel operations paren 28,010 0.1 0.0 0 0
checkpoint queue latch 5,604,333 0.0 0.0 0 84,149 0.0
child cursor hash table 6,584 0.0 0 0
commit callback allocati 722 0.0 0 0
Consistent RBA 29,722 0.0 0.0 0 0
dml lock allocation 317,974 0.1 0.0 0 0
dummy allocation 405 0.0 0 0
enqueue hash chains 4,371,327 0.2 0.0 0 0
enqueues 3,797,684 0.2 0.0 0 0
event group latch 118 0.0 0 0
FAL request queue 36 0.0 0 0
FIB s.o chain latch 20 0.0 0 0
FOB s.o list latch 1,311 0.0 0 0
hash table column usage 314 0.0 0 1,089,647 0.0
job workq parent latch 3 100.0 0.0 0 155 15.5
job_queue_processes para 62 0.0 0 0
ktm global data 3,165 0.0 0 0
lgwr LWN SCN 29,735 0.0 0.0 0 0
library cache 35,500,166 0.2 0.1 1 6,057 1.2
library cache load lock 3,058 0.0 0 0
library cache pin 33,895,644 0.0 0.0 0 0
library cache pin alloca 1,338,696 0.0 0.0 0 0
list of block allocation 16,276 0.0 0 0
loader state object free 11,344 0.0 0.0 0 0
longop free list parent 2 0.0 0 2 0.0
message pool operations 7,898 0.0 0.0 0 0
messages 206,142 0.0 0.0 0 0
mostly latch-free SCN 30,003 0.2 0.0 0 0
multiblock read objects 1,247,252 0.0 0.0 0 0
ncodef allocation latch 29 0.0 0 0
object stats modificatio 68,653 0.0 0 0
post/wait queue 6,824 0.0 0 3,621 0.0
process allocation 235 0.0 0 118 0.0
process group creation 235 0.0 0 0
redo allocation 2,181,889 0.1 0.0 0 0
redo copy 0 0 2,122,595 0.0
redo writing 128,152 0.0 0.0 0 0
resmgr group change latc 1,860,919 0.0 0.0 0 0
resmgr:actses active lis 407 0.0 0 0
resmgr:actses change gro 26 0.0 0 0
resmgr:actses change sta 35 0.0 0 0
Latch Activity for DB: SNAB Instance: snab Snaps: 1193 -1195
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
resmgr:free threads list 405 0.0 0 0
resmgr:resource group CP 589 0.2 0.0 0 0
resmgr:schema config 1,861,526 0.0 0.0 0 724 0.0
row cache enqueue latch 3,891,144 0.0 0.0 0 0
row cache objects 3,954,741 0.0 0.0 0 1,277 0.0
sequence cache 251,516 0.0 0.0 0 0
session allocation 32,058,522 0.3 0.0 0 0
session idle bit 137,702 0.0 0 0
session switching 33 0.0 0 0
session timer 601 0.0 0 0
shared pool 1,137,637 0.1 0.2 0 0
sim partition latch 0 0 1,340 0.0
simulator hash latch 18,646,167 0.0 0.0 0 0
simulator lru latch 257,703 0.1 0.1 0 522,328 0.1
sort extent pool 27,288 0.0 0.0 0 0
SQL memory manager latch 2 0.0 0 600 0.0
SQL memory manager worka 11,717,253 0.0 0.0 0 0
temp lob duration state 53 0.0 0 0
temporary table state ob 76 0.0 0 0
transaction allocation 2,046 0.0 0 0
transaction branch alloc 29 0.0 0 0
undo global data 709,290 0.0 0.0 0 84 0.0
user lock 232 0.0 0 0
-------------------------------------------------------------
Latch Sleep breakdown for DB: SNAB Instance: snab Snaps: 1193 -1195
-> ordered by misses desc
Get Spin &
Latch Name Requests Misses Sleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers chains 513,052,719 243,738 1,757 241992/1736/
9/1/0
session allocation 32,058,522 94,375 115 94263/109/3/
0/0
library cache 35,500,166 53,565 2,938 50682/2828/5
5/0/0
enqueues 3,797,684 8,632 8 8624/8/0/0/0
enqueue hash chains 4,371,327 7,450 5 7445/5/0/0/0
library cache pin 33,895,644 5,255 21 5234/21/0/0/
0
redo allocation 2,181,889 3,121 6 3115/6/0/0/0
row cache enqueue latch 3,891,144 1,015 1 1014/1/0/0/0
cache buffers lru chain 180,939 997 9 988/9/0/0/0
shared pool 1,137,637 608 95 514/93/1/0/0
row cache objects 3,954,741 549 2 547/2/0/0/0
resmgr group change latch 1,860,919 262 1 261/1/0/0/0
simulator lru latch 257,703 142 18 124/18/0/0/0
SQL memory manager workare 11,717,253 127 2 125/2/0/0/0
messages 206,142 67 3 65/1/1/0/0
channel operations parent 28,010 34 1 33/1/0/0/0
-------------------------------------------------------------
Latch Miss Sources for DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains kcbgtcr: kslbegin excl 0 1,202 1,036
cache buffers chains kcbgtcr: fast path 0 229 56
cache buffers chains kcbrls: kslbegin 0 139 330
cache buffers chains kcbchg: kslbegin: bufs not 0 99 24
cache buffers chains kcbzwb 0 46 14
cache buffers chains kcbgtcr: kslbegin shared 0 15 5
cache buffers chains kcbget: pin buffer 0 7 7
cache buffers chains kcbzib: finish free bufs 0 5 49
cache buffers chains kcbzgb: scan from tail. no 0 4 0
cache buffers chains kcbnew 0 3 0
cache buffers chains kcbgcur: kslbegin 0 2 6
cache buffers chains kcbzib: multi-block read: 0 2 0
cache buffers chains kcbnlc 0 2 82
cache buffers chains kcbget: exchange 0 1 2
cache buffers chains kcbgtcr 0 1 0
cache buffers lru chain kcbzgb: multiple sets nowa 21,408 7 0
cache buffers lru chain kcbbiop: lru scan 990 2 0
channel operations paren ksrmfree() 0 1 0
enqueue hash chains ksqgtl3 0 3 2
enqueue hash chains ksqrcl 0 2 3
enqueues ksqdel 0 6 2
enqueues ksqgel: create enqueue 0 1 5
enqueues ksqies 0 1 1
library cache kglic 0 1,405 4
library cache kglpnc: child 0 295 1,995
library cache kglupc: child 0 189 691
library cache kglpin: child: heap proces 0 145 27
library cache kglpndl: child: before pro 0 68 80
library cache kgllkdl: child: cleanup 0 58 0
library cache kglobpn: child: 0 28 8
library cache kglpnp: child 0 23 74
library cache kglpndl: child: after proc 0 13 2
library cache kglhdgc: child: 0 12 14
library cache kgldti: 2child 0 11 1
library cache kglhdgn: child: 0 11 29
library cache kglhfr: child 0 2 0
library cache kglpin 0 2 2
library cache kglget: child: KGLDSBRD 0 1 2
library cache kglget: child: KGLDSBYD 0 1 4
library cache pin kglpnc: child 0 9 8
library cache pin kglupc 0 6 13
library cache pin kglpnal: child: alloc spac 0 3 0
library cache pin kglpndl 0 2 0
library cache pin kglpnp: child 0 1 0
messages ksaamb: after wakeup 0 1 0
messages ksarcv: after wait 0 1 0
messages ksarcv 0 1 3
redo allocation kcrfwi: before write 0 4 0
redo allocation kcrfwr 0 2 6
resmgr group change latc kskincrstat1 0 1 1
row cache enqueue latch kqreqd 0 1 0
row cache objects kqrpfl: not dirty 0 2 0
session allocation ksuprc 0 72 42
Latch Miss Sources for DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
session allocation ksudlc 0 40 71
session allocation ksucri 0 3 2
shared pool kghfrunp: clatch: nowait 0 656 0
shared pool kghalo 0 71 2
shared pool kghfrunp: alloc: wait 0 21 0
shared pool kghfrunp: clatch: wait 0 19 2
shared pool kghupr1 0 2 91
shared pool kghalp 0 1 0
simulator lru latch kcbs_simulate: simulate se 0 18 18
SQL memory manager worka qesmmIRefreshBound 0 1 0
SQL memory manager worka qesmmIRegisterWorkArea 0 1 1
-------------------------------------------------------------
Parent Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps are shown
-> ordered by name
Get Spin &
Latch Name Requests Misses Sleeps Sleeps 1->4
------------------------ -------------- ----------- ---------- ------------
enqueues 4,056,638 11,642 9 11633/9/0/0/
0
messages 215,320 83 3 81/1/1/0/0
resmgr group change latc 1,990,503 328 5 323/5/0/0/0
row cache enqueue latch 3,890,466 1,015 1 1014/1/0/0/0
session allocation 32,120,084 99,522 120 99405/114/3/
0/0
-------------------------------------------------------------
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 7612 301,824 108 24 84/24/0/0/0
cache buffers chains 3842 207,930 10 4 7/2/1/0/0
cache buffers chains 10619 139,611 19 2 17/2/0/0/0
cache buffers chains 2363 117,187 5 2 3/2/0/0/0
cache buffers chains 15958 114,727 262 69 193/69/0/0/0
cache buffers chains 15956 114,504 245 80 169/72/4/0/0
cache buffers chains 7138 98,848 10 2 8/2/0/0/0
cache buffers chains 581 94,960 6 1 5/1/0/0/0
cache buffers chains 702 93,990 20 1 19/1/0/0/0
cache buffers chains 291 92,139 3 1 2/1/0/0/0
cache buffers chains 1180 89,678 4 1 3/1/0/0/0
cache buffers chains 9969 85,094 10 1 9/1/0/0/0
cache buffers chains 13626 81,748 6 1 5/1/0/0/0
cache buffers chains 15690 81,484 4 2 2/2/0/0/0
cache buffers chains 7792 72,522 6 1 5/1/0/0/0
cache buffers chains 1751 72,443 8 1 7/1/0/0/0
cache buffers chains 12119 70,706 22 2 20/2/0/0/0
cache buffers chains 13215 68,489 20 1 19/1/0/0/0
cache buffers chains 7410 67,095 5 1 4/1/0/0/0
cache buffers chains 12115 67,080 21 2 19/2/0/0/0
cache buffers chains 9284 64,220 6 1 5/1/0/0/0
cache buffers chains 4155 62,909 6 1 5/1/0/0/0
cache buffers chains 5156 62,406 7 1 6/1/0/0/0
cache buffers chains 14577 61,509 5 1 4/1/0/0/0
cache buffers chains 8529 61,110 4 2 2/2/0/0/0
cache buffers chains 9188 58,944 5 1 4/1/0/0/0
cache buffers chains 5075 57,798 6 1 5/1/0/0/0
cache buffers chains 11904 57,173 3 1 2/1/0/0/0
cache buffers chains 11180 55,342 12 1 11/1/0/0/0
cache buffers chains 11872 54,098 11 1 10/1/0/0/0
cache buffers chains 6721 53,896 4 1 3/1/0/0/0
cache buffers chains 2371 52,996 3 1 2/1/0/0/0
cache buffers chains 6707 52,934 5 1 4/1/0/0/0
cache buffers chains 8931 52,683 4 1 3/1/0/0/0
cache buffers chains 9272 52,413 4 1 3/1/0/0/0
cache buffers chains 15954 51,962 119 35 86/32/0/1/0
cache buffers chains 9281 51,871 13 1 12/1/0/0/0
cache buffers chains 9263 51,157 8 1 7/1/0/0/0
cache buffers chains 2416 50,845 7 1 6/1/0/0/0
cache buffers chains 6443 50,783 8 1 7/1/0/0/0
cache buffers chains 11481 50,730 12 1 11/1/0/0/0
cache buffers chains 561 50,481 5 1 4/1/0/0/0
cache buffers chains 636 49,517 7 2 5/2/0/0/0
cache buffers chains 2391 49,386 12 1 11/1/0/0/0
cache buffers chains 11201 49,309 4 1 3/1/0/0/0
cache buffers chains 1176 48,508 9 1 8/1/0/0/0
cache buffers chains 4259 48,474 7 1 6/1/0/0/0
cache buffers chains 15957 47,960 55 15 40/15/0/0/0
cache buffers chains 7785 47,843 6 1 5/1/0/0/0
cache buffers chains 8422 47,613 3 1 2/1/0/0/0
cache buffers chains 2038 46,759 6 1 5/1/0/0/0
cache buffers chains 13427 46,551 7 1 6/1/0/0/0
cache buffers chains 13309 46,288 6 1 5/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 11913 46,279 6 1 5/1/0/0/0
cache buffers chains 11500 46,172 7 1 6/1/0/0/0
cache buffers chains 11538 45,805 6 1 5/1/0/0/0
cache buffers chains 14030 45,675 6 1 5/1/0/0/0
cache buffers chains 11125 45,584 7 1 6/1/0/0/0
cache buffers chains 2378 45,461 3 1 2/1/0/0/0
cache buffers chains 11439 45,223 5 1 4/1/0/0/0
cache buffers chains 9899 44,127 9 2 7/2/0/0/0
cache buffers chains 9232 43,103 7 1 6/1/0/0/0
cache buffers chains 13246 42,758 5 1 4/1/0/0/0
cache buffers chains 14486 42,050 10 1 9/1/0/0/0
cache buffers chains 8641 41,582 8 1 7/1/0/0/0
cache buffers chains 11524 41,531 7 1 6/1/0/0/0
cache buffers chains 7313 41,525 5 1 4/1/0/0/0
cache buffers chains 8614 41,446 6 1 5/1/0/0/0
cache buffers chains 7260 41,373 11 1 10/1/0/0/0
cache buffers chains 9240 41,014 3 1 2/1/0/0/0
cache buffers chains 5191 40,939 5 1 4/1/0/0/0
cache buffers chains 5124 40,430 7 1 6/1/0/0/0
cache buffers chains 7250 40,299 9 1 8/1/0/0/0
cache buffers chains 15955 39,948 105 35 71/33/1/0/0
cache buffers chains 496 39,792 4 1 3/1/0/0/0
cache buffers chains 833 39,686 4 1 3/1/0/0/0
cache buffers chains 9172 39,198 3 1 2/1/0/0/0
cache buffers chains 6675 38,763 9 1 8/1/0/0/0
cache buffers chains 6703 38,604 11 1 10/1/0/0/0
cache buffers chains 11484 38,562 7 1 6/1/0/0/0
cache buffers chains 5180 38,365 8 1 7/1/0/0/0
cache buffers chains 7316 38,321 2 1 1/1/0/0/0
cache buffers chains 6759 38,269 4 1 3/1/0/0/0
cache buffers chains 3292 38,247 4 1 3/1/0/0/0
cache buffers chains 371 38,201 7 1 6/1/0/0/0
cache buffers chains 6552 38,145 8 1 7/1/0/0/0
cache buffers chains 1932 37,907 7 1 6/1/0/0/0
cache buffers chains 13183 37,544 1 1 0/1/0/0/0
cache buffers chains 5217 37,510 7 1 6/1/0/0/0
cache buffers chains 14580 37,509 5 1 4/1/0/0/0
cache buffers chains 7633 37,446 10 1 9/1/0/0/0
cache buffers chains 9286 37,403 6 1 5/1/0/0/0
cache buffers chains 11482 37,378 5 1 4/1/0/0/0
cache buffers chains 7329 37,224 9 1 8/1/0/0/0
cache buffers chains 9219 36,979 6 1 5/1/0/0/0
cache buffers chains 6237 36,797 4 1 3/1/0/0/0
cache buffers chains 12622 36,708 5 1 4/1/0/0/0
cache buffers chains 6600 36,693 5 1 4/1/0/0/0
cache buffers chains 6312 36,579 11 1 10/1/0/0/0
cache buffers chains 5127 36,505 5 1 4/1/0/0/0
cache buffers chains 2403 36,399 5 1 4/1/0/0/0
cache buffers chains 8443 36,198 10 1 9/1/0/0/0
cache buffers chains 7771 36,059 5 1 4/1/0/0/0
cache buffers chains 1219 35,746 11 2 9/2/0/0/0
cache buffers chains 14588 35,641 3 1 2/1/0/0/0
cache buffers chains 8441 35,615 5 1 4/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 2057 35,243 8 1 7/1/0/0/0
cache buffers chains 8411 35,238 8 1 7/1/0/0/0
cache buffers chains 5131 35,219 5 1 4/1/0/0/0
cache buffers chains 6598 35,131 6 1 5/1/0/0/0
cache buffers chains 8340 35,129 4 1 3/1/0/0/0
cache buffers chains 8646 34,775 4 1 3/1/0/0/0
cache buffers chains 7185 34,585 8 1 7/1/0/0/0
cache buffers chains 7859 34,464 3 1 2/1/0/0/0
cache buffers chains 9050 34,456 3 1 2/1/0/0/0
cache buffers chains 8353 34,139 3 1 2/1/0/0/0
cache buffers chains 13483 34,088 9 1 8/1/0/0/0
cache buffers chains 6466 33,868 5 1 4/1/0/0/0
cache buffers chains 6812 33,867 6 1 5/1/0/0/0
cache buffers chains 12316 33,714 9 1 8/1/0/0/0
cache buffers chains 9452 33,685 3 1 2/1/0/0/0
cache buffers chains 7807 33,533 4 1 3/1/0/0/0
cache buffers chains 6529 33,520 6 1 5/1/0/0/0
cache buffers chains 7449 33,380 4 1 3/1/0/0/0
cache buffers chains 6465 33,339 5 2 3/2/0/0/0
cache buffers chains 7401 33,259 4 1 3/1/0/0/0
cache buffers chains 11966 33,240 3 1 2/1/0/0/0
cache buffers chains 11219 33,188 5 1 4/1/0/0/0
cache buffers chains 11473 32,940 6 1 5/1/0/0/0
cache buffers chains 7373 32,876 5 1 4/1/0/0/0
cache buffers chains 7761 32,695 6 1 5/1/0/0/0
cache buffers chains 6172 32,684 11 1 10/1/0/0/0
cache buffers chains 8836 32,681 2 1 1/1/0/0/0
cache buffers chains 5142 32,499 2 1 1/1/0/0/0
cache buffers chains 10340 32,447 7 1 6/1/0/0/0
cache buffers chains 6487 32,433 3 1 2/1/0/0/0
cache buffers chains 2414 32,363 5 1 4/1/0/0/0
cache buffers chains 2444 32,348 6 1 5/1/0/0/0
cache buffers chains 15657 32,341 29 1 28/1/0/0/0
cache buffers chains 8330 32,258 4 1 3/1/0/0/0
cache buffers chains 6511 32,192 8 1 7/1/0/0/0
cache buffers chains 6434 32,191 1 1 0/1/0/0/0
cache buffers chains 13306 32,118 3 1 2/1/0/0/0
cache buffers chains 6691 32,014 11 1 10/1/0/0/0
cache buffers chains 7846 31,772 4 1 3/1/0/0/0
cache buffers chains 11142 31,752 3 1 2/1/0/0/0
cache buffers chains 6972 31,733 3 1 2/1/0/0/0
cache buffers chains 11911 31,693 6 1 5/1/0/0/0
cache buffers chains 13400 31,680 6 1 5/1/0/0/0
cache buffers chains 8670 31,634 5 1 4/1/0/0/0
cache buffers chains 8632 31,621 3 1 2/1/0/0/0
cache buffers chains 2268 31,385 7 1 6/1/0/0/0
cache buffers chains 8258 31,355 5 1 4/1/0/0/0
cache buffers chains 11138 31,293 6 1 5/1/0/0/0
cache buffers chains 6537 31,281 7 1 6/1/0/0/0
cache buffers chains 15297 31,211 5 1 4/1/0/0/0
cache buffers chains 3281 31,180 9 1 8/1/0/0/0
cache buffers chains 10148 31,158 8 1 7/1/0/0/0
cache buffers chains 6495 31,127 5 1 4/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 15716 31,078 6 1 5/1/0/0/0
cache buffers chains 10279 30,851 11 1 10/1/0/0/0
cache buffers chains 4790 30,848 5 1 4/1/0/0/0
cache buffers chains 10335 30,817 4 1 3/1/0/0/0
cache buffers chains 4429 30,747 6 1 5/1/0/0/0
cache buffers chains 490 30,641 1 1 0/1/0/0/0
cache buffers chains 13307 30,620 10 1 9/1/0/0/0
cache buffers chains 12278 30,401 4 1 3/1/0/0/0
cache buffers chains 2339 30,235 16 2 14/2/0/0/0
cache buffers chains 14622 30,229 5 1 4/1/0/0/0
cache buffers chains 12783 30,195 6 1 5/1/0/0/0
cache buffers chains 13584 30,149 5 1 4/1/0/0/0
cache buffers chains 10300 29,834 6 1 5/1/0/0/0
cache buffers chains 10240 29,819 6 1 5/1/0/0/0
cache buffers chains 362 29,770 7 1 6/1/0/0/0
cache buffers chains 594 29,631 7 1 6/1/0/0/0
cache buffers chains 4480 29,622 6 1 5/1/0/0/0
cache buffers chains 7683 29,513 4 1 3/1/0/0/0
cache buffers chains 12780 29,392 9 2 7/2/0/0/0
cache buffers chains 7782 29,177 6 1 5/1/0/0/0
cache buffers chains 10211 29,111 4 1 3/1/0/0/0
cache buffers chains 2939 28,999 2 1 1/1/0/0/0
cache buffers chains 4521 28,637 11 1 10/1/0/0/0
cache buffers chains 13528 28,636 4 1 3/1/0/0/0
cache buffers chains 4497 28,583 3 1 2/1/0/0/0
cache buffers chains 13026 28,552 3 1 2/1/0/0/0
cache buffers chains 9821 28,545 8 1 7/1/0/0/0
cache buffers chains 5203 28,495 6 1 5/1/0/0/0
cache buffers chains 11697 28,470 3 1 2/1/0/0/0
cache buffers chains 327 28,315 7 1 6/1/0/0/0
cache buffers chains 15725 28,293 5 1 4/1/0/0/0
cache buffers chains 4493 28,289 5 1 4/1/0/0/0
cache buffers chains 6170 28,189 5 1 4/1/0/0/0
cache buffers chains 11068 27,885 4 1 3/1/0/0/0
cache buffers chains 2531 27,658 1 1 0/1/0/0/0
cache buffers chains 872 27,619 3 1 2/1/0/0/0
cache buffers chains 9873 27,534 7 2 5/2/0/0/0
cache buffers chains 15386 27,370 6 1 5/1/0/0/0
cache buffers chains 8280 27,325 4 1 3/1/0/0/0
cache buffers chains 13505 27,259 5 1 4/1/0/0/0
cache buffers chains 13460 27,238 5 1 4/1/0/0/0
cache buffers chains 3276 27,213 9 1 8/1/0/0/0
cache buffers chains 14439 27,213 7 1 6/1/0/0/0
cache buffers chains 4026 27,191 5 1 4/1/0/0/0
cache buffers chains 11236 27,176 5 1 4/1/0/0/0
cache buffers chains 2275 27,169 13 1 12/1/0/0/0
cache buffers chains 13813 27,154 3 1 2/1/0/0/0
cache buffers chains 2321 27,152 4 1 3/1/0/0/0
cache buffers chains 5345 27,106 3 1 2/1/0/0/0
cache buffers chains 5118 27,099 3 1 2/1/0/0/0
cache buffers chains 11756 27,066 7 1 6/1/0/0/0
cache buffers chains 4940 27,051 4 1 3/1/0/0/0
cache buffers chains 11740 26,983 5 1 4/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 5296 26,821 2 1 1/1/0/0/0
cache buffers chains 9676 26,808 4 2 2/2/0/0/0
cache buffers chains 8393 26,791 4 1 3/1/0/0/0
cache buffers chains 9884 26,700 5 1 4/1/0/0/0
cache buffers chains 7860 26,680 9 1 8/1/0/0/0
cache buffers chains 9695 26,521 6 1 5/1/0/0/0
cache buffers chains 9678 26,509 7 1 6/1/0/0/0
cache buffers chains 15676 26,480 10 1 9/1/0/0/0
cache buffers chains 11583 26,440 12 1 11/1/0/0/0
cache buffers chains 11716 26,381 5 1 4/1/0/0/0
cache buffers chains 4937 26,249 6 1 5/1/0/0/0
cache buffers chains 6496 26,211 5 1 4/1/0/0/0
cache buffers chains 14053 26,181 9 1 8/1/0/0/0
cache buffers chains 2211 26,146 2 1 1/1/0/0/0
cache buffers chains 9589 26,123 6 2 4/2/0/0/0
cache buffers chains 5403 26,111 5 1 4/1/0/0/0
cache buffers chains 15097 26,081 9 1 8/1/0/0/0
cache buffers chains 12268 26,003 8 1 7/1/0/0/0
cache buffers chains 11617 25,954 2 1 1/1/0/0/0
cache buffers chains 13465 25,932 4 1 3/1/0/0/0
cache buffers chains 11591 25,813 5 1 4/1/0/0/0
cache buffers chains 11844 25,813 3 1 2/1/0/0/0
cache buffers chains 11707 25,771 7 2 5/2/0/0/0
cache buffers chains 635 25,656 5 1 4/1/0/0/0
cache buffers chains 6682 25,608 11 1 10/1/0/0/0
cache buffers chains 5441 25,581 7 1 6/1/0/0/0
cache buffers chains 13330 25,563 7 1 6/1/0/0/0
cache buffers chains 13973 25,489 2 1 1/1/0/0/0
cache buffers chains 6644 25,434 8 1 7/1/0/0/0
cache buffers chains 11457 25,410 12 1 11/1/0/0/0
cache buffers chains 6665 25,352 10 1 9/1/0/0/0
cache buffers chains 7835 25,285 4 1 3/1/0/0/0
cache buffers chains 14797 25,277 6 1 5/1/0/0/0
cache buffers chains 3395 25,243 5 1 4/1/0/0/0
cache buffers chains 6658 25,187 7 1 6/1/0/0/0
cache buffers chains 10506 25,157 6 1 5/1/0/0/0
cache buffers chains 13284 25,108 9 1 8/1/0/0/0
cache buffers chains 13529 25,062 7 1 6/1/0/0/0
cache buffers chains 15361 24,937 9 1 8/1/0/0/0
cache buffers chains 5275 24,815 4 1 3/1/0/0/0
cache buffers chains 11641 24,808 6 1 5/1/0/0/0
cache buffers chains 11670 24,690 6 1 5/1/0/0/0
cache buffers chains 8538 24,645 3 1 2/1/0/0/0
cache buffers chains 13658 24,608 7 1 6/1/0/0/0
cache buffers chains 4555 24,603 5 1 4/1/0/0/0
cache buffers chains 4532 24,557 6 1 5/1/0/0/0
cache buffers chains 6897 24,547 3 1 2/1/0/0/0
cache buffers chains 7306 24,538 4 1 3/1/0/0/0
cache buffers chains 4514 24,440 7 1 6/1/0/0/0
cache buffers chains 3921 24,368 4 1 3/1/0/0/0
cache buffers chains 16224 24,365 3 1 2/1/0/0/0
cache buffers chains 5098 24,262 6 1 5/1/0/0/0
cache buffers chains 11559 24,150 8 1 7/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 11390 24,121 9 1 8/1/0/0/0
cache buffers chains 13563 24,091 5 1 4/1/0/0/0
cache buffers chains 4511 23,960 6 1 5/1/0/0/0
cache buffers chains 12257 23,942 6 2 4/2/0/0/0
cache buffers chains 11575 23,933 12 1 11/1/0/0/0
cache buffers chains 10500 23,845 7 1 6/1/0/0/0
cache buffers chains 16112 23,830 12 1 11/1/0/0/0
cache buffers chains 15346 23,699 9 1 8/1/0/0/0
cache buffers chains 3701 23,695 7 1 6/1/0/0/0
cache buffers chains 4515 23,607 5 1 4/1/0/0/0
cache buffers chains 11613 23,588 8 1 7/1/0/0/0
cache buffers chains 11504 23,524 6 1 5/1/0/0/0
cache buffers chains 11489 23,465 4 1 3/1/0/0/0
cache buffers chains 7850 23,453 6 1 5/1/0/0/0
cache buffers chains 11080 23,388 9 1 8/1/0/0/0
cache buffers chains 15244 23,322 5 1 4/1/0/0/0
cache buffers chains 13570 23,287 8 1 7/1/0/0/0
cache buffers chains 12898 23,271 2 1 1/1/0/0/0
cache buffers chains 5440 23,221 6 1 5/1/0/0/0
cache buffers chains 1323 23,191 9 1 8/1/0/0/0
cache buffers chains 13349 23,107 7 1 6/1/0/0/0
cache buffers chains 11589 22,986 6 1 5/1/0/0/0
cache buffers chains 5294 22,761 11 1 10/1/0/0/0
cache buffers chains 7503 22,635 3 1 2/1/0/0/0
cache buffers chains 10105 22,605 5 1 4/1/0/0/0
cache buffers chains 13160 22,573 5 1 4/1/0/0/0
cache buffers chains 10510 22,563 4 1 3/1/0/0/0
cache buffers chains 15750 22,534 6 1 5/1/0/0/0
cache buffers chains 13448 22,343 5 1 4/1/0/0/0
cache buffers chains 14818 22,336 10 1 9/1/0/0/0
cache buffers chains 1299 22,306 6 1 5/1/0/0/0
cache buffers chains 14856 22,237 7 1 6/1/0/0/0
cache buffers chains 14715 22,169 3 1 2/1/0/0/0
cache buffers chains 212 22,156 9 1 8/1/0/0/0
cache buffers chains 10262 22,095 2 1 1/1/0/0/0
cache buffers chains 4442 22,093 3 1 2/1/0/0/0
cache buffers chains 15704 22,069 4 1 3/1/0/0/0
cache buffers chains 5737 22,036 10 3 8/1/1/0/0
cache buffers chains 11247 22,025 6 1 5/1/0/0/0
cache buffers chains 4017 21,972 8 1 7/1/0/0/0
cache buffers chains 783 21,842 9 1 8/1/0/0/0
cache buffers chains 13471 21,825 7 2 5/2/0/0/0
cache buffers chains 13907 21,799 5 1 4/1/0/0/0
cache buffers chains 11977 21,793 3 1 2/1/0/0/0
cache buffers chains 15746 21,751 4 1 3/1/0/0/0
cache buffers chains 9024 21,736 4 1 3/1/0/0/0
cache buffers chains 15376 21,728 9 1 8/1/0/0/0
cache buffers chains 9073 21,662 7 1 6/1/0/0/0
cache buffers chains 9180 21,616 3 1 2/1/0/0/0
cache buffers chains 15398 21,570 10 1 9/1/0/0/0
cache buffers chains 11135 21,559 9 1 8/1/0/0/0
cache buffers chains 11398 21,533 6 1 5/1/0/0/0
cache buffers chains 5360 21,482 6 1 5/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 2729 21,431 11 1 10/1/0/0/0
cache buffers chains 8374 21,424 9 1 8/1/0/0/0
cache buffers chains 8561 21,417 2 1 1/1/0/0/0
cache buffers chains 4047 21,183 4 1 3/1/0/0/0
cache buffers chains 6689 21,076 5 1 4/1/0/0/0
cache buffers chains 5530 21,062 3 1 2/1/0/0/0
cache buffers chains 13928 20,847 7 1 6/1/0/0/0
cache buffers chains 4660 20,758 2 1 1/1/0/0/0
cache buffers chains 12810 20,681 10 1 9/1/0/0/0
cache buffers chains 14752 20,653 5 1 4/1/0/0/0
cache buffers chains 13280 20,548 5 1 4/1/0/0/0
cache buffers chains 7322 20,525 8 1 7/1/0/0/0
cache buffers chains 14962 20,524 7 1 6/1/0/0/0
cache buffers chains 15066 20,407 7 1 6/1/0/0/0
cache buffers chains 643 20,396 5 1 4/1/0/0/0
cache buffers chains 3710 20,379 7 1 6/1/0/0/0
cache buffers chains 8601 20,365 3 1 2/1/0/0/0
cache buffers chains 14589 20,365 5 1 4/1/0/0/0
cache buffers chains 12935 20,347 5 1 4/1/0/0/0
cache buffers chains 8007 20,293 6 1 5/1/0/0/0
cache buffers chains 4639 20,044 2 1 1/1/0/0/0
cache buffers chains 73 20,043 2 1 1/1/0/0/0
cache buffers chains 9681 20,018 4 1 3/1/0/0/0
cache buffers chains 2566 19,921 3 1 2/1/0/0/0
cache buffers chains 11985 19,904 5 1 4/1/0/0/0
cache buffers chains 7233 19,887 7 1 6/1/0/0/0
cache buffers chains 4588 19,786 2 1 1/1/0/0/0
cache buffers chains 14201 19,783 6 1 5/1/0/0/0
cache buffers chains 11216 19,752 4 1 3/1/0/0/0
cache buffers chains 420 19,736 6 1 5/1/0/0/0
cache buffers chains 6227 19,724 6 1 5/1/0/0/0
cache buffers chains 7427 19,708 2 1 1/1/0/0/0
cache buffers chains 14512 19,693 6 1 5/1/0/0/0
cache buffers chains 6801 19,658 7 1 6/1/0/0/0
cache buffers chains 6032 19,649 9 1 8/1/0/0/0
cache buffers chains 9320 19,646 6 1 5/1/0/0/0
cache buffers chains 11211 19,626 8 1 7/1/0/0/0
cache buffers chains 9033 19,607 4 1 3/1/0/0/0
cache buffers chains 3679 19,580 4 1 3/1/0/0/0
cache buffers chains 8990 19,570 5 1 4/1/0/0/0
cache buffers chains 9686 19,523 6 1 5/1/0/0/0
cache buffers chains 13177 19,457 4 1 3/1/0/0/0
cache buffers chains 13422 19,435 10 1 9/1/0/0/0
cache buffers chains 4570 19,373 4 2 2/2/0/0/0
cache buffers chains 2465 19,363 9 1 8/1/0/0/0
cache buffers chains 6144 19,345 7 2 5/2/0/0/0
cache buffers chains 15085 19,327 6 1 5/1/0/0/0
cache buffers chains 8047 19,288 8 1 7/1/0/0/0
cache buffers chains 4554 19,230 6 1 5/1/0/0/0
cache buffers chains 15313 19,213 5 1 4/1/0/0/0
cache buffers chains 9011 19,208 4 1 3/1/0/0/0
cache buffers chains 7581 19,192 9 1 8/1/0/0/0
cache buffers chains 15394 19,190 6 1 5/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 15334 19,175 6 1 5/1/0/0/0
cache buffers chains 13038 19,165 11 1 10/1/0/0/0
cache buffers chains 15983 19,164 16 1 15/1/0/0/0
cache buffers chains 8913 19,144 3 1 2/1/0/0/0
cache buffers chains 13041 19,114 5 1 4/1/0/0/0
cache buffers chains 945 19,077 4 1 3/1/0/0/0
cache buffers chains 9023 19,045 8 2 6/2/0/0/0
cache buffers chains 12657 18,957 8 1 7/1/0/0/0
cache buffers chains 4619 18,944 4 1 3/1/0/0/0
cache buffers chains 9325 18,848 6 1 5/1/0/0/0
cache buffers chains 9000 18,797 5 1 4/1/0/0/0
cache buffers chains 2833 18,751 9 1 8/1/0/0/0
cache buffers chains 7331 18,718 2 1 1/1/0/0/0
cache buffers chains 3667 18,677 2 1 1/1/0/0/0
cache buffers chains 15988 18,657 7 1 6/1/0/0/0
cache buffers chains 12870 18,645 5 1 4/1/0/0/0
cache buffers chains 12130 18,640 8 1 7/1/0/0/0
cache buffers chains 13583 18,510 6 1 5/1/0/0/0
cache buffers chains 2534 18,491 5 1 4/1/0/0/0
cache buffers chains 4945 18,482 3 1 2/1/0/0/0
cache buffers chains 12611 18,479 3 1 2/1/0/0/0
cache buffers chains 15809 18,472 10 1 9/1/0/0/0
cache buffers chains 15341 18,405 8 1 7/1/0/0/0
cache buffers chains 7217 18,402 7 1 6/1/0/0/0
cache buffers chains 238 18,386 2 1 1/1/0/0/0
cache buffers chains 12912 18,378 8 1 7/1/0/0/0
cache buffers chains 3769 18,287 5 1 4/1/0/0/0
cache buffers chains 15054 18,284 18 1 17/1/0/0/0
cache buffers chains 481 18,242 3 1 2/1/0/0/0
cache buffers chains 4550 18,171 6 1 5/1/0/0/0
cache buffers chains 8245 18,138 12 1 11/1/0/0/0
cache buffers chains 12656 18,132 5 1 4/1/0/0/0
cache buffers chains 7649 18,122 8 1 7/1/0/0/0
cache buffers chains 9329 17,992 8 1 7/1/0/0/0
cache buffers chains 196 17,935 6 1 5/1/0/0/0
cache buffers chains 9707 17,929 4 1 3/1/0/0/0
cache buffers chains 6117 17,898 4 1 3/1/0/0/0
cache buffers chains 13128 17,886 6 1 5/1/0/0/0
cache buffers chains 8929 17,874 8 2 6/2/0/0/0
cache buffers chains 4746 17,871 5 1 4/1/0/0/0
cache buffers chains 15769 17,849 39 1 38/1/0/0/0
cache buffers chains 9114 17,702 5 1 4/1/0/0/0
cache buffers chains 14033 17,642 6 1 5/1/0/0/0
cache buffers chains 12904 17,606 1 1 0/1/0/0/0
cache buffers chains 917 17,582 12 1 11/1/0/0/0
cache buffers chains 12674 17,565 5 1 4/1/0/0/0
cache buffers chains 12571 17,548 7 1 6/1/0/0/0
cache buffers chains 2001 17,488 3 1 2/1/0/0/0
cache buffers chains 12704 17,435 1 1 0/1/0/0/0
cache buffers chains 10069 17,351 8 1 7/1/0/0/0
cache buffers chains 7193 17,336 5 1 4/1/0/0/0
cache buffers chains 12397 17,271 11 2 9/2/0/0/0
cache buffers chains 12557 17,271 4 1 3/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 6020 17,250 9 1 8/1/0/0/0
cache buffers chains 5569 17,234 3 1 2/1/0/0/0
cache buffers chains 7938 17,226 6 1 5/1/0/0/0
cache buffers chains 15372 17,150 6 1 5/1/0/0/0
cache buffers chains 2874 17,095 2 1 1/1/0/0/0
cache buffers chains 4689 17,084 6 2 4/2/0/0/0
cache buffers chains 15374 17,021 10 1 9/1/0/0/0
cache buffers chains 9128 17,014 4 1 3/1/0/0/0
cache buffers chains 16000 16,990 10 1 9/1/0/0/0
cache buffers chains 5342 16,989 7 1 6/1/0/0/0
cache buffers chains 6096 16,972 9 1 8/1/0/0/0
cache buffers chains 3335 16,936 3 1 2/1/0/0/0
cache buffers chains 12949 16,933 4 1 3/1/0/0/0
cache buffers chains 4720 16,909 9 1 8/1/0/0/0
cache buffers chains 8596 16,881 2 1 1/1/0/0/0
cache buffers chains 12669 16,880 5 1 4/1/0/0/0
cache buffers chains 15611 16,830 7 1 6/1/0/0/0
cache buffers chains 9026 16,789 3 1 2/1/0/0/0
cache buffers chains 15859 16,783 6 2 4/2/0/0/0
cache buffers chains 8045 16,774 6 1 5/1/0/0/0
cache buffers chains 2838 16,754 5 1 4/1/0/0/0
cache buffers chains 6116 16,751 2 1 1/1/0/0/0
cache buffers chains 11944 16,745 7 1 6/1/0/0/0
cache buffers chains 12844 16,718 14 1 13/1/0/0/0
cache buffers chains 5681 16,716 4 1 3/1/0/0/0
cache buffers chains 9574 16,716 6 1 5/1/0/0/0
cache buffers chains 12907 16,668 4 1 3/1/0/0/0
cache buffers chains 6024 16,578 3 1 2/1/0/0/0
cache buffers chains 14732 16,528 5 1 4/1/0/0/0
cache buffers chains 9135 16,522 6 1 5/1/0/0/0
cache buffers chains 12512 16,451 6 1 5/1/0/0/0
cache buffers chains 9582 16,412 6 1 5/1/0/0/0
cache buffers chains 7727 16,347 6 1 5/1/0/0/0
cache buffers chains 4418 16,322 4 1 3/1/0/0/0
cache buffers chains 12966 16,298 9 1 8/1/0/0/0
cache buffers chains 4709 16,296 3 1 2/1/0/0/0
cache buffers chains 5564 16,258 4 1 3/1/0/0/0
cache buffers chains 15457 16,249 14 1 13/1/0/0/0
cache buffers chains 15570 16,240 8 1 7/1/0/0/0
cache buffers chains 12743 16,207 6 1 5/1/0/0/0
cache buffers chains 12922 16,158 11 1 10/1/0/0/0
cache buffers chains 9610 16,138 9 1 8/1/0/0/0
cache buffers chains 5633 16,093 3 1 2/1/0/0/0
cache buffers chains 9633 16,067 2 1 1/1/0/0/0
cache buffers chains 8763 16,034 4 1 3/1/0/0/0
cache buffers chains 12200 16,034 10 1 9/1/0/0/0
cache buffers chains 1501 16,002 8 1 7/1/0/0/0
cache buffers chains 5638 15,992 4 1 3/1/0/0/0
cache buffers chains 15039 15,959 8 1 7/1/0/0/0
cache buffers chains 12529 15,892 10 2 8/2/0/0/0
cache buffers chains 12723 15,862 5 1 4/1/0/0/0
cache buffers chains 13169 15,847 3 1 2/1/0/0/0
cache buffers chains 13118 15,815 2 1 1/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 14139 15,803 8 1 7/1/0/0/0
cache buffers chains 15772 15,790 5 1 4/1/0/0/0
cache buffers chains 12599 15,722 3 1 2/1/0/0/0
cache buffers chains 15395 15,716 8 1 7/1/0/0/0
cache buffers chains 12701 15,633 8 2 6/2/0/0/0
cache buffers chains 15126 15,607 6 1 5/1/0/0/0
cache buffers chains 15796 15,602 7 1 6/1/0/0/0
cache buffers chains 5657 15,601 5 1 4/1/0/0/0
cache buffers chains 7375 15,596 6 1 5/1/0/0/0
cache buffers chains 11869 15,593 7 2 5/2/0/0/0
cache buffers chains 14074 15,585 9 1 8/1/0/0/0
cache buffers chains 14276 15,573 7 1 6/1/0/0/0
cache buffers chains 3120 15,544 2 1 1/1/0/0/0
cache buffers chains 12180 15,539 7 1 6/1/0/0/0
cache buffers chains 15977 15,520 6 1 5/1/0/0/0
cache buffers chains 14582 15,497 6 1 5/1/0/0/0
cache buffers chains 12833 15,451 6 1 5/1/0/0/0
cache buffers chains 15058 15,435 2 1 1/1/0/0/0
cache buffers chains 213 15,417 3 1 2/1/0/0/0
cache buffers chains 15422 15,417 10 2 8/2/0/0/0
cache buffers chains 12177 15,386 3 1 2/1/0/0/0
cache buffers chains 16040 15,362 3 1 2/1/0/0/0
cache buffers chains 2767 15,359 4 1 3/1/0/0/0
cache buffers chains 13113 15,313 10 1 9/1/0/0/0
cache buffers chains 4289 15,309 8 1 7/1/0/0/0
cache buffers chains 12425 15,306 8 1 7/1/0/0/0
cache buffers chains 11978 15,271 3 1 2/1/0/0/0
cache buffers chains 16021 15,270 5 1 4/1/0/0/0
cache buffers chains 8817 15,252 5 1 4/1/0/0/0
cache buffers chains 4990 15,245 3 1 2/1/0/0/0
cache buffers chains 7628 15,228 3 1 2/1/0/0/0
cache buffers chains 14049 15,182 5 1 4/1/0/0/0
cache buffers chains 12955 15,117 5 1 4/1/0/0/0
cache buffers chains 7208 15,111 10 1 9/1/0/0/0
cache buffers chains 5486 15,107 5 1 4/1/0/0/0
cache buffers chains 13057 15,092 3 1 2/1/0/0/0
cache buffers chains 5897 15,041 10 1 9/1/0/0/0
cache buffers chains 8795 15,024 5 1 4/1/0/0/0
cache buffers chains 15502 14,986 3 1 2/1/0/0/0
cache buffers chains 6990 14,940 5 1 4/1/0/0/0
cache buffers chains 15555 14,916 5 2 3/2/0/0/0
cache buffers chains 12985 14,913 5 1 4/1/0/0/0
cache buffers chains 6 14,873 5 1 4/1/0/0/0
cache buffers chains 13130 14,854 3 2 1/2/0/0/0
cache buffers chains 9702 14,842 5 1 4/1/0/0/0
cache buffers chains 13986 14,804 6 1 5/1/0/0/0
cache buffers chains 7528 14,795 8 1 7/1/0/0/0
cache buffers chains 6962 14,791 4 1 3/1/0/0/0
cache buffers chains 3290 14,790 11 1 10/1/0/0/0
cache buffers chains 6874 14,782 4 1 3/1/0/0/0
cache buffers chains 145 14,741 3 1 2/1/0/0/0
cache buffers chains 9603 14,672 7 1 6/1/0/0/0
cache buffers chains 12510 14,636 7 1 6/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 8024 14,627 4 1 3/1/0/0/0
cache buffers chains 12769 14,626 7 1 6/1/0/0/0
cache buffers chains 15463 14,618 6 1 5/1/0/0/0
cache buffers chains 4268 14,610 8 1 7/1/0/0/0
cache buffers chains 13137 14,586 10 1 9/1/0/0/0
cache buffers chains 15801 14,579 6 1 5/1/0/0/0
cache buffers chains 465 14,554 6 1 5/1/0/0/0
cache buffers chains 6884 14,526 3 1 2/1/0/0/0
cache buffers chains 14103 14,519 3 1 2/1/0/0/0
cache buffers chains 6991 14,509 3 1 2/1/0/0/0
cache buffers chains 6071 14,498 7 1 6/1/0/0/0
cache buffers chains 5689 14,492 6 1 5/1/0/0/0
cache buffers chains 285 14,446 7 1 6/1/0/0/0
cache buffers chains 5053 14,415 5 1 4/1/0/0/0
cache buffers chains 12178 14,356 6 1 5/1/0/0/0
cache buffers chains 3302 14,351 3 1 2/1/0/0/0
cache buffers chains 14335 14,315 5 1 4/1/0/0/0
cache buffers chains 14865 14,296 8 1 7/1/0/0/0
cache buffers chains 6339 14,289 4 1 3/1/0/0/0
cache buffers chains 9368 14,288 4 1 3/1/0/0/0
cache buffers chains 12216 14,284 6 1 5/1/0/0/0
cache buffers chains 6246 14,279 4 1 3/1/0/0/0
cache buffers chains 2472 14,277 8 1 7/1/0/0/0
cache buffers chains 6946 14,269 9 1 8/1/0/0/0
cache buffers chains 14321 14,243 5 1 4/1/0/0/0
cache buffers chains 2386 14,226 7 1 6/1/0/0/0
cache buffers chains 2097 14,218 9 1 8/1/0/0/0
cache buffers chains 12407 14,185 12 1 11/1/0/0/0
cache buffers chains 8061 14,159 3 1 2/1/0/0/0
cache buffers chains 314 14,124 5 1 4/1/0/0/0
cache buffers chains 16065 14,104 7 1 6/1/0/0/0
cache buffers chains 4087 14,065 6 1 5/1/0/0/0
cache buffers chains 15089 14,033 5 1 4/1/0/0/0
cache buffers chains 286 13,983 8 1 7/1/0/0/0
cache buffers chains 1969 13,936 9 1 8/1/0/0/0
cache buffers chains 7681 13,859 3 1 2/1/0/0/0
cache buffers chains 3655 13,852 4 1 3/1/0/0/0
cache buffers chains 7841 13,841 3 1 2/1/0/0/0
cache buffers chains 2537 13,829 8 1 7/1/0/0/0
cache buffers chains 3036 13,825 5 1 4/1/0/0/0
cache buffers chains 2849 13,821 9 1 8/1/0/0/0
cache buffers chains 12192 13,796 7 1 6/1/0/0/0
cache buffers chains 14378 13,768 6 1 5/1/0/0/0
cache buffers chains 251 13,719 5 2 3/2/0/0/0
cache buffers chains 2563 13,696 3 1 2/1/0/0/0
cache buffers chains 9539 13,662 3 1 2/1/0/0/0
cache buffers chains 6925 13,642 3 1 2/1/0/0/0
cache buffers chains 9523 13,582 2 1 1/1/0/0/0
cache buffers chains 16023 13,573 10 1 9/1/0/0/0
cache buffers chains 12095 13,444 3 1 2/1/0/0/0
cache buffers chains 13950 13,422 5 1 4/1/0/0/0
cache buffers chains 7549 13,409 11 1 10/1/0/0/0
cache buffers chains 12202 13,381 10 1 9/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 13922 13,344 3 1 2/1/0/0/0
cache buffers chains 5017 13,312 2 1 1/1/0/0/0
cache buffers chains 97 13,294 3 1 2/1/0/0/0
cache buffers chains 1989 13,270 7 2 5/2/0/0/0
cache buffers chains 4221 13,247 7 1 6/1/0/0/0
cache buffers chains 15909 13,229 7 1 6/1/0/0/0
cache buffers chains 2467 13,220 6 1 5/1/0/0/0
cache buffers chains 4291 13,190 3 1 2/1/0/0/0
cache buffers chains 16116 13,173 1 1 0/1/0/0/0
cache buffers chains 7458 13,139 7 1 6/1/0/0/0
cache buffers chains 2865 13,088 4 1 3/1/0/0/0
cache buffers chains 2499 13,072 6 1 5/1/0/0/0
cache buffers chains 12417 13,067 5 1 4/1/0/0/0
cache buffers chains 15056 13,033 11 1 10/1/0/0/0
cache buffers chains 7500 12,964 7 1 6/1/0/0/0
cache buffers chains 7536 12,911 6 1 5/1/0/0/0
cache buffers chains 4089 12,908 7 1 6/1/0/0/0
cache buffers chains 4093 12,901 7 1 6/1/0/0/0
cache buffers chains 14713 12,891 3 1 2/1/0/0/0
cache buffers chains 1980 12,871 6 1 5/1/0/0/0
cache buffers chains 7094 12,801 6 1 5/1/0/0/0
cache buffers chains 14880 12,796 7 1 6/1/0/0/0
cache buffers chains 3248 12,766 12 1 11/1/0/0/0
cache buffers chains 12820 12,704 5 1 4/1/0/0/0
cache buffers chains 8001 12,697 9 2 7/2/0/0/0
cache buffers chains 11987 12,696 5 1 4/1/0/0/0
cache buffers chains 15168 12,690 6 1 5/1/0/0/0
cache buffers chains 6155 12,619 6 1 5/1/0/0/0
cache buffers chains 15537 12,614 8 1 7/1/0/0/0
cache buffers chains 3112 12,517 5 1 4/1/0/0/0
cache buffers chains 3233 12,477 7 1 6/1/0/0/0
cache buffers chains 10593 12,470 8 1 7/1/0/0/0
cache buffers chains 9701 12,461 10 1 9/1/0/0/0
cache buffers chains 7948 12,421 3 1 2/1/0/0/0
cache buffers chains 12406 12,415 7 1 6/1/0/0/0
cache buffers chains 4732 12,393 4 1 3/1/0/0/0
cache buffers chains 12157 12,392 6 1 5/1/0/0/0
cache buffers chains 15289 12,391 8 1 7/1/0/0/0
cache buffers chains 4133 12,382 5 1 4/1/0/0/0
cache buffers chains 12319 12,374 14 1 13/1/0/0/0
cache buffers chains 9412 12,351 4 1 3/1/0/0/0
cache buffers chains 14117 12,294 5 1 4/1/0/0/0
cache buffers chains 2897 12,219 5 1 4/1/0/0/0
cache buffers chains 14108 12,203 5 1 4/1/0/0/0
cache buffers chains 8222 12,202 5 1 4/1/0/0/0
cache buffers chains 13937 12,184 4 1 3/1/0/0/0
cache buffers chains 12802 12,133 8 1 7/1/0/0/0
cache buffers chains 13940 12,129 10 1 9/1/0/0/0
cache buffers chains 6979 12,120 1 1 0/1/0/0/0
cache buffers chains 14961 12,098 7 1 6/1/0/0/0
cache buffers chains 1900 12,079 11 1 10/1/0/0/0
cache buffers chains 2689 12,074 5 1 4/1/0/0/0
cache buffers chains 452 12,056 4 1 3/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 12945 12,050 6 1 5/1/0/0/0
cache buffers chains 10664 11,956 9 1 8/1/0/0/0
cache buffers chains 10667 11,946 4 1 3/1/0/0/0
cache buffers chains 15257 11,941 7 1 6/1/0/0/0
cache buffers chains 4691 11,928 3 1 2/1/0/0/0
cache buffers chains 6948 11,907 5 1 4/1/0/0/0
cache buffers chains 2529 11,898 4 1 3/1/0/0/0
cache buffers chains 3462 11,895 9 1 8/1/0/0/0
cache buffers chains 4737 11,894 4 1 3/1/0/0/0
cache buffers chains 9780 11,889 9 2 7/2/0/0/0
cache buffers chains 14374 11,889 3 1 2/1/0/0/0
cache buffers chains 8319 11,859 12 1 11/1/0/0/0
cache buffers chains 11076 11,857 9 1 8/1/0/0/0
cache buffers chains 12420 11,845 7 1 6/1/0/0/0
cache buffers chains 12448 11,777 6 1 5/1/0/0/0
cache buffers chains 10605 11,770 12 1 11/1/0/0/0
cache buffers chains 83 11,751 1 1 0/1/0/0/0
cache buffers chains 10067 11,717 7 1 6/1/0/0/0
cache buffers chains 7617 11,653 3 1 2/1/0/0/0
cache buffers chains 14254 11,575 9 1 8/1/0/0/0
cache buffers chains 6429 11,491 3 1 2/1/0/0/0
cache buffers chains 2514 11,440 4 1 3/1/0/0/0
cache buffers chains 6882 11,381 3 1 2/1/0/0/0
cache buffers chains 9355 11,333 2 1 1/1/0/0/0
cache buffers chains 15967 11,332 7 1 6/1/0/0/0
cache buffers chains 5728 11,316 4 1 3/1/0/0/0
cache buffers chains 4097 11,294 10 3 7/3/0/0/0
cache buffers chains 12222 11,293 5 2 3/2/0/0/0
cache buffers chains 16188 11,264 2 1 1/1/0/0/0
cache buffers chains 7662 11,260 5 1 4/1/0/0/0
cache buffers chains 9802 11,256 3 1 2/1/0/0/0
cache buffers chains 76 11,255 7 1 6/1/0/0/0
cache buffers chains 7708 11,236 5 2 3/2/0/0/0
cache buffers chains 12450 11,236 6 1 5/1/0/0/0
cache buffers chains 15169 11,215 3 1 2/1/0/0/0
cache buffers chains 16104 11,181 3 1 2/1/0/0/0
cache buffers chains 6852 11,176 5 1 4/1/0/0/0
cache buffers chains 14847 11,133 6 1 5/1/0/0/0
cache buffers chains 6878 11,085 6 1 5/1/0/0/0
cache buffers chains 15601 11,082 4 1 3/1/0/0/0
cache buffers chains 1377 11,039 12 1 11/1/0/0/0
cache buffers chains 12156 10,991 5 1 4/1/0/0/0
cache buffers chains 6001 10,981 3 1 2/1/0/0/0
cache buffers chains 8161 10,974 4 1 3/1/0/0/0
cache buffers chains 14977 10,942 4 1 3/1/0/0/0
cache buffers chains 5773 10,932 6 1 5/1/0/0/0
cache buffers chains 3155 10,907 5 1 4/1/0/0/0
cache buffers chains 1918 10,820 7 1 6/1/0/0/0
cache buffers chains 5917 10,809 8 1 7/1/0/0/0
cache buffers chains 6833 10,800 10 1 9/1/0/0/0
cache buffers chains 16129 10,793 7 1 6/1/0/0/0
cache buffers chains 14215 10,769 3 1 2/1/0/0/0
cache buffers chains 9371 10,705 3 1 2/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 1465 10,678 10 2 8/2/0/0/0
cache buffers chains 16136 10,665 2 1 1/1/0/0/0
cache buffers chains 9453 10,642 10 1 9/1/0/0/0
cache buffers chains 13753 10,603 13 1 12/1/0/0/0
cache buffers chains 3518 10,602 11 1 10/1/0/0/0
cache buffers chains 16145 10,579 8 1 7/1/0/0/0
cache buffers chains 3591 10,576 9 1 8/1/0/0/0
cache buffers chains 10641 10,560 6 1 5/1/0/0/0
cache buffers chains 3530 10,512 5 1 4/1/0/0/0
cache buffers chains 16169 10,507 5 2 3/2/0/0/0
cache buffers chains 3137 10,488 8 1 7/1/0/0/0
cache buffers chains 13757 10,477 7 1 6/1/0/0/0
cache buffers chains 12228 10,447 11 1 10/1/0/0/0
cache buffers chains 7505 10,421 7 1 6/1/0/0/0
cache buffers chains 10142 10,382 8 1 7/1/0/0/0
cache buffers chains 5821 10,339 6 1 5/1/0/0/0
cache buffers chains 1515 10,329 5 1 4/1/0/0/0
cache buffers chains 5930 10,183 3 1 2/1/0/0/0
cache buffers chains 2988 10,173 5 1 4/1/0/0/0
cache buffers chains 3053 10,162 6 1 5/1/0/0/0
cache buffers chains 14625 10,160 2 1 1/1/0/0/0
cache buffers chains 3821 10,144 7 1 6/1/0/0/0
cache buffers chains 4183 10,141 8 1 7/1/0/0/0
cache buffers chains 3229 10,117 3 1 2/1/0/0/0
cache buffers chains 12225 10,116 6 2 4/2/0/0/0
cache buffers chains 4801 10,080 4 1 3/1/0/0/0
cache buffers chains 931 10,052 3 1 2/1/0/0/0
cache buffers chains 6136 10,002 8 1 7/1/0/0/0
cache buffers chains 103 9,975 7 1 6/1/0/0/0
cache buffers chains 1540 9,954 11 1 10/1/0/0/0
cache buffers chains 3980 9,935 4 1 3/1/0/0/0
cache buffers chains 15296 9,900 4 1 3/1/0/0/0
cache buffers chains 10604 9,892 12 1 11/1/0/0/0
cache buffers chains 15176 9,843 7 1 6/1/0/0/0
cache buffers chains 3146 9,832 9 1 8/1/0/0/0
cache buffers chains 3377 9,831 7 1 6/1/0/0/0
cache buffers chains 2863 9,799 3 1 2/1/0/0/0
cache buffers chains 1627 9,732 6 1 5/1/0/0/0
cache buffers chains 9535 9,721 9 1 8/1/0/0/0
cache buffers chains 7718 9,693 5 1 4/1/0/0/0
cache buffers chains 13667 9,618 12 1 11/1/0/0/0
cache buffers chains 15500 9,615 11 1 10/1/0/0/0
cache buffers chains 5888 9,611 9 1 8/1/0/0/0
cache buffers chains 11064 9,611 9 1 8/1/0/0/0
cache buffers chains 3461 9,565 5 1 4/1/0/0/0
cache buffers chains 11562 9,540 6 1 5/1/0/0/0
cache buffers chains 11648 9,534 11 1 10/1/0/0/0
cache buffers chains 2964 9,507 6 1 5/1/0/0/0
cache buffers chains 896 9,484 2 1 1/1/0/0/0
cache buffers chains 15837 9,434 9 1 8/1/0/0/0
cache buffers chains 16270 9,419 13 1 12/1/0/0/0
cache buffers chains 11096 9,408 7 1 6/1/0/0/0
cache buffers chains 5691 9,380 5 1 4/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 3521 9,317 7 2 5/2/0/0/0
cache buffers chains 12246 9,313 10 1 9/1/0/0/0
cache buffers chains 3951 9,312 7 1 6/1/0/0/0
cache buffers chains 10903 9,309 8 1 7/1/0/0/0
cache buffers chains 15233 9,296 4 1 3/1/0/0/0
cache buffers chains 9625 9,288 7 1 6/1/0/0/0
cache buffers chains 15209 9,256 3 1 2/1/0/0/0
cache buffers chains 12234 9,226 5 1 4/1/0/0/0
cache buffers chains 13804 9,216 6 1 5/1/0/0/0
cache buffers chains 13761 9,189 6 1 5/1/0/0/0
cache buffers chains 16285 9,170 10 1 9/1/0/0/0
cache buffers chains 6233 9,152 7 2 5/2/0/0/0
cache buffers chains 16384 9,150 4 1 3/1/0/0/0
cache buffers chains 10802 9,140 4 1 3/1/0/0/0
cache buffers chains 7553 9,132 4 1 3/1/0/0/0
cache buffers chains 1101 9,101 3 1 2/1/0/0/0
cache buffers chains 16296 9,099 3 1 2/1/0/0/0
cache buffers chains 6349 9,085 12 1 11/1/0/0/0
cache buffers chains 14671 9,052 8 1 7/1/0/0/0
cache buffers chains 1346 9,039 10 1 9/1/0/0/0
cache buffers chains 3640 9,025 3 1 2/1/0/0/0
cache buffers chains 3397 9,004 4 1 3/1/0/0/0
cache buffers chains 9484 8,956 8 1 7/1/0/0/0
cache buffers chains 10918 8,946 8 1 7/1/0/0/0
cache buffers chains 3490 8,878 8 2 6/2/0/0/0
cache buffers chains 1369 8,841 9 1 8/1/0/0/0
cache buffers chains 16107 8,834 8 1 7/1/0/0/0
cache buffers chains 2299 8,802 7 1 6/1/0/0/0
cache buffers chains 10061 8,788 15 3 12/3/0/0/0
cache buffers chains 11854 8,746 6 1 5/1/0/0/0
cache buffers chains 3866 8,728 4 1 3/1/0/0/0
cache buffers chains 15603 8,720 7 1 6/1/0/0/0
cache buffers chains 2703 8,694 5 1 4/1/0/0/0
cache buffers chains 2323 8,693 3 1 2/1/0/0/0
cache buffers chains 12232 8,678 9 1 8/1/0/0/0
cache buffers chains 1278 8,670 7 1 6/1/0/0/0
cache buffers chains 14004 8,661 6 1 5/1/0/0/0
cache buffers chains 9830 8,630 6 1 5/1/0/0/0
cache buffers chains 16365 8,621 2 1 1/1/0/0/0
cache buffers chains 12960 8,605 7 1 6/1/0/0/0
cache buffers chains 3497 8,604 4 1 3/1/0/0/0
cache buffers chains 14673 8,575 2 1 1/1/0/0/0
cache buffers chains 6363 8,514 6 1 5/1/0/0/0
cache buffers chains 3025 8,472 1 1 0/1/0/0/0
cache buffers chains 2956 8,444 4 1 3/1/0/0/0
cache buffers chains 11767 8,442 9 1 8/1/0/0/0
cache buffers chains 4897 8,439 2 1 1/1/0/0/0
cache buffers chains 9521 8,421 3 1 2/1/0/0/0
cache buffers chains 12377 8,397 5 1 4/1/0/0/0
cache buffers chains 2763 8,387 10 1 9/1/0/0/0
cache buffers chains 9409 8,355 4 1 3/1/0/0/0
cache buffers chains 3588 8,348 7 1 6/1/0/0/0
cache buffers chains 16271 8,314 8 1 7/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 14125 8,290 3 1 2/1/0/0/0
cache buffers chains 9511 8,284 5 1 4/1/0/0/0
cache buffers chains 3194 8,277 9 1 8/1/0/0/0
cache buffers chains 2721 8,276 6 1 5/1/0/0/0
cache buffers chains 10760 8,213 6 1 5/1/0/0/0
cache buffers chains 1211 8,208 8 1 7/1/0/0/0
cache buffers chains 16287 8,186 10 1 9/1/0/0/0
cache buffers chains 11198 8,182 8 1 7/1/0/0/0
cache buffers chains 1277 8,134 14 1 13/1/0/0/0
cache buffers chains 5968 8,094 4 1 3/1/0/0/0
cache buffers chains 8276 7,980 3 1 2/1/0/0/0
cache buffers chains 16195 7,971 7 2 5/2/0/0/0
cache buffers chains 11698 7,939 4 1 3/1/0/0/0
cache buffers chains 11738 7,936 1 1 0/1/0/0/0
cache buffers chains 9595 7,935 7 2 5/2/0/0/0
cache buffers chains 10732 7,921 4 1 3/1/0/0/0
cache buffers chains 9930 7,875 6 1 5/1/0/0/0
cache buffers chains 3623 7,866 8 1 7/1/0/0/0
cache buffers chains 16174 7,844 9 1 8/1/0/0/0
cache buffers chains 3429 7,832 10 1 9/1/0/0/0
cache buffers chains 3922 7,708 5 1 4/1/0/0/0
cache buffers chains 16217 7,699 8 1 7/1/0/0/0
cache buffers chains 3625 7,678 7 1 6/1/0/0/0
cache buffers chains 1112 7,661 5 1 4/1/0/0/0
cache buffers chains 3905 7,657 6 1 5/1/0/0/0
cache buffers chains 3535 7,621 4 2 2/2/0/0/0
cache buffers chains 10098 7,603 11 1 10/1/0/0/0
cache buffers chains 11598 7,594 11 2 9/2/0/0/0
cache buffers chains 16 7,575 4 1 3/1/0/0/0
cache buffers chains 2791 7,534 6 1 5/1/0/0/0
cache buffers chains 12308 7,520 7 1 6/1/0/0/0
cache buffers chains 13778 7,520 9 1 8/1/0/0/0
cache buffers chains 11864 7,507 9 1 8/1/0/0/0
cache buffers chains 33 7,466 3 1 2/1/0/0/0
cache buffers chains 11800 7,421 7 1 6/1/0/0/0
cache buffers chains 15827 7,409 10 1 9/1/0/0/0
cache buffers chains 16280 7,392 10 1 9/1/0/0/0
cache buffers chains 3920 7,372 5 1 4/1/0/0/0
cache buffers chains 15822 7,369 6 1 5/1/0/0/0
cache buffers chains 15834 7,369 7 1 6/1/0/0/0
cache buffers chains 3581 7,359 5 1 4/1/0/0/0
cache buffers chains 9547 7,330 9 1 8/1/0/0/0
cache buffers chains 4865 7,285 6 1 5/1/0/0/0
cache buffers chains 3217 7,230 10 2 8/2/0/0/0
cache buffers chains 10353 7,200 15 1 14/1/0/0/0
cache buffers chains 3055 7,193 6 1 5/1/0/0/0
cache buffers chains 8220 7,176 6 1 5/1/0/0/0
cache buffers chains 11070 7,151 6 1 5/1/0/0/0
cache buffers chains 2234 7,148 1 1 0/1/0/0/0
cache buffers chains 2247 7,072 6 1 5/1/0/0/0
cache buffers chains 11801 7,065 8 1 7/1/0/0/0
cache buffers chains 4356 7,044 2 1 1/1/0/0/0
cache buffers chains 12017 7,026 6 1 5/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 1141 7,021 9 1 8/1/0/0/0
cache buffers chains 38 7,013 10 1 9/1/0/0/0
cache buffers chains 6353 6,998 7 2 5/2/0/0/0
cache buffers chains 9773 6,976 6 1 5/1/0/0/0
cache buffers chains 8193 6,946 13 1 12/1/0/0/0
cache buffers chains 1623 6,864 11 2 9/2/0/0/0
cache buffers chains 3900 6,861 12 1 11/1/0/0/0
cache buffers chains 2737 6,860 7 2 5/2/0/0/0
cache buffers chains 11833 6,848 5 1 4/1/0/0/0
cache buffers chains 16369 6,840 8 1 7/1/0/0/0
cache buffers chains 11451 6,835 5 1 4/1/0/0/0
cache buffers chains 13695 6,832 5 1 4/1/0/0/0
cache buffers chains 3185 6,807 6 1 5/1/0/0/0
cache buffers chains 3634 6,791 7 1 6/1/0/0/0
cache buffers chains 12363 6,769 6 1 5/1/0/0/0
cache buffers chains 10163 6,703 5 1 4/1/0/0/0
cache buffers chains 12358 6,702 5 1 4/1/0/0/0
cache buffers chains 2723 6,682 3 1 2/1/0/0/0
cache buffers chains 6299 6,667 8 1 7/1/0/0/0
cache buffers chains 11761 6,665 7 1 6/1/0/0/0
cache buffers chains 1251 6,656 7 1 6/1/0/0/0
cache buffers chains 9512 6,648 4 1 3/1/0/0/0
cache buffers chains 16083 6,642 7 1 6/1/0/0/0
cache buffers chains 13694 6,619 9 1 8/1/0/0/0
cache buffers chains 11314 6,573 7 1 6/1/0/0/0
cache buffers chains 5960 6,561 6 1 5/1/0/0/0
cache buffers chains 1775 6,559 3 1 2/1/0/0/0
cache buffers chains 11863 6,523 10 1 9/1/0/0/0
cache buffers chains 12305 6,501 6 1 5/1/0/0/0
cache buffers chains 11290 6,499 9 1 8/1/0/0/0
cache buffers chains 28 6,414 11 1 10/1/0/0/0
cache buffers chains 1801 6,414 1 1 0/1/0/0/0
cache buffers chains 9420 6,410 6 1 5/1/0/0/0
cache buffers chains 1718 6,387 6 1 5/1/0/0/0
cache buffers chains 3151 6,351 4 1 3/1/0/0/0
cache buffers chains 13697 6,337 6 1 5/1/0/0/0
cache buffers chains 1316 6,335 14 1 13/1/0/0/0
cache buffers chains 1768 6,326 6 1 5/1/0/0/0
cache buffers chains 16053 6,314 7 1 6/1/0/0/0
cache buffers chains 4874 6,311 5 1 4/1/0/0/0
cache buffers chains 2748 6,301 4 1 3/1/0/0/0
cache buffers chains 10387 6,294 5 1 4/1/0/0/0
cache buffers chains 9777 6,288 9 1 8/1/0/0/0
cache buffers chains 4835 6,269 3 1 2/1/0/0/0
cache buffers chains 1359 6,267 7 1 6/1/0/0/0
cache buffers chains 16345 6,244 6 1 5/1/0/0/0
cache buffers chains 4907 6,191 4 1 3/1/0/0/0
cache buffers chains 1349 6,181 6 1 5/1/0/0/0
cache buffers chains 10192 6,119 11 1 10/1/0/0/0
cache buffers chains 2752 6,115 5 1 4/1/0/0/0
cache buffers chains 1473 6,105 5 1 4/1/0/0/0
cache buffers chains 3198 6,102 7 1 6/1/0/0/0
cache buffers chains 4860 6,090 5 1 4/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 1152 6,039 4 1 3/1/0/0/0
cache buffers chains 15888 6,029 7 1 6/1/0/0/0
cache buffers chains 2808 5,955 4 1 3/1/0/0/0
cache buffers chains 15864 5,945 5 1 4/1/0/0/0
cache buffers chains 11780 5,939 8 1 7/1/0/0/0
cache buffers chains 1233 5,890 14 1 13/1/0/0/0
cache buffers chains 14651 5,888 5 1 4/1/0/0/0
cache buffers chains 10132 5,834 4 1 3/1/0/0/0
cache buffers chains 1593 5,816 4 1 3/1/0/0/0
cache buffers chains 4847 5,790 3 1 2/1/0/0/0
cache buffers chains 9958 5,783 6 1 5/1/0/0/0
cache buffers chains 10111 5,782 9 1 8/1/0/0/0
cache buffers chains 10429 5,775 10 1 9/1/0/0/0
cache buffers chains 4768 5,773 4 1 3/1/0/0/0
cache buffers chains 10942 5,765 10 1 9/1/0/0/0
cache buffers chains 3854 5,760 5 1 4/1/0/0/0
cache buffers chains 1236 5,754 9 1 8/1/0/0/0
cache buffers chains 3873 5,748 1 1 0/1/0/0/0
cache buffers chains 10199 5,728 8 1 7/1/0/0/0
cache buffers chains 1711 5,686 4 1 3/1/0/0/0
cache buffers chains 1417 5,673 6 1 5/1/0/0/0
cache buffers chains 5884 5,671 5 1 4/1/0/0/0
cache buffers chains 13726 5,635 8 1 7/1/0/0/0
cache buffers chains 10001 5,576 7 1 6/1/0/0/0
cache buffers chains 16048 5,558 8 1 7/1/0/0/0
cache buffers chains 1411 5,546 7 1 6/1/0/0/0
cache buffers chains 10201 5,529 10 1 9/1/0/0/0
cache buffers chains 1649 5,512 6 1 5/1/0/0/0
cache buffers chains 1460 5,494 10 1 9/1/0/0/0
cache buffers chains 1009 5,491 5 1 4/1/0/0/0
cache buffers chains 10088 5,468 6 1 5/1/0/0/0
cache buffers chains 10511 5,426 12 1 11/1/0/0/0
cache buffers chains 11831 5,426 7 1 6/1/0/0/0
cache buffers chains 758 5,383 5 1 4/1/0/0/0
cache buffers chains 11287 5,371 8 1 7/1/0/0/0
cache buffers chains 1117 5,353 5 1 4/1/0/0/0
cache buffers chains 1681 5,321 5 1 4/1/0/0/0
cache buffers chains 15869 5,313 7 1 6/1/0/0/0
cache buffers chains 10145 5,261 7 1 6/1/0/0/0
cache buffers chains 2989 5,195 9 1 8/1/0/0/0
cache buffers chains 11289 5,175 9 1 8/1/0/0/0
cache buffers chains 13617 5,147 6 1 5/1/0/0/0
cache buffers chains 1427 5,142 6 1 5/1/0/0/0
cache buffers chains 1432 5,097 7 1 6/1/0/0/0
cache buffers chains 10915 5,088 7 1 6/1/0/0/0
cache buffers chains 1746 5,087 7 1 6/1/0/0/0
cache buffers chains 10972 5,072 7 1 6/1/0/0/0
cache buffers chains 10529 5,027 6 1 5/1/0/0/0
cache buffers chains 5647 5,017 6 1 5/1/0/0/0
cache buffers chains 1457 4,995 8 2 6/2/0/0/0
cache buffers chains 1962 4,969 10 1 9/1/0/0/0
cache buffers chains 10073 4,969 11 1 10/1/0/0/0
cache buffers chains 1415 4,932 6 1 5/1/0/0/0
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains 1396 4,922 11 1 10/1/0/0/0
cache buffers chains 11599 4,908 8 1 7/1/0/0/0
cache buffers chains 1594 4,872 5 1 4/1/0/0/0
cache buffers chains 9947 4,872 7 1 6/1/0/0/0
cache buffers chains 10037 4,817 11 1 10/1/0/0/0
cache buffers chains 12087 4,785 3 1 2/1/0/0/0
cache buffers chains 10396 4,756 14 1 13/1/0/0/0
cache buffers chains 11320 4,732 5 1 4/1/0/0/0
cache buffers chains 15871 4,724 7 1 6/1/0/0/0
cache buffers chains 10984 4,714 9 1 8/1/0/0/0
cache buffers chains 3799 4,685 7 1 6/1/0/0/0
cache buffers chains 12344 4,667 6 1 5/1/0/0/0
cache buffers chains 12038 4,650 7 1 6/1/0/0/0
cache buffers chains 1458 4,524 6 1 5/1/0/0/0
cache buffers chains 1034 4,418 8 1 7/1/0/0/0
cache buffers chains 1467 4,369 7 1 6/1/0/0/0
cache buffers chains 1024 4,342 6 1 5/1/0/0/0
cache buffers chains 692 4,308 8 1 7/1/0/0/0
cache buffers chains 4385 4,174 2 1 1/1/0/0/0
cache buffers chains 1185 4,171 12 1 11/1/0/0/0
cache buffers chains 1242 4,110 9 1 8/1/0/0/0
cache buffers chains 11282 4,101 11 1 10/1/0/0/0
cache buffers chains 9929 4,079 8 1 7/1/0/0/0
cache buffers chains 10872 4,072 9 1 8/1/0/0/0
cache buffers chains 11410 3,819 3 1 2/1/0/0/0
cache buffers chains 11274 3,807 10 1 9/1/0/0/0
cache buffers chains 1139 3,801 3 1 2/1/0/0/0
cache buffers chains 1256 3,791 4 1 3/1/0/0/0
cache buffers chains 1672 3,786 6 1 5/1/0/0/0
cache buffers chains 11373 3,770 5 1 4/1/0/0/0
cache buffers chains 15889 3,733 4 2 2/2/0/0/0
cache buffers chains 11094 3,710 8 1 7/1/0/0/0
cache buffers chains 11376 3,682 4 1 3/1/0/0/0
cache buffers chains 709 3,636 3 1 2/1/0/0/0
cache buffers chains 4392 3,622 5 1 4/1/0/0/0
cache buffers chains 10871 3,532 9 1 8/1/0/0/0
cache buffers chains 1144 3,459 5 1 4/1/0/0/0
cache buffers chains 10698 3,355 6 1 5/1/0/0/0
cache buffers chains 11408 3,355 5 1 4/1/0/0/0
cache buffers chains 11283 3,308 10 2 8/2/0/0/0
cache buffers chains 1532 3,221 8 1 7/1/0/0/0
cache buffers chains 11305 3,197 8 1 7/1/0/0/0
cache buffers chains 3836 2,956 4 1 3/1/0/0/0
cache buffers chains 682 2,672 6 1 5/1/0/0/0
cache buffers lru chai 11 45,641 246 2 244/2/0/0/0
cache buffers lru chai 12 45,360 285 3 282/3/0/0/0
cache buffers lru chai 9 45,170 232 2 230/2/0/0/0
cache buffers lru chai 10 44,999 234 2 232/2/0/0/0
channel operations par 5 26,131 34 1 33/1/0/0/0
enqueue hash chains 6 72,477 4 1 3/1/0/0/0
library cache 3 8,526,997 15,676 603 15086/577/13
/0/0
library cache 6 8,242,600 11,872 660 11222/640/10
Child Latch Statistics DB: SNAB Instance: snab Snaps: 1193 -1195
-> only latches with sleeps/gets > 1/100000 are shown
-> ordered by name, gets desc
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
/0/0
library cache 1 5,255,083 7,302 312 6992/308/2/0
/0
library cache 10 2,701,339 3,900 316 3590/304/6/0
/0
library cache 5 2,612,982 6,598 380 6223/370/5/0
/0
library cache 7 2,529,278 2,666 235 2438/221/7/0
/0
library cache 4 2,501,152 2,891 256 2641/244/6/0
/0
library cache 9 968,305 1,767 145 1625/139/3/0
/0
library cache 2 942,829 834 82 758/70/6/0/0
library cache 11 778,999 695 45 653/39/3/0/0
library cache 8 495,498 281 53 231/47/3/0/0
shared pool 2 783,206 485 59 426/59/0/0/0
shared pool 1 357,271 127 36 92/34/1/0/0
simulator lru latch 10 68,175 34 3 31/3/0/0/0
simulator lru latch 9 65,608 52 7 45/7/0/0/0
simulator lru latch 11 62,277 35 5 30/5/0/0/0
simulator lru latch 12 61,449 21 3 18/3/0/0/0
-------------------------------------------------------------
Top 5 Logical Reads per Segment for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Segment Logical Reads Threshold: 10000
Subobject Obj. Logical
Owner Tablespace Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
PARUS PARUS_IND C_USERROLES_ROLEAUTH INDEX 62,843,856 21.04
PARUS PARUS REPLINHIST TABLE 49,822,384 16.68
PARUS PARUS_IND C_EQLIFELENGHT_DATE_ INDEX 17,567,376 5.88
PARUS PARUS_IND C_UNITLIST_PK INDEX 13,025,136 4.36
PARUS PARUS EQCONFIG TABLE 11,371,472 3.81
-------------------------------------------------------------
Top 5 Physical Reads per Segment for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Segment Physical Reads Threshold: 1000
Subobject Obj. Physical
Owner Tablespace Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
PARUS PARUS TR_SNAB_COMPUTEL_OBJ TABLE 3,293,743 48.79
PARUS PARUS EQCONFIG TABLE 1,381,462 20.46
PARUS PARUS DOCLINKS TABLE 523,887 7.76
PARUS PARUS_IND I_DOCS_PROPS_VALS_DO INDEX 150,597 2.23
PARUS PARUS USERPRIV TABLE 125,751 1.86
-------------------------------------------------------------
Top 5 Buf. Busy Waits per Segment for DB: SNAB Instance: snab Snaps: 1193 -119
-> End Segment Buffer Busy Waits Threshold: 100
Buffer
Subobject Obj. Busy
Owner Tablespace Object Name Name Type Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
PARUS PARUS TR_SNAB_COMPUTEL_OBJ TABLE 284,888 72.75
PARUS PARUS_IND C_EQLIFELENGHT_DATE_ INDEX 54,423 13.90
PARUS PARUS DOCLINKS TABLE 41,161 10.51
PARUS PARUS_IND TR_SNAB_COMPUTEL_OBJ INDEX 4,121 1.05
PARUS PARUS STOREOPERJOURN TABLE 2,254 .58
-------------------------------------------------------------
Top 5 Row Lock Waits per Segment for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Segment Row Lock Waits Threshold: 100
Row
Subobject Obj. Lock
Owner Tablespace Object Name Name Type Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
PARUS PARUS_IND I_UPDATELIST_MODIFDA INDEX 140 22.40
PARUS PARUS_IND I_UPDATELIST_BUSPROC INDEX 128 20.48
PARUS PARUS_IND I_UPDATELIST_TABLERN INDEX 103 16.48
PARUS PARUS_IND I_UPDATELIST_TABLERN INDEX 92 14.72
PARUS PARUS_UPDL I_UPDATELIST_DETAIL_ INDEX 10 1.60
-------------------------------------------------------------
Top 5 ITL Waits per Segment for DB: SNAB Instance: snab Snaps: 1193 -1195
-> End Segment ITL Waits Threshold: 100
Subobject Obj. ITL
Owner Tablespace Object Name Name Type Waits %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
PARUS PARUS_IND I_UPDATELIST_MODIFDA INDEX 13 59.09
PARUS PARUS_IND I_UPDATELIST_TABLERN INDEX 3 13.64
PARUS PARUS_IND I_UPDATELIST_TABLERN INDEX 3 13.64
PARUS PARUS_IND I_UPDATELIST_BUSPROC INDEX 2 9.09
-------------------------------------------------------------
Dictionary Cache Stats for DB: SNAB Instance: snab Snaps: 1193 -1195
->"Pct Misses" should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_global_oids 15,779 0.0 0 0 34
dc_histogram_defs 26,637 0.3 0 0 6,043
dc_object_ids 316,192 0.1 0 0 4,994
dc_objects 25,700 3.6 0 0 8,007
dc_profiles 77 0.0 0 0 3
dc_rollback_segments 2,760 0.0 0 0 108
dc_segments 63,039 0.7 0 13 4,703
dc_sequences 14,737 0.0 0 14,737 13
dc_table_scns 178 0.0 0 0 5
dc_tablespace_quotas 52 0.0 0 13 4
dc_tablespaces 471,359 0.0 0 0 24
dc_user_grants 1,558 0.1 0 0 215
dc_usernames 33,140 0.0 0 0 218
dc_users 977,211 0.0 0 2 232
-------------------------------------------------------------
Library Cache Activity for DB: SNAB Instance: snab Snaps: 1193 -1195
->"Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,593 0.2 1,593 0.2 0 0
CLUSTER 29 0.0 44 0.0 0 0
PIPE 290,483 0.0 291,629 0.0 0 0
SQL AREA 13,560 2.1 15,906,850 0.0 187 0
TABLE/PROCEDURE 250,097 0.1 758,714 0.2 1,099 0
TRIGGER 650 3.8 650 5.8 13 0
-------------------------------------------------------------
Shared Pool Advisory for DB: SNAB Instance: snab End Snap: 1195
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid
Estd
Shared Pool SP Estd Estd Estd Lib LC Time
Size for Size Lib Cache Lib Cache Cache Time Saved Estd Lib Cache
Estim (M) Factr Size (M) Mem Obj Saved (s) Factr Mem Obj Hits
----------- ----- ---------- ------------ ------------ ------- ---------------
688 .6 654 29,931 5,692,296 1.0 946,846,758
816 .7 781 36,489 5,695,257 1.0 947,021,722
944 .8 909 41,776 5,697,379 1.0 947,161,833
1,072 .9 1,036 52,094 5,699,071 1.0 947,275,420
1,200 1.0 1,163 56,879 5,700,416 1.0 947,367,671
1,328 1.1 1,290 61,864 5,701,422 1.0 947,443,083
1,456 1.2 1,417 66,622 5,702,276 1.0 947,505,584
1,584 1.3 1,544 69,639 5,702,911 1.0 947,553,818
1,712 1.4 1,687 74,586 5,703,417 1.0 947,591,559
1,840 1.5 1,814 77,509 5,703,794 1.0 947,622,915
1,968 1.6 1,941 80,403 5,704,135 1.0 947,648,510
2,096 1.7 2,067 84,438 5,704,461 1.0 947,670,292
2,224 1.9 2,193 90,601 5,704,664 1.0 947,690,120
2,352 2.0 2,319 94,960 5,704,855 1.0 947,707,913
2,480 2.1 2,464 101,542 5,705,065 1.0 947,724,328
-------------------------------------------------------------
SGA Memory Summary for DB: SNAB Instance: snab Snaps: 1193 -1195
SGA regions Size in Bytes
------------------------------ ----------------
Database Buffers 1,476,395,008
Fixed Size 745,640
Redo Buffers 1,323,008
Variable Size 2,214,592,512
----------------
sum 3,693,056,168
-------------------------------------------------------------
SGA breakdown difference for DB: SNAB Instance: snab Snaps: 1193 -1195
Pool Name Begin value End value % Diff
------ ------------------------------ ---------------- ---------------- -------
java free memory 193,921,024 193,921,024 0.00
java memory in use 7,405,568 7,405,568 0.00
large free memory 117,440,512 117,440,512 0.00
shared Checkpoint queue 1,026,560 1,026,560 0.00
shared db_block_hash_buckets 4,718,592 4,718,592 0.00
shared dictionary cache 4,274,432 4,274,432 0.00
shared enqueue 1,045,464 1,045,464 0.00
shared errors 1,217,536 1,157,824 -4.90
shared event statistics per sess 6,309,240 6,309,240 0.00
shared FileOpenBlock 3,796,104 3,796,104 0.00
shared fixed allocation callback 2,448 2,448 0.00
shared free memory 87,287,192 120,948,160 38.56
shared joxlod: in ehe 449,752 449,752 0.00
shared joxs heap init 4,240 4,240 0.00
shared KGK heap 7,000 7,000 0.00
shared KGLS heap 30,854,784 73,140,848 137.05
shared KGSK scheduler 295,552 295,552 0.00
shared KGSKI schedule 18,808 18,808 0.00
shared KQR L PO 14,471,456 14,475,552 0.03
shared KQR L SO 9,408 9,408 0.00
shared KQR M PO 7,170,936 7,170,936 0.00
shared KQR M SO 2,720 2,720 0.00
shared KQR S SO 78,776 78,776 0.00
shared KQR X PO 20,640 20,640 0.00
shared KSXR receive buffers 1,034,000 1,034,000 0.00
shared library cache 155,774,784 153,033,432 -1.76
shared miscellaneous 93,152,552 93,189,128 0.04
shared MTTR advisory 360,200 360,200 0.00
shared parameters 968,024 952,464 -1.61
shared PLS non-lib hp 2,088 2,088 0.00
shared PL/SQL DIANA 12,989,320 11,389,504 -12.32
shared PL/SQL MPCODE 19,004,104 19,479,208 2.50
shared PL/SQL PPCODE 207,992 276,752 33.06
shared pl/sql source 6,320 6,320 0.00
shared PX subheap 26,152 26,152 0.00
shared sim memory hea 746,176 746,176 0.00
shared sql area 850,132,256 778,050,800 -8.48
shared subheap 51,720 51,720 0.00
shared table definiti 51,336 55,920 8.93
shared temporary tabl 398,984 387,352 -2.92
shared trigger defini 261,904 234,072 -10.63
shared trigger inform 11,120 9,936 -10.65
shared trigger source 2,800 504 -82.00
shared type object de 116,392 116,392 0.00
shared XDB Schema Cac 8,164,808 8,164,808 0.00
shared 1M buffer 2,098,176 2,098,176 0.00
buffer_cache 1,476,395,008 1,476,395,008 0.00
fixed_sga 745,640 745,640 0.00
log_buffer 1,311,744 1,311,744 0.00
-------------------------------------------------------------
Resource Limit Stats for DB: SNAB Instance: snab End Snap: 1195
-> only rows with Current or Maximum Utilization > 80% of Limit are shown
-> ordered by resource name
Current Maximum Initial
Resource Name Utilization Utilization Allocation Limit
------------------------------ ------------ ------------ ---------- ----------
parallel_max_servers 0 5 6 6
-------------------------------------------------------------
init.ora Parameters for DB: SNAB Instance: snab Snaps: 1193 -1195
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
background_dump_dest /u/oracle/admin/snab/bdump
compatible 9.2.0.5.0
control_files /u/oradata/dbs/snab/snab01.ctl, /
core_dump_dest /u/oracle/admin/snab/cdump
db_block_size 8192
db_cache_size 1476395008
db_domain
db_file_multiblock_read_count 128
db_name snab
fast_start_mttr_target 300
hash_area_size 194304000
hash_join_enabled TRUE
instance_name snab
java_pool_size 201326592
job_queue_processes 15
large_pool_size 117440512
local_listener (ADDRESS = (PROTOCOL=TCP)(HOST=12
log_archive_dest_1 location=/u/oradata/arch/snab
log_archive_format arch_snab_%T_%S.arc
log_archive_start TRUE
open_cursors 800
open_links 4
optimizer_index_caching 90
optimizer_index_cost_adj 1
optimizer_mode CHOOSE
pga_aggregate_target 4096000000
processes 500
query_rewrite_enabled FALSE
remote_login_passwordfile EXCLUSIVE
resource_limit TRUE
resource_manager_plan SYSTEM_PLAN
session_cached_cursors 500
sga_max_size 3693056168
shared_pool_size 1258291200
sort_area_retained_size 1024000
sort_area_size 1024000
star_transformation_enabled FALSE
timed_statistics TRUE
transactions_per_rollback_seg 1
undo_management AUTO
undo_retention 43200
undo_tablespace UNDOTBS1
user_dump_dest /u/oracle/admin/snab/udump
-------------------------------------------------------------
End of Report
|