ITPub博客

首页 > Linux操作系统 > Linux操作系统 > awrrpt_1_9670_9671.txt

awrrpt_1_9670_9671.txt

原创 Linux操作系统 作者:yagerya 时间:2013-07-02 18:01:49 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/22126868/viewspace-765342/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ADDSOFTCONFREFSOFT
下一篇: tunning_sql1
请登录后发表评论 登录
全部评论

注册时间:2012-10-21

  • 博文量
    20
  • 访问量
    54904