STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ --------
----------- ------- ------------
BUGS 1284265598 BUGS
1 9.2.0.8.0 NO BUGS01
Snap Id
Snap Time
Sessions Curs/Sess Comment
--------- ------------------ -------- --------- -------------------
Begin Snap: 8959 08-May-08 14:00:06 521 21.3
End
Snap: 8969
08-May-08 15:00:02 500 24.9
Elapsed:
59.93 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache:
1,600M
Std Block Size: 8K
Shared
Pool Size:
1,200M
Log Buffer: 160K
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction
--------------- ---------------
Redo size:
672,063.23
11,336.99
Logical reads: 176,064.17
2,970.01
Block changes:
5,480.09
92.44
Physical reads:
26,979.55
455.12
Physical writes:
628.92
10.61
User calls:
5,007.13
84.46
Parses:
1,179.79
19.90
Hard parses:
232.88
3.93
Sorts:
219.55
3.70
Logons:
4.61
0.08
Executes:
2,166.56
36.55
Transactions:
59.28
% Blocks
changed per Read:
3.11 Recursive
Call %: 48.24
Rollback per
transaction %: 31.24 Rows per
Sort: 79.85
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %:
99.98 Redo NoWait %: 99.99
Buffer Hit %: 84.82 In-memory Sort %: 99.97
Library Hit %: 94.38 Soft Parse %: 80.26
Execute to Parse
%: 45.55
Latch Hit %:
98.23
Parse CPU to Parse Elapsd %: 29.96 % Non-Parse CPU: 85.37
Shared Pool
Statistics Begin End
------ ------
Memory Usage %:
90.27 90.59
% SQL with executions>1:
55.34 61.24
% Memory
for SQL w/exec>1:
48.32 55.07
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
% Total
Event
Waits Time (s)
Ela Time
-------------------------------------------- ------------
----------- --------
CPU time
47,411 46.84
latch free
1,681,639
28,395 28.06
db file sequential read
19,150,874 8,197 8.10
db file scattered read
19,965,462
8,091
7.99
db file parallel write
77,300 2,094 2.07
-------------------------------------------------------------
Wait Events for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> 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
---------------------------- ------------ ----------
---------- ------ --------
latch free
1,681,639
145,857
28,395
17
7.9
db file sequential read 19,150,874 0 8,197 0 89.8
db file scattered read 19,965,462 0 8,091 0 93.7
db file parallel write
77,300 0 2,094 27 0.4
enqueue
1,119 556 1,715 1533 0.0
buffer busy waits
137,276 9 1,354 10 0.6
log file sync
100,942 5
918
9
0.5
direct path write
423,409 0
861
2
2.0
log file parallel write 296,516 0
504
2
1.4
direct path read
352,083 0
416
1
1.7
log buffer space
7,088 3
405
57
0.0
SQL*Net more data to client 297,445 0
261
1
1.4
direct path write (lob)
8,779 0
154
18
0.0
direct path read (lob)
27,427 0
130
5
0.1
library cache pin
6,999 0
75
11
0.0
LGWR wait for redo copy
77,476
1,816
61
1
0.4
log file sequential read
2,472 0
55
22
0.0
log file switch completion
542 0
35
65
0.0
wait list latch free
926 0
21
22
0.0
async disk IO
4,632
0 20 4 0.0
control file parallel write 1,574 0
20
13
0.0
write complete waits
5 5 5 982 0.0
db file parallel read
212 0 4 21 0.0
SQL*Net break/reset to clien 411 0 3 8 0.0
row cache lock
245
0 2 6 0.0
library cache load lock
35 0 1 42 0.0
log file single write
48 0 0 9 0.0
control file sequential read 2,417 0 0 0 0.0
kksfbc child completion
9 9 0 16 0.0
buffer deadlock
6
6 0 1 0.0
undo segment extension
158 158 0 0 0.0
SQL*Net message from client 18,010,856 0 1,018,615 57 84.5
SQL*Net message to client 18,016,007 0
35
0 84.5
SQL*Net more data from clien 93,073 0 15 0 0.4
-------------------------------------------------------------
Background Wait Events for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> ordered by wait time desc, waits desc (idle events
last)
Avg
Total Wait wait Waits
Event
Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ----------
---------- ------ --------
db file parallel write
77,296 0 2,096 27 0.4
log file parallel write
296,587 0
504
2
1.4
latch free
12,458
2,776 378 30 0.1
LGWR wait for redo copy
77,500
1,816
61
1
0.4
log file sequential read
2,472 0
55
22
0.0
async disk IO
4,632
0 20 4 0.0
control file parallel write 1,574 0
20
13
0.0
log buffer space
1,207 0
11
9
0.0
direct path write
984 0 1 1 0.0
direct path read
984
0 1 1 0.0
rdbms ipc reply
141
0 1 5 0.0
log file single write
48 0 0 9 0.0
control file sequential read 2,325 0
0
0
0.0
db file scattered read
116 0 0 3 0.0
db file sequential read
635 0 0 0 0.0
wait list latch free
6 0 0 15 0.0
buffer busy waits
7
0 0 0 0.0
rdbms ipc message
342,492
2,865
20,380
60
1.6
smon timer
9,509 0 3,498 368 0.0
pmon timer
2,196
1,367
3,418 1557 0.0
-------------------------------------------------------------
SQL ordered by Gets for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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
--------------- ------------ -------------- ------
-------- --------- ----------
114,301,714 21,084
5,421.3 18.1 7993.60 22337.82 4077924789
Module: JDBC Thin Client
SELECT ENDPOINT_ID, EQUIP_ID, MLPPP_BUNDLE_ID,
RLSQ_NUMBER FROM
IP_ASSIGNED_ENDPT WHERE MLPPP_BUNDLE_ID IS NOT NULL AND
RLSQ_NUM
BER IS NOT NULL
114,264,052 21,047
5,429.0 18.0 8020.49 22566.30 3970553590
Module: JDBC Thin Client
UPDATE
ip_assigned_endpt SET pos_flag = :1 , pos_j0 = :2 , pos_
s1s0 = :3 , loop_back_freq = :4 ,
ip_direct_broadcast_status = :
5 , cdp_enable = :6
WHERE endpoint_id = :7
8,968,401
44
203,827.3
1.4 77.64 184.67 2556775282
Module: JDBC Thin Client
DELETE FROM NA_ACL_DISCORD_DETAIL A WHERE EXISTS ( SELECT
1 FROM
NA_LOGICAL_DISCORD WHERE (SAA_DISCORD_DETAIL_ID =
A.ACL_DISCORD
_DETAIL_ID OR VPNI_DISCORD_DETAIL_ID =
A.ACL_DISCORD_DETAIL_ID O
R VPNO_DISCORD_DETAIL_ID = A.ACL_DISCORD_DETAIL_ID OR
BGPIN_DISC
ORD_DETAIL_ID = A.ACL_DISCORD_DETAIL_ID OR
BGPOUT_DISCORD_DETAIL
7,573,808
10
757,380.8
1.2 69.23 154.07 2213311996
Module: JDBC Thin Client
BEGIN NtmsEntityPkg.load_logical_discord(:1); END;
6,120,048 127 48,189.4 1.0 556.28 1584.69
896212474
Module: JDBC Thin Client
select
order_event_queue_id, type, instar_order_id, resource_id
, resource_type, event_name, event_status, create_date,
event_da
ta, processed_date, processed_status, processed_count,
processed
_history, jvm_user, resource_id1 from ORDER_EVENT_QUEUE
where pr
ocessed_status='Pending'
5,310,948
5 1,062,189.6 0.8 655.43 1896.38 1048505063
Module: JDBC Thin Client
SELECT
sap.serv_acc_pt_id AS sapid,
so.option_name,
(SELEC
T cca.absolute_percent FROM service_option_values
s
ov, cos_class_allocation cca, traffic_profile
tp WH
ERE ssor.selected_opt_id =
sov.selected_opt_id AND sov
.name = 'Ingress Traffic Profile ID' AND sov.value =
TO_CHA
4,884,020 888
5,500.0
0.8 476.11 1257.05 2530711592
Module: JDBC Thin Client
select TICKET_MESSAGE_ID, STATUS, ORDER_ID, RETRY_CT,
REQUEST, R
ESPONSE, RECV_ACTION, RECV_AGENT,
TO_CHAR(CREATE_DATE,'YYYYMMDDH
H24MISS') CREATE_DATE, TO_CHAR(MOD_DATE,'YYYY-MM-DD
HH24:MI:SS')
MOD_DATE
from TICKET_MESSAGE where STATUS != 'SUCCESS' and RETR
Y_CT < 12 order by ticket_message_id
3,227,348 766
4,213.2
0.5 490.64 1481.34 1008621300
Module: JDBC Thin Client
SQL ordered by Gets for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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
--------------- ------------ -------------- ------
-------- --------- ----------
BEGIN
AracsPkg.createConfigletSP(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,
:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,
:27,:28,:29,:30,:31,:32,:33,:34); END;
2,897,510 679 4,267.3 0.5 30.00 53.62 720922393
Module: JDBC Thin Client
SELECT count(DISTINCT ip_port_asgmt_id) as COUNT FROM
(SELECT pa
.IP_PORT_ASGMT_ID, pa.CL_LOGICAL_LINK, pa.cl_number,
pa.INTERFAC
E_STRING,NVL(gm.UNHOOKED_IND, (SELECT DISTINCT gm1.UNHOOKED_IND
FROM
ip_group_map gm1, ip_port_asgmt pa1 WHERE pa1.APS_PAID = p
a.IP_PORT_ASGMT_ID AND pa1.SERV_ACC_PT_ID =
gm1.SERV_ACC_PT_ID )
2,692,974 7,575 355.5 0.4 1357.95 3909.01 3909189457
Module: JDBC Thin Client
BEGIN :1 := PortAsgmtPkg.get_ipd_port (:2,:3); END;
2,256,039 1,123,982
2.0 0.4 160.17 491.88 1307778841
select condition from cdef$ where rowid=:1
2,127,165
3
709,055.0
0.3 284.01 713.62 153009382
Module: JDBC Thin Client
SELECT
sap.serv_acc_pt_id AS sapid,
so.option_name,
(SELEC
T cca.absolute_percent FROM
service_option_values s
ov, cos_class_allocation cca, traffic_profile
tp WH
ERE ssor.selected_opt_id =
sov.selected_opt_id AND sov
.name = 'Ingress Traffic Profile ID' AND sov.value =
TO_CHA
1,909,038 253
7,545.6
0.3 19.08 31.33 1001815406
Module: JDBC Thin Client
SELECT DISTINCT a.site_id, a.complex, c.clli,
a.pop_provide
r FROM site
a, equipment b, premise c
WHERE a.cust_id = 4797
AND a.loc_id = c.loc_id AND b.site_id = a.site_id AND b.mpls =
'Y' ORDER BY
a.complex
1,531,423 258,075
5.9 0.2 51.96 160.35 916801287
Module: JDBC Thin Client
delete from na_discord d where d.equip_id=:1 and
d.CUST_INTERFAC
E_ID=( select c.cust_interface_id from na_cust_interface
c where
c.ip_port_asgmt_id=:2 ) and d.DISCORD_TYPE_ID=:3
1,440,313
4
360,078.3
0.2 11.29 38.66 841697796
Module: JDBC Thin Client
select unique cust_id, cust_name from ipd_customer where
mcn = '
W62665' and grc = '001' and soc = 'XN'
1,080,298
3
360,099.3
0.2
8.38
20.42 3954146079
Module: JDBC Thin Client
select unique cust_id, cust_name from ipd_customer where
mcn = '
SM5792' and grc = '001' and soc = '37'
SQL ordered by Gets for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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
--------------- ------------ -------------- ------
-------- --------- ----------
1,076,518 38,181
28.2 0.2 30.23 169.94 1567640100
Module: JDBC Thin Client
SELECT a.PROTOCOL, a.NUM_HOPS, a.AS_NUMBER,
a.LOOPBACK_ADDR, a.D
EFAULT_ORIGINATE, a.ROUTE_MAP_IN, a.DO_ROUTE_MAP,
a.ROUTE_MAP_OU
T, a.GROUP_ID, a.mod_date, d.last_upload_date FROM
ROUTE_PARAMET
ER a, NA_PORT b, RC_ACL c, equipment d WHERE
b.IP_PORT_ASGMT_ID=
c.PORTASSIGNMENT AND c.CONN_ID=a.CONN_ID AND
a.STATUS='PRINCIPAL
1,011,190 258,296
3.9 0.2 20.23 46.57 4265647904
Module: JDBC Thin Client
select longname from javasnm$ where short = :1
940,243 963
976.4 0.1 263.91 772.09 2474443579
Module:
? @bgttlsb (TNS V1-V3)
BEGIN BUGS_dba.aracstoolsvrpkg.addrequestinfosp(:orde
rnum); END;
833,765
77,558
10.8 0.1 19.97 83.22 742038233
Module: JDBC Thin Client
select
s.serv_name from ip_port_asgmt pa,
ip_serv_acc_pt sap,
service s
where pa.serv_acc_pt_id = sap.serv_acc_pt_id and sap
.serv_id = s.serv_id and pa.ip_port_asgmt_id = :1
-------------------------------------------------------------
SQL ordered by Reads for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
5,666,038 127 44,614.5 5.8 556.28 1584.69
896212474
Module: JDBC Thin Client
select
order_event_queue_id, type, instar_order_id, resource_id
, resource_type, event_name, event_status, create_date,
event_da
ta, processed_date, processed_status, processed_count,
processed
_history, jvm_user, resource_id1 from ORDER_EVENT_QUEUE
where pr
ocessed_status='Pending'
4,223,476 888
4,756.2
4.4 476.11 1257.05 2530711592
Module: JDBC Thin Client
select TICKET_MESSAGE_ID, STATUS, ORDER_ID, RETRY_CT,
REQUEST, R
ESPONSE, RECV_ACTION, RECV_AGENT,
TO_CHAR(CREATE_DATE,'YYYYMMDDH
H24MISS') CREATE_DATE, TO_CHAR(MOD_DATE,'YYYY-MM-DD
HH24:MI:SS')
MOD_DATE
from TICKET_MESSAGE where STATUS != 'SUCCESS' and RETR
Y_CT < 12 order by ticket_message_id
2,662,326 766
3,475.6
2.7 490.64 1481.34 1008621300
Module: JDBC Thin Client
BEGIN
AracsPkg.createConfigletSP(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,
:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,
:27,:28,:29,:30,:31,:32,:33,:34); END;
436,979
79
5,531.4
0.5 67.11 220.41 3962804998
Module: JDBC Thin Client
BEGIN
AracsRouteEntity.createAracsMplsVpnTblSP(:1,:2,:3,:4,:5,:6
,:7); END;
436,381
84
5,195.0 0.4 65.43 208.00 1527737429
Module: JDBC Thin Client
SELECT ROUTEID FROM ROUTES WHERE LENGTH = 0 AND FULLIP =
0 AND E
FULLIP = 0
307,514
14
21,965.3
0.3 62.22 161.38 2190087223
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
228,147
10
22,814.7
0.2 45.15 122.88 1888278687
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
176,686
8
22,085.8
0.2 35.21 124.30 2847560200
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
SQL ordered by Reads for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
158,476
7
22,639.4
0.2 31.80 80.87 1959045979
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
157,669
41
3,845.6
0.2 32.34 97.46 140866403
Module: JDBC Thin Client
SELECT DISTINCT s.complex FROM site s,
approved_gsr_location agl
WHERE
substr(s.clli, 1, 8) = agl.clli
145,702
6
24,283.7
0.2 27.71 61.22 1946610118
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
133,930
6
22,321.7
0.1 26.85 73.98 2579950882
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
.ORDER_SOURCE, io.CC_EMAIL, io.CC_NAME, io.CC_PHONE,
io.NETWORK_
103,921
21,047
4.9 0.1 8020.49 22566.30 3970553590
Module: JDBC Thin Client
UPDATE
ip_assigned_endpt SET pos_flag = :1 , pos_j0 = :2 , pos_
s1s0 = :3 , loop_back_freq = :4 ,
ip_direct_broadcast_status = :
5 , cdp_enable = :6
WHERE endpoint_id = :7
102,996
21,084
4.9 0.1 7993.60 22337.82 4077924789
Module: JDBC Thin Client
SELECT ENDPOINT_ID, EQUIP_ID, MLPPP_BUNDLE_ID,
RLSQ_NUMBER FROM
IP_ASSIGNED_ENDPT WHERE MLPPP_BUNDLE_ID IS NOT NULL AND
RLSQ_NUM
BER IS NOT NULL
96,478
15
6,431.9
0.1 35.57 140.03 1050364476
Module: oracle@brige1us005 (TNS V1-V3)
SELECT DISTINCT "A3"."OPTION_NAME"
FROM "SELECTED_OPTS_REL" "A5"
,"IP_SELECTED_OPTS"
"A4","IP_SERVICE_OPTIONS" "A3","IP_SERV_ACC_
PT" "A2","DOMAIN" "A1"
WHERE "A5"."SELECTED_OPT_ID"="A4"."SELECT
ED_OPT_ID" AND
"A4"."SERVICE_OPTION_ID"="A3"."SERVICE_OPTION_ID"
AND
"A5"."SERV_ACC_PT_ID"="A2"."SERV_ACC_PT_ID"
AND "A2"."CUST_
90,735
4
22,683.8
0.1 18.39 45.49 3634176319
Module: JDBC Thin Client
select io.INSTAR_ORDER_ID, io.ORDER_PAID, io.ASSOC_PAID,
io.ORDE
SQL ordered by Reads for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Disk Reads Threshold: 1000
CPU
Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
R_GROUP_ID, io.CONFIGLET_ID, io.PARENT_ORDER_ID,
io.CUST_ID, io.
HARD_DISC_ALLOWED, io.ORDER_TYPE,
TO_CHAR(io.DATE_RECEIVED, 'MM/
DD/YYYY HH24:MI:SS') DATE_RECEIVED, io.STATUS,
io.MOCARS_TKT, io
-------------------------------------------------------------
SQL ordered by Executions for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Executions Threshold: 100
CPU per Elap
per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
1,123,982 1,123,924
1.0
0.00 0.00 1307778841
select condition from cdef$ where rowid=:1
427,831
427,829
1.0
0.00 0.00 850135601
Module: JDBC Thin Client
INSERT /*+ IDX(0) */ INTO "BUGS_DBA"."MLOG$_NA_PORT"
(dmltype$$,
old_new$$,snaptime$$,change_vector$$,m_row$$) VALUES
(:d,:o,to_d
ate('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:m)
258,296 247,300
1.0
0.00 0.00 4265647904
Module: JDBC Thin Client
select longname from javasnm$ where short = :1
258,075
15
0.0
0.00 0.00 916801287
Module: JDBC Thin Client
delete from na_discord d where d.equip_id=:1 and
d.CUST_INTERFAC
E_ID=( select c.cust_interface_id from na_cust_interface
c where
c.ip_port_asgmt_id=:2 ) and d.DISCORD_TYPE_ID=:3
109,532 109,530
1.0
0.00 0.00 1778939861
Module: JDBC Thin Client
SELECT var_value FROM app_param WHERE var_name =
'CBB_CUST_ID' O
R var_name = 'CBB_CUST_ID'
85,545
1
0.0
0.00 0.00 3586375446
Module: JDBC Thin Client
delete from na_discord d where d.equip_id=:1 and
d.port_id=:2 an
d d.DISCORD_TYPE_ID=:3
79,046 79,047
1.0
0.00 0.00 1333943659
Module: JDBC Thin Client
select * from dual
77,558 77,558
1.0
0.00 0.00 742038233
Module: JDBC Thin Client
select
s.serv_name from ip_port_asgmt pa,
ip_serv_acc_pt sap,
service s
where pa.serv_acc_pt_id = sap.serv_acc_pt_id and sap
.serv_id = s.serv_id and pa.ip_port_asgmt_id = :1
76,443 76,443
1.0
0.00 0.00 4147957497
Module: JDBC Thin Client
Update na_port set IP_PORT_ASGMT_ID = :1 where
PORT_ID = :2
38,465 38,465
1.0
0.00 0.00 716844992
Module: JDBC Thin Client
SELECT 123 AS nnn FROM DUAL
38,181 35,573
0.9
0.00 0.00 1567640100
Module: JDBC Thin Client
SELECT a.PROTOCOL, a.NUM_HOPS, a.AS_NUMBER,
a.LOOPBACK_ADDR, a.D
EFAULT_ORIGINATE, a.ROUTE_MAP_IN, a.DO_ROUTE_MAP,
a.ROUTE_MAP_OU
T, a.GROUP_ID, a.mod_date, d.last_upload_date FROM
ROUTE_PARAMET
ER a, NA_PORT b, RC_ACL c, equipment d WHERE
b.IP_PORT_ASGMT_ID=
c.PORTASSIGNMENT AND c.CONN_ID=a.CONN_ID AND
a.STATUS='PRINCIPAL
SQL ordered by Executions for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Executions Threshold: 100
CPU per Elap
per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
37,018 37,018
1.0
0.00 0.00 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
35,121 38,686
1.1
0.00 0.00 1433558559
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
26,996 26,995
1.0
0.00 0.00 3854187849
Module: JDBC Thin Client
SELECT PROTOCOL FROM NA_PORT WHERE IP_PORT_ASGMT_ID=:1
24,387 301,358
12.4
0.00 0.00 1356713530
select privilege#,level from sysauth$ connect by
grantee#=prior
privilege# and privilege#>0 start with (grantee#=:1 or
grantee#=
1) and privilege#>0
21,671 21,671
1.0
0.00 0.00 4259105057
Module: JDBC Thin Client
INSERT /*+ IDX(0) */ INTO
"IPD_DBA"."MLOG$_IP_SERV_ACC_PT" (dmlt
ype$$,old_new$$,snaptime$$,change_vector$$,m_row$$)
VALUES (:d,:
o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:m)
21,648 21,648
1.0
0.00 0.00 433029110
Module: JDBC Thin Client
SELECT COUNT(*) FROM IP_SELECTED_OPTS A,
IP_SERVICE_OPTIONS B, S
ELECTED_OPTS_REL C WHERE :B1 = C.SERV_ACC_PT_ID AND
C.SELECTED_O
PT_ID = A.SELECTED_OPT_ID AND A.SERVICE_OPTION_ID =
B.SERVICE_OP
TION_ID AND B.OPTION_NAME = 'MLPPP'
21,141 21,141 1.0 0.00
0.00 4019494605
Module: JDBC Thin Client
INSERT /*+ IDX(0) */ INTO
"IPD_DBA"."MLOG$_IP_ASSIGNED_ENDPT" (d
mltype$$,old_new$$,snaptime$$,change_vector$$,m_row$$)
VALUES (:
d,:o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:
m)
21,084 126,531
6.0
0.38 1.06 4077924789
Module: JDBC Thin Client
SELECT ENDPOINT_ID, EQUIP_ID, MLPPP_BUNDLE_ID,
RLSQ_NUMBER FROM
IP_ASSIGNED_ENDPT WHERE MLPPP_BUNDLE_ID IS NOT NULL AND
RLSQ_NUM
BER IS NOT NULL
21,047 21,047
1.0
0.38 1.07 3970553590
Module: JDBC Thin Client
UPDATE
ip_assigned_endpt SET pos_flag = :1 , pos_j0 = :2 , pos_
s1s0 = :3 , loop_back_freq = :4 ,
ip_direct_broadcast_status = :
5 , cdp_enable = :6
WHERE endpoint_id = :7
20,947 20,947
1.0
0.00 0.00 40248596
Module: JDBC Thin Client
SELECT ioc1,
b.site_id, b.cust_id FROM
cust_access a, ip_serv_
acc_pt b, ip_port_asgmt c WHERE c.ip_port_asgmt_id = :1 AND c
SQL ordered by Executions for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Executions Threshold: 100
CPU per Elap
per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
.SERV_ACC_PT_ID = b.SERV_ACC_PT_ID AND b.SITE_ID = a.SITE_ID (+
)
20,929 20,929
1.0
0.00 0.00
3359219889
Module: JDBC Thin Client
UPDATE
ip_serv_acc_pt SET peer_neighbor = :1 , down_when_looped
= :2 ,
pp_lb_ind = :3 WHERE
serv_acc_pt_id = :4
19,795 19,794
1.0
0.00 0.00 2558652917
Module: JDBC Thin Client
select NAME, VALUE from INSTAR_PROPERTY where NAME = 'QueuedSet
WaitDays'
17,218 17,218
1.0
0.00 0.00 1064267497
Module: JDBC Thin Client
select SERV_ID, SERV_NAME, SERV_CAT from service where
SERV_ID =
15
16,722 16,722
1.0
0.00 0.00 4273161798
Module: JDBC Thin Client
select SERV_ACC_SPEED_ID, SPEED_VALUE, SPEED_STRING,
NIPA_ACCESS
_SPEED from ip_serv_acc_speed where SERV_ACC_SPEED_ID =
10
15,265
7,720
0.5
0.00 0.00 3514776141
Module: JDBC Thin Client
DELETE FROM TMP_IPD_PORT_TABLE
13,994 13,994
1.0
0.00 0.00 2039485708
Module: JDBC Thin Client
SELECT LOGICAL_DISCORD_ID, PORT_ID, IP_PORT_ASGMT_ID,
WAN_DISCOR
D_IND FROM NA_LOGICAL_DISCORD WHERE PORT_ID = :B2 OR
IP_PORT_ASG
MT_ID = :B1
-------------------------------------------------------------
SQL ordered by Parse Calls for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Parse Calls Threshold: 1000
% Total
Parse
Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,123,947
1,123,982 26.49
1307778841
select condition from cdef$ where rowid=:1
109,531
109,532
2.58 1778939861
Module: JDBC Thin Client
SELECT var_value FROM app_param WHERE var_name =
'CBB_CUST_ID' O
R var_name = 'CBB_CUST_ID'
79,047 79,046 1.86 1333943659
Module: JDBC Thin Client
select * from dual
38,465 38,465 0.91 716844992
Module: JDBC Thin Client
SELECT 123 AS nnn FROM DUAL
37,018 37,018 0.87 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
26,996 26,996 0.64 3854187849
Module: JDBC Thin Client
SELECT PROTOCOL FROM NA_PORT WHERE IP_PORT_ASGMT_ID=:1
24,387 24,387 0.57 1356713530
select privilege#,level from sysauth$ connect by
grantee#=prior
privilege# and privilege#>0 start with (grantee#=:1 or
grantee#=
1) and privilege#>0
19,795 19,795 0.47 2558652917
Module: JDBC Thin Client
select NAME, VALUE from INSTAR_PROPERTY where NAME = 'QueuedSet
WaitDays'
17,217 17,218 0.41 1064267497
Module: JDBC Thin Client
select SERV_ID, SERV_NAME, SERV_CAT from service where
SERV_ID =
15
16,722 16,722 0.39 4273161798
Module: JDBC Thin Client
select SERV_ACC_SPEED_ID, SPEED_VALUE, SPEED_STRING,
NIPA_ACCESS
_SPEED from ip_serv_acc_speed where SERV_ACC_SPEED_ID =
10
12,543 12,543 0.30 1065893717
Module: JDBC Thin Client
declare p varchar2(32767); begin p := EXPORT
_PREDICATE(:sn, :on);
:v1 := substr(p,1,4000)
; :v2 := substr(p,4001,4000);
:v3 := substr(p
,8001,4000); :v4 := substr(p,12001,4000);
:v5
:=
substr(p,16001,4000); :v6 := substr(p,20001,4000);
11,744 11,744 0.28 3570694802
SQL ordered by Parse Calls for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Parse Calls Threshold: 1000
% Total
Parse
Calls Executions Parses Hash Value
------------ ------------ -------- ----------
Module: JDBC Thin Client
ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'
11,738 11,738 0.28 1702556642
Module: JDBC Thin Client
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER
='NLS_
DATE_FORMAT'
11,738 11,738 0.28 2707901715
Module: JDBC Thin Client
ALTER SESSION SET NLS_TERRITORY = 'AMERICA'
11,111 11,111 0.26 2360020247
Module: JDBC Thin Client
select SERV_ACC_TYPE_ID, ACC_TYPE, SERV_ID from
IP_SERV_ACC_TYPE
where
SERV_ACC_TYPE_ID = 2
9,919
9,919
0.23 760952485
Module: JDBC Thin Client
SELECT regular_mtu, cl_vlan_mtu, cl_no_vlan_mtu,
no_cl_vlan_
mtu FROM
card_mtu WHERE card_model =
'CHOC12/DS1-IR-SC' AND i
nfrastructure = 'N'
8,950
8,950
0.21 3830662532
Module: JDBC Thin Client
select distinct network from role
8,268
8,268
0.19 1545607257
Module: JDBC Thin Client
select SERV_ACC_SPEED_ID, SPEED_VALUE, SPEED_STRING,
NIPA_ACCESS
_SPEED from ip_serv_acc_speed where SERV_ACC_SPEED_ID =
937
8,133
9,429
0.19 1904588952
Module: JDBC Thin Client
INSERT /*+ IDX(0) */ INTO
"PROV_DBA"."MLOG$_RM_RESOURCE_LOCK" (d
mltype$$,old_new$$,snaptime$$,change_vector$$,m_row$$)
VALUES (:
d,:o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:
m)
7,957
7,957
0.19 3360804353
select default$ from col$ where rowid=:1
7,619
7,619
0.18 1614648503
Module: JDBC Thin Client
SELECT * FROM TMP_IPD_PORT_TABLE
7,575
7,575
0.18 3909189457
Module: JDBC Thin Client
BEGIN :1 := PortAsgmtPkg.get_ipd_port (:2,:3); END;
7,367
7,367
0.17 3997906522
select user# from sys.user$ where name = 'OUTLN'
7,336
7,336
0.17 2920189473
SQL ordered by Parse Calls for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses
Hash Value
------------ ------------ -------- ----------
Module: JDBC Thin Client
LOCK TABLE rm_resource_lock IN EXCLUSIVE MODE
6,690
7,646
0.16 1980305124
select
grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)
)from objauth$ where obj#=:1 group by
grantee#,privilege#,nvl(co
l#,0) order by grantee#
6,607
6,607
0.16 1480390431
Module: JDBC Thin Client
select SERV_ID, SERV_NAME, SERV_CAT from service where
SERV_ID =
30
6,479
6,479
0.15 1685859087
Module: JDBC Thin Client
select SERV_ACC_TYPE_ID, ACC_TYPE, SERV_ID from
IP_SERV_ACC_TYPE
where
SERV_ACC_TYPE_ID = 20
6,096
6,096
0.14 1778858624
Module: JDBC Thin Client
select SERV_ACC_SPEED_ID, SPEED_VALUE, SPEED_STRING,
NIPA_ACCESS
_SPEED from ip_serv_acc_speed where SERV_ACC_SPEED_ID =
71
5,981
6,191
0.14 2720233364
Module: JDBC Thin Client
INSERT /*+ IDX(0) */ INTO "BUGS_DBA"."MLOG$_CGEN_LOCKS"
(dmltype
$$,old_new$$,snaptime$$,change_vector$$,m_row$$) VALUES
(:d,:o,t
o_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c,:m)
5,901
8,171
0.14 839312984
select
name,intcol#,segcol#,type#,length,nvl(precision#,0),decod
e(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180
,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedsto
rage,nvl(deflength,0),default$,rowid,col#,property,
nvl(charseti
d,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from
col$ wh
5,796
7,965
0.14 1480155015
select
i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,
i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i
.distkey,
i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.sa
-------------------------------------------------------------
SQL ordered by Sharable Memory for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b)
Executions % Total Hash Value
---------------- ------------ ------- ------------
3,268,364
1
0.2 1061059250
Module: JDBC Thin Client
select case when ptnii_equip_name not like '%er8' then
nvl((sele
ct ptnii_equip_name from ip_equipment E where E.equip_id
= ip_eq
uipment.outer_equip_id), ptnii_equip_name)
else nvl(alias_name
, ptnii_equip_name) end ChassisName, (select alias_name from ip
_equipment E where E.equip_id = ip_equipment.equip_id and equip
-------------------------------------------------------------
SQL ordered by Version Count for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> End Version Count Threshold: 20
Version
Count Executions Hash Value
-------- ------------ ------------
36 229 2017163951
Module: JDBC Thin Client
DELETE FROM TMP_ARACS_RESULTS WHERE RESULT = :B1
-------------------------------------------------------------
Instance Activity Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
Statistic
Total per Second per Trans
--------------------------------- ------------------
-------------- ------------
CPU used by this session
4,741,108 1,318.4
22.2
CPU used when call started
4,740,579 1,318.3
22.2
CR blocks created
15,635,403
4,348.0 73.4
Cached Commit SCN referenced
0
0.0 0.0
Commit SCN cached
0 0.0 0.0
DBWR buffers scanned
4,226,972
1,175.5 19.8
DBWR checkpoint buffers written
1,302,921 362.3 6.1
DBWR checkpoints
24
0.0 0.0
DBWR free buffers found
4,114,215 1,144.1
19.3
DBWR lru scans
3,830
1.1 0.0
DBWR make free requests
4,201
1.2 0.0
DBWR revisited being-written buff
425
0.1 0.0
DBWR summed scan depth
4,226,972
1,175.5 19.8
DBWR transaction table writes
11,603
3.2 0.1
DBWR undo block writes
91,819
25.5 0.4
SQL*Net roundtrips to/from client
17,965,862 4,996.1
84.3
active txn count during cleanout
9,749,422 2,711.2
45.7
background checkpoints completed
24
0.0 0.0
background checkpoints started
24
0.0 0.0
background timeouts
4,681
1.3 0.0
branch node splits
0
0.0 0.0
buffer is not pinned count
465,932,166 129,569.6 2,185.7
buffer is pinned count
289,698,977 80,561.5 1,359.0
bytes received via SQL*Net from c 1,583,375,178 440,315.7 7,427.7
bytes sent via SQL*Net to client
2,093,077,534 582,057.2 9,818.7
calls to get snapshot scn: kcmgss
10,519,739 2,925.4
49.4
calls to kcmgas
16,062,183 4,466.7
75.4
calls to kcmgcs
78,149
21.7 0.4
change write time
106,876
29.7 0.5
cleanout - number of ktugct calls
7,984,009 2,220.3
37.5
cleanouts and rollbacks - consist
7,851,816 2,183.5
36.8
cleanouts only - consistent read
38,548
10.7 0.2
cluster key scan block gets
339,955
94.5 1.6
cluster key scans
82,909
23.1 0.4
commit cleanout failures: block l
22,809
6.3 0.1
commit cleanout failures: buffer
2,247
0.6 0.0
commit cleanout failures: callbac
10,406
2.9 0.1
commit cleanout failures: cannot
764
0.2 0.0
commit cleanout failures: hot bac
0
0.0 0.0
commit cleanouts
889,455 247.4 4.2
commit cleanouts successfully com
853,229 237.3 4.0
commit txn count during cleanout
73,126
20.3 0.3
consistent changes
35,124,807
9,767.7 164.8
consistent gets
622,376,906
173,074.8
2,919.6
consistent gets - examination
204,942,687 56,991.9
961.4
current blocks converted for CR
91,841
25.5 0.4
cursor authentications
295,885
82.3 1.4
data blocks consistent reads - un
34,857,425 9,693.4
163.5
db block changes
19,706,408 5,480.1
92.4
db block gets
10,782,722 2,998.5
50.6
deferred (CURRENT) block cleanout
395,036 109.9 1.9
dirty buffers inspected
22,120
6.2 0.1
enqueue conversions
25,697
7.2 0.1
enqueue deadlocks
0
0.0 0.0
enqueue releases
1,865,088
518.7 8.8
enqueue requests
1,864,905 518.6 8.8
Instance Activity Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
Statistic
Total per
Second per Trans
--------------------------------- ------------------
-------------- ------------
enqueue timeouts
1
0.0 0.0
enqueue waits
558
0.2 0.0
exchange deadlocks
6
0.0 0.0
execute count
7,790,953 2,166.6
36.6
failed probes on index block recl
204
0.1 0.0
free buffer inspected
2,225,722
618.9 10.4
free buffer requested
112,060,550 31,162.6
525.7
hot buffers moved to head of LRU
1,762,868 490.2 8.3
immediate (CR) block cleanout app
7,890,364 2,194.2
37.0
immediate (CURRENT) block cleanou
47,791 13.3 0.2
index crx upgrade (found)
164
0.1 0.0
index crx upgrade (positioned)
368,819 102.6 1.7
index fast full scans (full)
3,688
1.0 0.0
index fetch by key
65,717,444
18,275.2 308.3
index scans kdiixs1
47,304,773 13,154.8
221.9
leaf node 90-10 splits
407
0.1 0.0
leaf node splits
945
0.3 0.0
logons cumulative
16,576
4.6 0.1
messages received
397,704 110.6 1.9
messages sent
397,706 110.6 1.9
no buffer to keep pinned count
0
0.0 0.0
no work - consistent read gets
398,741,006 110,884.6 1,870.5
opened cursors cumulative
4,192,901 1,166.0
19.7
parse count (failures)
121
0.0 0.0
parse count (hard)
837,437 232.9 3.9
parse count (total)
4,242,522
1,179.8 19.9
parse time cpu
693,768 192.9 3.3
parse time elapsed
2,315,724
644.0 10.9
physical reads
97,018,453 26,979.6
455.1
physical reads direct
883,820
245.8 4.2
physical reads direct (lob)
32,902
9.2 0.2
physical writes
2,261,581 628.9
10.6
physical writes direct
800,996
222.8 3.8
physical writes direct (lob)
25,188
7.0 0.1
physical writes non checkpoint
1,226,520 341.1 5.8
pinned buffers inspected
43,118
12.0 0.2
prefetch clients - default
1
0.0 0.0
prefetched blocks
56,998,997
15,850.7 267.4
prefetched blocks aged out before
96
0.0 0.0
process last non-idle time
3,594
1.0
0.0
recovery blocks read
0
0.0 0.0
recursive aborts on index block r
5
0.0 0.0
recursive calls
16,778,279 4,665.8
78.7
recursive cpu usage
1,076,551
299.4 5.1
redo blocks written
4,939,862
1,373.7 23.2
redo buffer allocation retries
7,583 2.1 0.0
redo entries
13,818,007 3,842.6
64.8
redo log space requests
713
0.2 0.0
redo log space wait time
3,660
1.0 0.0
redo ordering marks
0
0.0 0.0
redo size
2,416,739,376 672,063.2 11,337.0
redo synch time
94,418
26.3 0.4
redo synch writes
108,366
30.1 0.5
redo wastage
36,722,756 10,212.1
172.3
redo write time
51,433
14.3 0.2
redo writer latching time
6,389
1.8 0.0
Instance Activity Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
Statistic
Total per
Second per Trans
--------------------------------- ------------------
-------------- ------------
redo writes
148,304
41.2 0.7
rollback changes - undo records a
17,833
5.0 0.1
rollbacks only - consistent read
8,247,503 2,293.5
38.7
rows fetched via callback
52,563,830 14,617.3
246.6
session connect time
0
0.0 0.0
session cursor cache count
1,351
0.4 0.0
session cursor cache hits
1,648,207 458.3 7.7
session logical reads
633,126,745 176,064.2 2,970.0
session pga memory
18,957,808
5,271.9 88.9
session pga memory max
19,040,848 5,295.0
89.3
session uga memory
248,217,448
69,026.0
1,164.4
session uga memory max
3,377,447,568 939,223.5 15,843.7
shared hash latch upgrades - no w
16,678,668 4,638.1
78.2
shared hash latch upgrades - wait
233
0.1 0.0
sorts (disk)
200
0.1 0.0
sorts (memory)
789,295 219.5 3.7
sorts (rows)
63,039,443 17,530.4
295.7
summed dirty queue length
168,080
46.7 0.8
switch current to new buffer
72,127
20.1 0.3
table fetch by rowid
190,918,799 53,092.0
895.6
table fetch continued row
364,183 101.3 1.7
table scan blocks gotten
267,338,146 74,343.2 1,254.1
table scan rows gotten
15,148,631,299
4,212,633.8
71,062.6
table scans (direct read)
0
0.0 0.0
table scans (long tables)
8,495
2.4 0.0
table scans (short tables)
483,533 134.5 2.3
transaction rollbacks
164
0.1 0.0
transaction tables consistent rea
64
0.0 0.0
transaction tables consistent rea
4,703
1.3 0.0
user calls
18,005,643 5,007.1
84.5
user commits
146,569
40.8 0.7
user rollbacks
66,604
18.5 0.3
write clones created in backgroun
41
0.0 0.0
write clones created in foregroun
104,174 29.0 0.5
-------------------------------------------------------------
Tablespace IO Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
DATA2
35,653,763 9,915 0.3 2.3 650,034 181 122,468 6.7
DATA3
1,748,631
486 1.0 2.3 441,421 123 8,457 59.5
TEMP
451,589 126 6.6 2.0 590,530 164
0 0.0
DATA
885,599 246 1.1 11.3
16,385 5
245 41.6
DATA4
479,716 133 0.8 2.8
77,885 22 4,485 7.4
INDX3
274,740 76 8.2 1.2
83,550 23 409 41.1
UNDO_TS
1,814 1 3.1 1.0 103,218 29
995 18.1
INDX2
56,113 16 3.5 1.1
24,367 7
66 38.8
TOOLS
2,567 1 1.9 5.1
35,532 10 0 0.0
SYSTEM
27,119 8 0.5 1.1
4,082 1
124 8.9
INDX
4,563 1 12.9 1.0 5,832 2
19 57.4
PERFSTAT
1,379 0 4.3 1.1 356 0 0 0.0
TEMP2
75
0 196.5 5.2 387 0 0 0.0
AUDITS
96
0 1.5 1.0 114 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
AUDITS
/u07/oradata/BUGS/audits_01.dbf
96
0 1.5 1.0 114
0 0
DATA
/u02/oradata/BUGS/data_06.dbf
124,349 35 0.8 11.2
36 0
0
/u02/oradata/BUGS/data_08.dbf
112,458 31 1.4 9.8
3,529 1
5 36.0
/u02/oradata/BUGS/data_09.dbf
16,707 5 2.6 4.2
6,185 2
197 47.1
/u03/oradata/BUGS/data_01.dbf
89,276 25 1.1 12.5 255
0
1 10.0
/u03/oradata/BUGS/data_02.dbf
92,403 26 1.2 12.9 142 0 3 3.3
/u03/oradata/BUGS/data_03.dbf
92,229 26 1.0 12.0
2,320 1 8 58.8
/u03/oradata/BUGS/data_04.dbf
126,033 35 0.8 11.5 528
0
7 18.6
/u03/oradata/BUGS/data_05.dbf
69,984 19 1.1 9.5
2,546 1
21 5.7
/u03/oradata/BUGS/data_07.dbf
70,614 20 1.0 11.6 258 0 1 0.0
/u07/oradata/BUGS/data_05.dbf
91,546 25 0.9 12.2 586 0 2 0.0
DATA2
/u02/oradata/BUGS/data2_04.dbf
5,294,616 1,472 0.3 2.0 110,173 31 18,886 6.2
/u03/oradata/BUGS/data2_01.dbf
8,123,947 2,259 0.3 2.5
88,060 24 25,440 7.1
/u03/oradata/BUGS/data2_02.dbf
7,949,672 2,211 0.3 2.5
80,037 22 22,623 7.6
/u03/oradata/BUGS/data2_03.dbf
6,045,119 1,681 0.3 2.3 124,070 35 18,951 7.0
/u03/oradata/BUGS/data2_05.dbf
4,705,798 1,309 0.5 1.9 131,636 37 19,872 6.3
/u03/oradata/BUGS/data2_06.dbf
2,798,589
778 0.4 1.9
91,134 25 13,448 5.9
/u03/oradata/BUGS/data2_07.dbf
736,022 205 0.2 1.7
24,924 7 3,248 4.7
DATA3
/u03/oradata/BUGS/data3_01.dbf
732,660 204 0.9 2.4 170,477 47 3,307 53.6
/u03/oradata/BUGS/data3_02.dbf
960,424 267 1.2 2.3 251,648 70 4,975 63.4
/u03/oradata/BUGS/data3_03.dbf
55,547 15 0.4 1.8
19,296 5
175 58.5
DATA4
/u07/oradata/BUGS/data4_01.dbf
241,091 67 0.8 2.8
40,711 11 2,121 6.7
/u07/oradata/BUGS/data4_02.dbf
238,625 66 0.9 2.8
37,174 10 2,364 8.0
INDX
/u04/oradata/BUGS/indx_01.dbf
File IO Stats for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
2,482 1 13.9 1.0 2,046 1
15 72.0
INDX
/u04/oradata/BUGS/indx_02.dbf
793
0 17.7 1.0 963 0 1 0.0
/u04/oradata/BUGS/indx_03.dbf
1,288 0 8.1 1.0
2,823 1 3 3.3
INDX2
/u04/oradata/BUGS/indx2_01.dbf
28,191 8 3.7 1.1
12,110 3
46 50.9
/u04/oradata/BUGS/indx2_02.dbf
27,922 8 3.3 1.1
12,257 3
20 11.0
INDX3
/u04/oradata/BUGS/indx3_01.dbf
256,358 71 8.7 1.2
70,275 20 393 41.9
/u04/oradata/BUGS/indx3_02.dbf
18,382 5 1.7 1.1
13,275 4
16 20.6
PERFSTAT
/u07/oradata/BUGS/pstat_01.dbf
438
0 2.8 1.1 100 0 0
/u07/oradata/BUGS/pstat_02.dbf
436
0 4.2 1.1 109 0 0
/u07/oradata/BUGS/pstat_03.dbf
505
0 5.6 1.1 147 0 0
SYSTEM
/u02/oradata/BUGS/system_01.dbf
27,119 8 0.5 1.1
4,082 1
124 8.9
TEMP
/u02/oradata/BUGS/temp_01.dbf
451,589 126 6.6 2.0 590,530 164
0
TEMP2
/u02/oradata/BUGS/temp2_01.dbf
75
0 196.5 5.2 387 0 0
TOOLS
/u02/oradata/BUGS/tools_01.dbf
175
0 2.0 6.6
32 0 0
/u02/oradata/BUGS/tools_02.dbf
34
0 3.5 1.0
34 0 0
/u02/oradata/BUGS/tools_03.dbf
26
0 11.2 1.0
26 0 0
/u02/oradata/BUGS/tools_04.dbf
24
0 8.3 1.0
24 0 0
/u02/oradata/BUGS/tools_05.dbf
978
0 1.1 5.5
15,869 4 0
/u02/oradata/BUGS/tools_06.dbf
1,330 0 2.1 4.9
19,547 5 0
UNDO_TS
/u04/oradata/BUGS/undo_ts_01.dbf
1,814 1 3.1 1.0 103,218 29
995 18.1
-------------------------------------------------------------
Buffer Pool Statistics for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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 198,500 84.7 626,010,146
96,070,795 1,433,993 0 5
137,275
-------------------------------------------------------------
Instance Recovery Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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
0 13 2612 11259 10000 184320 485278 10000
E
0 11 1701 24627 10000 184320 527334 10000
-------------------------------------------------------------
Buffer Pool Advisory for DB: BUGS Instance: BUGS End Snap: 8969
-> 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
160 .1
19,850 2.83 1,130,113,659
D
320 .2
39,700 2.42
967,471,943
D
480 .3
59,550 2.15
859,295,488
D
640 .4
79,400 1.92
764,379,955
D
800 .5
99,250 1.70
678,920,848
D
960 .6
119,100 1.52
605,179,714
D 1,120 .7 138,950 1.36
541,161,145
D 1,280 .8 158,800 1.22
486,970,449
D 1,440 .9 178,650 1.10
440,297,428
D 1,600 1.0 198,500 1.00
399,106,578
D 1,760 1.1 218,350 0.91
363,532,885
D 1,920 1.2 238,200 0.83
332,739,006
D 2,080 1.3 258,050 0.77
307,827,705
D 2,240 1.4 277,900 0.72
287,167,954
D 2,400 1.5 297,750 0.68
269,863,735
D 2,560 1.6 317,600 0.64
254,016,040
D 2,720 1.7 337,450 0.59
237,147,433
D 2,880 1.8 357,300 0.55
217,559,272
D 3,040 1.9 377,150 0.50
198,184,377
D 3,200 2.0 397,000 0.43
170,785,306
-------------------------------------------------------------
Buffer wait Statistics for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> ordered by wait time desc, waits desc
Tot Wait Avg
Class
Waits Time (s) Time
(ms)
------------------ ----------- ---------- ---------
data block
136,223
1,389
10
undo block
569 12 22
undo header
426 6 13
bitmap block
21 1 59
segment header
28 0
6
bitmap index block 1 0 50
-------------------------------------------------------------
Enqueue activity for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> 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 198,477 198,478 0 52 33,224.56
1,728
TM 660,226 660,218 0
444
74.86 33
SQ 1,804
1,804 0 51
49.51
3
HW 15,010
15,010 0 11
96.18
1
-------------------------------------------------------------
Rollback Segment Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->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
24.0 0.00
0 0
0 0
1 6,078.0 0.00
4,953,388 2
0
2
2 6,920.0 0.00 36,633,380 14
0
4
3 4,844.0 0.00
3,233,242
0 0 0
4 6,996.0 0.00
7,079,882 1
0
0
5 5,174.0 0.00
4,986,894 1
1
0
6 8,294.0 0.00 16,009,180
4 0 1
7 7,895.0 0.00
7,044,898 2
3
0
8 4,225.0 0.00
6,896,306 2
0
0
9 5,024.0 0.00
4,861,722 0
0
0
10
12,868.0
0.00
17,715,808 3
1 2
11 7,009.0 0.00
7,444,020 1
0
0
12 4,949.0 0.00
4,907,286 0
0
0
13 7,071.0 0.00
6,065,460 1
1
0
14 4,848.0 0.00
5,555,948 1
0
0
15 4,636.0 0.00
2,102,610 0
0
0
16 7,803.0 0.00
5,749,834 1
1
0
17 6,446.0 0.02
4,674,988 0
0
0
18 7,329.0 0.00
5,111,218 0
0
0
19 3,743.0 0.00
3,328,804 1
0
0
20 8,433.0 0.00 14,172,558
1 0 0
21 5,247.0 0.00
6,601,438 1
0
0
22 5,085.0 0.00
5,083,566 0
0
0
23 6,433.0 0.00
7,688,762 1
0 0
24 7,581.0 0.00
4,820,058 1
0
0
25 7,827.0 0.01
8,926,718 6
1
4
26
14,321.0
0.00
64,878,722 50 0 49
27
10,408.0
0.00
13,274,004 1
0
0
28 5,616.0 0.00
6,670,730 2
0
1
29 3,959.0 0.00
4,376,232 0
0
0
30 3,157.0 0.00
1,259,030 0 0 0
31 5,986.0 0.00
3,312,806 0
0
0
32 6,279.0 0.00
5,401,932 0
0
0
33 3,789.0 0.00
3,781,268 1
0
0
34 8,092.0 0.00 18,213,638
5 1 0
35 7,388.0 0.00
6,687,384 0
0
0
36 6,733.0 0.00 12,791,698
4 1 0
37 8,684.0 0.00
6,336,704 1 0 0
38 5,556.0 0.00 11,497,718
1 0 0
39 8,152.0 0.00
6,963,496 1
0
0
40
10,434.0
0.05
26,304,084 4
3
0
41 5,656.0 0.00
6,202,680 1
0
0
42
10,994.0
0.01
7,945,190 1
0
0
43 9,468.0 0.00
8,372,718 1
1
0
44 6,214.0 0.00
4,102,444 0
0 0
45 6,781.0 0.04
7,500,390 4
1
0
46 8,841.0 0.00
8,336,124 2
1
0
47
10,251.0
0.00
9,342,484 1
0
0
48 6,999.0 0.00 12,971,228
1 0 0
49 7,375.0 0.00
4,210,852 0
0
0
50 3,468.0 0.00
3,140,710 0
0
0
51 5,578.0 0.00 5,061,736
4 0 4
Rollback Segment Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->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
------ -------------- ------- --------------- -------- --------
--------
52
11,029.0
0.00
6,044,288 3
0
0
53 6,500.0 0.00
7,627,404 2
0
2
54 3,710.0 0.00
2,850,776 1
0
0
55 3,523.0 0.00
3,044,854 3
0
3
56 6,796.0 0.00
8,364,194 4
1
0
57 9,535.0 0.00 10,892,890 11
0
11
58 4,915.0 0.00
5,311,580
5
0 5
59 6,953.0 0.00
5,319,324 4
0
0
60 4,642.0 0.00
2,865,052 3
0
3
61 8,253.0 0.00
9,831,378 10 0 10
62
10,759.0
0.00
8,478,598 8
0
8
63 5,703.0 0.00 10,643,684
8 1 4
64
10,547.0
0.00
16,199,188 2
0
0
65 5,089.0 0.00 5,510,020
0 0 0
66 7,437.0 0.00 12,584,792
6 0 0
67 8,133.0 0.00 20,713,656 18
0
15
68 4,800.0 0.00
3,652,422 4
3
0
69 7,228.0 0.01
9,721,430 7
0
7
70 6,793.0 0.01
9,072,060 6
2
0
-------------------------------------------------------------
Rollback Segment Storage for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->Optimal Size should be larger than Avg Active
RBS No
Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- ---------------
---------------
0
4,988,928 15,564
4,988,928
1
186,769,408 26,158,959
1,177,673,728
2
81,911,808
13,177,416
1,021,435,904
3
61,988,864
40,242,266
901,898,240
4
74,571,776
20,203,918
881,975,296
5
79,814,656 5,977,634
1,010,950,144
6
141,680,640 20,520,959
723,640,320
7
74,571,776 4,409,130
690,085,888
8
71,426,048 5,418,740
519,168,000
9
92,397,568 3,744,376
350,347,264
10
133,292,032 8,959,447
533,848,064
11 69,328,896 5,652,928
344,055,808
12
131,194,880 10,919,220
339,861,504
13
87,154,688 4,478,785
403,824,640
14
110,223,360 27,058,651
424,796,160
15
103,931,904 3,590,256
221,372,416
16
103,931,904 3,994,829
338,812,928
17
86,106,112 4,909,894
303,161,344
18 100,786,176
8,931,829
184,672,256
19
72,474,624 5,911,737
340,910,080
20
85,057,536
25,454,156
307,355,648
21
56,745,984 2,751,414
207,740,928
22
151,117,824 20,704,882
160,555,008
23
80,863,232 6,545,441
159,506,432
24
78,766,080 4,910,099
167,895,040
25
84,008,960 2,516,504
92,397,568
26
114,417,664 31,058,606
180,477,952
27
74,571,776 6,580,434
252,829,696
28
95,543,296 5,100,766
230,809,600
29
84,008,960 8,877,422
151,117,824
30
85,057,536 4,400,952
149,020,672
31
159,506,432 20,426,814
207,740,928
32
106,029,056 17,623,458
267,509,760
33
107,077,632 11,559,226
218,226,688
34
74,571,776 5,925,534
217,178,112
35
97,640,448 7,728,290
226,615,296
36
81,911,808 4,402,550
217,178,112
37
100,786,176 3,988,616
147,972,096
38
110,223,360 14,589,101
178,380,800
39
107,077,632 4,894,181
211,935,232
40
60,940,288 7,043,546
245,489,664
41
78,766,080 6,126,717
251,781,120
42
86,106,112 5,307,311
184,672,256
43
84,008,960 8,217,424
206,692,352
44
81,911,808 5,016,428
140,632,064
45
76,668,928 5,572,273
192,012,288
46
79,814,656 3,827,887 394,387,456
47
71,426,048 5,718,878
155,312,128
48
71,426,048 6,798,869
122,806,272
49
88,203,264 5,659,931
142,729,216
50
55,697,408 2,196,047
55,697,408
51
89,251,840
16,299,338
89,251,840
52
51,503,104 2,393,473
59,891,712
53
88,203,264 3,333,072 88,203,264
54
53,600,256 2,952,451
53,600,256
Rollback Segment Storage for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->Optimal Size should be larger than Avg Active
RBS No
Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- ---------------
---------------
55
42,065,920 1,351,094
42,065,920
56
44,163,072 1,402,762
47,308,800
57 64,086,016 2,025,676
64,086,016
58
54,648,832 2,187,505
54,648,832
59
42,065,920 1,560,909
42,065,920
60
99,737,600 6,568,330
99,737,600
61
55,697,408 1,944,267
55,697,408
62
61,988,864 1,458,014
61,988,864
63
43,114,496 2,564,653
48,357,376
64 47,308,800 2,434,445
74,571,776
65
43,114,496 4,199,790
48,357,376
66
47,308,800 1,396,034
47,308,800
67
70,377,472 5,837,933
137,486,336
68
45,211,648 1,520,949
94,494,720
69
74,571,776
10,836,058
74,571,776
70
45,211,648 1,720,957
71,426,048
-------------------------------------------------------------
Undo Segment Summary for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> 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
---- -------------- ---------- -------- ----------
-------- ------ -------------
15
76,182 ##########
1,953
61 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> 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
------------ ------------ -------- ------- --------
------- ------ -------------
08-May 14:53 8,460 ######## 1,953 55 0 0 0/0/0/0/0/0
08-May 14:43 6,890 ######## 1,713 45 0 0 0/0/0/0/0/0
08-May 14:33 11,282 ######## 1,118 58 0 0 0/0/0/0/0/0
08-May 14:23 33,787 ######## 636 56 0 0 0/0/0/0/0/0
08-May 14:13 7,269 ######## 476 60 0 0 0/0/0/0/0/0
08-May 14:03 8,494 ######## 436 61 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
->"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
------------------------ -------------- ------ ------
------ ------------ ------
Consistent RBA
148,397 0.0 0.2 0
0
FAL request queue
72 0.0
0
0
FIB s.o chain latch
192 0.0
0
0
FOB s.o list latch
92,967 0.0 0.2 0
0
JOX SGA heap latch
302,057
0.0
0
0
SQL memory manager worka
67 0.0
0
0
active checkpoint queue 250,391 1.1 0.0 0
0
alert log latch
96 0.0
0
0
archive control
205 0.0
0
0
archive process latch
192 0.0
0
0
begin backup scn array
11,134 0.0
0
0
cache buffer handles 3,101,380 0.1 0.1 7
0
cache buffers chains 1,287,056,955 0.1 0.1 4311 204,186,588 1.1
cache buffers lru chain 1,815,310 3.2 0.2 494 263,764,600 8.8
channel handle pool latc 41,113 0.0 1.0 0
0
channel operations paren 113,862 0.4 0.0 0
0
checkpoint queue latch 35,347,877 0.0 0.1 3 1,428,868 0.0
child cursor hash table 5,982,929 0.5 0.3 115 0
commit callback allocati 2,411 0.0
0
0
constraint object alloca 2,393 0.1 0.0 0
0
dictionary lookup
3 0.0
0
0
dml lock allocation
1,308,537
0.2 0.1 2
0
dummy allocation
33,166 0.0 0.0 0
0
enqueue hash chains
3,757,035
0.0 0.2 8
0
enqueues
2,664,836 0.4 0.1
32
0
event group latch
16,579 0.0
0
0
global tx hash mapping
51,706 0.0
0
0
ktm global data
9,549 0.0
0
0
lgwr LWN SCN
148,555 0.0 0.0 0
0
library cache
102,444,638
2.4 0.3 8974 2,439,090 9.8
library cache load lock 104,224 0.0 0.1 0
0
library cache pin 47,576,850 0.1 0.1 149
0
library cache pin alloca 30,027,160 0.2 0.1 149
0
list of block allocation 53,707 0.0 0.3 0
0
loader state object free 39,724 0.0 0.8 1
0
longop free list parent
4,149 0.0
0 3,184 0.0
message pool operations 21,544 0.3 0.0 0
0
messages
1,211,699 0.3 0.0 2
0
mostly latch-free SCN
151,628
0.3 0.1 0
0
multiblock read objects 75,667,945 6.6 0.0
8412
0
ncodef allocation latch
827 0.0
0
0
object stats modificatio
82 0.0
0
0
post/wait queue
172,881 0.0 0.0 0 108,595 0.0
presentation list
1 0.0
0
0
process allocation
33,177 0.2 0.9 1 16,556 0.1
process group creation
33,177 0.0 0.0 0
0
redo allocation
14,131,896
0.9 0.1 287
0
redo copy
0
0 13,859,196 0.6
redo writing
698,688 0.1 0.1 1
0
row cache enqueue latch 300,922,214 8.9 0.0 780
0
Latch Activity for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
->"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
------------------------ -------------- ------ ------
------ ------------ ------
row cache objects
301,591,381
1.1 0.0 1866 34,361 0.4
sequence cache
175,163 0.0 0.1 0
0
session allocation
1,552,168
0.2 0.2 18
0
session idle bit
36,639,007
0.0 0.2 34
0
session switching
829 0.0
0
0
session timer
1,705 0.0
0
0
shared java pool
28,253 0.0
0
0
shared pool
77,478,493 4.8 0.1 2238
0
simulator hash latch 42,215,667 0.0 0.3 20
0
simulator lru latch
2,549,639
0.6 0.5 366 7,042,166 0.4
sort extent pool
82,796 0.1 0.1 0
0
temp lob duration state
1,892 0.0
0
0
temporary table state ob 6,535 0.0
0
0
transaction allocation 34,798 0.0 0.0 0
0
transaction branch alloc 52,533 0.0 0.0 0
0
undo global data
30,190,963
0.1 0.1 69 804 0.0
user lock
162,203 0.8 0.7 16
0
-------------------------------------------------------------
Latch Sleep breakdown for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> ordered by misses desc
Get
Spin
&
Latch Name
Requests
Misses
Sleeps Sleeps 1->4
-------------------------- -------------- -----------
----------- ------------
row cache enqueue latch 300,922,214 26,813,321 63,353 26750538/622
16/564/3/0
multiblock read objects 75,667,945 4,975,788 181,924 4797139/1753
98/3227/24/0
shared pool
77,478,493 3,683,712 499,072 3207833/4551
46/18888/184
5/0
row cache objects
301,591,381
3,299,463
83,466 3216692/8208
1/685/5/0
library cache
102,444,638 2,425,460 648,082 1813686/5791
32/29594/304
8/0
cache buffers chains 1,287,056,955 1,111,534 143,794 1023579/6408
4/9194/14682
/0
redo allocation
14,131,896
133,222 9,386 123896/9266/
60/0/0
library cache pin
47,576,850
62,174 6,825 55358/6807/9
/0/0
cache buffers lru chain 1,815,310 58,040 13,560
44605/13310/
125/0/0
library cache pin allocati 30,027,160 46,647 6,514 40150/6480/1
7/0/0
child cursor hash table 5,982,929 29,355 7,848
21544/7774/3
7/0/0
undo global data
30,190,963
18,853 1,998 16862/1984/7
/0/0
simulator lru latch
2,549,639
15,793
7,258 8567/7194/32
/0/0
enqueues
2,664,836
10,266 1,526 8744/1518/4/
0/0
session idle bit
36,639,007 9,334 1,961
7601/1621/49
/63/0
session allocation
1,552,168 3,424
608 2821/599/3/1
/0
messages
1,211,699
3,306 114 3193/112/1/0
/0
active checkpoint queue la 250,391 2,646 22
2624/22/0/0/
0
cache buffer handles
3,101,380 2,320
203 2118/201/1/0
/0
dml lock allocation
1,308,537 2,030
122 1908/122/0/0
/0
simulator hash latch
42,215,667 1,733
567 1167/565/1/0
/0
user lock
162,203
1,326 902 428/894/4/0/
0
enqueue hash chains
3,757,035 1,126
238 888/238/0/0/
0
checkpoint queue latch 35,347,877
886
127 759/127/0/0/
0
redo writing
698,688
607 53
554/53/0/0/0
channel operations parent 113,862
509
17 492/17/0/0/0
mostly latch-free SCN
151,628 428 26
402/26/0/0/0
Latch Sleep breakdown for DB: BUGS Instance: BUGS Snaps: 8959 -8969
-> ordered by misses desc
Get
Spin &
Latch Name
Requests
Misses
Sleeps Sleeps 1->4
-------------------------- -------------- -----------
----------- ------------
message pool operations pa 21,544 74
2 72/2/0/0/0
process allocation
33,177 65 59
42/12/4/7/0
sort extent pool
82,796 51 6
45/6/0/0/0
FOB s.o list latch
92,967 35 8
27/8/0/0/0
sequence cache
175,163 28 2
26/2/0/0/0
Consistent RBA
148,397 13 2
11/2/0/0/0
loader state object freeli 39,724 13
10 3/10/0/0/0
library cache load lock
104,224 13 1
12/1/0/0/0
hash table column usage la 2,274 10 8
4/4/2/0/0
list of block allocation
53,707 3 1
2/1/0/0/0
channel handle pool latch 41,113 1 1
0/1/0/0/0
-------------------------------------------------------------
Latch Miss Sources for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ --------------------------
------- ---------- --------
FOB s.o list latch ksfd_allfob
0 6 8
FOB s.o list latch ksfdfol02
0 2 0
active checkpoint queue kcbbacq: scan active check 0 22 22
cache buffer handles kcbzgs
0 122 98
cache buffer handles kcbzfs
0 81 105
cache buffers chains kcbgtcr: kslbegin excl 0 48,363 95,318
cache buffers chains kcbchg: kslbegin: bufs not 0 23,519 5,576
cache buffers chains kcbzgb: scan from tail. no 0 15,923 0
cache buffers chains kcbgtcr: fast path 0 15,538 17,822
cache buffers chains kcbrls: kslbegin
0
15,154 14,178
cache buffers chains kcbzib: multi-block read:
0
12,165 0
cache buffers chains kcbbic2
0
5,263
596
cache buffers chains kcbzib: finish free bufs
0
2,118 1,569
cache buffers chains kcbgcur: kslbegin
0
1,447
854
cache buffers chains kcbchg: kslbegin: call CR
0
1,053 3,946
cache buffers chains kcbibr
0
1,046
289
cache buffers chains kcbcge
0 776 378
cache buffers chains kcbzwb
0 703 363
cache buffers chains kcbget: pin buffer
0 240 392
cache buffers chains kcbgtcr: kslbegin shared
0
82
65
cache buffers chains kcbget: exchange
0 73 16
cache buffers chains kcbget: exchange rls
0
66 7
cache buffers chains kcbnew
0 61 36
cache buffers chains kcbbxsv
0 45 640
cache buffers chains kcbnlc
0 38 132
cache buffers chains kcbgtcr
0 26 0
cache buffers chains kcbso1: set no access
0
21
26
cache buffers chains kcbbic1
0
12 1,450
cache buffers chains kcbnew_1
0 3 1
cache buffers chains kcbbwdb
0 1 71
cache buffers lru chain kcbzgb: multiple sets nowa ####### 7,753 22
cache buffers lru chain kcbzar: KSLNBEGIN ####### 2,376 0
cache buffers lru chain kcbzgm
#######
1,599 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP ####### 802 0
cache buffers lru chain kcbbic2
4,448 442 8,078
cache buffers lru chain kcbzgb: posted for free bu 10,516 431 4,195
cache buffers lru chain kcbibr
1,584 113 1,009
cache buffers lru chain kcbbiop: lru scan
14,941
17
52
cache buffers lru chain kcbgtcr:CR Scan:KCBRSAVE 3,286 8 0
cache buffers lru chain kcbbxsv: move to being wri 386 6 62
cache buffers lru chain kcbbwlru
210 2 131
channel handle pool latc ksrchconnect()
0
1 0
channel operations paren ksrwait()
0
8 1
channel operations paren ksrapublish()
0
4 6
channel operations paren ksrsconsume()
0
4 1
channel operations paren ksrchdelete()
0
1 9
checkpoint queue latch kcbklbc: Link buffer into 0
109 6
checkpoint queue latch kcbnlc: Link buffers into 0
6 0
checkpoint queue latch kcbswcu: Switch buffers 0
4 8
checkpoint queue latch kcbbcthc: check thread que 0 3 67
checkpoint queue latch kcbbxsv: move to being wri 0 3 4
checkpoint queue latch kcbkllrba: compute lowest 0
1
40
checkpoint queue latch kcbkubc
0 1 34
Latch Miss Sources for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ --------------------------
------- ---------- --------
child cursor hash table kksfbc: new child
0
2,768 3,279
child cursor hash table kkslod: mark kksb state 0 1,659 272
child cursor hash table kksheqd: delete enqueue 0 1,468 11
child cursor hash table kkslod: set parent info. 0 1,217 8
child cursor hash table kksfbc: broken child
0
480
10
child cursor hash table kkshmih: mov.to.hashtable 0
73
34
child cursor hash table kksfbc: completing child 0
58 1,951
child cursor hash table kkslod: set opcode
0 43 2,014
child cursor hash table opiaba: set bbspbvnl
0
34 1
child cursor hash table kkshbsf: mark cursor state 0 23 230
child cursor hash table kkssbt: allocate enqueue 0
15
11
child cursor hash table opiaba: bitset.
0 7 12
child cursor hash table opiaba: allocate kksbnump. 0 2 13
cost function
kzulgt: find user res
0 545 538
cost function
kzulrl
0 357 364
dml lock allocation ktaiam
0 75 88
dml lock allocation ktaidm
0 47 34
enqueue hash chains ksqgtl3
0 147 150
enqueue hash chains ksqrcl
0 88 86
enqueue hash chains ksqcnl
0 3 2
enqueues
ksqgel: create enqueue 0
717
770
enqueues
ksqdel
0 543 466
enqueues
ksqies
0 266 290
hash table column usage KSXMMON_GETCELEM
0 8 0
lgwr LWN SCN
kcs023
0 5 0
library cache
kgllkdl: child: cleanup 0 111,860 31,427
library cache
kglobpn: child:
0 68,671 31,389
library cache
kglupc: child
0
57,910 65,830
library cache
kglpndl: child: before pro 0 56,829 81,527
library cache
kgldti: 2child
0
49,678 18,670
library cache
kglpnc: child
0
31,123 97,115
library cache
kglhdgn: child:
0
22,847 193,004
library cache
kglpin: child: heap proces 0 17,316 24,697
library cache
kglpin
0
13,196 11,426
library cache
kglpndl: child: after proc 0 11,548 2,509
library cache
kglhdgc: child:
0
9,333 6,102
library cache
kgldte: child 0
0
6,887 12,620
library cache
kglobld
0
3,190 8,199
library cache
kglpnp: child
0
1,959 3,948
library cache
kglati
0
782
317
library cache
kglic
0 760 871
library cache
kglget: child: KGLDSBRD 0
539 2,015
library cache
kglget: child: KGLDSBYD 0
415 10,579
library cache
kgldtld: 2child
0 300 312
library cache
kglini: child
0 115 66
library cache
kglhdgh: child: 0
100
160
library cache
kglnti
0 70 84
library cache
kglhfr: child
0 26 18
library cache
kglrtl
0 20 19
library cache
kgldrp: child
0 1 1
library cache load lock kgllldl: llatch
0 1 0
library cache pin kglpnal: child: alloc
spac
0
2,310 3,479
library cache pin kglpndl
0
2,297 1,373
Latch Miss Sources for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ --------------------------
------- ---------- --------
library cache pin kglpnc: child 0 1,123 1,257
library cache pin kglupc
0 923 614
library cache pin kgldnp: child
0 107 41
library cache pin kglpnp: child
0 62 59
library cache pin kglpnal: child: check
gran
0
1 0
library cache pin alloca kglpnal
0
3,744 3,941
library cache pin alloca kgllkdl
0
1,957 1,592
library cache pin alloca kglpndl
0 812 981
library cache pin alloca kglpnp
0 1 0
list of block allocation ktlbbl
0 1 0
loader state object free kcblfs
0 6 1
loader state object free kcblgs
0 4 9
message pool operations ksrmfree()
0 2 0
messages ksaamb:
after wakeup
0 66 57
messages
ksarcv: after wait
0 27 20
messages
ksarcv
0 17 33
messages
ksarcr
0 2 1
messages
ksaclr
0 1 3
messages
ksarcr: inside loop
0 1 0
mostly latch-free SCN kcslcu3 0
21
26
mostly latch-free SCN kcs01
0 2 2
multiblock read objects kcbzib: normal mbr free 0 91,715 83,058
multiblock read objects kcbzib: mbr get
0
90,182 98,839
process allocation ksuapc
17 39 21
process allocation ksucrp
0 14 0
process allocation ksudlp
6 6 38
redo allocation kcrfwr
0
8,966 8,909
redo allocation kcrfwi: more
space
0 182 349
redo allocation kcrfwi:
before write
0 153 130
redo allocation kcrfwr: redo
allocation 0 0
87 0
redo writing
kcrfwint: rba scn pair 0
23 0
redo writing
kcrfwcr
0 12 46
redo writing
kcrfw_cal_target_rba
0 11 1
redo writing
kcrfwint: after write
0 4 1
redo writing
kcrfws: outside the loop 0 2 1
redo writing
kcrfws: in loop
0 1 3
row cache enqueue latch kqreqd
0
43,081 13,332
row cache enqueue latch kqreqa
0
20,260 50,009
row cache objects kqrpfl: not dirty
0
68,594 3,254
row cache objects kqrpre: find obj
0
14,799 80,134
row cache objects kqrso
0 6 3
row cache objects kqrcmt: while loop
0 2 2
row cache objects kqrpre: init
complete
0 2 4
sequence cache
kdnss
0 1 2
sequence cache
kdnssd
0 1 0
session allocation ksucri
0 235 366
session allocation ksuxds: not user session
0
161
174
session allocation ksuxds: KSUSFCLC not set
0
149
26
session allocation ksuprc
0 21 7
session allocation ksudlc
0 14 1
session allocation ksudlp
0 13 22
session allocation ksucrp
0 11 10
session allocation ksufap: active sessions 0
2 0
Latch Miss Sources for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ -------------------------- -------
---------- --------
session idle bit ksupuc: if
ksurcp
0
1,284
770
session idle bit ksupuc: clear
busy
0 628 1,096
session idle bit ksuxds
0 40 82
session idle bit ksupuc: set
busy
0 8 13
shared pool
kghalo
0 293,578 211,571
shared pool
kghfrunp: clatch: nowait 0 140,991 0
shared pool
kghupr1
0
98,863 257,188
shared pool
kghfrunp: alloc: wait
0
84,809 4,466
shared pool
kghfrunp: clatch: wait 0 41,574 45,132
shared pool
kghalp
0
13,660 9,503
shared pool
kghfre
0
6,912 14,624
shared pool
kghfen: not perm alloc cla 0 1,040 1,433
shared pool kghfru
0 167 250
simulator hash latch kcbsacc: lookup dba
0 405 377
simulator hash latch kcbs_lookup_setid: lookup
0
136
178
simulator hash latch kcbsacc: insert dba
0 13 0
simulator hash latch kcbsacc: remove dba
0 13 12
simulator lru latch kcbs_simulate: simulate se 0 7,003 7,256
simulator lru latch kcbs_lookup_setid 0
253 0
sort extent pool
ktstaddextent1
0 3 3
sort extent pool ktstdt: dealloc
sort exten
0
2 0
sort extent pool ktstdt: return
extent
0 1 8
undo global data ktudba:
KSLBEGIN
0
1,987 1,970
undo global data ktudnx:child
0 10 9
undo global data ktugnb:
KSLBEGIN
0 1 2
-------------------------------------------------------------
Dictionary Cache Stats for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->"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_constraints
132 75.0 0
132
0
dc_free_extents
128,015
1.7 28,704 0.0 2,059 60
dc_global_oids
28 7.1 0
0
2
dc_histogram_defs
8,946,056
0.1
0
0
4,141
dc_object_ids
85,128,524
0.0
0
3
1,693
dc_objects
5,478,620
0.1
0
12
3,406
dc_profiles
31,872 0.0 0
0
3
dc_rollback_segments
8,993 0.0 0
0 192
dc_segments
17,375,792 0.0 0 1,082 2,360
dc_sequences
37,077 0.8 0
37,077 48
dc_table_scns
186,720 0.5 0
480
639
dc_tablespace_quotas
4,262 0.5 0 1,070
15
dc_tablespaces
15,046,260
0.0
0
0 11
dc_used_extents
2,059 100.0 0 2,059 0
dc_user_grants
155,771 0.0 0
0
53
dc_usernames
2,114,539 0.0 0
0
42
dc_users
16,291,259 0.0 0
0
94
-------------------------------------------------------------
Library Cache Activity for DB: BUGS Instance: BUGS Snaps: 8959 -8969
->"Pct Misses" should be very low
Get Pct
Pin Pct
Invali-
Namespace
Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------
---------- --------
BODY
19,361 0.1
19,374 0.5
59
0
CLUSTER
1,737 1.2
2,042 2.0 0 0
JAVA DATA 4,010 0.0
23,382 0.0 0 0
SQL AREA
2,522,464 26.5 15,529,055 10.4 169,439 77
TABLE/PROCEDURE 8,476,663 0.1 13,807,941 0.3 25,019 0
TRIGGER
26,927 2.3
26,927 4.3
551
0
-------------------------------------------------------------
Shared Pool Advisory for DB: BUGS Instance: BUGS End Snap: 8969
-> 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 649
64,315
9,697,081
1.0 1,369,919,674
816 .7 776
78,465
9,707,218
1.0 1,374,030,035
944 .8 903
92,049
9,714,325
1.0 1,377,409,831
1,072 .9 1,032 104,261 9,720,119 1.0 1,380,336,484
1,200 1.0 1,159 115,872 9,724,793 1.0 1,382,658,404
1,328 1.1 1,286 127,267 9,728,748 1.0 1,384,603,226
1,456 1.2 1,414 138,121 9,732,152 1.0 1,386,265,750
1,584 1.3 1,542 148,947 9,735,082 1.0 1,387,700,556
1,712 1.4 1,669 160,980 9,737,747 1.0 1,389,021,690
1,840 1.5 1,796 171,191 9,740,189 1.0 1,390,204,426
1,968 1.6 1,923 179,627 9,742,383 1.0 1,391,281,188
2,096 1.7 2,051 188,886 9,744,403 1.0 1,392,262,817
2,224 1.9 2,179 200,024 9,746,348 1.0 1,393,190,849
2,352 2.0 2,307 209,564 9,748,034 1.0 1,394,006,277
2,480 2.1 2,386 214,797 9,749,523 1.0 1,394,688,124
-------------------------------------------------------------
SGA Memory Summary for DB: BUGS Instance: BUGS
Snaps: 8959 -8969
SGA regions
Size in Bytes
------------------------------ ----------------
Database Buffers
1,677,721,600
Fixed Size
733,480
Redo Buffers
319,488
Variable Size
1,644,167,168
----------------
sum
3,322,941,736
-------------------------------------------------------------
SGA breakdown difference for DB: BUGS Instance: BUGS Snaps: 8959 -8969
Pool
Name
Begin value End value % Diff
------ ------------------------------ ----------------
---------------- -------
java
free memory
306,757,632 308,412,416 0.54
java
memory in use
12,009,472 10,354,688 -13.78
shared 1M buffer
2,098,176 2,098,176 0.00
shared Checkpoint queue
4,106,240
4,106,240 0.00
shared DML lock
716,168 716,168 0.00
shared FileIdentificatonBlock
349,824 349,824 0.00
shared FileOpenBlock
5,284,672
5,284,672 0.00
shared KGK heap
7,000
7,000 0.00
shared KGLS heap
8,271,560 8,821,944 6.65
shared KQR L PO
5,555,928 5,653,488 1.76
shared KQR M PO
5,077,616 5,077,024 -0.01
shared KQR M SO
21,080 21,080 0.00
shared KQR S SO
19,456
19,456 0.00
shared KSXR pending messages que
853,952 853,952 0.00
shared KSXR receive buffers
1,034,000 1,034,000 0.00
shared PL/SQL DIANA
1,258,904 2,390,192 89.86
shared PL/SQL MPCODE
1,535,160
1,500,784 -2.24
shared PLS non-lib hp
2,088 2,088 0.00
shared db_block_hash_buckets
11,070,800 11,070,800 0.00
shared db_handles
812,000 812,000 0.00
shared dictionary cache
4,274,432
4,274,432 0.00
shared enqueue
1,444,824 1,444,824 0.00
shared enqueue resources
526,568
526,568 0.00
shared errors
77,584
70,664 -8.92
shared event statistics per sess
8,810,200 8,810,200 0.00
shared fixed allocation callback
2,736
2,736 0.00
shared free memory
128,953,544
124,657,792 -3.33
shared joxlod: in ehe
523,832 516,272 -1.44
shared joxlod: in phe
496,696 184,856 -62.78
shared joxs heap init
4,240
4,240 0.00
shared kglsim hash table bkts 3,145,728
3,145,728 0.00
shared kglsim heap
5,936,320 5,936,320 0.00
shared kglsim object batch
9,910,656 9,910,656 0.00
shared krvxrr
253,056 253,056 0.00
shared ksm_file2sga region
404,864
404,864 0.00
shared ktlbk state objects
456,672
456,672 0.00
shared library cache
214,897,088
218,966,984 1.89
shared miscellaneous
70,820,760
70,498,712 -0.45
shared obj htab chunk
655,872 655,872 0.00
shared parameters
42,464
29,776 -29.88
shared processes
963,200 963,200 0.00
shared qmps connections
341,000
341,000 0.00
shared replication session stats
235,600 235,600 0.00
shared session param values
11,047,360 10,935,488 -1.01
shared sessions
2,095,600 2,095,600 0.00
shared sim memory hea
1,662,936
1,662,936 0.00
shared sim trace entries
196,608
196,608 0.00
shared sql area
802,265,256 801,510,072 -0.09
shared table definiti
84,720
87,448 3.22
shared temporary tabl 117,304 108,256 -7.71
shared trace buffer
4,997,120 4,997,120 0.00
shared transaction
1,642,584 1,652,544 0.61
shared trigger defini
61,984
56,704 -8.52
shared trigger inform
2,288
2,392 4.55
SGA breakdown difference for DB: BUGS Instance: BUGS Snaps: 8959 -8969
Pool
Name
Begin value End value % Diff
------ ------------------------------ ----------------
---------------- -------
buffer_cache
1,677,721,600
1,677,721,600
0.00
fixed_sga
733,480 733,480 0.00
log_buffer
295,936 295,936 0.00
-------------------------------------------------------------
Resource Limit Stats for DB: BUGS Instance: BUGS End Snap: 8969
-> 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
------------------------------ ------------ ------------
---------- ----------
processes
504 591
700
700
-------------------------------------------------------------
init.ora Parameters for DB: BUGS Instance: BUGS Snaps: 8959 -8969
End value
Parameter Name
Begin value
(if different)
-----------------------------
--------------------------------- --------------
_b_tree_bitmap_plans FALSE
audit_sys_operations TRUE
audit_trail
DB
background_dump_dest
/u01/app/oracle/admin/BUGS/bdump
compatible
9.2.0
control_files
/u02/oradata/BUGS/control_01.ctl,
core_dump_dest
/u01/app/oracle/admin/BUGS/cdump
db_block_size
8192
db_cache_size
1677721600
db_file_multiblock_read_count 16
db_files
200
db_name
BUGS
db_writer_processes 2
dml_locks
3400
instance_name
BUGS
java_pool_size
318767104
local_listener
BUGS
log_archive_dest
/u01/app/oracle/admin/BUGS/arch/
log_archive_format
log%S_%T.ARC
log_archive_start
TRUE
log_buffer
163840
log_checkpoint_interval 10000
max_dump_file_size
10240
max_enabled_roles
50
open_cursors
1000
os_authent_prefix
parallel_max_servers 0
processes
700
resource_limit
TRUE
service_names
BUGS
session_cached_cursors 100
sessions
775
sga_max_size 3322941736
shared_pool_reserved_size 104857600
shared_pool_size
1258291200
sort_area_size
262144
spfile
/u01/app/oracle/admin/BUGS/pfile/
sql92_security
TRUE
timed_statistics
TRUE
transactions
850
transactions_per_rollback_seg 5
undo_management
AUTO
undo_retention
21600
undo_suppress_errors TRUE
user_dump_dest
/u01/app/oracle/admin/BUGS/udump
utl_file_dir
/tmp
-------------------------------------------------------------
End of Report