ITPub博客

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

awrrpt_1_9474_9475.txt

原创 Linux操作系统 作者:yagerya 时间:2013-06-24 18:07:32 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:      9474 24-Jun-13 16:00:19        97       4.8
  End Snap:      9475 24-Jun-13 17:00:43       102       4.5
   Elapsed:               60.40 (mins)
   DB Time:              990.46 (mins)

Cache Sizes                       Begin        End
~~~~~~~~~~~                  ---------- ----------
               Buffer Cache:       784M       784M  Std Block Size:         8K
           Shared Pool Size:     1,264M     1,264M      Log Buffer:    15,596K

Load Profile              Per Second    Per Transaction   Per Exec   Per Call
~~~~~~~~~~~~         ---------------    --------------- ---------- ----------
      DB Time(s):               16.4               15.0       0.12       0.03
       DB CPU(s):                1.8                1.7       0.01       0.00
       Redo size:            3,912.2            3,581.5
   Logical reads:          101,396.9           92,823.8
   Block changes:               15.3               14.0
  Physical reads:            2,164.7            1,981.6
 Physical writes:            1,148.8            1,051.7
      User calls:              476.4              436.1
          Parses:              134.9              123.5
     Hard parses:                0.1                0.1
W/A MB processed:               14.1               12.9
          Logons:                0.1                0.1
        Executes:              136.2              124.7
       Rollbacks:                0.0                0.0
    Transactions:                1.1

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:  100.00    In-memory Sort %:  100.00
            Library Hit   %:   99.84        Soft Parse %:   99.94
         Execute to Parse %:    0.94         Latch Hit %:   99.88
Parse CPU to Parse Elapsd %:   16.97     % Non-Parse CPU:   99.91

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   71.58   70.88
    % SQL with executions>1:   92.01   95.35
  % Memory for SQL w/exec>1:   87.63   92.77

Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                                                           Avg
                                                          wait   % DB
Event                                 Waits     Time(s)   (ms)   time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
direct path write temp              205,140      37,874    185   63.7 User I/O
direct path read temp               204,387       8,892     44   15.0 User I/O
DB CPU                                            6,679          11.2
direct path read                     30,455         551     18     .9 User I/O
log file sync                         4,077         404     99     .7 Commit
Host CPU (CPUs:    4 Cores:    4 Sockets:    4)
~~~~~~~~         Load Average
               Begin       End     %User   %System      %WIO     %Idle
           --------- --------- --------- --------- --------- ---------
                1.30      6.50      34.1      12.1      10.8      53.8

Instance CPU
~~~~~~~~~~~~
              % of total CPU for Instance:      46.1
              % of busy  CPU for Instance:      99.8
  %DB time waiting for CPU - Resource Mgr:       0.0

Memory Statistics
~~~~~~~~~~~~~~~~~                       Begin          End
                  Host Mem (MB):      8,192.0      8,192.0
                   SGA use (MB):      2,144.0      2,144.0
                   PGA use (MB):        488.5        484.6
    % Host Mem used for SGA+PGA:        32.14        32.09

Time Model Statistics                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total time in database user-calls (DB Time): 59427.4s
-> Statistics including the word "background" measure background process
   time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name

Statistic Name                                       Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time                             58,650.4         98.7
DB CPU                                                6,679.2         11.2
PL/SQL execution elapsed time                         4,702.7          7.9
parse time elapsed                                       43.2           .1
connection management call elapsed time                  36.5           .1
hard parse elapsed time                                   6.8           .0
failed parse elapsed time                                 1.4           .0
hard parse (sharing criteria) elapsed time                0.9           .0
sequence load elapsed time                                0.2           .0
repeated bind elapsed time                                0.0           .0
PL/SQL compilation elapsed time                           0.0           .0
DB time                                              59,427.4
background elapsed time                                 694.5
background cpu time                                       2.1
          -------------------------------------------------------------

Operating System Statistics             DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> *TIME statistic values are diffed.
   All others display actual values.  End Value is displayed if different
-> ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic                                  Value        End Value
------------------------- ---------------------- ----------------
BUSY_TIME                                669,667
IDLE_TIME                                780,428
IOWAIT_TIME                              156,557
NICE_TIME                                      0
SYS_TIME                                 175,251
USER_TIME                                493,865
LOAD                                           1                7
RSRC_MGR_CPU_WAIT_TIME                         0
PHYSICAL_MEMORY_BYTES              8,589,934,592
NUM_CPUS                                       4
NUM_CPU_CORES                                  4
NUM_CPU_SOCKETS                                4
GLOBAL_RECEIVE_SIZE_MAX                4,194,304
GLOBAL_SEND_SIZE_MAX                   1,048,576
TCP_RECEIVE_SIZE_DEFAULT                  87,380
TCP_RECEIVE_SIZE_MAX                   4,194,304
TCP_RECEIVE_SIZE_MIN                       4,096
TCP_SEND_SIZE_DEFAULT                     16,384
TCP_SEND_SIZE_MAX                      4,194,304
TCP_SEND_SIZE_MIN                          4,096
          -------------------------------------------------------------

Operating System Statistics - Detail    DB/Inst: MYCAR/mycar  Snaps: 9474-9475

Snap Time           Load    %busy    %user     %sys    %idle  %iowait
--------------- -------- -------- -------- -------- -------- --------
24-Jun 16:00:19      1.3      N/A      N/A      N/A      N/A      N/A
24-Jun 17:00:43      6.5     46.2     34.1     12.1     53.8     10.8
          -------------------------------------------------------------

Foreground Wait Class                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> s  - second, ms - millisecond -    1000th of a second
-> ordered by wait time desc, waits desc
-> %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0
-> Captured Time accounts for         91.9%  of Total DB time      59,427.43 (s)
-> Total FG Wait Time:            47,923.01 (s)  DB CPU time:       6,679.21 (s)

                                                                  Avg
                                      %Time       Total Wait     wait
Wait Class                      Waits -outs         Time (s)     (ms)  %DB time
-------------------- ---------------- ----- ---------------- -------- ---------
User I/O                      441,860     0           47,430      107      79.8
DB CPU                                                 6,679               11.2
Commit                          4,077     0              404       99       0.7
Concurrency                       843     0               48       57       0.1
Application                        61     0               19      307       0.0
Other                          76,860   100               15        0       0.0
Network                     1,303,117     0                7        0       0.0
System I/O                         12     0                0        2       0.0
          -------------------------------------------------------------

Foreground Wait Events                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> s  - second, ms - millisecond -    1000th of a second
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by wait time desc, waits desc (idle events last)
-> %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0

                                                             Avg
                                        %Time Total Wait    wait    Waits   % DB
Event                             Waits -outs   Time (s)    (ms)     /txn   time
-------------------------- ------------ ----- ---------- ------- -------- ------
direct path write temp          205,140     0     37,874     185     51.8   63.7
direct path read temp           204,387     0      8,892      44     51.6   15.0
direct path read                 30,455     0        551      18      7.7     .9
log file sync                     4,077     0        404      99      1.0     .7
db file sequential read           1,569     0        112      71      0.4     .2
latch: cache buffers chain          811     0         41      51      0.2     .1
enq: KO - fast object chec           47     0         19     397      0.0     .0
latch free                          123     0         13     106      0.0     .0
cursor: pin S                        14     0          7     495      0.0     .0
SQL*Net message to client     1,252,837     0          5       0    316.5     .0
reliable message                     37     0          1      32      0.0     .0
SQL*Net more data from cli        4,495     0          1       0      1.1     .0
Disk file operations I/O            305     0          1       2      0.1     .0
SQL*Net more data to clien       45,785     0          1       0     11.6     .0
db file scattered read                3     0          0     120      0.0     .0
asynch descriptor resize         76,699   100          0       0     19.4     .0
latch: enqueue hash chains            1     0          0     236      0.0     .0
latch: row cache objects              8     0          0      11      0.0     .0
library cache: mutex X                2     0          0      29      0.0     .0
SQL*Net break/reset to cli           14     0          0       3      0.0     .0
control file sequential re           12     0          0       2      0.0     .0
read by other session                 1     0          0      23      0.0     .0
enq: TX - index contention            1     0          0      13      0.0     .0
latch: shared pool                    2     0          0       2      0.0     .0
buffer busy waits                     1     0          0       3      0.0     .0
SQL*Net message from clien    1,252,836     0     88,472      71    316.5
jobq slave wait                   7,665   100      3,883     507      1.9
          -------------------------------------------------------------

Background Wait Events                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by wait time desc, waits desc (idle events last)
-> Only events with Total Wait Time (s) >= .001 are shown
-> %Timeouts: value of 0 indicates value was < .5%.  Value of null is truly 0

                                                             Avg
                                        %Time Total Wait    wait    Waits   % bg
Event                             Waits -outs   Time (s)    (ms)     /txn   time
-------------------------- ------------ ----- ---------- ------- -------- ------
log file parallel write           9,162     0        292      32      2.3   42.0
control file parallel writ        1,247     0        119      95      0.3   17.1
db file async I/O submit            899     0        103     115      0.2   14.9
os thread startup                   139     0         79     572      0.0   11.4
direct path write                    37     0          5     125      0.0     .7
control file sequential re        5,910     0          4       1      1.5     .6
direct path sync                      3     0          2     623      0.0     .3
Disk file operations I/O             94     0          2      19      0.0     .3
enq: JD - contention                  1     0          1     940      0.0     .1
log file sync                         4     0          1     233      0.0     .1
latch: shared pool                    3     0          1     289      0.0     .1
db file sequential read             100     0          1       7      0.0     .1
LGWR wait for redo copy               8     0          0      24      0.0     .0
ADR block file read                  13     0          0       3      0.0     .0
latch free                            2     0          0       6      0.0     .0
asynch descriptor resize            336   100          0       0      0.1     .0
ADR block file write                  5     0          0       0      0.0     .0
rdbms ipc message                19,988    76     78,928    3949      5.0
DIAG idle wait                    7,199   100      7,248    1007      1.8
smon timer                           13   100      3,900  300030      0.0
shared server idle wait             121   100      3,633   30021      0.0
pmon timer                        1,359    88      3,625    2667      0.3
Space Manager: slave idle           695   100      3,620    5209      0.2
Streams AQ: qmn slave idle          248     0      3,615   14579      0.1
Streams AQ: qmn coordinato          378    34      3,615    9565      0.1
dispatcher timer                     60   100      3,601   60019      0.0
SQL*Net message from clien          282     0          7      26      0.1
class slave wait                     19     0          0       0      0.0
          -------------------------------------------------------------

Wait Event Histogram                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> % of Waits: value of .0 indicates value was <.05%; value of null is truly 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  76.9                    23.1
ADR block file write           5 100.0
ADR file lock                  6 100.0
Disk file operations I/O     399  95.7   2.8                .5          .8    .3
LGWR wait for redo copy        8  87.5                                12.5
SQL*Net break/reset to cli    14  85.7               7.1               7.1
SQL*Net message to client  1254. 100.0    .0    .0    .0    .0    .0    .0
SQL*Net more data from cli  4495  99.7    .1    .0                      .2
SQL*Net more data to clien 45.8K 100.0    .0
asynch descriptor resize     77K 100.0    .0                .0
buffer busy waits              1             100.0
control file parallel writ  1247  39.9   2.9   2.2   3.4   5.6   5.9  39.3    .9
control file sequential re  5922  99.4    .0    .0    .1    .1    .1    .2    .0
cursor: mutex S                2 100.0
cursor: pin S                 14  14.3                     7.1        64.3  14.3
db file async I/O submit     899  25.3  11.2   5.5   2.1   4.6   6.8  43.3   1.3
db file scattered read         3  33.3                                66.7
db file sequential read     1671  45.4   3.2   2.9   4.8   6.6   3.4  33.3    .4
direct path read           30.4K  84.1    .5    .3    .6   1.1   1.6  11.8    .0
direct path read temp      204.4  34.2    .2    .6   2.0   5.6  12.6  44.7    .0
direct path sync               3                                      66.7  33.3
direct path write             37  86.5               2.7               2.7   8.1
direct path write temp     205.1   6.9  15.6   7.4   5.3   7.1   8.9  46.4   2.5
enq: JD - contention           1                                     100.0
enq: KO - fast object chec    47   4.3   8.5   8.5   6.4         8.5  51.1  12.8
enq: TX - index contention     1                         100.0
latch free                   125  45.6   8.8   8.8   5.6   3.2   2.4  24.8    .8
latch: In memory undo latc     2 100.0
latch: cache buffers chain   811  59.8   2.5   1.6   2.2   6.3   3.7  23.7    .2
latch: enqueue hash chains     1                                     100.0
latch: redo allocation         1 100.0
latch: row cache objects       8  50.0        12.5  25.0              12.5
latch: shared pool             5  40.0              20.0              40.0
library cache: mutex X         2  50.0                                50.0
log file parallel write     9160  70.2   1.7   2.2   2.7   3.8   3.7  15.6    .2
log file sync               4081  34.2   3.5   4.4   5.5   7.8   7.6  36.1    .9
os thread startup            139                                58.3  28.8  12.9
read by other session          1                               100.0
reliable message              37  62.2   8.1         2.7   2.7   2.7  21.6
DIAG idle wait              7201                                      93.8   6.2
SQL*Net message from clien 1254.  86.2   4.1   1.2   1.2   2.1    .7   4.3    .3
Space Manager: slave idle    695                                           100.0
Streams AQ: qmn coordinato   378  60.3          .3   1.3    .8         3.2  34.1
Streams AQ: qmn slave idle   248  48.0                                      52.0
class slave wait              19 100.0
dispatcher timer              60                                           100.0
jobq slave wait             7668    .0                               100.0
pmon timer                  1359   8.4          .3          .3    .2   2.2  88.6
rdbms ipc message            20K   4.1    .3   1.4    .9   8.0   1.3  24.1  59.9
shared server idle wait      121                                           100.0
smon timer                    13                                           100.0
          -------------------------------------------------------------

Wait Event Histogram Detail (64 msec to 2 sec)DB/Inst: MYCAR/mycar  Snaps: 94
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> Units for % of Total Waits:
   ms is milliseconds
   s is 1024 milliseconds (approximately 1 second)
-> % of Total Waits: total waits for all wait classes, including Idle
-> % of Total Waits: value of .0 indicates value was <.05%;
   value of null is truly 0
-> Ordered by Event (only non-idle events are displayed)

                                                 % of Total Waits
                                 -----------------------------------------------
                           Waits
                           64ms
Event                      to 2s <32ms <64ms <1/8s <1/4s <1/2s   <1s   <2s  >=2s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
Disk file operations I/O       4  99.0          .3                .5    .3
LGWR wait for redo copy        1  87.5              12.5
SQL*Net break/reset to cli     1  92.9   7.1
SQL*Net message to client     13 100.0    .0    .0    .0    .0    .0
SQL*Net more data from cli     7  99.8    .0    .1    .0
control file parallel writ   499  59.8   7.9  10.7  11.1   7.1   2.5    .7    .2
control file sequential re    15  99.7    .1    .1    .0    .1          .0
cursor: pin S                 10  21.4   7.1   7.1  50.0               7.1   7.1
db file async I/O submit     399  55.4   8.3  13.1  10.3   7.9   3.6   1.1    .2
db file scattered read         2  33.3              66.7
db file sequential read      561  66.3   4.9  12.7   8.7   5.7   1.3    .3    .1
direct path read            3597  88.2   2.2   4.9   3.5   1.2    .2    .0    .0
direct path read temp      91.4K  55.3  21.7  16.1   5.6   1.2    .1    .0
direct path sync               3        33.3                    33.3  33.3
direct path write              3  89.2                     2.7         5.4   2.7
direct path write temp     96.9K  51.2   9.3  13.3  14.0   7.9   1.9    .9   1.6
enq: JD - contention           1                               100.0
enq: KO - fast object chec    27  36.2   8.5   6.4  10.6  19.1   6.4   6.4   6.4
latch free                    31  74.4   4.0   4.0   6.4   5.6   4.8          .8
latch: cache buffers chain   194  76.1   4.1   6.7   7.5   4.4   1.0    .2
latch: enqueue hash chains     1                   100.0
latch: row cache objects       1  87.5        12.5
latch: shared pool             2  60.0              20.0        20.0
library cache: mutex X         1  50.0  50.0
log file parallel write     1445  84.2   4.0   4.7   3.5   2.6    .8    .1    .0
log file sync               1500  63.0   8.4   9.2   7.8   7.0   3.8    .6    .2
os thread startup             43  58.3  15.1   5.8   2.9   1.4   3.6   2.2  10.8
reliable message               8  78.4  10.8         8.1   2.7
          -------------------------------------------------------------

Wait Event Histogram Detail (4 sec to 2 min)DB/Inst: MYCAR/mycar  Snaps: 9474
-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
-> Units for % of Total Waits:
   s is 1024 milliseconds (approximately 1 second)
   m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
-> % of Total Waits: total waits for all wait classes, including Idle
-> % of Total Waits: value of .0 indicates value was <.05%;
   value of null is truly 0
-> Ordered by Event (only non-idle events are displayed)

                                                 % of Total Waits
                                 -----------------------------------------------
                           Waits
                            4s
Event                      to 2m   <2s   <4s   <8s  <16s  <32s  < 1m  < 2m  >=2m
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
control file parallel writ     2  99.8    .2
cursor: pin S                  1  92.9   7.1
db file async I/O submit       2  99.8    .2
db file sequential read        2  99.9    .1
direct path read               1 100.0    .0
direct path write              1  97.3   2.7
direct path write temp      3285  98.4    .8    .6    .2    .0
enq: KO - fast object chec     3  93.6   6.4
latch free                     1  99.2    .8
log file parallel write        2 100.0    .0
log file sync                 10  99.8    .2    .0
os thread startup             15  89.2   6.5   3.6    .7
          -------------------------------------------------------------

Wait Event Histogram Detail (4 min to 1 hr)DB/Inst: MYCAR/mycar  Snaps: 9474-

                  No data exists for this section of the report.
          -------------------------------------------------------------

Service Statistics                     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by DB Time

                                                           Physical      Logical
Service Name                  DB Time (s)   DB CPU (s)    Reads (K)    Reads (K)
---------------------------- ------------ ------------ ------------ ------------
SYS$USERS                          59,425        6,676        7,845      367,429
SYS$BACKGROUND                          0            0            0           25
mycar                                   0            0            0            0
mycarXDB                                0            0            0            0
          -------------------------------------------------------------

Service Wait Class Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Wait Class info for services in the Service Statistics section.
-> Total Waits and Time Waited displayed for the following wait
   classes:  User I/O, Concurrency, Administrative, Network
-> Time Waited (Wt Time) in seconds

Service Name
----------------------------------------------------------------
 User I/O  User I/O  Concurcy  Concurcy     Admin     Admin   Network   Network
Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
SYS$USERS
   441860     47430       842        48         0         0   1303138         7
SYS$BACKGROUND
      231         9       140        80         0         0         0         0
mycar
        0         0         0         0         0         0         0         0
          -------------------------------------------------------------

SQL ordered by Elapsed Time            DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100
-> %Total - Elapsed Time  as a percentage of Total DB time
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for   98.3% of Total DB Time (s):          59,427
-> Captured PL/SQL account for    0.1% of Total DB Time (s):          59,427

        Elapsed                  Elapsed Time
        Time (s)    Executions  per Exec (s)  %Total   %CPU    %IO    SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
        47,321.8            109        434.14   79.6     .4   98.3 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

         8,439.3         15,098          0.56   14.2   64.4     .0 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
 AND IP.End_Ip1 >= ip_to_number(:2)

           595.9             56         10.64    1.0    4.0   91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_

           437.5              1        437.50     .7    7.9     .0 699fq02xtmfp0
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

           254.6             21         12.13     .4    5.0   93.4 7c9aurkrt70vn
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

           198.8          4,806          0.04     .3   93.4     .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc


           190.3         18,949          0.01     .3   76.2     .0 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc


            95.1          6,451          0.01     .2   80.1     .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1

            81.9          5,275          0.02     .1   81.1     .0 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

            66.2          5,275          0.01     .1   87.4     .0 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join

          -------------------------------------------------------------

SQL ordered by CPU Time                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> %Total - CPU Time      as a percentage of Total DB CPU
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for   97.4% of Total CPU Time (s):           6,679
-> Captured PL/SQL account for    0.0% of Total CPU Time (s):           6,679

    CPU                   CPU per           Elapsed
  Time (s)  Executions    Exec (s) %Total   Time (s)   %CPU    %IO    SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
   5,431.3       15,098       0.36   81.3    8,439.3   64.4     .0 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
 AND IP.End_Ip1 >= ip_to_number(:2)

     209.7          109       1.92    3.1   47,321.8     .4   98.3 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

     185.7        4,806       0.04    2.8      198.8   93.4     .0 dx9uj64072dw7
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc


     145.0       18,949       0.01    2.2      190.3   76.2     .0 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc


      76.2        6,451       0.01    1.1       95.1   80.1     .0 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1

      66.5        5,275       0.01    1.0       81.9   81.1     .0 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

      57.8        5,275       0.01    0.9       66.2   87.4     .0 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join

      34.4            1      34.39    0.5      437.5    7.9     .0 699fq02xtmfp0
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

      33.8            1      33.80    0.5       37.4   90.4     .0 7hcv97jgzd6zw
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

      31.2            1      31.24    0.5       45.2   69.2     .0 9734c447d6rvf
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

          -------------------------------------------------------------

SQL ordered by User I/O Wait Time      DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> %Total - User I/O Time as a percentage of Total User I/O Wait time
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Captured SQL account for  100.0% of Total User I/O Wait Time (s):          47
-> Captured PL/SQL account for    0.0% of Total User I/O Wait Time (s):

  User I/O                UIO per           Elapsed
  Time (s)  Executions    Exec (s) %Total   Time (s)   %CPU    %IO    SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
  46,527.6          109     426.86   98.1   47,321.8     .4   98.3 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

     545.0           56       9.73    1.1      595.9    4.0   91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_

     237.9           21      11.33    0.5      254.6    5.0   93.4 7c9aurkrt70vn
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

      48.7            8       6.08    0.1       49.8    1.0   97.8 0j5z1mkgtqw4s
select n.*,c.FAULT_CODE_ID_BYNAME from df_fault_code_desc c join df_fault_code_n
ame_desc n on (c.version_detail_id = n.version_detail_id and c.fault_co
de_id = n.fault_code_id) where n.version_detail_id=:1 and n.lan_id=:2 o
rder by n.fault_code_id asc

      35.7           26       1.37    0.1       37.6    1.2   95.1 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id

       7.7            3       2.56    0.0       48.2     .2   15.9 fdjtrdaz8hpvg
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SE
L$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id,
dbid, instance_number, sample_id, sample_time , session_id, session_serial#, ses
sion_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matchi

       5.0           60       0.08    0.0       43.9    3.7   11.4 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

       4.1        3,534       0.00    0.0        4.5    5.5   91.9 dnx1ugz1qwd2p
insert into OPERATE_LOG (LOG_ID,LOG_TYPE, OPERATE_DATE, OPERATE_DESC, OPERATE_RE
SULT, REMOTE_ADDRESS, USER_ID, USER_NAME,CLASS_NAME,METHOD_NAME) val
ues (:1,:2, :3, :4, :5, :6, :7, :8,:9,:10)

       3.3          236       0.01    0.0        5.3     .7   62.9 8vwv6hx92ymmm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN
G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2
AND COLLECTION_TIMESTAMP < :B1

       2.2        3,208       0.00    0.0        6.1    6.6   36.0 59ygsb7wnbc69
insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID,DOWNLOAD_IP, DOWNLOAD_PERSON, DOWN
LOAD_TIME, LAN_Id, SOFT_ID, SOFT_NAME, SOFT_TYPE, USER_ID, VERSION_DETAIL_ID, VE
RSION_ID, VERSION_NO, SERIAL_NO) values (:1,:2, :3, :4, :5, :6, :7,
:8, :9, :10, :11, :12,:13)

          -------------------------------------------------------------

SQL ordered by Gets                    DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> %Total - Buffer Gets   as a percentage of Total Buffer Gets
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Total Buffer Gets:     367,489,468
-> Captured SQL account for   91.9% of Total

     Buffer                 Gets              Elapsed
      Gets   Executions   per Exec   %Total   Time (s)   %CPU    %IO    SQL Id
----------- ----------- ------------ ------ ---------- ------ ------ -----------
2.04298E+08       4,806     42,508.9   55.6      198.8   93.4     .0 dx9uj64072d
select * from SYS_PRODUCT_BURN_INFOR where serial_no=:1 order by id desc


 29,465,698      18,949      1,555.0    8.0      190.3   76.2     .0 0ay7wjuhgzj
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc


 16,976,942         109    155,751.8    4.6   47,321.8     .4   98.3 9kyafghcc1x
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

 12,912,070       6,451      2,001.6    3.5       95.1   80.1     .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1

 10,708,610       5,275      2,030.1    2.9       81.9   81.1     .0 0nrknqc0j9k
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

 10,589,805       5,275      2,007.5    2.9       66.2   87.4     .0 1qk46xprzhv
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join

  4,172,577       2,735      1,525.6    1.1       17.9   53.4     .0 83trawx9dw9
select decode(ld.DISPLAY_NAME, null,l.LAN_NAME, ld.DISPLAY_NAME) LAN_NAME, d.* f
rom DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d.LAN_ID=l.LAN_I
D left join SYS_LAN_DISPLAY ld on ld.LAN_ID=l.LAN_ID
 AND (ld.DISP_LAN_ID = :1) WHERE (d.VERSION_ID

  3,594,736      33,484        107.4    1.0       62.5   36.9     .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1

  3,363,965           1  3,363,965.0    0.9      437.5    7.9     .0 699fq02xtmf
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

  3,363,920           1  3,363,920.0    0.9       37.4   90.4     .0 7hcv97jgzd6
Module: w3wp.exe
select * from (select rownum row_num,stream_display_name,stream_display_name_en,
version_detail_id,data_stream_id,unified_id,data_stream_unit_id,unit_name,desc_i
d,update_time,create_person,UNIFIED_UNIT_ID from (select b.stream_display_name,c
.stream_display_name stream_display_name_en ,a.version_detail_id,a.data_stream_i

          -------------------------------------------------------------

SQL ordered by Reads                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> %Total - Physical Reads as a percentage of Total Disk Reads
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Total Disk Reads:       7,845,258
-> Captured SQL account for   93.5% of Total

   Physical              Reads              Elapsed
      Reads  Executions per Exec   %Total   Time (s)   %CPU    %IO    SQL Id
----------- ----------- ---------- ------ ---------- ------ ------ -------------
  4,121,807         109   37,814.7   52.5   47,321.8     .4   98.3 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

  3,192,952          56   57,017.0   40.7      595.9    4.0   91.5 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_

     15,335          21      730.2    0.2      254.6    5.0   93.4 7c9aurkrt70vn
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

        968           8      121.0    0.0       49.8    1.0   97.8 0j5z1mkgtqw4s
select n.*,c.FAULT_CODE_ID_BYNAME from df_fault_code_desc c join df_fault_code_n
ame_desc n on (c.version_detail_id = n.version_detail_id and c.fault_co
de_id = n.fault_code_id) where n.version_detail_id=:1 and n.lan_id=:2 o
rder by n.fault_code_id asc

        218          26        8.4    0.0       37.6    1.2   95.1 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id

         87       3,208        0.0    0.0        6.1    6.6   36.0 59ygsb7wnbc69
insert into DIAG_DOWNLOAD_RECORD (DOWNLOAD_ID,DOWNLOAD_IP, DOWNLOAD_PERSON, DOWN
LOAD_TIME, LAN_Id, SOFT_ID, SOFT_NAME, SOFT_TYPE, USER_ID, VERSION_DETAIL_ID, VE
RSION_ID, VERSION_NO, SERIAL_NO) values (:1,:2, :3, :4, :5, :6, :7,
:8, :9, :10, :11, :12,:13)

         61       3,534        0.0    0.0        4.5    5.5   91.9 dnx1ugz1qwd2p
insert into OPERATE_LOG (LOG_ID,LOG_TYPE, OPERATE_DATE, OPERATE_DESC, OPERATE_RE
SULT, REMOTE_ADDRESS, USER_ID, USER_NAME,CLASS_NAME,METHOD_NAME) val
ues (:1,:2, :3, :4, :5, :6, :7, :8,:9,:10)

         13         174        0.1    0.0       24.5   72.3    8.5 89nfp8fv1y8vw
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
 AND sd.LAN_ID = :1

          8          60        0.1    0.0       43.9    3.7   11.4 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

          7       5,076        0.0    0.0        1.4   11.0   41.1 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial

          -------------------------------------------------------------

SQL ordered by Physical Reads (UnOptimized)DB/Inst: MYCAR/mycar  Snaps: 9474-
-> UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
-> %Opt   - Optimized Reads as percentage of SQL Read Requests
-> %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
-> Total Physical Read Requests:         236,503
-> Captured SQL account for   97.4% of Total
-> Total UnOptimized Read Requests:         236,503
-> Captured SQL account for   97.4% of Total
-> Total Optimized Read Requests:               1
-> Captured SQL account for    0.0% of Total

UnOptimized   Physical              UnOptimized
  Read Reqs   Read Reqs Executions Reqs per Exe   %Opt %Total    SQL Id
----------- ----------- ---------- ------------ ------ ------ -------------
    203,339     203,339        109      1,865.5    0.0   86.0 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

     25,912      25,912         56        462.7    0.0   11.0 asdsn1yqzjk0r
select r.DOWNLOAD_ID,r.VERSION_ID,r.SOFT_ID,r.VERSION_NO,r.VERSION_DETAIL_ID,r.U
SER_ID,r.LAN_ID,r.DOWNLOAD_PERSON,r.DOWNLOAD_TIME, r.SOFT_TYPE,r.DOWNLOA
D_IP,r.SERIAL_NO,l.LAN_NAME as LAN_NAME,(select soft_name from diag_soft where s
oft_id = r.soft_id) as SOFT_NAME from DIAG_DOWNLOAD_RECORD r join SYS_

      1,065       1,065         21         50.7    0.0    0.5 7c9aurkrt70vn
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

         60          60         26          2.3    0.0    0.0 0pv12svs6kn6t
select n.* from df_text_name_desc n join df_text_desc t on (t.version_detail_id=
n.version_detail_id and t.text_id=n.text_id) where t.version_detail_id=:
1 and n.lan_id=:2 order by t.text_id

         20          20         60          0.3    0.0    0.0 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         10          10        174          0.1    0.0    0.0 89nfp8fv1y8vw
SELECT COUNT(*) AS c from (select max(version_no) version_no, soft_id from DIAG
_SOFT_VERSION WHERE vALID_FLAG=1 group by soft_id)vv join DIAG_SOFT s on
s.soft_id=vv.soft_id left join DIAG_SOFT_DESC sd on (sd.SOFT_ID=s.SOFT_ID
 AND sd.LAN_ID = :1

          7           7      5,076          0.0    0.0    0.0 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial

          5           5     62,544          0.0    0.0    0.0 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1

          4           4        155          0.0    0.0    0.0 6mtnm8nm00gan
select * from DIAG_USER_SOFT_CENTER where SOFT_ID = :1 and SERIAL_NO = :2


          1           1          1          1.0    0.0    0.0 ab5nygnt6v4m0
Module: w3wp.exe
update DF_DATA_STREAM_DESC set unified_id='00000180',update_time=to_date('2013-6
-24 16:21:21', 'yyyy-mm-dd HH24:MI:SS'),create_person='閭撳▉' where version_detai
l
_id in(select version_detail_id from diag_soft_version_detail where version_id i
n(select version_id from diag_soft_version_detail where version_detail_id in(35

          -------------------------------------------------------------

SQL ordered by Executions              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Total Executions:         493,608
-> Captured SQL account for   96.0% of Total

                                              Elapsed
 Executions   Rows Processed  Rows per Exec   Time (s)   %CPU    %IO    SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
     147,140         147,142            1.0       12.5   32.8     .0 520mkxqpf15
select 1 from dual

      62,544          62,372            1.0       17.1   16.2    2.8 5nggumnh49y
select * from SYS_PRODUCT where SERIAL_NO = :1

      34,064          34,063            1.0        3.8   36.5     .0 bm7qdt1qj4c
select l.LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d
.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1

      33,484         116,019            3.5       62.5   36.9     .0 4xbg42tpyp0
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1

      28,060          11,886            0.4        7.6   52.6     .0 5ky6k3fa3cu
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3

      18,949         592,040           31.2      190.3   76.2     .0 0ay7wjuhgzj
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc


      15,101           1,034            0.1       11.0   10.0     .0 9arur6gysf1
select t.*,'' as name from sys_product_ip_rule t where t.product_id = :1 and
(t.start_time is null or t.start_time<= sysdate) and (t.end_time is null or t.e
nd_time>sysdate )

      15,098          15,026            1.0    8,439.3   64.4     .0 5spk48gcmhf
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
 AND IP.End_Ip1 >= ip_to_number(:2)

      14,067          14,041            1.0       38.7   13.1     .0 87hfb2vvgt6
select 1 from sys_area_country where 1=1 AND DOWNLOAD
_AREA_ID = (select distinct t1.download_area_id from sys_vender t1
 join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.fili
ale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) jo

       8,205           8,203            1.0        0.5   54.4     .0 1qp4my7430p
select * from DIAG_SOFT_VERSION where VERSION_ID = :1

       8,179           8,179            1.0        0.5   56.7     .0 a6j566u48p8
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1

       8,109               0            0.0        0.7   46.4     .2 drvvh1sx3r1
select l.LAN_NAME, d.* from SYS_PDT_TYPE_DESC d, sys_lan l where d.LAN_ID=l.LAN_
ID AND d.PDT_TYPE_ID = :1

       6,451               0            0.0        1.0   47.6     .6 12gmchtj8pp
select usd.*,s.soft_name as SOFT_NAME,su.cc as cc,decode(mu.user_name,null,'鏈?煡
',
mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SY
S_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_i
d = usd.last_upd_user_id join DIAG_SOFT s on us

       6,451          22,311            3.5       95.1   80.1     .0 f6j95rdnz0m
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1

       5,275          20,318            3.9       81.9   81.1     .0 0nrknqc0j9k
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
SQL ordered by Executions              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> %CPU   - CPU Time      as a percentage of Elapsed Time
-> %IO    - User I/O Time as a percentage of Elapsed Time
-> Total Executions:         493,608
-> Captured SQL account for   96.0% of Total

                                              Elapsed
 Executions   Rows Processed  Rows per Exec   Time (s)   %CPU    %IO    SQL Id
------------ --------------- -------------- ---------- ------ ------ -----------
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

       5,275           5,260            1.0       66.2   87.4     .0 1qk46xprzhv
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join

       5,076           5,076            1.0        1.4   11.0   41.1 c00br6fharc
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial

       4,966         117,688           23.7       14.3   47.7     .0 2asdyf7j381
select s.*, l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.L
AN_ID where s.SOFT_ID=:1

          -------------------------------------------------------------

SQL ordered by Parse Calls             DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Parse Calls:         488,968
-> Captured SQL account for   96.6% of Total

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
     147,141      147,140     30.09 520mkxqpf15q8
select 1 from dual

      62,545       62,544     12.79 5nggumnh49yzc
select * from SYS_PRODUCT where SERIAL_NO = :1

      34,064       34,064      6.97 bm7qdt1qj4cg0
select l.LAN_NAME, d.* from DIAG_SOFT_VERSION_DETAIL d left join sys_lan l on d
.LAN_ID=l.LAN_ID where VERSION_DETAIL_ID = :1

      33,483       33,484      6.85 4xbg42tpyp0gm
select * from SYS_PRODUCT_LANG_CONSTRAINT where SERIAL_NO = :1

      28,060       28,060      5.74 5ky6k3fa3cu3y
select * from SYS_VENDER_LANG_CONSTRAINT where (VENDER_ID = :1 or VENDER_ID = :2
) and LAN_ID = :3

      18,948       18,949      3.88 0ay7wjuhgzj9k
select d.* from diag_soft_version_detail d left join diag_soft_version v on v.ve
rsion_id = d.version_id where v.soft_id = :1 order by d.upload_time desc


      15,101       15,101      3.09 9arur6gysf1z0
select t.*,'' as name from sys_product_ip_rule t where t.product_id = :1 and
(t.start_time is null or t.start_time<= sysdate) and (t.end_time is null or t.e
nd_time>sysdate )

      15,098       15,098      3.09 5spk48gcmhf2g
SELECT * FROM COUNTRY_CODE C JOIN COUNTRY_IP_RANGE IP ON C
.COUNTRY_CODE = ip.country_code WHERE IP.Start_Ip1 <= ip_to_number(:1)
 AND IP.End_Ip1 >= ip_to_number(:2)

      14,067       14,067      2.88 87hfb2vvgt6tp
select 1 from sys_area_country where 1=1 AND DOWNLOAD
_AREA_ID = (select distinct t1.download_area_id from sys_vender t1
 join sys_vender t2 ON (t2.user_type=2 and t1.vender_id = t2.fili
ale_id) or(t2.user_type=3 and t1.vender_id =t2.vender_id) jo

       8,205        8,205      1.68 1qp4my7430ph5
select * from DIAG_SOFT_VERSION where VERSION_ID = :1

       8,179        8,179      1.67 a6j566u48p8nf
select * from SYS_PDT_TYPE where PDT_TYPE_ID = :1

       8,109        8,109      1.66 drvvh1sx3r1my
select l.LAN_NAME, d.* from SYS_PDT_TYPE_DESC d, sys_lan l where d.LAN_ID=l.LAN_
ID AND d.PDT_TYPE_ID = :1

       6,451        6,451      1.32 12gmchtj8pp10
select usd.*,s.soft_name as SOFT_NAME,su.cc as cc,decode(mu.user_name,null,'鏈?煡
',
mu.user_name) as LAST_UPD_USER_NAME from USER_DOWN_SOFT_LIMITS usd join SY
S_USER su on su.user_id = usd.user_id left join sys_manager_user mu on mu.user_i
d = usd.last_upd_user_id join DIAG_SOFT s on us

       6,451        6,451      1.32 f6j95rdnz0mmw
select t.* from sys_product t where t.user_id=:1 and t.pdt_state = 1

       5,275        5,275      1.08 0nrknqc0j9kgr
select * from ( select p.*,pt.PDT_TYPE,sc.name,v.VENDER_NAME,f.VENDER_NAME as FI
LIAL_ENAME,c.customer_name from SYS_PRODUCT p left join SYS_PDT_
SQL ordered by Parse Calls             DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Parse Calls:         488,968
-> Captured SQL account for   96.6% of Total

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
TYPE pt on p.pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc o
n p.SOFT_CONF_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID

       5,275        5,275      1.08 1qk46xprzhvy6
SELECT COUNT(*) AS c from SYS_PRODUCT p left join SYS_PDT_TYPE pt on p.
pdt_type_id = pt.pdt_type_id left join SYS_SOFT_CONF sc on p.SOFT_CONF
_ID = sc.SOFT_CONF_ID left join sys_vender v on p.VENDER_ID = v.VENDER_I
D left join sys_vender f on p.filiale_id = f.VENDER_ID left join

       5,076        5,076      1.04 c00br6fharcvs
select c.* from diag_user_soft_center c join diag_soft s on s.soft_id = c.soft_i
d join diag_soft_version v on v.soft_id = s.soft_id join diag_
soft_version_detail d on d.version_id = v.version_id join sys_product p
on p.serial_no = c.serial_no where d.version_detail_id = :1 and c.serial

       4,966        4,966      1.02 2asdyf7j381tv
select s.*, l.LAN_NAME from DIAG_SOFT_DESC s left join sys_lan l on s.LAN_ID=l.L
AN_ID where s.SOFT_ID=:1

          -------------------------------------------------------------

SQL ordered by Sharable Memory         DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)  Executions   % Total    SQL Id
---------------- ------------ -------- -------------
       1,920,331            1     0.14 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE

       1,749,568           10     0.13 bn4b3vjw2mj3u
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LET
IME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1
, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( s
elect a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last

       1,241,030          129     0.09 fsbqktj5vw6n9
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags,
 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date,
 a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job s
ch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date,

          -------------------------------------------------------------

SQL ordered by Version Count           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
     107            1 5s34t44u10q4g
SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name a
s last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a,
 wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor
_id(+) and a.last_exec_name = e.name(+) and a.id = :1

     102            1 c8gnrhxma4tas
SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1

     100            2 69k5bhm12sz98
SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_
name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time
 THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as beg
in_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((ca

      91            1 gdn3ysuyssf82
SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1

      90            2 5rygsj4dbw6jt
insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, dr
op_segments) values (:1, :2, :3, :4, :5, :6, :7)

      80          745 4m7m0t6fjcs5x
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1

      79          191 3c1kubcdjnppq
update sys.col_usage$ set equality_preds = equality_preds + decode(bitan
d(:flag,1),0,0,1), equijoin_preds = equijoin_preds + decode(bitand(:flag
,2),0,0,1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag,4),0,0
,1), range_preds = range_preds + decode(bitand(:flag,8),0,0,1),

      75          195 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

      73          129 fsbqktj5vw6n9
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags,
 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date,
 a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job s
ch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date,

      72          147 18naypzfmabd6
Module: EM_PING
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))

      67            1 8p9z2ztb272bm
 SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as
 cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM
WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_numb
er = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status

      67            6 fcb5u7n0r523m
SELECT NVL(AVG((VALUE*1000.0)/DURATION),0), NVL((((SUM(DURATION)/(60*1000))/60)*
100),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 =
 B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.
IS_TOTAL='Y' AND A.DURATION > 0

SQL ordered by Version Count           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
      67            6 fcb5u7n0r523m
SELECT NVL(AVG((VALUE*1000.0)/DURATION),0), NVL((((SUM(DURATION)/(60*1000))/60)*
100),0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 =
 B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.
IS_TOTAL='Y' AND A.DURATION > 0

      66           36 94pxkbat2zku7
SELECT NVL(SUM(VALUE),0),COUNT(*) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE NAME =
:B1 || '_TOTAL_DELIVERY_TIME' AND TIME > (SYSDATE-(1/(24*6)))

      65          236 8vwv6hx92ymmm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRIN
G_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2
AND COLLECTION_TIMESTAMP < :B1

      65           10 bn4b3vjw2mj3u
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LET
IME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1
, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( s
elect a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last

      63            1 23nad9x295gkf
SELECT (m.current_size / 1048576) as sizemb, case when cast(m.last
_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as chang
ed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT b
uffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DE

      63            1 6wm3n4d7bnddg
 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as ti
me_secs, operation FROM ( SELECT 1 as source, trunc(
(sysdate - cast(ll.log_date as date)) * 86400) as time_secs,
 decode(ll.operation, 'OPEN', 0

      57           67 47a50dvdgnxc2
update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_dat
e = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date,sysdate)) where j
ob=:4

      54            2 dcvnnc6bjqshc
SELECT TASK_ID, TASK_CLASS FROM MGMT_COLLECTION_TASKS C WHERE FREQUENCY_CODE !=
7 AND NOT EXISTS (SELECT 1 FROM MGMT_TASK_QTABLE Q WHERE Q.USER_DATA.TASK_ID = C
.TASK_ID) FOR UPDATE

      53            5 8mvxss6cn9q8t
SELECT TASK_CLASS,COUNT(*) PENDING FROM MGMT_COLLECTION_TASKS WHERE NEXT_COLLECT
ION_TIMESTAMP <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND FREQUENCY_CODE != :B1 GROUP B
Y TASK_CLASS

      53          236 gfdn12rn0fg3m
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :
B1

      52          710 5ms6rbzdnq16t
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n
ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1
= :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.d
b_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 an

      51           70 b2gnxm5z6r51n
lock table sys.col_usage$ in exclusive mode nowait
SQL ordered by Version Count           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------

      51          195 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
 + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn

      50            1 0ut2yw7mxf0aq
insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, be
gin_interval_time, end_interval_time, snap_level, status, error_count, bl_mov
ed, snap_flag) values (:snap_id, :dbid, :instance_number, :startup_time, :
begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1)

      46           32 crwtm662ycm4w
select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 =
 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) o
r (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))

      45            3 ab3swhv5g138y
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_
SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags
, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.pr
iority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_i

      41            1 7wwd9zjbvggmh
INSERT INTO SYS.WRI$_ADV_TASKS (ID,OWNER#,OWNER_NAME,NAME,DESCRIPTION,ADVISOR_ID
,ADVISOR_NAME, CTIME,MTIME,PARENT_ID,PARENT_REC_ID, PROPERTY,VERSION, EXEC_START
,EXEC_END,STATUS,STATUS_MSG_ID,PCT_COMPLETION_TIME, PROGRESS_METRIC,METRIC_UNITS
,ACTIVITY_COUNTER,REC_COUNT,ERROR_MSG#, SOURCE,HOW_CREATED ) VALUES (:B11 ,:B10

      39            1 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE

      39            1 gjm43un5cy843
SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024
)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME
, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTI
NCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERE

      34        3,067 3jdq13ju0b2z9
select v.* from DIAG_SOFT_VERSION v where exists (select 'X' from DIA
G_SOFT_VERSION_DETAIL d where v.VERSION_ID=d.VERSION_ID and d.CHECK_STATE=2)
 and exists(select 'X' from DIAG_SOFT s where s.SOFT_ID=v.SOFT_ID and s.VA
LID_FLAG=1) and v.VALID_FLAG=1 and v.SOFT_ID = :1 AND

      29          109 9kyafghcc1xh6
select distinct temp.SOFT_ID, temp.SOFT_NAME, temp.VERSION_NO, temp.LAN_ID, temp
.SOFT_DESC, temp.VERSION_DETAIL_ID, temp.REMARK,temp.FILE_SIZE,to_char(temp.UPLO
AD_TIME,'YYYY-MM-DD HH24:MI:SS') as SOFT_UPDATE_TIME, decode(temp.VEHI
CLE_TYPE_ID, null,1, temp.VEHICLE_TYPE_ID) as VEHICLE_TYPE, decode(temp.SOFT_APP

      29           67 cumjq42201t37
select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv,
 env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$
u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and
 powner = u2.name and cowner = u3.name

SQL ordered by Version Count           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
      26            1 1cq3qr774cu45
insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetyp
e_id, small_read_megabytes, small_write_megabytes, large_read_megabytes,
 large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_r
eqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_wr

      25            6 2rq8p9b3f1n82
SELECT COUNT(BROKEN) FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEV
ERITIES'

          -------------------------------------------------------------

Instance Activity Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by statistic name

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
Batched IO (bound) vector count                  43            0.0           0.0
Batched IO (full) vector count                    0            0.0           0.0
Batched IO block miss count                     129            0.0           0.0
Batched IO buffer defrag count                    0            0.0           0.0
Batched IO double miss count                      0            0.0           0.0
Batched IO same unit count                       86            0.0           0.0
Batched IO single block count                    43            0.0           0.0
Batched IO slow jump count                        0            0.0           0.0
Batched IO vector block count                     0            0.0           0.0
Batched IO vector read count                      0            0.0           0.0
Block Cleanout Optim referenced                   4            0.0           0.0
CCursor + sql area evicted                        3            0.0           0.0
CPU used by this session                    664,027          183.2         167.7
CPU used when call started                  663,739          183.1         167.7
CR blocks created                               302            0.1           0.1
Cached Commit SCN referenced                    171            0.1           0.0
Commit SCN cached                                76            0.0           0.0
DB time                                   6,296,463        1,737.3       1,590.4
DBWR checkpoint buffers written               3,825            1.1           1.0
DBWR checkpoints                                 47            0.0           0.0
DBWR object drop buffers written                  0            0.0           0.0
DBWR revisited being-written buf                  0            0.0           0.0
DBWR tablespace checkpoint buffe                306            0.1           0.1
DBWR thread checkpoint buffers w                  0            0.0           0.0
DBWR transaction table writes                   110            0.0           0.0
DBWR undo block writes                          551            0.2           0.1
DFO trees parallelized                            0            0.0           0.0
HSC Heap Segment Block Changes               11,489            3.2           2.9
HSC IDL Compressed Blocks                         0            0.0           0.0
Heap Segment Array Inserts                      122            0.0           0.0
Heap Segment Array Updates                      101            0.0           0.0
IMU CR rollbacks                                208            0.1           0.1
IMU Flushes                                   1,479            0.4           0.4
IMU Redo allocation size                  3,375,896          931.5         852.7
IMU commits                                   2,539            0.7           0.6
IMU contention                                   75            0.0           0.0
IMU ktichg flush                                  0            0.0           0.0
IMU pool not allocated                            0            0.0           0.0
IMU recursive-transaction flush                   0            0.0           0.0
IMU undo allocation size                  7,980,112        2,201.9       2,015.7
IMU- failed to get a private str                  0            0.0           0.0
LOB table id lookup cache misses                  0            0.0           0.0
Number of read IOs issued                    30,455            8.4           7.7
PX local messages recv'd                          0            0.0           0.0
PX local messages sent                            0            0.0           0.0
Parallel operations not downgrad                  0            0.0           0.0
RowCR - row contention                            0            0.0           0.0
RowCR attempts                                  135            0.0           0.0
RowCR hits                                      135            0.0           0.0
SMON posted for dropping temp se                  0            0.0           0.0
SMON posted for undo segment rec                  0            0.0           0.0
SMON posted for undo segment shr                  0            0.0           0.0
SQL*Net roundtrips to/from clien          1,253,422          345.8         316.6
TBS Extension: bytes extended                     0            0.0           0.0
TBS Extension: files extended                     0            0.0           0.0
TBS Extension: tasks created                      0            0.0           0.0
TBS Extension: tasks executed                     0            0.0           0.0
active txn count during cleanout                838            0.2           0.2
application wait time                         1,871            0.5           0.5
auto extends on undo tablespace                   0            0.0           0.0
Instance Activity Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by statistic name

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
background checkpoints completed                  0            0.0           0.0
background checkpoints started                    0            0.0           0.0
background timeouts                          15,225            4.2           3.9
branch node splits                                0            0.0           0.0
buffer is not pinned count              241,772,200       66,709.3      61,069.0
buffer is pinned count                1,277,472,545      352,477.6     322,675.6
bytes received via SQL*Net from         125,342,604       34,584.3      31,660.2
bytes sent via SQL*Net to client        505,510,828      139,479.5     127,686.5
calls to get snapshot scn: kcmgs            503,396          138.9         127.2
calls to kcmgas                               6,403            1.8           1.6
calls to kcmgcs                             937,861          258.8         236.9
cell physical IO interconnect by     98,530,077,184   27,186,215.7  24,887,617.4
change write time                               251            0.1           0.1
cleanout - number of ktugct call                420            0.1           0.1
cleanouts and rollbacks - consis                141            0.0           0.0
cleanouts only - consistent read                 15            0.0           0.0
cluster key scan block gets                   2,247            0.6           0.6
cluster key scans                             2,001            0.6           0.5
commit batch performed                            0            0.0           0.0
commit batch requested                            0            0.0           0.0
commit batch/immediate performed                  1            0.0           0.0
commit batch/immediate requested                  1            0.0           0.0
commit cleanout failures: block                   0            0.0           0.0
commit cleanout failures: buffer                  0            0.0           0.0
commit cleanout failures: callba                  7            0.0           0.0
commit cleanout failures: cannot                 53            0.0           0.0
commit cleanouts                             14,591            4.0           3.7
commit cleanouts successfully co             14,531            4.0           3.7
commit immediate performed                        1            0.0           0.0
commit immediate requested                        1            0.0           0.0
commit txn count during cleanout                839            0.2           0.2
concurrency wait time                        12,774            3.5           3.2
consistent changes                            1,716            0.5           0.4
consistent gets                         367,416,142      101,376.7      92,805.3
consistent gets - examination             5,877,821        1,621.8       1,484.7
consistent gets direct                    3,706,483        1,022.7         936.2
consistent gets from cache              363,709,677      100,354.0      91,869.1
consistent gets from cache (fast        345,361,764       95,291.5      87,234.6
cursor authentications                          121            0.0           0.0
data blocks consistent reads - u              1,756            0.5           0.4
db block changes                             55,393           15.3          14.0
db block gets                                74,569           20.6          18.8
db block gets direct                            243            0.1           0.1
db block gets from cache                     74,326           20.5          18.8
db block gets from cache (fastpa             20,388            5.6           5.2
deferred (CURRENT) block cleanou              9,101            2.5           2.3
dirty buffers inspected                           0            0.0           0.0
enqueue conversions                             964            0.3           0.2
enqueue deadlocks                                 0            0.0           0.0
enqueue releases                             84,412           23.3          21.3
enqueue requests                             84,413           23.3          21.3
enqueue timeouts                                  0            0.0           0.0
enqueue waits                                    49            0.0           0.0
exchange deadlocks                                0            0.0           0.0
execute count                               493,608          136.2         124.7
failed probes on index block rec                  0            0.0           0.0
file io service time                              0            0.0           0.0
file io wait time                       220,351,278       60,798.9      55,658.3
free buffer inspected                         3,297            0.9           0.8
free buffer requested                         3,516            1.0           0.9
Instance Activity Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by statistic name

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
global undo segment hints helped                  0            0.0           0.0
global undo segment hints were s                  0            0.0           0.0
heap block compress                             102            0.0           0.0
hot buffers moved to head of LRU              2,306            0.6           0.6
immediate (CR) block cleanout ap                156            0.0           0.0
immediate (CURRENT) block cleano                779            0.2           0.2
index crx upgrade (positioned)                   41            0.0           0.0
index crx upgrade (prefetch)                      0            0.0           0.0
index fast full scans (full)                    808            0.2           0.2
index fetch by key                        9,985,224        2,755.1       2,522.2
index scans kdiixs1                       1,896,217          523.2         479.0
leaf node 90-10 splits                           64            0.0           0.0
leaf node splits                                 73            0.0           0.0
lob reads                                       415            0.1           0.1
lob writes                                       64            0.0           0.0
lob writes unaligned                             64            0.0           0.0
logons cumulative                               266            0.1           0.1
max cf enq hold time                             90            0.0           0.0
messages received                             6,044            1.7           1.5
messages sent                                 6,044            1.7           1.5
min active SCN optimization appl                 16            0.0           0.0
no buffer to keep pinned count                1,232            0.3           0.3
no work - consistent read gets          360,471,291       99,460.5      91,051.1
non-idle wait count                       1,852,032          511.0         467.8
non-idle wait time                        4,853,208        1,339.1       1,225.9
opened cursors cumulative                   491,930          135.7         124.3
parse count (describe)                            5            0.0           0.0
parse count (failures)                            7            0.0           0.0
parse count (hard)                              310            0.1           0.1
parse count (total)                         488,968          134.9         123.5
parse time cpu                                  569            0.2           0.1
parse time elapsed                            3,353            0.9           0.9
physical read IO requests                   236,503           65.3          59.7
physical read bytes                  64,268,353,536   17,732,791.6  16,233,481.6
physical read total IO requests             242,434           66.9          61.2
physical read total bytes            64,365,780,992   17,759,673.5  16,258,090.7
physical read total multi block             107,714           29.7          27.2
physical reads                            7,845,258        2,164.7       1,981.6
physical reads cache                          1,650            0.5           0.4
physical reads cache prefetch                     3            0.0           0.0
physical reads direct                     7,843,608        2,164.2       1,981.2
physical reads direct (lob)                     364            0.1           0.1
physical reads direct temporary           4,137,125        1,141.5       1,045.0
physical reads prefetch warmup                    0            0.0           0.0
physical write IO requests                  207,382           57.2          52.4
physical write bytes                 34,107,359,232    9,410,832.2   8,615,145.0
physical write total IO requests            214,460           59.2          54.2
physical write total bytes           34,164,296,192    9,426,542.1   8,629,526.7
physical write total multi block             79,416           21.9          20.1
physical writes                           4,163,496        1,148.8       1,051.7
physical writes direct                    4,159,671        1,147.7       1,050.7
physical writes direct (lob)                     27            0.0           0.0
physical writes direct temporary          4,159,428        1,147.7       1,050.6
physical writes from cache                    3,825            1.1           1.0
physical writes non checkpoint            4,161,385        1,148.2       1,051.1
pinned buffers inspected                          2            0.0           0.0
pinned cursors current                            2            0.0           0.0
prefetch clients - default                        0            0.0           0.0
prefetch warmup blocks aged out                   0            0.0           0.0
prefetch warmup blocks flushed o                  0            0.0           0.0
Instance Activity Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by statistic name

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
prefetched blocks aged out befor                  0            0.0           0.0
process last non-idle time                    8,216            2.3           2.1
queries parallelized                              0            0.0           0.0
recursive calls                             275,471           76.0          69.6
recursive cpu usage                             609            0.2           0.2
redo blocks checksummed by FG (e             16,375            4.5           4.1
redo blocks written                          31,397            8.7           7.9
redo buffer allocation retries                    0            0.0           0.0
redo entries                                 18,636            5.1           4.7
redo k-bytes read total                           0            0.0           0.0
redo log space requests                           0            0.0           0.0
redo log space wait time                          0            0.0           0.0
redo ordering marks                             423            0.1           0.1
redo size                                14,178,984        3,912.2       3,581.5
redo size for direct writes               1,999,448          551.7         505.0
redo subscn max counts                        1,712            0.5           0.4
redo synch time                              40,659           11.2          10.3
redo synch writes                             4,093            1.1           1.0
redo wastage                              1,289,668          355.8         325.8
redo write time                              29,205            8.1           7.4
redo writes                                   4,582            1.3           1.2
rollback changes - undo records                   4            0.0           0.0
rollbacks only - consistent read                182            0.1           0.1
root node splits                                  0            0.0           0.0
rows fetched via callback                 3,698,420        1,020.5         934.2
scheduler wait time                               0            0.0           0.0
session connect time                              0            0.0           0.0
session cursor cache hits                   475,792          131.3         120.2
session logical reads                   367,489,468      101,396.9      92,823.8
shared hash latch upgrades - no             133,377           36.8          33.7
shared hash latch upgrades - wai                 14            0.0           0.0
sorts (disk)                                      0            0.0           0.0
sorts (memory)                               50,349           13.9          12.7
sorts (rows)                              9,093,355        2,509.0       2,296.9
sql area evicted                                242            0.1           0.1
sql area purged                                   7            0.0           0.0
summed dirty queue length                         0            0.0           0.0
switch current to new buffer                    344            0.1           0.1
table fetch by rowid                    757,312,732      208,956.2     191,288.9
table fetch continued row                    62,291           17.2          15.7
table scan blocks gotten                121,657,019       33,567.4      30,729.2
table scan rows gotten                6,223,471,539    1,717,167.4   1,571,980.7
table scans (direct read)                        65            0.0           0.0
table scans (long tables)                     1,021            0.3           0.3
table scans (rowid ranges)                        0            0.0           0.0
table scans (short tables)                  264,575           73.0          66.8
temp space allocated (bytes)                      0            0.0           0.0
total cf enq hold time                        8,030            2.2           2.0
total number of cf enq holders                  258            0.1           0.1
total number of times SMON poste                  0            0.0           0.0
transaction rollbacks                             1            0.0           0.0
transaction tables consistent re                  0            0.0           0.0
transaction tables consistent re                  0            0.0           0.0
undo change vector size                   3,183,416          878.4         804.1
user I/O wait time                        4,743,916        1,308.9       1,198.3
user calls                                1,726,509          476.4         436.1
user commits                                  3,959            1.1           1.0
user rollbacks                                    0            0.0           0.0
workarea executions - multipass                   0            0.0           0.0
workarea executions - onepass                   103            0.0           0.0
Instance Activity Stats                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by statistic name

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
workarea executions - optimal                82,364           22.7          20.8
write clones created in backgrou                  0            0.0           0.0
write clones created in foregrou                 20            0.0           0.0
          -------------------------------------------------------------

Instance Activity Stats - Absolute ValuesDB/Inst: MYCAR/mycar  Snaps: 9474-94
-> Statistics with absolute values (should not be diffed)

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
session uga memory max           1.154093207E+12 1.157295137E+12
session pga memory               3.600896775E+11 3.602573602E+11
session pga memory max           4.081360879E+11 4.073745042E+11
session cursor cache count            10,559,128      10,564,952
session uga memory               6.344924197E+14 6.347887902E+14
opened cursors current                       468             462
workarea memory allocated                 46,530          50,517
logons current                                97             102
          -------------------------------------------------------------

Instance Activity Stats - Thread ActivityDB/Inst: MYCAR/mycar  Snaps: 9474-947
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                            0       .00
          -------------------------------------------------------------

IOStat by Function summary              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
    other columns suffixed with K,M,G,T,P are in multiples of 1000
-> ordered by (Data Read + Write) desc

                Reads:   Reqs   Data    Writes:  Reqs   Data    Waits:    Avg
Function Name   Data    per sec per sec Data    per sec per sec Count    Tm(ms)
--------------- ------- ------- ------- ------- ------- ------- ------- -------
Direct Reads      59.8G    64.8 16.9013     13M     0.0 .003586  234.8K    39.9
Direct Writes       15M     0.0 .004138   31.7G    56.6 8.96319  205.2K   184.1
Others              93M     1.6 .025660     39M     0.7 .010760    8439    28.5
DBWR                 0M     0.0      0M     30M     0.6 .008277     899   114.4
LGWR                 0M     0.0      0M     15M     1.3 .004138    4580    63.1
Buffer Cache Re     13M     0.5 .003586      0M     0.0      0M    1656    68.1
TOTAL:            59.9G    66.9 16.9347   31.8G    59.2 8.98995  455.6K   105.1
          -------------------------------------------------------------

IOStat by Filetype summary              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
    other columns suffixed with K,M,G,T,P are in multiples of 1000
-> Small Read and Large Read are average service times, in milliseconds
-> Ordered by (Data Read + Write) desc

                Reads:   Reqs   Data    Writes:  Reqs   Data      Small   Large
Filetype Name   Data    per sec per sec Data    per sec per sec    Read    Read
--------------- ------- ------- ------- ------- ------- ------- ------- -------
Temp File         31.6G    56.4 8.91794   31.7G    56.6 8.96622    38.5    50.5
Data File         28.3G     8.9 7.99085     33M     0.6 .009105    38.9    18.4
Control File        93M     1.6 .025660     39M     0.7 .010760     0.7     N/A
Log File             0M     0.0      0M     15M     1.3 .004138     N/A     N/A
TOTAL:            59.9G    66.9 16.9344   31.8G    59.2 8.99023    36.9    41.8
          -------------------------------------------------------------

IOStat by Function/Filetype summary     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> 'Data' columns suffixed with M,G,T,P are in multiples of 1024
    other columns suffixed with K,M,G,T,P are in multiples of 1000
-> Ordered by (Data Read + Write) desc for each function

 Reads:   Reqs   Data    Writes:  Reqs   Data    Waits:    Avg
 Data    per sec per sec Data    per sec per sec Count    Tm(ms)
 ------- ------- ------- ------- ------- ------- ------- -------
Direct Reads
   59.8G    64.8 16.9013     13M     0.0 .003586       0     N/A
 Direct Reads (Data File)
   59.8G    64.8 16.9013     13M     0.0 .003586       0     N/A
Direct Writes
     15M     0.0 .004138   31.7G    56.6 8.96319       0     N/A
 Direct Writes (Data File)
     15M     0.0 .004138   31.7G    56.6 8.96319       0     N/A
Others
     94M     1.6 .025936     39M     0.7 .010760    5945     0.7
 Others (Control File)
     93M     1.6 .025660     39M     0.7 .010760    5922     0.7
 Others (Data File)
      1M     0.0 .000275      0M     0.0      0M      23     3.3
DBWR
      0M     0.0      0M     30M     0.6 .008277       0     N/A
 DBWR (Data File)
      0M     0.0      0M     30M     0.6 .008277       0     N/A
LGWR
      0M     0.0      0M     15M     1.3 .004138       0     N/A
 LGWR (Log File)
      0M     0.0      0M     15M     1.3 .004138       0     N/A
Buffer Cache Reads
     13M     0.5 .003586      0M     0.0      0M    1658    68.0
 Buffer Cache Reads (Data File)
     13M     0.5 .003586      0M     0.0      0M    1658    68.0
TOTAL:
   59.9G    66.9 16.9350   31.8G    59.2 8.98995    7603    15.4
          -------------------------------------------------------------

Tablespace IO Stats                    DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av       Av     Av                       Av     Buffer  Av Buf
         Reads Reads/s  Rd(ms) Blks/Rd       Writes Writes/s      Waits  Wt(ms)
-------------- ------- ------- ------- ------------ -------- ---------- -------
TEMP
       204,386      56     0.0    20.2      205,140       57          0     0.0
MYCAR
        31,998       9     3.3   115.9        1,208        0          2    10.0
SYSAUX
            92       0    57.6     1.0          632        0          0     0.0
UNDOTBS1
             0       0     0.0      .0          233        0          0     0.0
PASSPORT
            15       0    71.3     1.0           81        0          0     0.0
SYSTEM
             7       0   135.7     1.0           88        0          0     0.0
          -------------------------------------------------------------

File IO Stats                          DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av       Av     Av                       Av     Buffer  Av Buf
         Reads Reads/s  Rd(ms) Blks/Rd       Writes Writes/s      Waits  Wt(ms)
-------------- ------- ------- ------- ------------ -------- ---------- -------
MYCAR                    /oracle/oradata/mycar/mycar.dbf
        30,876       9     3.4   115.8          821        0          1     0.0
MYCAR                    /oracle/oradata/mycar/mycar01.dbf
         1,122       0     0.8   118.3          387        0          1    20.0
PASSPORT                 /oracle/oradata/mycar/passport.dbf
            15       0    71.3     1.0           81        0          0     0.0
SYSAUX                   /oracle/oradata/mycar/sysaux01.dbf
            92       0    57.6     1.0          632        0          0     0.0
SYSTEM                   /oracle/oradata/mycar/system01.dbf
             7       0   135.7     1.0           88        0          0     0.0
TEMP                     /oracle/oradata/mycar/temp01.dbf
       204,386      56     0.0    20.2      205,140       57          0     N/A
UNDOTBS1                 /oracle/oradata/mycar/undotbs01.dbf
             0       0     N/A     N/A          233        0          0     0.0
          -------------------------------------------------------------

Buffer Pool Statistics                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                            Free   Writ   Buffer
     Number of Pool       Buffer     Physical    Physical   Buff   Comp     Busy
P      Buffers Hit%         Gets        Reads      Writes   Wait   Wait    Waits
--- ---------- ---- ------------ ------------ ----------- ------ ------ --------
D       96,530  100  363,528,049        1,654       3,825      0      0        2
          -------------------------------------------------------------

Checkpoint Activity                     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Physical Writes:                    4,163,496

                                          Other    Autotune      Thread
       MTTR    Log Size    Log Ckpt    Settings        Ckpt        Ckpt
     Writes      Writes      Writes      Writes      Writes      Writes
----------- ----------- ----------- ----------- ----------- -----------
          0           0           0           0       3,519           0
          -------------------------------------------------------------

Instance Recovery Stats                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> B: Begin Snapshot,  E: End Snapshot

                                                                            Estd
  Targt  Estd                                     Log Ckpt Log Ckpt    Opt   RAC
  MTTR   MTTR Recovery  Actual   Target   Log Sz   Timeout Interval    Log Avail
   (s)    (s) Estd IOs RedoBlks RedoBlks RedoBlks RedoBlks RedoBlks  Sz(M)  Time
- ----- ----- -------- -------- -------- -------- -------- -------- ------ -----
B     0    14      375     1905     6265   995328     6265      N/A    N/A   N/A
E     0    14      453     5437    16514   995328    16514      N/A    N/A   N/A
          -------------------------------------------------------------

MTTR Advisory                                 DB/Inst: MYCAR/mycar  Snap: 9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffer Pool Advisory                          DB/Inst: MYCAR/mycar  Snap: 9475
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate

                                    Est
                                   Phys      Estimated                  Est
    Size for   Size      Buffers   Read     Phys Reads     Est Phys %DBtime
P    Est (M) Factor  (thousands) Factor    (thousands)    Read Time for Rds
--- -------- ------ ------------ ------ -------------- ------------ -------
D         80     .1           10    1.8      2,772,028            1 1.0E+06
D        160     .2           20    1.0      1,583,528            1 4.4E+04
D        240     .3           30    1.0      1,560,506            1 2.5E+04
D        320     .4           39    1.0      1,556,001            1 2.1E+04
D        400     .5           49    1.0      1,555,363            1 2.0E+04
D        480     .6           59    1.0      1,554,952            1 2.0E+04
D        560     .7           69    1.0      1,554,666            1 2.0E+04
D        640     .8           79    1.0      1,554,382            1 2.0E+04
D        720     .9           89    1.0      1,554,144            1 1.9E+04
D        800    1.0           99    1.0      1,553,962            1 1.9E+04
D        880    1.1          108    1.0      1,553,798            1 1.9E+04
D        960    1.2          118    1.0      1,553,631            1 1.9E+04
D      1,040    1.3          128    1.0      1,553,521            1 1.9E+04
D      1,120    1.4          138    1.0      1,553,439            1 1.9E+04
D      1,200    1.5          148    1.0      1,553,376            1 1.9E+04
D      1,280    1.6          158    1.0      1,553,308            1 1.9E+04
D      1,360    1.7          167    1.0      1,552,563            1 1.8E+04
D      1,440    1.8          177    1.0      1,495,189            1  6983.0
D      1,520    1.9          187    1.0      1,482,199            1  6982.0
D      1,600    2.0          197    0.9      1,414,700            1  6976.0
          -------------------------------------------------------------

PGA Aggr Summary                       DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %   W/A MB Processed  Extra W/A MB Read/Written
--------------- ------------------ --------------------------
           61.6             58,511                     36,484
          -------------------------------------------------------------

PGA Aggr Target Stats                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

PGA Aggr Target Histogram               DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Optimal Executions are purely in-memory operations

  Low     High
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K         54,555         54,555            0            0
    64K    128K          3,648          3,648            0            0
   128K    256K          1,650          1,650            0            0
   256K    512K             96             96            0            0
   512K   1024K         18,393         18,393            0            0
     1M      2M          3,893          3,893            0            0
     2M      4M             56             56            0            0
     4M      8M             21             21            0            0
    16M     32M             62             46           16            0
    32M     64M              2              1            1            0
    64M    128M              2              2            0            0
   128M    256M             11              0           11            0
   256M    512M             50              0           50            0
   512M   1024M             25              0           25            0
          -------------------------------------------------------------

PGA Memory Advisory                           DB/Inst: MYCAR/mycar  Snap: 9475
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
   where Estd PGA Overalloc Count is 0

                                       Estd Extra    Estd P Estd PGA
PGA Target    Size           W/A MB   W/A MB Read/    Cache Overallo    Estd
  Est (MB)   Factr        Processed Written to Disk   Hit %    Count    Time
---------- ------- ---------------- ---------------- ------ -------- -------
       142     0.1     22,987,341.4     49,510,357.8   32.0  302,597 8.2E+10
       284     0.3     22,987,341.4     49,348,616.7   32.0  298,460 8.2E+10
       568     0.5     22,987,341.4     12,566,007.7   65.0        9 4.0E+10
       852     0.8     22,987,341.4     12,274,213.5   65.0        0 4.0E+10
     1,136     1.0     22,987,341.4     11,524,015.3   67.0        0 3.9E+10
     1,363     1.2     22,987,341.4     11,372,520.8   67.0        0 3.9E+10
     1,590     1.4     22,987,341.4     11,372,371.0   67.0        0 3.9E+10
     1,818     1.6     22,987,341.4     11,372,260.0   67.0        0 3.9E+10
     2,045     1.8     22,987,341.4     11,372,260.0   67.0        0 3.9E+10
     2,272     2.0     22,987,341.4     11,372,260.0   67.0        0 3.9E+10
     3,408     3.0     22,987,341.4     11,372,260.0   67.0        0 3.9E+10
     4,544     4.0     22,987,341.4     11,372,100.4   67.0        0 3.9E+10
     6,816     6.0     22,987,341.4     11,372,100.4   67.0        0 3.9E+10
     9,088     8.0     22,987,341.4     11,372,100.4   67.0        0 3.9E+10
          -------------------------------------------------------------

Shared Pool Advisory                         DB/Inst: MYCAR/mycar  Snap: 9475
-> SP: Shared Pool     Est LC: Estimated Library Cache   Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
   in the Library Cache, and the physical number of memory objects associated
   with it.  Therefore comparing the number of Lib Cache objects (e.g. in
   v$librarycache), with the number of Lib Cache Memory Objects is invalid.

                                       Est LC Est LC  Est LC Est LC
  Shared    SP   Est LC                  Time   Time    Load   Load       Est LC
    Pool  Size     Size       Est LC    Saved  Saved    Time   Time      Mem Obj
 Size(M) Factr      (M)      Mem Obj      (s)  Factr     (s)  Factr     Hits (K)
-------- ----- -------- ------------ -------- ------ ------- ------ ------------
     752    .6       28        1,732 6.63E+06    1.0 2.1E+05    1.1       67,900
     880    .7      157        8,762 6.64E+06    1.0 2.1E+05    1.1      308,223
   1,008    .8      284       12,898 6.64E+06    1.0 2.0E+05    1.0      308,838
   1,136    .9      412       17,243 6.65E+06    1.0 2.0E+05    1.0      309,091
   1,264   1.0      540       21,902 6.65E+06    1.0 2.0E+05    1.0      309,294
   1,392   1.1      668       26,454 6.65E+06    1.0 1.9E+05    1.0      309,475
   1,520   1.2      796       31,027 6.65E+06    1.0 1.9E+05    1.0      309,591
   1,648   1.3      924       34,524 6.65E+06    1.0 1.9E+05    1.0      309,639
   1,776   1.4    1,052       38,341 6.65E+06    1.0 1.9E+05    1.0      309,671
   1,904   1.5    1,180       41,674 6.65E+06    1.0 1.9E+05    1.0      309,688
   2,032   1.6    1,308       45,353 6.65E+06    1.0 1.9E+05    1.0      309,701
   2,160   1.7    1,436       49,359 6.65E+06    1.0 1.9E+05    1.0      309,709
   2,288   1.8    1,564       52,835 6.65E+06    1.0 1.9E+05    1.0      309,717
   2,416   1.9    1,692       56,036 6.65E+06    1.0 1.9E+05    1.0      309,724
   2,544   2.0    1,820       59,892 6.65E+06    1.0 1.9E+05    1.0      309,731
          -------------------------------------------------------------

SGA Target Advisory                           DB/Inst: MYCAR/mycar  Snap: 9475

SGA Target   SGA Size       Est DB     Est Physical
  Size (M)     Factor     Time (s)            Reads
---------- ---------- ------------ ----------------
     1,072        0.5    4,702,675    1,559,866,826
     1,608        0.8    4,685,355    1,554,583,356
     2,144        1.0    4,681,142    1,553,961,771
     2,680        1.3    4,671,780    1,481,547,152
     3,216        1.5    4,667,567    1,494,445,035
     3,752        1.8    4,667,099    1,494,445,035
     4,288        2.0    4,667,099    1,414,105,212
          -------------------------------------------------------------

Streams Pool Advisory                         DB/Inst: MYCAR/mycar  Snap: 9475

  Size for      Size   Est Spill   Est Spill Est Unspill Est Unspill
  Est (MB)    Factor       Count    Time (s)       Count    Time (s)
---------- --------- ----------- ----------- ----------- -----------
        16       0.5           0           0           0           0
        32       1.0           0           0           0           0
        48       1.5           0           0           0           0
        64       2.0           0           0           0           0
        80       2.5           0           0           0           0
        96       3.0           0           0           0           0
       112       3.5           0           0           0           0
       128       4.0           0           0           0           0
       144       4.5           0           0           0           0
       160       5.0           0           0           0           0
       176       5.5           0           0           0           0
       192       6.0           0           0           0           0
       208       6.5           0           0           0           0
       224       7.0           0           0           0           0
       240       7.5           0           0           0           0
       256       8.0           0           0           0           0
       272       8.5           0           0           0           0
       288       9.0           0           0           0           0
       304       9.5           0           0           0           0
       320      10.0           0           0           0           0
          -------------------------------------------------------------

Java Pool Advisory                            DB/Inst: MYCAR/mycar  Snap: 9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffer Wait Statistics                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by wait time desc, waits desc

Class                    Waits Total Wait Time (s)  Avg Time (ms)
------------------ ----------- ------------------- --------------
data block                   2                   0             10
          -------------------------------------------------------------

Enqueue Activity                       DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)
------------------------------------------------------------------------------
    Requests    Succ Gets Failed Gets       Waits  Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
KO-Multiple Object Checkpoint (fast object checkpoint)
         423          423           0          47           19         398.09
JD-Job Queue Date
         777          777           0           1            1         940.00
TX-Transaction (index contention)
          12           12           0           1            0          20.00
          -------------------------------------------------------------

Undo Segment Summary                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count,  OOS - Out of Space count
-> Undo segment block stats:
-> uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
-> eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo   Num Undo       Number of  Max Qry   Max Tx Min/Max   STO/     uS/uR/uU/
 TS# Blocks (K)    Transactions  Len (s) Concurcy TR (mins) OOS      eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
   2         .3           4,264    1,453        4 240/240   0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Undo Segment Stats                      DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Most recent 35 Undostat rows, ordered by Time desc

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/    uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS     eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
24-Jun 16:50          78          945   1,453       3     240 0/0   0/0/0/0/0/0
24-Jun 16:40          84        1,011   1,003       4     240 0/0   0/0/0/0/0/0
24-Jun 16:30          66        1,327     399       4     240 0/0   0/0/0/0/0/0
24-Jun 16:20          31          531   1,000       2     240 0/0   0/0/0/0/0/0
24-Jun 16:10          20          450   1,260       2     240 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Latch Activity                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
AQ deq hash table latch               1    0.0             0            0    N/A
ASM db client latch               2,428    0.0             0            0    N/A
ASM map operation hash t              1    0.0             0            0    N/A
ASM network state latch              65    0.0             0            0    N/A
AWR Alerted Metric Eleme         32,136    0.0             0            0    N/A
Change Notification Hash          1,199    0.0             0            0    N/A
Consistent RBA                    4,582    0.0             0            0    N/A
DML lock allocation              26,428    0.0             0            0    N/A
Event Group Locks                   198    0.0             0            0    N/A
FAL Queue                           169    0.0             0            0    N/A
FOB s.o list latch                  801    0.0             0            0    N/A
File State Object Pool P              1    0.0             0            0    N/A
IPC stats buffer allocat              1    0.0             0            0    N/A
In memory undo latch             34,345    0.0    0.7      0        4,846    0.0
JS Sh mem access                      7    0.0             0            0    N/A
JS mem alloc latch                    5    0.0             0            0    N/A
JS queue access latch                 6    0.0             0            0    N/A
JS queue state obj latch         25,774    0.0             0            0    N/A
JS slv state obj latch        1,226,146    0.4    0.0      0            0    N/A
KFC FX Hash Latch                     1    0.0             0            0    N/A
KFC Hash Latch                        1    0.0             0            0    N/A
KFCL LE Freelist                      1    0.0             0            0    N/A
KGNFS-NFS:SHM structure               1    0.0             0            0    N/A
KGNFS-NFS:SVR LIST                    1    0.0             0            0    N/A
KJC message pool free li              1    0.0             0            0    N/A
KJCT flow control latch               1    0.0             0            0    N/A
KMG MMAN ready and start          1,204    0.0             0            0    N/A
KTF sga latch                        21    0.0             0          910    0.0
KWQP Prop Status                      2    0.0             0            0    N/A
KWQS pqsubs latch                     5    0.0             0            0    N/A
KWQS pqueue ctx latch                74    0.0             0            0    N/A
Locator state objects po              1    0.0             0            0    N/A
Lsod array latch                      1    0.0             0            0    N/A
MQL Tracking Latch                    0    N/A             0           72    0.0
Memory Management Latch               1    0.0             0        1,204    0.0
Memory Queue                          1    0.0             0            0    N/A
Memory Queue Message Sub              1    0.0             0            0    N/A
Memory Queue Message Sub              1    0.0             0            0    N/A
Memory Queue Message Sub              1    0.0             0            0    N/A
Memory Queue Message Sub              1    0.0             0            0    N/A
Memory Queue Subscriber               1    0.0             0            0    N/A
MinActiveScn Latch                   20    0.0             0            0    N/A
Mutex                                 1    0.0             0            0    N/A
Mutex Stats                           1    0.0             0            0    N/A
OS process                        1,411    0.0             0            0    N/A
OS process allocation             2,133    0.0             0            0    N/A
OS process: request allo            389    0.0             0            0    N/A
PL/SQL warning settings             452    0.0             0            0    N/A
PX hash array latch                   1    0.0             0            0    N/A
QMT                                   1    0.0             0            0    N/A
Real-time plan statistic          4,329    0.0             0            0    N/A
SGA blob parent                       1    0.0             0            0    N/A
SGA bucket locks                      1    0.0             0            0    N/A
SGA heap locks                        1    0.0             0            0    N/A
SGA pool locks                        1    0.0             0            0    N/A
SQL memory manager latch          2,403    1.3    1.0      1        1,167    0.0
SQL memory manager worka        397,435    0.0    0.0      0            0    N/A
Shared B-Tree                       327    0.0             0            0    N/A
Streams Generic                       1    0.0             0            0    N/A
Testing                               1    0.0             0            0    N/A
Latch Activity                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Token Manager                         1    0.0             0            0    N/A
WCR: sync                             1    0.0             0            0    N/A
Write State Object Pool               1    0.0             0            0    N/A
X$KSFQP                           2,327    0.0             0            0    N/A
XDB NFS Security Latch                1    0.0             0            0    N/A
XDB unused session pool               1    0.0             0            0    N/A
XDB used session pool                 1    0.0             0            0    N/A
active checkpoint queue           2,445    0.0             0            0    N/A
active service list               8,319    0.0    2.0      0        4,264    0.0
archive control                      61    0.0             0            0    N/A
archive process latch               507    0.0             0            0    N/A
begin backup scn array               37    0.0             0            0    N/A
buffer pool                           1    0.0             0            0    N/A
business card                         1    0.0             0            0    N/A
cache buffer handles             34,938    0.1    0.0      0            0    N/A
cache buffers chains        721,899,826    0.1    0.0     41        5,172    0.0
cache buffers lru chain           4,556    0.0             0    9,354,730    0.0
cache table scan latch                3    0.0             0            3    0.0
call allocation                   1,181    0.0             0            0    N/A
cas latch                             1    0.0             0            0    N/A
change notification clie              1    0.0             0            0    N/A
channel handle pool latc            470    0.0             0            0    N/A
channel operations paren         18,112    0.0             0            0    N/A
checkpoint queue latch          113,475    0.0             0        3,768    0.0
client/application info           2,032    0.0             0            0    N/A
compile environment latc            266    0.0             0            0    N/A
corrupted undo seg latch             13    0.0             0            0    N/A
cp cmon/server latch                  1    0.0             0            0    N/A
cp pool latch                         1    0.0             0            0    N/A
cp server hash latch                  1    0.0             0            0    N/A
cp sga latch                         65    0.0             0            0    N/A
cvmap freelist lock                   1    0.0             0            0    N/A
deferred cleanup latch               65    0.0             0            0    N/A
dml lock allocation                  65    0.0             0            0    N/A
done queue latch                      1    0.0             0            0    N/A
dummy allocation                    528    0.0             0            0    N/A
enqueue hash chains             169,906    0.0    0.1      0            9    0.0
enqueues                        129,885    0.0    0.0      0            0    N/A
fifth spare latch                     1    0.0             0            0    N/A
file cache latch                    213    0.0             0            0    N/A
flashback copy                        1    0.0             0            0    N/A
gc element                            1    0.0             0            0    N/A
gcs commit scn state                  1    0.0             0            0    N/A
gcs partitioned table ha              1    0.0             0            0    N/A
gcs pcm hashed value buc              1    0.0             0            0    N/A
gcs resource freelist                 1    0.0             0            0    N/A
gcs resource hash                     1    0.0             0            0    N/A
gcs resource scan list                1    0.0             0            0    N/A
gcs shadows freelist                  1    0.0             0            0    N/A
ges domain table                      1    0.0             0            0    N/A
ges enqueue table freeli              1    0.0             0            0    N/A
ges group table                       1    0.0             0            0    N/A
ges process hash list                 1    0.0             0            0    N/A
ges process parent latch              1    0.0             0            0    N/A
ges resource hash list                1    0.0             0            0    N/A
ges resource scan list                1    0.0             0            0    N/A
ges resource table freel              1    0.0             0            0    N/A
ges value block free lis              1    0.0             0            0    N/A
global KZLD latch for me             55    0.0             0            0    N/A
global tx hash mapping                1    0.0             0            0    N/A
Latch Activity                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
granule operation                     1    0.0             0            0    N/A
hash table column usage             112    0.0             0       38,857    0.0
hash table modification             110    0.0             0            0    N/A
heartbeat check                       1    0.0             0            0    N/A
internal temp table obje              3    0.0             0            0    N/A
intra txn parallel recov              1    0.0             0            0    N/A
io pool granule metadata              1    0.0             0            0    N/A
job workq parent latch               70    0.0             0           69    1.4
job_queue_processes free            142    0.0             0            0    N/A
job_queue_processes para            841    0.0             0            0    N/A
k2q lock allocation                   1    0.0             0            0    N/A
kdlx hb parent latch                  1    0.0             0            0    N/A
kgb parent                            1    0.0             0            0    N/A
kks stats                         1,736    0.0             0            0    N/A
kokc descriptor allocati            492    0.0             0            0    N/A
ksfv messages                         1    0.0             0            0    N/A
kss move lock                        39    0.0             0            0    N/A
ksuosstats global area              245    0.0             0            0    N/A
ksv allocation latch                141    0.0             0            0    N/A
ksv class latch                      77    0.0             0            0    N/A
ksv msg queue latch                   1    0.0             0            0    N/A
ksz_so allocation latch             389    0.0             0            0    N/A
ktm global data                      22    0.0             0            0    N/A
kwqbsn:qsga                         131    0.0             0            0    N/A
lgwr LWN SCN                      5,334    0.0             0            0    N/A
list of block allocation            396    0.0             0            0    N/A
loader state object free            932    0.0             0            0    N/A
lob segment dispenser la              1    0.0             0            0    N/A
lob segment hash table l             13    0.0             0            0    N/A
lob segment query latch               1    0.0             0            0    N/A
lock DBA buffer during m              1    0.0             0            0    N/A
logical standby cache                 1    0.0             0            0    N/A
logminer context allocat              2    0.0             0            0    N/A
logminer work area                    1    0.0             0            0    N/A
longop free list parent             491    0.0             0           70    0.0
managed standby latch               169    0.0             0            0    N/A
mapped buffers lru chain              1    0.0             0            0    N/A
message pool operations             142    0.0             0            0    N/A
messages                         48,234    0.0    0.0      0            0    N/A
mostly latch-free SCN             5,332    0.0             0            0    N/A
msg queue latch                       1    0.0             0            0    N/A
multiblock read objects              28    0.0             0            0    N/A
name-service namespace b              1    0.0             0            0    N/A
ncodef allocation latch              65    0.0             0            0    N/A
object queue header heap             66    0.0             0           37    0.0
object queue header oper         26,175    0.0             0            0    N/A
object stats modificatio              7    0.0             0            0    N/A
parallel query alloc buf            469    0.0             0            0    N/A
parallel query stats                  1    0.0             0            0    N/A
parameter list                      328    0.0             0            0    N/A
parameter table manageme            529    0.0             0            0    N/A
peshm                                 1    0.0             0            0    N/A
pesom_free_list                       1    0.0             0            0    N/A
pesom_hash_node                       1    0.0             0            0    N/A
post/wait queue                   8,682    0.0             0        6,533    0.0
process allocation                  528    0.0             0          197    0.0
process group creation              389    0.0             0            0    N/A
process queue                         1    0.0             0            0    N/A
process queue reference               1    0.0             0            0    N/A
qmn task queue latch                902    0.0             0            0    N/A
Latch Activity                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
query server freelists                1    0.0             0            0    N/A
queued dump request                  12    0.0             0            0    N/A
queuing load statistics               1    0.0             0            0    N/A
recovery domain hash lis              1    0.0             0            0    N/A
redo allocation                  24,891    0.0    0.5      0       18,688    0.0
redo copy                             1    0.0             0       18,688    0.1
redo writing                     18,361    0.0             0            0    N/A
resmgr group change latc            463    0.0             0            0    N/A
resmgr:active threads               528    0.0             0            0    N/A
resmgr:actses change gro            147    0.0             0            0    N/A
resmgr:actses change sta              1    0.0             0            0    N/A
resmgr:free threads list            527    0.0             0            0    N/A
resmgr:plan CPU method                1    0.0             0            0    N/A
resmgr:resource group CP              1    0.0             0            0    N/A
resmgr:schema config                 81    0.0             0            0    N/A
resmgr:session queuing                1    0.0             0            0    N/A
rm cas latch                          1    0.0             0            0    N/A
row cache objects               561,553    0.0    0.1      0          222    0.0
rules engine rule set st            100    0.0             0            0    N/A
second spare latch                    1    0.0             0            0    N/A
sequence cache                   24,284    0.0             0            0    N/A
session allocation              431,079    0.0    0.0      0      143,696    0.0
session idle bit              3,595,832    0.0    0.0      0            0    N/A
session queue latch                   1    0.0             0            0    N/A
session state list latch            588    0.0             0            0    N/A
session switching                 1,026    0.0             0            0    N/A
session timer                     1,359    0.0             0            0    N/A
shared pool                      44,705    0.1    0.2      1            0    N/A
shared pool sim alloc                 1    0.0             0            0    N/A
shared pool simulator             4,310    0.0             0            0    N/A
sim partition latch                   1    0.0             0            0    N/A
simulator hash latch         28,462,939    0.0    0.1      4            0    N/A
simulator lru latch               2,800    0.1    0.3      0   27,319,003    0.3
sort extent pool                 47,870    0.1    0.3      5            0    N/A
space background state o              4    0.0             0            0    N/A
space background task la          2,611    0.0             0        2,406    0.0
state object free list                2    0.0             0            0    N/A
statistics aggregation              560    0.0             0            0    N/A
tablespace key chain                  1    0.0             0            0    N/A
temp lob duration state               2    0.0             0            0    N/A
test excl. parent l0                  1    0.0             0            0    N/A
test excl. parent2 l0                 1    0.0             0            0    N/A
third spare latch                     1    0.0             0            0    N/A
threshold alerts latch              168    0.0             0            0    N/A
transaction allocation              952    0.1    1.0      3            0    N/A
undo global data                 25,666    0.0             0            0    N/A
virtual circuit buffers               1    0.0             0            0    N/A
virtual circuit holder                1    0.0             0            0    N/A
virtual circuit queues                1    0.0             0            0    N/A
          -------------------------------------------------------------

Latch Sleep Breakdown                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by misses desc

                                       Get                                 Spin
Latch Name                        Requests       Misses      Sleeps        Gets
-------------------------- --------------- ------------ ----------- -----------
cache buffers chains           721,899,826      910,124         854     909,346
JS slv state obj latch           1,226,146        4,392           4           0
simulator hash latch            28,462,939          716          80         638
session idle bit                 3,595,832          259           7         252
row cache objects                  561,553           81           8          73
SQL memory manager latch             2,403           31          31           2
shared pool                         44,705           27           5          22
sort extent pool                    47,870           24           8          16
enqueue hash chains                169,906            8           1           7
In memory undo latch                34,345            3           2           1
simulator lru latch                  2,800            3           1           2
redo allocation                     24,891            2           1           1
active service list                  8,319            1           2           0
transaction allocation                 952            1           1           0
          -------------------------------------------------------------

Latch Miss Sources                     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch     ktiFlush: child                  0          2        1
In memory undo latch     kticmt: child                    0          1        2
SQL memory manager latch qesmmIQueryRefreshBound          0         31       31
active service list      kswsite: service iterator        0          2        2
cache buffers chains     kcbgtcr: fast path (cr pin       0        604      285
cache buffers chains     kcbrls_1                         0        152      519
cache buffers chains     kcbgtcr_2                        0         80       31
cache buffers chains     kcbrls_2                         0         30       42
cache buffers chains     kcbgtcr: fast path               0         15       19
cache buffers chains     kcbgtcr: kslbegin excl           0         13        8
cache buffers chains     kcbzgb: scan from tail. no       0         11        0
cache buffers chains     kcbgcur_2                        0          1        0
enqueue hash chains      ksqgtl3                          0          1        1
redo allocation          kcrfw_redo_gen: redo alloc       0          1        0
row cache objects        kqrpre: find obj                 0          5        8
row cache objects        kqreqd: reget                    0          3        0
session idle bit         ksupuc: set busy                 0          4        5
session idle bit         ksuxds                           0          3        0
session idle bit         ksupuc: clear busy               0          2        4
shared pool              kghalo                           0          4        3
shared pool              kghupr1                          0          1        1
simulator hash latch     kcbs_lookup_setid: lookup        0         59       52
simulator hash latch     kcbsacc: lookup dba              0         20       28
simulator hash latch     kcbsacc: remove dba              0          1        0
simulator lru latch      kcbs_lookup_setid                0          1        0
sort extent pool         ktatobjstats                     0          4        4
sort extent pool         ktstaddextent1                   0          4        4
transaction allocation   ktcxbr                           0          1        0
          -------------------------------------------------------------

Mutex Sleep Summary                     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by number of sleeps desc

                                                                         Wait
Mutex Type            Location                               Sleeps    Time (ms)
--------------------- -------------------------------- ------------ ------------
Cursor Pin            kksfbc [KKSCHLPIN1]                    24,612            0
Cursor Stat           kkocsStoreBindAwareStats [KKSSTA            2            0
Library Cache         kglIsOwnerVersionable 121                   1            1
Library Cache         kglpndl1  95                                1           49
Cursor Pin            kksLockDelete [KKSCHLPIN6]                  1            0
          -------------------------------------------------------------

Parent Latch Statistics                DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Child Latch Statistics                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Segments by Logical Reads              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Logical Reads:     367,489,468
-> Captured Segments account for   99.7% of Total

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      SYS_PRODUCT_BURN_INF            TABLE  203,500,240   55.38
MYCAR      MYCAR      DIAG_SOFT_VERSION_DE            TABLE   63,007,632   17.15
MYCAR      MYCAR      SYS_PRODUCT                     TABLE   37,915,104   10.32
MYCAR      MYCAR      DF_DATA_STREAM_NAME_            TABLE   28,527,744    7.76
MYCAR      MYCAR      DIAG_USER_SOFT_CENTE            TABLE    9,691,360    2.64
          -------------------------------------------------------------

Segments by Physical Reads              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Physical Reads:       7,845,258
-> Captured Segments account for   47.2% of Total

           Tablespace                      Subobject  Obj.      Physical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE    3,706,179   47.24
MYCAR      MYCAR      DF_DATA_STREAM_NAME_            TABLE           89     .00
MYCAR      MYCAR      OPERATE_LOG                     TABLE           61     .00
MYCAR      MYCAR      SOFTIDUSERIDSERIALNO            INDEX           31     .00
MYCAR      MYCAR      I_DF_STREAM_VERSION_            INDEX           27     .00
          -------------------------------------------------------------

Segments by Physical Read Requests      DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Physical Read Requests:         236,503
-> Captured Segments account for   12.9% of Total

           Tablespace                      Subobject  Obj.     Phys Read
Owner         Name    Object Name            Name     Type      Requests  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE       30,169   12.76
MYCAR      MYCAR      DF_DATA_STREAM_NAME_            TABLE           89     .04
MYCAR      MYCAR      OPERATE_LOG                     TABLE           61     .03
MYCAR      MYCAR      SOFTIDUSERIDSERIALNO            INDEX           31     .01
MYCAR      MYCAR      I_DF_STREAM_VERSION_            INDEX           27     .01
          -------------------------------------------------------------

Segments by UnOptimized Reads           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total UnOptimized Read Requests:         236,503
-> Captured Segments account for   12.9% of Total

           Tablespace                      Subobject  Obj.   UnOptimized
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE       30,169   12.76
MYCAR      MYCAR      DF_DATA_STREAM_NAME_            TABLE           89     .04
MYCAR      MYCAR      OPERATE_LOG                     TABLE           61     .03
MYCAR      MYCAR      SOFTIDUSERIDSERIALNO            INDEX           31     .01
MYCAR      MYCAR      I_DF_STREAM_VERSION_            INDEX           27     .01
          -------------------------------------------------------------

Segments by Optimized Reads             DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Segments by Direct Physical Reads       DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Direct Physical Reads:       7,843,608
-> Captured Segments account for   47.2% of Total

           Tablespace                      Subobject  Obj.        Direct
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE    3,705,977   47.25
          -------------------------------------------------------------

Segments by Physical Writes             DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Physical Writes:       4,163,496
-> Captured Segments account for    0.1% of Total

           Tablespace                      Subobject  Obj.      Physical
Owner         Name    Object Name            Name     Type        Writes  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      OPERATE_LOG                     TABLE        1,133     .03
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE          315     .01
SYS        SYSAUX     WRH$_ACTIVE_SESSION_ 81432_9469 TABLE          233     .01
MYCAR      MYCAR      SYS_PRODUCT                     TABLE          103     .00
SYS        SYSAUX     WRH$_ACTIVE_SESSION_ 81432_9469 INDEX           35     .00
          -------------------------------------------------------------

Segments by Physical Write Requests     DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Physical Write Requestss:         207,382
-> Captured Segments account for    0.6% of Total

           Tablespace                      Subobject  Obj.    Phys Write
Owner         Name    Object Name            Name     Type      Requests  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      OPERATE_LOG                     TABLE          383     .18
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE          293     .14
MYCAR      MYCAR      SYS_PRODUCT                     TABLE           96     .05
MYCAR      MYCAR      PK_DIAG_DOWNLOAD_REC            INDEX           31     .01
SYS        SYSAUX     SYS_LOB0000006213C00            LOB             28     .01
          -------------------------------------------------------------

Segments by Direct Physical Writes      DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Direct Physical Writes:       4,159,671
-> Captured Segments account for    0.0% of Total

           Tablespace                      Subobject  Obj.        Direct
Owner         Name    Object Name            Name     Type        Writes  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS        SYSAUX     WRH$_ACTIVE_SESSION_ 81432_9469 TABLE          216     .01
SYS        SYSAUX     SYS_LOB0000006213C00            LOB             27     .00
          -------------------------------------------------------------

Segments by Table Scans                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Total Table Scans:           1,829
-> Captured Segments account for   55.9% of Total

           Tablespace                      Subobject  Obj.         Table
Owner         Name    Object Name            Name     Type         Scans  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      DIAG_USER_SOFT_CENTE            TABLE          958   52.38
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE           65    3.55
          -------------------------------------------------------------

Segments by DB Blocks Changes           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> % of Capture shows % of DB Block Changes for each top segment compared
-> with total DB Block Changes for all segments captured by the Snapshot

           Tablespace                      Subobject  Obj.      DB Block    % of
Owner         Name    Object Name            Name     Type       Changes Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      OPERATE_LOG                     TABLE        3,088   37.19
MYCAR      MYCAR      SYS_PRODUCT_LANG_CON            TABLE        1,600   19.27
MYCAR      MYCAR      PK_DIAG_DOWNLOAD_REC            INDEX          576    6.94
SYS        SYSAUX     WRH$_SQL_PLAN                   TABLE          480    5.78
MYCAR      MYCAR      DIAG_DOWNLOAD_RECORD            TABLE          400    4.82
          -------------------------------------------------------------

Segments by Row Lock Waits             DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot

                                                                     Row
           Tablespace                      Subobject  Obj.          Lock    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      PK_DIAG_DOWNLOAD_REC            INDEX            8   66.67
MYCAR      MYCAR      SOFTIDUSERIDSERIALNO            INDEX            3   25.00
MYCAR      MYCAR      PK_DIAG_USER_SOFT_CE            INDEX            1    8.33
          -------------------------------------------------------------

Segments by ITL Waits                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Segments by Buffer Busy Waits           DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot

                                                                  Buffer
           Tablespace                      Subobject  Obj.          Busy    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
MYCAR      MYCAR      PK_DIAG_DOWNLOAD_REC            INDEX            1  100.00
          -------------------------------------------------------------

Dictionary Cache Stats                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Pct Misses"  should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control                      69    0.0       0   N/A        2          1
dc_files                             9    0.0       0   N/A        0          9
dc_global_oids                     511    0.0       0   N/A        0         89
dc_histogram_data               16,216    0.0       0   N/A        0      3,623
dc_histogram_defs                8,438    0.3       0   N/A        0      5,857
dc_objects                      11,686    0.1       0   N/A        5      3,612
dc_profiles                        126    0.0       0   N/A        0          1
dc_rollback_segments               878    0.0       0   N/A        0         22
dc_segments                      5,684    0.0       0   N/A       19      1,506
dc_sequences                       745    0.1       0   N/A      745         42
dc_tablespaces                  69,593    0.0       0   N/A        0         10
dc_users                        81,493    0.0       0   N/A        0        169
global database name             2,539    0.0       0   N/A        0          2
outstanding_alerts                  42    0.0       0   N/A        0          7
sch_lj_oids                          5    0.0       0   N/A        0         37
          -------------------------------------------------------------

Library Cache Activity                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> "Pct Misses"  should be very low

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   1,286    0.0          1,657    0.0          0        0
DBLINK                   115    0.0              0    N/A          0        0
EDITION                  144    0.0            268    0.0          0        0
INDEX                     15    0.0             15    0.0          0        0
QUEUE                     66    0.0            215    0.0          0        0
SCHEMA                   203    0.0              0    N/A          0        0
SQL AREA              14,823    4.8        501,288    0.2         45        7
SUBSCRIPTION              17    0.0             17    0.0          0        0
TABLE/PROCEDURE        6,866    0.2         36,164    0.1         15        0
TRIGGER                   24    0.0             66    0.0          0        0
          -------------------------------------------------------------

Memory Dynamic Components              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Min/Max sizes since instance startup
-> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
-> ordered by Component

                 Begin Snap     Current         Min         Max   Oper Last Op
Component         Size (Mb)   Size (Mb)   Size (Mb)   Size (Mb)  Count Typ/Mod
--------------- ----------- ----------- ----------- ----------- ------ -------
ASM Buffer Cach         .00         .00         .00         .00      0 STA/
DEFAULT 16K buf         .00         .00         .00         .00      0 STA/
DEFAULT 2K buff         .00         .00         .00         .00      0 STA/
DEFAULT 32K buf         .00         .00         .00         .00      0 STA/
DEFAULT 4K buff         .00         .00         .00         .00      0 STA/
DEFAULT 8K buff         .00         .00         .00         .00      0 STA/
DEFAULT buffer       784.00      784.00      784.00      816.00      0 SHR/IMM
KEEP buffer cac         .00         .00         .00         .00      0 STA/
PGA Target         1,136.00    1,136.00    1,136.00    1,136.00      0 STA/
RECYCLE buffer          .00         .00         .00         .00      0 STA/
SGA Target         2,144.00    2,144.00    2,144.00    2,144.00      0 STA/
Shared IO Pool          .00         .00         .00         .00      0 STA/
java pool             16.00       16.00       16.00       16.00      0 STA/
large pool            16.00       16.00       16.00       16.00      0 STA/
shared pool        1,264.00    1,264.00    1,264.00    1,264.00      0 STA/
streams pool          32.00       32.00         .00       32.00      0 GRO/IMM
          -------------------------------------------------------------

Memory Resize Operations Summary        DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Memory Resize Ops                       DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Process Memory Summary                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> B: Begin Snap   E: End Snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
-> Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> ordered by Begin/End snapshot, Alloc (MB) desc

                                                            Hist
                                    Avg  Std Dev     Max     Max
               Alloc      Used    Alloc    Alloc   Alloc   Alloc    Num    Num
  Category      (MB)      (MB)     (MB)     (MB)    (MB)    (MB)   Proc  Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other        385.0       N/A      3.9      8.0      28      32     99     99
  Freeable      56.4        .0      1.0       .7       4     N/A     54     54
  SQL           46.0      45.2       .6      4.5      39     133     77     71
  PL/SQL         1.1        .8       .0       .0       0       0     97     97
E Other        389.4       N/A      3.7      7.8      28      33    104    104
  SQL           49.5      48.7       .6      4.4      39     133     81     74
  Freeable      44.6        .0       .9       .6       4     N/A     48     48
  PL/SQL         1.1        .8       .0       .0       0       1    102    102
          -------------------------------------------------------------

SGA Memory Summary                      DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                                                      End Size (Bytes)
SGA regions                     Begin Size (Bytes)      (if different)
------------------------------ ------------------- -------------------
Database Buffers                       822,083,584
Fixed Size                               2,218,152
Redo Buffers                            15,970,304
Variable Size                        2,583,693,144
                               -------------------
sum                                  3,423,965,184
          -------------------------------------------------------------

SGA breakdown difference                DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> ordered by Pool, Name
-> N/A value for Begin MB or End MB indicates the size of that Pool/Name was
   insignificant, or zero in that snapshot

Pool   Name                                 Begin MB         End MB  % Diff
------ ------------------------------ -------------- -------------- -------
java   free memory                              16.0           16.0    0.00
large  PX msg pool                               7.5            7.5    0.00
large  free memory                               8.5            8.5    0.00
shared CCUR                                     84.6           85.3    0.83
shared FileOpenBlock                            15.2           15.2    0.00
shared KGLHD                                    28.3           28.1   -0.88
shared PCUR                                     77.6           77.4   -0.35
shared SQLA                                    473.6          467.5   -1.30
shared free memory                             359.3          368.1    2.46
stream KTG hash buckets                          1.3            1.3    0.00
stream free memory                              30.7           30.7    0.00
       buffer_cache                            784.0          784.0    0.00
       fixed_sga                                 2.1            2.1    0.00
       log_buffer                               15.2           15.2    0.00
          -------------------------------------------------------------

Streams CPU/IO Usage                   DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Streams processes ordered by Foreground CPU Time, descending

                                     Foreground      User IO       SYS IO
Session Type         First Logon    CPU time(s) Wait time(s) Wait time(s)
-------------------- ------------- ------------ ------------ ------------
QMON Coordinator     0326 18:10:23          0.0          0.0          0.0
QMON Slaves          0326 18:10:33          0.0          0.0          0.0
          -------------------------------------------------------------

Streams Capture                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Streams Capture Rate                    DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Streams Apply                           DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Streams Apply Rate                      DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffered Queues                         DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffered Queue Subscribers              DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Rule Set                                DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Persistent Queues                       DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by Queue Name
-> * indicates queue (re)started between Begin/End snaps
-> %Exp Msgs   - % of msgs enqueued with expiry
-> %Delay Msgs - % of msgs enqueued with delay
-> %Trasf Time - % of Enqueue time spent in transformation
-> %Eval Time  - % of Enqueue time spent in rule evaluation

        Enq        Deq   %Exp  %Delay      Enq      Deq   %Transf   %Eval
       Msgs       Msgs   Msgs    Msgs  Time(s)  Time(s)      Time    Time
 ---------- ---------- ------ ------- -------- -------- --------- -------
SYS.ALERT_QUE(12343)
          0          0    N/A     N/A      0.0      0.0       N/A     N/A
SYS.AQ$_ALERT_QT_E(12342)
          0          0    N/A     N/A      0.0      0.0       N/A     N/A
SYSMAN.MGMT_NOTIFY_Q(66903)
          0          0    N/A     N/A      0.0      0.0       N/A     N/A
SYSMAN.MGMT_TASK_Q(66573)
         59         59    0.0     0.0      1.6      2.9       0.0     0.0
          -------------------------------------------------------------

Persistent Queues Rate                  DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by Queue Name
-> * indicates queue (re)started between Begin/End snaps

    Enqueue    Dequeue   Avg Enqueue   Avg Dequeue
   Msgs/sec   Msgs/sec     sec / msg     sec / msg
 ---------- ---------- ------------- -------------
SYS.ALERT_QUE(12343)
       0.00       0.00           N/A           N/A
SYS.AQ$_ALERT_QT_E(12342)
       0.00       0.00           N/A           N/A
SYSMAN.MGMT_NOTIFY_Q(66903)
       0.00       0.00           N/A           N/A
SYSMAN.MGMT_TASK_Q(66573)
       0.02       0.02          0.03          0.05
          -------------------------------------------------------------

Persistent Queue Subscribers            DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by Queue Name, Subscriber Name
-> * indicates Subscriber activity (re)started between Begin/End snaps

    Enqueue    Dequeue     Expire    Enqueue    Dequeue     Expire
       Msgs       Msgs       Msgs   Msgs/sec   Msgs/sec   Msgs/sec
 ---------- ---------- ---------- ---------- ---------- ----------
HAE_SUB(1)/SYS.ALERT_QUE
          0          0          0        N/A        N/A        N/A
VM19216800003_3938_MYCAR(22)/SYS.ALERT_QUE
          0          0          0       0.00       0.00       0.00
          -------------------------------------------------------------

Resource Limit Stats                         DB/Inst: MYCAR/mycar  Snap: 9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Shared Servers Activity                 DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Values represent averages for all samples

   Avg Total   Avg Active    Avg Total   Avg Active    Avg Total   Avg Active
 Connections  Connections Shared Srvrs Shared Srvrs  Dispatchers  Dispatchers
------------ ------------ ------------ ------------ ------------ ------------
           0            0            1            0            1            0
          -------------------------------------------------------------

Shared Servers Rates                    DB/Inst: MYCAR/mycar  Snaps: 9474-9475

  Common     Disp                        Common       Disp     Server
   Queue    Queue   Server    Server      Queue      Queue      Total     Server
 Per Sec  Per Sec Msgs/Sec    KB/Sec      Total      Total       Msgs  Total(KB)
-------- -------- -------- --------- ---------- ---------- ---------- ----------
       0        0        0       0.0          0          0          0          0
          -------------------------------------------------------------

Shared Servers Utilization              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Statistics are combined for all servers
-> Incoming and Outgoing Net % are included in %Busy

  Total Server                    Incoming  Outgoing
      Time (s)    %Busy    %Idle     Net %     Net %
-------------- -------- -------- --------- ---------
         3,626      0.0    100.0       0.0       0.0
          -------------------------------------------------------------

Shared Servers Common Queue             DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

Shared Servers Dispatchers              DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> Ordered by %Busy, descending
-> Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
-> Name suffixes:
     "(N)" - dispatcher started between begin and end snapshots
     "(R)" - dispatcher re-started between begin and end snapshots

              Avg Total Disp                        Total Total Queue  Avg Queue
Name        Conns   Time (s)    %Busy    %Idle     Queued    Wait (s)  Wait (ms)
------- --------- ---------- -------- -------- ---------- ----------- ----------
D000          0.0      3,626      0.0    100.0          0           0
          -------------------------------------------------------------

init.ora Parameters                    DB/Inst: MYCAR/mycar  Snaps: 9474-9475
-> if IP/Public/Source at End snap is different a '*' is displayed

                                                                End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
audit_file_dest               /oracle/admin/mycar/adump
audit_trail                   DB
compatible                    11.2.0.0.0
control_files                 /oracle/oradata/mycar/control01.c
db_block_size                 8192
db_domain
db_name                       mycar
db_recovery_file_dest         /oracle/flash_recovery_area
db_recovery_file_dest_size    4070572032
deferred_segment_creation     FALSE
diagnostic_dest               /oracle
dispatchers                   (PROTOCOL=TCP) (SERVICE=mycarXDB)
log_archive_dest_1            location=/oracle/oradata/archivel
log_archive_format            archive_%t_%s_%r.log
log_archive_max_processes     10
memory_target                 3439329280
open_cursors                  300
processes                     500
remote_login_passwordfile     EXCLUSIVE
sec_case_sensitive_logon      FALSE
undo_retention                14400
undo_tablespace               UNDOTBS1
workarea_size_policy          AUTO
          -------------------------------------------------------------

Dynamic Remastering Stats               DB/Inst: MYCAR/mycar  Snaps: 9474-9475

                  No data exists for this section of the report.
          -------------------------------------------------------------

End of Report

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22126868/viewspace-764723/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-10-21

  • 博文量
    20
  • 访问量
    54695