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: 9474 24-Jun-13 16:00:19 97 4.8
End Snap: 9475 24-Jun-13 17:00:43 102 4.5
Elapsed: 60.40 (mins)
DB Time: 990.46 (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): 16.4 15.0 0.12 0.03
DB CPU(s): 1.8 1.7 0.01 0.00
Redo size: 3,912.2 3,581.5
Logical reads: 101,396.9 92,823.8
Block changes: 15.3 14.0
Physical reads: 2,164.7 1,981.6
Physical writes: 1,148.8 1,051.7
User calls: 476.4 436.1
Parses: 134.9 123.5
Hard parses: 0.1 0.1
W/A MB processed: 14.1 12.9
Logons: 0.1 0.1
Executes: 136.2 124.7
Rollbacks: 0.0 0.0
Transactions: 1.1
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.84 Soft Parse %: 99.94
Execute to Parse %: 0.94 Latch Hit %: 99.88
Parse CPU to Parse Elapsd %: 16.97 % Non-Parse CPU: 99.91
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 71.58 70.88
% SQL with executions>1: 92.01 95.35
% Memory for SQL w/exec>1: 87.63 92.77
Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
direct path write temp 205,140 37,874 185 63.7 User I/O
direct path read temp 204,387 8,892 44 15.0 User I/O
DB CPU 6,679 11.2
direct path read 30,455 551 18 .9 User I/O
log file sync 4,077 404 99 .7 Commit
Host CPU (CPUs: 4 Cores: 4 Sockets: 4)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
1.30 6.50 34.1 12.1 10.8 53.8
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 46.1
% of busy CPU for Instance: 99.8
%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): 488.5 484.6
% Host Mem used for SGA+PGA: 32.14 32.09
Time Model Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total time in database user-calls (DB Time): 59427.4s
-> 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 58,650.4 98.7
DB CPU 6,679.2 11.2
PL/SQL execution elapsed time 4,702.7 7.9
parse time elapsed 43.2 .1
connection management call elapsed time 36.5 .1
hard parse elapsed time 6.8 .0
failed parse elapsed time 1.4 .0
hard parse (sharing criteria) elapsed time 0.9 .0
sequence load elapsed time 0.2 .0
repeated bind elapsed time 0.0 .0
PL/SQL compilation elapsed time 0.0 .0
DB time 59,427.4
background elapsed time 694.5
background cpu time 2.1
-------------------------------------------------------------
Operating System Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> *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 669,667
IDLE_TIME 780,428
IOWAIT_TIME 156,557
NICE_TIME 0
SYS_TIME 175,251
USER_TIME 493,865
LOAD 1 7
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: 9474-9475
Snap Time Load %busy %user %sys %idle %iowait
--------------- -------- -------- -------- -------- -------- --------
24-Jun 16:00:19 1.3 N/A N/A N/A N/A N/A
24-Jun 17:00:43 6.5 46.2 34.1 12.1 53.8 10.8
-------------------------------------------------------------
Foreground Wait Class DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 91.9% of Total DB time 59,427.43 (s)
-> Total FG Wait Time: 47,923.01 (s) DB CPU time: 6,679.21 (s)
Avg
%Time Total Wait wait
Wait Class Waits -outs Time (s) (ms) %DB time
-------------------- ---------------- ----- ---------------- -------- ---------
User I/O 441,860 0 47,430 107 79.8
DB CPU 6,679 11.2
Commit 4,077 0 404 99 0.7
Concurrency 843 0 48 57 0.1
Application 61 0 19 307 0.0
Other 76,860 100 15 0 0.0
Network 1,303,117 0 7 0 0.0
System I/O 12 0 0 2 0.0
-------------------------------------------------------------
Foreground Wait Events DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 205,140 0 37,874 185 51.8 63.7
direct path read temp 204,387 0 8,892 44 51.6 15.0
direct path read 30,455 0 551 18 7.7 .9
log file sync 4,077 0 404 99 1.0 .7
db file sequential read 1,569 0 112 71 0.4 .2
latch: cache buffers chain 811 0 41 51 0.2 .1
enq: KO - fast object chec 47 0 19 397 0.0 .0
latch free 123 0 13 106 0.0 .0
cursor: pin S 14 0 7 495 0.0 .0
SQL*Net message to client 1,252,837 0 5 0 316.5 .0
reliable message 37 0 1 32 0.0 .0
SQL*Net more data from cli 4,495 0 1 0 1.1 .0
Disk file operations I/O 305 0 1 2 0.1 .0
SQL*Net more data to clien 45,785 0 1 0 11.6 .0
db file scattered read 3 0 0 120 0.0 .0
asynch descriptor resize 76,699 100 0 0 19.4 .0
latch: enqueue hash chains 1 0 0 236 0.0 .0
latch: row cache objects 8 0 0 11 0.0 .0
library cache: mutex X 2 0 0 29 0.0 .0
SQL*Net break/reset to cli 14 0 0 3 0.0 .0
control file sequential re 12 0 0 2 0.0 .0
read by other session 1 0 0 23 0.0 .0
enq: TX - index contention 1 0 0 13 0.0 .0
latch: shared pool 2 0 0 2 0.0 .0
buffer busy waits 1 0 0 3 0.0 .0
SQL*Net message from clien 1,252,836 0 88,472 71 316.5
jobq slave wait 7,665 100 3,883 507 1.9
-------------------------------------------------------------
Background Wait Events DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
-------------------------- ------------ ----- ---------- ------- -------- ------
log file parallel write 9,162 0 292 32 2.3 42.0
control file parallel writ 1,247 0 119 95 0.3 17.1
db file async I/O submit 899 0 103 115 0.2 14.9
os thread startup 139 0 79 572 0.0 11.4
direct path write 37 0 5 125 0.0 .7
control file sequential re 5,910 0 4 1 1.5 .6
direct path sync 3 0 2 623 0.0 .3
Disk file operations I/O 94 0 2 19 0.0 .3
enq: JD - contention 1 0 1 940 0.0 .1
log file sync 4 0 1 233 0.0 .1
latch: shared pool 3 0 1 289 0.0 .1
db file sequential read 100 0 1 7 0.0 .1
LGWR wait for redo copy 8 0 0 24 0.0 .0
ADR block file read 13 0 0 3 0.0 .0
latch free 2 0 0 6 0.0 .0
asynch descriptor resize 336 100 0 0 0.1 .0
ADR block file write 5 0 0 0 0.0 .0
rdbms ipc message 19,988 76 78,928 3949 5.0
DIAG idle wait 7,199 100 7,248 1007 1.8
smon timer 13 100 3,900 300030 0.0
shared server idle wait 121 100 3,633 30021 0.0
pmon timer 1,359 88 3,625 2667 0.3
Space Manager: slave idle 695 100 3,620 5209 0.2
Streams AQ: qmn slave idle 248 0 3,615 14579 0.1
Streams AQ: qmn coordinato 378 34 3,615 9565 0.1
dispatcher timer 60 100 3,601 60019 0.0
SQL*Net message from clien 282 0 7 26 0.1
class slave wait 19 0 0 0 0.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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>-> % 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 13 76.9 23.1
ADR block file write 5 100.0
ADR file lock 6 100.0
Disk file operations I/O 399 95.7 2.8 .5 .8 .3
LGWR wait for redo copy 8 87.5 12.5
SQL*Net break/reset to cli 14 85.7 7.1 7.1
SQL*Net message to client 1254. 100.0 .0 .0 .0 .0 .0 .0
SQL*Net more data from cli 4495 99.7 .1 .0 .2
SQL*Net more data to clien 45.8K 100.0 .0
asynch descriptor resize 77K 100.0 .0 .0
buffer busy waits 1 100.0
control file parallel writ 1247 39.9 2.9 2.2 3.4 5.6 5.9 39.3 .9
control file sequential re 5922 99.4 .0 .0 .1 .1 .1 .2 .0
cursor: mutex S 2 100.0
cursor: pin S 14 14.3 7.1 64.3 14.3
db file async I/O submit 899 25.3 11.2 5.5 2.1 4.6 6.8 43.3 1.3
db file scattered read 3 33.3 66.7
db file sequential read 1671 45.4 3.2 2.9 4.8 6.6 3.4 33.3 .4
direct path read 30.4K 84.1 .5 .3 .6 1.1 1.6 11.8 .0
direct path read temp 204.4 34.2 .2 .6 2.0 5.6 12.6 44.7 .0
direct path sync 3 66.7 33.3
direct path write 37 86.5 2.7 2.7 8.1
direct path write temp 205.1 6.9 15.6 7.4 5.3 7.1 8.9 46.4 2.5
enq: JD - contention 1 100.0
enq: KO - fast object chec 47 4.3 8.5 8.5 6.4 8.5 51.1 12.8
enq: TX - index contention 1 100.0
latch free 125 45.6 8.8 8.8 5.6 3.2 2.4 24.8 .8
latch: In memory undo latc 2 100.0
latch: cache buffers chain 811 59.8 2.5 1.6 2.2 6.3 3.7 23.7 .2
latch: enqueue hash chains 1 100.0
latch: redo allocation 1 100.0
latch: row cache objects 8 50.0 12.5 25.0 12.5
latch: shared pool 5 40.0 20.0 40.0
library cache: mutex X 2 50.0 50.0
log file parallel write 9160 70.2 1.7 2.2 2.7 3.8 3.7 15.6 .2
log file sync 4081 34.2 3.5 4.4 5.5 7.8 7.6 36.1 .9
os thread startup 139 58.3 28.8 12.9
read by other session 1 100.0
reliable message 37 62.2 8.1 2.7 2.7 2.7 21.6
DIAG idle wait 7201 93.8 6.2
SQL*Net message from clien 1254. 86.2 4.1 1.2 1.2 2.1 .7 4.3 .3
Space Manager: slave idle 695 100.0
Streams AQ: qmn coordinato 378 60.3 .3 1.3 .8 3.2 34.1
Streams AQ: qmn slave idle 248 48.0 52.0
class slave wait 19 100.0
dispatcher timer 60 100.0
jobq slave wait 7668 .0 100.0
pmon timer 1359 8.4 .3 .3 .2 2.2 88.6
rdbms ipc message 20K 4.1 .3 1.4 .9 8.0 1.3 24.1 59.9
shared server idle wait 121 100.0
smon timer 13 100.0
-------------------------------------------------------------
Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: MYCAR/mycar Snaps: 94
-> 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
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
Disk file operations I/O 4 99.0 .3 .5 .3
LGWR wait for redo copy 1 87.5 12.5
SQL*Net break/reset to cli 1 92.9 7.1
SQL*Net message to client 13 100.0 .0 .0 .0 .0 .0
SQL*Net more data from cli 7 99.8 .0 .1 .0
control file parallel writ 499 59.8 7.9 10.7 11.1 7.1 2.5 .7 .2
control file sequential re 15 99.7 .1 .1 .0 .1 .0
cursor: pin S 10 21.4 7.1 7.1 50.0 7.1 7.1
db file async I/O submit 399 55.4 8.3 13.1 10.3 7.9 3.6 1.1 .2
db file scattered read 2 33.3 66.7
db file sequential read 561 66.3 4.9 12.7 8.7 5.7 1.3 .3 .1
direct path read 3597 88.2 2.2 4.9 3.5 1.2 .2 .0 .0
direct path read temp 91.4K 55.3 21.7 16.1 5.6 1.2 .1 .0
direct path sync 3 33.3 33.3 33.3
direct path write 3 89.2 2.7 5.4 2.7
direct path write temp 96.9K 51.2 9.3 13.3 14.0 7.9 1.9 .9 1.6
enq: JD - contention 1 100.0
enq: KO - fast object chec 27 36.2 8.5 6.4 10.6 19.1 6.4 6.4 6.4
latch free 31 74.4 4.0 4.0 6.4 5.6 4.8 .8
latch: cache buffers chain 194 76.1 4.1 6.7 7.5 4.4 1.0 .2
latch: enqueue hash chains 1 100.0
latch: row cache objects 1 87.5 12.5
latch: shared pool 2 60.0 20.0 20.0
library cache: mutex X 1 50.0 50.0
log file parallel write 1445 84.2 4.0 4.7 3.5 2.6 .8 .1 .0
log file sync 1500 63.0 8.4 9.2 7.8 7.0 3.8 .6 .2
os thread startup 43 58.3 15.1 5.8 2.9 1.4 3.6 2.2 10.8
reliable message 8 78.4 10.8 8.1 2.7
-------------------------------------------------------------
Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: MYCAR/mycar Snaps: 9474
-> 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 2 99.8 .2
cursor: pin S 1 92.9 7.1
db file async I/O submit 2 99.8 .2
db file sequential read 2 99.9 .1
direct path read 1 100.0 .0
direct path write 1 97.3 2.7
direct path write temp 3285 98.4 .8 .6 .2 .0
enq: KO - fast object chec 3 93.6 6.4
latch free 1 99.2 .8
log file parallel write 2 100.0 .0
log file sync 10 99.8 .2 .0
os thread startup 15 89.2 6.5 3.6 .7
-------------------------------------------------------------
Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: MYCAR/mycar Snaps: 9474-
No data exists for this section of the report.
-------------------------------------------------------------
Service Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K)
---------------------------- ------------ ------------ ------------ ------------
SYS$USERS 59,425 6,676 7,845 367,429
SYS$BACKGROUND 0 0 0 25
mycar 0 0 0 0
mycarXDB 0 0 0 0
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
441860 47430 842 48 0 0 1303138 7
SYS$BACKGROUND
231 9 140 80 0 0 0 0
mycar
0 0 0 0 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 98.3% of Total DB Time (s): 59,427
-> Captured PL/SQL account for 0.1% of Total DB Time (s): 59,427
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
47,321.8 109 434.14 79.6 .4 98.3 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
8,439.3 15,098 0.56 14.2 64.4 .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)
595.9 56 10.64 1.0 4.0 91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_
437.5 1 437.50 .7 7.9 .0 699fq02xtmfp0
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
254.6 21 12.13 .4 5.0 93.4 7c9aurkrt70vn
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
198.8 4,806 0.04 .3 93.4 .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
190.3 18,949 0.01 .3 76.2 .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
95.1 6,451 0.01 .2 80.1 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
81.9 5,275 0.02 .1 81.1 .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
66.2 5,275 0.01 .1 87.4 .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
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 97.4% of Total CPU Time (s): 6,679
-> Captured PL/SQL account for 0.0% of Total CPU Time (s): 6,679
CPU CPU per Elapsed
Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
5,431.3 15,098 0.36 81.3 8,439.3 64.4 .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)
209.7 109 1.92 3.1 47,321.8 .4 98.3 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
185.7 4,806 0.04 2.8 198.8 93.4 .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
145.0 18,949 0.01 2.2 190.3 76.2 .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
76.2 6,451 0.01 1.1 95.1 80.1 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
66.5 5,275 0.01 1.0 81.9 81.1 .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
57.8 5,275 0.01 0.9 66.2 87.4 .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
34.4 1 34.39 0.5 437.5 7.9 .0 699fq02xtmfp0
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
33.8 1 33.80 0.5 37.4 90.4 .0 7hcv97jgzd6zw
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
31.2 1 31.24 0.5 45.2 69.2 .0 9734c447d6rvf
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
-------------------------------------------------------------
SQL ordered by User I/O Wait Time DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 100.0% of Total User I/O Wait Time (s): 47
-> 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
---------- ------------ ---------- ------ ---------- ------ ------ -------------
46,527.6 109 426.86 98.1 47,321.8 .4 98.3 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
545.0 56 9.73 1.1 595.9 4.0 91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_
237.9 21 11.33 0.5 254.6 5.0 93.4 7c9aurkrt70vn
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
48.7 8 6.08 0.1 49.8 1.0 97.8 0j5z1mkgtqw4s
select n.*,c.FAULT_CODE_ID_BYNAME from df_fault_code_desc c join df_fault_code_n
ame_desc n on (c.version_detail_id = n.version_detail_id and c.fault_co
de_id = n.fault_code_id) where n.version_detail_id=:1 and n.lan_id=:2 o
rder by n.fault_code_id asc
35.7 26 1.37 0.1 37.6 1.2 95.1 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id
7.7 3 2.56 0.0 48.2 .2 15.9 fdjtrdaz8hpvg
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SE
L$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id,
dbid, instance_number, sample_id, sample_time , session_id, session_serial#, ses
sion_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matchi
5.0 60 0.08 0.0 43.9 3.7 11.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;
4.1 3,534 0.00 0.0 4.5 5.5 91.9 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)
3.3 236 0.01 0.0 5.3 .7 62.9 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
2.2 3,208 0.00 0.0 6.1 6.6 36.0 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)
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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: 367,489,468
-> Captured SQL account for 91.9% of Total
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ------ ------ -----------
2.04298E+08 4,806 42,508.9 55.6 198.8 93.4 .0 dx9uj64072d
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
29,465,698 18,949 1,555.0 8.0 190.3 76.2 .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
16,976,942 109 155,751.8 4.6 47,321.8 .4 98.3 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
12,912,070 6,451 2,001.6 3.5 95.1 80.1 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
10,708,610 5,275 2,030.1 2.9 81.9 81.1 .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
10,589,805 5,275 2,007.5 2.9 66.2 87.4 .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
4,172,577 2,735 1,525.6 1.1 17.9 53.4 .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
3,594,736 33,484 107.4 1.0 62.5 36.9 .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
3,363,965 1 3,363,965.0 0.9 437.5 7.9 .0 699fq02xtmf
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
3,363,920 1 3,363,920.0 0.9 37.4 90.4 .0 7hcv97jgzd6
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> %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: 7,845,258
-> Captured SQL account for 93.5% of Total
Physical Reads Elapsed
Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ---------- ------ ---------- ------ ------ -------------
4,121,807 109 37,814.7 52.5 47,321.8 .4 98.3 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
3,192,952 56 57,017.0 40.7 595.9 4.0 91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_
15,335 21 730.2 0.2 254.6 5.0 93.4 7c9aurkrt70vn
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
968 8 121.0 0.0 49.8 1.0 97.8 0j5z1mkgtqw4s
select n.*,c.FAULT_CODE_ID_BYNAME from df_fault_code_desc c join df_fault_code_n
ame_desc n on (c.version_detail_id = n.version_detail_id and c.fault_co
de_id = n.fault_code_id) where n.version_detail_id=:1 and n.lan_id=:2 o
rder by n.fault_code_id asc
218 26 8.4 0.0 37.6 1.2 95.1 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id
87 3,208 0.0 0.0 6.1 6.6 36.0 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)
61 3,534 0.0 0.0 4.5 5.5 91.9 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)
13 174 0.1 0.0 24.5 72.3 8.5 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
8 60 0.1 0.0 43.9 3.7 11.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;
7 5,076 0.0 0.0 1.4 11.0 41.1 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial
-------------------------------------------------------------
SQL ordered by Physical Reads (UnOptimized)DB/Inst: MYCAR/mycar Snaps: 9474-
-> 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: 236,503
-> Captured SQL account for 97.4% of Total
-> Total UnOptimized Read Requests: 236,503
-> Captured SQL account for 97.4% 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
----------- ----------- ---------- ------------ ------ ------ -------------
203,339 203,339 109 1,865.5 0.0 86.0 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
25,912 25,912 56 462.7 0.0 11.0 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_
1,065 1,065 21 50.7 0.0 0.5 7c9aurkrt70vn
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
60 60 26 2.3 0.0 0.0 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id
20 20 60 0.3 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;
10 10 174 0.1 0.0 0.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
7 7 5,076 0.0 0.0 0.0 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial
5 5 62,544 0.0 0.0 0.0 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
4 4 155 0.0 0.0 0.0 6mtnm8nm00gan
select * from DIAG_USER_SOFT_CENTER where SOFT_ID = :1 and SERIAL_NO = :2
1 1 1 1.0 0.0 0.0 ab5nygnt6v4m0
Module: w3wp.exe
update DF_DATA_STREAM_DESC set unified_id='00000180',update_time=to_date('2013-6
-24 16:21:21', 'yyyy-mm-dd HH24:MI:SS'),create_person='閭撳▉' where version_detai
l
_id in(select version_detail_id from diag_soft_version_detail where version_id i
n(select version_id from diag_soft_version_detail where version_detail_id in(35
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Executions: 493,608
-> Captured SQL account for 96.0% of Total
Elapsed
Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
147,140 147,142 1.0 12.5 32.8 .0 520mkxqpf15
select 1 from dual
62,544 62,372 1.0 17.1 16.2 2.8 5nggumnh49y
select * from SYS_PRODUCT where SERIAL_NO = :1
34,064 34,063 1.0 3.8 36.5 .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
33,484 116,019 3.5 62.5 36.9 .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
28,060 11,886 0.4 7.6 52.6 .0 5ky6k3fa3cu
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
18,949 592,040 31.2 190.3 76.2 .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
15,101 1,034 0.1 11.0 10.0 .0 9arur6gysf1
select t.*,'' as name from sys_product_ip_rule t where t.product_id = :1 and
(t.start_time is null or t.start_time<= sysdate) and (t.end_time is null or t.e
nd_time>sysdate )
15,098 15,026 1.0 8,439.3 64.4 .0 5spk48gcmhf
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)
14,067 14,041 1.0 38.7 13.1 .0 87hfb2vvgt6
select 1 from sys_area_country where 1=1 AND DOWNLOAD
_AREA_ID = (select distinct t1.download_area_id from sys_vender t1
join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.fili
ale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) jo
8,205 8,203 1.0 0.5 54.4 .0 1qp4my7430p
select * from DIAG_SOFT_VERSION where VERSION_ID = :1
8,179 8,179 1.0 0.5 56.7 .0 a6j566u48p8
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
8,109 0 0.0 0.7 46.4 .2 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
6,451 0 0.0 1.0 47.6 .6 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
6,451 22,311 3.5 95.1 80.1 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
5,275 20,318 3.9 81.9 81.1 .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_
SQL ordered by Executions DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Executions: 493,608
-> Captured SQL account for 96.0% of Total
Elapsed
Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
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
5,275 5,260 1.0 66.2 87.4 .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
5,076 5,076 1.0 1.4 11.0 41.1 c00br6fharc
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial
4,966 117,688 23.7 14.3 47.7 .0 2asdyf7j381
select s.*, l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.L
AN_ID where s.SOFT_ID=:1
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Parse Calls: 488,968
-> Captured SQL account for 96.6% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
147,141 147,140 30.09 520mkxqpf15q8
select 1 from dual
62,545 62,544 12.79 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
34,064 34,064 6.97 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
33,483 33,484 6.85 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
28,060 28,060 5.74 5ky6k3fa3cu3y
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
18,948 18,949 3.88 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
15,101 15,101 3.09 9arur6gysf1z0
select t.*,'' as name from sys_product_ip_rule t where t.product_id = :1 and
(t.start_time is null or t.start_time<= sysdate) and (t.end_time is null or t.e
nd_time>sysdate )
15,098 15,098 3.09 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)
14,067 14,067 2.88 87hfb2vvgt6tp
select 1 from sys_area_country where 1=1 AND DOWNLOAD
_AREA_ID = (select distinct t1.download_area_id from sys_vender t1
join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.fili
ale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) jo
8,205 8,205 1.68 1qp4my7430ph5
select * from DIAG_SOFT_VERSION where VERSION_ID = :1
8,179 8,179 1.67 a6j566u48p8nf
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1
8,109 8,109 1.66 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
6,451 6,451 1.32 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
6,451 6,451 1.32 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
5,275 5,275 1.08 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_
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Parse Calls: 488,968
-> Captured SQL account for 96.6% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
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
5,275 5,275 1.08 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
5,076 5,076 1.04 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial
4,966 4,966 1.02 2asdyf7j381tv
select s.*, l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.L
AN_ID where s.SOFT_ID=:1
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
1,920,331 1 0.14 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE
1,749,568 10 0.13 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
1,241,030 129 0.09 fsbqktj5vw6n9
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags,
16384), 0, a.next_run_date, a.last_enabled_time) next_run_date,
a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job s
ch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date,
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
107 1 5s34t44u10q4g
SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name a
s last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a,
wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor
_id(+) and a.last_exec_name = e.name(+) and a.id = :1
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
90 2 5rygsj4dbw6jt
insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, dr
op_segments) values (:1, :2, :3, :4, :5, :6, :7)
80 745 4m7m0t6fjcs5x
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
79 191 3c1kubcdjnppq
update sys.col_usage$ set equality_preds = equality_preds + decode(bitan
d(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag
,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0
,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1),
75 195 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
73 129 fsbqktj5vw6n9
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags,
16384), 0, a.next_run_date, a.last_enabled_time) next_run_date,
a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job s
ch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date,
72 147 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))
67 1 8p9z2ztb272bm
SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as
cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM
WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_numb
er = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status
67 6 fcb5u7n0r523m
SELECT NVL(AVG((VALUE*1000.0)/DURATION),0), NVL((((SUM(DURATION)/(60*1000))/60)*
100),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 =
B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.
IS_TOTAL='Y' AND A.DURATION > 0
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
67 6 fcb5u7n0r523m
SELECT NVL(AVG((VALUE*1000.0)/DURATION),0), NVL((((SUM(DURATION)/(60*1000))/60)*
100),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 =
B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.
IS_TOTAL='Y' AND A.DURATION > 0
66 36 94pxkbat2zku7
SELECT NVL(SUM(VALUE),0),COUNT(*) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE NAME =
:B1 || '_TOTAL_DELIVERY_TIME' AND TIME > (SYSDATE-(1/(24*6)))
65 236 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 10 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 23nad9x295gkf
SELECT (m.current_size / 1048576) as sizemb, case when cast(m.last
_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as chang
ed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT b
uffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DE
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 67 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
54 2 dcvnnc6bjqshc
SELECT TASK_ID, TASK_CLASS FROM MGMT_COLLECTION_TASKS C WHERE FREQUENCY_CODE !=
7 AND NOT EXISTS (SELECT 1 FROM MGMT_TASK_QTABLE Q WHERE Q.USER_DATA.TASK_ID = C
.TASK_ID) FOR UPDATE
53 5 8mvxss6cn9q8t
SELECT TASK_CLASS,COUNT(*) PENDING FROM MGMT_COLLECTION_TASKS WHERE NEXT_COLLECT
ION_TIMESTAMP <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND FREQUENCY_CODE != :B1 GROUP B
Y TASK_CLASS
53 236 gfdn12rn0fg3m
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :
B1
52 710 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 70 b2gnxm5z6r51n
lock table sys.col_usage$ in exclusive mode nowait
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
51 195 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
+ :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn
50 1 0ut2yw7mxf0aq
insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, be
gin_interval_time, end_interval_time, snap_level, status, error_count, bl_mov
ed, snap_flag) values (:snap_id, :dbid, :instance_number, :startup_time, :
begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1)
46 32 crwtm662ycm4w
select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 =
0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) o
r (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
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
41 1 7wwd9zjbvggmh
INSERT INTO SYS.WRI$_ADV_TASKS (ID,OWNER#,OWNER_NAME,NAME,DESCRIPTION,ADVISOR_ID
,ADVISOR_NAME, CTIME,MTIME,PARENT_ID,PARENT_REC_ID, PROPERTY,VERSION, EXEC_START
,EXEC_END,STATUS,STATUS_MSG_ID,PCT_COMPLETION_TIME, PROGRESS_METRIC,METRIC_UNITS
,ACTIVITY_COUNTER,REC_COUNT,ERROR_MSG#, SOURCE,HOW_CREATED ) VALUES (:B11 ,:B10
39 1 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE
39 1 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE
34 3,067 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 109 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
29 67 cumjq42201t37
select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv,
env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$
u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and
powner = u2.name and cowner = u3.name
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
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,
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
25 6 2rq8p9b3f1n82
SELECT COUNT(BROKEN) FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEV
ERITIES'
-------------------------------------------------------------
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
Batched IO (bound) vector count 43 0.0 0.0
Batched IO (full) vector count 0 0.0 0.0
Batched IO block miss count 129 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 86 0.0 0.0
Batched IO single block count 43 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 4 0.0 0.0
CCursor + sql area evicted 3 0.0 0.0
CPU used by this session 664,027 183.2 167.7
CPU used when call started 663,739 183.1 167.7
CR blocks created 302 0.1 0.1
Cached Commit SCN referenced 171 0.1 0.0
Commit SCN cached 76 0.0 0.0
DB time 6,296,463 1,737.3 1,590.4
DBWR checkpoint buffers written 3,825 1.1 1.0
DBWR checkpoints 47 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 306 0.1 0.1
DBWR thread checkpoint buffers w 0 0.0 0.0
DBWR transaction table writes 110 0.0 0.0
DBWR undo block writes 551 0.2 0.1
DFO trees parallelized 0 0.0 0.0
HSC Heap Segment Block Changes 11,489 3.2 2.9
HSC IDL Compressed Blocks 0 0.0 0.0
Heap Segment Array Inserts 122 0.0 0.0
Heap Segment Array Updates 101 0.0 0.0
IMU CR rollbacks 208 0.1 0.1
IMU Flushes 1,479 0.4 0.4
IMU Redo allocation size 3,375,896 931.5 852.7
IMU commits 2,539 0.7 0.6
IMU contention 75 0.0 0.0
IMU ktichg flush 0 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 0 0.0 0.0
IMU undo allocation size 7,980,112 2,201.9 2,015.7
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 30,455 8.4 7.7
PX local messages recv'd 0 0.0 0.0
PX local messages sent 0 0.0 0.0
Parallel operations not downgrad 0 0.0 0.0
RowCR - row contention 0 0.0 0.0
RowCR attempts 135 0.0 0.0
RowCR hits 135 0.0 0.0
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 1,253,422 345.8 316.6
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 838 0.2 0.2
application wait time 1,871 0.5 0.5
auto extends on undo tablespace 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 15,225 4.2 3.9
branch node splits 0 0.0 0.0
buffer is not pinned count 241,772,200 66,709.3 61,069.0
buffer is pinned count 1,277,472,545 352,477.6 322,675.6
bytes received via SQL*Net from 125,342,604 34,584.3 31,660.2
bytes sent via SQL*Net to client 505,510,828 139,479.5 127,686.5
calls to get snapshot scn: kcmgs 503,396 138.9 127.2
calls to kcmgas 6,403 1.8 1.6
calls to kcmgcs 937,861 258.8 236.9
cell physical IO interconnect by 98,530,077,184 27,186,215.7 24,887,617.4
change write time 251 0.1 0.1
cleanout - number of ktugct call 420 0.1 0.1
cleanouts and rollbacks - consis 141 0.0 0.0
cleanouts only - consistent read 15 0.0 0.0
cluster key scan block gets 2,247 0.6 0.6
cluster key scans 2,001 0.6 0.5
commit batch performed 0 0.0 0.0
commit batch requested 0 0.0 0.0
commit batch/immediate performed 1 0.0 0.0
commit batch/immediate requested 1 0.0 0.0
commit cleanout failures: block 0 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callba 7 0.0 0.0
commit cleanout failures: cannot 53 0.0 0.0
commit cleanouts 14,591 4.0 3.7
commit cleanouts successfully co 14,531 4.0 3.7
commit immediate performed 1 0.0 0.0
commit immediate requested 1 0.0 0.0
commit txn count during cleanout 839 0.2 0.2
concurrency wait time 12,774 3.5 3.2
consistent changes 1,716 0.5 0.4
consistent gets 367,416,142 101,376.7 92,805.3
consistent gets - examination 5,877,821 1,621.8 1,484.7
consistent gets direct 3,706,483 1,022.7 936.2
consistent gets from cache 363,709,677 100,354.0 91,869.1
consistent gets from cache (fast 345,361,764 95,291.5 87,234.6
cursor authentications 121 0.0 0.0
data blocks consistent reads - u 1,756 0.5 0.4
db block changes 55,393 15.3 14.0
db block gets 74,569 20.6 18.8
db block gets direct 243 0.1 0.1
db block gets from cache 74,326 20.5 18.8
db block gets from cache (fastpa 20,388 5.6 5.2
deferred (CURRENT) block cleanou 9,101 2.5 2.3
dirty buffers inspected 0 0.0 0.0
enqueue conversions 964 0.3 0.2
enqueue deadlocks 0 0.0 0.0
enqueue releases 84,412 23.3 21.3
enqueue requests 84,413 23.3 21.3
enqueue timeouts 0 0.0 0.0
enqueue waits 49 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 493,608 136.2 124.7
failed probes on index block rec 0 0.0 0.0
file io service time 0 0.0 0.0
file io wait time 220,351,278 60,798.9 55,658.3
free buffer inspected 3,297 0.9 0.8
free buffer requested 3,516 1.0 0.9
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
global undo segment hints helped 0 0.0 0.0
global undo segment hints were s 0 0.0 0.0
heap block compress 102 0.0 0.0
hot buffers moved to head of LRU 2,306 0.6 0.6
immediate (CR) block cleanout ap 156 0.0 0.0
immediate (CURRENT) block cleano 779 0.2 0.2
index crx upgrade (positioned) 41 0.0 0.0
index crx upgrade (prefetch) 0 0.0 0.0
index fast full scans (full) 808 0.2 0.2
index fetch by key 9,985,224 2,755.1 2,522.2
index scans kdiixs1 1,896,217 523.2 479.0
leaf node 90-10 splits 64 0.0 0.0
leaf node splits 73 0.0 0.0
lob reads 415 0.1 0.1
lob writes 64 0.0 0.0
lob writes unaligned 64 0.0 0.0
logons cumulative 266 0.1 0.1
max cf enq hold time 90 0.0 0.0
messages received 6,044 1.7 1.5
messages sent 6,044 1.7 1.5
min active SCN optimization appl 16 0.0 0.0
no buffer to keep pinned count 1,232 0.3 0.3
no work - consistent read gets 360,471,291 99,460.5 91,051.1
non-idle wait count 1,852,032 511.0 467.8
non-idle wait time 4,853,208 1,339.1 1,225.9
opened cursors cumulative 491,930 135.7 124.3
parse count (describe) 5 0.0 0.0
parse count (failures) 7 0.0 0.0
parse count (hard) 310 0.1 0.1
parse count (total) 488,968 134.9 123.5
parse time cpu 569 0.2 0.1
parse time elapsed 3,353 0.9 0.9
physical read IO requests 236,503 65.3 59.7
physical read bytes 64,268,353,536 17,732,791.6 16,233,481.6
physical read total IO requests 242,434 66.9 61.2
physical read total bytes 64,365,780,992 17,759,673.5 16,258,090.7
physical read total multi block 107,714 29.7 27.2
physical reads 7,845,258 2,164.7 1,981.6
physical reads cache 1,650 0.5 0.4
physical reads cache prefetch 3 0.0 0.0
physical reads direct 7,843,608 2,164.2 1,981.2
physical reads direct (lob) 364 0.1 0.1
physical reads direct temporary 4,137,125 1,141.5 1,045.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 207,382 57.2 52.4
physical write bytes 34,107,359,232 9,410,832.2 8,615,145.0
physical write total IO requests 214,460 59.2 54.2
physical write total bytes 34,164,296,192 9,426,542.1 8,629,526.7
physical write total multi block 79,416 21.9 20.1
physical writes 4,163,496 1,148.8 1,051.7
physical writes direct 4,159,671 1,147.7 1,050.7
physical writes direct (lob) 27 0.0 0.0
physical writes direct temporary 4,159,428 1,147.7 1,050.6
physical writes from cache 3,825 1.1 1.0
physical writes non checkpoint 4,161,385 1,148.2 1,051.1
pinned buffers inspected 2 0.0 0.0
pinned cursors current 2 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
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
prefetched blocks aged out befor 0 0.0 0.0
process last non-idle time 8,216 2.3 2.1
queries parallelized 0 0.0 0.0
recursive calls 275,471 76.0 69.6
recursive cpu usage 609 0.2 0.2
redo blocks checksummed by FG (e 16,375 4.5 4.1
redo blocks written 31,397 8.7 7.9
redo buffer allocation retries 0 0.0 0.0
redo entries 18,636 5.1 4.7
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 423 0.1 0.1
redo size 14,178,984 3,912.2 3,581.5
redo size for direct writes 1,999,448 551.7 505.0
redo subscn max counts 1,712 0.5 0.4
redo synch time 40,659 11.2 10.3
redo synch writes 4,093 1.1 1.0
redo wastage 1,289,668 355.8 325.8
redo write time 29,205 8.1 7.4
redo writes 4,582 1.3 1.2
rollback changes - undo records 4 0.0 0.0
rollbacks only - consistent read 182 0.1 0.1
root node splits 0 0.0 0.0
rows fetched via callback 3,698,420 1,020.5 934.2
scheduler wait time 0 0.0 0.0
session connect time 0 0.0 0.0
session cursor cache hits 475,792 131.3 120.2
session logical reads 367,489,468 101,396.9 92,823.8
shared hash latch upgrades - no 133,377 36.8 33.7
shared hash latch upgrades - wai 14 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 50,349 13.9 12.7
sorts (rows) 9,093,355 2,509.0 2,296.9
sql area evicted 242 0.1 0.1
sql area purged 7 0.0 0.0
summed dirty queue length 0 0.0 0.0
switch current to new buffer 344 0.1 0.1
table fetch by rowid 757,312,732 208,956.2 191,288.9
table fetch continued row 62,291 17.2 15.7
table scan blocks gotten 121,657,019 33,567.4 30,729.2
table scan rows gotten 6,223,471,539 1,717,167.4 1,571,980.7
table scans (direct read) 65 0.0 0.0
table scans (long tables) 1,021 0.3 0.3
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 264,575 73.0 66.8
temp space allocated (bytes) 0 0.0 0.0
total cf enq hold time 8,030 2.2 2.0
total number of cf enq holders 258 0.1 0.1
total number of times SMON poste 0 0.0 0.0
transaction rollbacks 1 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 3,183,416 878.4 804.1
user I/O wait time 4,743,916 1,308.9 1,198.3
user calls 1,726,509 476.4 436.1
user commits 3,959 1.1 1.0
user rollbacks 0 0.0 0.0
workarea executions - multipass 0 0.0 0.0
workarea executions - onepass 103 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
workarea executions - optimal 82,364 22.7 20.8
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 20 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: MYCAR/mycar Snaps: 9474-94
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session uga memory max 1.154093207E+12 1.157295137E+12
session pga memory 3.600896775E+11 3.602573602E+11
session pga memory max 4.081360879E+11 4.073745042E+11
session cursor cache count 10,559,128 10,564,952
session uga memory 6.344924197E+14 6.347887902E+14
opened cursors current 468 462
workarea memory allocated 46,530 50,517
logons current 97 102
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: MYCAR/mycar Snaps: 9474-947
-> 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: 9474-9475
-> '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 Reads 59.8G 64.8 16.9013 13M 0.0 .003586 234.8K 39.9
Direct Writes 15M 0.0 .004138 31.7G 56.6 8.96319 205.2K 184.1
Others 93M 1.6 .025660 39M 0.7 .010760 8439 28.5
DBWR 0M 0.0 0M 30M 0.6 .008277 899 114.4
LGWR 0M 0.0 0M 15M 1.3 .004138 4580 63.1
Buffer Cache Re 13M 0.5 .003586 0M 0.0 0M 1656 68.1
TOTAL: 59.9G 66.9 16.9347 31.8G 59.2 8.98995 455.6K 105.1
-------------------------------------------------------------
IOStat by Filetype summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> '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 31.6G 56.4 8.91794 31.7G 56.6 8.96622 38.5 50.5
Data File 28.3G 8.9 7.99085 33M 0.6 .009105 38.9 18.4
Control File 93M 1.6 .025660 39M 0.7 .010760 0.7 N/A
Log File 0M 0.0 0M 15M 1.3 .004138 N/A N/A
TOTAL: 59.9G 66.9 16.9344 31.8G 59.2 8.99023 36.9 41.8
-------------------------------------------------------------
IOStat by Function/Filetype summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> '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 Reads
59.8G 64.8 16.9013 13M 0.0 .003586 0 N/A
Direct Reads (Data File)
59.8G 64.8 16.9013 13M 0.0 .003586 0 N/A
Direct Writes
15M 0.0 .004138 31.7G 56.6 8.96319 0 N/A
Direct Writes (Data File)
15M 0.0 .004138 31.7G 56.6 8.96319 0 N/A
Others
94M 1.6 .025936 39M 0.7 .010760 5945 0.7
Others (Control File)
93M 1.6 .025660 39M 0.7 .010760 5922 0.7
Others (Data File)
1M 0.0 .000275 0M 0.0 0M 23 3.3
DBWR
0M 0.0 0M 30M 0.6 .008277 0 N/A
DBWR (Data File)
0M 0.0 0M 30M 0.6 .008277 0 N/A
LGWR
0M 0.0 0M 15M 1.3 .004138 0 N/A
LGWR (Log File)
0M 0.0 0M 15M 1.3 .004138 0 N/A
Buffer Cache Reads
13M 0.5 .003586 0M 0.0 0M 1658 68.0
Buffer Cache Reads (Data File)
13M 0.5 .003586 0M 0.0 0M 1658 68.0
TOTAL:
59.9G 66.9 16.9350 31.8G 59.2 8.98995 7603 15.4
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
204,386 56 0.0 20.2 205,140 57 0 0.0
MYCAR
31,998 9 3.3 115.9 1,208 0 2 10.0
SYSAUX
92 0 57.6 1.0 632 0 0 0.0
UNDOTBS1
0 0 0.0 .0 233 0 0 0.0
PASSPORT
15 0 71.3 1.0 81 0 0 0.0
SYSTEM
7 0 135.7 1.0 88 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
30,876 9 3.4 115.8 821 0 1 0.0
MYCAR /oracle/oradata/mycar/mycar01.dbf
1,122 0 0.8 118.3 387 0 1 20.0
PASSPORT /oracle/oradata/mycar/passport.dbf
15 0 71.3 1.0 81 0 0 0.0
SYSAUX /oracle/oradata/mycar/sysaux01.dbf
92 0 57.6 1.0 632 0 0 0.0
SYSTEM /oracle/oradata/mycar/system01.dbf
7 0 135.7 1.0 88 0 0 0.0
TEMP /oracle/oradata/mycar/temp01.dbf
204,386 56 0.0 20.2 205,140 57 0 N/A
UNDOTBS1 /oracle/oradata/mycar/undotbs01.dbf
0 0 N/A N/A 233 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 363,528,049 1,654 3,825 0 0 2
-------------------------------------------------------------
Checkpoint Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Physical Writes: 4,163,496
Other Autotune Thread
MTTR Log Size Log Ckpt Settings Ckpt Ckpt
Writes Writes Writes Writes Writes Writes
----------- ----------- ----------- ----------- ----------- -----------
0 0 0 0 3,519 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 375 1905 6265 995328 6265 N/A N/A N/A
E 0 14 453 5437 16514 995328 16514 N/A N/A N/A
-------------------------------------------------------------
MTTR Advisory DB/Inst: MYCAR/mycar Snap: 9475
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: MYCAR/mycar Snap: 9475
-> 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,772,028 1 1.0E+06
D 160 .2 20 1.0 1,583,528 1 4.4E+04
D 240 .3 30 1.0 1,560,506 1 2.5E+04
D 320 .4 39 1.0 1,556,001 1 2.1E+04
D 400 .5 49 1.0 1,555,363 1 2.0E+04
D 480 .6 59 1.0 1,554,952 1 2.0E+04
D 560 .7 69 1.0 1,554,666 1 2.0E+04
D 640 .8 79 1.0 1,554,382 1 2.0E+04
D 720 .9 89 1.0 1,554,144 1 1.9E+04
D 800 1.0 99 1.0 1,553,962 1 1.9E+04
D 880 1.1 108 1.0 1,553,798 1 1.9E+04
D 960 1.2 118 1.0 1,553,631 1 1.9E+04
D 1,040 1.3 128 1.0 1,553,521 1 1.9E+04
D 1,120 1.4 138 1.0 1,553,439 1 1.9E+04
D 1,200 1.5 148 1.0 1,553,376 1 1.9E+04
D 1,280 1.6 158 1.0 1,553,308 1 1.9E+04
D 1,360 1.7 167 1.0 1,552,563 1 1.8E+04
D 1,440 1.8 177 1.0 1,495,189 1 6983.0
D 1,520 1.9 187 1.0 1,482,199 1 6982.0
D 1,600 2.0 197 0.9 1,414,700 1 6976.0
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
--------------- ------------------ --------------------------
61.6 58,511 36,484
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 54,555 54,555 0 0
64K 128K 3,648 3,648 0 0
128K 256K 1,650 1,650 0 0
256K 512K 96 96 0 0
512K 1024K 18,393 18,393 0 0
1M 2M 3,893 3,893 0 0
2M 4M 56 56 0 0
4M 8M 21 21 0 0
16M 32M 62 46 16 0
32M 64M 2 1 1 0
64M 128M 2 2 0 0
128M 256M 11 0 11 0
256M 512M 50 0 50 0
512M 1024M 25 0 25 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: MYCAR/mycar Snap: 9475
-> 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 22,987,341.4 49,510,357.8 32.0 302,597 8.2E+10
284 0.3 22,987,341.4 49,348,616.7 32.0 298,460 8.2E+10
568 0.5 22,987,341.4 12,566,007.7 65.0 9 4.0E+10
852 0.8 22,987,341.4 12,274,213.5 65.0 0 4.0E+10
1,136 1.0 22,987,341.4 11,524,015.3 67.0 0 3.9E+10
1,363 1.2 22,987,341.4 11,372,520.8 67.0 0 3.9E+10
1,590 1.4 22,987,341.4 11,372,371.0 67.0 0 3.9E+10
1,818 1.6 22,987,341.4 11,372,260.0 67.0 0 3.9E+10
2,045 1.8 22,987,341.4 11,372,260.0 67.0 0 3.9E+10
2,272 2.0 22,987,341.4 11,372,260.0 67.0 0 3.9E+10
3,408 3.0 22,987,341.4 11,372,260.0 67.0 0 3.9E+10
4,544 4.0 22,987,341.4 11,372,100.4 67.0 0 3.9E+10
6,816 6.0 22,987,341.4 11,372,100.4 67.0 0 3.9E+10
9,088 8.0 22,987,341.4 11,372,100.4 67.0 0 3.9E+10
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: MYCAR/mycar Snap: 9475
-> 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 28 1,732 6.63E+06 1.0 2.1E+05 1.1 67,900
880 .7 157 8,762 6.64E+06 1.0 2.1E+05 1.1 308,223
1,008 .8 284 12,898 6.64E+06 1.0 2.0E+05 1.0 308,838
1,136 .9 412 17,243 6.65E+06 1.0 2.0E+05 1.0 309,091
1,264 1.0 540 21,902 6.65E+06 1.0 2.0E+05 1.0 309,294
1,392 1.1 668 26,454 6.65E+06 1.0 1.9E+05 1.0 309,475
1,520 1.2 796 31,027 6.65E+06 1.0 1.9E+05 1.0 309,591
1,648 1.3 924 34,524 6.65E+06 1.0 1.9E+05 1.0 309,639
1,776 1.4 1,052 38,341 6.65E+06 1.0 1.9E+05 1.0 309,671
1,904 1.5 1,180 41,674 6.65E+06 1.0 1.9E+05 1.0 309,688
2,032 1.6 1,308 45,353 6.65E+06 1.0 1.9E+05 1.0 309,701
2,160 1.7 1,436 49,359 6.65E+06 1.0 1.9E+05 1.0 309,709
2,288 1.8 1,564 52,835 6.65E+06 1.0 1.9E+05 1.0 309,717
2,416 1.9 1,692 56,036 6.65E+06 1.0 1.9E+05 1.0 309,724
2,544 2.0 1,820 59,892 6.65E+06 1.0 1.9E+05 1.0 309,731
-------------------------------------------------------------
SGA Target Advisory DB/Inst: MYCAR/mycar Snap: 9475
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
1,072 0.5 4,702,675 1,559,866,826
1,608 0.8 4,685,355 1,554,583,356
2,144 1.0 4,681,142 1,553,961,771
2,680 1.3 4,671,780 1,481,547,152
3,216 1.5 4,667,567 1,494,445,035
3,752 1.8 4,667,099 1,494,445,035
4,288 2.0 4,667,099 1,414,105,212
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: MYCAR/mycar Snap: 9475
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: 9475
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 2 0 10
-------------------------------------------------------------
Enqueue Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc
Enqueue Type (Request Reason)
------------------------------------------------------------------------------
Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
KO-Multiple Object Checkpoint (fast object checkpoint)
423 423 0 47 19 398.09
JD-Job Queue Date
777 777 0 1 1 940.00
TX-Transaction (index contention)
12 12 0 1 0 20.00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 .3 4,264 1,453 4 240/240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
24-Jun 16:50 78 945 1,453 3 240 0/0 0/0/0/0/0/0
24-Jun 16:40 84 1,011 1,003 4 240 0/0 0/0/0/0/0/0
24-Jun 16:30 66 1,327 399 4 240 0/0 0/0/0/0/0/0
24-Jun 16:20 31 531 1,000 2 240 0/0 0/0/0/0/0/0
24-Jun 16:10 20 450 1,260 2 240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> "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
ASM db client latch 2,428 0.0 0 0 N/A
ASM map operation hash t 1 0.0 0 0 N/A
ASM network state latch 65 0.0 0 0 N/A
AWR Alerted Metric Eleme 32,136 0.0 0 0 N/A
Change Notification Hash 1,199 0.0 0 0 N/A
Consistent RBA 4,582 0.0 0 0 N/A
DML lock allocation 26,428 0.0 0 0 N/A
Event Group Locks 198 0.0 0 0 N/A
FAL Queue 169 0.0 0 0 N/A
FOB s.o list latch 801 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 34,345 0.0 0.7 0 4,846 0.0
JS Sh mem access 7 0.0 0 0 N/A
JS mem alloc latch 5 0.0 0 0 N/A
JS queue access latch 6 0.0 0 0 N/A
JS queue state obj latch 25,774 0.0 0 0 N/A
JS slv state obj latch 1,226,146 0.4 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,204 0.0 0 0 N/A
KTF sga latch 21 0.0 0 910 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 74 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,204 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,411 0.0 0 0 N/A
OS process allocation 2,133 0.0 0 0 N/A
OS process: request allo 389 0.0 0 0 N/A
PL/SQL warning settings 452 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,329 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 2,403 1.3 1.0 1 1,167 0.0
SQL memory manager worka 397,435 0.0 0.0 0 0 N/A
Shared B-Tree 327 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: 9474-9475
-> "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 2,327 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 2,445 0.0 0 0 N/A
active service list 8,319 0.0 2.0 0 4,264 0.0
archive control 61 0.0 0 0 N/A
archive process latch 507 0.0 0 0 N/A
begin backup scn array 37 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 34,938 0.1 0.0 0 0 N/A
cache buffers chains 721,899,826 0.1 0.0 41 5,172 0.0
cache buffers lru chain 4,556 0.0 0 9,354,730 0.0
cache table scan latch 3 0.0 0 3 0.0
call allocation 1,181 0.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 470 0.0 0 0 N/A
channel operations paren 18,112 0.0 0 0 N/A
checkpoint queue latch 113,475 0.0 0 3,768 0.0
client/application info 2,032 0.0 0 0 N/A
compile environment latc 266 0.0 0 0 N/A
corrupted undo seg latch 13 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 65 0.0 0 0 N/A
cvmap freelist lock 1 0.0 0 0 N/A
deferred cleanup latch 65 0.0 0 0 N/A
dml lock allocation 65 0.0 0 0 N/A
done queue latch 1 0.0 0 0 N/A
dummy allocation 528 0.0 0 0 N/A
enqueue hash chains 169,906 0.0 0.1 0 9 0.0
enqueues 129,885 0.0 0.0 0 0 N/A
fifth spare latch 1 0.0 0 0 N/A
file cache latch 213 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 55 0.0 0 0 N/A
global tx hash mapping 1 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> "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 112 0.0 0 38,857 0.0
hash table modification 110 0.0 0 0 N/A
heartbeat check 1 0.0 0 0 N/A
internal temp table obje 3 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 70 0.0 0 69 1.4
job_queue_processes free 142 0.0 0 0 N/A
job_queue_processes para 841 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 1,736 0.0 0 0 N/A
kokc descriptor allocati 492 0.0 0 0 N/A
ksfv messages 1 0.0 0 0 N/A
kss move lock 39 0.0 0 0 N/A
ksuosstats global area 245 0.0 0 0 N/A
ksv allocation latch 141 0.0 0 0 N/A
ksv class latch 77 0.0 0 0 N/A
ksv msg queue latch 1 0.0 0 0 N/A
ksz_so allocation latch 389 0.0 0 0 N/A
ktm global data 22 0.0 0 0 N/A
kwqbsn:qsga 131 0.0 0 0 N/A
lgwr LWN SCN 5,334 0.0 0 0 N/A
list of block allocation 396 0.0 0 0 N/A
loader state object free 932 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 491 0.0 0 70 0.0
managed standby latch 169 0.0 0 0 N/A
mapped buffers lru chain 1 0.0 0 0 N/A
message pool operations 142 0.0 0 0 N/A
messages 48,234 0.0 0.0 0 0 N/A
mostly latch-free SCN 5,332 0.0 0 0 N/A
msg queue latch 1 0.0 0 0 N/A
multiblock read objects 28 0.0 0 0 N/A
name-service namespace b 1 0.0 0 0 N/A
ncodef allocation latch 65 0.0 0 0 N/A
object queue header heap 66 0.0 0 37 0.0
object queue header oper 26,175 0.0 0 0 N/A
object stats modificatio 7 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 328 0.0 0 0 N/A
parameter table manageme 529 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 8,682 0.0 0 6,533 0.0
process allocation 528 0.0 0 197 0.0
process group creation 389 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 902 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> "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 24,891 0.0 0.5 0 18,688 0.0
redo copy 1 0.0 0 18,688 0.1
redo writing 18,361 0.0 0 0 N/A
resmgr group change latc 463 0.0 0 0 N/A
resmgr:active threads 528 0.0 0 0 N/A
resmgr:actses change gro 147 0.0 0 0 N/A
resmgr:actses change sta 1 0.0 0 0 N/A
resmgr:free threads list 527 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 561,553 0.0 0.1 0 222 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 24,284 0.0 0 0 N/A
session allocation 431,079 0.0 0.0 0 143,696 0.0
session idle bit 3,595,832 0.0 0.0 0 0 N/A
session queue latch 1 0.0 0 0 N/A
session state list latch 588 0.0 0 0 N/A
session switching 1,026 0.0 0 0 N/A
session timer 1,359 0.0 0 0 N/A
shared pool 44,705 0.1 0.2 1 0 N/A
shared pool sim alloc 1 0.0 0 0 N/A
shared pool simulator 4,310 0.0 0 0 N/A
sim partition latch 1 0.0 0 0 N/A
simulator hash latch 28,462,939 0.0 0.1 4 0 N/A
simulator lru latch 2,800 0.1 0.3 0 27,319,003 0.3
sort extent pool 47,870 0.1 0.3 5 0 N/A
space background state o 4 0.0 0 0 N/A
space background task la 2,611 0.0 0 2,406 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 2 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 952 0.1 1.0 3 0 N/A
undo global data 25,666 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: 9474-9475
-> ordered by misses desc
Get Spin
Latch Name Requests Misses Sleeps Gets
-------------------------- --------------- ------------ ----------- -----------
cache buffers chains 721,899,826 910,124 854 909,346
JS slv state obj latch 1,226,146 4,392 4 0
simulator hash latch 28,462,939 716 80 638
session idle bit 3,595,832 259 7 252
row cache objects 561,553 81 8 73
SQL memory manager latch 2,403 31 31 2
shared pool 44,705 27 5 22
sort extent pool 47,870 24 8 16
enqueue hash chains 169,906 8 1 7
In memory undo latch 34,345 3 2 1
simulator lru latch 2,800 3 1 2
redo allocation 24,891 2 1 1
active service list 8,319 1 2 0
transaction allocation 952 1 1 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch ktiFlush: child 0 2 1
In memory undo latch kticmt: child 0 1 2
SQL memory manager latch qesmmIQueryRefreshBound 0 31 31
active service list kswsite: service iterator 0 2 2
cache buffers chains kcbgtcr: fast path (cr pin 0 604 285
cache buffers chains kcbrls_1 0 152 519
cache buffers chains kcbgtcr_2 0 80 31
cache buffers chains kcbrls_2 0 30 42
cache buffers chains kcbgtcr: fast path 0 15 19
cache buffers chains kcbgtcr: kslbegin excl 0 13 8
cache buffers chains kcbzgb: scan from tail. no 0 11 0
cache buffers chains kcbgcur_2 0 1 0
enqueue hash chains ksqgtl3 0 1 1
redo allocation kcrfw_redo_gen: redo alloc 0 1 0
row cache objects kqrpre: find obj 0 5 8
row cache objects kqreqd: reget 0 3 0
session idle bit ksupuc: set busy 0 4 5
session idle bit ksuxds 0 3 0
session idle bit ksupuc: clear busy 0 2 4
shared pool kghalo 0 4 3
shared pool kghupr1 0 1 1
simulator hash latch kcbs_lookup_setid: lookup 0 59 52
simulator hash latch kcbsacc: lookup dba 0 20 28
simulator hash latch kcbsacc: remove dba 0 1 0
simulator lru latch kcbs_lookup_setid 0 1 0
sort extent pool ktatobjstats 0 4 4
sort extent pool ktstaddextent1 0 4 4
transaction allocation ktcxbr 0 1 0
-------------------------------------------------------------
Mutex Sleep Summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> ordered by number of sleeps desc
Wait
Mutex Type Location Sleeps Time (ms)
--------------------- -------------------------------- ------------ ------------
Cursor Pin kksfbc [KKSCHLPIN1] 24,612 0
Cursor Stat kkocsStoreBindAwareStats [KKSSTA 2 0
Library Cache kglIsOwnerVersionable 121 1 1
Library Cache kglpndl1 95 1 49
Cursor Pin kksLockDelete [KKSCHLPIN6] 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Logical Reads: 367,489,468
-> 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 203,500,240 55.38
MYCAR MYCAR DIAG_SOFT_VERSION_DE TABLE 63,007,632 17.15
MYCAR MYCAR SYS_PRODUCT TABLE 37,915,104 10.32
MYCAR MYCAR DF_DATA_STREAM_NAME_ TABLE 28,527,744 7.76
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 9,691,360 2.64
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Physical Reads: 7,845,258
-> Captured Segments account for 47.2% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 3,706,179 47.24
MYCAR MYCAR DF_DATA_STREAM_NAME_ TABLE 89 .00
MYCAR MYCAR OPERATE_LOG TABLE 61 .00
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 31 .00
MYCAR MYCAR I_DF_STREAM_VERSION_ INDEX 27 .00
-------------------------------------------------------------
Segments by Physical Read Requests DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Physical Read Requests: 236,503
-> Captured Segments account for 12.9% of Total
Tablespace Subobject Obj. Phys Read
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 30,169 12.76
MYCAR MYCAR DF_DATA_STREAM_NAME_ TABLE 89 .04
MYCAR MYCAR OPERATE_LOG TABLE 61 .03
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 31 .01
MYCAR MYCAR I_DF_STREAM_VERSION_ INDEX 27 .01
-------------------------------------------------------------
Segments by UnOptimized Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total UnOptimized Read Requests: 236,503
-> Captured Segments account for 12.9% of Total
Tablespace Subobject Obj. UnOptimized
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 30,169 12.76
MYCAR MYCAR DF_DATA_STREAM_NAME_ TABLE 89 .04
MYCAR MYCAR OPERATE_LOG TABLE 61 .03
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 31 .01
MYCAR MYCAR I_DF_STREAM_VERSION_ INDEX 27 .01
-------------------------------------------------------------
Segments by Optimized Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Direct Physical Reads DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Direct Physical Reads: 7,843,608
-> Captured Segments account for 47.2% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 3,705,977 47.25
-------------------------------------------------------------
Segments by Physical Writes DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Physical Writes: 4,163,496
-> Captured Segments account for 0.1% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 1,133 .03
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 315 .01
SYS SYSAUX WRH$_ACTIVE_SESSION_ 81432_9469 TABLE 233 .01
MYCAR MYCAR SYS_PRODUCT TABLE 103 .00
SYS SYSAUX WRH$_ACTIVE_SESSION_ 81432_9469 INDEX 35 .00
-------------------------------------------------------------
Segments by Physical Write Requests DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Physical Write Requestss: 207,382
-> Captured Segments account for 0.6% of Total
Tablespace Subobject Obj. Phys Write
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 383 .18
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 293 .14
MYCAR MYCAR SYS_PRODUCT TABLE 96 .05
MYCAR MYCAR PK_DIAG_DOWNLOAD_REC INDEX 31 .01
SYS SYSAUX SYS_LOB0000006213C00 LOB 28 .01
-------------------------------------------------------------
Segments by Direct Physical Writes DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Direct Physical Writes: 4,159,671
-> Captured Segments account for 0.0% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSAUX WRH$_ACTIVE_SESSION_ 81432_9469 TABLE 216 .01
SYS SYSAUX SYS_LOB0000006213C00 LOB 27 .00
-------------------------------------------------------------
Segments by Table Scans DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> Total Table Scans: 1,829
-> Captured Segments account for 55.9% of Total
Tablespace Subobject Obj. Table
Owner Name Object Name Name Type Scans %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 958 52.38
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 65 3.55
-------------------------------------------------------------
Segments by DB Blocks Changes DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> % 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
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR OPERATE_LOG TABLE 3,088 37.19
MYCAR MYCAR SYS_PRODUCT_LANG_CON TABLE 1,600 19.27
MYCAR MYCAR PK_DIAG_DOWNLOAD_REC INDEX 576 6.94
SYS SYSAUX WRH$_SQL_PLAN TABLE 480 5.78
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 400 4.82
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> % 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_DOWNLOAD_REC INDEX 8 66.67
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 3 25.00
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 1 8.33
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR PK_DIAG_DOWNLOAD_REC INDEX 1 100.00
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> "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 69 0.0 0 N/A 2 1
dc_files 9 0.0 0 N/A 0 9
dc_global_oids 511 0.0 0 N/A 0 89
dc_histogram_data 16,216 0.0 0 N/A 0 3,623
dc_histogram_defs 8,438 0.3 0 N/A 0 5,857
dc_objects 11,686 0.1 0 N/A 5 3,612
dc_profiles 126 0.0 0 N/A 0 1
dc_rollback_segments 878 0.0 0 N/A 0 22
dc_segments 5,684 0.0 0 N/A 19 1,506
dc_sequences 745 0.1 0 N/A 745 42
dc_tablespaces 69,593 0.0 0 N/A 0 10
dc_users 81,493 0.0 0 N/A 0 169
global database name 2,539 0.0 0 N/A 0 2
outstanding_alerts 42 0.0 0 N/A 0 7
sch_lj_oids 5 0.0 0 N/A 0 37
-------------------------------------------------------------
Library Cache Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,286 0.0 1,657 0.0 0 0
DBLINK 115 0.0 0 N/A 0 0
EDITION 144 0.0 268 0.0 0 0
INDEX 15 0.0 15 0.0 0 0
QUEUE 66 0.0 215 0.0 0 0
SCHEMA 203 0.0 0 N/A 0 0
SQL AREA 14,823 4.8 501,288 0.2 45 7
SUBSCRIPTION 17 0.0 17 0.0 0 0
TABLE/PROCEDURE 6,866 0.2 36,164 0.1 15 0
TRIGGER 24 0.0 66 0.0 0 0
-------------------------------------------------------------
Memory Dynamic Components DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Memory Resize Ops DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Process Memory Summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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 385.0 N/A 3.9 8.0 28 32 99 99
Freeable 56.4 .0 1.0 .7 4 N/A 54 54
SQL 46.0 45.2 .6 4.5 39 133 77 71
PL/SQL 1.1 .8 .0 .0 0 0 97 97
E Other 389.4 N/A 3.7 7.8 28 33 104 104
SQL 49.5 48.7 .6 4.4 39 133 81 74
Freeable 44.6 .0 .9 .6 4 N/A 48 48
PL/SQL 1.1 .8 .0 .0 0 1 102 102
-------------------------------------------------------------
SGA Memory Summary DB/Inst: MYCAR/mycar Snaps: 9474-9475
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: 9474-9475
-> 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 84.6 85.3 0.83
shared FileOpenBlock 15.2 15.2 0.00
shared KGLHD 28.3 28.1 -0.88
shared PCUR 77.6 77.4 -0.35
shared SQLA 473.6 467.5 -1.30
shared free memory 359.3 368.1 2.46
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: 9474-9475
-> 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: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture Rate DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply Rate DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Persistent Queues DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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)
59 59 0.0 0.0 1.6 2.9 0.0 0.0
-------------------------------------------------------------
Persistent Queues Rate DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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.03 0.05
-------------------------------------------------------------
Persistent Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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: 9475
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Activity DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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: 9474-9475
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: 9474-9475
-> 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,626 0.0 100.0 0.0 0.0
-------------------------------------------------------------
Shared Servers Common Queue DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Dispatchers DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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,626 0.0 100.0 0 0
-------------------------------------------------------------
init.ora Parameters DB/Inst: MYCAR/mycar Snaps: 9474-9475
-> 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
workarea_size_policy AUTO
-------------------------------------------------------------
Dynamic Remastering Stats DB/Inst: MYCAR/mycar Snaps: 9474-9475
No data exists for this section of the report.
-------------------------------------------------------------
End of Report
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22126868/viewspace-764723/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22126868/viewspace-764723/