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: 9670 02-Jul-13 16:00:36 105 3.4
End Snap: 9671 02-Jul-13 16:53:02 101 3.7
Elapsed: 52.44 (mins)
DB Time: 865.38 (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.5 22.4 0.08 0.03
DB CPU(s): 3.0 4.0 0.01 0.01
Redo size: 3,781.4 5,125.8
Logical reads: 27,011.7 36,615.5
Block changes: 93.2 126.4
Physical reads: 825.5 1,119.0
Physical writes: 1.6 2.1
User calls: 578.0 783.5
Parses: 159.7 216.5
Hard parses: 0.1 0.1
W/A MB processed: 3.4 4.6
Logons: 0.1 0.2
Executes: 203.8 276.3
Rollbacks: 0.0 0.0
Transactions: 0.7
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.90 Soft Parse %: 99.95
Execute to Parse %: 21.66 Latch Hit %: 99.81
Parse CPU to Parse Elapsd %: 10.71 % Non-Parse CPU: 99.94
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 74.62 74.07
% SQL with executions>1: 94.26 92.40
% Memory for SQL w/exec>1: 90.67 89.24
Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
DB CPU 9,329 18.0
log file sync 2,640 803 304 1.5 Commit
db file sequential read 2,828 393 139 .8 User I/O
latch: cache buffers chains 314 244 776 .5 Concurrenc
library cache: mutex X 16 78 4882 .2 Concurrenc
Host CPU (CPUs: 4 Cores: 4 Sockets: 4)
~~~~~~~~ Load Average
Begin End %User %System %WIO %Idle
--------- --------- --------- --------- --------- ---------
1.05 1.25 52.5 21.7 0.1 25.7
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 74.2
% 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): 450.4 452.2
% Host Mem used for SGA+PGA: 31.67 31.69
Time Model Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total time in database user-calls (DB Time): 51923s
-> 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 47,429.8 91.3
PL/SQL execution elapsed time 24,425.3 47.0
DB CPU 9,329.3 18.0
connection management call elapsed time 121.5 .2
parse time elapsed 83.7 .2
hard parse elapsed time 7.1 .0
PL/SQL compilation elapsed time 4.1 .0
sequence load elapsed time 0.2 .0
hard parse (sharing criteria) elapsed time 0.2 .0
repeated bind elapsed time 0.0 .0
hard parse (bind mismatch) elapsed time 0.0 .0
DB time 51,923.0
background elapsed time 1,442.8
background cpu time 1.6
-------------------------------------------------------------
Operating System Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> *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 934,547
IDLE_TIME 323,815
IOWAIT_TIME 984
NICE_TIME 0
SYS_TIME 272,553
USER_TIME 661,222
LOAD 1 1
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: 9670-9671
Snap Time Load %busy %user %sys %idle %iowait
--------------- -------- -------- -------- -------- -------- --------
02-Jul 16:00:36 1.0 N/A N/A N/A N/A N/A
02-Jul 16:53:02 1.3 74.3 52.5 21.7 25.7 0.1
-------------------------------------------------------------
Foreground Wait Class DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 21.2% of Total DB time 51,923.04 (s)
-> Total FG Wait Time: 1,657.98 (s) DB CPU time: 9,329.27 (s)
Avg
%Time Total Wait wait
Wait Class Waits -outs Time (s) (ms) %DB time
-------------------- ---------------- ----- ---------------- -------- ---------
DB CPU 9,329 18.0
Commit 2,640 0 803 304 1.5
User I/O 24,941 0 473 19 0.9
Concurrency 360 1 336 933 0.6
Network 1,398,367 0 26 0 0.1
Application 33 0 10 297 0.0
Other 72,312 100 9 0 0.0
System I/O 84 0 1 15 0.0
-------------------------------------------------------------
Foreground Wait Events DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
-------------------------- ------------ ----- ---------- ------- -------- ------
log file sync 2,640 0 803 304 1.1 1.5
db file sequential read 2,828 0 393 139 1.2 .8
latch: cache buffers chain 314 0 244 776 0.1 .5
library cache: mutex X 16 0 78 4882 0.0 .2
direct path read 21,314 0 65 3 9.2 .1
SQL*Net message to client 1,330,590 0 25 0 573.3 .0
direct path sync 2 0 13 6579 0.0 .0
cursor: pin S 10 0 11 1055 0.0 .0
enq: KO - fast object chec 27 0 9 341 0.0 .0
asynch descriptor resize 72,283 100 6 0 31.1 .0
cursor: mutex S 2 100 3 1559 0.0 .0
latch free 9 0 2 189 0.0 .0
SQL*Net more data to clien 62,770 0 2 0 27.0 .0
read by other session 3 0 2 536 0.0 .0
control file sequential re 84 0 1 15 0.0 .0
reliable message 20 0 1 48 0.0 .0
SQL*Net break/reset to cli 6 0 1 95 0.0 .0
Disk file operations I/O 790 0 0 0 0.3 .0
latch: shared pool 11 0 0 14 0.0 .0
SQL*Net more data from cli 5,007 0 0 0 2.2 .0
db file scattered read 2 0 0 6 0.0 .0
SQL*Net message from clien 1,330,588 0 99,801 75 573.3
jobq slave wait 6,155 100 3,110 505 2.7
-------------------------------------------------------------
Background Wait Events DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 6,180 0 417 68 2.7 28.9
control file parallel writ 1,019 0 301 295 0.4 20.8
os thread startup 117 0 257 2196 0.1 17.8
db file async I/O submit 1,024 0 255 249 0.4 17.7
enq: PR - contention 5 0 74 14881 0.0 5.2
direct path sync 2 0 42 20929 0.0 2.9
ADR block file read 13 0 26 2011 0.0 1.8
control file sequential re 4,920 0 12 3 2.1 .9
log file sync 4 0 11 2814 0.0 .8
LGWR wait for redo copy 1 0 3 2730 0.0 .2
direct path write 14 0 2 128 0.0 .1
latch: shared pool 5 0 0 43 0.0 .0
db file sequential read 107 0 0 1 0.0 .0
Disk file operations I/O 76 0 0 0 0.0 .0
ADR block file write 5 0 0 4 0.0 .0
asynch descriptor resize 457 100 0 0 0.2 .0
SQL*Net message to client 1,082 0 0 0 0.5 .0
latch free 5 0 0 0 0.0 .0
rdbms ipc message 16,258 79 66,977 4120 7.0
DIAG idle wait 6,248 100 6,289 1007 2.7
Space Manager: slave idle 537 99 3,738 6961 0.2
smon timer 11 100 3,300 300026 0.0
shared server idle wait 105 100 3,152 30024 0.0
pmon timer 1,153 88 3,146 2728 0.5
Streams AQ: qmn slave idle 222 0 3,138 14137 0.1
Streams AQ: qmn coordinato 335 33 3,138 9368 0.1
dispatcher timer 52 100 3,121 60013 0.0
SQL*Net message from clien 1,358 0 95 70 0.6
class slave wait 16 0 31 1961 0.0
-------------------------------------------------------------
Wait Event Histogram DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
-> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
-> Ordered by Event (idle events last)
% of Waits
-----------------------------------------------
Total
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
ADR block file read 13 38.5 7.7 15.4 23.1 15.4
ADR block file write 5 60.0 20.0 20.0
ADR file lock 6 100.0
Disk file operations I/O 866 99.5 .5
LGWR wait for redo copy 1 100.0
SQL*Net break/reset to cli 6 66.7 16.7 16.7
SQL*Net message to client 1331. 100.0 .0 .0 .0 .0 .0
SQL*Net more data from cli 5008 100.0
SQL*Net more data to clien 62.8K 100.0 .0 .0 .0
asynch descriptor resize 72.8K 100.0 .0
control file parallel writ 1019 48.5 2.4 .5 .7 1.5 1.8 36.1 8.6
control file sequential re 5004 99.9 .1 .1
cursor: mutex S 2 50.0 50.0
cursor: pin S 10 10.0 70.0 10.0 10.0
db file async I/O submit 1024 40.5 14.8 7.6 .7 1.7 1.8 25.2 7.7
db file scattered read 2 50.0 50.0
db file sequential read 2930 79.4 .9 1.8 4.7 5.4 .9 4.6 2.5
direct path read 21.3K 99.3 .3 .0 .0 .1 .0 .2 .0
direct path sync 4 25.0 75.0
direct path write 15 93.3 6.7
direct path write temp 1 100.0
enq: KO - fast object chec 27 7.4 11.1 33.3 7.4 3.7 22.2 14.8
enq: PR - contention 5 20.0 20.0 60.0
latch free 14 64.3 7.1 28.6
latch: cache buffers chain 314 29.9 1.0 .6 3.8 4.1 38.9 21.7
latch: call allocation 6 100.0
latch: row cache objects 7 100.0
latch: shared pool 16 68.8 6.3 12.5 12.5
library cache: mutex X 16 12.5 12.5 12.5 18.8 43.8
log file parallel write 6182 81.4 .7 .5 .4 1.0 .9 13.7 1.4
log file sync 2643 54.2 1.5 .9 1.0 2.4 2.2 29.7 8.2
os thread startup 117 43.6 28.2 28.2
read by other session 3 33.3 66.7
reliable message 20 70.0 5.0 5.0 20.0
DIAG idle wait 6250 94.8 5.2
SQL*Net message from clien 1332K 91.2 2.4 .7 .5 1.4 .4 2.9 .5
Space Manager: slave idle 537 .6 .2 99.3
Streams AQ: qmn coordinato 335 64.8 .3 .3 1.2 33.4
Streams AQ: qmn slave idle 222 49.5 50.5
class slave wait 16 68.8 6.3 25.0
dispatcher timer 52 100.0
jobq slave wait 6155 .1 .0 .0 99.9 .0
pmon timer 1153 3.9 .3 .6 .6 .4 2.7 91.4
rdbms ipc message 16.3K 3.6 .3 1.2 .9 2.7 .7 28.7 61.9
shared server idle wait 105 100.0
smon timer 11 100.0
-------------------------------------------------------------
Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: MYCAR/mycar Snaps: 96
-> 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
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
ADR block file read 3 61.5 7.7 7.7 7.7 15.4
SQL*Net break/reset to cli 1 83.3 16.7
SQL*Net message to client 7 100.0 .0 .0 .0 .0
SQL*Net more data to clien 1 100.0 .0
asynch descriptor resize 1 100.0 .0 .0
control file parallel writ 447 55.3 2.1 6.4 8.2 9.0 10.4 7.8 .9
control file sequential re 4 99.9 .0 .0 .0 .0
cursor: pin S 1 80.0 10.0 10.0
db file async I/O submit 316 67.1 1.8 4.7 6.1 6.5 6.2 5.7 2.1
db file sequential read 154 93.0 .6 1.0 1.0 1.1 .8 .7 1.8
direct path read 39 99.8 .0 .0 .0 .1 .0 .0 .0
direct path write 1 93.3 6.7
enq: KO - fast object chec 9 63.0 3.7 7.4 3.7 7.4 11.1 3.7
enq: PR - contention 1 20.0 20.0 60.0
latch free 4 71.4 7.1 7.1 14.3
latch: cache buffers chain 151 39.5 2.9 4.5 8.3 13.1 10.2 9.2 12.4
latch: shared pool 2 87.5 12.5
library cache: mutex X 4 37.5 6.3 6.3 6.3 6.3 37.5
log file parallel write 928 84.9 1.1 3.0 3.2 3.3 3.2 1.3 .1
log file sync 940 62.1 3.2 6.4 6.4 6.6 7.2 5.9 2.3
os thread startup 39 43.6 13.7 6.8 3.4 .9 3.4 5.1 23.1
read by other session 2 33.3 66.7
reliable message 4 80.0 5.0 5.0 10.0
-------------------------------------------------------------
Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: MYCAR/mycar Snaps: 9670
-> 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
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
ADR block file read 2 84.6 15.4
LGWR wait for redo copy 1 100.0
SQL*Net message to client 3 100.0 .0 .0
asynch descriptor resize 1 100.0 .0
control file parallel writ 9 99.1 .6 .2 .1
control file sequential re 2 100.0 .0 .0
cursor: mutex S 1 50.0 50.0
cursor: pin S 1 90.0 10.0
db file async I/O submit 21 97.9 1.8 .2 .1
db file sequential read 52 98.2 .7 .6 .4
direct path read 5 100.0 .0 .0 .0
direct path sync 3 25.0 25.0 25.0 25.0
enq: KO - fast object chec 1 96.3 3.7
enq: PR - contention 3 40.0 20.0 20.0 20.0
latch: cache buffers chain 39 87.6 8.3 3.8 .3
library cache: mutex X 6 62.5 12.5 18.8 6.3
log file parallel write 8 99.9 .1 .0
log file sync 61 97.7 1.4 .5 .3 .1
os thread startup 27 76.9 4.3 12.0 5.1 .9 .9
-------------------------------------------------------------
Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: MYCAR/mycar Snaps: 9670-
No data exists for this section of the report.
-------------------------------------------------------------
Service Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K)
---------------------------- ------------ ------------ ------------ ------------
SYS$USERS 51,902 9,308 2,042 84,399
mycar 21 21 555 567
SYS$BACKGROUND 0 0 0 19
mycarXDB 0 0 0 0
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
20575 472 360 336 0 0 1398026 26
mycar
4365 1 0 0 0 0 433 0
SYS$BACKGROUND
203 44 117 257 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 90.9% of Total DB Time (s): 51,923
-> Captured PL/SQL account for 1.8% of Total DB Time (s): 51,923
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
45,134.3 7,242 6.23 86.9 19.2 .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)
871.3 133 6.55 1.7 11.5 35.2 c03tktb0r7cxt
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
499.4 66,855 0.01 1.0 17.8 .0 8r73w38v6xb5a
SELECT COUNT(*) FROM USER_ORDER UO,ORDER_DETAIL_INFO OD WHERE UO.ORDER_ID = OD.O
RDER_ID AND OD.SOFT_ID = :B2 AND UO.USER_ID = :B1 AND UO.ORDER_STATUS IN (1,3)
278.2 302 0.92 .5 .0 99.9 8f0zuannunkpx
INSERT INTO DIAG_USER_SOFT_CENTER(USER_SOFT_ID,SOFT_ID,USER_ID,SOFT_TYPE,FREE_ST
ART_TIME,FREE_END_TIME,CREATE_TIME,UPDATE_TIME,SERIAL_NO,SOFT_CONF_ID) VALUES(SE
Q_DIAG_USER_SOFT_CENTER.NEXTVAL,:B6 ,:B5 ,1,:B4 ,ADD_MONTHS(:B4 ,:B3 ),SYSDATE,S
YSDATE,:B2 ,:B1 )
189.2 5,638 0.03 .4 37.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
146.7 6,450 0.02 .3 58.1 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
118.0 5,638 0.02 .2 52.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
79.1 5,424 0.01 .2 2.3 .0 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
57.9 53 1.09 .1 73.3 .0 4040jw7rmjbqj
select cbi.* FROM diag_soft ds,car_base_info cbi where ds.soft_name in (select d
sxn.auto_code from user_carbaseinfo uc,diag_soft_x431_name dsxn where uc
.serial_no=:1 and uc.auto_id=cbi.car_brand_id and uc.diag_entrance_id = cbi.diag
_entrance_id and dsxn.auto_id=cbi.car_brand_id) AND DS.PDT_TYPE_ID=:2
53.4 50 1.07 .1 3.0 80.3 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;
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 98.4% of Total CPU Time (s): 9,329
-> Captured PL/SQL account for 1.1% of Total CPU Time (s): 9,329
CPU CPU per Elapsed
Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
8,647.6 7,242 1.19 92.7 45,134.3 19.2 .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)
100.1 133 0.75 1.1 871.3 11.5 35.2 c03tktb0r7cxt
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
88.9 66,855 0.00 1.0 499.4 17.8 .0 8r73w38v6xb5a
SELECT COUNT(*) FROM USER_ORDER UO,ORDER_DETAIL_INFO OD WHERE UO.ORDER_ID = OD.O
RDER_ID AND OD.SOFT_ID = :B2 AND UO.USER_ID = :B1 AND UO.ORDER_STATUS IN (1,3)
85.3 6,450 0.01 0.9 146.7 58.1 .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
70.1 5,638 0.01 0.8 189.2 37.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
61.8 5,638 0.01 0.7 118.0 52.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
42.4 53 0.80 0.5 57.9 73.3 .0 4040jw7rmjbqj
select cbi.* FROM diag_soft ds,car_base_info cbi where ds.soft_name in (select d
sxn.auto_code from user_carbaseinfo uc,diag_soft_x431_name dsxn where uc
.serial_no=:1 and uc.auto_id=cbi.car_brand_id and uc.diag_entrance_id = cbi.diag
_entrance_id and dsxn.auto_id=cbi.car_brand_id) AND DS.PDT_TYPE_ID=:2
21.9 203 0.11 0.2 49.9 43.9 .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
16.7 203 0.08 0.2 36.8 45.4 .0 6zzzr28dtrtpd
select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, deco
de(sd.SOFT_NAME, null,s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK,
null,s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) ve
rsion_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv
16.5 203 0.08 0.2 30.2 54.8 .0 1dv841hap05xc
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
AND sd.LAN_ID = :1
-------------------------------------------------------------
SQL ordered by User I/O Wait Time DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 82.5% of Total User I/O Wait Time (s):
-> Captured PL/SQL account for 67.5% 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
---------- ------------ ---------- ------ ---------- ------ ------ -------------
306.4 133 2.30 59.2 871.3 11.5 35.2 c03tktb0r7cxt
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
278.0 302 0.92 53.7 278.2 .0 99.9 8f0zuannunkpx
INSERT INTO DIAG_USER_SOFT_CENTER(USER_SOFT_ID,SOFT_ID,USER_ID,SOFT_TYPE,FREE_ST
ART_TIME,FREE_END_TIME,CREATE_TIME,UPDATE_TIME,SERIAL_NO,SOFT_CONF_ID) VALUES(SE
Q_DIAG_USER_SOFT_CENTER.NEXTVAL,:B6 ,:B5 ,1,:B4 ,ADD_MONTHS(:B4 ,:B3 ),SYSDATE,S
YSDATE,:B2 ,:B1 )
43.7 3 14.55 8.4 45.3 .2 96.4 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
42.9 50 0.86 8.3 53.4 3.0 80.3 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;
26.7 1 26.66 5.2 40.2 .7 66.4 2krxtvn08xjcs
Module: sqlplus@vm192168000035 (TNS V1-V3)
select output from table(dbms_workload_repository.awr_sql_report_text( :dbid,
:inst_num,
:bid, :eid,
:sqlid,
25.8 66,855 0.00 5.0 40.4 4.9 63.9 2d309vzfg4w3p
SELECT COUNT(*) FROM DIAG_USER_SOFT_CENTER D WHERE D.SOFT_ID = :B2 AND D.SERIAL_
NO = :B1
23.9 21 1.14 4.6 50.8 20.5 47.1 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_
11.5 1 11.51 2.2 17.6 6.5 65.4 7yyd1h8humc00
Module: SQL*Plus
select log_type from operate_log where operate_date between sysdate - 4 and sysd
ate -3
5.0 1,734 0.00 1.0 5.2 1.8 95.8 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
4.4 1 4.43 0.9 32.4 15.8 13.7 572fbaj0fdw2b
Module: sqlplus@vm192168000035 (TNS V1-V3)
select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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: 84,984,651
-> Captured SQL account for 94.8% of Total
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ------ ------ -----------
17,117,041 133 128,699.6 20.1 871.3 11.5 35.2 c03tktb0r7c
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
16,580,041 66,855 248.0 19.5 499.4 17.8 .0 8r73w38v6xb
SELECT COUNT(*) FROM USER_ORDER UO,ORDER_DETAIL_INFO OD WHERE UO.ORDER_ID = OD.O
RDER_ID AND OD.SOFT_ID = :B2 AND UO.USER_ID = :B1 AND UO.ORDER_STATUS IN (1,3)
12,983,194 6,450 2,012.9 15.3 146.7 58.1 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
11,403,122 5,638 2,022.5 13.4 189.2 37.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
11,344,925 5,638 2,012.2 13.3 118.0 52.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
6,876,325 7,242 949.5 8.1 45,134.3 19.2 .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)
2,262,940 203 11,147.5 2.7 30.2 54.8 .0 1dv841hap05
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
2,262,738 203 11,146.5 2.7 36.8 45.4 .0 6zzzr28dtrt
select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, deco
de(sd.SOFT_NAME, null,s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK,
null,s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) ve
rsion_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv
2,257,073 203 11,118.6 2.7 49.9 43.9 .0 89nfp8fv1y8
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
1,767,771 159 11,118.1 2.1 23.4 54.5 .0 6u4dt8af4b0
select * from ( select us.FREE_END_TIME, vv.version_no MAX_VERSION_No, s.*, deco
de(sd.SOFT_NAME, null,s.SOFT_NAME, sd.SOFT_NAME) as softDesc, decode(sd.REMARK,
null,s.REMARK, sd.REMARK) as remarkDesc from (select max(version_no) ve
rsion_no, soft_id from DIAG_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv
1,539,023 26 59,193.2 1.8 12.2 63.5 .0 7c9aurkrt70
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID
1,304,585 21 62,123.1 1.5 50.8 20.5 47.1 asdsn1yqzjk
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
SQL ordered by Gets DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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: 84,984,651
-> Captured SQL account for 94.8% of Total
Buffer Gets Elapsed
Gets Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ------------ ------ ---------- ------ ------ -----------
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,108,224 547 2,026.0 1.3 11.2 69.8 .0 4b3gtr71xwc
select t.* from sys_product t left join diag_soft s on s.pdt_type_id = t.pdt_typ
e_id left join diag_soft_version d on s.soft_id = d.soft_id left join
diag_soft_version_detail dd on dd.version_id = d.version_id left join sys_user
su on su.user_id = t.user_id where dd.version_detail_id = :1 and t.p
926,302 1 926,302.0 1.1 32.4 15.8 13.7 572fbaj0fdw
Module: sqlplus@vm192168000035 (TNS V1-V3)
select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> %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: 2,597,099
-> Captured SQL account for 82.3% of Total
Physical Reads Elapsed
Reads Executions per Exec %Total Time (s) %CPU %IO SQL Id
----------- ----------- ---------- ------ ---------- ------ ------ -------------
1,304,457 21 62,117.0 50.2 50.8 20.5 47.1 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_
277,362 1 277,362.0 10.7 10.4 100.0 6.0 d735zszm8pp8h
Module: PL/SQL Developer
select * from operate_log t where t.operate_desc like '%965290004055%' order by
t.log_id asc
277,362 1 277,362.0 10.7 10.6 98.9 6.2 du1mx6rq8qz0v
Module: PL/SQL Developer
select * from operate_log t where t.operate_desc like '%965290004055%'
277,314 1 277,314.0 10.7 17.6 6.5 65.4 7yyd1h8humc00
Module: SQL*Plus
select log_type from operate_log where operate_date between sysdate - 4 and sysd
ate -3
651 133 4.9 0.0 871.3 11.5 35.2 c03tktb0r7cxt
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
367 66,855 0.0 0.0 40.4 4.9 63.9 2d309vzfg4w3p
SELECT COUNT(*) FROM DIAG_USER_SOFT_CENTER D WHERE D.SOFT_ID = :B2 AND D.SERIAL_
NO = :B1
277 302 0.9 0.0 278.2 .0 99.9 8f0zuannunkpx
INSERT INTO DIAG_USER_SOFT_CENTER(USER_SOFT_ID,SOFT_ID,USER_ID,SOFT_TYPE,FREE_ST
ART_TIME,FREE_END_TIME,CREATE_TIME,UPDATE_TIME,SERIAL_NO,SOFT_CONF_ID) VALUES(SE
Q_DIAG_USER_SOFT_CENTER.NEXTVAL,:B6 ,:B5 ,1,:B4 ,ADD_MONTHS(:B4 ,:B3 ),SYSDATE,S
YSDATE,:B2 ,:B1 )
115 1 115.0 0.0 32.4 15.8 13.7 572fbaj0fdw2b
Module: sqlplus@vm192168000035 (TNS V1-V3)
select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
29 1,734 0.0 0.0 5.2 1.8 95.8 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc
14 86 0.2 0.0 24.8 3.9 6.9 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
-------------------------------------------------------------
SQL ordered by Physical Reads (UnOptimized)DB/Inst: MYCAR/mycar Snaps: 9670-
-> 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: 24,237
-> Captured SQL account for 30.5% of Total
-> Total UnOptimized Read Requests: 24,237
-> Captured SQL account for 30.5% 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
----------- ----------- ---------- ------------ ------ ------ -------------
2,182 2,182 1 2,182.0 0.0 9.0 7yyd1h8humc00
Module: SQL*Plus
select log_type from operate_log where operate_date between sysdate - 4 and sysd
ate -3
2,180 2,180 1 2,180.0 0.0 9.0 d735zszm8pp8h
Module: PL/SQL Developer
select * from operate_log t where t.operate_desc like '%965290004055%' order by
t.log_id asc
2,180 2,180 1 2,180.0 0.0 9.0 du1mx6rq8qz0v
Module: PL/SQL Developer
select * from operate_log t where t.operate_desc like '%965290004055%'
651 651 133 4.9 0.0 2.7 c03tktb0r7cxt
BEGIN addsoftconfrefsoft(:1,:2,:3); END;
367 367 66,855 0.0 0.0 1.5 2d309vzfg4w3p
SELECT COUNT(*) FROM DIAG_USER_SOFT_CENTER D WHERE D.SOFT_ID = :B2 AND D.SERIAL_
NO = :B1
277 277 302 0.9 0.0 1.1 8f0zuannunkpx
INSERT INTO DIAG_USER_SOFT_CENTER(USER_SOFT_ID,SOFT_ID,USER_ID,SOFT_TYPE,FREE_ST
ART_TIME,FREE_END_TIME,CREATE_TIME,UPDATE_TIME,SERIAL_NO,SOFT_CONF_ID) VALUES(SE
Q_DIAG_USER_SOFT_CENTER.NEXTVAL,:B6 ,:B5 ,1,:B4 ,ADD_MONTHS(:B4 ,:B3 ),SYSDATE,S
YSDATE,:B2 ,:B1 )
115 115 1 115.0 0.0 0.5 572fbaj0fdw2b
Module: sqlplus@vm192168000035 (TNS V1-V3)
select output from table(dbms_workload_repository.awr_report_html( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
65 65 10 6.5 0.0 0.3 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
24 24 50 0.5 0.0 0.1 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;
14 14 86 0.2 0.0 0.1 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
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Executions: 641,287
-> Captured SQL account for 95.4% of Total
Elapsed
Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
148,680 148,680 1.0 12.3 31.3 .0 520mkxqpf15
select 1 from dual
66,855 66,855 1.0 40.4 4.9 63.9 2d309vzfg4w
SELECT COUNT(*) FROM DIAG_USER_SOFT_CENTER D WHERE D.SOFT_ID = :B2 AND D.SERIAL_
NO = :B1
66,855 66,855 1.0 499.4 17.8 .0 8r73w38v6xb
SELECT COUNT(*) FROM USER_ORDER UO,ORDER_DETAIL_INFO OD WHERE UO.ORDER_ID = OD.O
RDER_ID AND OD.SOFT_ID = :B2 AND UO.USER_ID = :B1 AND UO.ORDER_STATUS IN (1,3)
48,785 48,520 1.0 32.2 6.7 .0 5nggumnh49y
select * from SYS_PRODUCT where SERIAL_NO = :1
35,583 35,582 1.0 15.5 11.7 .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
34,552 340,070 9.8 5.5 35.8 15.0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
30,153 0 0.0 1.6 72.8 .1 1fnv7qu1a8q
select * from product_down_setting p where p.serial_no=:1
25,723 776,347 30.2 20.5 28.5 .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
25,723 85,722 3.3 3.1 86.6 .0 5ck2pk4pxbq
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=:1 ) and exists(select 'X' from DI
AG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VALID_FLAG=1) and v.VALID_FL
20,164 20,164 1.0 19.7 83.3 .0 c2t5v51gank
select ds.unified_id as unified_data_id, du.stream_displ
ay_name as unified_data_name, ddsu.unit_name as unified_d
ata_unit_name, ddsu.unit_id as unified_data_unit_id
from df_data_stream_desc ds left join df_unified_data_desc dud on d
14,946 7,406 0.5 4.4 49.3 .0 5ky6k3fa3cu
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
10,535 10,522 1.0 0.6 33.6 .0 6vcur2dbtx6
select * from DIAG_SOFT where SOFT_ID = :1
7,553 2,129 0.3 18.0 4.5 .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 )
7,242 7,208 1.0 45,134.3 19.2 .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)
6,462 0 0.0 1.2 36.9 3.7 12gmchtj8pp
select usd.*,s.soft_name as SOFT_NAME,su.cc as cc,decode(mu.user_name,null,'鏈?煡
',
SQL ordered by Executions DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> %CPU - CPU Time as a percentage of Elapsed Time
-> %IO - User I/O Time as a percentage of Elapsed Time
-> Total Executions: 641,287
-> Captured SQL account for 95.4% of Total
Elapsed
Executions Rows Processed Rows per Exec Time (s) %CPU %IO SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
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,450 7,777 1.2 146.7 58.1 .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Parse Calls: 502,378
-> Captured SQL account for 94.9% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
148,680 148,680 29.60 520mkxqpf15q8
select 1 from dual
48,785 48,785 9.71 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1
35,583 35,583 7.08 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
34,552 34,552 6.88 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1
30,153 30,153 6.00 1fnv7qu1a8qsc
select * from product_down_setting p where p.serial_no=:1
25,723 25,723 5.12 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc
25,723 25,723 5.12 5ck2pk4pxbq6y
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=:1 ) and exists(select 'X' from DI
AG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VALID_FLAG=1) and v.VALID_FL
20,164 20,164 4.01 c2t5v51gankkv
select ds.unified_id as unified_data_id, du.stream_displ
ay_name as unified_data_name, ddsu.unit_name as unified_d
ata_unit_name, ddsu.unit_id as unified_data_unit_id
from df_data_stream_desc ds left join df_unified_data_desc dud on d
14,946 14,946 2.98 5ky6k3fa3cu3y
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3
10,535 10,535 2.10 6vcur2dbtx62n
select * from DIAG_SOFT where SOFT_ID = :1
7,553 7,553 1.50 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 )
7,242 7,242 1.44 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)
6,462 6,462 1.29 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,450 6,450 1.28 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1
5,638 5,638 1.12 0nrknqc0j9kgr
SQL ordered by Parse Calls DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Parse Calls: 502,378
-> Captured SQL account for 94.9% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
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
5,638 5,638 1.12 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,424 5,424 1.08 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
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
3,370,170 2 0.25 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
3,273,422 88 0.25 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
1,985,434 1 0.15 6wm3n4d7bnddg
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti
me_secs, operation FROM ( SELECT 1 as source, trunc(
(sysdate - cast(ll.log_date as date)) * 86400) as time_secs,
decode(ll.operation, 'OPEN', 0
1,773,960 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,581,780 44 0.12 3hpxs5dvc897x
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
1,581,708 44 0.12 77jfd5z2qky8p
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
1,467,842 5 0.11 f900nxym1961q
Module: PL/SQL Developer
SELECT O.OBJECT_TYPE, O.OWNER, O.OBJECT_NAME FROM SYS.ALL_OBJECTS O WHERE O.OWNE
R = :B2 AND O.OBJECT_NAME = :B1 AND OBJECT_TYPE IN ('TABLE', 'VIEW', 'SEQUENCE',
'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM =
1
1,467,758 11 0.11 5dkwcgywj8qug
Module: PL/SQL Developer
SELECT OBJECT_TYPE, USER, :B1 FROM SYS.ALL_OBJECTS WHERE WNER = USER AND OBJECT
_NAME = :B1 AND OBJECT_TYPE IN ('TABLE', 'VIEW', 'SEQUENCE', 'PROCEDURE', 'FUNCT
ION', 'PACKAGE', 'TYPE', 'TRIGGER', 'SYNONYM') AND ROWNUM = 1
1,245,158 107 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,
1,199,654 88 0.09 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
SQL ordered by Sharable Memory DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
1,082,924 27 0.08 6wm4cg3kd3u81
update CC_USER set USER_TYPE_ID = :1, PASSWORD = :2,
USER_NAME = :3, NICK_NAME = :4, PURIKURAURL
= :5, MOBILE = :6, EMAIL = :7,
SEX = :8, BIRTHDAY = :9, IS_BIND_EMAIL =
1,081,868 5 0.08 13u83qfzhh56a
Module: PL/SQL Developer
SELECT S.TABLE_OWNER, S.TABLE_NAME FROM SYS.ALL_SYNONYMS S WHERE S.SYNONYM_NAME
= :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
178 4 0v3dvmc22qnam
insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, noneq
uijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn,
:coln, decode(bitand(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decod
e(bitand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode(bitand(:flag
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 1 5rygsj4dbw6jt
insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, dr
op_segments) values (:1, :2, :3, :4, :5, :6, :7)
80 554 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 276 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 213 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
73 107 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 117 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))
71 72 ctsfqq07f876g
SELECT NVL(CRIT_COUNTER,0), NVL(WARN_COUNTER,0), NVL(INFO_COUNTER,0) FROM MGMT_P
OLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND RESUL
T_KEY_VALUE = :B2 AND COLL_NAME = :B1
69 1 9yt4ka3n2svmc
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
Module: DBMS_SCHEDULER
update sys.scheduler$_job set last_enabled_time = :1, next_run_date = :2, job_s
tatus = :3 where obj# = :4
67 5 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
67 5 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
65 204 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
64 5 2wuxsvgst612h
SELECT NVL(AVG(VALUE),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND
NAME=:B1 AND TIME>(SYSDATE-(1/24))
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 5 1t0vfvhmyjq5c
SELECT NVL(AVG(VALUE) ,0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME='Notif
ication Delivery' AND NAME='Delivery Time' AND TIME>(SYSDATE-(1/24))
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 204 gfdn12rn0fg3m
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :
B1
51 70 9p5tvdmjymwx7
UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE
), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VI
OLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_
LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID =
51 110 b2gnxm5z6r51n
lock table sys.col_usage$ in exclusive mode nowait
51 213 g00cj285jmgsw
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
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)
47 56 aq8yqxyyb40nn
update sys.job$ set this_date=:1 where job=:2
45 2 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
40 5 7gzxf61vj6wq4
SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B
2 ) = :B2 AND A.OWNER# = :B1
29 86 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 88 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
29 88 cw5gh4duww26p
SELECT COUNT(*) AS c from ( select mm.*,nvl2(t3.soft_name,t3.soft_name
,mm.soft_name) as soft_desc from (select distinct m.* from (select s.soft_
id,t1.version_no,t1.creater_time,t2.remark,t2.version_detail_id,nvl(buy_price, d
efault_bprice) as price,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s
28 44 77jfd5z2qky8p
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
28 44 77jfd5z2qky8p
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
28 44 77jfd5z2qky8p
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
SQL ordered by Version Count DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
25 44 3hpxs5dvc897x
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
25 44 3hpxs5dvc897x
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
25 44 3hpxs5dvc897x
select * from ( select mm.*,nvl2(t3.soft_name,t3.soft_name,mm.soft_name) as soft
_desc from (select distinct m.* from (select s.soft_id,t1.version_no,t1.cr
eater_time,t2.remark,t2.version_detail_id,nvl(buy_price, default_bprice) as pric
e,t4.CUR_ID,t4.cur_code,s.soft_name from diag_soft s,sys_product p,sys_ven
25 27 6wm4cg3kd3u81
update CC_USER set USER_TYPE_ID = :1, PASSWORD = :2,
USER_NAME = :3, NICK_NAME = :4, PURIKURAURL
= :5, MOBILE = :6, EMAIL = :7,
SEX = :8, BIRTHDAY = :9, IS_BIND_EMAIL =
-------------------------------------------------------------
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
Batched IO (bound) vector count 0 0.0 0.0
Batched IO (full) vector count 0 0.0 0.0
Batched IO block miss count 0 0.0 0.0
Batched IO buffer defrag count 0 0.0 0.0
Batched IO double miss count 0 0.0 0.0
Batched IO same unit count 0 0.0 0.0
Batched IO single block count 0 0.0 0.0
Batched IO slow jump count 0 0.0 0.0
Batched IO vector block count 0 0.0 0.0
Batched IO vector read count 0 0.0 0.0
Block Cleanout Optim referenced 5 0.0 0.0
CCursor + sql area evicted 8 0.0 0.0
CPU used by this session 927,463 294.8 399.6
CPU used when call started 927,197 294.7 399.5
CR blocks created 469 0.2 0.2
Cached Commit SCN referenced 229,647 73.0 98.9
Commit SCN cached 127 0.0 0.1
DB time 5,156,584 1,639.0 2,221.7
DBWR checkpoint buffers written 4,674 1.5 2.0
DBWR checkpoints 27 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 280 0.1 0.1
DBWR thread checkpoint buffers w 0 0.0 0.0
DBWR transaction table writes 145 0.1 0.1
DBWR undo block writes 623 0.2 0.3
DFO trees parallelized 0 0.0 0.0
HSC Heap Segment Block Changes 9,184 2.9 4.0
HSC IDL Compressed Blocks 0 0.0 0.0
Heap Segment Array Inserts 121 0.0 0.1
Heap Segment Array Updates 80 0.0 0.0
IMU CR rollbacks 131 0.0 0.1
IMU Flushes 767 0.2 0.3
IMU Redo allocation size 2,234,888 710.3 962.9
IMU commits 1,601 0.5 0.7
IMU contention 4 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 1 0.0 0.0
IMU undo allocation size 5,324,656 1,692.4 2,294.1
IMU- failed to get a private str 0 0.0 0.0
LOB table id lookup cache misses 0 0.0 0.0
Number of read IOs issued 21,311 6.8 9.2
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 208 0.1 0.1
RowCR hits 205 0.1 0.1
SMON posted for dropping temp se 0 0.0 0.0
SMON posted for undo segment rec 0 0.0 0.0
SMON posted for undo segment shr 0 0.0 0.0
SQL*Net roundtrips to/from clien 1,330,581 422.9 573.3
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 500 0.2 0.2
application wait time 978 0.3 0.4
auto extends on undo tablespace 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 13,011 4.1 5.6
branch node splits 1 0.0 0.0
buffer is not pinned count 9,072,816 2,883.7 3,909.0
buffer is pinned count 22,109,836 7,027.4 9,526.0
bytes received via SQL*Net from 144,876,341 46,047.8 62,419.8
bytes sent via SQL*Net to client 567,932,674 180,512.9 244,693.1
calls to get snapshot scn: kcmgs 1,002,560 318.7 432.0
calls to kcmgas 4,981 1.6 2.2
calls to kcmgcs 798,473 253.8 344.0
cell physical IO interconnect by 21,444,213,760 6,815,872.5 9,239,213.2
change write time 610 0.2 0.3
cleanout - number of ktugct call 636 0.2 0.3
cleanouts and rollbacks - consis 350 0.1 0.2
cleanouts only - consistent read 128 0.0 0.1
cluster key scan block gets 2,536 0.8 1.1
cluster key scans 2,110 0.7 0.9
commit batch performed 0 0.0 0.0
commit batch requested 0 0.0 0.0
commit batch/immediate performed 4 0.0 0.0
commit batch/immediate requested 4 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 6 0.0 0.0
commit cleanout failures: cannot 2 0.0 0.0
commit cleanouts 10,328 3.3 4.5
commit cleanouts successfully co 10,320 3.3 4.5
commit immediate performed 4 0.0 0.0
commit immediate requested 4 0.0 0.0
commit txn count during cleanout 683 0.2 0.3
concurrency wait time 59,265 18.8 25.5
consistent changes 256,017 81.4 110.3
consistent gets 84,226,087 26,770.6 36,288.7
consistent gets - examination 4,164,636 1,323.7 1,794.3
consistent gets direct 2,595,393 824.9 1,118.2
consistent gets from cache 81,630,694 25,945.7 35,170.5
consistent gets from cache (fast 77,303,077 24,570.2 33,305.9
cursor authentications 203 0.1 0.1
data blocks consistent reads - u 14,509 4.6 6.3
db block changes 293,290 93.2 126.4
db block gets 758,564 241.1 326.8
db block gets direct 177 0.1 0.1
db block gets from cache 758,387 241.1 326.8
db block gets from cache (fastpa 20,490 6.5 8.8
deferred (CURRENT) block cleanou 6,394 2.0 2.8
dirty buffers inspected 1 0.0 0.0
enqueue conversions 720 0.2 0.3
enqueue deadlocks 0 0.0 0.0
enqueue releases 39,207 12.5 16.9
enqueue requests 39,203 12.5 16.9
enqueue timeouts 0 0.0 0.0
enqueue waits 32 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 641,287 203.8 276.3
failed probes on index block rec 0 0.0 0.0
file io service time 0 0.0 0.0
file io wait time 648,361,106 206,076.4 279,345.6
free buffer inspected 4,678 1.5 2.0
free buffer requested 56,643 18.0 24.4
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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,085 0.7 0.9
immediate (CR) block cleanout ap 478 0.2 0.2
immediate (CURRENT) block cleano 722 0.2 0.3
index crx upgrade (positioned) 18 0.0 0.0
index crx upgrade (prefetch) 0 0.0 0.0
index fast full scans (full) 380 0.1 0.2
index fetch by key 8,582,236 2,727.8 3,697.7
index scans kdiixs1 790,147 251.1 340.4
leaf node 90-10 splits 54 0.0 0.0
leaf node splits 72 0.0 0.0
lob reads 121,122 38.5 52.2
lob writes 85,385 27.1 36.8
lob writes unaligned 85,385 27.1 36.8
logons cumulative 451 0.1 0.2
max cf enq hold time 0 0.0 0.0
messages received 4,578 1.5 2.0
messages sent 4,578 1.5 2.0
min active SCN optimization appl 36 0.0 0.0
no buffer to keep pinned count 210 0.1 0.1
no work - consistent read gets 79,017,108 25,115.0 34,044.4
non-idle wait count 1,521,475 483.6 655.5
non-idle wait time 305,865 97.2 131.8
opened cursors cumulative 640,108 203.5 275.8
parse count (describe) 0 0.0 0.0
parse count (failures) 0 0.0 0.0
parse count (hard) 242 0.1 0.1
parse count (total) 502,378 159.7 216.5
parse time cpu 538 0.2 0.2
parse time elapsed 5,021 1.6 2.2
physical read IO requests 24,237 7.7 10.4
physical read bytes 21,275,435,008 6,762,227.5 9,166,495.1
physical read total IO requests 29,250 9.3 12.6
physical read total bytes 21,357,756,416 6,788,392.7 9,201,963.1
physical read total multi block 20,351 6.5 8.8
physical reads 2,597,099 825.5 1,119.0
physical reads cache 2,929 0.9 1.3
physical reads cache prefetch 8 0.0 0.0
physical reads direct 2,594,170 824.5 1,117.7
physical reads direct (lob) 596 0.2 0.3
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 2,905 0.9 1.3
physical write bytes 39,870,464 12,672.5 17,178.1
physical write total IO requests 8,034 2.6 3.5
physical write total bytes 86,457,344 27,479.8 37,250.0
physical write total multi block 74 0.0 0.0
physical writes 4,867 1.6 2.1
physical writes direct 177 0.1 0.1
physical writes direct (lob) 7 0.0 0.0
physical writes direct temporary 1 0.0 0.0
physical writes from cache 4,690 1.5 2.0
physical writes non checkpoint 2,328 0.7 1.0
pinned buffers inspected 0 0.0 0.0
pinned cursors current 1 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: 9670-9671
-> 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 2,486 0.8 1.1
queries parallelized 0 0.0 0.0
recursive calls 473,529 150.5 204.0
recursive cpu usage 10,665 3.4 4.6
redo blocks checksummed by FG (e 12,818 4.1 5.5
redo blocks written 25,774 8.2 11.1
redo buffer allocation retries 0 0.0 0.0
redo entries 19,950 6.3 8.6
redo k-bytes read total 0 0.0 0.0
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 391 0.1 0.2
redo size 11,897,060 3,781.4 5,125.8
redo size for direct writes 1,448,128 460.3 623.9
redo subscn max counts 1,364 0.4 0.6
redo synch time 81,560 25.9 35.1
redo synch writes 2,776 0.9 1.2
redo wastage 841,392 267.4 362.5
redo write time 41,779 13.3 18.0
redo writes 3,090 1.0 1.3
rollback changes - undo records 1,210 0.4 0.5
rollbacks only - consistent read 117 0.0 0.1
root node splits 0 0.0 0.0
rows fetched via callback 2,811,251 893.5 1,211.2
scheduler wait time 0 0.0 0.0
session connect time 0 0.0 0.0
session cursor cache hits 620,095 197.1 267.2
session logical reads 84,984,651 27,011.7 36,615.5
shared hash latch upgrades - no 88,199 28.0 38.0
shared hash latch upgrades - wai 2 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 103,193 32.8 44.5
sorts (rows) 5,484,443 1,743.2 2,363.0
sql area evicted 382 0.1 0.2
sql area purged 0 0.0 0.0
summed dirty queue length 1 0.0 0.0
switch current to new buffer 196 0.1 0.1
table fetch by rowid 12,922,208 4,107.2 5,567.5
table fetch continued row 56,445 17.9 24.3
table scan blocks gotten 75,708,678 24,063.4 32,619.0
table scan rows gotten 7,116,711,711 2,261,990.1 3,066,226.5
table scans (direct read) 30 0.0 0.0
table scans (long tables) 856 0.3 0.4
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 237,207 75.4 102.2
temp space allocated (bytes) 3,145,728 999.8 1,355.3
total cf enq hold time 7,790 2.5 3.4
total number of cf enq holders 220 0.1 0.1
total number of times SMON poste 0 0.0 0.0
transaction rollbacks 4 0.0 0.0
transaction tables consistent re 0 0.0 0.0
transaction tables consistent re 0 0.0 0.0
undo change vector size 2,959,432 940.6 1,275.1
user I/O wait time 51,724 16.4 22.3
user calls 1,818,591 578.0 783.5
user commits 2,317 0.7 1.0
user rollbacks 4 0.0 0.0
workarea executions - multipass 0 0.0 0.0
workarea executions - onepass 0 0.0 0.0
Instance Activity Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Ordered by statistic name
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
workarea executions - optimal 99,533 31.6 42.9
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 6 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: MYCAR/mycar Snaps: 9670-96
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session uga memory max 1.250282425E+12 1.251165754E+12
session pga memory 3.932174241E+11 3.933500253E+11
session pga memory max 4.429923635E+11 4.428823164E+11
session cursor cache count 11,548,804 11,560,177
session uga memory 6.908188560E+14 6.910679909E+14
opened cursors current 361 375
workarea memory allocated 1,724 1,724
logons current 105 101
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: MYCAR/mycar Snaps: 9670-967
-> 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: 9670-9671
-> '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 19.8G 6.8 6.44138 0M 0.0 0M 21.3K 2.8
Others 78M 1.6 .024791 32M 0.6 .010170 7053 87.0
DBWR 0M 0.0 0M 37M 0.9 .011760 1024 248.7
Buffer Cache Re 23M 0.9 .007310 0M 0.0 0M 2922 134.3
LGWR 0M 0.0 0M 13M 1.0 .004131 3091 134.5
Direct Writes 0M 0.0 0M 1M 0.0 .000317 16 112.1
TOTAL: 19.9G 9.3 6.47348 83M 2.6 .026380 35.4K 49.0
-------------------------------------------------------------
IOStat by Filetype summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> '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
--------------- ------- ------- ------- ------- ------- ------- ------- -------
Data File 19.8G 7.7 6.44901 38M 0.9 .012077 107.8 1.6
Control File 78M 1.6 .024791 32M 0.6 .010170 2.7 N/A
Log File 0M 0.0 0M 13M 1.0 .004131 N/A N/A
Temp File 0M 0.0 0M 0M 0.0 0M 0.0 N/A
TOTAL: 19.9G 9.3 6.47380 83M 2.6 .026380 48.7 1.6
-------------------------------------------------------------
IOStat by Function/Filetype summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> '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
19.8G 6.8 6.44138 0M 0.0 0M 0 N/A
Direct Reads (Data File)
19.8G 6.8 6.44138 0M 0.0 0M 0 N/A
Others
78M 1.6 .024791 32M 0.6 .010170 5015 2.7
Others (Control File)
78M 1.6 .024791 32M 0.6 .010170 5004 2.7
Others (Data File)
0M 0.0 0M 0M 0.0 0M 11 0.5
DBWR
0M 0.0 0M 37M 0.9 .011760 0 N/A
DBWR (Data File)
0M 0.0 0M 37M 0.9 .011760 0 N/A
Buffer Cache Reads
23M 0.9 .007310 0M 0.0 0M 2924 134.2
Buffer Cache Reads (Data File)
23M 0.9 .007310 0M 0.0 0M 2924 134.2
LGWR
0M 0.0 0M 13M 1.0 .004131 0 N/A
LGWR (Log File)
0M 0.0 0M 13M 1.0 .004131 0 N/A
Direct Writes
0M 0.0 0M 1M 0.0 .000317 0 N/A
Direct Writes (Data File)
0M 0.0 0M 1M 0.0 .000317 0 N/A
TOTAL:
19.9G 9.3 6.47348 83M 2.6 .026380 7939 51.1
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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)
-------------- ------- ------- ------- ------------ -------- ---------- -------
MYCAR
23,946 8 13.8 108.4 1,863 1 4 402.5
SYSAUX
256 0 184.8 1.0 568 0 0 0.0
UNDOTBS1
1 0 0.0 1.0 307 0 0 0.0
SYSTEM
24 0 630.0 1.0 80 0 0 0.0
PASSPORT
16 0 96.9 1.0 86 0 0 0.0
TEMP
1 0 0.0 1.0 1 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
21,980 7 13.4 109.6 1,037 0 4 402.5
MYCAR /oracle/oradata/mycar/mycar01.dbf
1,966 1 17.2 96.0 826 0 0 0.0
PASSPORT /oracle/oradata/mycar/passport.dbf
16 0 96.9 1.0 86 0 0 0.0
SYSAUX /oracle/oradata/mycar/sysaux01.dbf
256 0 184.8 1.0 568 0 0 0.0
SYSTEM /oracle/oradata/mycar/system01.dbf
24 0 630.0 1.0 80 0 0 0.0
TEMP /oracle/oradata/mycar/temp01.dbf
1 0 0.0 1.0 1 0 0 N/A
UNDOTBS1 /oracle/oradata/mycar/undotbs01.dbf
1 0 0.0 1.0 307 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 82,350,457 2,927 4,690 0 0 4
-------------------------------------------------------------
Checkpoint Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Physical Writes: 4,867
Other Autotune Thread
MTTR Log Size Log Ckpt Settings Ckpt Ckpt
Writes Writes Writes Writes Writes Writes
----------- ----------- ----------- ----------- ----------- -----------
0 0 0 0 4,394 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 690 3472 10360 995328 10360 N/A N/A N/A
E 0 14 389 2352 12974 995328 12974 N/A N/A N/A
-------------------------------------------------------------
MTTR Advisory DB/Inst: MYCAR/mycar Snap: 9671
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: MYCAR/mycar Snap: 9671
-> 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.7 2,630,395 1 1.2E+06
D 160 .2 20 1.0 1,587,704 1 5.6E+04
D 240 .3 30 1.0 1,567,139 1 3.3E+04
D 320 .4 39 1.0 1,563,103 1 2.8E+04
D 400 .5 49 1.0 1,562,481 1 2.8E+04
D 480 .6 59 1.0 1,562,055 1 2.7E+04
D 560 .7 69 1.0 1,561,763 1 2.7E+04
D 640 .8 79 1.0 1,561,482 1 2.6E+04
D 720 .9 89 1.0 1,561,250 1 2.6E+04
D 800 1.0 99 1.0 1,561,072 1 2.6E+04
D 880 1.1 108 1.0 1,560,897 1 2.6E+04
D 960 1.2 118 1.0 1,560,738 1 2.6E+04
D 1,040 1.3 128 1.0 1,560,624 1 2.5E+04
D 1,120 1.4 138 1.0 1,560,541 1 2.5E+04
D 1,200 1.5 148 1.0 1,560,473 1 2.5E+04
D 1,280 1.6 158 1.0 1,560,403 1 2.5E+04
D 1,360 1.7 167 1.0 1,559,736 1 2.4E+04
D 1,440 1.8 177 1.0 1,509,444 1 8032.0
D 1,520 1.9 187 1.0 1,498,050 1 8030.0
D 1,600 2.0 197 0.9 1,434,643 1 8023.0
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
--------------- ------------------ --------------------------
100.0 10,665 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 81,823 81,823 0 0
64K 128K 4,332 4,332 0 0
128K 256K 1,804 1,804 0 0
256K 512K 92 92 0 0
512K 1024K 10,612 10,612 0 0
1M 2M 721 721 0 0
2M 4M 111 111 0 0
4M 8M 32 32 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: MYCAR/mycar Snap: 9671
-> 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 24,723,183.0 52,357,020.9 32.0 351,888 9.1E+10
284 0.3 24,723,183.0 52,195,279.8 32.0 347,751 9.1E+10
568 0.5 24,723,183.0 13,321,858.6 65.0 9 4.5E+10
852 0.8 24,723,183.0 12,958,227.0 66.0 0 4.4E+10
1,136 1.0 24,723,183.0 12,101,488.4 67.0 0 4.3E+10
1,363 1.2 24,723,183.0 11,940,608.0 67.0 0 4.3E+10
1,590 1.4 24,723,183.0 11,940,458.1 67.0 0 4.3E+10
1,818 1.6 24,723,183.0 11,940,347.2 67.0 0 4.3E+10
2,045 1.8 24,723,183.0 11,940,347.2 67.0 0 4.3E+10
2,272 2.0 24,723,183.0 11,940,347.2 67.0 0 4.3E+10
3,408 3.0 24,723,183.0 11,940,347.2 67.0 0 4.3E+10
4,544 4.0 24,723,183.0 11,940,187.6 67.0 0 4.3E+10
6,816 6.0 24,723,183.0 11,940,187.6 67.0 0 4.3E+10
9,088 8.0 24,723,183.0 11,940,187.6 67.0 0 4.3E+10
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: MYCAR/mycar Snap: 9671
-> 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 39 2,153 6.94E+06 1.0 2.3E+05 1.1 101,462
880 .7 169 8,081 6.94E+06 1.0 2.3E+05 1.1 332,585
1,008 .8 296 11,699 6.95E+06 1.0 2.2E+05 1.0 333,224
1,136 .9 423 15,418 6.95E+06 1.0 2.1E+05 1.0 333,487
1,264 1.0 551 18,749 6.96E+06 1.0 2.1E+05 1.0 333,703
1,392 1.1 679 23,378 6.96E+06 1.0 2.1E+05 1.0 333,893
1,520 1.2 807 27,654 6.96E+06 1.0 2.1E+05 1.0 334,007
1,648 1.3 934 32,125 6.96E+06 1.0 2.1E+05 1.0 334,056
1,776 1.4 1,062 35,686 6.96E+06 1.0 2.1E+05 1.0 334,090
1,904 1.5 1,190 38,566 6.96E+06 1.0 2.1E+05 1.0 334,108
2,032 1.6 1,318 41,951 6.96E+06 1.0 2.1E+05 1.0 334,122
2,160 1.7 1,446 45,488 6.96E+06 1.0 2.1E+05 1.0 334,132
2,288 1.8 1,574 48,999 6.96E+06 1.0 2.1E+05 1.0 334,141
2,416 1.9 1,701 52,890 6.96E+06 1.0 2.1E+05 1.0 334,149
2,544 2.0 1,829 56,952 6.96E+06 1.0 2.1E+05 1.0 334,157
-------------------------------------------------------------
SGA Target Advisory DB/Inst: MYCAR/mycar Snap: 9671
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
1,072 0.5 5,805,623 1,566,379,870
1,608 0.8 5,785,391 1,561,852,760
2,144 1.0 5,780,766 1,561,072,224
2,680 1.3 5,765,736 1,497,380,477
3,216 1.5 5,761,111 1,508,776,304
3,752 1.8 5,760,533 1,508,776,304
4,288 2.0 5,760,533 1,434,000,945
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: MYCAR/mycar Snap: 9671
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: 9671
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 4 2 403
-------------------------------------------------------------
Enqueue Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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)
------------ ------------ ----------- ----------- ------------ --------------
PR-Process Startup
117 117 0 5 74 14,882.00
KO-Multiple Object Checkpoint (fast object checkpoint)
243 243 0 27 9 340.00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 .5 3,797 1,191 4 240/240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
02-Jul 16:50 41 654 1,191 3 240 0/0 0/0/0/0/0/0
02-Jul 16:40 83 1,096 590 2 240 0/0 0/0/0/0/0/0
02-Jul 16:30 87 686 1,190 3 240 0/0 0/0/0/0/0/0
02-Jul 16:20 48 615 582 4 240 0/0 0/0/0/0/0/0
02-Jul 16:10 191 746 1,182 3 240 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> "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 1,948 0.0 0 0 N/A
ASM map operation hash t 1 0.0 0 0 N/A
ASM network state latch 55 0.0 0 0 N/A
AWR Alerted Metric Eleme 27,016 0.0 0 0 N/A
Change Notification Hash 1,017 0.0 0 0 N/A
Consistent RBA 3,090 0.0 0 0 N/A
DML lock allocation 16,992 0.0 0 0 N/A
Event Group Locks 394 0.0 0 0 N/A
FAL Queue 142 0.0 0 0 N/A
FOB s.o list latch 1,727 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 21,320 0.0 0 3,022 0.0
JS Sh mem access 5 0.0 0 0 N/A
JS mem alloc latch 4 0.0 0 0 N/A
JS queue access latch 5 0.0 0 0 N/A
JS queue state obj latch 21,022 0.0 0 0 N/A
JS slv state obj latch 203 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,046 0.0 0 0 N/A
KTF sga latch 17 0.0 0 808 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 69 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 62 0.0
Memory Management Latch 1 0.0 0 1,046 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 16 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,894 0.0 0 0 N/A
OS process allocation 2,304 0.0 0.0 0 0 N/A
OS process: request allo 790 0.0 0 0 N/A
PL/SQL warning settings 940 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 3,355 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 104 0.0 0 947 0.0
SQL memory manager worka 196,025 0.0 0 0 N/A
Shared B-Tree 295 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: 9670-9671
-> "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,329 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,213 0.0 0 0 N/A
active service list 8,147 0.0 1.0 0 4,130 0.0
archive control 52 0.0 0 0 N/A
archive process latch 426 0.9 1.0 0 0 N/A
begin backup scn array 15 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 30,650 0.0 0.0 0 0 N/A
cache buffers chains 161,316,785 0.2 0.0 244 34,541 0.0
cache buffers lru chain 5,144 0.0 0.0 0 8,267,598 0.0
cache table scan latch 2 0.0 0 2 0.0
call allocation 1,754 0.3 1.0 0 0 N/A
cas latch 1 0.0 0 0 N/A
change notification clie 1 0.0 0 0 N/A
channel handle pool latc 849 0.0 0 0 N/A
channel operations paren 15,572 0.0 0 0 N/A
checkpoint queue latch 98,328 0.0 0 4,241 0.0
client/application info 3,038 0.0 0 0 N/A
compile environment latc 451 0.0 0 0 N/A
corrupted undo seg latch 3,634 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 55 0.0 0 0 N/A
cvmap freelist lock 1 0.0 0 0 N/A
deferred cleanup latch 55 0.0 0 0 N/A
dml lock allocation 55 0.0 0 0 N/A
done queue latch 1 0.0 0 0 N/A
dummy allocation 907 0.0 0 0 N/A
enqueue hash chains 79,213 0.0 0.0 0 27 0.0
enqueues 51,678 0.0 0.0 0 0 N/A
fifth spare latch 1 0.0 0 0 N/A
file cache latch 176 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 273 0.0 0 0 N/A
global tx hash mapping 1 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> "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 212 0.0 0 189,852 0.0
hash table modification 110 0.0 0 0 N/A
heartbeat check 1 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 59 0.0 0 58 5.2
job_queue_processes free 120 0.0 0 0 N/A
job_queue_processes para 687 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,883 0.0 0 0 N/A
kokc descriptor allocati 468 0.0 0 0 N/A
ksfv messages 1 0.0 0 0 N/A
kss move lock 33 0.0 0 0 N/A
ksuosstats global area 213 0.0 0 0 N/A
ksv allocation latch 120 0.0 0 0 N/A
ksv class latch 67 0.0 0 0 N/A
ksv msg queue latch 1 0.0 0 0 N/A
ksz_so allocation latch 790 0.0 0 0 N/A
ktm global data 18 0.0 0 0 N/A
kwqbsn:qsga 114 0.0 0 0 N/A
lgwr LWN SCN 3,592 0.0 0 0 N/A
list of block allocation 948 0.0 0 0 N/A
loader state object free 1,154 0.0 0 0 N/A
lob segment dispenser la 1 0.0 0 0 N/A
lob segment hash table l 11 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 6 0.0 0 5 0.0
managed standby latch 142 0.7 0.0 0 0 N/A
mapped buffers lru chain 1 0.0 0 0 N/A
message pool operations 82 0.0 0 0 N/A
messages 39,290 0.0 0.0 0 0 N/A
mostly latch-free SCN 3,592 0.0 0 0 N/A
msg queue latch 1 0.0 0 0 N/A
multiblock read objects 10 0.0 0 0 N/A
name-service namespace b 1 0.0 0 0 N/A
ncodef allocation latch 55 0.0 0 0 N/A
object queue header heap 82 0.0 0 80 0.0
object queue header oper 129,857 0.0 0 0 N/A
object stats modificatio 4 0.0 0 0 N/A
parallel query alloc buf 401 0.0 0 0 N/A
parallel query stats 1 0.0 0 0 N/A
parameter list 473 0.0 0 0 N/A
parameter table manageme 908 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 9,861 0.0 0.0 0 8,622 0.0
process allocation 907 0.0 0 393 0.0
process group creation 790 0.1 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 791 0.0 0 0 N/A
query server freelists 1 0.0 0 0 N/A
Latch Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
queued dump request 10 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 16,279 0.0 0 19,988 0.0
redo copy 1 0.0 0 19,988 0.5
redo writing 13,313 0.0 0 0 N/A
resmgr group change latc 609 0.0 0 0 N/A
resmgr:active threads 907 0.0 0 0 N/A
resmgr:actses change gro 351 0.0 0 0 N/A
resmgr:actses change sta 1 0.0 0 0 N/A
resmgr:free threads list 906 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 795,245 0.0 0.4 0 96 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 18,844 0.0 0 0 N/A
session allocation 441,165 0.0 0.0 0 147,052 0.0
session idle bit 3,783,784 0.0 0.0 0 0 N/A
session queue latch 1 0.0 0 0 N/A
session state list latch 960 0.0 0 0 N/A
session switching 2,041 0.0 0 0 N/A
session timer 1,153 0.0 0 0 N/A
shared pool 52,366 0.3 0.1 0 0 N/A
shared pool sim alloc 1 0.0 0 0 N/A
shared pool simulator 3,065 0.0 0 0 N/A
sim partition latch 1 0.0 0 0 N/A
simulator hash latch 6,189,399 0.0 0.2 2 0 N/A
simulator lru latch 2,261 0.0 0 5,198,044 0.4
sort extent pool 105 0.0 0 0 N/A
space background state o 4 0.0 0 0 N/A
space background task la 2,138 0.0 0 2,090 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 5 0.0 0 0 N/A
temporary table state ob 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 141 0.0 0 0 N/A
transaction allocation 1,506 0.0 0 0 N/A
undo global data 18,404 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: 9670-9671
-> ordered by misses desc
Get Spin
Latch Name Requests Misses Sleeps Gets
-------------------------- --------------- ------------ ----------- -----------
cache buffers chains 161,316,785 322,164 324 321,867
shared pool 52,366 134 17 118
session idle bit 3,783,784 112 3 109
simulator hash latch 6,189,399 30 6 24
row cache objects 795,245 16 7 9
call allocation 1,754 6 6 0
archive process latch 426 4 4 0
active service list 8,147 1 1 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
active service list kswslogon: session logout 0 1 1
archive process latch kcrrgpll 0 4 2
cache buffers chains kcbgtcr: fast path (cr pin 0 291 176
cache buffers chains kcbrls_1 0 66 183
cache buffers chains kcbgtcr: fast path 0 5 4
cache buffers chains kcbivbr 0 1 0
cache buffers chains kcbrls_2 0 1 0
call allocation ksuxds 0 6 1
row cache objects kqrpre: find obj 0 6 7
row cache objects kqreqd 0 1 0
session idle bit ksupuc: clear busy 0 2 0
session idle bit ksuxds 0 1 1
shared pool kghalo 0 16 11
shared pool kghupr1 0 1 4
simulator hash latch kcbsacc: lookup dba 0 5 6
simulator hash latch kcbsacc: remove dba 0 1 0
-------------------------------------------------------------
Mutex Sleep Summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> ordered by number of sleeps desc
Wait
Mutex Type Location Sleeps Time (ms)
--------------------- -------------------------------- ------------ ------------
Library Cache kgllkdl1 85 10 11
Cursor Pin kksfbc [KKSCHLPIN1] 9 0
Library Cache kglIsOwnerVersionable 121 2 16,202
Library Cache kglhdgn1 62 2 209
Library Cache kglhdgn2 106 1 -8
Library Cache kglpndl1 95 1 0
Cursor Stat kkocsStoreBindAwareStats [KKSSTA 1 0
Cursor Pin kksLockDelete [KKSCHLPIN6] 1 0
Cursor Parent kkscsAddChildNode [KKSPRTLOC34] 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Logical Reads: 84,984,651
-> Captured Segments account for 98.8% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR SYS_PRODUCT TABLE 38,624,880 45.45
MYCAR MYCAR ORDER_DETAIL_INFO TABLE 17,260,864 20.31
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 8,351,296 9.83
MYCAR MYCAR COUNTRY_IP_RANGE TABLE 6,849,200 8.06
MYCAR MYCAR SYS_SOFT_CONF TABLE 1,827,440 2.15
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Physical Reads: 2,597,099
-> Captured Segments account for 99.9% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 1,490,835 57.40
MYCAR MYCAR OPERATE_LOG TABLE 1,102,913 42.47
MYCAR MYCAR COM_IND_DUSC INDEX 521 .02
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 304 .01
MYCAR MYCAR SYS_PRODUCT_BURN_INF TABLE 31 .00
-------------------------------------------------------------
Segments by Physical Read Requests DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Physical Read Requests: 24,237
-> Captured Segments account for 90.2% of Total
Tablespace Subobject Obj. Phys Read
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 12,099 49.92
MYCAR MYCAR OPERATE_LOG TABLE 8,812 36.36
MYCAR MYCAR COM_IND_DUSC INDEX 521 2.15
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 304 1.25
MYCAR MYCAR SYS_PRODUCT_BURN_INF TABLE 31 .13
-------------------------------------------------------------
Segments by UnOptimized Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total UnOptimized Read Requests: 24,237
-> Captured Segments account for 90.2% of Total
Tablespace Subobject Obj. UnOptimized
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 12,099 49.92
MYCAR MYCAR OPERATE_LOG TABLE 8,812 36.36
MYCAR MYCAR COM_IND_DUSC INDEX 521 2.15
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 304 1.25
MYCAR MYCAR SYS_PRODUCT_BURN_INF TABLE 31 .13
-------------------------------------------------------------
Segments by Optimized Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Direct Physical Reads DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Direct Physical Reads: 2,594,170
-> Captured Segments account for 100.0% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 1,490,808 57.47
MYCAR MYCAR OPERATE_LOG TABLE 1,102,764 42.51
-------------------------------------------------------------
Segments by Physical Writes DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Physical Writes: 4,867
-> Captured Segments account for 58.9% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR COM_IND_DUSC INDEX 645 13.25
MYCAR MYCAR OPERATE_LOG TABLE 422 8.67
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 325 6.68
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 195 4.01
MYCAR MYCAR SYS_PRODUCT_BURN_SOF TABLE 185 3.80
-------------------------------------------------------------
Segments by Physical Write Requests DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Physical Write Requestss: 2,905
-> Captured Segments account for 60.7% of Total
Tablespace Subobject Obj. Phys Write
Owner Name Object Name Name Type Requests %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR COM_IND_DUSC INDEX 377 12.98
MYCAR MYCAR OPERATE_LOG TABLE 320 11.02
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 274 9.43
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 181 6.23
MYCAR MYCAR SYS_PRODUCT TABLE 107 3.68
-------------------------------------------------------------
Segments by Direct Physical Writes DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Direct Physical Writes: 177
-> Captured Segments account for 99.4% of Total
Tablespace Subobject Obj. Direct
Owner Name Object Name Name Type Writes %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSAUX WRH$_ACTIVE_SESSION_ 81432_9664 TABLE 169 95.48
SYS SYSAUX SYS_LOB0000006213C00 LOB 7 3.95
-------------------------------------------------------------
Segments by Table Scans DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Total Table Scans: 1,236
-> Captured Segments account for 69.3% of Total
Tablespace Subobject Obj. Table
Owner Name Object Name Name Type Scans %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 826 66.83
MYCAR MYCAR DIAG_DOWNLOAD_RECORD TABLE 24 1.94
MYCAR MYCAR OPERATE_LOG TABLE 6 .49
-------------------------------------------------------------
Segments by DB Blocks Changes DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> % 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
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS TEMP SYS_TEMP_0FD9D6863_B TABLE 241,456 90.15
MYCAR MYCAR DIAG_USER_SOFT_CENTE TABLE 15,488 5.78
MYCAR MYCAR OPERATE_LOG TABLE 2,176 .81
MYCAR MYCAR SOFTIDUSERIDSERIALNO INDEX 1,456 .54
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 1,232 .46
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR MYCAR PK_DIAG_USER_SOFT_CE INDEX 5 55.56
MYCAR MYCAR SERIALNO_SPLC INDEX 2 22.22
MYCAR MYCAR SYS_C0015896 INDEX 2 22.22
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> "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 60 0.0 0 N/A 2 1
dc_files 9 0.0 0 N/A 0 9
dc_global_oids 589 0.0 0 N/A 0 66
dc_histogram_data 5,238 0.1 0 N/A 0 4,326
dc_histogram_defs 4,179 1.8 0 N/A 0 5,734
dc_objects 4,963 0.2 0 N/A 5 2,974
dc_profiles 333 0.0 0 N/A 0 1
dc_rollback_segments 736 0.0 0 N/A 0 22
dc_segments 3,108 0.1 0 N/A 7 1,476
dc_sequences 554 0.0 0 N/A 554 50
dc_tablespaces 113,458 0.0 0 N/A 0 10
dc_users 137,424 0.0 0 N/A 0 173
global database name 2,376 0.0 0 N/A 0 2
outstanding_alerts 35 0.0 0 N/A 0 7
sch_lj_oids 4 0.0 0 N/A 0 27
-------------------------------------------------------------
Library Cache Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,025 0.0 1,779 0.0 0 0
CLUSTER 10 0.0 6 0.0 0 0
DBLINK 551 0.0 0 N/A 0 0
EDITION 348 0.0 679 0.0 0 0
INDEX 2 0.0 1 0.0 0 0
QUEUE 54 0.0 187 0.0 0 0
SCHEMA 610 0.0 0 N/A 0 0
SQL AREA 18,748 2.7 671,841 0.1 44 0
SUBSCRIPTION 11 0.0 11 0.0 0 0
TABLE/PROCEDURE 4,760 0.1 23,484 0.1 16 0
TRIGGER 21 0.0 62 0.0 0 0
-------------------------------------------------------------
Memory Dynamic Components DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Memory Resize Ops DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Process Memory Summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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 390.7 N/A 3.7 7.7 28 32 107 107
Freeable 56.9 .0 1.0 .7 4 N/A 55 55
SQL 1.6 1.0 .0 .0 0 85 85 79
PL/SQL 1.1 .9 .0 .0 0 0 105 105
E Other 390.0 N/A 3.8 7.8 28 32 103 103
Freeable 56.8 .0 1.1 .7 4 N/A 54 54
PL/SQL 3.2 3.0 .0 .2 2 3 101 101
SQL 2.2 1.6 .0 .1 1 10 81 75
-------------------------------------------------------------
SGA Memory Summary DB/Inst: MYCAR/mycar Snaps: 9670-9671
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: 9670-9671
-> 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 91.1 90.8 -0.38
shared FileOpenBlock 15.2 15.2 0.00
shared KGLHD 26.5 26.7 0.79
shared KGLS 13.8 13.5 -1.97
shared PCUR 72.1 72.6 0.70
shared PLMCD 13.1 12.8 -2.72
shared SQLA 506.5 500.3 -1.24
shared free memory 320.8 327.7 2.17
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: 9670-9671
-> 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: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture Rate DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply Rate DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Persistent Queues DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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)
54 54 0.0 0.0 0.0 3.5 0.0 0.0
-------------------------------------------------------------
Persistent Queues Rate DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> Ordered by Queue Name
-> * indicates queue (re)started between Begin/End snaps
Enqueue Dequeue Avg Enqueue Avg Dequeue
Msgs/sec Msgs/sec sec / msg sec / msg
---------- ---------- ------------- -------------
SYS.ALERT_QUE(12343)
0.00 0.00 N/A N/A
SYS.AQ$_ALERT_QT_E(12342)
0.00 0.00 N/A N/A
SYSMAN.MGMT_NOTIFY_Q(66903)
0.00 0.00 N/A N/A
SYSMAN.MGMT_TASK_Q(66573)
0.02 0.02 0.00 0.07
-------------------------------------------------------------
Persistent Queue Subscribers DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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: 9671
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Activity DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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: 9670-9671
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: 9670-9671
-> 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,146 0.0 100.0 0.0 0.0
-------------------------------------------------------------
Shared Servers Common Queue DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
Shared Servers Dispatchers DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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,146 0.0 100.0 0 0
-------------------------------------------------------------
init.ora Parameters DB/Inst: MYCAR/mycar Snaps: 9670-9671
-> 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
cursor_sharing EXACT
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
sql_trace FALSE
undo_retention 14400
undo_tablespace UNDOTBS1
workarea_size_policy AUTO
-------------------------------------------------------------
Dynamic Remastering Stats DB/Inst: MYCAR/mycar Snaps: 9670-9671
No data exists for this section of the report.
-------------------------------------------------------------
End of Report
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22126868/viewspace-765342/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ADDSOFTCONFREFSOFT
下一篇：
tunning_sql1
请登录后发表评论
登录
全部评论
