ITPub博客

首页 > Linux操作系统 > Linux操作系统 > awr txt 档

awr txt 档

原创 Linux操作系统 作者:tom_xieym 时间:2012-01-12 17:06:44 0 删除 编辑

WORKLOAD REPOSITORY report for

DB Name         DB Id    Instance     Inst Num Release     RAC Host       
------------ ----------- ------------ -------- ----------- --- ------------
HREMPLOY      3933957540 hremploy            1 10.2.0.4.0  NO  pceghrdb   

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:     13789 12-1月 -12 04:00:20       41       5.6
  End Snap:     13790 12-1月 -12 05:00:22       42       7.6
   Elapsed:               60.03 (mins)
   DB Time:               50.36 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:       656M       720M  Std Block Size:         8K
           Shared Pool Size:       832M       768M      Log Buffer:    14,348K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:              7,809.16                896.84
              Logical reads:             16,036.65              1,841.72
              Block changes:                 46.94                  5.39
             Physical reads:                157.96                 18.14
            Physical writes:                  1.72                  0.20
                 User calls:                394.47                 45.30
                     Parses:                 83.38                  9.58
                Hard parses:                  2.30                  0.26
                      Sorts:              1,991.40                228.70
                     Logons:                 69.98                  8.04
                   Executes:              1,754.46                201.49
               Transactions:                  8.71

  % Blocks changed per Read:    0.29    Recursive Call %:    90.10
 Rollback per transaction %:    0.18       Rows per Sort:     2.60

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   99.02    In-memory Sort %:  100.00
            Library Hit   %:   99.62        Soft Parse %:   97.24
         Execute to Parse %:   95.25         Latch Hit %:   99.67
Parse CPU to Parse Elapsd %:   43.54     % Non-Parse CPU:   98.09

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   60.47   56.65
    % SQL with executions>1:   50.90   56.22
  % Memory for SQL w/exec>1:   46.51   52.49

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
db file sequential read             448,782       1,150      3   38.1   User I/O
CPU time                                          1,120          37.1          
log file parallel write              24,134         459     19   15.2 System I/O
control file parallel write           3,045          99     32    3.3 System I/O
log file sync                         1,816          41     23    1.4     Commit
          -------------------------------------------------------------      
Time Model Statistics          DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total time in database user-calls (DB Time): 3021.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                              2,928.6         96.9
DB CPU                                                1,120.1         37.1
PL/SQL execution elapsed time                            94.6          3.1
parse time elapsed                                       32.6          1.1
hard parse elapsed time                                  24.3           .8
hard parse (sharing criteria) elapsed time                3.0           .1
PL/SQL compilation elapsed time                           1.4           .0
connection management call elapsed time                   1.0           .0
failed parse elapsed time                                 0.2           .0
hard parse (bind mismatch) elapsed time                   0.1           .0
repeated bind elapsed time                                0.1           .0
sequence load elapsed time                                0.0           .0
DB time                                               3,021.4          N/A
background elapsed time                                 614.6          N/A
background cpu time                                       6.6          N/A
          -------------------------------------------------------------      

Wait Class                      DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> s  - second     
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc

                                                                  Avg         
                                       %Time       Total Wait    wait     Waits
Wait Class                      Waits  -outs         Time (s)    (ms)      /txn
-------------------- ---------------- ------ ---------------- ------- ---------
User I/O                      467,742     .0            1,169       2      14.9
System I/O                    103,724     .0              558       5       3.3
Other                         959,495    4.5               55       0      30.6
Commit                          1,816     .0               41      23       0.1
Concurrency                       290    5.2                1       3       0.0
Network                       184,831     .0                0       0       5.9
Application                       776     .0                0       0       0.0
          -------------------------------------------------------------      

Wait Events                    DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> s  - second     
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg         
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
db file sequential read             448,782     .0       1,150       3      14.3
log file parallel write              24,134     .0         459      19       0.8
control file parallel write           3,045     .0          99      32       0.1
log file sync                         1,816     .0          41      23       0.1
PX Deq Credit: send blkd            225,972     .0          35       0       7.2
PX Deq: Signal ACK                  478,481    7.7          13       0      15.3
db file scattered read               17,337     .0          11       1       0.6
enq: PS - contention                227,359     .0           5       0       7.2
db file parallel read                    98     .0           4      45       0.0
read by other session                   739     .0           3       4       0.0
enq: CF - contention                     10     .0           1     100       0.0
os thread startup                        48     .0           1      14       0.0
PX qref latch                        14,178   45.3           1       0       0.5
control file sequential read         76,447     .0           0       0       2.4
SQL*Net break/reset to clien            776     .0           0       0       0.0
latch: session allocation            10,245     .0           0       0       0.3
SQL*Net more data to client          19,238     .0           0       0       0.6
log file sequential read                 52     .0           0       4       0.0
cursor: pin S wait on X                  17   88.2           0       9       0.0
log file single write                     8     .0           0      19       0.0
SQL*Net message to client           162,543     .0           0       0       5.2
latch: shared pool                      193     .0           0       1       0.0
latch free                            3,156     .0           0       0       0.1
enq: JS - queue lock                      1     .0           0      50       0.0
Log archive I/O                          38     .0           0       1       0.0
SQL*Net more data from clien            308     .0           0       0       0.0
SQL*Net message to dblink             2,742     .0           0       0       0.1
direct path write temp                  356     .0           0       0       0.0
latch: parallel query alloc              28     .0           0       0       0.0
rdbms ipc reply                          20     .0           0       0       0.0
latch: library cache                     18     .0           0       0       0.0
PX Deq: Table Q qref                     24     .0           0       0       0.0
latch: enqueue hash chains                4     .0           0       0       0.0
direct path read                        250     .0           0       0       0.0
latch: cache buffers chains               8     .0           0       0       0.0
direct path write                       180     .0           0       0       0.0
buffer busy waits                         3     .0           0       0       0.0
latch: library cache lock                 1     .0           0       0       0.0
LGWR wait for redo copy                  10     .0           0       0       0.0
cursor: pin S                             7     .0           0       0       0.0
latch: In memory undo latch               2     .0           0       0       0.0
SQL*Net message from client         162,541     .0      32,498     200       5.2
PX Idle Wait                        252,975    1.4       7,599      30       8.1
jobq slave wait                       1,772   95.6       5,129    2894       0.1
virtual circuit status                  120  100.0       3,505   29208       0.0
Streams AQ: qmn coordinator             261   51.0       3,500   13411       0.0
Streams AQ: qmn slave idle w            128     .0       3,500   27345       0.0
Streams AQ: waiting for time              1  100.0       1,917 #######       0.0
PX Deq: Execution Msg             2,271,419     .0         341       0      72.4
PX Deq: Execute Reply             1,069,444     .0         291       0      34.1
SQL*Net message from dblink           2,743     .0         133      48       0.1
PX Deq: Join ACK                    203,970     .0          28       0       6.5
PX Deq: Parse Reply                 226,153     .0          18       0       7.2
PX Deq: Msg Fragment                167,097     .0           9       0       5.3
PX Deq: Table Q Sample                   86    2.3           4      46       0.0
PX Deq: Table Q Normal                   76     .0           0       0       0.0
class slave wait                          2     .0           0       0       0.0
          -------------------------------------------------------------      

Background Wait Events         DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg         
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
log file parallel write              24,136     .0         459      19       0.8
control file parallel write           3,045     .0          99      32       0.1
db file sequential read               2,894     .0           1       0       0.1
os thread startup                        34     .0           0      15       0.0
events in waitclass Other                37     .0           0      10       0.0
db file scattered read                  170     .0           0       1       0.0
log file sequential read                 52     .0           0       4       0.0
control file sequential read         11,593     .0           0       0       0.4
log file single write                     8     .0           0      19       0.0
Log archive I/O                          38     .0           0       1       0.0
latch: shared pool                        1     .0           0       1       0.0
direct path read                        250     .0           0       0       0.0
buffer busy waits                         4     .0           0       0       0.0
direct path write                       152     .0           0       0       0.0
latch: In memory undo latch               1     .0           0       0       0.0
rdbms ipc message                    27,061   42.1      36,438    1347       0.9
smon timer                              361     .0       3,584    9929       0.0
pmon timer                            1,518  100.0       3,519    2318       0.0
Streams AQ: qmn coordinator             261   51.0       3,500   13411       0.0
Streams AQ: qmn slave idle w            128     .0       3,500   27345       0.0
Streams AQ: waiting for time              1  100.0       1,917 #######       0.0
          -------------------------------------------------------------      

Operating System Statistics     DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

Statistic                                       Total
-------------------------------- --------------------
BUSY_TIME                                      82,980
IDLE_TIME                                   2,799,138
IOWAIT_TIME                                   127,032
NICE_TIME                                          43
SYS_TIME                                        8,932
USER_TIME                                      73,397
LOAD                                                2
RSRC_MGR_CPU_WAIT_TIME                              0
PHYSICAL_MEMORY_BYTES                   4,140,408,832
NUM_CPUS                                            8
NUM_CPU_SOCKETS                                     2
          -------------------------------------------------------------      

Service Statistics             DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> ordered by DB Time

                                                             Physical    Logical
Service Name                      DB Time (s)   DB CPU (s)      Reads      Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS                             2,816.8      1,072.6    445,205 ##########
hremploy                                187.0         46.2    116,432  3,111,829
SYS$BACKGROUND                            0.0          0.0      6,867     50,064
hremployXDB                               0.0          0.0          0          0
          -------------------------------------------------------------      

Service Wait Class Stats        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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 centisecond (100th of a second)

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                                                      
   396217    106991       180        28         0         0      4249         1
hremploy                                                       
    66493      9526        57        19         0         0    180268        33
SYS$BACKGROUND                                                 
     4986       323        39        49         0         0         0         0
          -------------------------------------------------------------      

SQL ordered by Elapsed Time    DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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

  Elapsed      CPU                  Elap per  % Total             
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id   
---------- ---------- ------------ ---------- ------- -------------
       339        107            2      169.6    11.2 dn66wyxfw5769
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

       253         89       25,176        0.0     8.4 f3a4vwufkr872
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'OJT' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

       155         58            4       38.7     5.1 5495w446zwpc5
Module: DBMS_SCHEDULER
call TIMER_GET_NOKAOQINEMPLOYEE ( )

       140         93       27,346        0.0     4.6 d1yb8kknk59na
Module: w3wp.exe
SELECT SUM (HOURS) FROM OTM_ADVANCEAPPLY WHERE WORKNO = :B4 AND OTDATE >= :B3 AN
D OTDATE <= :B2 AND ID<>:B1 AND STATUS <> '3' AND IMPORTFLAG='N'

       107         62            4       26.8     3.6 84tu07tmzwq2r
Module: DBMS_SCHEDULER
call TIMER_DISPOSE_KQDATAEXCEPTION ( )

        95         45       25,176        0.0     3.1 aaf3a5yc6rr29
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('GEK', 'MAK', 'IEK') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        87         11       25,176        0.0     2.9 5fs6jwxv03kw3
Module: w3wp.exe
SELECT NVL (TO_CHAR (MAX (A.EFFECTDATE), 'yyyy/MM/dd'), 'N') FROM HRM_EMPMOVE A,
 HRM_LEVEL B, HRM_LEVEL C WHERE B.LEVELCODE = A.BEFOREVALUE AND C.LEVELCODE = A.
AFTERVALUE AND A.WORKNO = :B2 AND A.MOVETYPECODE = 'P01' AND TO_CHAR (A.EFFECTDA
TE, 'yyyy') = :B1 AND B.LEVELTYPE = 'B' AND C.LEVELTYPE = 'A'

        87         43       25,176        0.0     2.9 91946k7t9qgu3
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('SPK', 'PRD', 'MAS') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        86         57       29,083        0.0     2.9 7xf6b57w2at4d
Module: w3wp.exe
SELECT SUM (CONFIRMHOURS) FROM OTM_REALAPPLY WHERE WORKNO = :B3 AND OTDATE >= :B
2 AND OTDATE <= :B1 AND STATUS <> '3'

        84         71      139,799        0.0     2.8 b8bqrymty1fha
Module: w3wp.exe
SELECT SUM (LVTOTAL) FROM KQM_LEAVEDETAIL A WHERE WORKNO = :B2 AND LVDATE = :B1
AND EXISTS (SELECT 1 FROM KQM_LEAVEAPPLY B WHERE B.ID = A.ID AND B.STATUS IN('2'
,'4'))

        73         17       25,176        0.0     2.4 fnxdc2py0v7ns
Module: w3wp.exe
SELECT NVL (SUM (ENDDATE - STARTDATE + 1), 0) FROM KQM_LEAVEAPPLY WHERE TO_CHAR
(STARTDATE, 'yyyy') = :B2 AND TO_CHAR (ENDDATE, 'yyyy') = :B2 AND WORKNO = :B1 A
ND LVTYPECODE IN ('f', 'd', 'h', 'e', 'g', 's', 'S', 'Z', 'R', 'V', 'W', 'k', 'r
SQL ordered by Elapsed Time    DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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

  Elapsed      CPU                  Elap per  % Total             
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id   
---------- ---------- ------------ ---------- ------- -------------
', 'x') AND STATUS IN ('2', '4') AND ENDDATE >= STARTDATE + 14

        61         47      140,066        0.0     2.0 3dyuqvd5kyzrj
Module: w3wp.exe
SELECT 1 FROM KQM_KAOQINDATA WHERE KQDATE = :B2 AND WORKNO = :B1 AND ONDUTYTIME
IS NULL AND OFFDUTYTIME IS NULL AND EXCEPTIONTYPE IN('C','D') AND ROWNUM=1

        58          6            0        N/A     1.9 85kan7rhcqv6a
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

        58          1          551        0.1     1.9 fxw3rb4bdjnda
Module: DBMS_SCHEDULER
SELECT TO_CHAR(KQDATE,'yyyy/mm/dd') AS KQDATE FROM KQM_KAOQINDATA A WHERE A.WORK
NO=:B3 AND (EXCEPTIONTYPE IS NULL OR EXCEPTIONTYPE NOT IN('J','K','L','R','S','T
','V','Y','W','C','Z','d','e','f','g','h','r','s','t','x')) AND (ONDUTYTIME>TO_D
ATE('1901/12/31','yyyy/mm/dd') OR OFFDUTYTIME>TO_DATE('1901/12/31','yyyy/mm/dd')

        57          1            0        N/A     1.9 6bg4pacs7xs5b
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

        51         10       28,202        0.0     1.7 9pyut3vrk4mzx
Module: DBMS_SCHEDULER
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE WORKNO=:B2 AND STARTDATE<=:B1 AND :B
1 <=ENDDATE

        38         35       25,176        0.0     1.3 6c03pmva6bv8v
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'KNE' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

        37         37       26,543        0.0     1.2 4p69wtd63gs5n
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND EFFECTFLAG = 'Y' AND ISTEACHER = 'Y'

        34          7          388        0.1     1.1 9c2b0pk944bw5
Module: w3wp.exe
begin prog_page(P_PAGESIZE=>:V00001, P_PAGENO=>:V00002, P_SQLSELECT=>:V00003, P_
OUTCURSOR=>:R000C000); end;

        31         31      319,037        0.0     1.0 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

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

SQL ordered by CPU Time        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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

    CPU      Elapsed                  CPU per  % Total             
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id   
---------- ---------- ------------ ----------- ------- -------------
       107        339            2       53.27    11.2 dn66wyxfw5769
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

        93        140       27,346        0.00     4.6 d1yb8kknk59na
Module: w3wp.exe
SELECT SUM (HOURS) FROM OTM_ADVANCEAPPLY WHERE WORKNO = :B4 AND OTDATE >= :B3 AN
D OTDATE <= :B2 AND ID<>:B1 AND STATUS <> '3' AND IMPORTFLAG='N'

        89        253       25,176        0.00     8.4 f3a4vwufkr872
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'OJT' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

        71         84      139,799        0.00     2.8 b8bqrymty1fha
Module: w3wp.exe
SELECT SUM (LVTOTAL) FROM KQM_LEAVEDETAIL A WHERE WORKNO = :B2 AND LVDATE = :B1
AND EXISTS (SELECT 1 FROM KQM_LEAVEAPPLY B WHERE B.ID = A.ID AND B.STATUS IN('2'
,'4'))

        62        107            4       15.42     3.6 84tu07tmzwq2r
Module: DBMS_SCHEDULER
call TIMER_DISPOSE_KQDATAEXCEPTION ( )

        58        155            4       14.58     5.1 5495w446zwpc5
Module: DBMS_SCHEDULER
call TIMER_GET_NOKAOQINEMPLOYEE ( )

        57         86       29,083        0.00     2.9 7xf6b57w2at4d
Module: w3wp.exe
SELECT SUM (CONFIRMHOURS) FROM OTM_REALAPPLY WHERE WORKNO = :B3 AND OTDATE >= :B
2 AND OTDATE <= :B1 AND STATUS <> '3'

        47         61      140,066        0.00     2.0 3dyuqvd5kyzrj
Module: w3wp.exe
SELECT 1 FROM KQM_KAOQINDATA WHERE KQDATE = :B2 AND WORKNO = :B1 AND ONDUTYTIME
IS NULL AND OFFDUTYTIME IS NULL AND EXCEPTIONTYPE IN('C','D') AND ROWNUM=1

        45         95       25,176        0.00     3.1 aaf3a5yc6rr29
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('GEK', 'MAK', 'IEK') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        43         87       25,176        0.00     2.9 91946k7t9qgu3
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('SPK', 'PRD', 'MAS') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        37         37       26,543        0.00     1.2 4p69wtd63gs5n
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND EFFECTFLAG = 'Y' AND ISTEACHER = 'Y'

        35         38       25,176        0.00     1.3 6c03pmva6bv8v
Module: w3wp.exe
SQL ordered by CPU Time        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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

    CPU      Elapsed                  CPU per  % Total             
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id   
---------- ---------- ------------ ----------- ------- -------------
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'KNE' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

        31         31      319,037        0.00     1.0 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

        17         73       25,176        0.00     2.4 fnxdc2py0v7ns
Module: w3wp.exe
SELECT NVL (SUM (ENDDATE - STARTDATE + 1), 0) FROM KQM_LEAVEAPPLY WHERE TO_CHAR
(STARTDATE, 'yyyy') = :B2 AND TO_CHAR (ENDDATE, 'yyyy') = :B2 AND WORKNO = :B1 A
ND LVTYPECODE IN ('f', 'd', 'h', 'e', 'g', 's', 'S', 'Z', 'R', 'V', 'W', 'k', 'r
', 'x') AND STATUS IN ('2', '4') AND ENDDATE >= STARTDATE + 14

        11         87       25,176        0.00     2.9 5fs6jwxv03kw3
Module: w3wp.exe
SELECT NVL (TO_CHAR (MAX (A.EFFECTDATE), 'yyyy/MM/dd'), 'N') FROM HRM_EMPMOVE A,
 HRM_LEVEL B, HRM_LEVEL C WHERE B.LEVELCODE = A.BEFOREVALUE AND C.LEVELCODE = A.
AFTERVALUE AND A.WORKNO = :B2 AND A.MOVETYPECODE = 'P01' AND TO_CHAR (A.EFFECTDA
TE, 'yyyy') = :B1 AND B.LEVELTYPE = 'B' AND C.LEVELTYPE = 'A'

        10         51       28,202        0.00     1.7 9pyut3vrk4mzx
Module: DBMS_SCHEDULER
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE WORKNO=:B2 AND STARTDATE<=:B1 AND :B
1 <=ENDDATE

         7         34          388        0.02     1.1 9c2b0pk944bw5
Module: w3wp.exe
begin prog_page(P_PAGESIZE=>:V00001, P_PAGENO=>:V00002, P_SQLSELECT=>:V00003, P_
OUTCURSOR=>:R000C000); end;

         6         58            0         N/A     1.9 85kan7rhcqv6a
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

         1         57            0         N/A     1.9 6bg4pacs7xs5b
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

         1         58          551        0.00     1.9 fxw3rb4bdjnda
Module: DBMS_SCHEDULER
SELECT TO_CHAR(KQDATE,'yyyy/mm/dd') AS KQDATE FROM KQM_KAOQINDATA A WHERE A.WORK
NO=:B3 AND (EXCEPTIONTYPE IS NULL OR EXCEPTIONTYPE NOT IN('J','K','L','R','S','T
','V','Y','W','C','Z','d','e','f','g','h','r','s','t','x')) AND (ONDUTYTIME>TO_D
ATE('1901/12/31','yyyy/mm/dd') OR OFFDUTYTIME>TO_DATE('1901/12/31','yyyy/mm/dd')

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

SQL ordered by Gets            DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:      57,763,579
-> Captured SQL account for     118.1% of Total

                                Gets              CPU     Elapsed              
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id   
-------------- ------------ ------------ ------ -------- --------- -------------
    12,055,643            4  3,013,910.8   20.9    61.70    107.33 84tu07tmzwq2r
Module: DBMS_SCHEDULER
call TIMER_DISPOSE_KQDATAEXCEPTION ( )

    11,897,551            2  5,948,775.5   20.6   106.54    339.30 dn66wyxfw5769
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

     7,824,451            4  1,956,112.8   13.5    58.34    154.81 5495w446zwpc5
Module: DBMS_SCHEDULER
call TIMER_GET_NOKAOQINEMPLOYEE ( )

     6,854,956      319,037         21.5   11.9    31.07     31.23 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

     5,512,815      308,876         17.8    9.5    24.38     24.38 1cpvnmh47uhhd
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT WHERE LEVELCODE = '0' START WITH DEPCODE = :B
1 CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

     5,208,813          502     10,376.1    9.0    13.22     13.28 72sdq3nv5pj6t
Module: DBMS_SCHEDULER
UPDATE KQM_KAOQINDATA SET FFDUTYEXCEPT='D',STATUS='1',EXCEPTIONTYPE='D', PROCES
SFLAG='Y',MODIFYDATE=SYSDATE WHERE KQDATE=:B2 AND SHIFTNO=:B1 AND STATUS<'2' AND
 (OFFDUTYTIME IS NULL) AND (PROCESSFLAG IS NULL OR PROCESSFLAG<>'Y') AND ((EXCEP
TIONTYPE<>'F' AND EXCEPTIONTYPE<>'E' AND EXCEPTIONTYPE<>'H' AND EXCEPTIONTYPE<>'

     3,705,307    1,922,802          1.9    6.4    16.61     16.74 5sg7n6k6qmhzq
Module: DBMS_SCHEDULER
SELECT WORKFLAG FROM KQM_BUCALENDAR WHERE WORKDAY = :B2 AND BUCODE = :B1

     3,546,993      159,397         22.3    6.1     7.35      7.63 8g3y5hwn2610u
Module: w3wp.exe
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE :B2 BETWEEN STARTDATE AND ENDDATE AN
D WORKNO = :B1

     3,181,895          258     12,332.9    5.5     7.27      7.34 dj07hut92rtwm
Module: DBMS_SCHEDULER
UPDATE KQM_KAOQINDATA SET FFDUTYEXCEPT='D',STATUS='1',EXCEPTIONTYPE='D',PROCESS
FLAG='Y',MODIFYDATE=SYSDATE WHERE KQDATE=:B2 -1 AND SHIFTNO=:B1 AND STATUS<'2' A
ND (OFFDUTYTIME IS NULL) AND (PROCESSFLAG IS NULL OR PROCESSFLAG<>'Y') AND ((EXC
EPTIONTYPE<>'F' AND EXCEPTIONTYPE<>'E' AND EXCEPTIONTYPE<>'H' AND EXCEPTIONTYPE<

     2,496,114       26,543         94.0    4.3    36.93     36.94 4p69wtd63gs5n
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND EFFECTFLAG = 'Y' AND ISTEACHER = 'Y'

     1,652,740      139,799         11.8    2.9    71.03     84.19 b8bqrymty1fha
Module: w3wp.exe
SELECT SUM (LVTOTAL) FROM KQM_LEAVEDETAIL A WHERE WORKNO = :B2 AND LVDATE = :B1
AND EXISTS (SELECT 1 FROM KQM_LEAVEAPPLY B WHERE B.ID = A.ID AND B.STATUS IN('2'
,'4'))

     1,632,721       25,176         64.9    2.8    45.21     94.84 aaf3a5yc6rr29
SQL ordered by Gets            DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:      57,763,579
-> Captured SQL account for     118.1% of Total

                                Gets              CPU     Elapsed              
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id   
-------------- ------------ ------------ ------ -------- --------- -------------
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('GEK', 'MAK', 'IEK') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

     1,590,251       25,176         63.2    2.8    43.14     86.80 91946k7t9qgu3
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('SPK', 'PRD', 'MAS') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

     1,525,164       25,176         60.6    2.6    89.06    253.10 f3a4vwufkr872
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'OJT' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

     1,342,476        1,008      1,331.8    2.3     4.52      4.63 4bt9vrkvdnn41
Module: oracle@node2 (TNS V1-V3)
SELECT "A1"."LOCALNAME","A1"."SEX",TO_CHAR("A1"."JOINDATE",'yyyy/MM/dd'),"A1"."D
EPCODE","A1"."CBGNAME","A1"."BUNAME",TO_CHAR("A1"."LEAVEDATE",'yyyy/MM/dd') FROM
 "OHSS_LH"."V_EMPLOYEEINFO" "A1" WHERE "A1"."WORKNO"=:B1 AND ROWNUM=1

     1,254,761      319,037          3.9    2.2     3.62      3.62 3xa3kh4s8wrp2
Module: DBMS_SCHEDULER
SELECT DCODE FROM V_EMPLOYEE WHERE WORKNO = :B1

     1,174,254       25,176         46.6    2.0    34.63     38.00 6c03pmva6bv8v
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'KNE' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

     1,080,998       46,612         23.2    1.9     4.00      4.00 6gjqc8v660c91
Module: w3wp.exe
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY PRIOR PARENTDEPCODE = DEPCODE

       926,637      308,882          3.0    1.6     3.76      3.92 4pt8wfzbm10r7
Module: DBMS_SCHEDULER
SELECT WORKFLAG FROM KQM_BGCALENDAR WHERE WORKDAY = :B2 AND BGCODE = :B1

       763,121      266,606          2.9    1.3     4.57      6.50 2c7vgr59ut42x
Module: DBMS_SCHEDULER
SELECT COUNT (1) FROM KQM_MOVESHIFT WHERE WORKNO = :B2 AND WORKDATE = :B1

       667,440       28,202         23.7    1.2    10.05     50.65 9pyut3vrk4mzx
Module: DBMS_SCHEDULER
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE WORKNO=:B2 AND STARTDATE<=:B1 AND :B
1 <=ENDDATE

       601,653      319,221          1.9    1.0     4.24      4.35 g9pt076r6dnzw
Module: DBMS_SCHEDULER
SELECT COUNT(WORKNO) FROM KQM_STRETCHSHIFT WHERE WORKNO=:B2 AND YEARWEEK=:B1

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

SQL ordered by Reads           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Disk Reads:         568,955
-> Captured SQL account for     83.9% of Total

                               Reads              CPU     Elapsed              
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id   
-------------- ----------- ------------- ------ -------- --------- -------------
       126,122           2      63,061.0   22.2   106.54    339.30 dn66wyxfw5769
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

        89,230           4      22,307.5   15.7    61.70    107.33 84tu07tmzwq2r
Module: DBMS_SCHEDULER
call TIMER_DISPOSE_KQDATAEXCEPTION ( )

        57,636           4      14,409.0   10.1    58.34    154.81 5495w446zwpc5
Module: DBMS_SCHEDULER
call TIMER_GET_NOKAOQINEMPLOYEE ( )

        56,082      22,521           2.5    9.9     8.04     21.48 dzp5p6qc92ram
Module: w3wp.exe
SELECT LVTYPECODE,STARTDATE,ENDDATE FROM KQM_LEAVEAPPLY WHERE WORKNO=:B3 AND (ST
ATUS='2' OR STATUS='4') AND ( (( :B2 <=TO_CHAR(STARTDATE,'yyyy/mm/dd')||' '||STA
RTTIME AND TO_CHAR(STARTDATE,'yyyy/mm/dd')||' '||STARTTIME<:B1 ) OR ( :B2 AR(ENDDATE,'yyyy/mm/dd')||' '||ENDTIME AND TO_CHAR(ENDDATE,'yyyy/mm/dd')||' '||E

        49,748         388         128.2    8.7     7.23     34.39 9c2b0pk944bw5
Module: w3wp.exe
begin prog_page(P_PAGESIZE=>:V00001, P_PAGENO=>:V00002, P_SQLSELECT=>:V00003, P_
OUTCURSOR=>:R000C000); end;

        48,992      25,176           1.9    8.6    89.06    253.10 f3a4vwufkr872
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'OJT' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

        27,804           2      13,902.0    4.9     3.67     10.79 1b7296r7mw86w
Module: DBMS_SCHEDULER
DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :myda
te; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname
VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start
TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME

        26,654      27,346           1.0    4.7    92.96    139.59 d1yb8kknk59na
Module: w3wp.exe
SELECT SUM (HOURS) FROM OTM_ADVANCEAPPLY WHERE WORKNO = :B4 AND OTDATE >= :B3 AN
D OTDATE <= :B2 AND ID<>:B1 AND STATUS <> '3' AND IMPORTFLAG='N'

        24,942     140,066           0.2    4.4    47.38     60.69 3dyuqvd5kyzrj
Module: w3wp.exe
SELECT 1 FROM KQM_KAOQINDATA WHERE KQDATE = :B2 AND WORKNO = :B1 AND ONDUTYTIME
IS NULL AND OFFDUTYTIME IS NULL AND EXCEPTIONTYPE IN('C','D') AND ROWNUM=1

        24,586      29,083           0.8    4.3    57.19     86.43 7xf6b57w2at4d
Module: w3wp.exe
SELECT SUM (CONFIRMHOURS) FROM OTM_REALAPPLY WHERE WORKNO = :B3 AND OTDATE >= :B
2 AND OTDATE <= :B1 AND STATUS <> '3'

        22,252      28,202           0.8    3.9    10.05     50.65 9pyut3vrk4mzx
Module: DBMS_SCHEDULER
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE WORKNO=:B2 AND STARTDATE<=:B1 AND :B
1 <=ENDDATE

        19,638      25,176           0.8    3.5    45.21     94.84 aaf3a5yc6rr29
SQL ordered by Reads           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Disk Reads:         568,955
-> Captured SQL account for     83.9% of Total

                               Reads              CPU     Elapsed              
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id   
-------------- ----------- ------------- ------ -------- --------- -------------
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('GEK', 'MAK', 'IEK') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        18,595      25,176           0.7    3.3    43.14     86.80 91946k7t9qgu3
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('SPK', 'PRD', 'MAS') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

        17,550      25,176           0.7    3.1    11.24     87.45 5fs6jwxv03kw3
Module: w3wp.exe
SELECT NVL (TO_CHAR (MAX (A.EFFECTDATE), 'yyyy/MM/dd'), 'N') FROM HRM_EMPMOVE A,
 HRM_LEVEL B, HRM_LEVEL C WHERE B.LEVELCODE = A.BEFOREVALUE AND C.LEVELCODE = A.
AFTERVALUE AND A.WORKNO = :B2 AND A.MOVETYPECODE = 'P01' AND TO_CHAR (A.EFFECTDA
TE, 'yyyy') = :B1 AND B.LEVELTYPE = 'B' AND C.LEVELTYPE = 'A'

        12,753      14,021           0.9    2.2     5.17     10.97 4kcfh5rmmh9un
Module: DBMS_SCHEDULER
SELECT COUNT(WORKNO) FROM KQM_KAOQINDATA WHERE WORKNO=:B2 AND KQDATE=:B1

         9,062     139,799           0.1    1.6    71.03     84.19 b8bqrymty1fha
Module: w3wp.exe
SELECT SUM (LVTOTAL) FROM KQM_LEAVEDETAIL A WHERE WORKNO = :B2 AND LVDATE = :B1
AND EXISTS (SELECT 1 FROM KQM_LEAVEAPPLY B WHERE B.ID = A.ID AND B.STATUS IN('2'
,'4'))

         8,657      25,176           0.3    1.5    16.53     73.01 fnxdc2py0v7ns
Module: w3wp.exe
SELECT NVL (SUM (ENDDATE - STARTDATE + 1), 0) FROM KQM_LEAVEAPPLY WHERE TO_CHAR
(STARTDATE, 'yyyy') = :B2 AND TO_CHAR (ENDDATE, 'yyyy') = :B2 AND WORKNO = :B1 A
ND LVTYPECODE IN ('f', 'd', 'h', 'e', 'g', 's', 'S', 'Z', 'R', 'V', 'W', 'k', 'r
', 'x') AND STATUS IN ('2', '4') AND ENDDATE >= STARTDATE + 14

         7,740           4       1,935.0    1.4     5.40      8.61 6ggf6wk58fa77
Module: DBMS_SCHEDULER
SELECT WORKNO,KQDATE,SHIFTNO,ONDUTYTIME,OFFDUTYTIME,ONDUTYTIME1,OFFDUTYTIME1,EXC
EPTIONTYPE FROM KQM_KAOQINDATA WHERE :B2 <=KQDATE AND KQDATE<=:B1 AND STATUS='1'
 

         7,707          24         321.1    1.4     0.47     11.21 d4twbkb1tjcdn
Module: WHZBhrmNotes.exe
select distinct c.AuditMan as ApproveManNoA,nvl(d.LocalName,(select LocalName Fr
om WFM_EmployeesOut e Where e.WorkNo=c.AuditMan)) ApproveManNameA,nvl(d.Notes,(s
elect Notes From WFM_EmployeesOut e Where e.WorkNo=c.AuditMan)) NotesA,nvl(d.Dep
Name,(select DepName From WFM_EmployeesOut e Where e.WorkNo=c.AuditMan)||'(OutEm

         5,722     159,397           0.0    1.0     7.35      7.63 8g3y5hwn2610u
Module: w3wp.exe
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE :B2 BETWEEN STARTDATE AND ENDDATE AN
D WORKNO = :B1

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

SQL ordered by Executions      DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Executions:       6,319,531
-> Captured SQL account for     78.4% of Total

                                              CPU per    Elap per              
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id   
------------ --------------- -------------- ---------- ----------- -------------
   1,922,802          10,154            0.0       0.00        0.00 5sg7n6k6qmhzq
Module: DBMS_SCHEDULER
SELECT WORKFLAG FROM KQM_BUCALENDAR WHERE WORKDAY = :B2 AND BUCODE = :B1

     319,221         319,218            1.0       0.00        0.00 g9pt076r6dnzw
Module: DBMS_SCHEDULER
SELECT COUNT(WORKNO) FROM KQM_STRETCHSHIFT WHERE WORKNO=:B2 AND YEARWEEK=:B1

     319,037         319,037            1.0       0.00        0.00 3xa3kh4s8wrp2
Module: DBMS_SCHEDULER
SELECT DCODE FROM V_EMPLOYEE WHERE WORKNO = :B1

     319,037       1,932,954            6.1       0.00        0.00 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

     308,882         308,881            1.0       0.00        0.00 4pt8wfzbm10r7
Module: DBMS_SCHEDULER
SELECT WORKFLAG FROM KQM_BGCALENDAR WHERE WORKDAY = :B2 AND BGCODE = :B1

     308,876         308,876            1.0       0.00        0.00 1cpvnmh47uhhd
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT WHERE LEVELCODE = '0' START WITH DEPCODE = :B
1 CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

     266,606         266,604            1.0       0.00        0.00 2c7vgr59ut42x
Module: DBMS_SCHEDULER
SELECT COUNT (1) FROM KQM_MOVESHIFT WHERE WORKNO = :B2 AND WORKDATE = :B1

     159,397         112,956            0.7       0.00        0.00 8g3y5hwn2610u
Module: w3wp.exe
SELECT SHIFTNO FROM KQM_EMPLOYEESHIFT WHERE :B2 BETWEEN STARTDATE AND ENDDATE AN
D WORKNO = :B1

     144,959         144,047            1.0       0.00        0.00 8tbxrbg9q5m6v
Module: w3wp.exe
SELECT TIMEQTY FROM KQM_WORKSHIFT WHERE SHIFTNO = :B1

     140,066           1,146            0.0       0.00        0.00 3dyuqvd5kyzrj
Module: w3wp.exe
SELECT 1 FROM KQM_KAOQINDATA WHERE KQDATE = :B2 AND WORKNO = :B1 AND ONDUTYTIME
IS NULL AND OFFDUTYTIME IS NULL AND EXCEPTIONTYPE IN('C','D') AND ROWNUM=1

     139,799         139,799            1.0       0.00        0.00 b8bqrymty1fha
Module: w3wp.exe
SELECT SUM (LVTOTAL) FROM KQM_LEAVEDETAIL A WHERE WORKNO = :B2 AND LVDATE = :B1
AND EXISTS (SELECT 1 FROM KQM_LEAVEAPPLY B WHERE B.ID = A.ID AND B.STATUS IN('2'
,'4'))

      70,425          70,425            1.0       0.00        0.00 0dg7m28xhgvs5
Module: DBMS_SCHEDULER
SELECT COUNT(WORKNO) FROM KQM_MOVESHIFT WHERE WORKNO=:B2 AND (WORKDATE=:B1 OR NO
WORKDATE=:B1 )

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

SQL ordered by Parse Calls     DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Parse Calls:         300,344
-> Captured SQL account for      88.5% of Total

                            % Total             
 Parse Calls  Executions     Parses    SQL Id   
------------ ------------ --------- -------------
      50,362       26,543     16.77 4p69wtd63gs5n
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND EFFECTFLAG = 'Y' AND ISTEACHER = 'Y'

      50,362       25,176     16.77 aaf3a5yc6rr29
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('GEK', 'MAK', 'IEK') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

      50,361       25,176     16.77 6c03pmva6bv8v
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'KNE' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

      50,361       25,176     16.77 91946k7t9qgu3
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) IN ('SPK', 'PRD', 'MAS') AND EFFECTFLAG = 'Y' AND ISTEACHER
= 'N'

      50,352       25,176     16.76 f3a4vwufkr872
Module: w3wp.exe
SELECT NVL (SUM (CHOUR), 0) FROM ETM_CHOURDETAIL WHERE WORKNO = :B2 AND YEAR = :
B1 AND TRIM (CTYPE) = 'OJT' AND EFFECTFLAG = 'Y' AND ISTEACHER = 'N'

       1,702        1,702      0.57 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

         882          441      0.29 cvzn1whdxf5c7
Module: FetchData.exe
begin Prog_Read_BellCardData(:V00001,:V00002,:V00003,:V00004); end;

         776          388      0.26 9c2b0pk944bw5
Module: w3wp.exe
begin prog_page(P_PAGESIZE=>:V00001, P_PAGENO=>:V00002, P_SQLSELECT=>:V00003, P_
OUTCURSOR=>:R000C000); end;

         742          742      0.25 2ym6hhaq30r73
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis
ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro
m seg$ where ts#=:1 and file#=:2 and block#=:3

         625          625      0.21 08fr7swn9tgxn
Module: w3wp.exe
SELECT * FROM bfw_module WHERE modulecode='' ORDER BY orderid

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

SQL ordered by Sharable Memory DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

SQL ordered by Version Count   DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Only Statements with Version Count greater than 20 are displayed

 Version                          
  Count   Executions     SQL Id   
-------- ------------ -------------
     622          388 9c2b0pk944bw5
Module: w3wp.exe
begin prog_page(P_PAGESIZE=>:V00001, P_PAGENO=>:V00002, P_SQLSELECT=>:V00003, P_
OUTCURSOR=>:R000C000); end;

      42       46,612 6gjqc8v660c91
Module: w3wp.exe
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY PRIOR PARENTDEPCODE = DEPCODE

      42       46,612 6gjqc8v660c91
Module: w3wp.exe
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY PRIOR PARENTDEPCODE = DEPCODE

      38      266,606 2c7vgr59ut42x
Module: DBMS_SCHEDULER
SELECT COUNT (1) FROM KQM_MOVESHIFT WHERE WORKNO = :B2 AND WORKDATE = :B1

      36      319,221 g9pt076r6dnzw
Module: DBMS_SCHEDULER
SELECT COUNT(WORKNO) FROM KQM_STRETCHSHIFT WHERE WORKNO=:B2 AND YEARWEEK=:B1

      35          189 d3apnz76qwmrs
select pol#, usr_name, usr_labels, package, privs from lbac$user_logon where usr
_name = :username

      29      319,037 3xa3kh4s8wrp2
Module: DBMS_SCHEDULER
SELECT DCODE FROM V_EMPLOYEE WHERE WORKNO = :B1

      24       17,033 96g93hntrzjtr
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_
size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, a
vgcln from hist_head$ where obj#=:1 and intcol#=:2

      24      319,037 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

      24      319,037 arpbsapqw4128
Module: DBMS_SCHEDULER
SELECT DEPCODE FROM BFW_DEPARTMENT START WITH DEPCODE IN (SELECT DCODE FROM V_EM
PLOYEE WHERE WORKNO = :B1 ) CONNECT BY DEPCODE = PRIOR PARENTDEPCODE

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

Instance Activity Stats        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session                     66,426           18.4           2.1
CPU used when call started                   21,743            6.0           0.7
CR blocks created                                16            0.0           0.0
Cached Commit SCN referenced                      0            0.0           0.0
Commit SCN cached                                 0            0.0           0.0
DB time                                     772,856          214.6          24.6
DBWR checkpoint buffers written               2,386            0.7           0.1
DBWR checkpoints                                  2            0.0           0.0
DBWR object drop buffers written                  0            0.0           0.0
DBWR parallel query checkpoint b                  0            0.0           0.0
DBWR revisited being-written buf                  0            0.0           0.0
DBWR thread checkpoint buffers w                  0            0.0           0.0
DBWR transaction table writes                   235            0.1           0.0
DBWR undo block writes                        1,597            0.4           0.1
DFO trees parallelized                      125,902           35.0           4.0
IMU CR rollbacks                                  1            0.0           0.0
IMU Flushes                                     129            0.0           0.0
IMU Redo allocation size                    961,656          267.0          30.7
IMU commits                                  31,178            8.7           1.0
IMU contention                                    3            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                   3            0.0           0.0
IMU undo allocation size                112,233,832       31,159.0       3,578.4
IMU- failed to get a private str                  0            0.0           0.0
PX local messages recv'd                  3,777,752        1,048.8         120.5
PX local messages sent                    3,777,752        1,048.8         120.5
Parallel operations downgraded t                  0            0.0           0.0
Parallel operations not downgrad            125,902           35.0           4.0
SMON posted for undo segment shr                  6            0.0           0.0
SQL*Net roundtrips to/from clien            162,308           45.1           5.2
SQL*Net roundtrips to/from dblin              2,736            0.8           0.1
active txn count during cleanout                104            0.0           0.0
application wait time                            22            0.0           0.0
background checkpoints completed                  2            0.0           0.0
background checkpoints started                    2            0.0           0.0
background timeouts                          11,570            3.2           0.4
branch node splits                                0            0.0           0.0
buffer is not pinned count               36,374,823       10,098.6       1,159.8
buffer is pinned count                   49,482,828       13,737.7       1,577.7
bytes received via SQL*Net from          15,278,347        4,241.7         487.1
bytes received via SQL*Net from             624,866          173.5          19.9
bytes sent via SQL*Net to client         62,594,903       17,378.0       1,995.8
bytes sent via SQL*Net to dblink            457,220          126.9          14.6
calls to get snapshot scn: kcmgs          9,511,363        2,640.6         303.3
calls to kcmgas                              34,695            9.6           1.1
calls to kcmgcs                                 769            0.2           0.0
change write time                               100            0.0           0.0
cleanout - number of ktugct call                177            0.1           0.0
cleanouts and rollbacks - consis                  5            0.0           0.0
cleanouts only - consistent read                 34            0.0           0.0
cluster key scan block gets                  17,622            4.9           0.6
cluster key scans                            12,562            3.5           0.4
commit batch performed                            1            0.0           0.0
commit batch requested                            1            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                 19            0.0           0.0
Instance Activity Stats        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
commit cleanout failures: cannot                  0            0.0           0.0
commit cleanouts                             41,773           11.6           1.3
commit cleanouts successfully co             41,754           11.6           1.3
commit immediate performed                        0            0.0           0.0
commit immediate requested                        0            0.0           0.0
commit txn count during cleanout                161            0.0           0.0
concurrency wait time                            97            0.0           0.0
consistent changes                            1,442            0.4           0.1
consistent gets                          57,575,453       15,984.4       1,835.7
consistent gets - examination            16,628,509        4,616.5         530.2
consistent gets direct                           21            0.0           0.0
consistent gets from cache               57,575,432       15,984.4       1,835.7
current blocks converted for CR                   0            0.0           0.0
cursor authentications                        2,870            0.8           0.1
data blocks consistent reads - u                 18            0.0           0.0
db block changes                            169,092           46.9           5.4
db block gets                               188,126           52.2           6.0
db block gets direct                            424            0.1           0.0
db block gets from cache                    187,702           52.1           6.0
deferred (CURRENT) block cleanou             20,245            5.6           0.7
dirty buffers inspected                       1,841            0.5           0.1
enqueue conversions                         511,922          142.1          16.3
enqueue releases                          1,128,711          313.4          36.0
enqueue requests                          1,128,764          313.4          36.0
enqueue timeouts                                 54            0.0           0.0
enqueue waits                               104,456           29.0           3.3
exchange deadlocks                                0            0.0           0.0
execute count                             6,319,531        1,754.5         201.5
failed probes on index block rec                  0            0.0           0.0
frame. signature mismatch                          0            0.0           0.0
free buffer inspected                       610,859          169.6          19.5
free buffer requested                       570,805          158.5          18.2
heap block compress                             254            0.1           0.0
hot buffers moved to head of LRU            491,706          136.5          15.7
immediate (CR) block cleanout ap                 39            0.0           0.0
immediate (CURRENT) block cleano                768            0.2           0.0
index crx upgrade (found)                         0            0.0           0.0
index crx upgrade (positioned)              511,898          142.1          16.3
index fast full scans (full)                     84            0.0           0.0
index fast full scans (rowid ran                  0            0.0           0.0
index fetch by key                        4,574,320        1,270.0         145.9
index scans kdiixs1                       8,586,866        2,383.9         273.8
leaf node 90-10 splits                           17            0.0           0.0
leaf node splits                                 69            0.0           0.0
lob reads                                       418            0.1           0.0
lob writes                                      104            0.0           0.0
lob writes unaligned                            104            0.0           0.0
logons cumulative                           252,067           70.0           8.0
messages received                            25,873            7.2           0.8
messages sent                                25,874            7.2           0.8
no buffer to keep pinned count                    0            0.0           0.0
no work - consistent read gets           36,967,412       10,263.1       1,178.7
opened cursors cumulative                   314,054           87.2          10.0
parse count (failures)                          388            0.1           0.0
parse count (hard)                            8,298            2.3           0.3
parse count (total)                         300,344           83.4           9.6
parse time cpu                                2,140            0.6           0.1
parse time elapsed                            4,915            1.4           0.2
physical read IO requests                   468,386          130.0          14.9
physical read bytes                   4,660,879,360    1,293,979.5     148,606.0
Instance Activity Stats        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
physical read total IO requests             544,976          151.3          17.4
physical read total bytes             5,951,156,736    1,652,193.6     189,744.8
physical read total multi block              17,381            4.8           0.6
physical reads                              568,955          158.0          18.1
physical reads cache                        568,684          157.9          18.1
physical reads cache prefetch               102,185           28.4           3.3
physical reads direct                           271            0.1           0.0
physical reads direct (lob)                       0            0.0           0.0
physical reads direct temporary                   0            0.0           0.0
physical reads prefetch warmup                    0            0.0           0.0
physical write IO requests                    3,784            1.1           0.1
physical write bytes                     50,765,824       14,093.9       1,618.6
physical write total IO requests             61,305           17.0           2.0
physical write total bytes              311,084,544       86,365.0       9,918.5
physical write total multi block             48,099           13.4           1.5
physical writes                               6,197            1.7           0.2
physical writes direct                          574            0.2           0.0
physical writes direct (lob)                     32            0.0           0.0
physical writes direct temporary                385            0.1           0.0
physical writes from cache                    5,623            1.6           0.2
physical writes non checkpoint                5,027            1.4           0.2
pinned buffers inspected                          5            0.0           0.0
prefetch clients - default                        0            0.0           0.0
prefetch warmup blocks aged out                   0            0.0           0.0
prefetched blocks aged out befor                  0            0.0           0.0
process last non-idle time                    3,606            1.0           0.1
queries parallelized                        125,902           35.0           4.0
recursive aborts on index block                   0            0.0           0.0
recursive calls                          12,927,222        3,588.9         412.2
recursive cpu usage                          53,921           15.0           1.7
redo blocks written                          71,745           19.9           2.3
redo buffer allocation retries                    0            0.0           0.0
redo entries                                 47,490           13.2           1.5
redo log space requests                           0            0.0           0.0
redo log space wait time                          0            0.0           0.0
redo ordering marks                             342            0.1           0.0
redo size                                28,128,388        7,809.2         896.8
redo subscn max counts                          967            0.3           0.0
redo synch time                               4,157            1.2           0.1
redo synch writes                             1,798            0.5           0.1
redo wastage                              7,220,740        2,004.7         230.2
redo write time                              47,091           13.1           1.5
redo writer latching time                         0            0.0           0.0
redo writes                                  24,174            6.7           0.8
rollback changes - undo records                   0            0.0           0.0
rollbacks only - consistent read                 11            0.0           0.0
rows fetched via callback                 1,711,981          475.3          54.6
session connect time                              0            0.0           0.0
session cursor cache hits                    34,067            9.5           1.1
session logical reads                    57,763,579       16,036.7       1,841.7
session pga memory                  141,432,943,744   39,265,409.2   4,509,403.9
session pga memory max              142,121,154,336   39,456,474.1   4,531,346.6
session uga memory                  432,255,223,424  120,005,125.9  13,781,890.8
session uga memory max               61,149,185,240   16,976,580.7   1,949,661.6
shared hash latch upgrades - no             617,316          171.4          19.7
shared hash latch upgrades - wai                  0            0.0           0.0
sorts (disk)                                      0            0.0           0.0
sorts (memory)                            7,172,982        1,991.4         228.7
sorts (rows)                             18,665,650        5,182.1         595.1
sql area evicted                              8,819            2.5           0.3
Instance Activity Stats        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
sql area purged                                 656            0.2           0.0
summed dirty queue length                     2,243            0.6           0.1
switch current to new buffer                    296            0.1           0.0
table fetch by rowid                     38,124,094       10,584.2       1,215.5
table fetch continued row                 4,035,371        1,120.3         128.7
table scan blocks gotten                    778,842          216.2          24.8
table scan rows gotten                   44,616,911       12,386.8       1,422.6
table scans (cache partitions)                    0            0.0           0.0
table scans (long tables)                        11            0.0           0.0
table scans (short tables)                    4,854            1.4           0.2
total number of times SMON poste                362            0.1           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                   9,239,584        2,565.2         294.6
user I/O wait time                          117,500           32.6           3.8
user calls                                1,420,866          394.5          45.3
user commits                                 31,307            8.7           1.0
user rollbacks                                   57            0.0           0.0
workarea executions - onepass                     0            0.0           0.0
workarea executions - optimal             7,154,249        1,986.2         228.1
write clones created in backgrou                  0            0.0           0.0
write clones created in foregrou                 27            0.0           0.0
          -------------------------------------------------------------      

Instance Activity Stats - Absolute ValuesDB/Inst: HREMPLOY/hremploy  Snaps: 1
-> Statistics with absolute values (should not be diffed)

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
session cursor cache count             3,122,065       3,179,737
opened cursors current                       230             321
workarea memory allocated                  4,841           3,606
logons current                                41              42
          -------------------------------------------------------------      

Instance Activity Stats - Thread ActivityDB/Inst: HREMPLOY/hremploy  Snaps: 13
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                            2      2.00
          -------------------------------------------------------------      

Tablespace IO Stats            DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
HR_LDATA                     
       150,535      42    1.2     1.4          691        0        727    4.5
PART_IDX                     
       125,646      35    3.6     1.0          371        0          0    0.0
PART_DATA                    
        94,691      26    2.5     1.1          178        0          2   15.0
HR_LINDX                     
        59,220      16    3.0     1.0          354        0          3    3.3
HR_SDATA                     
        23,921       7    3.6     1.9          182        0          0    0.0
SYSTEM                       
         5,975       2    1.9     1.7          277        0          4    7.5
HR_SINDX                     
         5,671       2    2.2     1.1          213        0          3    0.0
SYSAUX                       
         1,302       0    2.4     1.3          517        0          0    0.0
UNDOTBS1                     
           516       0    0.3     1.0          631        0          3    0.0
TEMP                         
           359       0    0.1     1.1          356        0          0    0.0
HISPART_DATA                 
            36       0    2.5     1.0            6        0          0    0.0
HISPART_IDX                  
            33       0    3.0     1.0            6        0          0    0.0
USERS                        
             8       0    2.5     1.0            2        0          0    0.0
          -------------------------------------------------------------      

File IO Stats                  DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
HISPART_DATA             /data/hremploy/hispart_data01.DBF                  
            11       0    2.7     1.0            2        0          0    0.0
HISPART_DATA             /data/hremploy/hispart_data02.DBF                  
            13       0    1.5     1.0            2        0          0    0.0
HISPART_DATA             /data/hremploy/hispart_data03.DBF                  
            12       0    3.3     1.0            2        0          0    0.0
HISPART_IDX              /data/hremploy/hispart_idx01.DBF                   
            11       0    3.6     1.0            2        0          0    0.0
HISPART_IDX              /data/hremploy/hispart_idx02.DBF                   
            10       0    6.0     1.0            2        0          0    0.0
HISPART_IDX              /data/hremploy/hispart_idx03.DBF                   
            12       0    0.0     1.0            2        0          0    0.0
HR_LDATA                 /data/hremploy/HR_LDATA01.DBF                      
        47,708      13    1.2     1.5          169        0          0    0.0
HR_LDATA                 /data/hremploy/HR_LDATA02.DBF                      
        31,663       9    1.0     1.1          133        0        727    4.5
HR_LDATA                 /data/hremploy/HR_LDATA03.DBF                      
        71,164      20    1.3     1.4          389        0          0    0.0
HR_LINDX                 /data/hremploy/HR_LINDX01.DBF                      
         7,327       2    5.4     1.0           66        0          0    0.0
HR_LINDX                 /data/hremploy/HR_LINDX02.DBF                      
         1,829       1    3.6     1.0          219        0          3    3.3
HR_LINDX                 /data/hremploy/HR_LINDX03.DBF                      
        49,349      14    2.6     1.0           21        0          0    0.0
HR_LINDX                 /data/hremploy/HR_LINDX04.DBF                      
           660       0    5.6     1.0           32        0          0    0.0
HR_LINDX                 /data/hremploy/HR_LINDX05.DBF                      
            55       0    4.9     1.0           16        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA01.DBF                      
         2,383       1    5.1     1.5            7        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA02.DBF                      
           652       0    3.9     1.9           43        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA03.DBF                      
         4,322       1    4.5     1.4            4        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA04.DBF                      
         1,250       0    7.0     1.0            2        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA05.DBF                      
         2,998       1    2.3     1.3           11        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA06.DBF                      
         2,030       1    7.5     1.0           20        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA07.DBF                      
         2,474       1    3.1     3.9           30        0          0    0.0
HR_SDATA                 /data/hremploy/HR_SDATA08.DBF                      
         7,812       2    1.6     2.3           65        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX01.DBF                      
            26       0    9.2     1.0            2        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX02.DBF                      
            89       0    5.2     1.0           56        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX03.DBF                      
         1,352       0    2.9     1.4            2        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX04.DBF                      
         3,677       1    1.7     1.0            2        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX05.DBF                      
           169       0    4.1     1.0            2        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX06.DBF                      
           101       0    3.3     1.0            2        0          0    0.0
HR_SINDX                 /data/hremploy/HR_SINDX07.DBF                      
           257       0    3.0     1.0          147        0          3    0.0
PART_DATA                /data/hremploy/part_data01.DBF                     
             8       0    5.0     1.0            2        0          0    0.0
File IO Stats                  DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PART_DATA                /data/hremploy/part_data02.DBF                     
             6       0    6.7     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data03.DBF                     
            31       0    4.5     1.0           18        0          0    0.0
PART_DATA                /data/hremploy/part_data04.DBF                     
        10,345       3    3.5     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data05.DBF                     
            67       0   15.4     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data06.DBF                     
            11       0    3.6     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data07.DBF                     
             9       0    3.3     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data08.DBF                     
            11       0    0.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data09.DBF                     
            10       0    3.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data10.DBF                     
            10       0    1.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data11.DBF                     
            11       0    1.8     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data12.DBF                     
            10       0    3.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data13.DBF                     
            10       0    3.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data14.DBF                     
             9       0    3.3     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data15.DBF                     
            10       0    3.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data16.DBF                     
            10       0    1.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data17.DBF                     
             8       0    5.0     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data18.DBF                     
        25,263       7    2.2     1.5          101        0          2   15.0
PART_DATA                /data/hremploy/part_data19.DBF                     
         9,423       3    3.7     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data20.DBF                     
        26,601       7    2.4     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data21.DBF                     
        14,678       4    2.6     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data22.DBF                     
         8,101       2    0.6     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data23.DBF                     
            12       0    2.5     1.0            2        0          0    0.0
PART_DATA                /data/hremploy/part_data24.DBF                     
            37       0    3.2     1.0           17        0          0    0.0
PART_IDX                 /data/hremploy/part_idx01.DBF                      
        15,922       4    3.4     1.0           20        0          0    0.0
PART_IDX                 /data/hremploy/part_idx02.DBF                      
         5,489       2    2.2     1.0          145        0          0    0.0
PART_IDX                 /data/hremploy/part_idx03.DBF                      
         5,687       2    2.8     1.0           18        0          0    0.0
PART_IDX                 /data/hremploy/part_idx04.DBF                      
         3,556       1    2.9     1.0            5        0          0    0.0
PART_IDX                 /data/hremploy/part_idx05.DBF                      
         3,736       1    3.8     1.0            7        0          0    0.0
PART_IDX                 /data/hremploy/part_idx06.DBF                      
           841       0    5.0     1.0            3        0          0    0.0
PART_IDX                 /data/hremploy/part_idx07.DBF                      
         3,711       1    2.6     1.0            5        0          0    0.0
File IO Stats                  DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PART_IDX                 /data/hremploy/part_idx08.DBF                      
         4,839       1    4.0     1.0            2        0          0    0.0
PART_IDX                 /data/hremploy/part_idx09.DBF                      
        30,358       8    4.0     1.0           10        0          0    0.0
PART_IDX                 /data/hremploy/part_idx10.DBF                      
           570       0    4.6     1.0            3        0          0    0.0
PART_IDX                 /data/hremploy/part_idx11.DBF                      
         3,890       1    4.1     1.0           22        0          0    0.0
PART_IDX                 /data/hremploy/part_idx12.DBF                      
         5,585       2    4.8     1.0           56        0          0    0.0
PART_IDX                 /data/hremploy/part_idx13.DBF                      
         9,016       3    4.3     1.0            9        0          0    0.0
PART_IDX                 /data/hremploy/part_idx14.DBF                      
        10,579       3    4.2     1.0           21        0          0    0.0
PART_IDX                 /data/hremploy/part_idx15.DBF                      
        13,542       4    3.6     1.0           28        0          0    0.0
PART_IDX                 /data/hremploy/part_idx16.DBF                      
         8,325       2    1.9     1.0           17        0          0    0.0
SYSAUX                   /u01/product/oradata/hremploy/sysaux01.dbf         
         1,302       0    2.4     1.3          517        0          0    0.0
SYSTEM                   /u01/product/oradata/hremploy/system01.dbf         
         5,799       2    1.8     1.7          235        0          4    7.5
SYSTEM                   /u01/product/oradata/hremploy/system02.dbf         
           176       0    4.1     1.1           42        0          0    0.0
TEMP                     /u01/product/oradata/hremploy/temp01.dbf           
           138       0    0.1     1.0          137        0          0    N/A
TEMP                     /u01/product/oradata/hremploy/temp02.dbf           
           221       0    0.1     1.1          219        0          0    N/A
UNDOTBS1                 /u01/product/oradata/hremploy/undotbs01.dbf        
           251       0    0.4     1.0          521        0          3    0.0
UNDOTBS1                 /u01/product/oradata/hremploy/undotbs02.dbf        
           265       0    0.1     1.0          110        0          0    0.0
USERS                    /u01/product/oradata/hremploy/users01.dbf          
             8       0    2.5     1.0            2        0          0    0.0
          -------------------------------------------------------------      

Buffer Pool Statistics         DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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       86,605   99     57,728,933      568,542       5,623    0    0        743
          -------------------------------------------------------------      

Instance Recovery Stats         DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> B: Begin snapshot,  E: End snapshot

  Targt  Estd                                  Log File Log Ckpt     Log Ckpt
  MTTR   MTTR   Recovery  Actual    Target       Size    Timeout     Interval
   (s)    (s)   Estd IOs Redo Blks Redo Blks  Redo Blks Redo Blks   Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B     0    12        709      8331     14732    1474560     14732          N/A
E     0    12        879      6731     59223    1474560     59223          N/A
          -------------------------------------------------------------      

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

                                        Est                  
                                       Phys                  
    Size for   Size      Buffers for   Read          Estimated
P    Est (M) Factor         Estimate Factor     Physical Reads
--- -------- ------ ---------------- ------ ------------------
D         64     .1            7,916    1.8      2,551,032,750
D        128     .2           15,832    1.6      2,310,714,823
D        192     .3           23,748    1.5      2,079,606,981
D        256     .4           31,664    1.4      1,899,249,225
D        320     .4           39,580    1.2      1,743,210,770
D        384     .5           47,496    1.1      1,614,199,357
D        448     .6           55,412    1.1      1,551,062,209
D        512     .7           63,328    1.1      1,497,073,047
D        576     .8           71,244    1.0      1,451,191,057
D        640     .9           79,160    1.0      1,427,629,081
D        704    1.0           87,076    1.0      1,408,475,678
D        720    1.0           89,055    1.0      1,404,560,548
D        768    1.1           94,992    1.0      1,392,813,994
D        832    1.2          102,908    1.0      1,381,619,691
D        896    1.2          110,824    1.0      1,370,783,350
D        960    1.3          118,740    1.0      1,360,174,851
D      1,024    1.4          126,656    1.0      1,349,587,094
D      1,088    1.5          134,572    1.0      1,339,046,502
D      1,152    1.6          142,488    0.9      1,328,443,461
D      1,216    1.7          150,404    0.9      1,317,861,221
D      1,280    1.8          158,320    0.9      1,307,319,784
          -------------------------------------------------------------      

PGA Aggr Summary               DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %   W/A MB Processed  Extra W/A MB Read/Written
--------------- ------------------ --------------------------
          100.0             15,095                          0
          -------------------------------------------------------------      

PGA Aggr Target Stats           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> B: Begin snap   E: End snap (rows dentified with B or E contain data
   which is absolute i.e. not diffed over the interval)
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used    - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem    - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem   - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem    - percentage of workarea memory under manual control

                                                %PGA  %Auto   %Man          
    PGA Aggr   Auto PGA   PGA Mem    W/A PGA     W/A    W/A    W/A Global Mem
   Target(M)  Target(M)  Alloc(M)    Used(M)     Mem    Mem    Mem   Bound(K)
- ---------- ---------- ---------- ---------- ------ ------ ------ ----------
B        582        472      165.8        1.2     .7  100.0     .0    102,400
E        582        470      168.8        0.0     .0     .0     .0    102,400
          -------------------------------------------------------------      

PGA Aggr Target Histogram       DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Optimal Executions are purely in-memory operations

  Low     High                                                        
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K      7,151,185      7,151,185            0            0
    64K    128K            705            705            0            0
   128K    256K             29             29            0            0
   256K    512K            750            750            0            0
   512K   1024K            731            731            0            0
     1M      2M             81             81            0            0
     2M      4M             54             54            0            0
     4M      8M              2              2            0            0
     8M     16M              2              2            0            0
          -------------------------------------------------------------      

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

                                       Estd Extra    Estd PGA   Estd PGA
PGA Target    Size           W/A MB   W/A MB Read/      Cache  Overalloc
  Est (MB)   Factr        Processed Written to Disk     Hit %      Count
---------- ------- ---------------- ---------------- -------- ----------
        73     0.1      2,382,216.8        113,088.6     95.0     18,762
       146     0.3      2,382,216.8         14,235.7     99.0        861
       291     0.5      2,382,216.8          5,295.5    100.0          0
       437     0.8      2,382,216.8          4,490.7    100.0          0
       582     1.0      2,382,216.8          3,483.4    100.0          0
       698     1.2      2,382,216.8          2,326.9    100.0          0
       815     1.4      2,382,216.8          2,326.9    100.0          0
       931     1.6      2,382,216.8          2,326.9    100.0          0
     1,048     1.8      2,382,216.8          2,326.9    100.0          0
     1,164     2.0      2,382,216.8          2,326.9    100.0          0
     1,746     3.0      2,382,216.8          2,326.9    100.0          0
     2,328     4.0      2,382,216.8          2,326.9    100.0          0
     3,492     6.0      2,382,216.8          2,326.9    100.0          0
     4,656     8.0      2,382,216.8          2,326.9    100.0          0
          -------------------------------------------------------------      

Shared Pool Advisory                  DB/Inst: HREMPLOY/hremploy  Snap: 13790
-> 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
   Size(M) Factr      (M)      Mem Obj     (s)  Factr     (s)  Factr    Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       288    .4       90        7,176 #######    1.0 #######    2.2 ###########
       368    .5      168       10,240 #######    1.0 #######    2.0 ###########
       448    .6      247       13,664 #######    1.0 #######    1.8 ###########
       528    .7      325       16,851 #######    1.0 #######    1.6 ###########
       608    .8      404       20,005 #######    1.0 #######    1.4 ###########
       688    .9      483       23,208 #######    1.0 #######    1.2 ###########
       768   1.0      562       25,892 #######    1.0  97,925    1.0 ###########
       848   1.1      641       28,993 #######    1.0  80,129     .8 ###########
       928   1.2      720       31,800 #######    1.0  62,689     .6 ###########
     1,008   1.3      799       35,074 #######    1.0  45,892     .5 ###########
     1,088   1.4      878       40,158 #######    1.0  29,423     .3 ###########
     1,168   1.5      957       45,735 #######    1.0  13,243     .1 ###########
     1,248   1.6    1,036       48,830 #######    1.0       1     .0 ###########
     1,328   1.7    1,115       51,566 #######    1.0       1     .0 ###########
     1,408   1.8    1,194       55,285 #######    1.0       1     .0 ###########
     1,488   1.9    1,273       61,224 #######    1.0       1     .0 ###########
     1,568   2.0    1,352       65,539 #######    1.0       1     .0 ###########
          -------------------------------------------------------------      

SGA Target Advisory                    DB/Inst: HREMPLOY/hremploy  Snap: 13790

SGA Target   SGA Size       Est DB     Est Physical
  Size (M)     Factor     Time (s)            Reads
---------- ---------- ------------ ----------------
       768        0.5    4,921,422    1,653,158,049
     1,152        0.8    2,822,111    1,472,532,624
     1,536        1.0    2,032,050    1,404,552,293
     1,920        1.3    1,791,658    1,393,315,875
     2,304        1.5    1,659,169    1,393,315,875
     2,688        1.8    1,592,924    1,393,315,875
     3,072        2.0    1,592,924    1,393,315,875
          -------------------------------------------------------------      

Streams Pool Advisory                  DB/Inst: HREMPLOY/hremploy  Snap: 13790

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

Java Pool Advisory                     DB/Inst: HREMPLOY/hremploy  Snap: 13790

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

Buffer Wait Statistics          DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> ordered by wait time desc, waits desc

Class                    Waits Total Wait Time (s)  Avg Time (ms)
------------------ ----------- ------------------- --------------
data block                 739                   3              5
undo header                  4                   0              0
          -------------------------------------------------------------      

Enqueue Activity               DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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)
------------ ------------ ----------- ----------- ------------ --------------
PS-PX Process Reservation                                                    
   1,007,364    1,007,341          54     104,445            6            .06
CF-Controlfile Transaction                                                   
       4,783        4,783           0          10            1         104.00
JS-Job Scheduler (queue lock)                                                
      13,475       13,475           0           1            0          50.00
          -------------------------------------------------------------      

Undo Segment Summary           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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  
---- ---------- --------------- -------- -------- --------- ----- --------------
   1        1.3          35,249      251        4 15/15.2   0/0   0/0/0/0/0/0  
          -------------------------------------------------------------      

Undo Segment Stats              DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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 
------------ ----------- ------------ ------- ------- ------- ----- ------------
12-1月  04:5          74          826       0       2      15 0/0   0/0/0/0/0/0 
12-1月  04:4         627       20,833       0       3      15 0/0   0/0/0/0/0/0 
12-1月  04:3         201        6,601     251       3      15 0/0   0/0/0/0/0/0 
12-1月  04:2          63          504       0       3      15 0/0   0/0/0/0/0/0 
12-1月  04:1          58        1,122       0       2      15 0/0   0/0/0/0/0/0 
12-1月  04:0         293        5,363     249       4      15 0/0   0/0/0/0/0/0 
          -------------------------------------------------------------      

Latch Activity                 DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch               2,393    0.0    N/A      0            0    N/A
AWR Alerted Metric Eleme         16,074    0.0    N/A      0            0    N/A
Consistent RBA                   24,150    0.0    N/A      0            0    N/A
FAL request queue                    76    0.0    N/A      0            0    N/A
FAL subheap alocation                76    0.0    N/A      0            0    N/A
FIB s.o chain latch                  28    0.0    N/A      0            0    N/A
FOB s.o list latch                3,117    0.0    N/A      0            0    N/A
In memory undo latch            139,032    0.0    1.0      0       34,009    0.0
JS mem alloc latch                  114    0.0    N/A      0            0    N/A
JS queue access latch               114    0.0    N/A      0            0    N/A
JS queue state obj latch         26,950    0.0    N/A      0            0    N/A
JS slv state obj latch              291    0.0    N/A      0            0    N/A
KMG MMAN ready and start          1,201    0.0    N/A      0            0    N/A
KMG resize request state              4    0.0    N/A      0            0    N/A
KTF sga latch                        12    0.0    N/A      0          994    0.0
KWQMN job cache list lat              1    0.0    N/A      0            0    N/A
MQL Tracking Latch                    0    N/A    N/A      0           72    0.0
Memory Management Latch              40    0.0    N/A      0        1,201    0.0
OS process                          657    0.0    N/A      0            0    N/A
OS process allocation             1,640    0.0    N/A      0            0    N/A
OS process: request allo            263    0.0    N/A      0            0    N/A
PL/SQL warning settings         258,313    0.0    N/A      0            0    N/A
SGA IO buffer pool latch             24    0.0    N/A      0           24    0.0
SQL memory manager latch              1    0.0    N/A      0        1,185    0.0
SQL memory manager worka         96,577    0.0    N/A      0            0    N/A
Shared B-Tree                       128    0.0    N/A      0            0    N/A
active checkpoint queue           2,964    0.0    N/A      0            0    N/A
active service list           1,267,933    1.5    0.2      0        1,517    0.1
archive control                      74    0.0    N/A      0            0    N/A
archive process latch             1,341    0.1    1.0      0            0    N/A
begin backup scn array               34    0.0    N/A      0            0    N/A
buffer pool                         278    0.0    N/A      0            0    N/A
cache buffer handles              2,056    0.0    N/A      0            0    N/A
cache buffers chains        100,072,099    0.0    0.0      0    1,069,089    0.0
cache buffers lru chain          25,882    0.0    0.0      0    1,035,562    0.0
cache table scan latch                0    N/A    N/A      0       17,337    0.0
channel handle pool latc            975    0.0    N/A      0            0    N/A
channel operations paren         20,453    0.0    N/A      0            0    N/A
checkpoint queue latch          123,252    0.0    N/A      0        5,648    0.0
client/application info       1,261,652    0.0    N/A      0            0    N/A
compile environment latc        252,053    0.0    N/A      0            0    N/A
dml lock allocation              72,246    0.0    0.0      0            0    N/A
dummy allocation                504,157    0.7    0.0      0            0    N/A
enqueue hash chains           2,996,224    0.2    0.0      0          643    0.2
enqueues                      1,971,195    0.1    0.0      0            0    N/A
error message lists             629,598    0.2    0.0      0            0    N/A
event group latch                   132    0.0    N/A      0            0    N/A
file cache latch                    214    0.0    N/A      0            0    N/A
global KZLD latch for me             88    0.0    N/A      0            0    N/A
global tx hash mapping            5,995    0.0    N/A      0            0    N/A
hash table column usage             941    0.0    N/A      0      273,887    0.0
hash table modification             104    0.0    N/A      0            0    N/A
instance information                378    0.0    N/A      0            0    N/A
internal temp table obje            804    0.0    N/A      0            0    N/A
job workq parent latch                0    N/A    N/A      0          195    0.0
job_queue_processes para            139    0.0    N/A      0            0    N/A
kks stats                        47,087    0.0    N/A      0            0    N/A
kokc descriptor allocati             58    0.0    N/A      0            0    N/A
ksuosstats global area              242    0.0    N/A      0            0    N/A
ktm global data                     371    0.0    N/A      0            0    N/A
Latch Activity                 DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
kwqbsn:qsga                         128    0.0    N/A      0            0    N/A
lgwr LWN SCN                     24,404    0.0    0.0      0            0    N/A
library cache                 3,389,969    2.2    0.0      0       39,091    0.0
library cache load lock           1,970    0.0    N/A      0            0    N/A
library cache lock            2,157,880    0.5    0.0      0            0    N/A
library cache lock alloc          6,546    0.0    N/A      0            0    N/A
library cache pin               648,480    0.8    0.0      0            0    N/A
library cache pin alloca          3,609    0.0    N/A      0            0    N/A
list of block allocation            319    0.0    N/A      0            0    N/A
loader state object free            916    0.0    N/A      0            0    N/A
longop free list parent              88    0.0    N/A      0            0    N/A
message pool operations             712    0.0    N/A      0            0    N/A
messages                         93,617    0.0    N/A      0            0    N/A
mostly latch-free SCN            24,462    0.1    0.0      0            0    N/A
multiblock read objects          66,720    0.0    N/A      0            0    N/A
ncodef allocation latch              72    0.0    N/A      0            0    N/A
object queue header heap         16,821    0.0    N/A      0        4,970    0.0
object queue header oper      1,178,650    0.0    N/A      0            0    N/A
object stats modificatio            713    0.0    N/A      0            0    N/A
parallel query alloc buf      2,519,484    0.1    0.0      0            0    N/A
parallel query stats            629,554    4.8    0.0      0            0    N/A
parameter list                    1,128    0.0    N/A      0            0    N/A
parameter table allocati        503,821    1.0    0.0      0            0    N/A
policy information                3,969    0.0    N/A      0            0    N/A
post/wait queue                   3,151    0.0    N/A      0        1,816    0.0
process allocation              126,165    0.0    N/A      0          132    0.0
process group creation              263    0.0    N/A      0            0    N/A
process queue                 1,763,268    0.3    0.0      0            0    N/A
process queue reference      53,557,991    0.1    0.0      0    5,251,881    0.3
qmn task queue latch                512    0.0    N/A      0            0    N/A
query server freelists        1,385,474    0.5    0.0      0            0    N/A
query server process                 12    0.0    N/A      0           12    0.0
redo allocation                 141,337    0.0    0.0      0       47,379    0.0
redo copy                             0    N/A    N/A      0       47,380    0.0
redo writing                     77,899    0.0    N/A      0            0    N/A
resmgr group change latc        252,356    0.0    N/A      0            0    N/A
resmgr:active threads           504,154    0.0    N/A      0            0    N/A
resmgr:actses change gro        252,037    0.0    N/A      0            0    N/A
resmgr:free threads list        504,153    2.2    0.0      0            0    N/A
resmgr:schema config                  1    0.0    N/A      0            0    N/A
row cache objects             2,525,743    0.0    0.0      0        4,233    0.0
sequence cache                      922    0.0    N/A      0            0    N/A
session allocation            4,378,629    3.0    0.1      0            0    N/A
session idle bit              2,946,139    0.0    0.0      0            0    N/A
session state list latch        504,854    1.8    0.0      0            0    N/A
session switching                    72    0.0    N/A      0            0    N/A
session timer                     1,518    0.0    N/A      0            0    N/A
shared pool                   5,813,135    5.0    0.0      0            0    N/A
shared pool simulator         5,328,129    0.0    0.0      0            0    N/A
simulator hash latch          2,908,218    0.0    0.0      0            0    N/A
simulator lru latch               5,697    0.0    0.0      0    2,860,586    0.0
slave class                           2    0.0    N/A      0            0    N/A
slave class create                    8   12.5    1.0      0            0    N/A
sort extent pool                  2,587    0.0    N/A      0            0    N/A
state object free list                2    0.0    N/A      0            0    N/A
statistics aggregation              560    0.0    N/A      0            0    N/A
temporary table state ob             45    0.0    N/A      0            0    N/A
threshold alerts latch              239    0.0    N/A      0            0    N/A
transaction allocation          179,572    0.0    N/A      0            0    N/A
transaction branch alloc          4,843    0.0    N/A      0            0    N/A
Latch Activity                 DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
undo global data                171,734    0.0    N/A      0            0    N/A
user lock                           568    0.0    N/A      0            0    N/A
          -------------------------------------------------------------      

Latch Sleep Breakdown          DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> ordered by misses desc

Latch Name                             
----------------------------------------
  Get Requests      Misses      Sleeps  Spin Gets   Sleep1   Sleep2   Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
shared pool                            
     5,813,135     290,891         193    290,745        0        0        0
session allocation                     
     4,378,629     131,683      10,245    122,924        0        0        0
library cache                          
     3,389,969      75,447          18     75,430        0        0        0
process queue reference                
    53,557,991      46,759         187     46,572        0        0        0
parallel query stats                   
       629,554      30,266           5     30,261        0        0        0
active service list                    
     1,267,933      18,750       2,881     15,869        0        0        0
resmgr:free threads list               
       504,153      10,887           1     10,886        0        0        0
library cache lock                     
     2,157,880      10,420           1     10,419        0        0        0
process queue                          
     1,763,268       6,068          22      6,046        0        0        0
enqueue hash chains                    
     2,996,224       4,994           4      4,990        0        0        0
parameter table allocation management  
       503,821       4,882          16      4,866        0        0        0
cache buffers chains                   
   100,072,099       4,408           8      4,400        0        0        0
dummy allocation                       
       504,157       3,555           1      3,554        0        0        0
enqueues                               
     1,971,195       2,341           9      2,332        0        0        0
parallel query alloc buffer            
     2,519,484       1,612          28      1,598        0        0        0
error message lists                    
       629,598       1,409          26      1,396        0        0        0
session idle bit                       
     2,946,139         651           4        647        0        0        0
shared pool simulator                  
     5,328,129          65           1         64        0        0        0
In memory undo latch                   
       139,032           2           2          0        0        0        0
archive process latch                  
         1,341           2           2          0        0        0        0
slave class create                     
             8           1           1          0        0        0        0
          -------------------------------------------------------------      

Latch Miss Sources             DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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          1        1
In memory undo latch     ktichg: child                    0          1        0
active service list      ksws_event: ksws event           0      4,074    4,042
active service list      kswsgsnp: get service name       0          6       38
active service list      kswssyis: find service ent       0          2        0
archive process latch    kcrrsarc                         0          2        0
cache buffers chains     kcbgtcr: kslbegin excl           0         50       37
cache buffers chains     kcbrls: kslbegin                 0          5       17
cache buffers chains     kcbgtcr: fast path               0          3        4
cache buffers chains     kcbzgb: scan from tail. no       0          1        0
dummy allocation         ktcscnfy                         0          1        1
enqueue hash chains      ksqrcl                           0          3        1
enqueue hash chains      ksqgtl3                          0          1        2
enqueues                 ksqdel                           0          4        8
enqueues                 ksqies                           0          4        1
enqueues                 ksqgel: create enqueue           0          1        0
error message lists      kxfpqsnd                         0         26        0
library cache            kglScanDependency                0          3        0
library cache            kglLockCursor                    0          2        1
library cache            kglic                            0          2        0
library cache            kglobpn: child:                  0          1        1
library cache            kglpndl: child: after proc       0          1        0
library cache            kglpndl: child: before pro       0          1        2
library cache lock       kgllkdl: child: cleanup          0          1        1
library cache lock       kgllkdl: child: no lock ha       0          1        2
parallel query alloc buf kxfpbfre                         0         16       28
parallel query alloc buf kxfpbalo                         0         12        0
parallel query stats     kxfprst: KSLBEGIN:1              0          5        5
parameter table allocati ksp_param_table_free             0         16       16
process queue            kxfpqidqr: KSLBEGIN              0         13        3
process queue            kxfpqsnd: KSLBEGIN               0          9       19
process queue reference  kxfpqrsnd                        0        187        0
resmgr:free threads list kgskthrsod                       0          1        1
session allocation       ksuxds: KSUSFCLC not set         0      9,748    1,815
session allocation       kxfprdp                          0        240        1
session allocation       ksursi                           0         86    5,615
session allocation       ksucri                           0         65      362
session allocation       kxfpqidqr                        0         59    2,224
session allocation       ksuprc                           0         22      109
session allocation       ksudlc                           0         15       53
session allocation       ksuxds: not user session         0          7       58
session allocation       ksusin                           0          3        8
session idle bit         ksupuc: clear busy               0          4        1
shared pool              kghalo                           0        112       90
shared pool              kgh_next_free                    0         35        0
shared pool              kghfre                           0         24       77
shared pool              kghfrunp: alloc: wait            0         11        0
shared pool              kghfrunp: clatch: nowait         0          6        0
shared pool              kghupr1                          0          5       20
shared pool              kgh: add extent to quiesce       0          4        0
shared pool              kgh: quiesce extents             0          2        0
shared pool              kghfrunp: clatch: wait           0          1        0
shared pool simulator    kglsim_unpin_simhp               0          1        0
slave class create       ksvcreate                        0          1        0
          -------------------------------------------------------------      

Parent Latch Statistics        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Child Latch Statistics          DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Segments by Logical Reads      DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Logical Reads:      57,763,579
-> Captured Segments account for   89.3% of Total

           Tablespace                      Subobject  Obj.       Logical       
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
HR         PART_DATA  KQM_KAOQINDATA       AOQIN_2012 TABLE    8,727,776   15.11
HR         HR_SINDX   IX_DEPARTMENT_DEPCOD            INDEX    7,685,536   13.31
HR         HR_SDATA   BFW_DEPARTMENT                  TABLE    4,399,648    7.62
HR         HR_LDATA   KQM_EMPLOYEESHIFT               TABLE    4,168,160    7.22
HR         HR_SINDX   PK_KQM_BUCALENDAR               INDEX    3,546,992    6.14
          -------------------------------------------------------------      

Segments by Physical Reads      DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> Total Physical Reads:         568,955
-> Captured Segments account for    71.7% of Total

           Tablespace                      Subobject  Obj.      Physical       
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
HR         HR_LDATA   KQM_LEAVEAPPLY                  TABLE      102,785   18.07
HR         PART_DATA  ETM_CHOURDETAIL      ETM_2011   TABLE       58,046   10.20
HR         PART_IDX   KQM_KAOQINDATA_PK               INDEX       37,967    6.67
HR         HR_LDATA   HRM_EMPLOYEES                   TABLE       29,393    5.17
HR         HR_LDATA   KQM_EMPLOYEESHIFT               TABLE       27,142    4.77
          -------------------------------------------------------------      

Segments by Row Lock Waits     DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Segments by ITL Waits           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Segments by Buffer Busy Waits   DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

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

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control                      65    0.0       0   N/A        2          1
dc_database_links                2,338    0.0       0   N/A        0          5
dc_files                         9,000    0.0       0   N/A        0         75
dc_global_oids                   1,128    1.8       0   N/A        0         23
dc_histogram_data              167,769    0.8       0   N/A        0      3,631
dc_histogram_defs              202,593    8.4       0   N/A   14,833     23,177
dc_object_ids                  348,119    0.2       0   N/A      268      1,080
dc_objects                      29,199    2.7       0   N/A      578      1,090
dc_profiles                        228    0.0       0   N/A        0          1
dc_rollback_segments             4,784    0.0       0   N/A        0        141
dc_segments                     81,830    0.9       0   N/A        3      1,076
dc_sequences                        26    3.8       0   N/A       26          3
dc_tablespaces                  25,873    0.0       0   N/A        0         14
dc_usernames                     3,251    0.0       0   N/A        0         44
dc_users                        62,035    0.0       0   N/A        0         82
outstanding_alerts                  84    0.0       0   N/A        0         13
          -------------------------------------------------------------      

Library Cache Activity          DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> "Pct Misses"  should be very low 

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                     616    0.0          4,009    0.2          7        0
CLUSTER                   20    0.0             42    2.4          1        0
INDEX                  2,112    0.2          6,029    0.4         20        0
SQL AREA             289,639    4.3      6,412,343    0.4      1,643       28
TABLE/PROCEDURE        8,484    3.5        315,770    0.5        573        0
TRIGGER                1,908    0.1          2,288    0.0          0        0
          -------------------------------------------------------------      

Process Memory Summary         DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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        103.4       N/A      2.4      5.4      22      33     43     43
  Freeable      58.6        .0      2.4      6.0      30     N/A     24     24
  SQL            2.8       2.0       .1       .2       1       8     30     25
  PL/SQL         1.0        .6       .0       .0       0       0     41     41
E Other        107.1       N/A      2.4      5.4      22      33     44     44
  Freeable      58.7        .0      2.4      6.0      30     N/A     24     24
  SQL            2.0        .9       .1       .0       0       4     31     29
  PL/SQL         1.0        .6       .0       .0       0       0     42     42
          -------------------------------------------------------------      

SGA Memory Summary              DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

                                                      End Size (Bytes)
SGA regions                     Begin Size (Bytes)      (if different)
------------------------------ ------------------- -------------------
Database Buffers                       687,865,856         754,974,720
Fixed Size                               2,084,296                   
Redo Buffers                            14,692,352                   
Variable Size                          905,970,232         838,861,368
                               -------------------                             
sum                                  1,610,612,736                             
          -------------------------------------------------------------      

SGA breakdown difference        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790
-> 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                               1.0            1.0    0.00
large  free memory                              15.0           15.0    0.00
shared ASH buffers                              15.5           15.5    0.00
shared CCursor                                  43.2           38.3  -11.45
shared KGH: NO ACCESS                          637.6          701.3    9.98
shared PCursor                                  29.5           26.1  -11.72
shared free memory                             328.9          332.9    1.21
shared kglsim heap                              21.6           21.6    0.00
shared kglsim object batch                      35.8           35.8    0.00
shared library cache                            29.9           29.3   -2.02
shared sql area                                225.6          167.6  -25.73
       buffer_cache                            656.0          720.0    9.76
       fixed_sga                                 2.0            2.0    0.00
       log_buffer                               14.0           14.0    0.00
          -------------------------------------------------------------      

Streams CPU/IO Usage           DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Streams Capture                 DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Streams Apply                   DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Buffered Queues                 DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Buffered Subscribers            DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Rule Set                        DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

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

Resource Limit Stats                  DB/Inst: HREMPLOY/hremploy  Snap: 13790

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

init.ora Parameters            DB/Inst: HREMPLOY/hremploy  Snaps: 13789-13790

                                                                End value    
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
archive_lag_target            1800                                           
audit_file_dest               /u01/product/admin/hremploy/adump              
background_dump_dest          /u01/product/admin/hremploy/bdump              
compatible                    10.2.0.3.0                                     
control_files                 /u01/product/oradata/hremploy/con              
core_dump_dest                /u01/product/admin/hremploy/cdump              
db_block_size                 8192                                           
db_domain                                                                    
db_file_multiblock_read_count 16                                             
db_name                       hremploy                                       
db_recovery_file_dest         /u01/product/flash_recovery_area               
db_recovery_file_dest_size    2147483648                                     
dispatchers                   (PROTOCOL=TCP) (SERVICE=hremployX              
job_queue_processes           30                                             
log_archive_dest_1            LOCATION=/data/hremploy/arch                   
log_archive_format            %t_%s_%r.arc                                   
open_cursors                  300                                            
optimizer_index_cost_adj      50                                             
pga_aggregate_target          610271232                                      
processes                     300                                            
remote_login_passwordfile     EXCLUSIVE                                      
sga_target                    1610612736                                     
undo_management               AUTO                                           
undo_retention                900                                            
undo_tablespace               UNDOTBS1                                       
user_dump_dest                /u01/product/admin/hremploy/udump              
          -------------------------------------------------------------      

End of Report

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

下一篇: 深入了解SCN
请登录后发表评论 登录
全部评论

注册时间:2011-05-20

  • 博文量
    77
  • 访问量
    92533