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