WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
SZORCL2436002808szorcl110.2.0.1.0NOJAVAAPP

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:171929-3ÔÂ -13 09:01:0696 .6
End Snap:172029-3ÔÂ -13 10:00:4295 1.1
Elapsed:  59.60 (mins)  
DB Time:  0.15 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,336M 1,344MStd Block Size: 8K
Shared Pool Size: 128M 120MLog Buffer: 6,968K

Load Profile

Per SecondPer Transaction
Redo size: 390.83 24,518.95
Logical reads: 78.64 4,933.74
Block changes: 1.50 94.28
Physical reads: 3.91 245.30
Physical writes: 0.17 10.60
User calls: 7.67 481.19
Parses: 3.34 209.49
Hard parses: 0.26 16.47
Sorts: 0.98 61.39
Logons: 0.06 3.70
Executes: 5.51 345.54
Transactions: 0.02 

% Blocks changed per Read: 1.91Recursive Call %: 79.72
Rollback per transaction %: 21.05Rows per Sort: 10.08

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 95.04In-memory Sort %: 100.00
Library Hit %: 92.70Soft Parse %: 92.14
Execute to Parse %: 39.37Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 89.43% Non-Parse CPU: 69.11

Shared Pool Statistics

BeginEnd
Memory Usage %: 89.21 91.70
% SQL with executions>1: 35.90 78.65
% Memory for SQL w/exec>1: 58.97 89.25

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
SQL*Net more data from client 207 11 52 116.3Network
CPU time  7  77.4 
Streams AQ: enqueue blocked on low memory 1 3 2,772 30.1Configuration
db file sequential read 630 1 2 10.9User I/O
db file scattered read 914 1 1 10.2User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 7.12 77.36
sql execute elapsed time 6.48 70.40
parse time elapsed 2.37 25.79
hard parse elapsed time 1.53 16.59
connection management call elapsed time 0.72 7.78
PL/SQL execution elapsed time 0.10 1.13
PL/SQL compilation elapsed time 0.09 0.96
hard parse (sharing criteria) elapsed time 0.03 0.36
sequence load elapsed time 0.01 0.08
repeated bind elapsed time 0.00 0.04
hard parse (bind mismatch) elapsed time 0.00 0.02
DB time 9.21  
background elapsed time 8.63  
background cpu time 5.26  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Network 20,764 0.00 11 1 364.28
Configuration 1 0.00 3 2772 0.02
User I/O 1,626 0.00 2 1 28.53
System I/O 2,601 0.00 1 0 45.63
Concurrency 9 0.00 0 9 0.16
Other 3 33.33 0 21 0.05
Commit 55 0.00 0 0 0.96

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
SQL*Net more data from client 207 0.00 11 52 3.63
Streams AQ: enqueue blocked on low memory 1 0.00 3 2772 0.02
db file sequential read 630 0.00 1 2 11.05
db file scattered read 914 0.00 1 1 16.04
control file parallel write 1,192 0.00 0 0 20.91
control file sequential read 873 0.00 0 0 15.32
log file parallel write 497 0.00 0 0 8.72
library cache pin 5 0.00 0 12 0.09
kksfbc child completion 1 100.00 0 57 0.02
SQL*Net message to client 20,473 0.00 0 0 359.18
read by other session 19 0.00 0 2 0.33
os thread startup 4 0.00 0 6 0.07
log file sync 55 0.00 0 0 0.96
db file parallel write 39 0.00 0 0 0.68
latch free 1 0.00 0 5 0.02
SQL*Net more data to client 84 0.00 0 0 1.47
SGA: allocation forcing component growth 1 0.00 0 2 0.02
direct path write 63 0.00 0 0 1.11
SQL*Net message from client 20,473 0.00 235,132 11485 359.18
Streams AQ: qmn slave idle wait 254 0.00 3,557 14002 4.46
Streams AQ: qmn coordinator idle wait 369 34.69 3,557 9638 6.47
virtual circuit status 119 100.00 3,552 29850 2.09
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,219 2219046 0.02
jobq slave wait 56 100.00 168 3000 0.98
class slave wait 2 100.00 10 4994 0.04

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Streams AQ: enqueue blocked on low memory 1 0.00 3 2772 0.02
control file parallel write 1,192 0.00 0 0 20.91
control file sequential read 156 0.00 0 1 2.74
log file parallel write 497 0.00 0 0 8.72
os thread startup 4 0.00 0 6 0.07
db file parallel write 39 0.00 0 0 0.68
events in waitclass Other 1 0.00 0 2 0.02
rdbms ipc message 11,922 96.01 32,113 2694 209.16
pmon timer 1,223 100.00 3,573 2922 21.46
Streams AQ: qmn slave idle wait 254 0.00 3,557 14002 4.46
Streams AQ: qmn coordinator idle wait 369 34.69 3,557 9638 6.47
smon timer 11 100.00 3,081 280073 0.19
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,219 2219046 0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 1,022
AVG_IDLE_TIME 356,476
AVG_SYS_TIME 261
AVG_USER_TIME 726
BUSY_TIME 4,250
IDLE_TIME 1,426,070
SYS_TIME 1,211
USER_TIME 3,039
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 90,112
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 4,294,606,848
NUM_CPUS 4
NUM_CPU_CORES 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 9.20 7.10 13,913 251,746
SYS$BACKGROUND 0.00 0.00 72 30,186
szorcl 0.00 0.00 0 0
szorclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 1486 180 5 6 0 0 19944 1074
SYS$BACKGROUND 140 17 4 3 0 0 0 0
szorcl 0 0 0 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
1 1 1 1.24 13.48 bunssq950snhf   insert into wrh$_sga_target_ad...
1 0 1 1.15 12.52 ac4r8t6csxh45   SELECT DISTINCT RECEIVE_GOODS_...
0 0 397 0.00 4.22 crjpjxn045bmf JDBC Thin Client select v_hrvuser0_.EMP_ID as E...
0 0 31 0.01 2.48 2362zkbzvtg5f   select employee.EMPLOYEE_I...
0 0 2 0.11 2.31 gj3zt1nnm53r5   SELECT DISTINCT QA_BIZ_DEAL_DE...
0 0 54 0.00 2.29 3arf6d7urs67z JDBC Thin Client select GET_PERONAL_VACATION_IN...
0 0 54 0.00 1.78 fvcdp6sf72ah0 JDBC Thin Client select GET_PERONAL_VACATION_IN...
0 0 252 0.00 1.63 65nmjgupyssar JDBC Thin Client SELECT HUV.* FROM HRV_USER_V H...
0 0 5 0.03 1.62 cbu8ww54m5d4w JDBC Thin Client select max(hrvapplyhe0_.APPLY_...
0 0 27 0.01 1.53 51b7c9xsgh5wv   SELECT G.PRODUCT_NAME, P.MODU...
0 0 253 0.00 1.52 5b6f2j1k0qjwr JDBC Thin Client SELECT NVL(SUM(DECODE(HAL.STAT...
0 0 1 0.13 1.45 55cacd6du30aw   SELECT FN_BAL_LWF_CONFIRM_DOC_...
0 0 690 0.00 1.45 9kthv2gyukhzz   select g.product_name, m.discr...
0 0 3 0.04 1.38 gkm3ju73qrdn7   select * from usr_ccss.Fbp_Acc...
0 0 192 0.00 1.28 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0 0 10 0.01 1.21 121fjv1ar6d9j JDBC Thin Client select this_.APPLY_ID as APPLY...
0 0 3 0.04 1.18 fraz8rxzhtw2p   select * from usr_ccss.Fbp_Acc...
0 0 717 0.00 1.18 3c1kubcdjnppq   update sys.col_usage$ set eq...
0 0 2 0.05 1.12 8nx3v9uc7g7pp   SELECT CUSTOMER_ACL_INFO.ACL_I...
0 0 716 0.00 1.06 803b7z0t84sq7   select job, nvl2(last_date, ...
0 0 1 0.10 1.04 6b0rzczyyku92 JDBC Thin Client select get_leave_employee_vaca...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1 1 1 1.24 13.48 bunssq950snhf   insert into wrh$_sga_target_ad...
0 0 397 0.00 4.22 crjpjxn045bmf JDBC Thin Client select v_hrvuser0_.EMP_ID as E...
0 1 1 0.22 12.52 ac4r8t6csxh45   SELECT DISTINCT RECEIVE_GOODS_...
0 0 31 0.01 2.48 2362zkbzvtg5f   select employee.EMPLOYEE_I...
0 0 54 0.00 2.29 3arf6d7urs67z JDBC Thin Client select GET_PERONAL_VACATION_IN...
0 0 54 0.00 1.78 fvcdp6sf72ah0 JDBC Thin Client select GET_PERONAL_VACATION_IN...
0 0 2 0.08 2.31 gj3zt1nnm53r5   SELECT DISTINCT QA_BIZ_DEAL_DE...
0 0 252 0.00 1.63 65nmjgupyssar JDBC Thin Client SELECT HUV.* FROM HRV_USER_V H...
0 0 27 0.01 1.53 51b7c9xsgh5wv   SELECT G.PRODUCT_NAME, P.MODU...
0 0 5 0.03 1.62 cbu8ww54m5d4w JDBC Thin Client select max(hrvapplyhe0_.APPLY_...
0 0 690 0.00 1.45 9kthv2gyukhzz   select g.product_name, m.discr...
0 0 192 0.00 1.28 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0 0 3 0.04 1.38 gkm3ju73qrdn7   select * from usr_ccss.Fbp_Acc...
0 0 717 0.00 1.18 3c1kubcdjnppq   update sys.col_usage$ set eq...
0 0 3 0.03 1.18 fraz8rxzhtw2p   select * from usr_ccss.Fbp_Acc...
0 0 716 0.00 1.06 803b7z0t84sq7   select job, nvl2(last_date, ...
0 0 10 0.01 1.21 121fjv1ar6d9j JDBC Thin Client select this_.APPLY_ID as APPLY...
0 0 253 0.00 1.52 5b6f2j1k0qjwr JDBC Thin Client SELECT NVL(SUM(DECODE(HAL.STAT...
0 0 1 0.05 1.04 6b0rzczyyku92 JDBC Thin Client select get_leave_employee_vaca...
0 0 2 0.02 1.12 8nx3v9uc7g7pp   SELECT CUSTOMER_ACL_INFO.ACL_I...
0 0 1 0.01 1.45 55cacd6du30aw   SELECT FN_BAL_LWF_CONFIRM_DOC_...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
24,227 2 12,113.50 8.61 0.16 0.21 gj3zt1nnm53r5   SELECT DISTINCT QA_BIZ_DEAL_DE...
21,222 31 684.58 7.55 0.22 0.23 2362zkbzvtg5f   select employee.EMPLOYEE_I...
13,899 397 35.01 4.94 0.39 0.39 crjpjxn045bmf JDBC Thin Client select v_hrvuser0_.EMP_ID as E...
13,824 54 256.00 4.92 0.21 0.21 3arf6d7urs67z JDBC Thin Client select GET_PERONAL_VACATION_IN...
13,201 3 4,400.33 4.69 0.11 0.13 gkm3ju73qrdn7   select * from usr_ccss.Fbp_Acc...
13,048 3 4,349.33 4.64 0.10 0.11 fraz8rxzhtw2p   select * from usr_ccss.Fbp_Acc...
12,960 54 240.00 4.61 0.16 0.16 fvcdp6sf72ah0 JDBC Thin Client select GET_PERONAL_VACATION_IN...
12,447 1 12,447.00 4.43 0.22 1.15 ac4r8t6csxh45   SELECT DISTINCT RECEIVE_GOODS_...
11,853 27 439.00 4.21 0.14 0.14 51b7c9xsgh5wv   SELECT G.PRODUCT_NAME, P.MODU...
11,103 253 43.89 3.95 0.06 0.07 dsz9u3s5h6jur JDBC Thin Client SELECT NVL(SUM(ADL.AMOUNT), 0...
8,225 252 32.64 2.92 0.15 0.15 65nmjgupyssar JDBC Thin Client SELECT HUV.* FROM HRV_USER_V H...
8,198 10 819.80 2.92 0.08 0.11 121fjv1ar6d9j JDBC Thin Client select this_.APPLY_ID as APPLY...
6,954 690 10.08 2.47 0.13 0.13 9kthv2gyukhzz   select g.product_name, m.discr...
6,408 12 534.00 2.28 0.07 0.07 0g9k3w6x3czz8   SELECT dept.DEPT_ID, dept.DEPT...
4,075 5 815.00 1.45 0.14 0.15 cbu8ww54m5d4w JDBC Thin Client select max(hrvapplyhe0_.APPLY_...
3,717 413 9.00 1.32 0.07 0.07 anuhfdu5b01sb   SELECT ECC_FND_LOOKUP_CODE_PRO...
3,326 253 13.15 1.18 0.05 0.14 5b6f2j1k0qjwr JDBC Thin Client SELECT NVL(SUM(DECODE(HAL.STAT...
3,300 330 10.00 1.17 0.06 0.06 4zvajcp2px4km   select g.product_name, m.discr...
3,050 664 4.59 1.08 0.04 0.05 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
10,920 1 10,920.00 78.10 0.22 1.15 ac4r8t6csxh45   SELECT DISTINCT RECEIVE_GOODS_...
1,062 1 1,062.00 7.60 0.01 0.13 55cacd6du30aw   SELECT FN_BAL_LWF_CONFIRM_DOC_...
669 2 334.50 4.78 0.16 0.21 gj3zt1nnm53r5   SELECT DISTINCT QA_BIZ_DEAL_DE...
622 1 622.00 4.45 0.02 0.08 5k0nmhc11a103   SELECT FN_BAL_AWPB_DETAIL.DETA...
206 2 103.00 1.47 0.02 0.07 2p5uq9gs0dnrc   SELECT FN_BAL_LWF_CONFIRM_DOC....
61 253 0.24 0.44 0.05 0.14 5b6f2j1k0qjwr JDBC Thin Client SELECT NVL(SUM(DECODE(HAL.STAT...
47 3 15.67 0.34 0.01 0.07 dun2f36s6j3vz JDBC Thin Client select GET_PERONAL_VACATION_IN...
40 2 20.00 0.29 0.03 0.10 8nx3v9uc7g7pp   SELECT CUSTOMER_ACL_INFO.ACL_I...
28 1 28.00 0.20 0.05 0.10 6b0rzczyyku92 JDBC Thin Client select get_leave_employee_vaca...
5 3 1.67 0.04 0.04 0.08 53vfj6d97j68v JDBC Thin Client BEGIN init_personal_vaction_in...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
717 698 0.97 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set eq...
716 0 0.00 0.00 0.00 803b7z0t84sq7   select job, nvl2(last_date, ...
716 716 1.00 0.00 0.00 g2wr3u7s1gtf3   select count(*) from sys.job$ ...
690 690 1.00 0.00 0.00 9kthv2gyukhzz   select g.product_name, m.discr...
664 861 1.30 0.00 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
551 551 1.00 0.00 0.00 7ht0rhn5z6h85   SELECT ECC_FND_LOOKUP_CODE_PRO...
550 550 1.00 0.00 0.00 5m79nfnfm5ba6   SELECT ECC_FND_LOOKUP_CODE_PRO...
476 92 0.19 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
440 693 1.58 0.00 0.00 430c8b2d31ww7 JDBC Thin Client select hrvroleuse0_.EMP_ID as ...
413 413 1.00 0.00 0.00 anuhfdu5b01sb   SELECT ECC_FND_LOOKUP_CODE_PRO...
397 397 1.00 0.00 0.00 crjpjxn045bmf JDBC Thin Client select v_hrvuser0_.EMP_ID as E...
360 360 1.00 0.00 0.00 b25tauyfuh1wf   select qa_biz_dea0_.INFO_ID as...
330 330 1.00 0.00 0.00 4zvajcp2px4km   select g.product_name, m.discr...
308 308 1.00 0.00 0.00 76x7b5ghg4zds JDBC Thin Client select hrvrole0_.ROLE_ID as RO...
296 0 0.00 0.00 0.00 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
260 524 2.02 0.00 0.00 6769wyy3yf66f   select pos#, intcol#, col#, sp...
253 253 1.00 0.00 0.00 5b6f2j1k0qjwr JDBC Thin Client SELECT NVL(SUM(DECODE(HAL.STAT...
253 253 1.00 0.00 0.00 dsz9u3s5h6jur JDBC Thin Client SELECT NVL(SUM(ADL.AMOUNT), 0...
252 252 1.00 0.00 0.00 65nmjgupyssar JDBC Thin Client SELECT HUV.* FROM HRV_USER_V H...
240 198 0.83 0.00 0.00 179ygzzrtb9hk JDBC Thin Client select hrvmenus0_.PARENTMENU a...
209 476 2.28 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
209 3,076 14.72 0.00 0.00 83taa7kaw59c1   select name, intcol#, segcol#,...
205 205 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
205 205 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
205 205 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
690 690 5.78 9kthv2gyukhzz   select g.product_name, m.discr...
551 551 4.61 7ht0rhn5z6h85   SELECT ECC_FND_LOOKUP_CODE_PRO...
550 550 4.61 5m79nfnfm5ba6   SELECT ECC_FND_LOOKUP_CODE_PRO...
476 476 3.99 0h6b2sajwb74n   select privilege#, level from ...
440 440 3.68 430c8b2d31ww7 JDBC Thin Client select hrvroleuse0_.EMP_ID as ...
413 413 3.46 anuhfdu5b01sb   SELECT ECC_FND_LOOKUP_CODE_PRO...
397 397 3.32 crjpjxn045bmf JDBC Thin Client select v_hrvuser0_.EMP_ID as E...
360 360 3.01 b25tauyfuh1wf   select qa_biz_dea0_.INFO_ID as...
330 330 2.76 4zvajcp2px4km   select g.product_name, m.discr...
308 308 2.58 76x7b5ghg4zds JDBC Thin Client select hrvrole0_.ROLE_ID as RO...
296 717 2.48 3c1kubcdjnppq   update sys.col_usage$ set eq...
296 19 2.48 53btfq0dt9bs9   insert into sys.col_usage$ val...
296 296 2.48 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
240 240 2.01 179ygzzrtb9hk JDBC Thin Client select hrvmenus0_.PARENTMENU a...
209 209 1.75 0k8522rmdzg4k   select privilege# from sysauth...
205 205 1.72 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
205 205 1.72 459f3z9u4fb3u   select value$ from props$ wher...
205 205 1.72 5ur69atw3vfhj   select decode(failover_method,...
188 188 1.57 4cm0pmh1nhg3k JDBC Thin Client select hrvdeptass0_.DEPTBASE_I...
188 188 1.57 8rnmj20bxfyd0 JDBC Thin Client select hrvbuhrs0_.DEPTBASE_ID ...
184 184 1.54 7h8y26yv85q2f JDBC Thin Client select v_hrvcostc0_.DEPTBASE_I...
180 180 1.51 5706xqmnwpmmj   select qa_biz_dea0_.DETAIL_ID ...
176 176 1.47 9dqs2j1kdughb JDBC Thin Client select hrvresourc0_.RESOURCE_T...
176 176 1.47 f5zvvqj84ax8n JDBC Thin Client select hrvresourc0_.RESOURCE_T...
122 122 1.02 grwydz59pu6mc   select text from view$ where r...
121 121 1.01 7krdqbw2jp68m   SELECT * FROM ( SELECT result...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0g9k3w6x3czz8SELECT dept.DEPT_ID, dept.DEPT_NO, dept.PARENT_DEPT_ID, dept_prop.DEPT_NAME FROM ECC_FND.ECC_FND_DEPT dept, ECC_FND.ECC_FND_DEPT_PROP dept_prop WHERE dept.REGISTER_ID=dept_prop.REGISTER_ID AND dept.REGISTER_ID=200 AND dept.ENABLE_FLAG='T' AND dept.DEPT_ID=dept_prop.DEPT_ID AND dept_prop.LANGUAGE_LOOKUP_TYPE='PCM_LANGUAGE' AND dept_prop.LANGUAGE_LOOKUP_CODE='CHINESE' start with(dept.DEPT_ID=2) CONNECT BY( dept.PARENT_DEPT_ID=PRIOR dept.DEPT_ID AND dept_prop.LANGUAGE_LOOKUP_CODE=PRIOR dept_prop.LANGUAGE_LOOKUP_CODE)
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
121fjv1ar6d9jselect this_.APPLY_ID as APPLY1_2_0_, this_.SUBMIT_BY as SUBMIT2_2_0_, this_.APPLY_BY as APPLY3_2_0_, this_.APPLY_NUM as APPLY4_2_0_, this_.PROCESS_ID as PROCESS5_2_0_, this_.PROCESS_NUM as PROCESS6_2_0_, this_.STATUS as STATUS2_0_, this_.DESCRIPTION as DESCRIPT8_2_0_, this_.APPLY_DATE as APPLY9_2_0_, this_.CURRENT_DEPTBASE_ID as CURRENT10_2_0_, this_.CURRENT_LOCATION_ID as CURRENT11_2_0_, this_.SUBMIT_DATE as SUBMIT12_2_0_, this_.CREATE_BY as CREATE13_2_0_, this_.CREATE_DATE as CREATE14_2_0_, this_.LAST_UPDATE_BY as LAST15_2_0_, this_.LAST_UPDATE_DATE as LAST16_2_0_, this_.PASS_DATE as PASS17_2_0_, this_.ISDELETED as ISDELETED2_0_, this_.ATTRIBUTE1 as ATTRIBUTE19_2_0_, this_.ATTRIBUTE2 as ATTRIBUTE20_2_0_ from HRV_APPLY_HEADER this_ where this_.CREATE_BY=:1 and (this_.STATUS=:2 or this_.ATTRIBUTE1 is not null) order by this_.APPLY_NUM desc
179ygzzrtb9hkselect hrvmenus0_.PARENTMENU as PARENTMENU1_, hrvmenus0_.MENU_ID as MENU1_1_, hrvmenus0_.MENU_ID as MENU1_16_0_, hrvmenus0_.PARENTMENU as PARENTMENU16_0_, hrvmenus0_.seq as seq16_0_, hrvmenus0_.TITLE as TITLE16_0_, hrvmenus0_.NAME as NAME16_0_, hrvmenus0_.TIP as TIP16_0_, hrvmenus0_.DESCRIPTION as DESCRIPT7_16_0_, hrvmenus0_.ICON as ICON16_0_, hrvmenus0_.FORWARD as FORWARD16_0_, hrvmenus0_.TARGET as TARGET16_0_, hrvmenus0_.CREATE_DATE as CREATE11_16_0_, hrvmenus0_.CREATE_BY as CREATE12_16_0_, hrvmenus0_.ATTRIBUTE1 as ATTRIBUTE13_16_0_, hrvmenus0_.ATTRIBUTE2 as ATTRIBUTE14_16_0_, hrvmenus0_.ISDISABLED as ISDISABLED16_0_, hrvmenus0_.ISDELETED as ISDELETED16_0_ from HRV_MENU hrvmenus0_ where hrvmenus0_.PARENTMENU=:1 order by hrvmenus0_.seq
2362zkbzvtg5fselect employee.EMPLOYEE_ID, employee_prop.EMPLOYEE_NAME, employee.EMPLOYEE_NO, employee.JOB_LOOKUP_TYPE, employee.JOB_LOOKUP_CODE, employee.TEL_NO1, employee.TEL_NO2, employee.CELL_PHONE1, employee.CELL_PHONE2, employee.EMAIL, employee.PASSWORD, employee.REGISTER_ID, employee.MEMO, dept.DEPT_ID, dept.DEPT_NO, dept.DEPT_NAME, 'dept.LEVEL' as DEPT_LEVEL, dept.PARENT_DEPT_ID, dept.FULL_NAME from ECC_FND.ECC_FND_EMPLOYEES employee, ECC_FND.ECC_FND_EMPLOYEES_PROP_INFO employee_prop, ECC_FND.ECC_FND_DEPT_V dept where employee.employee_id=:1 and employee.enable_flag='T' and employee.employee_id=employee_prop.employee_id and employee.dept_id=dept.dept_id and dept.language_lookup_type=:2 and dept.language_lookup_code=:3 and employee_prop.language_lookup_type=dept.language_lookup_type and employee_prop.language_lookup_code=dept.language_lookup_code
2p5uq9gs0dnrc SELECT FN_BAL_LWF_CONFIRM_DOC.DOC_ID AS docId, FN_BAL_LWF_CONFIRM_DOC.DETAIL_ID AS detailId, FN_BAL_LWF_CONFIRM_DOC.COST_CENTER AS costCenter, FN_BAL_LWF_CONFIRM_DOC.BAL_ID AS balId, FN_BAL_LWF_CONFIRM_DOC.APP_AMOUNT AS appAmount, FN_BAL_LWF_CONFIRM_DOC.FINAL_AMOUNT AS finalAmount, FN_BAL_LWF_CONFIRM_DOC.OTHER_PAY AS otherPay, FN_BAL_LWF_CONFIRM_DOC.OTHER_SUB AS otherSub, FN_BAL_LWF_CONFIRM_DOC.CALLBACK_SUB AS callbackSub, FN_BAL_LWF_CONFIRM_DOC.NO_BAL_NUM AS noBalNum, FN_BAL_LWF_CONFIRM_DOC.MEMO AS memo, FN_BAL_LWF_CONFIRM_DOC.REGISTER_ID AS registerId, FN_BAL_LWF_CONFIRM_DOC.ENABLE_FLAG AS enableFlag, FN_BAL_LWF_CONFIRM_DOC.CREATED_BY_CUSTOMER AS createdByCustomer, FN_BAL_LWF_CONFIRM_DOC.CREATED_BY_EMPLOYEE AS createdByEmployee, FN_BAL_LWF_CONFIRM_DOC.CREATION_TIME AS creationTime, FN_BAL_LWF_CONFIRM_DOC.CREATED_BY_DEPT AS createdByDept, FN_BAL_LWF_CONFIRM_DOC.LAST_UPDATE_BY AS lastUpdateBy, FN_BAL_LWF_CONFIRM_DOC.LAST_UPDATE_TIME AS lastUpdateTime, FN_BAL_LWF_CONFIRM_DOC.LAST_UPDATE_DEPT AS lastUpdateDept, FN_BALANCE.BAL_NO AS balNo, FN_BALANCE.PRT_CFG_ID AS prtCfgId, FN_BALANCE.CUSTOMER_ID AS customerId, FN_BALANCE.CUSTOMER_CODE AS customerCode, FN_BALANCE.CUSTOMER_NAME AS customerName, FN_BALANCE.EXP_LOOKUP_TYPE AS expLookupType, FN_BALANCE.EXP_LOOKUP_CODE AS expLookupCode, FN_BALANCE.BAL_AMOUNT AS balAmount, FN_BALANCE.AW_PUB_AMOUNT AS awPubAmount, FN_BALANCE.FINAL_BAL_AMOUNT AS finalBalAmount, FN_BALANCE.BAL_DATE_BEGIN AS balDateBegin, FN_B ALANCE.BAL_DATE_TO AS balDateTo, FN_BALANCE.BAL_DESC AS balDesc, FN_BALANCE.STATUS_LOOKUP_TYPE AS statusLookupType, FN_BALANCE.STATUS_LOOKUP_CODE AS statusLookupCode FROM ECC_SFM.FN_BAL_LWF_CONFIRM_DOC FN_BAL_LWF_CONFIRM_DOC, ECC_SFM.FN_BALANCE FN_BALANCE WHERE FN_BALANCE.bal_id=FN_BAL_LWF_CONFIRM_DOC.bal_id and FN_BALANCE.ENABLE_FLAG='T' and FN_BAL_LWF_CONFIRM_DOC.ENABLE_FLAG like '%T%' AND FN_BALANCE.ENABLE_FLAG = 'T' AND FN_BALANCE.BAL_DATE_TO>=to_date('2012-12-25', 'yyyy-mm-dd') AND FN_BALANCE.BAL_DATE_TO<=to_date('2012-12-25', 'yyyy-mm-dd')
3arf6d7urs67zselect GET_PERONAL_VACATION_INFO(14849, to_date('2013-03-29', 'yyyy-MM-dd'), '012') from dual
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
430c8b2d31ww7select hrvroleuse0_.EMP_ID as EMP2_1_, hrvroleuse0_.USER_ROLE_ID as USER1_1_, hrvroleuse0_.USER_ROLE_ID as USER1_23_0_, hrvroleuse0_.EMP_ID as EMP2_23_0_, hrvroleuse0_.ROLE_ID as ROLE3_23_0_, hrvroleuse0_.CREATE_DATE as CREATE4_23_0_, hrvroleuse0_.CREATE_BY as CREATE5_23_0_, hrvroleuse0_.LAST_UPDATE_DATE as LAST6_23_0_, hrvroleuse0_.LAST_UPDATE_BY as LAST7_23_0_ from HRV_ROLE_USER hrvroleuse0_ where hrvroleuse0_.EMP_ID=:1
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4cm0pmh1nhg3kselect hrvdeptass0_.DEPTBASE_ID as DEPTBASE3_1_, hrvdeptass0_.ASSISTANT_ID as ASSISTANT1_1_, hrvdeptass0_.ASSISTANT_ID as ASSISTANT1_32_0_, hrvdeptass0_.EMP_ID as EMP2_32_0_, hrvdeptass0_.DEPTBASE_ID as DEPTBASE3_32_0_, hrvdeptass0_.LOCATION_ID as LOCATION4_32_0_, hrvdeptass0_.ISPRIMARY as ISPRIMARY32_0_, hrvdeptass0_.EFFECTIVE_START_DATE as EFFECTIVE6_32_0_, hrvdeptass0_.EFFECTIVE_END_DATE as EFFECTIVE7_32_0_, hrvdeptass0_.CREATE_BY as CREATE8_32_0_, hrvdeptass0_.CREATE_DATE as CREATE9_32_0_, hrvdeptass0_.LAST_UPDATE_BY as LAST10_32_0_, hrvdeptass0_.LAST_UPDATE_DATE as LAST11_32_0_, hrvdeptass0_.ATTRIBUTE1 as ATTRIBUTE12_32_0_ from HRV_DEPT_ASSISTANT_V hrvdeptass0_ where hrvdeptass0_.DEPTBASE_ID=:1
4zvajcp2px4kmselect g.product_name, m.discript, m.material_id from ECC_FND.PRODUCT_GENERAL_PROP_INFO g, ECC_FND.PRODUCT_MODULE_GENERAL_INFO m where g.product_id = m.material_id and m.product_id = 200902
51b7c9xsgh5wvSELECT G.PRODUCT_NAME, P.MODULE_NAME FROM ECC_FND.PRODUCT_GENERAL_PROP_INFO G, ECC_FND.PRODUCT_MODULE_INFO M, ECC_FND.PRODUCT_MODULE_PROP_INFO P WHERE G.PRODUCT_ID = M.MATERIAL_ID AND G.LANGUAGE_LOOKUP_CODE = 'CHINESE' AND M.MODULE_ID = P.MODULE_ID AND P.LANGUAGE_LOOKUP_CODE = 'CHINESE' AND M.MODULE_CODE = 'PWBMC1110B2CTC2.0(01)'
53btfq0dt9bs9insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
53vfj6d97j68vBEGIN init_personal_vaction_info(:1, :2); END;
55cacd6du30awSELECT FN_BAL_LWF_CONFIRM_DOC_DT.DETAIL_ID AS detailId, FN_BAL_LWF_CONFIRM_DOC_DT.DOC_ID AS docId, FN_BAL_LWF_CONFIRM_DOC_DT.BAL_APP_LOOKUP_TYPE AS balAppLookupType, FN_BAL_LWF_CONFIRM_DOC_DT.BAL_APP_LOOKUP_CODE AS balAppLookupCode, FN_BAL_LWF_CONFIRM_DOC_DT.NUM AS num, FN_BAL_LWF_CONFIRM_DOC_DT.COM_NUM AS comNum, FN_BAL_LWF_CONFIRM_DOC_DT.QA_NO_PASS_NUM AS qaNoPassNum, FN_BAL_LWF_CONFIRM_DOC_DT.DUP_NUM AS dupNum, FN_BAL_LWF_CONFIRM_DOC_DT.CB_NO_PASS_NUM AS cbNoPassNum, FN_BAL_LWF_CONFIRM_DOC_DT.MEMO AS memo, FN_BAL_LWF_CONFIRM_DOC_DT.REGISTER_ID AS registerId, FN_BAL_LWF_CONFIRM_DOC_DT.ENABLE_FLAG AS enableFlag, FN_BAL_LWF_CONFIRM_DOC_DT.CREATED_BY_CUSTOMER AS createdByCustomer, FN_BAL_LWF_CONFIRM_DOC_DT.CREATED_BY_EMPLOYEE AS createdByEmployee, FN_BAL_LWF_CONFIRM_DOC_DT.CREATION_TIME AS creationTime, FN_BAL_LWF_CONFIRM_DOC_DT.CREATED_BY_DEPT AS createdByDept, FN_BAL_LWF_CONFIRM_DOC_DT.LAST_UPDATE_BY AS lastUpdateBy, FN_BAL_LWF_CONFIRM_DOC_DT.LAST_UPDATE_TIME AS lastUpdateTime, FN_BAL_LWF_CONFIRM_DOC_DT.LAST_UPDATE_DEPT AS lastUpdateDept FROM ECC_SFM.FN_BAL_LWF_CONFIRM_DOC_DT FN_BAL_LWF_CONFIRM_DOC_DT WHERE FN_BAL_LWF_CONFIRM_DOC_DT.DOC_ID =19380 AND FN_BAL_LWF_CONFIRM_DOC_DT.ENABLE_FLAG like '%T%'
5706xqmnwpmmjselect qa_biz_dea0_.DETAIL_ID as DETAIL1_658_0_, qa_biz_dea0_.info_id as info2_658_0_, qa_biz_dea0_.biz_no as biz3_658_0_, qa_biz_dea0_.mrp_id as mrp4_658_0_, qa_biz_dea0_.mrp_code as mrp5_658_0_, qa_biz_dea0_.sn as sn658_0_, qa_biz_dea0_.deal_lookup_type as deal7_658_0_, qa_biz_dea0_.deal_lookup_code as deal8_658_0_, qa_biz_dea0_.memo as memo658_0_, qa_biz_dea0_.created_by_employee as created10_658_0_, qa_biz_dea0_.created_time as created11_658_0_, qa_biz_dea0_.created_by_dept as created12_658_0_, qa_biz_dea0_.last_upd_employee as last13_658_0_, qa_biz_dea0_.last_upd_time as last14_658_0_, qa_biz_dea0_.last_upd_dept as last15_658_0_, qa_biz_dea0_.enable_flag as enable16_658_0_, qa_biz_dea0_.register_id as register17_658_0_, qa_biz_dea0_.num as num658_0_, qa_biz_dea0_.is_deal as is19_658_0_, qa_biz_dea0_.report_id as report20_658_0_, qa_biz_dea0_.reason as reason658_0_, qa_biz_dea0_.attr1 as attr22_658_0_, qa_biz_dea0_.type_lookup_type as type23_658_0_, qa_biz_dea0_.type_lookup_code as type24_658_0_ from ECC_SFM.qa_biz_deal_detail qa_biz_dea0_ where qa_biz_dea0_.DETAIL_ID=:1
5b6f2j1k0qjwrSELECT NVL(SUM(DECODE(HAL.STATUS, '1', 0, HAL.AMOUNT)), 0) AS APPLYDAYS FROM HRV_APPLY_HEADER HAH, HRV_APPLY_LINE HAL WHERE HAH.APPLY_ID = HAL.APPLY_ID AND HAH.APPLY_BY = :B4 AND HAH.APPLY_DATE <TRUNC(:B3 )+1 AND HAH.APPLY_DATE >= :B2 AND HAL.VACATION_TYPE = :B1 AND ( HAL.STATUS IS NULL OR HAL.STATUS NOT IN ('1') ) AND HAH.STATUS IN ('2', '3', '8')
5k0nmhc11a103SELECT FN_BAL_AWPB_DETAIL.DETAIL_ID AS detailId, FN_BAL_AWPB_DETAIL.BAL_ID AS balId, FN_BAL_AWPB_DETAIL.AW_PB_LOOKUP_TYPE AS awPbLookupType, FN_BAL_AWPB_DETAIL.AW_PB_LOOKUP_CODE AS awPbLookupCode, FN_BAL_AWPB_DETAIL.AW_PB_AMOUNT AS awPbAmount, FN_BAL_AWPB_DETAIL.AW_PB_FLAG AS awPbFlag, FN_BAL_AWPB_DETAIL.COST_CENTER AS costCenter, FN_BAL_AWPB_DETAIL.MEMO AS memo, FN_BAL_AWPB_DETAIL.bal_detail_id as balDetailId, FN_BAL_AWPB_DETAIL.REGISTER_ID AS registerId, FN_BAL_AWPB_DETAIL.ENABLE_FLAG AS enableFlag, FN_BAL_AWPB_DETAIL.CREATED_BY_CUSTOMER AS createdByCustomer, FN_BAL_AWPB_DETAIL.CREATED_BY_EMPLOYEE AS createdByEmployee, FN_BAL_AWPB_DETAIL.CREATION_TIME AS creationTime, FN_BAL_AWPB_DETAIL.CREATED_BY_DEPT AS createdByDept, FN_BAL_AWPB_DETAIL.LAST_UPDATE_BY AS lastUpdateBy, FN_BAL_AWPB_DETAIL.LAST_UPDATE_TIME AS lastUpdateTime, FN_BAL_AWPB_DETAIL.LAST_UPDATE_DEPT AS lastUpdateDept FROM ECC_SFM.FN_BAL_AWPB_DETAIL FN_BAL_AWPB_DETAIL WHERE FN_BAL_AWPB_DETAIL.BAL_DETAIL_ID =16360 AND FN_BAL_AWPB_DETAIL.ENABLE_FLAG like '%T%'
5m79nfnfm5ba6SELECT ECC_FND_LOOKUP_CODE_PROP.PROP_ID AS propId, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE AS lookupType, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE AS lookupCode, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE AS languageLookupType, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE AS languageLookupCode, ECC_FND_LOOKUP_CODE_PROP.MEANING AS meaning, ECC_FND_LOOKUP_CODE_PROP.DESCRIPTION AS description, ECC_FND_LOOKUP_CODE_PROP.CREATION_DATE AS creationDate, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_EMPLOYEE AS createdByEmployee, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_DEPT AS createdByDept, ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID AS registerId, ECC_FND_LOOKUP_CODE_PROP.ENABLE_FLAG AS enableFlag FROM ECC_FND.ECC_FND_LOOKUP_CODE_PROP ECC_FND_LOOKUP_CODE_PROP WHERE ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE = 'PCM_QA_DEAL_TYPE' AND ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE = 'PCM' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE = 'PCM_LANGUAGE' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE = 'CHINESE' AND ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID =200
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
65nmjgupyssarSELECT HUV.* FROM HRV_USER_V HUV WHERE HUV.EMP_ID = :B1 AND ROWNUM = 1
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6b0rzczyyku92select get_leave_employee_vaca_info(2837, to_date('2013-03-29', 'yyyy-MM-dd') ) from DUAL
76x7b5ghg4zdsselect hrvrole0_.ROLE_ID as ROLE1_21_0_, hrvrole0_.ROLE_NAME as ROLE2_21_0_, hrvrole0_.DESCRIPTION as DESCRIPT3_21_0_, hrvrole0_.CREATE_BY as CREATE4_21_0_, hrvrole0_.CREATE_DATE as CREATE5_21_0_, hrvrole0_.LAST_UPDATE_BY as LAST6_21_0_, hrvrole0_.LAST_UPDATE_DATE as LAST7_21_0_, hrvrole0_.ISDISABLED as ISDISABLED21_0_, hrvrole0_.ISDELETED as ISDELETED21_0_, hrvrole0_.ATTRIBUTE1 as ATTRIBUTE10_21_0_, hrvrole0_.ATTRIBUTE2 as ATTRIBUTE11_21_0_ from HRV_ROLE hrvrole0_ where hrvrole0_.ROLE_ID=:1
7h8y26yv85q2fselect v_hrvcostc0_.DEPTBASE_ID as DEPTBASE1_31_0_, v_hrvcostc0_.DEPTBASE_COSTCENTER_CODE as DEPTBASE2_31_0_, v_hrvcostc0_.DEPTBASE_NAME_EN as DEPTBASE3_31_0_, v_hrvcostc0_.DEPTBASE_NAME_CN as DEPTBASE4_31_0_, v_hrvcostc0_.EFFECTIVE_START_DATE as EFFECTIVE5_31_0_, v_hrvcostc0_.EFFECTIVE_END_DATE as EFFECTIVE6_31_0_, v_hrvcostc0_.MANAGER_ID as MANAGER7_31_0_, v_hrvcostc0_.LOCATION_ID as LOCATION8_31_0_, v_hrvcostc0_.COMPANY_ID as COMPANY9_31_0_, v_hrvcostc0_.CREATE_BY as CREATE10_31_0_, v_hrvcostc0_.CREATE_DATE as CREATE11_31_0_, v_hrvcostc0_.LAST_UPDATE_BY as LAST12_31_0_, v_hrvcostc0_.LAST_UPDATE_DATE as LAST13_31_0_ from HRV_COST_CENTER_V v_hrvcostc0_ where v_hrvcostc0_.DEPTBASE_ID=:1
7ht0rhn5z6h85SELECT ECC_FND_LOOKUP_CODE_PROP.PROP_ID AS propId, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE AS lookupType, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE AS lookupCode, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE AS languageLookupType, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE AS languageLookupCode, ECC_FND_LOOKUP_CODE_PROP.MEANING AS meaning, ECC_FND_LOOKUP_CODE_PROP.DESCRIPTION AS description, ECC_FND_LOOKUP_CODE_PROP.CREATION_DATE AS creationDate, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_EMPLOYEE AS createdByEmployee, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_DEPT AS createdByDept, ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID AS registerId, ECC_FND_LOOKUP_CODE_PROP.ENABLE_FLAG AS enableFlag FROM ECC_FND.ECC_FND_LOOKUP_CODE_PROP ECC_FND_LOOKUP_CODE_PROP WHERE ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE = 'PCM_QA_CHECK_PROD_RESULT_TYPE' AND ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE = 'QA_CHECK_PROD_RESULT_FIX' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE = 'PCM_LANGUAGE' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE = 'CHINESE' AND ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID =200
7krdqbw2jp68m SELECT * FROM ( SELECT resultTable.*, viewTable.*, ROWNUM AS resultNums FROM ( select /*+ index(PROD_STOREROOM_POS_INFO IND_PROD_STOREROOM_POS_MID) */ PROD_STOREROOM_POS_INFO.INFO_ID AS infoId, PROD_STOREROOM_POS_INFO.MRP_ID AS mrpId, PROD_STOREROOM_POS_INFO.MRP_CODE AS mrpCode, PROD_STOREROOM_POS_INFO.BIZ_LOOKUP_TYPE AS bizLookupType, PROD_STOREROOM_POS_INFO.BIZ_LOOKUP_CODE AS bizLookupCode, PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_TYPE AS prodStatusLookupType, PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_CODE AS prodStatusLookupCode, PROD_STOREROOM_POS_INFO.DC_ID AS dcId, PROD_STOREROOM_POS_INFO.DC_CODE AS dcCode, PROD_STOREROOM_POS_INFO.POS_CODE AS posCode, PROD_STOREROOM_POS_INFO.MEMO AS memo, PROD_STOREROOM_POS_INFO.CREATED_BY_EMPLOYEE AS createdByEmployee, PROD_STOREROOM_POS_INFO.CREATED_TIME AS createdTime, PROD_STOREROOM_POS_INFO.CREATED_BY_DEPT AS createdByDept, PROD_STOREROOM_POS_INFO.LAST_UPD_EMPLOYEE AS lastUpdEmployee, PROD_STOREROOM_POS_INFO.LAST_UPD_TIME AS lastUpdTime, PROD_STOREROOM_POS_INFO.LAST_UPD_DEPT AS lastUpdDept, PROD_STOREROOM_POS_INFO.ENABLE_FLAG AS enableFlag, PROD_STOREROOM_POS_INFO.REGISTER_ID AS registerId FROM ECC_SFM.PROD_STOREROOM_POS_INFO PROD_STOREROOM_POS_INFO WHERE PROD_STOREROOM_POS_INFO.MRP_ID=200821 AND PROD_STOREROOM_POS_INFO.MRP_ID=200821 AND PROD_STOREROOM_POS_INFO.MRP_CODE like '%PWBMC1110B2CTC2.0(01)%' AND PROD_STOREROOM_POS_INFO.BIZ_LOOKUP_TYPE = 'PCM_SFM_BIZ_TYPE' AND PROD_STOREROOM_POS_INFO.BIZ_LOOKU P_CODE = 'PCM_SFM_BIZ_TURNOVER_DIRECT' AND PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_TYPE = 'PCM_QA_CHECK_PROD_RESULT_TYPE' AND PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_CODE = 'QA_CHECK_PROD_RESULT_FIX' AND PROD_STOREROOM_POS_INFO.DC_ID=42 AND PROD_STOREROOM_POS_INFO.DC_ID=42)resultTable, ( SELECT COUNT(1) as resultCount FROM ECC_SFM.PROD_STOREROOM_POS_INFO PROD_STOREROOM_POS_INFO WHERE PROD_STOREROOM_POS_INFO.MRP_ID=200821 AND PROD_STOREROOM_POS_INFO.MRP_ID=200821 AND PROD_STOREROOM_POS_INFO.MRP_CODE like '%PWBMC1110B2CTC2.0(01)%' AND PROD_STOREROOM_POS_INFO.BIZ_LOOKUP_TYPE = 'PCM_SFM_BIZ_TYPE' AND PROD_STOREROOM_POS_INFO.BIZ_LOOKUP_CODE = 'PCM_SFM_BIZ_TURNOVER_DIRECT' AND PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_TYPE = 'PCM_QA_CHECK_PROD_RESULT_TYPE' AND PROD_STOREROOM_POS_INFO.PROD_STATUS_LOOKUP_CODE = 'QA_CHECK_PROD_RESULT_FIX' AND PROD_STOREROOM_POS_INFO.DC_ID=42 AND PROD_STOREROOM_POS_INFO.DC_ID=42) viewTable) WHERE resultNums >0 AND resultNums <= 10000
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
803b7z0t84sq7select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8nx3v9uc7g7pp SELECT CUSTOMER_ACL_INFO.ACL_ID AS aclId, CUSTOMER_ACL_INFO.CUSTOMER_ID AS customerId, CUSTOMER_ACL_INFO.ACL_CODE AS aclCode, CUSTOMER_ACL_INFO.ACL_NAME AS aclName, CUSTOMER_ACL_INFO.TYPE_LOOKUP_TYPE AS typeLookupType, CUSTOMER_ACL_INFO.PASSWORD AS password, CUSTOMER_ACL_INFO.TYPE_LOOKUP_CODE AS typeLookupCode, CUSTOMER_ACL_INFO.ACL_DESC AS aclDesc, CUSTOMER_ACL_INFO.CREATION_DATE AS creationDate, CUSTOMER_ACL_INFO.CREATED_BY_EMPLOYEE AS createdByEmployee, CUSTOMER_ACL_INFO.CREATED_BY_DEPT AS createdByDept, CUSTOMER_ACL_INFO.REGISTER_ID AS registerId, CUSTOMER_ACL_INFO.ENABLE_FLAG AS enableFlag, CUSTOMER_ACL_INFO.PERSONAL_ID AS personalId, CUSTOMER_PERSONAL_INFO.NAME AS name, CUSTOMER_PERSONAL_INFO.SEX AS sex, CUSTOMER_PERSONAL_INFO.OFFICE_PHONE AS officePhone, CUSTOMER_PERSONAL_INFO.HOME_PHONE AS homePhone, CUSTOMER_PERSONAL_INFO.ADDRESS AS address, CUSTOMER_PERSONAL_INFO.COMMUNICATION_ADDRESS AS communicationAddress, CUSTOMER_PERSONAL_INFO.EMAIL AS email, CUSTOMER_PERSONAL_INFO.MOBILE_PHONE AS mobilePhone, CUSTOMER_GENERAL_INFO.CUSTOMER_CODE AS customerCode, CUSTOMER_GENERAL_INFO.TYPE_LOOKUP_CODE AS serviceType, CUSTOMER_GENERAL_PROP_INFO.CUSTOMER_NAME AS customerName FROM ECC_CUSTOMER.CUSTOMER_ACL_INFO CUSTOMER_ACL_INFO left join ECC_CUSTOMER.CUSTOMER_PERSONAL_INFO CUSTOMER_PERSONAL_INFO ON (CUSTOMER_ACL_INFO.PERSONAL_ID = CUSTOMER_PERSONAL_INFO.PERSONAL_ID) , ECC_CUSTOMER.CUSTOMER_GENERAL_INFO CUSTOMER_GENERAL_INFO, ECC_CUSTOMER.CUSTOMER_GENERA L_PROP_INFO CUSTOMER_GENERAL_PROP_INFO WHERE CUSTOMER_ACL_INFO.ACL_CODE = 'FJ046' AND CUSTOMER_GENERAL_INFO.CUSTOMER_CODE = 'FJ046' AND CUSTOMER_ACL_INFO.REGISTER_ID =200 AND CUSTOMER_ACL_INFO.ENABLE_FLAG = 'T' AND CUSTOMER_ACL_INFO.CUSTOMER_ID = CUSTOMER_GENERAL_INFO.CUSTOMER_ID AND CUSTOMER_GENERAL_INFO.CUSTOMER_ID = CUSTOMER_GENERAL_PROP_INFO.CUSTOMER_ID AND CUSTOMER_GENERAL_PROP_INFO.LANGUAGE_LOOKUP_TYPE = 'PCM_LANGUAGE'AND CUSTOMER_GENERAL_PROP_INFO.LANGUAGE_LOOKUP_CODE = 'CHINESE'
8rnmj20bxfyd0select hrvbuhrs0_.DEPTBASE_ID as DEPTBASE3_1_, hrvbuhrs0_.BHR_ID as BHR1_1_, hrvbuhrs0_.BHR_ID as BHR1_29_0_, hrvbuhrs0_.EMP_ID as EMP2_29_0_, hrvbuhrs0_.DEPTBASE_ID as DEPTBASE3_29_0_, hrvbuhrs0_.ISPRIMARY as ISPRIMARY29_0_, hrvbuhrs0_.LOCATION_ID as LOCATION5_29_0_, hrvbuhrs0_.EFFECTIVE_START_DATE as EFFECTIVE6_29_0_, hrvbuhrs0_.EFFECTIVE_END_DATE as EFFECTIVE7_29_0_, hrvbuhrs0_.CREATE_BY as CREATE8_29_0_, hrvbuhrs0_.CREATE_DATE as CREATE9_29_0_, hrvbuhrs0_.LAST_UPDATE_BY as LAST10_29_0_, hrvbuhrs0_.LAST_UPDATE_DATE as LAST11_29_0_, hrvbuhrs0_.ATTRIBUTE1 as ATTRIBUTE12_29_0_ from HRV_BU_HR_V hrvbuhrs0_ where hrvbuhrs0_.DEPTBASE_ID=:1
9dqs2j1kdughbselect hrvresourc0_.RESOURCE_TREE_ID as RESOURCE2_1_, hrvresourc0_.RESOURCE_ID as RESOURCE1_1_, hrvresourc0_.RESOURCE_ID as RESOURCE1_19_0_, hrvresourc0_.RESOURCE_TREE_ID as RESOURCE2_19_0_, hrvresourc0_.NAME as NAME19_0_, hrvresourc0_.DESCRIPTION as DESCRIPT4_19_0_, hrvresourc0_.KEY_WORD as KEY5_19_0_, hrvresourc0_.CREATE_DATE as CREATE6_19_0_, hrvresourc0_.CREATE_BY as CREATE7_19_0_, hrvresourc0_.LAST_UPDATE_BY as LAST8_19_0_, hrvresourc0_.LAST_UPDATE_DATE as LAST9_19_0_, hrvresourc0_.ISDISABLED as ISDISABLED19_0_, hrvresourc0_.ISDELETED as ISDELETED19_0_, hrvresourc0_.ATTRIBUTE1 as ATTRIBUTE12_19_0_, hrvresourc0_.ATTRIBUTE2 as ATTRIBUTE13_19_0_ from HRV_RESOURCE hrvresourc0_ where hrvresourc0_.RESOURCE_TREE_ID=:1
9kthv2gyukhzzselect g.product_name, m.discript, m.material_id from ECC_FND.PRODUCT_GENERAL_PROP_INFO g, ECC_FND.PRODUCT_MODULE_GENERAL_INFO m where g.product_id = m.material_id and m.product_id = 200821
ac4r8t6csxh45 SELECT DISTINCT RECEIVE_GOODS_INFO.RECEIVE_NO AS receiveNo, RECEIVE_GOODS_INFO.APP_ID AS appId, RECEIVE_GOODS_INFO.CUSTOMER_CODE AS customerCode, RECEIVE_GOODS_INFO.FREIGHT_COMPANY_ID AS freightCompanyId, RECEIVE_GOODS_INFO.FREIGHT_NO AS freightNo, RECEIVE_GOODS_INFO.FREIGHT_PERSON AS freightPerson, RECEIVE_GOODS_INFO.FREIGHT_PHONE AS freightPhone, RECEIVE_GOODS_INFO.FREIGHT_MOBILE AS freightMobile, RECEIVE_GOODS_INFO.ARRIVE_DATE AS arriveDate, RECEIVE_GOODS_INFO.CONSIGNMENT_ADDR AS consignmentAddr, RECEIVE_GOODS_INFO.CONSIGNMENT_PERSON AS consignmentPerson, RECEIVE_GOODS_INFO.CONSIGNMENT_PHONE AS consignmentPhone, RECEIVE_GOODS_INFO.CONSIGNMENT_COMPANY AS consignmentCompany, RECEIVE_GOODS_INFO.RECEPTION_PERSON AS receptionPerson, RECEIVE_GOODS_INFO.RECEPTION_PHONE AS receptionPhone, RECEIVE_GOODS_INFO.RECEPTION_COMPANY AS receptionCompany, RECEIVE_GOODS_INFO.RECEPTION_ADDR AS receptionAddr, RECEIVE_GOODS_INFO.RECEPTION_DEPT_ID AS receptionDeptId, RECEIVE_GOODS_INFO.FREIGHT_WAY_LOOKUP_TYPE AS freightWayLookupType, RECEIVE_GOODS_INFO.FREIGHT_WAY_LOOKUP_CODE AS freightWayLookupCode, RECEIVE_GOODS_INFO.RECEIVE_LOOKUP_TYPE AS receiveLookupType, RECEIVE_GOODS_INFO.RECEIVE_LOOKUP_CODE AS receiveLookupCode, RECEIVE_GOODS_INFO.BIZ_LOOKUP_TYPE AS bizLookupType, RECEIVE_GOODS_INFO.BIZ_LOOKUP_CODE AS bizLookupCode, RECEIVE_GOODS_INFO.status_LOOKUP_TYPE AS statusLookupType, RECEIVE_GOODS_INFO.STATUS_LOOKUP_CODE AS statusLookupCode, RECEIVE_GOODS_INFO.BIZ_NO AS bizNo, RECE IVE_GOODS_INFO.QA_NO AS qaNo, RECEIVE_GOODS_INFO.MEMO AS memo, RECEIVE_GOODS_INFO.CONSIGNMENT_NO AS consignmentNo, RECEIVE_GOODS_INFO.REGISTER_ID AS registerId, RECEIVE_GOODS_INFO.ENABLE_FLAG AS enableFlag, RECEIVE_GOODS_INFO.CREATED_BY_EMPLOYEE AS createdByEmployee, RECEIVE_GOODS_INFO.CREATION_TIME AS creationTime, RECEIVE_GOODS_INFO.CREATED_BY_DEPT AS createdByDept, RECEIVE_GOODS_INFO.LAST_UPD_EMPLOYEE AS lastUpdEmployee, RECEIVE_GOODS_INFO.CREATED_BY_CUSTOMER AS createdByCustomer, RECEIVE_GOODS_INFO.CUSTOMER_ID AS customerId, RECEIVE_GOODS_INFO.LAST_UPD_DEPT AS lastUpdDept, RECEIVE_GOODS_INFO.LAST_UPD_DATE AS lastUpdDate, RECEIVE_GOODS_INFO.RECEIVE_CUSTOMER as receiveCustomer, RECEIVE_GOODS_INFO.IS_SHELF AS isShelf, APPLICATION_GENERAL_INFO.APPLY_NO AS applyNo, APPLICATION_GENERAL_INFO.APPLICANT_ID AS applicantId, APPLICATION_GENERAL_INFO.APPLICANT_DEPT_ID AS applicantDeptId, APPLICATION_GENERAL_INFO.APP_SUBJECT AS appSubject, APPLICATION_GENERAL_INFO.EDIT_DATE AS editDate, APPLICATION_GENERAL_INFO.APPLY_DATE AS applyDate, APPLICATION_GENERAL_INFO.APPLY_REASON AS applyReason, APPLICATION_GENERAL_INFO.SIGNED_NO AS signedNo, APPLICATION_GENERAL_INFO.SIGNER_ID AS signerId, APPLICATION_GENERAL_INFO.SIGNED_DEPT_ID AS signedDeptId, APPLICATION_GENERAL_INFO.SIGNED_DATE AS signedDate, APPLICATION_GENERAL_INFO.SIGNED_DESC AS signedDesc, APPLICATION_GENERAL_INFO.STATUS_LOOKUP_TYPE AS appStatusLookupType, APPLICATION_GENERAL_INFO.STATUS_LOOKUP_CODE AS appStatus LookupCode, APPLICATION_GENERAL_INFO.TYPE_LOOKUP_TYPE AS appTypeLookupType, APPLICATION_GENERAL_INFO.TYPE_LOOKUP_CODE AS appTypeLookupCode FROM ECC_BIZ.APPLICATION_GENERAL_INFO APPLICATION_GENERAL_INFO , ecc_sfm.receive_goods_detail_prop receive_goods_detail_prop, ECC_SFM.RECEIVE_GOODS_INFO RECEIVE_GOODS_INFO WHERE APPLICATION_GENERAL_INFO.APP_ID=RECEIVE_GOODS_INFO.APP_ID AND RECEIVE_GOODS_INFO.RECEIVE_NO=receive_goods_detail_prop.RECEIVE_NO AND RECEIVE_GOODS_INFO.ENABLE_FLAG like '%T%' AND RECEIVE_GOODS_INFO.RECEIVE_CUSTOMER =100700 AND APPLICATION_GENERAL_INFO.STATUS_LOOKUP_CODE = 'APPLICATION_STATE_NOAUDI_CODE' ORDER BY RECEIVE_GOODS_INFO.LAST_UPD_DATE DESC
anuhfdu5b01sbSELECT ECC_FND_LOOKUP_CODE_PROP.PROP_ID AS propId, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE AS lookupType, ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE AS lookupCode, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE AS languageLookupType, ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE AS languageLookupCode, ECC_FND_LOOKUP_CODE_PROP.MEANING AS meaning, ECC_FND_LOOKUP_CODE_PROP.DESCRIPTION AS description, ECC_FND_LOOKUP_CODE_PROP.CREATION_DATE AS creationDate, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_EMPLOYEE AS createdByEmployee, ECC_FND_LOOKUP_CODE_PROP.CREATED_BY_DEPT AS createdByDept, ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID AS registerId, ECC_FND_LOOKUP_CODE_PROP.ENABLE_FLAG AS enableFlag FROM ECC_FND.ECC_FND_LOOKUP_CODE_PROP ECC_FND_LOOKUP_CODE_PROP WHERE ECC_FND_LOOKUP_CODE_PROP.LOOKUP_TYPE = 'PCM_SFM_BIZ_TYPE' AND ECC_FND_LOOKUP_CODE_PROP.LOOKUP_CODE = 'PCM_SFM_BIZ_TURNOVER_DIRECT' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_TYPE = 'PCM_LANGUAGE' AND ECC_FND_LOOKUP_CODE_PROP.LANGUAGE_LOOKUP_CODE = 'CHINESE' AND ECC_FND_LOOKUP_CODE_PROP.REGISTER_ID =200
b25tauyfuh1wfselect qa_biz_dea0_.INFO_ID as INFO1_659_0_, qa_biz_dea0_.biz_lookup_type as biz2_659_0_, qa_biz_dea0_.biz_lookup_code as biz3_659_0_, qa_biz_dea0_.biz_no as biz4_659_0_, qa_biz_dea0_.memo as memo659_0_, qa_biz_dea0_.created_by_employee as created6_659_0_, qa_biz_dea0_.created_time as created7_659_0_, qa_biz_dea0_.created_by_dept as created8_659_0_, qa_biz_dea0_.last_upd_employee as last9_659_0_, qa_biz_dea0_.last_upd_time as last10_659_0_, qa_biz_dea0_.last_upd_dept as last11_659_0_, qa_biz_dea0_.enable_flag as enable12_659_0_, qa_biz_dea0_.register_id as register13_659_0_, qa_biz_dea0_.customer_id as customer14_659_0_, qa_biz_dea0_.customer_code as customer15_659_0_ from ECC_SFM.qa_biz_deal_info qa_biz_dea0_ where qa_biz_dea0_.INFO_ID=:1
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
cbu8ww54m5d4wselect max(hrvapplyhe0_.APPLY_NUM) as col_0_0_ from HRV_APPLY_HEADER hrvapplyhe0_ where hrvapplyhe0_.APPLY_NUM like 'VA201303%'
crjpjxn045bmf select v_hrvuser0_.EMP_ID as EMP1_34_0_, v_hrvuser0_.DEPTBASE_ID as DEPTBASE2_34_0_, v_hrvuser0_.APPROVE_LEVEL2 as APPROVE3_34_0_, v_hrvuser0_.APPROVE_LEVEL3 as APPROVE4_34_0_, v_hrvuser0_.APPROVE_LEVEL1 as APPROVE5_34_0_, v_hrvuser0_.LOCATION_ID as LOCATION6_34_0_, v_hrvuser0_.SALARY_SITE_ID as SALARY7_34_0_, v_hrvuser0_.G_EMP_NUM as G8_34_0_, v_hrvuser0_.L_EMP_NUM as L9_34_0_, v_hrvuser0_.USER_PWD as USER10_34_0_, v_hrvuser0_.USER_FULL_NAME as USER11_34_0_, v_hrvuser0_.TYPE as TYPE34_0_, v_hrvuser0_.EFFECTIVE_START_DATE as EFFECTIVE13_34_0_, v_hrvuser0_.EFFECTIVE_END_DATE as EFFECTIVE14_34_0_, v_hrvuser0_.EMPLOY_DATE1 as EMPLOY15_34_0_, v_hrvuser0_.EMPLOY_DATE2 as EMPLOY16_34_0_, v_hrvuser0_.EMPLOY_DATE3 as EMPLOY17_34_0_, v_hrvuser0_.EMPLOY_DATE4 as EMPLOY18_34_0_, v_hrvuser0_.EMPLOY_DATE5 as EMPLOY19_34_0_, v_hrvuser0_.LEAVE_DATE as LEAVE20_34_0_, v_hrvuser0_.MARRY_DATE as MARRY21_34_0_, v_hrvuser0_.BRITHDAY as BRITHDAY34_0_, v_hrvuser0_.CHILD_BIRTH_DATE as CHILD23_34_0_, v_hrvuser0_.SUPERVISOR_ID as SUPERVISOR24_34_0_, v_hrvuser0_.GENDER as GENDER34_0_, v_hrvuser0_.EMAIL as EMAIL34_0_, v_hrvuser0_.MOBILE as MOBILE34_0_, v_hrvuser0_.TEL as TEL34_0_, v_hrvuser0_.CREATE_BY as CREATE29_34_0_, v_hrvuser0_.CREATE_DATE as CREATE30_34_0_, v_hrvuser0_.LAST_UPDATE_BY as LAST31_34_0_, v_hrvuser0_.LAST_UPDATE_DATE as LAST32_34_0_, v_hrvuser0_.ATTRIBUTE1 as ATTRIBUTE33_34_0_, v_hrvuser0_.ATTRIBUTE2 as ATTRIBUTE34_34_0_, v_hrvuser0_.ATTRIBUTE3 as ATTR IBUTE35_34_0_, v_hrvuser0_.SOCIAL_EXPERIENCE as SOCIAL36_34_0_ from HRV_USER_V v_hrvuser0_ where v_hrvuser0_.EMP_ID=:1
dsz9u3s5h6jurSELECT NVL(SUM(ADL.AMOUNT), 0) AS ADJUSTDAYS FROM HRV_ADJUST_LINE ADL, HRV_ADJUST_HEADER ADH WHERE ADL.ADJUST_ID = ADH.ADJUST_ID AND ADH.ADJUST_DATE <TRUNC(:B2 )+1 AND ADL.VACATION_TYPE = :B1 AND EXISTS (SELECT * FROM HRV_APPLY_HEADER HAH, HRV_APPLY_LINE HAL WHERE HAH.APPLY_ID = HAL.APPLY_ID AND HAL.APPLY_LINE_ID = ADL.APPLY_LINE_ID AND HAH.APPLY_DATE <TRUNC(:B2 )+1 AND HAH.APPLY_DATE >= :B4 AND HAH.APPLY_BY = :B3 )
dun2f36s6j3vzselect GET_PERONAL_VACATION_INFO(2482, to_date('2013-03-29', 'yyyy-MM-dd'), '040') from dual
f5zvvqj84ax8nselect hrvresourc0_.RESOURCE_TREE_PARENT_ID as RESOURCE2_1_, hrvresourc0_.RESOURCE_TREE_ID as RESOURCE1_1_, hrvresourc0_.RESOURCE_TREE_ID as RESOURCE1_20_0_, hrvresourc0_.RESOURCE_TREE_PARENT_ID as RESOURCE2_20_0_, hrvresourc0_.RESOURCE_TREE_NAME as RESOURCE3_20_0_, hrvresourc0_.RESOURCE_TREE_DESCN as RESOURCE4_20_0_, hrvresourc0_.CREATE_DATE as CREATE5_20_0_, hrvresourc0_.CREATE_BY as CREATE6_20_0_, hrvresourc0_.LAST_UPDATE_BY as LAST7_20_0_, hrvresourc0_.LAST_UPDATE_DATE as LAST8_20_0_, hrvresourc0_.ISDELETED as ISDELETED20_0_, hrvresourc0_.ISDISABLED as ISDISABLED20_0_ from HRV_RESOURCE_TREE hrvresourc0_ where hrvresourc0_.RESOURCE_TREE_PARENT_ID=:1
fraz8rxzhtw2pselect * from usr_ccss.Fbp_Accessory_V t where t.relation_Id=1801 and t.enabled_Flag='T'
fvcdp6sf72ah0select GET_PERONAL_VACATION_INFO(14849, to_date('2013-03-29', 'yyyy-MM-dd'), '011') from dual
g2wr3u7s1gtf3select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
gj3zt1nnm53r5 SELECT DISTINCT QA_BIZ_DEAL_DETAIL.DETAIL_ID AS detailId, QA_BIZ_DEAL_DETAIL.INFO_ID AS infoId, QA_BIZ_DEAL_DETAIL.BIZ_NO AS bizNo, QA_BIZ_DEAL_DETAIL.MRP_ID AS mrpId, QA_BIZ_DEAL_DETAIL.MRP_CODE AS mrpCode, QA_BIZ_DEAL_DETAIL.SN AS sn, QA_BIZ_DEAL_DETAIL.NUM AS num, QA_BIZ_DEAL_DETAIL.DEAL_LOOKUP_TYPE AS dealLookupType, QA_BIZ_DEAL_DETAIL.DEAL_LOOKUP_CODE AS dealLookupCode, QA_BIZ_DEAL_DETAIL.MEMO AS memo, QA_BIZ_DEAL_DETAIL.REASON AS reason, QA_BIZ_DEAL_DETAIL.ATTR1 AS attr1, QA_BIZ_DEAL_DETAIL.TYPE_LOOKUP_TYPE AS typeLookupType, QA_BIZ_DEAL_DETAIL.TYPE_LOOKUP_CODE AS typeLookupCode, QA_BIZ_DEAL_DETAIL.REPORT_ID AS reportId, QA_BIZ_DEAL_INFO.BIZ_LOOKUP_TYPE AS bizLookupType, QA_BIZ_DEAL_INFO.BIZ_LOOKUP_CODE AS bizLookupCode, QA_BIZ_DEAL_INFO.CUSTOMER_ID AS customerId, QA_BIZ_DEAL_DETAIL.is_deal as isDeal, QA_BIZ_DEAL_INFO.CUSTOMER_CODE AS customerCode, QA_BIZ_DEAL_DETAIL.CREATED_BY_EMPLOYEE AS createdByEmployee, QA_BIZ_DEAL_DETAIL.CREATED_TIME AS createdTime, QA_BIZ_DEAL_DETAIL.CREATED_BY_DEPT AS createdByDept, QA_BIZ_DEAL_DETAIL.LAST_UPD_EMPLOYEE AS lastUpdEmployee, QA_BIZ_DEAL_DETAIL.LAST_UPD_TIME AS lastUpdTime, QA_BIZ_DEAL_DETAIL.LAST_UPD_DEPT AS lastUpdDept, QA_BIZ_DEAL_DETAIL.ENABLE_FLAG AS enableFlag, QA_BIZ_DEAL_DETAIL.REGISTER_ID AS registerId FROM ECC_SFM.QA_BIZ_DEAL_DETAIL QA_BIZ_DEAL_DETAIL, ECC_SFM.QA_BIZ_DEAL_INFO QA_BIZ_DEAL_INFO WHERE QA_BIZ_DEAL_INFO.INFO_ID=QA_BIZ_DEAL_DETAIL.INFO_ID AND QA_BIZ_DEAL_DETAIL.CREATED_BY_DEPT in (0, 42) AN D QA_BIZ_DEAL_DETAIL.DEAL_LOOKUP_TYPE = 'PCM_QA_DEAL_TYPE' AND QA_BIZ_DEAL_DETAIL.DEAL_LOOKUP_CODE = 'PCM' AND QA_BIZ_DEAL_DETAIL.CREATED_TIME>=to_timestamp('2013-03-28 00:00:00', 'yyyy-mm-dd hh24:mi:ss.ff2') ORDER BY QA_BIZ_DEAL_DETAIL.LAST_UPD_TIME DESC
gkm3ju73qrdn7select * from usr_ccss.Fbp_Accessory_V t where t.relation_Id=1802 and t.enabled_Flag='T'
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,045 0.29 18.33
CPU used when call started 999 0.28 17.53
CR blocks created 2 0.00 0.04
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 18,970 5.30 332.81
DBWR checkpoint buffers written 583 0.16 10.23
DBWR checkpoints 0 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 53 0.01 0.93
DBWR undo block writes 115 0.03 2.02
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 5 0.00 0.09
IMU Redo allocation size 46,716 13.06 819.58
IMU commits 40 0.01 0.70
IMU contention 0 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 2 0.00 0.04
IMU undo allocation size 150,868 42.19 2,646.81
IMU- failed to get a private strand 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 19,653 5.50 344.79
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 26 0.01 0.46
application wait time 0 0.00 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 11,446 3.20 200.81
buffer is not pinned count 118,902 33.25 2,086.00
buffer is pinned count 91,210 25.51 1,600.18
bytes received via SQL*Net from client 6,283,848 1,757.25 110,242.95
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 6,733,268 1,882.93 118,127.51
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 36,776 10.28 645.19
calls to kcmgas 586 0.16 10.28
calls to kcmgcs 38 0.01 0.67
change write time 9 0.00 0.16
cleanout - number of ktugct calls 33 0.01 0.58
cleanouts and rollbacks - consistent read gets 0 0.00 0.00
cleanouts only - consistent read gets 3 0.00 0.05
cluster key scan block gets 4,095 1.15 71.84
cluster key scans 819 0.23 14.37
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: callback failure 7 0.00 0.12
commit cleanouts 988 0.28 17.33
commit cleanouts successfully completed 981 0.27 17.21
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 22 0.01 0.39
concurrency wait time 8 0.00 0.14
consistent changes 2 0.00 0.04
consistent gets 276,508 77.32 4,851.02
consistent gets - examination 66,049 18.47 1,158.75
consistent gets direct 21 0.01 0.37
consistent gets from cache 276,487 77.32 4,850.65
cursor authentications 339 0.09 5.95
data blocks consistent reads - undo records applied 2 0.00 0.04
db block changes 5,374 1.50 94.28
db block gets 4,715 1.32 82.72
db block gets direct 21 0.01 0.37
db block gets from cache 4,694 1.31 82.35
deferred (CURRENT) block cleanout applications 528 0.15 9.26
dirty buffers inspected 0 0.00 0.00
enqueue conversions 719 0.20 12.61
enqueue releases 31,491 8.81 552.47
enqueue requests 31,491 8.81 552.47
enqueue waits 0 0.00 0.00
execute count 19,696 5.51 345.54
frame signature mismatch 0 0.00 0.00
free buffer inspected 0 0.00 0.00
free buffer requested 14,044 3.93 246.39
heap block compress 19 0.01 0.33
hot buffers moved to head of LRU 0 0.00 0.00
immediate (CR) block cleanout applications 3 0.00 0.05
immediate (CURRENT) block cleanout applications 164 0.05 2.88
index fast full scans (full) 0 0.00 0.00
index fetch by key 42,968 12.02 753.82
index scans kdiixs1 10,957 3.06 192.23
leaf node 90-10 splits 5 0.00 0.09
leaf node splits 13 0.00 0.23
lob reads 279 0.08 4.89
lob writes 37 0.01 0.65
lob writes unaligned 37 0.01 0.65
logons cumulative 211 0.06 3.70
messages received 515 0.14 9.04
messages sent 515 0.14 9.04
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 183,701 51.37 3,222.82
opened cursors cumulative 14,119 3.95 247.70
parse count (failures) 0 0.00 0.00
parse count (hard) 939 0.26 16.47
parse count (total) 11,941 3.34 209.49
parse time cpu 220 0.06 3.86
parse time elapsed 246 0.07 4.32
physical read IO requests 1,525 0.43 26.75
physical read bytes 114,540,544 32,030.77 2,009,483.23
physical read total IO requests 2,414 0.68 42.35
physical read total bytes 128,974,848 36,067.27 2,262,716.63
physical read total multi block requests 914 0.26 16.04
physical reads 13,982 3.91 245.30
physical reads cache 13,961 3.90 244.93
physical reads cache prefetch 12,457 3.48 218.54
physical reads direct 21 0.01 0.37
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 477 0.13 8.37
physical write bytes 4,947,968 1,383.68 86,806.46
physical write total IO requests 4,550 1.27 79.82
physical write total bytes 65,155,072 18,220.34 1,143,071.44
physical write total multi block requests 528 0.15 9.26
physical writes 604 0.17 10.60
physical writes direct 21 0.01 0.37
physical writes direct (lob) 21 0.01 0.37
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 583 0.16 10.23
physical writes non checkpoint 136 0.04 2.39
pinned buffers inspected 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 3,531 0.99 61.95
recursive calls 107,824 30.15 1,891.65
recursive cpu usage 537 0.15 9.42
redo blocks written 3,160 0.88 55.44
redo buffer allocation retries 0 0.00 0.00
redo entries 2,613 0.73 45.84
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 38 0.01 0.67
redo size 1,397,580 390.83 24,518.95
redo synch time 3 0.00 0.05
redo synch writes 1,908 0.53 33.47
redo wastage 151,580 42.39 2,659.30
redo write time 13 0.00 0.23
redo writes 497 0.14 8.72
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 2 0.00 0.04
rows fetched via callback 36,534 10.22 640.95
session connect time 0 0.00 0.00
session cursor cache hits 10,241 2.86 179.67
session logical reads 281,223 78.64 4,933.74
session pga memory 2,661,328 744.23 46,689.96
session pga memory max 15,506,384 4,336.29 272,041.82
session uga memory 8,595,760,576 2,403,767.77 150,802,817.12
session uga memory max 63,195,412 17,672.33 1,108,691.44
shared hash latch upgrades - no wait 11,280 3.15 197.89
shared hash latch upgrades - wait 0 0.00 0.00
sorts (memory) 3,499 0.98 61.39
sorts (rows) 35,261 9.86 618.61
sql area purged 205 0.06 3.60
summed dirty queue length 0 0.00 0.00
switch current to new buffer 33 0.01 0.58
table fetch by rowid 67,598 18.90 1,185.93
table fetch continued row 134 0.04 2.35
table scan blocks gotten 150,911 42.20 2,647.56
table scan rows gotten 8,040,527 2,248.50 141,061.88
table scans (direct read) 0 0.00 0.00
table scans (long tables) 3 0.00 0.05
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 6,861 1.92 120.37
total number of times SMON posted 0 0.00 0.00
transaction rollbacks 0 0.00 0.00
undo change vector size 393,416 110.02 6,902.04
user I/O wait time 198 0.06 3.47
user calls 27,428 7.67 481.19
user commits 45 0.01 0.79
user rollbacks 12 0.00 0.21
workarea executions - optimal 2,303 0.64 40.40
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 25,337 26,697
opened cursors current 56 103
logons current 96 95

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
USR_CCSS2 1,302 0 1.13 10.56 15 0 19 1.58
SYSAUX 56 0 1.79 1.20 234 0 0 0.00
GLOBAL_BIS 153 0 2.22 1.03 18 0 0 0.00
SYSTEM 16 0 3.13 1.00 98 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 112 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
GLOBAL_BIS E:\ORACLE\ORADATA\SZORCL\GLOBAL_BIS01.DBF 153 0 2.22 1.03 18 0 0 0.00
SYSAUX E:\ORACLE\ORADATA\SZORCL\SYSAUX01.DBF 56 0 1.79 1.20 234 0 0 0.00
SYSTEM E:\ORACLE\ORADATA\SZORCL\SYSTEM01.DBF 16 0 3.13 1.00 98 0 0 0.00
UNDOTBS1 E:\ORACLE\ORADATA\SZORCL\UNDOTBS01.DBF 0 0     112 0 0 0.00
USR_CCSS2 E:\ORACLE\ORADATA\SZORCL\USR_CCSS201.DBF 479 0 0.96 9.28 5 0 4 5.00
USR_CCSS2 E:\ORACLE\ORADATA\SZORCL\USR_CCSS203.DBF 322 0 1.18 13.11 8 0 1 0.00
USR_CCSS2 E:\ORACLE\ORADATA\SZORCL\USR_CCSS204.DBF 501 0 1.26 10.13 2 0 14 0.71

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 168,000 95 281,571 13,965 583 0 0 19


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 9 130 221 1565 368640 1565  
E 0 9 143 340 530 368640 530  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 128 0.10 16,000 2.43 2,233,536
D 256 0.19 32,000 1.06 977,611
D 384 0.29 48,000 1.02 938,788
D 512 0.38 64,000 1.02 932,490
D 640 0.48 80,000 1.01 927,889
D 768 0.57 96,000 1.01 927,071
D 896 0.67 112,000 1.01 925,780
D 1,024 0.76 128,000 1.01 923,671
D 1,152 0.86 144,000 1.00 922,004
D 1,280 0.95 160,000 1.00 919,094
D 1,344 1.00 168,000 1.00 918,492
D 1,408 1.05 176,000 1.00 917,708
D 1,536 1.14 192,000 1.00 917,701
D 1,664 1.24 208,000 1.00 917,701
D 1,792 1.33 224,000 1.00 917,701
D 1,920 1.43 240,000 1.00 917,701
D 2,048 1.52 256,000 1.00 917,701
D 2,176 1.62 272,000 1.00 917,701
D 2,304 1.71 288,000 1.00 917,701
D 2,432 1.81 304,000 1.00 917,701
D 2,560 1.90 320,000 0.94 864,850

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 151 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 1,024 892 57.10 0.00 0.00 0.00 0.00 102,400
E 1,024 891 57.11 0.00 0.00 0.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 2,124 2,124 0 0
64K 128K 3 3 0 0
256K 512K 2 2 0 0
512K 1024K 183 183 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
128 0.13 1,912.31 61.28 97.00 0
256 0.25 1,912.31 0.00 100.00 0
512 0.50 1,912.31 0.00 100.00 0
768 0.75 1,912.31 0.00 100.00 0
1,024 1.00 1,912.31 0.00 100.00 0
1,229 1.20 1,912.31 0.00 100.00 0
1,434 1.40 1,912.31 0.00 100.00 0
1,638 1.60 1,912.31 0.00 100.00 0
1,843 1.80 1,912.31 0.00 100.00 0
2,048 2.00 1,912.31 0.00 100.00 0
3,072 3.00 1,912.31 0.00 100.00 0
4,096 4.00 1,912.31 0.00 100.00 0
6,144 6.00 1,912.31 0.00 100.00 0
8,192 8.00 1,912.31 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
104 0.87 19 2,796 6,805 1.00 79 1.07 1,317,515
120 1.00 33 4,391 6,810 1.00 74 1.00 1,321,394
136 1.13 48 5,672 6,813 1.00 71 0.96 1,323,742
152 1.27 63 6,828 6,815 1.00 69 0.93 1,325,035
168 1.40 78 8,344 6,816 1.00 68 0.92 1,325,900
184 1.53 93 9,968 6,816 1.00 68 0.92 1,326,474
200 1.67 108 12,545 6,816 1.00 68 0.92 1,326,767
216 1.80 123 13,962 6,816 1.00 68 0.92 1,327,026
232 1.93 138 15,355 6,816 1.00 68 0.92 1,327,329
248 2.07 153 16,930 6,816 1.00 68 0.92 1,327,572

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
376 0.25 1,806 918,485
752 0.50 1,806 918,485
1,128 0.75 1,806 918,485
1,504 1.00 1,806 918,485
1,880 1.25 1,806 918,485
2,256 1.50 1,806 918,485
2,632 1.75 1,807 918,485
3,008 2.00 1,806 918,485

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
8 0.50 0 0 0 0
16 1.00 0 0 0 0
24 1.50 0 0 0 0
32 2.00 0 0 0 0
40 2.50 0 0 0 0
48 3.00 0 0 0 0
56 3.50 0 0 0 0
64 4.00 0 0 0 0
72 4.50 0 0 0 0
80 5.00 0 0 0 0
88 5.50 0 0 0 0
96 6.00 0 0 0 0
104 6.50 0 0 0 0
112 7.00 0 0 0 0
120 7.50 0 0 0 0
128 8.00 0 0 0 0
136 8.50 0 0 0 0
144 9.00 0 0 0 0
152 9.50 0 0 0 0
160 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 19 0 2

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 0.06 494 0 3 15/15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
29-3ÔÂ 09:55 6 122 0 1 15 0/0 0/0/0/0/0/0
29-3ÔÂ 09:45 0 12 0 0 15 0/0 0/0/0/0/0/0
29-3ÔÂ 09:35 1 17 0 1 15 0/0 0/0/0/0/0/0
29-3ÔÂ 09:25 0 3 0 0 15 0/0 0/0/0/0/0/0
29-3ÔÂ 09:15 6 268 0 1 15 0/0 0/0/0/0/0/0
29-3ÔÂ 09:05 48 72 0 3 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AWR Alerted Metric Element list 16,949 0.00   0 0  
Consistent RBA 497 0.00   0 0  
FOB s.o list latch 81 0.00   0 0  
In memory undo latch 1,922 0.00   0 832 0.00
JS mem alloc latch 4 0.00   0 0  
JS queue access latch 4 0.00   0 0  
JS queue state obj latch 25,846 0.00   0 0  
JS slv state obj latch 18 0.00   0 0  
KMG MMAN ready and startup request latch 1,194 0.00   0 0  
KMG resize request state object freelist 6 0.00   0 0  
KTF sga latch 5 0.00   0 1,165 0.00
KWQMN job cache list latch 1 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 62 0.00   0 1,193 0.00
Memory Queue Message Subscriber #1 2 0.00   0 0  
Memory Queue Message Subscriber #2 2 0.00   0 0  
Memory Queue Message Subscriber #3 2 0.00   0 0  
Memory Queue Message Subscriber #4 2 0.00   0 0  
OS process 654 0.00   0 0  
OS process allocation 1,627 0.00   0 0  
OS process: request allocation 419 0.00   0 0  
PL/SQL warning settings 319 0.00   0 0  
SGA IO buffer pool latch 914 0.00   0 914 0.00
SQL memory manager latch 1 0.00   0 1,192 0.00
SQL memory manager workarea list latch 82,795 0.00   0 0  
STREAMS LCR 2 0.00   0 0  
STREAMS Pool Advisor 2 0.00   0 2 0.00
Shared B-Tree 132 0.00   0 0  
Streams Generic 2 0.00   0 0  
active checkpoint queue latch 1,231 0.00   0 0  
active service list 8,449 0.00   0 1,222 0.08
archive control 8 0.00   0 0  
begin backup scn array 21 0.00   0 0  
buffer pool 6 0.00   0 0  
cache buffer handles 519 0.00   0 0  
cache buffers chains 524,217 0.00 0.00 0 30,163 0.00
cache buffers lru chain 2,856 0.00   0 41,236 0.00
cache table scan latch 0     0 914 0.00
channel handle pool latch 419 0.00   0 0  
channel operations parent latch 17,363 0.00   0 0  
checkpoint queue latch 47,944 0.00   0 533 0.00
client/application info 1,045 0.00   0 0  
compile environment latch 3,728 0.00   0 0  
dml lock allocation 1,272 0.00   0 0  
dummy allocation 423 0.00   0 0  
enqueue hash chains 63,703 0.00   0 59 0.00
enqueues 64,028 0.00   0 0  
event group latch 209 0.00   0 0  
file cache latch 104 0.00   0 0  
global KZLD latch for mem in SGA 205 0.00   0 0  
hash table column usage latch 510 0.00   0 10,431 0.00
hash table modification latch 72 0.00   0 0  
image handles of buffered messages latch 2 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 61 0.00   0 0  
kks stats 2,639 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
ksuosstats global area 241 0.00   0 0  
ktm global data 11 0.00   0 0  
kwqbsgn:msghdr 12 0.00   0 0  
kwqbsn:qsga 129 0.00   0 2 0.00
kwqbsn:qxl 16 0.00   0 0  
lgwr LWN SCN 1,619 0.00   0 0  
library cache 105,078 0.02 0.00 0 2,134 0.00
library cache load lock 2,220 0.00   0 0  
library cache lock 28,334 0.00   0 0  
library cache lock allocation 822 0.00   0 0  
library cache pin 63,702 0.00 0.00 0 0  
library cache pin allocation 306 0.00   0 0  
list of block allocation 56 0.00   0 0  
loader state object freelist 126 0.00   0 0  
logminer context allocation 1 0.00   0 0  
messages 24,610 0.43 0.00 0 0  
mostly latch-free SCN 1,620 0.06 0.00 0 0  
multiblock read objects 1,896 0.00   0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 33 0.00   0 0  
object queue header operation 30,595 0.00   0 0  
object stats modification 10 0.00   0 0  
parallel query alloc buffer 432 0.00   0 0  
parameter table allocation management 220 0.00   0 0  
post/wait queue 88 0.00   0 55 0.00
process allocation 419 0.00   0 209 0.00
process group creation 419 0.00   0 0  
qmn task queue latch 889 0.00   0 0  
redo allocation 5,393 0.00   0 2,620 0.00
redo copy 0     0 2,620 0.00
redo writing 5,226 0.00   0 0  
resmgr group change latch 211 0.00   0 0  
resmgr:actses active list 420 0.00   0 0  
resmgr:actses change group 207 0.00   0 0  
resmgr:free threads list 419 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 96,368 0.00   0 587 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 710 0.00   0 0  
session allocation 80,969 0.00 0.00 0 0  
session idle bit 58,374 0.01 0.00 0 0  
session state list latch 434 0.00   0 0  
session switching 58 0.00   0 0  
session timer 1,223 0.00   0 0  
shared pool 58,762 0.00   0 0  
simulator hash latch 46,407 0.00   0 0  
simulator lru latch 43,903 0.03 0.00 0 908 0.00
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 87 0.00   0 0  
spilled messages latch 4 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 140 0.00   0 0  
threshold alerts latch 195 0.00   0 0  
transaction allocation 52 0.00   0 0  
transaction branch allocation 58 0.00   0 0  
undo global data 2,537 0.00   0 0  
user lock 824 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
ECC_FND USR_CCSS2 ECC_FND_DEPT   TABLE 27,936 9.93
USR_CCSS CCSS_MAIN FBP_ACCESSORIES   TABLE 26,080 9.27
ECC_SFM USR_CCSS2 QA_BIZ_DEAL_DETAIL   TABLE 23,392 8.32
USR_GBIS_EVM GLOBAL_BIS HRV_APPLY_HEADER   TABLE 16,928 6.02
ECC_SFM USR_CCSS2 FN_BAL_LWF_CONFIRM_DOC_DT   TABLE 12,832 4.56

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ECC_SFM USR_CCSS2 RECEIVE_GOODS_INFO   TABLE 10,599 75.80
ECC_SFM USR_CCSS2 FN_BAL_LWF_CONFIRM_DOC_DT   TABLE 1,062 7.60
ECC_SFM USR_CCSS2 QA_BIZ_DEAL_DETAIL   TABLE 669 4.78
ECC_SFM USR_CCSS2 FN_BAL_AWPB_DETAIL   TABLE 622 4.45
ECC_FND USR_CCSS2 PRODUCT_MODULE_PROP_INFO   TABLE 180 1.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
USR_GBIS_EVM GLOBAL_BIS PK_HRV_APPLY_HEADER   INDEX 5 50.00
USR_GBIS_EVM GLOBAL_BIS R_APP_LINE_FK   INDEX 5 50.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 62 0.00 0   2 1
dc_global_oids 77 1.30 0   0 257
dc_histogram_data 5,756 1.04 0   0 2,828
dc_histogram_defs 9,045 6.84 0   0 4,498
dc_object_ids 5,797 0.93 0   0 2,689
dc_objects 2,198 2.68 0   5 1,704
dc_profiles 209 0.00 0   0 1
dc_rollback_segments 616 0.00 0   0 22
dc_segments 2,439 2.42 0   1 2,609
dc_sequences 16 18.75 0   16 12
dc_tablespaces 3,706 0.00 0   0 10
dc_usernames 666 0.00 0   0 21
dc_users 6,236 0.00 0   0 57
outstanding_alerts 62 0.00 0   0 9


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 16 12.50 101 11.88 10 0
CLUSTER 21 0.00 48 4.17 2 0
INDEX 31 0.00 64 26.56 17 0
SQL AREA 647 36.63 25,981 5.05 691 0
TABLE/PROCEDURE 1,032 2.42 6,580 15.93 479 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 56.09   0.57 0.90 9 12 98 98
  SQL 0.75 0.32 0.01 0.02 0 61 91 14
  PL/SQL 0.28 0.06 0.00 0.01 0 0 96 96
E Other 56.04   0.58 0.90 9 12 97 97
  SQL 0.81 0.34 0.01 0.02 0 61 90 20
  PL/SQL 0.36 0.08 0.00 0.01 0 0 95 95

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1,400,897,536 1,409,286,144
Fixed Size 1,251,484  
Redo Buffers 7,135,232  
Variable Size 167,774,052 159,385,444

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 8.00 8.00 0.00
large PX msg pool 1.02 1.02 0.00
large free memory 6.98 6.98 0.00
shared ASH buffers 8.00 8.00 0.00
shared CCursor 3.70 3.30 -10.76
shared Heap0: KGL 1.26 1.11 -11.80
shared KCB Table Scan Buffer 4.00 4.00 0.00
shared KGLS heap 1.57 2.51 59.77
shared KQR M PO 4.82 4.42 -8.18
shared KQR M SO 1.23 1.25 1.47
shared KSFD SGA I/O b 4.00 4.00 0.00
shared KTI-UNDO 1.18 1.18 0.00
shared PCursor 2.27 2.10 -7.21
shared XDB Schema Cac 4.06 4.06 0.00
shared db_block_hash_buckets 4.26 4.26 0.00
shared event statistics per sess 1.48 1.48 0.00
shared free memory 13.81 9.96 -27.92
shared kglsim hash table bkts 2.00 2.00 0.00
shared kglsim heap 1.50 1.50 0.00
shared kglsim object batch 1.99 1.99 0.00
shared library cache 9.67 9.94 2.79
shared private strands   1.14  
shared row cache 3.57 3.57 0.00
shared sql area 13.75 8.91 -35.17
shared trace buffer 1.58 1.58 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 1,336.00 1,344.00 0.60
  fixed_sga 1.19 1.19 0.00
  log_buffer 6.80 6.80 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 13,998 0 0
QMON Slaves 10,581 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest E:\ORACLE\PRODUCT\10.2.0\ADMIN\SZORCL\ADUMP   
background_dump_dest E:\ORACLE\PRODUCT\10.2.0\ADMIN\SZORCL\BDUMP   
compatible 10.2.0.1.0   
control_files E:\ORACLE\ORADATA\SZORCL\CONTROL01.CTL, E:\ORACLE\ORADATA\SZORCL\CONTROL02.CTL, E:\ORACLE\ORADATA\SZORCL\CONTROL03.CTL   
core_dump_dest E:\ORACLE\PRODUCT\10.2.0\ADMIN\SZORCL\CDUMP   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name szorcl   
db_recovery_file_dest E:\oracle\product\10.2.0/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=szorclXDB)   
job_queue_processes 10   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 600   
pga_aggregate_target 1073741824   
processes 150   
remote_login_passwordfile EXCLUSIVE   
sga_max_size 1577058304   
sga_target 1577058304   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest E:\ORACLE\PRODUCT\10.2.0\ADMIN\SZORCL\UDUMP   


Back to Top

End of Report