WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Startup Time Release RAC
------------ ----------- ------------ -------- --------------- ----------- ---
MYCAR 1652681432 mycar 1 26-Mar-13 18:10 11.2.0.1.0 NO
Host Name Platform CPUs Cores Sockets Memory(GB)
---------------- -------------------------------- ---- ----- ------- ----------
vm192168000035 Linux x86 64-bit 4 4 4 8.00
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 9345 19-Jun-13 07:00:15 103 4.8
End Snap: 9346 19-Jun-13 08:00:48 101 4.9
Elapsed: 60.56 (mins)
DB Time: 10.72 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 784M 784M Std Block Size: 8K
Shared Pool Size: 1,264M 1,264M Log Buffer: 15,596K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ --------------- --------------- ---------- ----------
DB Time(s): 0.2 0.5 0.00 0.00
DB CPU(s): 0.1 0.4 0.00 0.00
Redo size: 1,874.5 5,405.6
Logical reads: 29,815.4 85,980.5
Block changes: 9.6 27.7
Physical reads: 275.3 793.9
Physical writes: 278.0 801.7
User calls: 140.3 404.6
Parses: 40.0 115.2
Hard parses: 0.0 0.1
W/A MB processed: 3.7 10.8
Logons: 0.1 0.2
Executes: 44.5 128.2
Rollbacks: 0.0 0.0
Transactions: 0.4
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.81 Soft Parse %: 99.90
Execute to Parse %: 10.13 Latch Hit %: 99.93
Parse CPU to Parse Elapsd %: 56.85 % Non-Parse CPU: 99.70
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 69.86 69.89
% SQL with executions>1: 93.78 95.80
% Memory for SQL w/exec>1: 91.81 92.80
Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU 466 72.5
direct path write temp 37,110 77 2 11.9 User I/O
log file sync 943 8 9 1.3 Commit
direct path read temp 36,866 3 0 .4 User I/O
db file sequential read 116 2 18 .3 User I/O
Host CPU (CPUs: 4 Cores: 4 Sockets: 4)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
0.28 0.16 2.8 0.6 0.7 96.5
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 3.2
% of busy CPU for Instance: 92.5
%DB time waiting for CPU - Resource Mgr: 0.0
Memory Statistics
~~~~~~~~~~~~~~~~~ Begin End
Host Mem (MB): 8,192.0 8,192.0
SGA use (MB): 2,144.0 2,144.0
PGA use (MB): 521.3 519.5
% Host Mem used for SGA+PGA: 32.54 32.51
Time Model Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total time in database user-calls (DB Time): 643s
-> Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time 606.0 94.2
DB CPU 466.3 72.5
PL/SQL execution elapsed time 62.4 9.7
parse time elapsed 5.2 .8
hard parse elapsed time 1.2 .2
connection management call elapsed time 0.6 .1
hard parse (sharing criteria) elapsed time 0.2 .0
sequence load elapsed time 0.1 .0
repeated bind elapsed time 0.0 .0
failed parse elapsed time 0.0 .0
DB time 643.0
background elapsed time 45.6
background cpu time 1.2
-------------------------------------------------------------
Operating System Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> *TIME statistic values are diffed.
All others display actual values. End Value is displayed if different
-> ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name
Statistic Value End Value
------------------------- ---------------------- ----------------
BUSY_TIME 50,545
IDLE_TIME 1,402,685
IOWAIT_TIME 10,336
NICE_TIME 0
SYS_TIME 9,163
USER_TIME 41,273
LOAD 0 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 8,589,934,592
NUM_CPUS 4
NUM_CPU_CORES 4
NUM_CPU_SOCKETS 4
GLOBAL_RECEIVE_SIZE_MAX 4,194,304
GLOBAL_SEND_SIZE_MAX 1,048,576
TCP_RECEIVE_SIZE_DEFAULT 87,380
TCP_RECEIVE_SIZE_MAX 4,194,304
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 4,194,304
TCP_SEND_SIZE_MIN 4,096
-------------------------------------------------------------
Operating System Statistics - Detail DB/Inst: MYCAR/mycar Snaps: 9345-9346
Snap Time Load %busy %user %sys %idle %iowait
--------------- -------- -------- -------- -------- -------- --------
19-Jun 07:00:15 0.3 N/A N/A N/A N/A N/A
19-Jun 08:00:48 0.2 3.5 2.8 0.6 96.5 0.7
-------------------------------------------------------------
Foreground Wait Class DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> s - second, ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Captured Time accounts for 86.7% of Total DB time 643.00 (s)
-> Total FG Wait Time: 91.03 (s) DB CPU time: 466.35 (s)
Avg
%Time Total Wait wait
Wait Class Waits -outs Time (s) (ms) %DB time
-------------------- ---------------- ----- ---------------- -------- ---------
DB CPU 466 72.5
User I/O 74,526 0 81 1 12.7
Commit 943 0 8 9 1.3
Network 402,322 0 1 0 0.2
Other 5,171 99 0 0 0.0
Concurrency 79 0 0 2 0.0
Application 252 0 0 0 0.0
System I/O 834 0 0 0 0.0
-------------------------------------------------------------
Foreground Wait Events DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> s - second, ms - millisecond - 1000th of a second
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by wait time desc, waits desc (idle events last)
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Avg
%Time Total Wait wait Waits % DB
Event Waits -outs Time (s) (ms) /txn time
-------------------------- ------------ ----- ---------- ------- -------- ------
direct path write temp 37,110 0 77 2 29.5 11.9
log file sync 943 0 8 9 0.7 1.3
direct path read temp 36,866 0 3 0 29.3 .4
db file sequential read 116 0 2 18 0.1 .3
SQL*Net message to client 376,951 0 1 0 299.2 .1
SQL*Net more data to clien 21,777 0 0 0 17.3 .0
latch: cache buffers chain 71 0 0 2 0.1 .0
ADR block file read 36 0 0 4 0.0 .0
Disk file operations I/O 161 0 0 0 0.1 .0
SQL*Net more data from cli 3,594 0 0 0 2.9 .0
SQL*Net break/reset to cli 252 0 0 0 0.2 .0
direct path read 273 0 0 0 0.2 .0
asynch descriptor resize 5,122 100 0 0 4.1 .0
control file sequential re 834 0 0 0 0.7 .0
latch: shared pool 8 0 0 0 0.0 .0
ADR block file write 5 0 0 0 0.0 .0
SQL*Net message from clien 376,951 0 96,752 257 299.2
jobq slave wait 7,656 100 3,825 500 6.1
wait for unread message on 3,689 98 3,632 985 2.9
Streams AQ: waiting for me 726 100 3,632 5003 0.6
-------------------------------------------------------------
Background Wait Events DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> ordered by wait time desc, waits desc (idle events last)
-> Only events with Total Wait Time (s) >= .001 are shown
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Avg
%Time Total Wait wait Waits % bg
Event Waits -outs Time (s) (ms) /txn time
-------------------------- ------------ ----- ---------- ------- -------- ------
control file parallel writ 1,278 0 24 19 1.0 53.4
log file parallel write 3,382 0 10 3 2.7 21.2
os thread startup 136 0 4 28 0.1 8.4
db file async I/O submit 634 0 1 2 0.5 3.1
db file sequential read 39 0 0 4 0.0 .3
control file sequential re 6,008 0 0 0 4.8 .1
ADR block file read 13 0 0 3 0.0 .1
Disk file operations I/O 86 0 0 0 0.1 .1
log file sync 2 0 0 10 0.0 .0
asynch descriptor resize 315 100 0 0 0.3 .0
direct path sync 1 0 0 3 0.0 .0
ADR block file write 5 0 0 0 0.0 .0
LGWR wait for redo copy 27 0 0 0 0.0 .0
rdbms ipc message 16,949 91 79,532 4692 13.5
DIAG idle wait 7,266 100 7,263 1000 5.8
pmon timer 1,238 98 3,633 2934 1.0
Space Manager: slave idle 726 99 3,632 5002 0.6
shared server idle wait 121 100 3,631 30012 0.1
Streams AQ: qmn slave idle 254 0 3,613 14225 0.2
Streams AQ: qmn coordinato 386 33 3,613 9360 0.3
dispatcher timer 60 100 3,601 60009 0.0
smon timer 12 100 3,600 300005 0.0
SQL*Net message from clien 200 0 0 1 0.2
class slave wait 16 0 0 0 0.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
-> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
-> Ordered by Event (idle events last)
% of Waits
-----------------------------------------------
Total
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
ADR block file read 49 67.3 2.0 6.1 22.4 2.0
ADR block file write 10 100.0
ADR file lock 12 100.0
Disk file operations I/O 247 100.0
LGWR wait for redo copy 27 100.0
SQL*Net break/reset to cli 252 100.0
SQL*Net message to client 377.5 100.0 .0
SQL*Net more data from cli 3594 100.0
SQL*Net more data to clien 21.8K 100.0 .0
asynch descriptor resize 5439 100.0 .0
control file parallel writ 1278 85.6 4.5 2.0 2.1 2.6 1.1 1.4 .7
control file sequential re 6842 100.0
db file async I/O submit 634 62.5 25.6 7.6 1.7 1.9 .6 .2
db file sequential read 154 21.4 1.3 4.5 15.6 49.4 3.9 3.9
direct path read 273 99.3 .4 .4
direct path read temp 36.9K 100.0 .0 .0
direct path sync 1 100.0
direct path write 12 100.0
direct path write temp 37.1K 19.9 71.0 6.7 .8 .9 .3 .4 .0
latch free 3 100.0
latch: cache buffers chain 71 77.5 1.4 5.6 14.1 1.4
latch: call allocation 2 100.0
latch: shared pool 8 87.5 12.5
log file parallel write 3382 92.8 1.4 1.0 1.3 2.2 .5 .7
log file sync 945 80.6 4.0 3.0 3.0 6.1 1.3 1.9 .1
os thread startup 136 96.3 3.7
DIAG idle wait 7266 100.0
SQL*Net message from clien 377.5 91.9 2.5 .7 1.1 1.3 .2 1.4 .8
Space Manager: slave idle 726 100.0
Streams AQ: qmn coordinato 386 66.1 .3 .3 33.4
Streams AQ: qmn slave idle 254 49.2 50.8
Streams AQ: waiting for me 727 100.0
class slave wait 16 93.8 6.3
dispatcher timer 60 100.0
jobq slave wait 7649 .0 .0 .0 99.9
pmon timer 1238 2.2 .1 97.7
rdbms ipc message 16.9K 1.1 .3 .5 .5 1.2 .8 25.2 70.4
shared server idle wait 121 100.0
smon timer 12 100.0
wait for unread message on 3690 .3 .7 .2 98.9
-------------------------------------------------------------
Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: MYCAR/mycar Snaps: 93
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> Units for % of Total Waits:
ms is milliseconds
s is 1024 milliseconds (approximately 1 second)
-> % of Total Waits: total waits for all wait classes, including Idle
-> % of Total Waits: value of .0 indicates value was <.05%;
value of null is truly 0
-> Ordered by Event (only non-idle events are displayed)
% of Total Waits
-----------------------------------------------
Waits
64ms
Event to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s >=2s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
control file parallel writ 26 97.9 .4 .2 .2 .6 .6 .1
db file async I/O submit 1 99.8 .2
db file sequential read 6 96.1 1.9 .6 1.3
direct path write temp 134 99.6 .2 .1 .0 .0 .0 .0
log file parallel write 22 99.3 .2 .1 .2 .2
log file sync 19 98.0 .6 .3 .6 .3 .1
os thread startup 5 96.3 3.7
-------------------------------------------------------------
Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: MYCAR/mycar Snaps: 9345
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> Units for % of Total Waits:
s is 1024 milliseconds (approximately 1 second)
m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
-> % of Total Waits: total waits for all wait classes, including Idle
-> % of Total Waits: value of .0 indicates value was <.05%;
value of null is truly 0
-> Ordered by Event (only non-idle events are displayed)
% of Total Waits
-----------------------------------------------
Waits
4s
Event to 2m <2s <4s <8s <16s <32s < 1m < 2m >=2m
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
control file parallel writ 1 99.9 .1
-------------------------------------------------------------
Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: MYCAR/mycar Snaps: 9345-
No data exists for this section of the report.
-------------------------------------------------------------
Service Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K)
---------------------------- ------------ ------------ ------------ ------------
SYS$USERS 639 466 1,000 108,273
mycar 4 0 0 40
SYS$BACKGROUND 0 0 0 22
mycarXDB 0 0 0 0
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Wait Class info for services in the Service Statistics section.
-> Total Waits and Time Waited displayed for the following wait
classes: User I/O, Concurrency, Administrative, Network
-> Time Waited (Wt Time) in seconds
Service Name
----------------------------------------------------------------
User I/O User I/O Concurcy Concurcy Admin Admin Network Network
Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
SYS$USERS
74526 81 77 0 0 0 397311 1
mycar
0 0 0 0 0 0 5011 0
SYS$BACKGROUND
138 0 136 4 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
-> %Total - Elapsed Time as a percentage of Total DB time
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for 86.7% of Total DB Time (s): 643
-> Captured PL/SQL account for 1.0% of Total DB Time (s): 643
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
159.4 72 2.21 24.8 40.7 49.8 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
108.6 428 0.25 16.9 97.6 .1 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
AND IP.End_Ip1 >= ip_to_number(:2)
56.0 1,494 0.04 8.7 94.4 .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
49.6 6,075 0.01 7.7 80.9 .0 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
33.3 2,438 0.01 5.2 76.0 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
27.5 1,855 0.01 4.3 78.2 .0 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
21.6 1,855 0.01 3.4 92.0 .0 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join
9.0 9,130 0.00 1.4 61.6 .0 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
7.4 82 0.09 1.1 96.5 .0 6zzzr28dtrtpd
select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, deco
de(sd.SOFT_NAME, null,s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK,
null,s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) ve
rsion_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv
7.3 82 0.09 1.1 96.8 .0 1dv841hap05xc
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
AND sd.LAN_ID = :1
7.3 82 0.09 1.1 96.1 .0 89nfp8fv1y8vw
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
AND sd.LAN_ID = :1
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> %Total - CPU Time as a percentage of Total DB CPU
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for 87.9% of Total CPU Time (s): 466
-> Captured PL/SQL account for 1.4% of Total CPU Time (s): 466
CPU CPU per Elapsed
Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
106.0 428 0.25 22.7 108.6 97.6 .1 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
AND IP.End_Ip1 >= ip_to_number(:2)
65.0 72 0.90 13.9 159.4 40.7 49.8 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
52.8 1,494 0.04 11.3 56.0 94.4 .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
40.1 6,075 0.01 8.6 49.6 80.9 .0 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
25.3 2,438 0.01 5.4 33.3 76.0 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
21.5 1,855 0.01 4.6 27.5 78.2 .0 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
19.8 1,855 0.01 4.3 21.6 92.0 .0 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join
7.1 82 0.09 1.5 7.4 96.5 .0 6zzzr28dtrtpd
select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, deco
de(sd.SOFT_NAME, null,s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK,
null,s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) ve
rsion_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv
7.1 82 0.09 1.5 7.3 96.8 .0 1dv841hap05xc
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
AND sd.LAN_ID = :1
7.0 82 0.09 1.5 7.3 96.1 .0 89nfp8fv1y8vw
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
AND sd.LAN_ID = :1
5.5 9,130 0.00 1.2 9.0 61.6 .0 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
-------------------------------------------------------------
SQL ordered by User I/O Wait Time DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> %Total - User I/O Time as a percentage of Total User I/O Wait time
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for 98.8% of Total User I/O Wait Time (s):
-> Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s):
User I/O UIO per Elapsed
Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
79.4 72 1.10 97.3 159.4 40.7 49.8 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
1.0 554 0.00 1.2 1.0 1.2 94.8 dnx1ugz1qwd2p
insert into OPERATE_LOG (LOG_ID,LOG_TYPE, OPERATE_DATE, OPERATE_DESC, OPERATE_RE
SULT, REMOTE_ADDRESS, USER_ID, USER_NAME,CLASS_NAME,METHOD_NAME) val
ues (:1,:2, :3, :4, :5, :6, :7, :8,:9,:10)
0.2 13,648 0.00 0.2 1.1 44.6 16.1 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
0.1 428 0.00 0.1 108.6 97.6 .1 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
AND IP.End_Ip1 >= ip_to_number(:2)
0.0 446 0.00 0.0 0.1 18.5 28.7 59ygsb7wnbc69
insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID,DOWNLOAD_IP, DOWNLOAD_PERSON, DOWN
LOAD_TIME, LAN_Id, SOFT_ID, SOFT_NAME, SOFT_TYPE, USER_ID, VERSION_DETAIL_ID, VE
RSION_ID, VERSION_NO, SERIAL_NO) values (:1,:2, :3, :4, :5, :6, :7,
:8, :9, :10, :11, :12,:13)
0.0 60 0.00 0.0 1.9 100.3 1.4 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0.0 1,353 0.00 0.0 0.1 3.6 17.4 3dyfx3qn2fx77
select * from SYS_USER where cc = :1
0.0 16 0.00 0.0 1.2 91.8 1.6 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
0.0 1,391 0.00 0.0 0.1 75.4 .6 8vwv6hx92ymmm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN
G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2
AND COLLECTION_TIMESTAMP < :B1
0.0 182 0.00 0.0 0.1 92.5 1.3 18naypzfmabd6
Module: EM_PING
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> %Total - Buffer Gets as a percentage of Total Buffer Gets
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Buffer Gets: 108,335,429
-> Captured SQL account for 94.4% of Total
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ------ ------ -----------
60,293,358 1,494 40,357.0 55.7 56.0 94.4 .0 dx9uj64072d
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
9,446,625 6,075 1,555.0 8.7 49.6 80.9 .0 0ay7wjuhgzj
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
6,131,763 72 85,163.4 5.7 159.4 40.7 49.8 9kyafghcc1x
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
4,594,845 2,438 1,884.7 4.2 33.3 76.0 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
3,509,711 1,855 1,892.0 3.2 27.5 78.2 .0 0nrknqc0j9k
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
3,496,611 1,855 1,885.0 3.2 21.6 92.0 .0 1qk46xprzhv
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join
1,822,498 807 2,258.4 1.7 4.9 77.1 .0 42sb9ufsqxu
select sv.version_no,sd.* from diag_soft_version_detail sd left join di
ag_soft_version sv on sd.version_id = sv.version_id left join diag_soft
ds on ds.soft_id = sv.soft_id where ds.valid_flag=:1 and sv.valid_flag=:2 and sd
.check_state=:3 and ds.soft_id=:4 and sd.lan_id=:5 order by sv.version_n
1,708,565 1,119 1,526.9 1.6 5.8 48.3 .0 83trawx9dw9
select decode(ld.DISPLAY_NAME, null,l.LAN_NAME, ld.DISPLAY_NAME) LAN_NAME, d.* f
rom DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d.LAN_ID=l.LAN_I
D left join SYS_LAN_DISPLAY ld on ld.LAN_ID=l.LAN_ID
AND (ld.DISP_LAN_ID = :1) WHERE (d.VERSION_ID
1,195,498 1,390 860.1 1.1 5.8 44.9 .0 3jdq13ju0b2
select v.* from DIAG_SOFT_VERSION v where exists (select 'X' from DIA
G_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=2)
and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VA
LID_FLAG=1) and v.VALID_FLAG=1 and v.SOFT_ID = :1 AND
986,354 9,130 108.0 0.9 9.0 61.6 .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> %Total - Physical Reads as a percentage of Total Disk Reads
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Disk Reads: 1,000,290
-> Captured SQL account for 100.0% of Total
Physical Reads Elapsed
Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ---------- ------ ---------- ------ ------ -------------
999,882 72 13,887.3 100.0 159.4 40.7 49.8 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
38 554 0.1 0.0 1.0 1.2 94.8 dnx1ugz1qwd2p
insert into OPERATE_LOG (LOG_ID,LOG_TYPE, OPERATE_DATE, OPERATE_DESC, OPERATE_RE
SULT, REMOTE_ADDRESS, USER_ID, USER_NAME,CLASS_NAME,METHOD_NAME) val
ues (:1,:2, :3, :4, :5, :6, :7, :8,:9,:10)
12 446 0.0 0.0 0.1 18.5 28.7 59ygsb7wnbc69
insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID,DOWNLOAD_IP, DOWNLOAD_PERSON, DOWN
LOAD_TIME, LAN_Id, SOFT_ID, SOFT_NAME, SOFT_TYPE, USER_ID, VERSION_DETAIL_ID, VE
RSION_ID, VERSION_NO, SERIAL_NO) values (:1,:2, :3, :4, :5, :6, :7,
:8, :9, :10, :11, :12,:13)
12 13,648 0.0 0.0 1.1 44.6 16.1 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
5 428 0.0 0.0 108.6 97.6 .1 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
AND IP.End_Ip1 >= ip_to_number(:2)
3 16 0.2 0.0 1.2 91.8 1.6 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
1 1 1.0 0.0 4.6 99.9 .0 05q4hp8hzdv27
Module: emagent_SQL_oracle_database
/* OracleOEM */ DECLARE rep
t varchar2(4000); rref varchar2(400
0); key_enable varchar2(20);
autoimpl_enable varchar2(20); key_count
1 1,353 0.0 0.0 0.1 3.6 17.4 3dyfx3qn2fx77
select * from SYS_USER where cc = :1
1 1 1.0 0.0 0.0 88.1 .5 cxt1cbqk1jrkp
Module: emagent_SQL_oracle_database
SELECT DECODE(COUNT(*), 0, 'DISABLED', 'ENABLED') STATUS FROM DBA_AUTOTASK_WINDO
W_CLIENTS WHERE SQL_TUNE_ADVISOR = 'ENABLED' AND AUTOTASK_STATUS = 'ENABLED'
0 1 0.0 0.0 4.5 100.0 .0 00amgv6xy2km7
Module: emagent_SQL_oracle_database
SELECT /*+ leading(oe f r l) */ /* STN_REPT_TOP_PROF */
xmlelement( "top_profiles", xmlagg(xmleleme
nt("obj_id", object_id))) FROM (SELECT task_id, exec_name, exec_id, ex
ec_start, object_id, sql_id, parsing_schema, phv, obj_attr8
-------------------------------------------------------------
SQL ordered by Physical Reads (UnOptimized)DB/Inst: MYCAR/mycar Snaps: 9345-
-> UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
-> %Opt - Optimized Reads as percentage of SQL Read Requests
-> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
-> Total Physical Read Requests: 37,286
-> Captured SQL account for 0.1% of Total
-> Total UnOptimized Read Requests: 37,286
-> Captured SQL account for 0.1% of Total
-> Total Optimized Read Requests: 1
-> Captured SQL account for 0.0% of Total
UnOptimized Physical UnOptimized
Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id
----------- ----------- ---------- ------------ ------ ------ -------------
12 12 13,648 0.0 0.0 0.0 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
12 12 60 0.2 0.0 0.0 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5 5 428 0.0 0.0 0.0 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
AND IP.End_Ip1 >= ip_to_number(:2)
3 3 16 0.2 0.0 0.0 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
1 1 1 1.0 0.0 0.0 05q4hp8hzdv27
Module: emagent_SQL_oracle_database
/* OracleOEM */ DECLARE rep
t varchar2(4000); rref varchar2(400
0); key_enable varchar2(20);
autoimpl_enable varchar2(20); key_count
1 1 1,353 0.0 0.0 0.0 3dyfx3qn2fx77
select * from SYS_USER where cc = :1
1 1 1 1.0 0.0 0.0 cxt1cbqk1jrkp
Module: emagent_SQL_oracle_database
SELECT DECODE(COUNT(*), 0, 'DISABLED', 'ENABLED') STATUS FROM DBA_AUTOTASK_WINDO
W_CLIENTS WHERE SQL_TUNE_ADVISOR = 'ENABLED' AND AUTOTASK_STATUS = 'ENABLED'
0 0 1 0.0 N/A 0.0 00amgv6xy2km7
Module: emagent_SQL_oracle_database
SELECT /*+ leading(oe f r l) */ /* STN_REPT_TOP_PROF */
xmlelement( "top_profiles", xmlagg(xmleleme
nt("obj_id", object_id))) FROM (SELECT task_id, exec_name, exec_id, ex
ec_start, object_id, sql_id, parsing_schema, phv, obj_attr8
0 0 5 0.0 N/A 0.0 00prz3j9n4gyj
Module: Oracle Enterprise Manager.rollup
SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET
_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW
WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION
_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GU
0 0 1,048 0.0 N/A 0.0 01q51jb3mq09x
select s.*,l.LAN_NAME from PUBLIC_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.
LAN_ID where PUB_SOFT_ID =:1
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Executions: 161,533
-> Captured SQL account for 81.6% of Total
Elapsed
Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
51,041 51,040 1.0 2.6 33.0 .0 520mkxqpf15
select 1 from dual
13,648 13,646 1.0 1.1 44.6 16.1 5nggumnh49y
select * from SYS_PRODUCT where SERIAL_NO = :1
9,449 9,449 1.0 0.6 57.9 .0 bm7qdt1qj4c
select l.LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d
.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1
9,130 104,508 11.4 9.0 61.6 .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
6,075 216,881 35.7 49.6 80.9 .0 0ay7wjuhgzj
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
3,833 1,799 0.5 0.8 62.1 .0 5ky6k3fa3cu
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
3,284 4,852 1.5 0.2 74.5 .0 cm5vu20fhtn
select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra
ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
2,438 0 0.0 0.3 36.1 .0 12gmchtj8pp
select usd.*,s.soft_name as SOFT_NAME,su.cc as cc,decode(mu.user_name,null,'鏈?煡
',
mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SY
S_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_i
d = usd.last_upd_user_id join DIAG_SOFT s on us
2,438 1,990 0.8 33.3 76.0 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
2,022 2,022 1.0 0.1 44.0 .0 a6j566u48p8
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
2,002 0 0.0 0.2 57.2 .0 drvvh1sx3r1
select l.LAN_NAME, d.* from SYS_PDT_TYPE_DESC d, sys_lan l where d.LAN_ID=l.LAN_
ID AND d.PDT_TYPE_ID = :1
1,855 1,629 0.9 27.5 78.2 .0 0nrknqc0j9k
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
1,855 1,852 1.0 21.6 92.0 .0 1qk46xprzhv
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Parse Calls: 145,162
-> Captured SQL account for 89.0% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
51,038 51,041 35.16 520mkxqpf15q8
select 1 from dual
13,648 13,648 9.40 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
9,449 9,449 6.51 bm7qdt1qj4cg0
select l.LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d
.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1
9,130 9,130 6.29 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
6,075 6,075 4.18 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
3,833 3,833 2.64 5ky6k3fa3cu3y
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
3,284 3,284 2.26 cm5vu20fhtnq1
select /*+ connect_by_filtering */ privilege#,level from sysauth$ connect by gra
ntee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
2,438 2,438 1.68 12gmchtj8pp10
select usd.*,s.soft_name as SOFT_NAME,su.cc as cc,decode(mu.user_name,null,'鏈?煡
',
mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SY
S_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_i
d = usd.last_upd_user_id join DIAG_SOFT s on us
2,438 2,438 1.68 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
2,022 2,022 1.39 a6j566u48p8nf
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
2,002 2,002 1.38 drvvh1sx3r1my
select l.LAN_NAME, d.* from SYS_PDT_TYPE_DESC d, sys_lan l where d.LAN_ID=l.LAN_
ID AND d.PDT_TYPE_ID = :1
1,855 1,855 1.28 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
1,855 1,855 1.28 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join
1,595 1,595 1.10 1qp4my7430ph5
select * from DIAG_SOFT_VERSION where VERSION_ID = :1
1,494 1,494 1.03 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Parse Calls: 145,162
-> Captured SQL account for 89.0% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
1,494 1,494 1.03 gkmzhrqxapv9h
select * from SYS_LAN_DISPLAY where LAN_ID = :1 and DISP_LAN_ID = :2
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
2,769,002 3 0.21 ab3swhv5g138y
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_
SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags
, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.pr
iority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_i
2,294,522 1 0.17 6wm3n4d7bnddg
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti
me_secs, operation FROM ( SELECT 1 as source, trunc(
(sysdate - cast(ll.log_date as date)) * 86400) as time_secs,
decode(ll.operation, 'OPEN', 0
1,067,360 1,391 0.08 8vwv6hx92ymmm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN
G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2
AND COLLECTION_TIMESTAMP < :B1
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
102 1 c8gnrhxma4tas
SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
100 2 69k5bhm12sz98
SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_
name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time
THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as beg
in_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((ca
91 1 gdn3ysuyssf82
SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
75 209 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
72 182 18naypzfmabd6
Module: EM_PING
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
69 1 9yt4ka3n2svmc
Module: DBMS_SCHEDULER
update sys.scheduler$_job set last_enabled_time = :1, next_run_date = :2, job_s
tatus = :3 where obj# = :4
65 1,391 8vwv6hx92ymmm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN
G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2
AND COLLECTION_TIMESTAMP < :B1
65 15 bn4b3vjw2mj3u
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LET
IME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1
, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( s
elect a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last
63 1 6wm3n4d7bnddg
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti
me_secs, operation FROM ( SELECT 1 as source, trunc(
(sysdate - cast(ll.log_date as date)) * 86400) as time_secs,
decode(ll.operation, 'OPEN', 0
57 66 47a50dvdgnxc2
update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_dat
e = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date,sysdate)) where j
ob=:4
56 1 5uw1u291s3m0k
SELECT case when cnt = 0 then 0 else (1000000 * total) / cnt end FROM ( SE
LECT SUM(m.num_interval) AS cnt, SUM(m.num_interval * m.average) AS
total FROM WRH$_SYSMETRIC_SUMMARY m , WRH$_METRIC_NAME n WHERE m.dbi
d = :dbid and m.instance_number = :inst_num and m.snap_i
54 5 ckwq494gaf2ff
Module: Oracle Enterprise Manager.rollup
SELECT ROLLUP_TABLE_NAME, ROLLUP_TIMESTAMP, ROWID FROM MGMT_TARGET_ROLLUP_TIMES
WHERE TARGET_GUID = :B3 AND ROLLUP_TABLE_NAME IN (:B2 , :B1 ) ORDER BY ROLLUP_TA
BLE_NAME
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
52 725 5ms6rbzdnq16t
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.d
b_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 an
51 80 9p5tvdmjymwx7
UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE
), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VI
OLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_
LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID =
47 5 00prz3j9n4gyj
Module: Oracle Enterprise Manager.rollup
SELECT METRIC_GUID, TRUNC(COLLECTION_TIMESTAMP, 'HH24'), KEY_VALUE, COUNT(TARGET
_GUID), AVG(VALUE), MIN(VALUE), MAX(VALUE), STDDEV(VALUE) FROM MGMT_METRICS_RAW
WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP >= (:B2 +(1/24)) AND COLLECTION
_TIMESTAMP < (:B1 +(1/24)) AND VALUE IS NOT NULL GROUP BY TARGET_GUID, METRIC_GU
45 3 ab3swhv5g138y
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_
SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags
, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.pr
iority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_i
39 1 08qpghs7y4q2f
UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, LAST_EXEC_NAME = :B5 , STATUS = N
VL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHE
RE ID = :B1
39 1 cpqs5k8jpd9kz
Module: Oracle Enterprise Manager.rollup
SELECT MT.TARGET_GUID, LAST_LOAD_TIME FROM MGMT_TARGETS MT, MGMT_TARGET_ROLLUP_T
IMES MTRT WHERE MTRT.ROLLUP_TABLE_NAME = :B1 AND MT.TARGET_GUID = MTRT.TARGET_GU
ID AND (TRUNC(MT.LAST_LOAD_TIME, 'HH24') > MTRT.ROLLUP_TIMESTAMP)
39 2 g4gp07gt2z920
update sys.scheduler$_job set last_start_date = :1, running_instance = :2, runn
ing_slave = :3, job_status = :4 where obj# = :5
36 1 1rac8z6n21f14
SELECT MAX(END_INTERVAL_TIME), COUNT(*) FROM WRM$_SNAPSHOT WHERE SNAP_ID = :B2 A
ND DBID = :B1
34 1,390 3jdq13ju0b2z9
select v.* from DIAG_SOFT_VERSION v where exists (select 'X' from DIA
G_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=2)
and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VA
LID_FLAG=1) and v.VALID_FLAG=1 and v.SOFT_ID = :1 AND
29 72 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP
26 1 1cq3qr774cu45
insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetyp
e_id, small_read_megabytes, small_write_megabytes, large_read_megabytes,
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_r
eqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_wr
24 7 g4kcn01rx9d0m
SELECT COUNT(*) AS c from ( select m.* from (select s.soft
_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.v
ersion_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as pric
e, v.CUR_ID,t5.cur_code from diag_soft s, sys_product p, sys
24 7 g4kcn01rx9d0m
SELECT COUNT(*) AS c from ( select m.* from (select s.soft
_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.v
ersion_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as pric
e, v.CUR_ID,t5.cur_code from diag_soft s, sys_product p, sys
24 7 g4kcn01rx9d0m
SELECT COUNT(*) AS c from ( select m.* from (select s.soft
_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.v
ersion_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as pric
e, v.CUR_ID,t5.cur_code from diag_soft s, sys_product p, sys
24 7 g4kcn01rx9d0m
SELECT COUNT(*) AS c from ( select m.* from (select s.soft
_id, t1.version_no, t1.creater_time, t4.soft_name as soft_desc, t2.remark, t2.v
ersion_detail_id, nvl(UPGRADE_PRICE, DEFAULT_BPRICE) as pric
e, v.CUR_ID,t5.cur_code from diag_soft s, sys_product p, sys
-------------------------------------------------------------
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
Batched IO (bound) vector count 0 0.0 0.0
Batched IO (full) vector count 0 0.0 0.0
Batched IO block miss count 0 0.0 0.0
Batched IO buffer defrag count 0 0.0 0.0
Batched IO double miss count 0 0.0 0.0
Batched IO same unit count 0 0.0 0.0
Batched IO single block count 0 0.0 0.0
Batched IO slow jump count 0 0.0 0.0
Batched IO vector block count 0 0.0 0.0
Batched IO vector read count 0 0.0 0.0
Block Cleanout Optim referenced 5 0.0 0.0
CCursor + sql area evicted 7 0.0 0.0
CPU used by this session 45,574 12.5 36.2
CPU used when call started 45,279 12.5 35.9
CR blocks created 603 0.2 0.5
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 13 0.0 0.0
DB time 1,176,698 323.8 933.9
DBWR checkpoint buffers written 2,652 0.7 2.1
DBWR checkpoints 0 0.0 0.0
DBWR object drop buffers written 0 0.0 0.0
DBWR revisited being-written buf 0 0.0 0.0
DBWR tablespace checkpoint buffe 0 0.0 0.0
DBWR thread checkpoint buffers w 0 0.0 0.0
DBWR transaction table writes 110 0.0 0.1
DBWR undo block writes 425 0.1 0.3
HSC Heap Segment Block Changes 4,862 1.3 3.9
HSC IDL Compressed Blocks 0 0.0 0.0
Heap Segment Array Inserts 132 0.0 0.1
Heap Segment Array Updates 159 0.0 0.1
IMU CR rollbacks 500 0.1 0.4
IMU Flushes 1,297 0.4 1.0
IMU Redo allocation size 1,477,440 406.6 1,172.6
IMU commits 989 0.3 0.8
IMU contention 1 0.0 0.0
IMU ktichg flush 12 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 6 0.0 0.0
IMU undo allocation size 4,650,728 1,279.9 3,691.1
IMU- failed to get a private str 0 0.0 0.0
LOB table id lookup cache misses 0 0.0 0.0
Number of read IOs issued 273 0.1 0.2
PX local messages recv'd 0 0.0 0.0
PX local messages sent 0 0.0 0.0
RowCR - row contention 0 0.0 0.0
RowCR attempts 132 0.0 0.1
RowCR hits 132 0.0 0.1
SMON posted for dropping temp se 0 0.0 0.0
SMON posted for undo segment rec 0 0.0 0.0
SMON posted for undo segment shr 0 0.0 0.0
SQL*Net roundtrips to/from clien 376,951 103.7 299.2
TBS Extension: bytes extended 0 0.0 0.0
TBS Extension: files extended 0 0.0 0.0
TBS Extension: tasks created 0 0.0 0.0
TBS Extension: tasks executed 0 0.0 0.0
active txn count during cleanout 197 0.1 0.2
application wait time 3 0.0 0.0
auto extends on undo tablespace 0 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
background timeouts 15,402 4.2 12.2
branch node splits 0 0.0 0.0
buffer is not pinned count 63,006,638 17,340.3 50,005.3
buffer is pinned count 220,987,008 60,818.7 175,386.5
bytes received via SQL*Net from 45,145,720 12,424.7 35,829.9
bytes sent via SQL*Net to client 166,070,560 45,704.9 131,802.0
calls to get snapshot scn: kcmgs 172,959 47.6 137.3
calls to kcmgas 3,497 1.0 2.8
calls to kcmgcs 283,995 78.2 225.4
cell physical IO interconnect by 16,631,616,512 4,577,248.8 13,199,695.6
change write time 23 0.0 0.0
cleanout - number of ktugct call 123 0.0 0.1
cleanouts and rollbacks - consis 0 0.0 0.0
cleanouts only - consistent read 3 0.0 0.0
cluster key scan block gets 2,214 0.6 1.8
cluster key scans 1,974 0.5 1.6
commit batch performed 0 0.0 0.0
commit batch requested 0 0.0 0.0
commit batch/immediate performed 0 0.0 0.0
commit batch/immediate requested 0 0.0 0.0
commit cleanout failures: block 12 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callba 6 0.0 0.0
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 5,671 1.6 4.5
commit cleanouts successfully co 5,653 1.6 4.5
commit immediate performed 0 0.0 0.0
commit immediate requested 0 0.0 0.0
commit txn count during cleanout 158 0.0 0.1
concurrency wait time 402 0.1 0.3
consistent changes 1,294 0.4 1.0
consistent gets 108,299,330 29,805.5 85,951.9
consistent gets - examination 1,475,358 406.0 1,170.9
consistent gets direct 282 0.1 0.2
consistent gets from cache 108,299,048 29,805.4 85,951.6
consistent gets from cache (fast 105,990,868 29,170.1 84,119.7
cursor authentications 73 0.0 0.1
data blocks consistent reads - u 1,092 0.3 0.9
db block changes 34,887 9.6 27.7
db block gets 36,099 9.9 28.7
db block gets direct 13 0.0 0.0
db block gets from cache 36,086 9.9 28.6
db block gets from cache (fastpa 10,978 3.0 8.7
deferred (CURRENT) block cleanou 3,352 0.9 2.7
dirty buffers inspected 0 0.0 0.0
enqueue conversions 733 0.2 0.6
enqueue deadlocks 0 0.0 0.0
enqueue releases 52,361 14.4 41.6
enqueue requests 52,361 14.4 41.6
enqueue timeouts 0 0.0 0.0
enqueue waits 0 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 161,533 44.5 128.2
failed probes on index block rec 0 0.0 0.0
file io service time 42 0.0 0.0
file io wait time 3,678,777 1,012.5 2,919.7
free buffer inspected 771 0.2 0.6
free buffer requested 1,752 0.5 1.4
global undo segment hints helped 0 0.0 0.0
global undo segment hints were s 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
heap block compress 59 0.0 0.1
hot buffers moved to head of LRU 521 0.1 0.4
immediate (CR) block cleanout ap 3 0.0 0.0
immediate (CURRENT) block cleano 910 0.3 0.7
index crx upgrade (positioned) 5,587 1.5 4.4
index crx upgrade (prefetch) 0 0.0 0.0
index fast full scans (full) 116 0.0 0.1
index fetch by key 1,939,738 533.8 1,539.5
index scans kdiixs1 36,142 10.0 28.7
leaf node 90-10 splits 28 0.0 0.0
leaf node splits 49 0.0 0.0
lob reads 355 0.1 0.3
lob writes 39 0.0 0.0
lob writes unaligned 39 0.0 0.0
logons cumulative 254 0.1 0.2
max cf enq hold time 0 0.0 0.0
messages received 2,280 0.6 1.8
messages sent 2,280 0.6 1.8
min active SCN optimization appl 2 0.0 0.0
no buffer to keep pinned count 33 0.0 0.0
no work - consistent read gets 106,517,948 29,315.2 84,538.1
non-idle wait count 497,088 136.8 394.5
non-idle wait time 13,062 3.6 10.4
opened cursors cumulative 158,198 43.5 125.6
parse count (describe) 1 0.0 0.0
parse count (failures) 24 0.0 0.0
parse count (hard) 151 0.0 0.1
parse count (total) 145,162 40.0 115.2
parse time cpu 141 0.0 0.1
parse time elapsed 248 0.1 0.2
physical read IO requests 37,286 10.3 29.6
physical read bytes 8,194,375,680 2,255,204.5 6,503,472.8
physical read total IO requests 44,137 12.2 35.0
physical read total bytes 8,306,876,416 2,286,166.2 6,592,759.1
physical read total multi block 27,930 7.7 22.2
physical reads 1,000,290 275.3 793.9
physical reads cache 138 0.0 0.1
physical reads cache prefetch 0 0.0 0.0
physical reads direct 1,000,152 275.3 793.8
physical reads direct (lob) 273 0.1 0.2
physical reads direct temporary 999,870 275.2 793.6
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 38,715 10.7 30.7
physical write bytes 8,275,394,560 2,277,502.0 6,567,773.5
physical write total IO requests 42,963 11.8 34.1
physical write total bytes 8,324,740,096 2,291,082.6 6,606,936.6
physical write total multi block 28,201 7.8 22.4
physical writes 1,010,180 278.0 801.7
physical writes direct 1,007,528 277.3 799.6
physical writes direct (lob) 12 0.0 0.0
physical writes direct temporary 1,007,516 277.3 799.6
physical writes from cache 2,652 0.7 2.1
physical writes non checkpoint 1,007,967 277.4 800.0
pinned buffers inspected 1 0.0 0.0
pinned cursors current 0 0.0 0.0
prefetch clients - default 0 0.0 0.0
prefetch warmup blocks aged out 0 0.0 0.0
prefetch warmup blocks flushed o 0 0.0 0.0
prefetched blocks aged out befor 0 0.0 0.0
process last non-idle time 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
recursive calls 164,715 45.3 130.7
recursive cpu usage 945 0.3 0.8
redo blocks checksummed by FG (e 6,510 1.8 5.2
redo blocks written 14,586 4.0 11.6
redo buffer allocation retries 0 0.0 0.0
redo entries 12,116 3.3 9.6
redo k-bytes read total 0 0.0 0.0
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 253 0.1 0.2
redo size 6,811,024 1,874.5 5,405.6
redo size for direct writes 98,736 27.2 78.4
redo subscn max counts 796 0.2 0.6
redo synch time 814 0.2 0.7
redo synch writes 991 0.3 0.8
redo wastage 484,924 133.5 384.9
redo write time 969 0.3 0.8
redo writes 1,691 0.5 1.3
rollback changes - undo records 13 0.0 0.0
rollbacks only - consistent read 603 0.2 0.5
root node splits 0 0.0 0.0
rows fetched via callback 910,810 250.7 722.9
scheduler wait time 0 0.0 0.0
session connect time 0 0.0 0.0
session logical reads 108,335,429 29,815.4 85,980.5
shared hash latch upgrades - no 24,892 6.9 19.8
shared hash latch upgrades - wai 0 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 28,050 7.7 22.3
sorts (rows) 1,853,947 510.2 1,471.4
sql area evicted 122 0.0 0.1
sql area purged 24 0.0 0.0
summed dirty queue length 0 0.0 0.0
switch current to new buffer 618 0.2 0.5
table fetch by rowid 141,438,642 38,925.9 112,252.9
table fetch continued row 18,064 5.0 14.3
table scan blocks gotten 45,036,703 12,394.7 35,743.4
table scan rows gotten 2,329,827,083 641,200.3 1,849,069.1
table scans (direct read) 0 0.0 0.0
table scans (long tables) 0 0.0 0.0
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 75,406 20.8 59.9
temp space allocated (bytes) 0 0.0 0.0
total cf enq hold time 30 0.0 0.0
total number of cf enq holders 292 0.1 0.2
total number of times SMON poste 0 0.0 0.0
transaction rollbacks 0 0.0 0.0
transaction tables consistent re 0 0.0 0.0
transaction tables consistent re 0 0.0 0.0
undo change vector size 2,309,724 635.7 1,833.1
user I/O wait time 8,162 2.3 6.5
user calls 509,817 140.3 404.6
user commits 1,255 0.4 1.0
user rollbacks 5 0.0 0.0
workarea executions - onepass 46 0.0 0.0
workarea executions - optimal 29,271 8.1 23.2
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: MYCAR/mycar Snaps: 9345-93
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session uga memory max 1.064893698E+12 1.065155364E+12
session pga memory 3.385910621E+11 3.387569073E+11
session pga memory max 3.826735616E+11 3.828727305E+11
session cursor cache count 9,935,999 9,940,882
session uga memory 5.965663118E+14 5.968583822E+14
opened cursors current 490 493
workarea memory allocated 45,962 45,962
logons current 103 101
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: MYCAR/mycar Snaps: 9345-934
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
-------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
IOStat by Function summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
other columns suffixed with K,M,G,T,P are in multiples of 1000
-> ordered by (Data Read + Write) desc
Reads: Reqs Data Writes: Reqs Data Waits: Avg
Function Name Data per sec per sec Data per sec per sec Count Tm(ms)
--------------- ------- ------- ------- ------- ------- ------- ------- -------
Direct Writes 0M 0.0 0M 7.7G 10.2 2.16593 37.1K 1.4
Direct Reads 7.6G 10.2 2.15024 0M 0.0 0M 37.1K 0.0
Others 107M 1.9 .029447 40M 0.7 .011008 9416 5.0
DBWR 0M 0.0 0M 20M 0.4 .005504 634 1.8
LGWR 0M 0.0 0M 7M 0.5 .001926 1691 5.3
Buffer Cache Re 1M 0.0 .000275 0M 0.0 0M 135 16.1
TOTAL: 7.7G 12.1 2.17996 7.8G 11.8 2.18437 86.1K 1.3
-------------------------------------------------------------
IOStat by Filetype summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
other columns suffixed with K,M,G,T,P are in multiples of 1000
-> Small Read and Large Read are average service times, in milliseconds
-> Ordered by (Data Read + Write) desc
Reads: Reqs Data Writes: Reqs Data Small Large
Filetype Name Data per sec per sec Data per sec per sec Read Read
--------------- ------- ------- ------- ------- ------- ------- ------- -------
Temp File 7.6G 10.1 2.14969 7.7G 10.2 2.16648 0.0 0.0
Control File 108M 1.9 .029723 40M 0.7 .011008 0.0 N/A
Data File 3M 0.1 .000825 20M 0.4 .005504 5.2 N/A
Log File 0M 0.0 0M 7M 0.5 .001926 N/A N/A
TOTAL: 7.7G 12.1 2.18024 7.8G 11.8 2.18492 0.1 0.0
-------------------------------------------------------------
IOStat by Function/Filetype summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
other columns suffixed with K,M,G,T,P are in multiples of 1000
-> Ordered by (Data Read + Write) desc for each function
Reads: Reqs Data Writes: Reqs Data Waits: Avg
Data per sec per sec Data per sec per sec Count Tm(ms)
------- ------- ------- ------- ------- ------- ------- -------
Direct Writes
0M 0.0 0M 7.7G 10.2 2.16593 0 N/A
Direct Writes (Data File)
0M 0.0 0M 7.7G 10.2 2.16593 0 N/A
Direct Reads
7.6G 10.2 2.15024 0M 0.0 0M 0 N/A
Direct Reads (Data File)
7.6G 10.2 2.15024 0M 0.0 0M 0 N/A
Others
108M 1.9 .029723 40M 0.7 .011008 6860 0.0
Others (Control File)
108M 1.9 .029723 40M 0.7 .011008 6842 0.0
Others (Data File)
0M 0.0 0M 0M 0.0 0M 18 0.5
DBWR
0M 0.0 0M 20M 0.4 .005504 0 N/A
DBWR (Data File)
0M 0.0 0M 20M 0.4 .005504 0 N/A
LGWR
0M 0.0 0M 7M 0.5 .001926 0 N/A
LGWR (Log File)
0M 0.0 0M 7M 0.5 .001926 0 N/A
Buffer Cache Reads
1M 0.0 .000275 0M 0.0 0M 135 16.1
Buffer Cache Reads (Data File)
1M 0.0 .000275 0M 0.0 0M 135 16.1
TOTAL:
7.7G 12.1 2.18024 7.8G 11.8 2.18437 6995 0.3
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> 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)
-------------- ------- ------- ------- ------------ -------- ---------- -------
TEMP
36,867 10 0.0 27.1 37,110 10 0 0.0
SYSAUX
30 0 4.7 1.0 875 0 0 0.0
MYCAR
370 0 5.1 1.0 304 0 0 0.0
UNDOTBS1
0 0 0.0 .0 230 0 0 0.0
PASSPORT
18 0 11.7 1.0 104 0 0 0.0
SYSTEM
0 0 0.0 .0 92 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> 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)
-------------- ------- ------- ------- ------------ -------- ---------- -------
MYCAR /oracle/oradata/mycar/mycar.dbf
370 0 5.1 1.0 297 0 0 0.0
MYCAR /oracle/oradata/mycar/mycar01.dbf
0 0 N/A N/A 7 0 0 0.0
PASSPORT /oracle/oradata/mycar/passport.dbf
18 0 11.7 1.0 104 0 0 0.0
SYSAUX /oracle/oradata/mycar/sysaux01.dbf
30 0 4.7 1.0 875 0 0 0.0
SYSTEM /oracle/oradata/mycar/system01.dbf
0 0 N/A N/A 92 0 0 0.0
TEMP /oracle/oradata/mycar/temp01.dbf
36,867 10 0.0 27.1 37,110 10 0 N/A
UNDOTBS1 /oracle/oradata/mycar/undotbs01.dbf
0 0 N/A N/A 230 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Writ Buffer
Number of Pool Buffer Physical Physical Buff Comp Busy
P Buffers Hit% Gets Reads Writes Wait Wait Waits
--- ---------- ---- ------------ ------------ ----------- ------ ------ --------
D 96,530 100 108,305,472 139 2,652 0 0 0
-------------------------------------------------------------
Checkpoint Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Physical Writes: 1,010,180
Other Autotune Thread
MTTR Log Size Log Ckpt Settings Ckpt Ckpt
Writes Writes Writes Writes Writes Writes
----------- ----------- ----------- ----------- ----------- -----------
0 0 0 0 2,652 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> B: Begin Snapshot, E: End Snapshot
Estd
Targt Estd Log Ckpt Log Ckpt Opt RAC
MTTR MTTR Recovery Actual Target Log Sz Timeout Interval Log Avail
(s) (s) Estd IOs RedoBlks RedoBlks RedoBlks RedoBlks RedoBlks Sz(M) Time
- ----- ----- -------- -------- -------- -------- -------- -------- ------ -----
B 0 14 312 1439 5318 995328 5318 N/A N/A N/A
E 0 14 355 1574 5172 995328 5172 N/A N/A N/A
-------------------------------------------------------------
MTTR Advisory DB/Inst: MYCAR/mycar Snap: 9346
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: MYCAR/mycar Snap: 9346
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate
Est
Phys Estimated Est
Size for Size Buffers Read Phys Reads Est Phys %DBtime
P Est (M) Factor (thousands) Factor (thousands) Read Time for Rds
--- -------- ------ ------------ ------ -------------- ------------ -------
D 80 .1 10 1.8 2,767,362 1 8.6E+05
D 160 .2 20 1.0 1,577,900 1 3.5E+04
D 240 .3 30 1.0 1,557,238 1 2.0E+04
D 320 .4 39 1.0 1,554,072 1 1.8E+04
D 400 .5 49 1.0 1,553,545 1 1.8E+04
D 480 .6 59 1.0 1,553,182 1 1.7E+04
D 560 .7 69 1.0 1,552,914 1 1.7E+04
D 640 .8 79 1.0 1,552,641 1 1.7E+04
D 720 .9 89 1.0 1,552,419 1 1.7E+04
D 800 1.0 99 1.0 1,552,241 1 1.7E+04
D 880 1.1 108 1.0 1,552,091 1 1.7E+04
D 960 1.2 118 1.0 1,551,928 1 1.6E+04
D 1,040 1.3 128 1.0 1,551,826 1 1.6E+04
D 1,120 1.4 138 1.0 1,551,756 1 1.6E+04
D 1,200 1.5 148 1.0 1,551,703 1 1.6E+04
D 1,280 1.6 158 1.0 1,551,639 1 1.6E+04
D 1,360 1.7 167 1.0 1,550,868 1 1.6E+04
D 1,440 1.8 177 1.0 1,490,811 1 6716.0
D 1,520 1.9 187 1.0 1,477,221 1 6716.0
D 1,600 2.0 197 0.9 1,408,873 1 6711.0
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ------------------ --------------------------
58.1 13,553 9,761
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 24,182 24,182 0 0
64K 128K 1,162 1,162 0 0
128K 256K 498 498 0 0
256K 512K 4 4 0 0
512K 1024K 1,958 1,958 0 0
1M 2M 1,430 1,430 0 0
4M 8M 14 14 0 0
8M 16M 8 8 0 0
16M 32M 12 12 0 0
128M 256M 39 0 39 0
256M 512M 3 0 3 0
512M 1024M 4 0 4 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: MYCAR/mycar Snap: 9346
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd P Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd
Est (MB) Factr Processed Written to Disk Hit % Count Time
---------- ------- ---------------- ---------------- ------ -------- -------
142 0.1 20,994,825.0 44,977,856.9 32.0 278,021 7.5E+10
284 0.3 20,994,825.0 44,816,115.8 32.0 273,884 7.5E+10
568 0.5 20,994,825.0 11,390,408.5 65.0 9 3.7E+10
852 0.8 20,994,825.0 11,137,933.9 65.0 0 3.7E+10
1,136 1.0 20,994,825.0 10,462,696.7 67.0 0 3.6E+10
1,363 1.2 20,994,825.0 10,315,030.9 67.0 0 3.6E+10
1,590 1.4 20,994,825.0 10,314,881.1 67.0 0 3.6E+10
1,818 1.6 20,994,825.0 10,314,770.1 67.0 0 3.6E+10
2,045 1.8 20,994,825.0 10,314,770.1 67.0 0 3.6E+10
2,272 2.0 20,994,825.0 10,314,770.1 67.0 0 3.6E+10
3,408 3.0 20,994,825.0 10,314,770.1 67.0 0 3.6E+10
4,544 4.0 20,994,825.0 10,314,610.6 67.0 0 3.6E+10
6,816 6.0 20,994,825.0 10,314,610.6 67.0 0 3.6E+10
9,088 8.0 20,994,825.0 10,314,610.6 67.0 0 3.6E+10
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: MYCAR/mycar Snap: 9346
-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
-> 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.
Est LC Est LC Est LC Est LC
Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem Obj
Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Hits (K)
-------- ----- -------- ------------ -------- ------ ------- ------ ------------
752 .6 32 1,971 6.23E+06 1.0 1.9E+05 1.1 70,109
880 .7 162 9,229 6.23E+06 1.0 1.9E+05 1.1 285,499
1,008 .8 289 14,018 6.24E+06 1.0 1.8E+05 1.0 286,059
1,136 .9 417 18,299 6.24E+06 1.0 1.8E+05 1.0 286,301
1,264 1.0 545 22,321 6.24E+06 1.0 1.8E+05 1.0 286,498
1,392 1.1 673 26,161 6.24E+06 1.0 1.8E+05 1.0 286,672
1,520 1.2 799 29,440 6.24E+06 1.0 1.8E+05 1.0 286,779
1,648 1.3 927 32,543 6.24E+06 1.0 1.8E+05 1.0 286,826
1,776 1.4 1,063 34,972 6.24E+06 1.0 1.8E+05 1.0 286,856
1,904 1.5 1,219 38,433 6.24E+06 1.0 1.8E+05 1.0 286,871
2,032 1.6 1,357 41,196 6.24E+06 1.0 1.8E+05 1.0 286,882
2,160 1.7 1,485 45,470 6.24E+06 1.0 1.8E+05 1.0 286,890
2,288 1.8 1,613 49,558 6.24E+06 1.0 1.8E+05 1.0 286,897
2,416 1.9 1,741 53,781 6.24E+06 1.0 1.8E+05 1.0 286,903
2,544 2.0 1,869 57,837 6.24E+06 1.0 1.8E+05 1.0 286,909
-------------------------------------------------------------
SGA Target Advisory DB/Inst: MYCAR/mycar Snap: 9346
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
1,072 0.5 4,317,949 1,556,587,681
1,608 0.8 4,303,331 1,552,862,302
2,144 1.0 4,299,461 1,552,241,405
2,680 1.3 4,292,152 1,490,151,749
3,216 1.5 4,288,712 1,490,151,749
3,752 1.8 4,287,852 1,490,151,749
4,288 2.0 4,287,852 1,408,193,403
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: MYCAR/mycar Snap: 9346
Size for Size Est Spill Est Spill Est Unspill Est Unspill
Est (MB) Factor Count Time (s) Count Time (s)
---------- --------- ----------- ----------- ----------- -----------
16 0.5 0 0 0 0
32 1.0 0 0 0 0
48 1.5 0 0 0 0
64 2.0 0 0 0 0
80 2.5 0 0 0 0
96 3.0 0 0 0 0
112 3.5 0 0 0 0
128 4.0 0 0 0 0
144 4.5 0 0 0 0
160 5.0 0 0 0 0
176 5.5 0 0 0 0
192 6.0 0 0 0 0
208 6.5 0 0 0 0
224 7.0 0 0 0 0
240 7.5 0 0 0 0
256 8.0 0 0 0 0
272 8.5 0 0 0 0
288 9.0 0 0 0 0
304 9.5 0 0 0 0
320 10.0 0 0 0 0
-------------------------------------------------------------
Java Pool Advisory DB/Inst: MYCAR/mycar Snap: 9346
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Enqueue Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Undo Segment Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count, OOS - Out of Space count
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
2 .2 1,565 1,072 3 240/240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Most recent 35 Undostat rows, ordered by Time desc
Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
19-Jun 07:50 47 317 1,072 2 240 0/0 0/0/0/0/0/0
19-Jun 07:40 38 285 469 2 240 0/0 0/0/0/0/0/0
19-Jun 07:30 18 217 1,071 3 240 0/0 0/0/0/0/0/0
19-Jun 07:20 45 484 467 2 240 0/0 0/0/0/0/0/0
19-Jun 07:10 56 262 1,065 2 240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
AQ deq hash table latch 1 0.0 0 0 N/A
AQ dequeue txn counter l 3,146 0.0 0 0 N/A
ASM db client latch 2,396 0.0 0 0 N/A
ASM map operation hash t 1 0.0 0 0 N/A
ASM network state latch 59 0.0 0 0 N/A
AWR Alerted Metric Eleme 30,884 0.0 0 0 N/A
Change Notification Hash 1,208 0.0 0 0 N/A
Consistent RBA 1,691 0.0 0 0 N/A
DML lock allocation 186,532 0.0 0 0 N/A
Event Group Locks 187 0.0 0 0 N/A
FAL Queue 168 0.0 0 0 N/A
FOB s.o list latch 496 0.0 0 0 N/A
File State Object Pool P 1 0.0 0 0 N/A
IPC stats buffer allocat 1 0.0 0 0 N/A
In memory undo latch 18,831 0.0 0 4,003 0.0
JS Sh mem access 9 0.0 0 0 N/A
JS mem alloc latch 4 0.0 0 0 N/A
JS queue access latch 5 0.0 0 0 N/A
JS queue state obj latch 26,348 0.0 0 0 N/A
KFC FX Hash Latch 1 0.0 0 0 N/A
KFC Hash Latch 1 0.0 0 0 N/A
KFCL LE Freelist 1 0.0 0 0 N/A
KGNFS-NFS:SHM structure 1 0.0 0 0 N/A
KGNFS-NFS:SVR LIST 1 0.0 0 0 N/A
KJC message pool free li 1 0.0 0 0 N/A
KJCT flow control latch 1 0.0 0 0 N/A
KMG MMAN ready and start 1,210 0.0 0 0 N/A
KTF sga latch 18 0.0 0 883 0.0
KWQP Prop Status 2 0.0 0 0 N/A
KWQS pqsubs latch 5 0.0 0 0 N/A
KWQS pqueue ctx latch 226 0.0 0 0 N/A
Locator state objects po 1 0.0 0 0 N/A
Lsod array latch 1 0.0 0 0 N/A
MQL Tracking Latch 0 N/A 0 72 0.0
Memory Management Latch 1 0.0 0 1,210 0.0
Memory Queue 1 0.0 0 0 N/A
Memory Queue Message Sub 1 0.0 0 0 N/A
Memory Queue Message Sub 1 0.0 0 0 N/A
Memory Queue Message Sub 1 0.0 0 0 N/A
Memory Queue Message Sub 1 0.0 0 0 N/A
Memory Queue Subscriber 1 0.0 0 0 N/A
MinActiveScn Latch 20 0.0 0 0 N/A
Mutex 1 0.0 0 0 N/A
Mutex Stats 1 0.0 0 0 N/A
OS process 1,381 0.0 0 0 N/A
OS process allocation 2,128 0.0 0 0 N/A
OS process: request allo 374 0.0 0 0 N/A
PL/SQL warning settings 2,258 0.0 0 0 N/A
PX hash array latch 1 0.0 0 0 N/A
QMT 1 0.0 0 0 N/A
Real-time plan statistic 4,176 0.0 0 0 N/A
SGA blob parent 1 0.0 0 0 N/A
SGA bucket locks 1 0.0 0 0 N/A
SGA heap locks 1 0.0 0 0 N/A
SGA pool locks 1 0.0 0 0 N/A
SQL memory manager latch 124 0.0 0 1,198 0.0
SQL memory manager worka 115,306 0.0 0 0 N/A
Shared B-Tree 573 0.0 0 0 N/A
Streams Generic 1 0.0 0 0 N/A
Testing 1 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Token Manager 1 0.0 0 0 N/A
WCR: sync 1 0.0 0 0 N/A
Write State Object Pool 1 0.0 0 0 N/A
X$KSFQP 9,296 0.0 0 0 N/A
XDB NFS Security Latch 1 0.0 0 0 N/A
XDB unused session pool 1 0.0 0 0 N/A
XDB used session pool 1 0.0 0 0 N/A
active checkpoint queue 1,840 0.0 0 0 N/A
active service list 8,283 0.0 0.5 0 3,507 0.0
archive control 184 0.0 0 0 N/A
archive process latch 504 0.0 0 0 N/A
begin backup scn array 12 0.0 0 0 N/A
buffer pool 1 0.0 0 0 N/A
business card 1 0.0 0 0 N/A
cache buffer handles 662 0.0 0 0 N/A
cache buffers chains 215,296,869 0.1 0.0 0 1,308 0.0
cache buffers lru chain 3,960 0.0 0 4,935 0.0
call allocation 1,168 0.2 1.0 0 0 N/A
cas latch 1 0.0 0 0 N/A
change notification clie 1 0.0 0 0 N/A
channel handle pool latc 413 0.0 0 0 N/A
channel operations paren 22,393 0.0 0 0 N/A
checkpoint queue latch 109,382 0.0 0 2,527 0.0
client/application info 5,382 0.0 0 0 N/A
compile environment latc 254 0.0 0 0 N/A
corrupted undo seg latch 39 0.0 0 0 N/A
cp cmon/server latch 1 0.0 0 0 N/A
cp pool latch 1 0.0 0 0 N/A
cp server hash latch 1 0.0 0 0 N/A
cp sga latch 59 0.0 0 0 N/A
cvmap freelist lock 1 0.0 0 0 N/A
deferred cleanup latch 59 0.0 0 0 N/A
dml lock allocation 59 0.0 0 0 N/A
done queue latch 1 0.0 0 0 N/A
dummy allocation 511 0.0 0 0 N/A
enqueue hash chains 105,440 0.0 0.0 0 0 N/A
enqueues 78,432 0.0 0.0 0 0 N/A
fifth spare latch 1 0.0 0 0 N/A
file cache latch 198 0.0 0 0 N/A
flashback copy 1 0.0 0 0 N/A
gc element 1 0.0 0 0 N/A
gcs commit scn state 1 0.0 0 0 N/A
gcs partitioned table ha 1 0.0 0 0 N/A
gcs pcm hashed value buc 1 0.0 0 0 N/A
gcs resource freelist 1 0.0 0 0 N/A
gcs resource hash 1 0.0 0 0 N/A
gcs resource scan list 1 0.0 0 0 N/A
gcs shadows freelist 1 0.0 0 0 N/A
ges domain table 1 0.0 0 0 N/A
ges enqueue table freeli 1 0.0 0 0 N/A
ges group table 1 0.0 0 0 N/A
ges process hash list 1 0.0 0 0 N/A
ges process parent latch 1 0.0 0 0 N/A
ges resource hash list 1 0.0 0 0 N/A
ges resource scan list 1 0.0 0 0 N/A
ges resource table freel 1 0.0 0 0 N/A
ges value block free lis 1 0.0 0 0 N/A
global KZLD latch for me 50 0.0 0 0 N/A
global ctx hash table la 2 0.0 0 0 N/A
global tx hash mapping 1 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
granule operation 1 0.0 0 0 N/A
hash table column usage 121 0.0 0 68,392 0.0
hash table modification 92 0.0 0 0 N/A
heartbeat check 1 0.0 0 0 N/A
internal temp table obje 4 0.0 0 0 N/A
intra txn parallel recov 1 0.0 0 0 N/A
io pool granule metadata 1 0.0 0 0 N/A
job workq parent latch 69 0.0 0 68 1.5
job_queue_processes free 140 0.0 0 0 N/A
job_queue_processes para 857 0.0 0 0 N/A
k2q lock allocation 1 0.0 0 0 N/A
kdlx hb parent latch 1 0.0 0 0 N/A
kgb parent 1 0.0 0 0 N/A
kks stats 766 0.0 0 0 N/A
kokc descriptor allocati 996 0.0 0 0 N/A
krbmrosl 2 0.0 0 0 N/A
ksfv messages 1 0.0 0 0 N/A
kss move lock 33 0.0 0 0 N/A
ksuosstats global area 245 0.0 0 0 N/A
ksv allocation latch 123 0.0 0 0 N/A
ksv class latch 65 0.0 0 0 N/A
ksv msg queue latch 1 0.0 0 0 N/A
ksz_so allocation latch 374 0.0 0 0 N/A
ktm global data 19 0.0 0 0 N/A
kwqbsn:qsga 221 0.0 0 0 N/A
lgwr LWN SCN 2,172 0.0 0 0 N/A
list of block allocation 349 0.0 0 0 N/A
loader state object free 592 0.0 0 0 N/A
lob segment dispenser la 1 0.0 0 0 N/A
lob segment hash table l 13 0.0 0 0 N/A
lob segment query latch 1 0.0 0 0 N/A
lock DBA buffer during m 1 0.0 0 0 N/A
logical standby cache 1 0.0 0 0 N/A
logminer context allocat 2 0.0 0 0 N/A
logminer work area 1 0.0 0 0 N/A
longop free list parent 1 0.0 0 0 N/A
managed standby latch 168 0.0 0 0 N/A
mapped buffers lru chain 1 0.0 0 0 N/A
message pool operations 123 0.0 0 0 N/A
messages 37,179 0.0 0.0 0 0 N/A
mostly latch-free SCN 2,172 0.0 0 0 N/A
msg queue latch 1 0.0 0 0 N/A
name-service namespace b 1 0.0 0 0 N/A
ncodef allocation latch 59 0.0 0 0 N/A
object queue header heap 90 0.0 0 37 0.0
object queue header oper 12,183 0.0 0 0 N/A
object stats modificatio 21 0.0 0 0 N/A
parallel query alloc buf 469 0.0 0 0 N/A
parallel query stats 1 0.0 0 0 N/A
parameter list 56 0.0 0 0 N/A
parameter table manageme 514 0.0 0 0 N/A
peshm 1 0.0 0 0 N/A
pesom_free_list 1 0.0 0 0 N/A
pesom_hash_node 1 0.0 0 0 N/A
post/wait queue 1,514 0.0 0 1,018 0.0
process allocation 510 0.0 0 186 0.0
process group creation 374 0.0 0 0 N/A
process queue 1 0.0 0 0 N/A
process queue reference 1 0.0 0 0 N/A
qmn task queue latch 908 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
query server freelists 1 0.0 0 0 N/A
queued dump request 12 0.0 0 0 N/A
queuing load statistics 1 0.0 0 0 N/A
recovery domain hash lis 1 0.0 0 0 N/A
redo allocation 13,888 0.0 0.0 0 12,072 0.0
redo copy 1 0.0 0 12,072 0.4
redo writing 9,441 0.0 0 0 N/A
resmgr group change latc 1,167 0.0 0 0 N/A
resmgr:active threads 511 0.0 0 0 N/A
resmgr:actses change gro 135 0.0 0 0 N/A
resmgr:actses change sta 1 0.0 0 0 N/A
resmgr:free threads list 510 0.0 0 0 N/A
resmgr:plan CPU method 1 0.0 0 0 N/A
resmgr:resource group CP 1 0.0 0 0 N/A
resmgr:schema config 81 0.0 0 0 N/A
resmgr:session queuing 1 0.0 0 0 N/A
rm cas latch 1 0.0 0 0 N/A
row cache objects 274,802 0.0 0.0 0 43 0.0
rules engine rule set st 100 0.0 0 0 N/A
second spare latch 1 0.0 0 0 N/A
sequence cache 5,360 0.0 0 0 N/A
session allocation 157,250 0.0 0.0 0 52,415 0.0
session idle bit 1,071,798 0.0 0.0 0 0 N/A
session queue latch 1 0.0 0 0 N/A
session state list latch 468 0.0 0 0 N/A
session switching 1,000 0.0 0 0 N/A
session timer 1,238 0.0 0 0 N/A
shared pool 42,377 0.1 0.2 0 0 N/A
shared pool sim alloc 1 0.0 0 0 N/A
shared pool simulator 1,207 0.0 0 0 N/A
sim partition latch 1 0.0 0 0 N/A
simulator hash latch 7,691,401 0.0 0.1 0 0 N/A
simulator lru latch 1,640 0.0 0 7,689,753 0.1
sort extent pool 8,904 0.0 0 0 N/A
space background state o 2 0.0 0 0 N/A
space background task la 2,680 0.1 0.0 0 2,420 0.0
state object free list 2 0.0 0 0 N/A
statistics aggregation 560 0.0 0 0 N/A
tablespace key chain 1 0.0 0 0 N/A
temp lob duration state 4 0.0 0 0 N/A
test excl. parent l0 1 0.0 0 0 N/A
test excl. parent2 l0 1 0.0 0 0 N/A
third spare latch 1 0.0 0 0 N/A
threshold alerts latch 168 0.0 0 0 N/A
transaction allocation 45,620 0.0 0 0 N/A
undo global data 9,671 0.0 0 0 N/A
virtual circuit buffers 1 0.0 0 0 N/A
virtual circuit holder 1 0.0 0 0 N/A
virtual circuit queues 1 0.0 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> ordered by misses desc
Get Spin
Latch Name Requests Misses Sleeps Gets
-------------------------- --------------- ------------ ----------- -----------
cache buffers chains 215,296,869 163,504 74 163,432
shared pool 42,377 43 8 36
session idle bit 1,071,798 37 1 36
simulator hash latch 7,691,401 14 1 13
active service list 8,283 2 1 1
call allocation 1,168 2 2 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
active service list kswslogon: session logout 0 1 0
cache buffers chains kcbgtcr: fast path (cr pin 0 67 6
cache buffers chains kcbrls_1 0 14 75
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kcbrls_2 0 1 2
call allocation ksuxds 0 2 0
session idle bit ksuxds 0 1 1
shared pool kghalo 0 8 4
simulator hash latch kcbsacc: lookup dba 0 1 1
-------------------------------------------------------------
Mutex Sleep Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Logical Reads: 108,335,429
-> Captured Segments account for 99.7% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR SYS_PRODUCT_BURN_INF TABLE 60,055,568 55.43
MYCAR MYCAR DIAG_SOFT_VERSION_DE TABLE 19,928,208 18.39
MYCAR MYCAR SYS_PRODUCT TABLE 19,789,408 18.27
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 3,373,040 3.11
MYCAR MYCAR SYS_PRODUCT_LANG_CON TABLE 982,784 .91
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Physical Reads: 1,000,290
-> Captured Segments account for 0.0% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 38 .00
MYCAR MYCAR UK_SERIAL_NO INDEX 12 .00
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 9 .00
PASSPORT PASSPORT OPERATE_LOG TABLE 7 .00
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 2 .00
-------------------------------------------------------------
Segments by Physical Read Requests DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Physical Read Requests: 37,286
-> Captured Segments account for 0.2% of Total
Tablespace Subobject Obj. Phys Read
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 38 .10
MYCAR MYCAR UK_SERIAL_NO INDEX 12 .03
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 9 .02
PASSPORT PASSPORT OPERATE_LOG TABLE 7 .02
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 2 .01
-------------------------------------------------------------
Segments by UnOptimized Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total UnOptimized Read Requests: 37,286
-> Captured Segments account for 0.2% of Total
Tablespace Subobject Obj. UnOptimized
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 38 .10
MYCAR MYCAR UK_SERIAL_NO INDEX 12 .03
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 9 .02
PASSPORT PASSPORT OPERATE_LOG TABLE 7 .02
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 2 .01
-------------------------------------------------------------
Segments by Optimized Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Direct Physical Reads DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Physical Writes DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Physical Writes: 1,010,180
-> Captured Segments account for 0.1% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 646 .06
MYCAR MYCAR OPERATE_LOG TABLE 111 .01
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 56 .01
PASSPORT PASSPORT OPERATE_LOG TABLE 24 .00
MYCAR MYCAR SYS_PRODUCT TABLE 21 .00
-------------------------------------------------------------
Segments by Physical Write Requests DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Physical Write Requestss: 38,715
-> Captured Segments account for 1.3% of Total
Tablespace Subobject Obj. Phys Write
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 177 .46
MYCAR MYCAR OPERATE_LOG TABLE 95 .25
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 47 .12
PASSPORT PASSPORT OPERATE_LOG TABLE 22 .06
MYCAR MYCAR SYS_PRODUCT TABLE 21 .05
-------------------------------------------------------------
Segments by Direct Physical Writes DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Total Direct Physical Writes: 1,007,528
-> Captured Segments account for 0.0% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSAUX SYS_LOB0000006213C00 LOB 11 .00
SYS SYSAUX SYS_LOB0000006207C00 LOB 1 .00
-------------------------------------------------------------
Segments by Table Scans DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Segments by DB Blocks Changes DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> % of Capture shows % of DB Block Changes for each top segment compared
-> with total DB Block Changes for all segments captured by the Snapshot
Tablespace Subobject Obj. DB Block % of
Owner Name Object Name Name Type Changes Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 1,664 47.93
SYS SYSAUX WRH$_SQL_PLAN TABLE 320 9.22
MYCAR MYCAR OPERATE_LOG TABLE 304 8.76
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 192 5.53
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 176 5.07
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 4 100.00
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "Pct Misses" should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control 65 0.0 0 N/A 2 1
dc_files 9 0.0 0 N/A 0 9
dc_global_oids 4,232 0.0 0 N/A 0 108
dc_histogram_data 4,124 0.0 0 N/A 0 7,071
dc_histogram_defs 5,761 0.0 0 N/A 0 6,521
dc_object_grants 516 0.0 0 N/A 0 281
dc_objects 8,399 0.0 0 N/A 5 3,766
dc_profiles 170 0.0 0 N/A 0 2
dc_rollback_segments 857 0.0 0 N/A 0 22
dc_segments 2,601 0.0 0 N/A 7 1,706
dc_sequences 151 0.0 0 N/A 151 39
dc_tablespaces 24,624 0.0 0 N/A 0 10
dc_users 41,501 0.0 0 N/A 0 183
global database name 2,549 0.0 0 N/A 0 2
outstanding_alerts 42 0.0 0 N/A 0 7
sch_lj_oids 4 0.0 0 N/A 0 12
-------------------------------------------------------------
Library Cache Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
APP CONTEXT 7 0.0 7 0.0 0 0
BODY 1,352 0.0 8,134 0.0 0 0
CLUSTER 12 0.0 3 0.0 0 0
DBLINK 102 0.0 0 N/A 0 0
EDITION 133 0.0 251 0.0 0 0
INDEX 15 0.0 15 0.0 0 0
QUEUE 8,548 0.0 10,273 0.0 0 0
SCHEMA 168 0.0 0 N/A 0 0
SQL AREA 8,800 2.5 169,352 0.2 62 24
SUBSCRIPTION 19 0.0 19 0.0 0 0
TABLE/PROCEDURE 8,303 0.0 21,932 0.0 0 0
TRIGGER 877 0.0 938 0.0 0 0
-------------------------------------------------------------
Memory Dynamic Components DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Min/Max sizes since instance startup
-> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
-> ordered by Component
Begin Snap Current Min Max Oper Last Op
Component Size (Mb) Size (Mb) Size (Mb) Size (Mb) Count Typ/Mod
--------------- ----------- ----------- ----------- ----------- ------ -------
ASM Buffer Cach .00 .00 .00 .00 0 STA/
DEFAULT 16K buf .00 .00 .00 .00 0 STA/
DEFAULT 2K buff .00 .00 .00 .00 0 STA/
DEFAULT 32K buf .00 .00 .00 .00 0 STA/
DEFAULT 4K buff .00 .00 .00 .00 0 STA/
DEFAULT 8K buff .00 .00 .00 .00 0 STA/
DEFAULT buffer 784.00 784.00 784.00 816.00 0 SHR/IMM
KEEP buffer cac .00 .00 .00 .00 0 STA/
PGA Target 1,136.00 1,136.00 1,136.00 1,136.00 0 STA/
RECYCLE buffer .00 .00 .00 .00 0 STA/
SGA Target 2,144.00 2,144.00 2,144.00 2,144.00 0 STA/
Shared IO Pool .00 .00 .00 .00 0 STA/
java pool 16.00 16.00 16.00 16.00 0 STA/
large pool 16.00 16.00 16.00 16.00 0 STA/
shared pool 1,264.00 1,264.00 1,264.00 1,264.00 0 STA/
streams pool 32.00 32.00 .00 32.00 0 GRO/IMM
-------------------------------------------------------------
Memory Resize Operations Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Memory Resize Ops DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Process Memory Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> B: Begin Snap E: End Snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
-> Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> ordered by Begin/End snapshot, Alloc (MB) desc
Hist
Avg Std Dev Max Max
Alloc Used Alloc Alloc Alloc Alloc Num Num
Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other 404.7 N/A 3.9 7.8 28 28 105 105
Freeable 63.2 .0 1.1 .9 4 N/A 56 56
SQL 45.4 44.5 .6 4.4 39 128 82 75
PL/SQL 8.1 7.7 .1 .3 2 2 103 103
E Other 402.4 N/A 3.9 7.8 28 28 103 103
Freeable 63.7 .0 1.1 .9 4 N/A 56 56
SQL 45.4 44.5 .6 4.4 39 128 81 75
PL/SQL 8.0 7.7 .1 .3 2 2 101 101
-------------------------------------------------------------
SGA Memory Summary DB/Inst: MYCAR/mycar Snaps: 9345-9346
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 822,083,584
Fixed Size 2,218,152
Redo Buffers 15,970,304
Variable Size 2,583,693,144
-------------------
sum 3,423,965,184
-------------------------------------------------------------
SGA breakdown difference DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> ordered by Pool, Name
-> N/A value for Begin MB or End MB indicates the size of that Pool/Name was
insignificant, or zero in that snapshot
Pool Name Begin MB End MB % Diff
------ ------------------------------ -------------- -------------- -------
java free memory 16.0 16.0 0.00
large PX msg pool 7.5 7.5 0.00
large free memory 8.5 8.5 0.00
shared CCUR 82.8 83.0 0.31
shared FileOpenBlock 15.2 15.2 0.00
shared KGLHD 29.4 29.3 -0.29
shared KGLS 15.2 15.2 -0.20
shared PCUR 77.3 77.1 -0.30
shared PLMCD 14.5 14.5 0.00
shared SQLA 438.0 438.6 0.15
shared free memory 380.9 380.6 -0.10
stream KTG hash buckets 1.3 1.3 0.00
stream free memory 30.7 30.7 0.00
buffer_cache 784.0 784.0 0.00
fixed_sga 2.1 2.1 0.00
log_buffer 15.2 15.2 0.00
-------------------------------------------------------------
Streams CPU/IO Usage DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Streams processes ordered by Foreground CPU Time, descending
Foreground User IO SYS IO
Session Type First Logon CPU time(s) Wait time(s) Wait time(s)
-------------------- ------------- ------------ ------------ ------------
QMON Coordinator 0326 18:10:23 0.0 0.0 0.0
QMON Slaves 0326 18:10:33 0.0 0.0 0.0
-------------------------------------------------------------
Streams Capture DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture Rate DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply Rate DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Persistent Queues DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by Queue Name
-> * indicates queue (re)started between Begin/End snaps
-> %Exp Msgs - % of msgs enqueued with expiry
-> %Delay Msgs - % of msgs enqueued with delay
-> %Trasf Time - % of Enqueue time spent in transformation
-> %Eval Time - % of Enqueue time spent in rule evaluation
Enq Deq %Exp %Delay Enq Deq %Transf %Eval
Msgs Msgs Msgs Msgs Time(s) Time(s) Time Time
---------- ---------- ------ ------- -------- -------- --------- -------
SYS.ALERT_QUE(12343)
0 0 N/A N/A 0.0 0.0 N/A N/A
SYS.AQ$_ALERT_QT_E(12342)
0 0 N/A N/A 0.0 0.0 N/A N/A
SYSMAN.MGMT_NOTIFY_Q(66903)
0 0 N/A N/A 0.0 0.0 N/A N/A
SYSMAN.MGMT_TASK_Q(66573)
61 61 0.0 0.0 0.0 0.1 0.0 0.0
-------------------------------------------------------------
Persistent Queues Rate DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by Queue Name
-> * indicates queue (re)started between Begin/End snaps
Enqueue Dequeue Avg Enqueue Avg Dequeue
Msgs/sec Msgs/sec sec / msg sec / msg
---------- ---------- ------------- -------------
SYS.ALERT_QUE(12343)
0.00 0.00 N/A N/A
SYS.AQ$_ALERT_QT_E(12342)
0.00 0.00 N/A N/A
SYSMAN.MGMT_NOTIFY_Q(66903)
0.00 0.00 N/A N/A
SYSMAN.MGMT_TASK_Q(66573)
0.02 0.02 0.00 0.00
-------------------------------------------------------------
Persistent Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by Queue Name, Subscriber Name
-> * indicates Subscriber activity (re)started between Begin/End snaps
Enqueue Dequeue Expire Enqueue Dequeue Expire
Msgs Msgs Msgs Msgs/sec Msgs/sec Msgs/sec
---------- ---------- ---------- ---------- ---------- ----------
HAE_SUB(1)/SYS.ALERT_QUE
0 0 0 N/A N/A N/A
VM19216800003_3938_MYCAR(22)/SYS.ALERT_QUE
0 0 0 0.00 0.00 0.00
-------------------------------------------------------------
Resource Limit Stats DB/Inst: MYCAR/mycar Snap: 9346
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Activity DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Values represent averages for all samples
Avg Total Avg Active Avg Total Avg Active Avg Total Avg Active
Connections Connections Shared Srvrs Shared Srvrs Dispatchers Dispatchers
------------ ------------ ------------ ------------ ------------ ------------
0 0 1 0 1 0
-------------------------------------------------------------
Shared Servers Rates DB/Inst: MYCAR/mycar Snaps: 9345-9346
Common Disp Common Disp Server
Queue Queue Server Server Queue Queue Total Server
Per Sec Per Sec Msgs/Sec KB/Sec Total Total Msgs Total(KB)
-------- -------- -------- --------- ---------- ---------- ---------- ----------
0 0 0 0.0 0 0 0 0
-------------------------------------------------------------
Shared Servers Utilization DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Statistics are combined for all servers
-> Incoming and Outgoing Net % are included in %Busy
Total Server Incoming Outgoing
Time (s) %Busy %Idle Net % Net %
-------------- -------- -------- --------- ---------
3,634 0.0 100.0 0.0 0.0
-------------------------------------------------------------
Shared Servers Common Queue DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Dispatchers DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> Ordered by %Busy, descending
-> Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
-> Name suffixes:
"(N)" - dispatcher started between begin and end snapshots
"(R)" - dispatcher re-started between begin and end snapshots
Avg Total Disp Total Total Queue Avg Queue
Name Conns Time (s) %Busy %Idle Queued Wait (s) Wait (ms)
------- --------- ---------- -------- -------- ---------- ----------- ----------
D000 0.0 3,634 0.0 100.0 0 0
-------------------------------------------------------------
init.ora Parameters DB/Inst: MYCAR/mycar Snaps: 9345-9346
-> if IP/Public/Source at End snap is different a '*' is displayed
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /oracle/admin/mycar/adump
audit_trail DB
compatible 11.2.0.0.0
control_files /oracle/oradata/mycar/control01.c
db_block_size 8192
db_domain
db_name mycar
db_recovery_file_dest /oracle/flash_recovery_area
db_recovery_file_dest_size 4070572032
deferred_segment_creation FALSE
diagnostic_dest /oracle
dispatchers (PROTOCOL=TCP) (SERVICE=mycarXDB)
log_archive_dest_1 location=/oracle/oradata/archivel
log_archive_format archive_%t_%s_%r.log
log_archive_max_processes 10
memory_target 3439329280
open_cursors 300
processes 500
remote_login_passwordfile EXCLUSIVE
sec_case_sensitive_logon FALSE
undo_retention 14400
undo_tablespace UNDOTBS1
-------------------------------------------------------------
Dynamic Remastering Stats DB/Inst: MYCAR/mycar Snaps: 9345-9346
No data exists for this section of the report.
-------------------------------------------------------------
End of Report
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22126868/viewspace-764351/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
你的数据库中有等待问题么？
请登录后发表评论
登录
全部评论
