WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
HJFXDB1975301032hjfxdb110.2.0.1.0NOhjfxdb2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2866304-May-14 00:01:0626 2.2
End Snap:2868705-May-14 00:00:3926 2.0
Elapsed:  1,439.55 (mins)  
DB Time:  765.50 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 13,136M 13,120MStd Block Size: 8K
Shared Pool Size: 512M 528MLog Buffer: 14,384K

Load Profile

Per SecondPer Transaction
Redo size: 410,085.04 25,049,663.57
Logical reads: 7,329.96 447,743.66
Block changes: 353.39 21,586.43
Physical reads: 1,888.48 115,355.99
Physical writes: 59.80 3,653.06
User calls: 1.25 76.61
Parses: 32.36 1,976.78
Hard parses: 0.05 2.81
Sorts: 16.25 992.39
Logons: 0.01 0.79
Executes: 35.48 2,167.15
Transactions: 0.02 

% Blocks changed per Read: 4.82Recursive Call %: 99.83
Rollback per transaction %: 0.71Rows per Sort: 84.99

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98Redo NoWait %: 100.00
Buffer Hit %: 74.27In-memory Sort %: 100.00
Library Hit %: 99.86Soft Parse %: 99.86
Execute to Parse %: 8.78Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 0.15% Non-Parse CPU: 99.89

Shared Pool Statistics

BeginEnd
Memory Usage %: 95.12#################
% SQL with executions>1: 90.32 90.22
% Memory for SQL w/exec>1: 79.41 85.14

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  21,528  46.9 
db file scattered read 10,180,072 6,369 1 13.9User I/O
db file sequential read 2,867,403 1,925 1 4.2User I/O
db file parallel write 34,936 1,885 54 4.1System I/O
log file parallel write 34,455 1,680 49 3.7System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 30,150.28 65.64
DB CPU 21,528.38 46.87
parse time elapsed 15,880.90 34.58
hard parse elapsed time 15,840.96 34.49
failed parse elapsed time 15,821.87 34.45
inbound PL/SQL rpc elapsed time 179.24 0.39
PL/SQL execution elapsed time 55.84 0.12
connection management call elapsed time 3.24 0.01
PL/SQL compilation elapsed time 2.92 0.01
hard parse (sharing criteria) elapsed time 1.08 0.00
hard parse (bind mismatch) elapsed time 0.10 0.00
RMAN cpu time (backup/restore) 0.10 0.00
sequence load elapsed time 0.07 0.00
repeated bind elapsed time 0.01 0.00
DB time 45,930.20  
background elapsed time 4,354.12  
background cpu time 216.81  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 13,279,431 0.00 8,764 1 9,391.39
System I/O 8,646,291 0.00 4,093 0 6,114.77
Network 5,390,072 0.00 1,111 0 3,811.93
Configuration 1,583 78.02 29 18 1.12
Commit 835 0.12 16 19 0.59
Other 5,127 0.18 10 2 3.63
Concurrency 1,010 0.00 8 8 0.71
Application 1,846 0.00 1 0 1.31

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file scattered read 10,180,072 0.00 6,369 1 7,199.49
db file sequential read 2,867,403 0.00 1,925 1 2,027.87
db file parallel write 34,936 0.00 1,885 54 24.71
log file parallel write 34,455 0.00 1,680 49 24.37
SQL*Net more data from dblink 4,371,154 0.00 1,109 0 3,091.34
read by other session 135,514 0.00 421 3 95.84
control file parallel write 36,578 0.00 352 10 25.87
Log archive I/O 41,623 0.00 100 2 29.44
control file sequential read 8,462,505 0.00 47 0 5,984.80
log file sequential read 35,274 0.00 25 1 24.95
direct path write temp 8,243 0.00 24 3 5.83
log file switch completion 231 0.43 17 72 0.16
log file sync 835 0.12 16 19 0.59
direct path read 49,189 0.00 15 0 34.79
log buffer space 113 0.00 8 69 0.08
os thread startup 153 0.00 8 50 0.11
direct path write 12,037 0.00 5 0 8.51
log file switch (checkpoint incomplete) 6 66.67 5 794 0.00
direct path read temp 26,870 0.00 5 0 19.00
recovery area: computing obsolete files 12 0.00 4 303 0.01
enq: CF - contention 21 0.00 3 150 0.01
control file single write 636 0.00 2 4 0.45
SQL*Net more data to client 31,277 0.00 2 0 22.12
rdbms ipc reply 1,736 0.00 2 1 1.23
log file single write 284 0.00 2 6 0.20
local write wait 102 0.00 1 9 0.07
enq: RO - fast object reuse 84 0.00 1 8 0.06
latch free 72 0.00 1 8 0.05
SQL*Net message to dblink 885,518 0.00 0 0 626.25
SGA: allocation forcing component growth 26 30.77 0 10 0.02
SQL*Net more data from client 590 0.00 0 0 0.42
SQL*Net break/reset to client 1,750 0.00 0 0 1.24
library cache pin 6 0.00 0 8 0.00
kksfbc child completion 1 100.00 0 49 0.00
db file parallel read 1 0.00 0 49 0.00
SQL*Net message to client 101,527 0.00 0 0 71.80
latch: cache buffers lru chain 89 0.00 0 0 0.06
LGWR wait for redo copy 3,031 0.00 0 0 2.14
latch: cache buffers chains 751 0.00 0 0 0.53
library cache load lock 2 0.00 0 9 0.00
latch: object queue header operation 18 0.00 0 1 0.01
recovery area: computing identical files 12 0.00 0 1 0.01
reliable message 66 0.00 0 0 0.05
latch: shared pool 12 0.00 0 1 0.01
buffer busy waits 56 0.00 0 0 0.04
latch: library cache 21 0.00 0 0 0.01
recovery area: computing dropped files 12 0.00 0 0 0.01
recovery area: computing backed up files 12 0.00 0 0 0.01
enq: TX - contention 1 0.00 0 2 0.00
latch: In memory undo latch 1 0.00 0 2 0.00
undo segment extension 1,230 100.00 0 0 0.87
SQL*Net break/reset to dblink 12 0.00 0 0 0.01
recovery area: computing applied logs 12 0.00 0 0 0.01
enq: SQ - contention 1 0.00 0 0 0.00
latch: enqueue hash chains 2 0.00 0 0 0.00
latch: checkpoint queue latch 3 0.00 0 0 0.00
SQL*Net more data to dblink 6 0.00 0 0 0.00
latch: library cache pin 2 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
latch: redo allocation 1 0.00 0 0 0.00
cursor: mutex S 6 0.00 0 0 0.00
virtual circuit status 2,879 100.00 84,064 29199 2.04
Streams AQ: qmn slave idle wait 3,083 0.00 83,969 27236 2.18
Streams AQ: qmn coordinator idle wait 6,184 50.15 83,969 13578 4.37
Streams AQ: waiting for time management or cleanup tasks 20 100.00 29,549 1477443 0.01
SQL*Net message from client 101,528 0.00 20,733 204 71.80
jobq slave wait 2,155 98.00 6,266 2908 1.52
SQL*Net message from dblink 885,518 0.00 1,269 1 626.25
class slave wait 46 100.00 225 4883 0.03
single-task message 24 0.00 1 51 0.02
SGA: MMAN sleep for component shrink 1 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file parallel write 34,936 0.00 1,885 54 24.71
log file parallel write 34,454 0.00 1,680 49 24.37
control file parallel write 35,098 0.00 331 9 24.82
Log archive I/O 41,623 0.00 100 2 29.44
log file sequential read 35,274 0.00 25 1 24.95
direct path read 49,182 0.00 15 0 34.78
os thread startup 153 0.00 8 50 0.11
direct path write 11,582 0.00 5 0 8.19
control file sequential read 53,878 0.00 5 0 38.10
events in waitclass Other 4,127 0.02 3 1 2.92
db file sequential read 4,339 0.00 3 1 3.07
log file single write 284 0.00 2 6 0.20
log file sync 1 0.00 0 4 0.00
buffer busy waits 16 0.00 0 0 0.01
latch: library cache 2 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
latch: cache buffers chains 4 0.00 0 0 0.00
rdbms ipc message 342,252 89.36 986,203 2882 242.05
pmon timer 28,948 100.00 84,312 2913 20.47
Streams AQ: qmn slave idle wait 3,083 0.00 83,969 27236 2.18
Streams AQ: qmn coordinator idle wait 6,184 50.15 83,969 13578 4.37
smon timer 446 55.83 81,411 182536 0.32
Streams AQ: waiting for time management or cleanup tasks 20 100.00 29,549 1477443 0.01
SGA: MMAN sleep for component shrink 1 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 200,832
AVG_IDLE_TIME 8,444,022
AVG_IOWAIT_TIME 107,655
AVG_SYS_TIME 66,581
AVG_USER_TIME 132,469
BUSY_TIME 2,443,132
IDLE_TIME 101,360,172
IOWAIT_TIME 1,324,545
SYS_TIME 830,138
USER_TIME 1,612,994
LOAD 0
OS_CPU_WAIT_TIME 3,495,700
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 48,049,946,624
NUM_CPUS 12
NUM_CPU_CORES 6

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
hjfxdb 26,306.90 9,629.90 116,538,715 140,056,657
SYS$USERS 19,623.30 11,898.50 46,509,664 491,314,140
SYS$BACKGROUND 0.00 0.00 64,991 1,738,701
hjfxdbXDB 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
hjfxdb 7297277 256017 11 1 0 0 42450 26
SYS$USERS 5901493 615153 796 10 0 0 5345397 111089
SYS$BACKGROUND 80661 5195 203 772 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
4,019 3,847 1 4019.21 8.75 4ypduwnc0mxf5 PL/SQL Developer BEGIN FOR DT in '20140401'...
3,959 3,726 1 3959.49 8.62 b558cx1vmxmvx PL/SQL Developer BEGIN FOR DT in '20140301'...
3,821 1,025 1 3820.79 8.32 agphydy3rn3hv SQL*Plus declare iv_date varchar2...
3,619 3,263 1 3618.90 7.88 2ntjnuny7mhaq   DECLARE job BINARY_INTEGER := ...
1,787 314 48 37.22 3.89 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
1,260 1,028 1 1259.54 2.74 3gj2yj98kxgkq PL/SQL Developer BEGIN FOR DT in '20140401'...
1,207 364 1 1207.16 2.63 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
1,201 993 1 1201.09 2.62 5s8vw7pt8kkw1 PL/SQL Developer BEGIN FOR DT in '20140301'...
1,145 1,025 1 1144.90 2.49 awrvqu5440b2p SQL*Plus declare iv_date varchar2...
1,088 250 1 1088.09 2.37 31cnjn0d3v271 SQL*Plus INSERT /*+APPEND */ INTO DM...
993 508 1 992.94 2.16 8k8y9zb4tkcb7 SQL*Plus DECLARE oi_return INTEGER; BEG...
993 508 1 992.50 2.16 ckd14gx0cvb4w SQL*Plus INSERT INTO DWD_BILL_GSM_CAL...
933 852 40,109 0.02 2.03 avak6hzypnxv3   SELECT COUNT(T.CITY_ID) FROM D...
928 848 40,109 0.02 2.02 fmhc91f39a2h9   SELECT COUNT(T.CITY_ID) FROM D...
888 720 1 887.80 1.93 3056bxn0sby0v SQL*Plus declare o_return integer; begi...
845 773 36,559 0.02 1.84 a6autkuhq56mz   SELECT T.CITY_ID FROM DIM_NUMB...
755 614 1 755.21 1.64 dcxh6p276kt1z SQL*Plus Insert Into DW_ORDER_TICKET_NU...
673 672 1 673.18 1.47 fk009t2ad33ag   INSERT /*+APPEND */ INTO DW_CO...
668 137 1 667.97 1.45 b82hd1sty3c3j SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
651 331 1 651.34 1.42 f7hysjfzsj6d2   DECLARE job BINARY_INTEGER := ...
571 152 24 23.81 1.24 d65ypzjzr3y68   INSERT INTO GR_ODS.MONITOR_DB_...
517 517 1 517.43 1.13 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
498 131 1 497.62 1.08 2xqxfd30szq23 SQL*Plus INSERT /*+APPEND */ INTO ...
495 127 22 22.52 1.08 5k76jf9k4kd0v   DECLARE job BINARY_INTEGER := ...

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
3,847 4,019 1 3847.28 8.75 4ypduwnc0mxf5 PL/SQL Developer BEGIN FOR DT in '20140401'...
3,726 3,959 1 3726.31 8.62 b558cx1vmxmvx PL/SQL Developer BEGIN FOR DT in '20140301'...
3,263 3,619 1 3263.29 7.88 2ntjnuny7mhaq   DECLARE job BINARY_INTEGER := ...
1,028 1,260 1 1027.86 2.74 3gj2yj98kxgkq PL/SQL Developer BEGIN FOR DT in '20140401'...
1,025 3,821 1 1025.49 8.32 agphydy3rn3hv SQL*Plus declare iv_date varchar2...
1,025 1,145 1 1025.49 2.49 awrvqu5440b2p SQL*Plus declare iv_date varchar2...
993 1,201 1 992.87 2.62 5s8vw7pt8kkw1 PL/SQL Developer BEGIN FOR DT in '20140301'...
852 933 40,109 0.02 2.03 avak6hzypnxv3   SELECT COUNT(T.CITY_ID) FROM D...
848 928 40,109 0.02 2.02 fmhc91f39a2h9   SELECT COUNT(T.CITY_ID) FROM D...
773 845 36,559 0.02 1.84 a6autkuhq56mz   SELECT T.CITY_ID FROM DIM_NUMB...
720 888 1 720.17 1.93 3056bxn0sby0v SQL*Plus declare o_return integer; begi...
672 673 1 672.27 1.47 fk009t2ad33ag   INSERT /*+APPEND */ INTO DW_CO...
614 755 1 614.17 1.64 dcxh6p276kt1z SQL*Plus Insert Into DW_ORDER_TICKET_NU...
517 517 1 517.41 1.13 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
508 993 1 507.73 2.16 8k8y9zb4tkcb7 SQL*Plus DECLARE oi_return INTEGER; BEG...
508 993 1 507.67 2.16 ckd14gx0cvb4w SQL*Plus INSERT INTO DWD_BILL_GSM_CAL...
364 1,207 1 364.19 2.63 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
331 651 1 331.32 1.42 f7hysjfzsj6d2   DECLARE job BINARY_INTEGER := ...
314 1,787 48 6.53 3.89 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
250 1,088 1 250.42 2.37 31cnjn0d3v271 SQL*Plus INSERT /*+APPEND */ INTO DM...
152 571 24 6.35 1.24 d65ypzjzr3y68   INSERT INTO GR_ODS.MONITOR_DB_...
137 668 1 137.05 1.45 b82hd1sty3c3j SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
131 498 1 130.70 1.08 2xqxfd30szq23 SQL*Plus INSERT /*+APPEND */ INTO ...
127 495 22 5.76 1.08 5k76jf9k4kd0v   DECLARE job BINARY_INTEGER := ...

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
307,839,325 1 307,839,325.00 48.62 720.17 887.80 3056bxn0sby0v SQL*Plus declare o_return integer; begi...
263,118,748 1 263,118,748.00 41.56 614.17 755.21 dcxh6p276kt1z SQL*Plus Insert Into DW_ORDER_TICKET_NU...
67,191,848 1 67,191,848.00 10.61 3263.29 3618.90 2ntjnuny7mhaq   DECLARE job BINARY_INTEGER := ...
44,716,906 1 44,716,906.00 7.06 105.95 132.26 3v7dv2zqhgck3 SQL*Plus Insert Into DW_ORDER_TICKET_NU...
40,861,296 1 40,861,296.00 6.45 3847.28 4019.21 4ypduwnc0mxf5 PL/SQL Developer BEGIN FOR DT in '20140401'...
39,466,214 1 39,466,214.00 6.23 3726.31 3959.49 b558cx1vmxmvx PL/SQL Developer BEGIN FOR DT in '20140301'...
29,951,080 1 29,951,080.00 4.73 1027.86 1259.54 3gj2yj98kxgkq PL/SQL Developer BEGIN FOR DT in '20140401'...
28,948,843 1 28,948,843.00 4.57 992.87 1201.09 5s8vw7pt8kkw1 PL/SQL Developer BEGIN FOR DT in '20140301'...
27,787,399 1 27,787,399.00 4.39 1025.49 1144.90 awrvqu5440b2p SQL*Plus declare iv_date varchar2...
21,746,305 1 21,746,305.00 3.43 1025.49 3820.79 agphydy3rn3hv SQL*Plus declare iv_date varchar2...
18,891,339 40,109 471.00 2.98 851.54 932.97 avak6hzypnxv3   SELECT COUNT(T.CITY_ID) FROM D...
18,891,339 40,109 471.00 2.98 848.25 928.13 fmhc91f39a2h9   SELECT COUNT(T.CITY_ID) FROM D...
17,219,289 36,559 471.00 2.72 772.97 845.46 a6autkuhq56mz   SELECT T.CITY_ID FROM DIM_NUMB...
16,545,411 1 16,545,411.00 2.61 331.32 651.34 f7hysjfzsj6d2   DECLARE job BINARY_INTEGER := ...
13,623,122 1 13,623,122.00 2.15 672.27 673.18 fk009t2ad33ag   INSERT /*+APPEND */ INTO DW_CO...
13,103,162 1 13,103,162.00 2.07 517.41 517.43 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
11,912,909 1 11,912,909.00 1.88 507.73 992.94 8k8y9zb4tkcb7 SQL*Plus DECLARE oi_return INTEGER; BEG...
11,909,202 1 11,909,202.00 1.88 507.67 992.50 ckd14gx0cvb4w SQL*Plus INSERT INTO DWD_BILL_GSM_CAL...
10,884,967 2,721,368 4.00 1.72 75.55 75.81 2ym6hhaq30r73   select type#, blocks, extents,...
10,852,592 19,804 548.00 1.71 402.60 429.61 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
10,828,480 19,760 548.00 1.71 401.91 428.49 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
9,607,045 48 200,146.77 1.52 313.63 1786.64 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
9,071,096 1 9,071,096.00 1.43 450.17 450.18 7sxzqmz8r8c8z   INSERT /*+APPEND */ INTO DW_CO...
8,647,928 1 8,647,928.00 1.37 148.23 164.51 dgrrz06m4cffa   INSERT INTO MID_DW_INCR_QBAR N...
8,640,951 1 8,640,951.00 1.36 364.19 1207.16 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
7,869,624 1 7,869,624.00 1.24 324.70 324.84 7k4vyptuvcsx2 SQL*Plus INSERT INTO MID_DW_YYGH_USER_R...
6,889,021 1 6,889,021.00 1.09 329.55 329.55 fvb1u4vsc2b2d   INSERT /*+APPEND */ INTO DW_CO...

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
29,698,210 1 29,698,210.00 18.21 3847.28 4019.21 4ypduwnc0mxf5 PL/SQL Developer BEGIN FOR DT in '20140401'...
29,628,240 1 29,628,240.00 18.16 1027.86 1259.54 3gj2yj98kxgkq PL/SQL Developer BEGIN FOR DT in '20140401'...
28,553,497 1 28,553,497.00 17.51 992.87 1201.09 5s8vw7pt8kkw1 PL/SQL Developer BEGIN FOR DT in '20140301'...
28,553,420 1 28,553,420.00 17.51 3726.31 3959.49 b558cx1vmxmvx PL/SQL Developer BEGIN FOR DT in '20140301'...
21,301,001 1 21,301,001.00 13.06 1025.49 3820.79 agphydy3rn3hv SQL*Plus declare iv_date varchar2...
15,670,496 1 15,670,496.00 9.61 331.32 651.34 f7hysjfzsj6d2   DECLARE job BINARY_INTEGER := ...
8,621,858 1 8,621,858.00 5.29 364.19 1207.16 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
8,549,367 1 8,549,367.00 5.24 148.23 164.51 dgrrz06m4cffa   INSERT INTO MID_DW_INCR_QBAR N...
5,207,774 1 5,207,774.00 3.19 250.42 1088.09 31cnjn0d3v271 SQL*Plus INSERT /*+APPEND */ INTO DM...
2,631,112 1 2,631,112.00 1.61 137.05 667.97 b82hd1sty3c3j SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
2,545,712 1 2,545,712.00 1.56 65.42 167.49 0wwb4fjcx9q4x   INSERT INTO DM_INCR_QBAR_USER_...
2,545,562 1 2,545,562.00 1.56 65.13 167.26 2bsrhgwksjk6g   DELETE DW_INCR_QBAR_USE_D T WH...
2,514,523 1 2,514,523.00 1.54 130.70 497.62 2xqxfd30szq23 SQL*Plus INSERT /*+APPEND */ INTO ...
1,903,822 1 1,903,822.00 1.17 252.55 263.40 br1xgsckydkga PL/SQL Developer INSERT INTO TMP_LICAL_USER_CAL...
1,833,782 1 1,833,782.00 1.12 64.58 74.93 1prgqu7r7nttb PL/SQL Developer INSERT INTO TMP_LICAI_CALL ...
1,818,603 1 1,818,603.00 1.11 3263.29 3618.90 2ntjnuny7mhaq   DECLARE job BINARY_INTEGER := ...
1,729,518 1 1,729,518.00 1.06 42.45 60.32 fjdpxdf5bn9zg   INSERT INTO DW_INCR_QBAR_USE_D...
1,701,509 48 35,448.10 1.04 313.63 1786.64 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
1,663,842 1 1,663,842.00 1.02 1025.49 1144.90 awrvqu5440b2p SQL*Plus declare iv_date varchar2...

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
2,721,368 2,721,166 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
40,109 40,109 1.00 0.02 0.02 avak6hzypnxv3   SELECT COUNT(T.CITY_ID) FROM D...
40,109 40,109 1.00 0.02 0.02 fmhc91f39a2h9   SELECT COUNT(T.CITY_ID) FROM D...
36,559 36,559 1.00 0.02 0.02 a6autkuhq56mz   SELECT T.CITY_ID FROM DIM_NUMB...
19,804 19,804 1.00 0.02 0.02 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
19,760 19,760 1.00 0.02 0.02 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
8,618 25 0.00 0.00 0.00 803b7z0t84sq7   select job, nvl2(last_date, ...
8,183 8,183 1.00 0.02 0.02 86773aqr8874p   SELECT T.CITY_ID FROM DIM_NUMB...
6,250 6,250 1.00 0.00 0.00 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
5,983 282,103 47.15 0.00 0.00 bsa0wjtftg3uw   select file# from file$ where ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,721,371 2,721,368 97.36 2ym6hhaq30r73   select type#, blocks, extents,...
6,250 6,250 0.22 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
5,983 5,983 0.21 bsa0wjtftg3uw   select file# from file$ where ...
4,401 4,401 0.16 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
4,118 4,118 0.15 0h6b2sajwb74n   select privilege#, level from ...
2,481 2,481 0.09 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
2,481 2,481 0.09 g00cj285jmgsw   update sys.mon_mods$ set inser...
1,960 1,960 0.07 aq4js2gkfjru8   update tsq$ set blocks=:3, max...
1,359 3,086 0.05 3c1kubcdjnppq   update sys.col_usage$ set eq...
1,350 23 0.05 53btfq0dt9bs9   insert into sys.col_usage$ val...

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

Version Count Executions SQL IdSQL ModuleSQL Text
419 181 afy6x9s4h317u SQL*Plus INSERT INTO TB_114_SYS_LOG ( T...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0wwb4fjcx9q4xINSERT INTO DM_INCR_QBAR_USER_D NOLOGGING (STATICE_MONTH, STATICE_DATE, CARRIER_CITY, CARRIER_TYPE, NUMBER_TYPE, SP_ID, USER_TYPE, SERVICE_NO_ID, CALL_TYPE, CALL_CNT, CALL_DUR, CHARGE_USER_CNT, NEW_USER_CNT, SILENCT_USER_CNT, ARRIVE_USER_CNT, PENE_RATE, INSERT_DATE) SELECT T.STATICE_MONTH STATICE_MONTH, T.STATICE_DATE STATICE_DATE, CASE WHEN T.CARRIER_CITY IN ('010', '2001') THEN '1' WHEN T.CARRIER_CITY NOT IN ('010', '2001', '-1') THEN '2' WHEN T.CARRIER_CITY = '-1' THEN '-1' END CARRIER_CITY, T.CARRIER_TYPE CARRIER_TYPE, T.CALLING_NO_TYPE NUMBER_TYPE, T.SP_ID SP_ID, CASE WHEN T.USER_TYPE = '01' THEN '01' WHEN T.USER_TYPE = '02' THEN '02' ELSE '03' END AS USER_TYPE, NVL(D.QBAR_NO_ID, '-1') SERVICE_NO_ID, T.CALL_TYPE CALL_TYPE, COUNT(*) CALL_CNT, ROUND(SUM(T.CALL_DUR) / 60) CALL_DUR, '' CHARGE_USER_CNT, '' NEW_USER_CNT, '' SILENCT_USER_CNT, '' ARRIVE_USER_CNT, '' PENE_RATE, SYSDATE INSERT_DATE FROM DW_INCR_QBAR_USE_D T, GR_DIM.DIM_INCR_QBAR_NO D WHERE SUBSTR(T.CALLED_NO, 1, 8) = D.QBAR_NO_DESC(+) AND T.STATICE_DATE = :B1 GROUP BY T.STATICE_MONTH, T.STATICE_DATE, T.CARRIER_CITY, T.CARRIER_TYPE, T.CALLING_NO_TYPE, T.SP_ID, T.USER_TYPE, NVL(D.QBAR_NO_ID, '-1'), T.CALL_TYPE
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1prgqu7r7nttbINSERT INTO TMP_LICAI_CALL SELECT T1.MSISDN, T1.B_MSISDN, T1.START_DATE, T1.START_TIME, T1.END_DATE, T1.END_TIME, TO_CHAR(TO_DATE(START_DATE, 'YYYYMMDD'), 'DAY'), ROUND((to_date(t1.end_date||t1.end_time, 'yyyy-mm-dd hh24:mi:ss') - to_date(t1.start_date||t1.start_time, 'yyyy-mm-dd hh24:mi:ss'))*1440) CALL_LEN FROM DWD_BILL_GSM_CALL_201404 T1, TMP_LICAI_TEL T2 WHERE T1.B_MSISDN = T2.TEL AND T1.CALL_TYPE = '01' AND STATICE_DATE = '20140402'
2bsrhgwksjk6gDELETE DW_INCR_QBAR_USE_D T WHERE T.STATICE_DATE =:B1
2ntjnuny7mhaqDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN declare OI_RETURN integer; begin SP_114_ORDER_COMPETE_ALL(to_char(to_date(to_char(sysdate, 'yyyymmdd'), 'yyyymmdd')-1, 'yyyymmdd'), oi_return); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2xqxfd30szq23 INSERT /*+APPEND */ INTO DW_CUSTBEF_ACTIVE_USER_Y2014 NOLOGGING SELECT '201405', '03', '20140503', substr(A.CALLING_NO, 1, 20), B.CITY_ID, B.CARRIER_TYPE, B.DISTRICT_ID, B.CUST_TYPE, B.CUST_LEVEL, B.NUMBER_TYPE, B.FLAG_NEW, B.FLAG_114, B.FLAG_116114, B.FLAG_OTHER, NULL, NULL, NULL, NULL, B.CALL_114_CNT, B.CALL_116_CNT, B.CALL_OTH_CNT, B.CALL_114_TIME, B.CALL_116_TIME, B.CALL_OTH_TIME, NULL, NULL, NULL, NULL, SYSDATE FROM MID_ACTIVE_USER_Y A, DW_CUSTBEF_ACTIVE_USER_D B WHERE A.CALLING_NO=B.CALLING_NO(+) AND B.STATICE_TIME=20140503
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3056bxn0sby0vdeclare o_return integer; begin calnav.SP_ORDER_TICKET_NUM_D('20140503', o_return); end;
31cnjn0d3v271 INSERT /*+APPEND */ INTO DM_CUST_BEFORE_VOLUME_USER_D NOLOGGING SELECT 20140503, CARRIER_TYPE, CITY_ID, DISTRICT_ID, CUST_LEVEL, CUST_TYPE, NUMBER_TYPE, CALLED_NO, 0, SUM(NEW_USERS), SUM(ACTICE_USERS), 0, 0, SUM(LJ_ACTIVE_USERS), SUM(LJ_ACTIVE_USERS_Y), SYSDATE FROM (SELECT T.CARRIER_TYPE, T.CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END) CALLED_NO, SUM(CASE WHEN T.FLAG_NEW='1' THEN 1 ELSE 0 END) NEW_USERS, COUNT(T.CALLING_NO) ACTICE_USERS, 0 LJ_ACTIVE_USERS, 0 LJ_ACTIVE_USERS_Y FROM DW_CUSTBEF_ACTIVE_USER_D T WHERE T.STATICE_TIME=20140503 GROUP BY T.CARRIER_TYPE, T.CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END) UNION ALL ---------------------------ÔÂÀۼƻîÔ¾Óû§ SELECT T.CARRIER_TYPE, T.CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END), 0, 0, COUNT(T.CALLING_NO), 0 FROM DW_CUSTBEF_ACTIVE_USER_M T WHERE T.STATICE_MONTH=201405 AND STATICE_DAY<=03 GROUP BY T.CARRIER_TYPE, T. CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END) UNION ALL ---------------------------ÄêÀۼƻîÔ¾Óû§ SELECT T.CARRIER_TYPE, T.CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END), 0, 0, 0, COUNT(T.CALLING_NO) FROM DW_CUSTBEF_ACTIVE_USER_Y2014 T WHERE T.STATICE_TIME<=20140503 GROUP BY T.CARRIER_TYPE, T.CITY_ID, T.DISTRICT_ID, T.CUST_LEVEL, T.CUST_TYPE, T.NUMBER_TYPE, (CASE WHEN T.FLAG_114='1' THEN '1' WHEN T.FLAG_116114='1' THEN '2' WHEN T.FLAG_OTHER='1' THEN '3' END) ) GROUP BY CARRIER_TYPE, CITY_ID, DISTRICT_ID, CUST_LEVEL, CUST_TYPE, NUMBER_TYPE, CALLED_NO
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
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
3gj2yj98kxgkqBEGIN FOR DT in '20140401' .. '20140430' LOOP EXECUTE IMMEDIATE 'INSERT INTO TMP_LICAI_CALL SELECT T1.MSISDN, T1.B_MSISDN, T1.START_DATE, T1.START_TIME, T1.END_DATE, T1.END_TIME, TO_CHAR(TO_DATE(START_DATE, ''YYYYMMDD''), ''DAY''), ROUND((to_date(t1.end_date||t1.end_time, ''yyyy-mm-dd hh24:mi:ss'') - to_date(t1.start_date||t1.start_time, ''yyyy-mm-dd hh24:mi:ss''))*1440) CALL_LEN FROM DWD_BILL_GSM_CALL_201404 T1, TMP_LICAI_TEL T2 WHERE T1.B_MSISDN = T2.TEL AND T1.CALL_TYPE = ''01'' AND STATICE_DATE = '''||DT||''''; COMMIT; END LOOP; END;
3v7dv2zqhgck3Insert Into DW_ORDER_TICKET_NUM_D ( statice_time, ----Êý¾ÝÈÕÆÚ calling_num, ----Ö÷½ÐºÅÂë called_num, ----±»½ÐºÅÂë num_type ----ºÅÂëÀàÐÍ£¨1-¹Ì»°£¬2-ÊÖ»ú£© ) SELECT T.END_DATE, substr(T.MSISDN, 4) calling_no, T.B_MSISDN, '1' NUM_TYPE FROM HJFX.TI_BIL_PSTN_CALL_20140503@HJFXDB78 T, DIM_ORDER_TICKET_TELNUM A WHERE (T.B_MSISDN = A.TEL_NUM1 OR T.B_MSISDN = A.TEL_NUM2) AND SUBSTR(T.MSISDN, 1, 4) IN ('0106', '0108') AND T.END_DATE = '20140503' AND LENGTH(T.MSISDN) = 11
4ypduwnc0mxf5BEGIN FOR DT in '20140401' .. '20140430' LOOP EXECUTE IMMEDIATE 'INSERT INTO TMP_LICAL_USER_CALL_LEN SELECT T1.MSISDN, ROUND((to_date(t1.end_date||t1.end_time, ''yyyy-mm-dd hh24:mi:ss'') - to_date(t1.start_date||t1.start_time, ''yyyy-mm-dd hh24:mi:ss''))*1440) CALL_LEN, ''Mar'' FROM DWD_BILL_GSM_CALL_201404 T1, TMP_LICAI_USER T2 WHERE T1.MSISDN = T2.CALLER AND STATICE_DATE = '''||DT||''''; COMMIT; END LOOP; END;
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)
5k76jf9k4kd0vDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sp_monitor_db_tablespace(to_char(sysdate, 'yyyymmdd')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5s8vw7pt8kkw1BEGIN FOR DT in '20140301' .. '20140331' LOOP EXECUTE IMMEDIATE 'INSERT INTO TMP_LICAI_CALL SELECT T1.MSISDN, T1.B_MSISDN, T1.START_DATE, T1.START_TIME, T1.END_DATE, T1.END_TIME, TO_CHAR(TO_DATE(START_DATE, ''YYYYMMDD''), ''DAY''), ROUND((to_date(t1.end_date||t1.end_time, ''yyyy-mm-dd hh24:mi:ss'') - to_date(t1.start_date||t1.start_time, ''yyyy-mm-dd hh24:mi:ss''))*1440) CALL_LEN FROM DWD_BILL_GSM_CALL_201403 T1, TMP_LICAI_TEL T2 WHERE T1.B_MSISDN = T2.TEL AND T1.CALL_TYPE = ''01'' AND STATICE_DATE = '''||DT||''''; COMMIT; END LOOP; END;
6gwmxvc9g5yvzINSERT /*+APPEND */ INTO DW_CALL_VOLUME_DAILY NOLOGGING (STATICE_TIME, CALLID, CALLING_NO, CALLED_NO, SUBCCNO, TIME_POINT, TIME_PART, WAIT_TIME, CALL_TIME, REMARK1, REMARK2, REMARK3, REMARK4, REMARK5, INSERT_DATE ) SELECT :B1 , A.CALLID, A.CALLING_NO, A.CALLED_NO, A.SUBCCNO, A.TIME_POINT, B.TIME_PART, SUM(A.WAIT_TIME), SUM(A.CALL_TIME), NULL, NULL, NULL, NULL, NULL, SYSDATE FROM (SELECT T.CALLID, T.CALLING_NO, T.CALLED_NO, T.SUBCCNO, MAX(T.TIME_POINT) TIME_POINT, SUM(T.WAIT_TIME) WAIT_TIME, SUM(T.CALL_TIME) CALL_TIME FROM DW_CALL_VOLUME_ALL_DAILY T WHERE STATICE_TIME=:B1 GROUP BY T.CALLID, T.CALLING_NO, T.CALLED_NO, T.SUBCCNO ) A, DIM_TIME_PART B WHERE A.TIME_POINT>=B.FLOOR AND A.TIME_POINT<B.CEIL GROUP BY :B1 , A.CALLID, A.CALLING_NO, A.CALLED_NO, A.SUBCCNO, B.TIME_PART, A.TIME_POINT
7k4vyptuvcsx2INSERT INTO MID_DW_YYGH_USER_REGISTER ( STATICE_MONTH , STATICE_TIME , REGISTER_TIME , PATIENT_NAME , SEX , PATIENT_AGE , CRED_ID , CRED_DESC , PATIENT_ID , PATIENT_NUM , LIVE_CITY_ID , LIVE_CITY , CARRIER_TYPE , CITY_ID , NUMBER_TYPE , REGISTER_WAY , REGISTER_WAY_ID ) SELECT T.STATICE_MONTH, T.STATICE_TIME, TO_CHAR(T.REGISTER_TIME, 'YYYYMMDD'), T.PATIENT_NAME, T.SEX, CASE WHEN T.CRED_DESC='Éí·ÝÖ¤' AND T.PATIENT_ID LIKE '%X%X%' THEN -1 WHEN T.CRED_DESC='Éí·ÝÖ¤' AND LENGTH(T.PATIENT_ID)=18 THEN TO_CHAR(SYSDATE, 'YYYY')-SUBSTR(T.PATIENT_ID, 7, 4) WHEN T.CRED_DESC='Éí·ÝÖ¤' AND LENGTH(T.PATIENT_ID)=15 THEN TO_CHAR(SYSDATE, 'YYYY')-TO_NUMBER('19'||SUBSTR(T.PATIENT_ID, 7, 2)) ELSE -1 END AS PATIENT_AGE, T.CRED_ID, T.CRED_DESC, T.PATIENT_ID, T.PATIENT_NUM, NVL(A.AREA_ID, '-1') AS LIVE_CITY_ID, T.LIVE_CITY, FUN_114_CARRIER_TYPE(T.PATIENT_NUM) AS CARRIER_TYPE, FUN_114_NUMBER_CITY_NEW(T.PATIENT_NUM) AS CITY_ID, FUN_114_NUMBER_TYPE_NEW(T.PATIENT_NUM) AS NUMBER_TYPE, REGISTER_WAY, CASE WHEN T.REGISTER_WAY ='01' THEN '01' WHEN T.REGISTER_WAY ='02' THEN '02' ELSE '-1' END AS REGISTER_WAY_ID FROM MID_ODS_YYGH_USER_REGISTER T, DIM_YYGH_LIVE_CITY A WHERE T.LIVE_CITY = A.AREA_NAME(+) AND NOT EXISTS(SELECT 1 FROM DW_YYGH_USER_REGISTER B WHERE B.PATIENT_ID=T.PATIENT_ID)
7sxzqmz8r8c8z INSERT /*+APPEND */ INTO DW_COMPETE_CAR_D NOLOGGING (STATICE_TIME, CALLING_NO, SERVICE_NO, NUMBER_TYPE, CARRIER_TYPE, CITY_ID, COMPETE_ID, CALL_CNT, USER_CNT, INSERT_DATE) SELECT STATICE_DATE, T3.CALLING_NO, T3.CALLED_NO, CASE WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T3.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END NUMBER_TYPE, CASE WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END CARRIER_TYPE, DECODE(FUN_114_NUMBER_CITY(T3.CALLING_N O), '2001', '01', '-1', '-1', '02'), T5.TYPE_ID COMPETE_ID, SUM(T3.CALL_CNT) CALL_CNT, COUNT(DISTINCT T3.CALLING_NO) USER_CNT, SYSDATE INSERT_DATE FROM MID_PSTN_DETAIL T3, (SELECT T.PHONE_NUM PHONE_NUM, T.TYPE_ID TYPE_ID FROM DIM_COMPETE T WHERE T.TYPE_ID='04' UNION SELECT T.PHONE_NUM2 PHONE_NUM, T.TYPE_ID TYPE_ID FROM DIM_COMPETE T WHERE T.TYPE_ID='04') T5 WHERE T3.CALLED_NO=T5.PHONE_NUM GROUP BY STATICE_DATE, T3.CALLING_NO, T3.CALLED_NO, CASE WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T3.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END , CASE WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLI NG_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END , DECODE(FUN_114_NUMBER_CITY(T3.CALLING_NO), '2001', '01', '-1', '-1', '02'), T5.TYPE_ID, SYSDATE
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
86773aqr8874pSELECT T.CITY_ID FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND TO_NUMBER(T.START_ID) <= TO_NUMBER(SUBSTR(:B1 , 5, 4)) AND TO_NUMBER(T.END_ID) >= TO_NUMBER(SUBSTR(:B1 , 5, 4))
8k8y9zb4tkcb7DECLARE oi_return INTEGER; BEGIN SP_DWD_BILL_GSM_CALL('20140503', oi_return); END;
8mxcwt4vvs1dbSELECT T.CITY_ID FROM DIM_NUM_FOR_CITY T WHERE T.START_ID <= SUBSTR(:B1 , 1, 8) AND T.END_ID >= SUBSTR(:B1 , 1, 8) AND T.SEGMENT_ID=SUBSTR(:B1 , 1, 4)
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
a6autkuhq56mzSELECT T.CITY_ID FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND TO_NUMBER(T.START_ID) <= TO_NUMBER(SUBSTR(:B1 , 5, 3)) AND TO_NUMBER(T.END_ID) >= TO_NUMBER(SUBSTR(:B1 , 5, 3))
afy6x9s4h317uINSERT INTO TB_114_SYS_LOG ( TASK_ID, TASK_NAME, TABLE_NAME, TASK_SIGN, START_TIME, END_TIME, TASK_STATUS, TASK_LOG, TASK_POS, ROW_COUNT ) VALUES ( :B4 , UPPER(:B3 ), UPPER(:B2 ), :B1 , SYSDATE, NULL, 1, '³ÌÐòÔËÐÐÖÐ', NULL, NULL )
agphydy3rn3hvdeclare iv_date varchar2(200); io_return varchar2(200); begin iv_date :=20140503; SP_114_CUST_BEFORE_RUN(iv_date, io_return); commit; end;
aq4js2gkfjru8update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2
avak6hzypnxv3SELECT COUNT(T.CITY_ID) FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND TO_NUMBER(T.START_ID) <= TO_NUMBER(SUBSTR(:B1 , 5, 4)) AND TO_NUMBER(T.END_ID) >= TO_NUMBER(SUBSTR(:B1 , 5, 4))
awrvqu5440b2pdeclare iv_date varchar2(200); oi_return varchar2(200); begin iv_date :=20140503; sp_ods_yygh_user_register(iv_date, oi_return); sp_ods_yygh_order_success(iv_date, oi_return); sp_ods_yygh_order_fail(iv_date, oi_return); sp_ods_yygh_number_source(iv_date, oi_return); sp_ods_yygh_hos_all_info(iv_date, oi_return); sp_ods_yygh_opr_call_d(iv_date, oi_return); sp_ods_yygh_opr_log_d(iv_date, oi_return); sp_ods_yygh_data_check(iv_date, oi_return); sp_dw_yygh_user_register(iv_date, oi_return); sp_dw_yygh_order_success(iv_date, oi_return); sp_dw_yygh_114_opr_call(iv_date, oi_return); sp_dw_yygh_order_fail(iv_date, oi_return); sp_dm_yygh_user_register(iv_date, oi_return); sp_dm_yygh_order_success(iv_date, oi_return); sp_dm_yygh_order_fail(iv_date, oi_return); sp_dw_yygh_number_source(iv_date, oi_return); sp_dm_yygh_number_source(iv_date, oi_return); sp_dw_yygh_114_call_contion(iv_date, oi_return); sp_dm_yygh_114_call_contion(iv_date, oi_return); sp_dw_yygh_114_call_detail(iv_date, oi_return); sp_dm_yygh_114_call_detail(iv_date, oi_return); sp_dm_yygh_114_opr_call(iv_date, oi_return); commit; end;
b558cx1vmxmvxBEGIN FOR DT in '20140301' .. '20140331' LOOP EXECUTE IMMEDIATE 'INSERT INTO TMP_LICAL_USER_CALL_LEN SELECT T1.MSISDN, ROUND((to_date(t1.end_date||t1.end_time, ''yyyy-mm-dd hh24:mi:ss'') - to_date(t1.start_date||t1.start_time, ''yyyy-mm-dd hh24:mi:ss''))*1440) CALL_LEN, ''Mar'' FROM DWD_BILL_GSM_CALL_201403 T1, TMP_LICAI_USER T2 WHERE T1.MSISDN = T2.CALLER AND STATICE_DATE = '''||DT||''''; COMMIT; END LOOP; END;
b82hd1sty3c3jINSERT INTO MID_ACTIVE_USER_Y NOLOGGING SELECT CALLING_NO FROM DW_CUSTBEF_ACTIVE_USER_D T WHERE T.STATICE_TIME=20140503 MINUS SELECT CALLING_NO FROM DW_CUSTBEF_ACTIVE_USER_Y2014 A WHERE STATICE_TIME<=20140503
br1xgsckydkgaINSERT INTO TMP_LICAL_USER_CALL_LEN SELECT T1.MSISDN, ROUND((to_date(t1.end_date||t1.end_time, 'yyyy-mm-dd hh24:mi:ss') - to_date(t1.start_date||t1.start_time, 'yyyy-mm-dd hh24:mi:ss'))*1440) CALL_LEN, 'Mar' FROM DWD_BILL_GSM_CALL_201404 T1, TMP_LICAI_USER T2 WHERE T1.MSISDN = T2.CALLER AND STATICE_DATE = '20140402'
bsa0wjtftg3uwselect file# from file$ where ts#=:1
ckd14gx0cvb4w INSERT INTO DWD_BILL_GSM_CALL_201405 NOLOGGING SELECT '20140503', T.SOURCE_TYPE, T.BIZ_TYPE, T.FID, T.RR_FLAG, T.START_DATE, T.START_TIME, T.END_DATE, T.END_TIME, T.CALL_TYPE, T.MSISDN, T.B_MSISDN, T.SERVICE_TYPE, T.SERVICE_CODE, T.VISIT_AREA_CODE, T.CALLED_CODE, T.LONG_TYPE1, T.LONG_TYPE2, T.ROAM_TYPE, T.CALL_DURATION, T.CFEE, T.LFEE, T.OTHERFEE, T.DISCOUNT_CFEE, T.DISCOUNT_LFEE, T.DISCOUNT_OTHERFEE, T.TARIFF_FEE, T.IMSI_NUMBER, T.IMEI FROM TI_BIL_GSM_CALL_20140503@HJFXDB78 T
d65ypzjzr3y68INSERT INTO GR_ODS.MONITOR_DB_TABLESPACE SELECT T.TSN, NVL(TOTAL_SPACE, 0) TOTAL_SPACE, NVL(FREE_SPACE, 0) FREE_SPACE, ROUND(FREE_SPACE / TOTAL_SPACE, 2) FREE_PERCENT, NVL(USED_SPACE, 0) USED_SPACE, ROUND(USED_SPACE / TOTAL_SPACE, 2) USED_PERCENT, :B1 , TO_CHAR(SYSDATE, 'HH24') FROM (SELECT TABLESPACE_NAME TSN, SUM(BYTES) / 1024 / 1024 / 1024 TOTAL_SPACE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) T, (SELECT TABLESPACE_NAME TSN2, SUM(BYTES) / 1024 / 1024 / 1024 FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) T2, (SELECT TABLESPACE_NAME TSN3, SUM(BYTES) / 1024 / 1024 / 1024 USED_SPACE FROM DBA_SEGMENTS GROUP BY TABLESPACE_NAME) T3 WHERE T.TSN = T2.TSN2(+) AND T.TSN = T3.TSN3(+) ORDER BY T.TSN
dcxh6p276kt1zInsert Into DW_ORDER_TICKET_NUM_D ( statice_time, calling_num, called_num, num_type ) SELECT T.END_DATE, T.MSISDN CALLING_NO, T.B_MSISDN, '2' NUM_TYPE FROM HJFX.TI_BIL_GSM_CALL_20140503@HJFXDB78 T, DIM_ORDER_TICKET_TELNUM A WHERE (T.B_MSISDN = A.TEL_NUM1 OR T.B_MSISDN = A.TEL_NUM2) AND LENGTH(T.MSISDN) = 11 AND T.END_DATE = '20140503' AND SUBSTR(T.MSISDN, 1, 3) IN ('130', '131', '132', '155', '156', '185', '186')
dgrrz06m4cffa INSERT INTO MID_DW_INCR_QBAR NOLOGGING (DEVICE_NO, DEVICE_NO_C, CITY_ID, PROVINCE_ID, DEVICE_TYPE) SELECT DISTINCT A.CALLING_NO, CASE WHEN SUBSTR(A.CALLING_NO, 1, 3) = '010' THEN SUBSTR(A.CALLING_NO, 4) ELSE A.CALLING_NO END CALLING_X, B.AREA_CODE, B.PROVINCE_ID, '01' FROM GR_ODS.ODS_INCR_QBAR A, GR_DIM.DIM_PSTN_AREA_CODE B WHERE (SUBSTR(A.CALLING_NO, 1, 3) = B.AREA_CODE OR SUBSTR(A.CALLING_NO, 1, 4) = B.AREA_CODE) AND LENGTH(A.CALLING_NO) IN (11, 12) AND A.STATICE_DATE = :B1 UNION ALL SELECT DISTINCT A.CALLING_NO, A.CALLING_NO, '010', '1001', '01' NUMBER_TYPE FROM GR_ODS.ODS_INCR_QBAR A WHERE LENGTH(A.CALLING_NO) = 8 AND SUBSTR(A.CALLING_NO, 1, 1) IN (5, 6, 8) AND A.STATICE_DATE = :B1 UNION ALL SELECT DISTINCT A.CALLING_NO, A.CALLING_NO, C.CITY_ID, C.AREA_ID, '02' NUMBER_TYPE FROM GR_ODS.ODS_INCR_QBAR A, CALNAV.DIM_NUMBER_LIST C WHERE SUBSTR(A.CALLING_NO, 1, 4) = C.SEGMENT_ID(+) AND SUBSTR(A.CALLING_NO, 5, 3) BETWEEN C.START_ID AND C.END_ID AND LENGTH(A.CALLING_NO) = 11 AND A.STATICE_DATE = :B1 UNION ALL SELECT DISTINCT A.CALLING_NO, SUBSTR(A.CALLING_NO, 2), C.CITY_ID, C.AREA_ID, '02' NUMBER_TYPE FROM GR_ODS.ODS_INCR_QBAR A, CALNAV.DIM_NUMBER_LIST C WHERE SUBSTR(A.CALLING_NO, 2, 4) = C.SEGMENT_ID(+) AND SUBSTR(A.CALLING_NO, 6, 3) BETWEEN C.START_ID AND C.END_ID AND LENGTH(A.CALLING_NO) = 12 AND A.STATICE_DATE = :B1 UNION ALL SELECT DISTINCT A.CALLING_NO, A.CALLING_NO, '-1', '-1', '03' FROM GR_ODS.ODS_INCR_QBAR A WHERE SUBSTR(A. CALLING_NO, 1, 3) IN ('168', '116', '160', '962') AND A.STATICE_DATE = :B1
drfyzt9x73p5zSELECT COUNT(T.CITY_ID) FROM DIM_NUM_FOR_CITY T WHERE T.START_ID <= SUBSTR(:B1 , 1, 8) AND T.END_ID >= SUBSTR(:B1 , 1, 8) AND T.SEGMENT_ID=SUBSTR(:B1 , 1, 4)
dzffdpu58dqgvSELECT A.TABLESPACE_NAME||'|'|| decode(substr(ROUND(A.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND(A.BYTES / 1024 / 1024 / 1024, 2), ROUND(A.BYTES / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2), ROUND((A.BYTES - B.BYTES) / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND(B.BYTES / 1024 / 1024 / 1024, 2), 1, 1), '.', '0'||ROUND(B.BYTES / 1024 / 1024 / 1024, 2), ROUND(B.BYTES / 1024 / 1024 / 1024, 2))||'|'|| decode(substr(ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), 1, 1), '.', '0'||ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2), ROUND(((A.BYTES - B.BYTES) / A.BYTES) * 100, 2)) FROM (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES, MAX(BYTES) LARGEST FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) B WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME ORDER BY ((A.BYTES - B.BYTES) / A.BYTES) DESC
f7hysjfzsj6d2 DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN Declare VI_TASK_ID INTEGER; -- ÈÎÎñÈÕÖ¾ID II_DAY Varchar2(10); OI_RETURN Integer; Begin ---ÈÕÖ¾ GR_DW.SP_114_SYS_LOG(VI_TASK_ID, UPPER('ÔöÖµÒµÎñDWºÍDM²ã½Å±¾µ÷¶È'), UPPER('ÔöÖµÒµÎñDWºÍDM²ã½Å±¾µ÷¶È'), TO_CHAR(SYSDATE - 2, 'YYYYMMDD'), 1, NULL, NULL, NULL); II_DAY := TO_CHAR(Sysdate-2, 'YYYYMMDD'); ---dw²ã ÌìÖ´ÐРÿÌìÖ´ÐÐÇ°ÌìÊý¾Ý£¨±ÈÈç3ºÅÖ´ÐÐ1ºÅ£© SP_DW_INCR_TELINFO_USE_D(II_DAY, OI_RETURN);---µç»°ÐÅÏ¢ SP_DW_INCR_16856000_D(II_DAY, OI_RETURN);---¸èÇúÏÂÔØÌì SP_DW_INCR_QB_USE_D(II_DAY, OI_RETURN);------dw²ãq±ÒÒµÎñ SP_DW_INCR_TELCON_D(II_DAY, OI_RETURN);---µç»°»áÒéÈÕ sp_dw_incr_qbar_use_d(II_DAY, OI_RETURN); ---QBARÒµÎñDW²ã ---dm²ã ÌìÖ´ÐРÿÌìÖ´ÐÐÇ°ÌìÊý¾Ý£¨±ÈÈç3ºÅÖ´ÐÐ1ºÅ£© SP_DM_INCR_QB_D(II_DAY, OI_RETURN);-------dm²ãqbÒµÎñ sp_dm_incr_qbar_user_d(II_DAY, OI_RETURN); ---QBARÒµÎñDM²ã ---dm²ã ÔÂÖ´ÐРÿÔÂ2ºÅÖ´ÐÐ If Substr(II_DAY, 7, 2)='02' Then SP_DM_INCR_TELECON_FEE_M(TO_CHAR(ADD_MONTHS(TO_DATE(II_DAY, 'YYYYMMDD'), -1), 'YYYYMM'), OI_RETURN);---µç»°»áÒé SP_DM_INCR_16856000_M(TO_CHAR(ADD_MONTHS(TO_DATE(II_DAY, 'YYYYMMDD'), -1), 'YYYYMM'), OI_RETURN);---¸èÇúÏÂÔØÔ SP_DM_INCR_TELEINFOR_M(TO_CHAR(ADD_MONTHS(TO_DATE(II_DAY, 'YYYYMMDD'), -1), 'YYYYMM'), OI_RETURN);---µç»°ÐÅÏ¢Ô±í End If; GR_DW.SP_114_SYS_LOG( VI_TASK_ID, UPPER('ÔöÖµÒµÎñDWºÍDM²ã½Å±¾µ÷¶È'), UPPER('ÔöÖµÒµÎñDWºÍDM²ã½Å±¾µ÷¶È'), TO_CHAR(SYSDATE - 2, 'YYYYMMDD'), 0, NULL, NULL, NULL); End; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fjdpxdf5bn9zg INSERT INTO DW_INCR_QBAR_USE_D NOLOGGING (STATICE_MONTH, STATICE_DAY, STATICE_DATE, CALLING_NO, CALLED_NO, CALLING_NO_TYPE, CARRIER_TYPE, CARRIER_CITY, CARRIER_PROVINCE, DISTRICT_ID, BRAND_ID, CALL_BEGIN_DATE, CALL_END_DATE, CALL_DUR, RECEIVABLE_FEE, CALL_TYPE, PROMOTION_DESC, USER_TYPE, SP_ID, INSERT_DATE ) SELECT SUBSTR(A.STATICE_DATE, 1, 6) STATICE_MONTH, SUBSTR(A.STATICE_DATE, 7, 2) STATICE_DAY, A.STATICE_DATE STATICE_DATE, A.CALLING_NO CALLING_NO, A.CALLED_NO CALLED_NO, NVL(B.DEVICE_TYPE, '-1') CALLING_NO_TYPE, CASE WHEN (SUBSTR(B.DEVICE_NO_C, 1, 1) IN ('6', '8') OR SUBSTR(B.DEVICE_NO, 1, 3) IN ('130', '131', '132', '155', '156', '186')) AND B.PROVINCE_ID = '1001' THEN '01' WHEN (SUBSTR(B.DEVICE_NO_C, 1, 2) IN ('51', '52', '53') OR SUBSTR(B.DEVICE_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '144', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) AND B.PROVINCE_ID = '1001' THEN '02' WHEN (SUBSTR(B.DEVICE_NO_C, 1, 2) IN ('57', '58', '59') OR SUBSTR(B.DEVICE_NO, 1, 3) IN ('133', '153', '180', '189')) AND B.PROVINCE_ID = '1001' THEN '03' ELSE '-1' END CARRIER_TYPE, NVL(B.CITY_ID, '-1') CARRIER_CITY, NVL(B.PROVINCE_ID, '-1') CARRIER_PROVINCE, C.DISTRICT_ID DISTRICT_ID, C.BRAND BRAND_ID, A.CALL_BEGIN_DATE CALL_BEGIN_DATE, A.CALL_END_DATE CALL_END_DATE, (A.CALL_END_DATE - A.CALL_BEGIN_DATE) * 86400 CALL_DUR, '' RECEIVABLE_FEE, CASE WHEN A.CALL_TYPE IN ('01', 'ºôÈë') THEN '01' WHEN A.CALL_TYPE IN ('02', 'Íâºô³É¹¦') THEN '02' WHEN A.CALL_TYPE IN ('03', 'Íâºôʧ°Ü') THEN '03' ELSE '04' END AS CALL_TYPE, A.PROMOTION_DESC PROMOTION_DESC, A.USER_TYPE, A.SP_ID, SYSDATE INSERT_DATE FROM GR_ODS.ODS_INCR_QBAR A, MID_DW_INCR_QBAR B, DW_USER_DISTRICT_BRAND C WHERE A.CALLING_NO = B.DEVICE_NO(+) AND B.DEVICE_NO_C = C.DEVICE_NO(+) AND A.STATICE_DATE = :B1
fk009t2ad33ag INSERT /*+APPEND */ INTO DW_COMPETE_HOTEL_D NOLOGGING (STATICE_TIME, CALLING_NO, SERVICE_NO, NUMBER_TYPE, CARRIER_TYPE, CITY_ID, COMPETE_ID, CALL_CNT, USER_CNT, INSERT_DATE) SELECT STATICE_DATE, T3.CALLING_NO, T3.CALLED_NO, CASE WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T3.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END NUMBER_TYPE, CASE WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END CARRIER_TYPE, DECODE(FUN_114_NUMBER_CITY(T3.CALLING _NO), '2001', '01', '-1', '-1', '02'), T5.TYPE_ID COMPETE_ID, SUM(T3.CALL_CNT) CALL_CNT, COUNT(DISTINCT T3.CALLING_NO) USER_CNT, SYSDATE INSERT_DATE FROM MID_PSTN_DETAIL T3, (SELECT T.PHONE_NUM PHONE_NUM, T.TYPE_ID TYPE_ID FROM DIM_COMPETE T WHERE T.TYPE_ID='02' UNION SELECT T.PHONE_NUM2 PHONE_NUM, T.TYPE_ID TYPE_ID FROM DIM_COMPETE T WHERE T.TYPE_ID='02') T5 WHERE T3.CALLED_NO=T5.PHONE_NUM GROUP BY STATICE_DATE, T3.CALLING_NO, T3.CALLED_NO, CASE WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T3.CALLING_NO IS NOT NULL AND LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T3.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END , CASE WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T3.CALLING_NO)=8 AND SUBSTR(T3.CAL LING_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T3.CALLING_NO)=11 AND SUBSTR(T3.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END , DECODE(FUN_114_NUMBER_CITY(T3.CALLING_NO), '2001', '01', '-1', '-1', '02'), T5.TYPE_ID, SYSDATE
fmhc91f39a2h9SELECT COUNT(T.CITY_ID) FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND TO_NUMBER(T.START_ID) <= TO_NUMBER(SUBSTR(:B1 , 5, 3)) AND TO_NUMBER(T.END_ID) >= TO_NUMBER(SUBSTR(:B1 , 5, 3))
fnhtmkf5j3n7rINSERT INTO MID_ODS_YYGH_ORDER_SUCCESS NOLOGGING ( STATICE_TIME, STATICE_MONTH, ORDER_TIME, TIME_FLAG, DOCTOR_NUM, SUB_SECTION_NAME, SECTION_NAME, DOCTOR_NAME, DOCTOR_POST, SOURCE_TYPE, NUM_FEE, PATIENT_NAME, PATIENT_ID, PATIENT_SEX, PATIENT_AGE, PATIENT_NUM, CARRIER_TYPE, CITY_ID, NUMBER_TYPE, SEE_TIME, ORDER_SUCCESS_TIME, HOSPITAL_NAME, HOS_GRADE, PAY_ID, ORDER_WAY, REGISTER_WAY_ID, OPERATOR_NUM, LIVE_CITY_ID ) SELECT T.STATICE_TIME, SUBSTR(T.STATICE_TIME, 1, 6), T.ORDER_TIME, T.TIME_FLAG, T.DOCTOR_NUM, T.SUB_SECTION_NAME, T.SECTION_NAME, T.DOCTOR_NAME, T.DOCTOR_POST, T.SOURCE_TYPE, T.NUM_FEE, T.PATIENT_NAME, T.PATIENT_ID, T.PATIENT_SEX, T.PATIENT_AGE, T.PATIENT_NUM, FUN_114_NUMBER_CARRIER_TYPE(T.PATIENT_NUM), FUN_114_NUMBER_CITY_NEW(T.PATIENT_NUM), FUN_114_NUMBER_TYPE_NEW(T.PATIENT_NUM), T.SEE_TIME, T.ORDER_SUCCESS_TIME, T.HOSPITAL_NAME, T.HOS_GRADE, T.PAY_ID, T.ORDER_WAY, T.REGISTER_WAY_ID, T.OPERATOR_NUM, T.LIVE_CITY_ID FROM MID_DW_YYGH_ORDER_SUCCESS T
fvb1u4vsc2b2d INSERT /*+APPEND */ INTO DW_COMPETE_CATE_D NOLOGGING (STATICE_TIME, CALLING_NO, SERVICE_NO, NUMBER_TYPE, CARRIER_TYPE, CITY_ID, COMPETE_ID, CALL_CNT, USER_CNT, INSERT_DATE) SELECT STATICE_TIME, CALLING_NO, T.CALLED_NO, CASE WHEN T.CALLING_NO IS NOT NULL AND LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T.CALLING_NO IS NOT NULL AND LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END NUMBER_TYPE, CASE WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END CARRIER_TYPE, DECODE(FUN_114_NUMBER_CITY(T.CALLING_NO), '2001', '01', '-1', '-1', '02'), '03' COMPETE_ID, COUNT(1) CALL_CNT, COUNT(DISTINCT CALLING_NO) USER_CNT, SYSDATE INSERT_DATE FROM DW_CALL_VOLUME_ALL_DAILY T WHERE T.STATICE_TIME = :B1 AND T.TELE_TYPE = '1401' AND T.CALLED_NO IN ('1', '2') GROUP BY STATICE_TIME, CALLING_NO, T.CALLED_NO, CASE WHEN T.CALLING_NO IS NOT NULL AND LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '159', '158', '152', '151', '150', '130', '131', '132', '155', '156', '133', '153', '182', '157', '188', '187', '186', '185', '189', '180', '147', '183', '145', '181') THEN '01' WHEN T.CALLING_NO IS NOT NULL AND LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 1) IN('6', '8') OR SUBSTR(T.CALLING_NO, 1, 2) IN('51', '52', '58', '59') THEN '02' ELSE '-1' END , CASE WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 1) IN ('6', '8')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('130', '131', '132', '145', '155', '156', '185', '186')) THEN '1' WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 2) IN ('51', '52')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('134', '135', '136', '137', '138', '139', '147', '150', '151', '152', '157', '158', '159', '182', '183', '187', '188')) THEN '2' WHEN (LENGTH(T.CALLING_NO)=8 AND SUBSTR(T.CALLING_NO, 1, 2) IN ('58', '59')) OR (LENGTH(T.CALLING_NO)=11 AND SUBSTR(T.CALLING_NO, 1, 3) IN ('133', '153', '180', '189', '181')) THEN '3' ELSE '4' END , DECODE(FUN_114_NUMBER_CITY(T.CALLING_NO ), '2001', '01', '-1', '-1', '02'), SYSDATE
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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,797,937 20.82 1,271.53
CPU used when call started 1,410,014 16.32 997.18
CR blocks created 6,751 0.08 4.77
Cached Commit SCN referenced 8,840,093 102.35 6,251.83
Commit SCN cached 5,308 0.06 3.75
DB time 4,978,583 57.64 3,520.92
DBWR checkpoint buffers written 4,145,479 48.00 2,931.74
DBWR checkpoints 148 0.00 0.10
DBWR object drop buffers written 152 0.00 0.11
DBWR revisited being-written buffer 4 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 2,414,739 27.96 1,707.74
DBWR transaction table writes 1,239 0.01 0.88
DBWR undo block writes 270,674 3.13 191.42
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 353 0.00 0.25
IMU Redo allocation size 3,349,492 38.78 2,368.81
IMU commits 974 0.01 0.69
IMU contention 3 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 181 0.00 0.13
IMU recursive-transaction flush 3 0.00 0.00
IMU undo allocation size 6,690,392 77.46 4,731.54
IMU- failed to get a private strand 181 0.00 0.13
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 41 0.00 0.03
SQL*Net roundtrips to/from client 99,350 1.15 70.26
SQL*Net roundtrips to/from dblink 885,518 10.25 626.25
active txn count during cleanout 3,713,179 42.99 2,626.01
application wait time 84 0.00 0.06
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 71 0.00 0.05
background checkpoints started 71 0.00 0.05
background timeouts 306,655 3.55 216.87
branch node splits 0 0.00 0.00
buffer is not pinned count 8,415,110 97.43 5,951.28
buffer is pinned count 595,770,613 6,897.66 421,337.07
bytes received via SQL*Net from client 6,706,655 77.65 4,743.04
bytes received via SQL*Net from dblink 9,554,018,559 110,613.64 6,756,731.65
bytes sent via SQL*Net to client 99,110,493 1,147.47 70,092.29
bytes sent via SQL*Net to dblink 9,877,689 114.36 6,985.64
calls to get snapshot scn: kcmgss 99,103,128 1,147.39 70,087.08
calls to kcmgas 3,108,865 35.99 2,198.63
calls to kcmgcs 3,850,803 44.58 2,723.34
change write time 17,689 0.20 12.51
cleanout - number of ktugct calls 3,720,077 43.07 2,630.89
cleanouts and rollbacks - consistent read gets 3 0.00 0.00
cleanouts only - consistent read gets 6,585 0.08 4.66
cluster key scan block gets 2,883,484 33.38 2,039.24
cluster key scans 2,761,218 31.97 1,952.77
commit batch performed 14 0.00 0.01
commit batch requested 14 0.00 0.01
commit batch/immediate performed 16 0.00 0.01
commit batch/immediate requested 16 0.00 0.01
commit cleanout failures: block lost 32,824 0.38 23.21
commit cleanout failures: buffer being written 422 0.00 0.30
commit cleanout failures: callback failure 434 0.01 0.31
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 2,863,761 33.16 2,025.29
commit cleanouts successfully completed 2,830,081 32.77 2,001.47
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 7,444 0.09 5.26
concurrency wait time 783 0.01 0.55
consistent changes 6,330 0.07 4.48
consistent gets 593,685,972 6,873.52 419,862.78
consistent gets - examination 16,181,293 187.34 11,443.63
consistent gets direct 30 0.00 0.02
consistent gets from cache 593,685,942 6,873.52 419,862.76
current blocks converted for CR 0 0.00 0.00
cursor authentications 1,770 0.02 1.25
data blocks consistent reads - undo records applied 6,214 0.07 4.39
db block changes 30,523,213 353.39 21,586.43
db block gets 39,423,566 456.43 27,880.88
db block gets direct 201,501 2.33 142.50
db block gets from cache 39,222,065 454.10 27,738.38
deferred (CURRENT) block cleanout applications 33,196 0.38 23.48
dirty buffers inspected 509,423 5.90 360.27
enqueue conversions 1,789,067 20.71 1,265.25
enqueue releases 4,669,561 54.06 3,302.38
enqueue requests 4,669,620 54.06 3,302.42
enqueue timeouts 59 0.00 0.04
enqueue waits 95 0.00 0.07
execute count 3,064,355 35.48 2,167.15
frame signature mismatch 0 0.00 0.00
free buffer inspected 165,845,718 1,920.11 117,288.34
free buffer requested 167,002,133 1,933.50 118,106.18
global undo segment hints helped 0 0.00 0.00
heap block compress 872 0.01 0.62
hot buffers moved to head of LRU 1,326,982 15.36 938.46
immediate (CR) block cleanout applications 6,588 0.08 4.66
immediate (CURRENT) block cleanout applications 4,023 0.05 2.85
index fast full scans (full) 22 0.00 0.02
index fetch by key 8,204,047 94.98 5,802.01
index scans kdiixs1 2,494,101 28.88 1,763.86
leaf node 90-10 splits 376 0.00 0.27
leaf node splits 550 0.01 0.39
lob reads 6,709 0.08 4.74
lob writes 1,061 0.01 0.75
lob writes unaligned 1,061 0.01 0.75
logons cumulative 1,120 0.01 0.79
messages received 95,826 1.11 67.77
messages sent 95,826 1.11 67.77
no buffer to keep pinned count 5 0.00 0.00
no work - consistent read gets 478,871,823 5,544.24 338,664.66
opened cursors cumulative 2,799,864 32.42 1,980.10
parse count (failures) 463 0.01 0.33
parse count (hard) 3,971 0.05 2.81
parse count (total) 2,795,171 32.36 1,976.78
parse time cpu 2,363 0.03 1.67
parse time elapsed 1,625,130 18.82 1,149.31
physical read IO requests 13,114,568 151.84 9,274.80
physical read bytes ############### 15,470,420.79 944,996,288.27
physical read total IO requests 21,621,425 250.33 15,290.97
physical read total bytes ############### 17,605,237.01 1,075,399,555.08
physical read total multi block requests 10,247,277 118.64 7,247.01
physical reads 163,113,373 1,888.48 115,355.99
physical reads cache 162,879,995 1,885.78 115,190.94
physical reads cache prefetch 149,841,491 1,734.82 105,969.94
physical reads direct 233,378 2.70 165.05
physical reads direct (lob) 7 0.00 0.00
physical reads direct temporary tablespace 184,166 2.13 130.24
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 3,777,818 43.74 2,671.72
physical write bytes 42,315,186,176 489,912.89 29,925,874.24
physical write total IO requests 3,996,037 46.26 2,826.05
physical write total bytes ############### 1,785,526.53 109,067,230.33
physical write total multi block requests 349,814 4.05 247.39
physical writes 5,165,428 59.80 3,653.06
physical writes direct 397,249 4.60 280.94
physical writes direct (lob) 23 0.00 0.02
physical writes direct temporary tablespace 184,166 2.13 130.24
physical writes from cache 4,768,179 55.20 3,372.12
physical writes non checkpoint 4,540,041 52.56 3,210.78
pinned buffers inspected 12,298 0.14 8.70
prefetch clients - default 6,544 0.08 4.63
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 86,399 1.00 61.10
queries parallelized 0 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive calls 64,221,141 743.53 45,418.06
recursive cpu usage 1,757,892 20.35 1,243.21
redo blocks read for recovery 0 0.00 0.00
redo blocks written 71,422,426 826.91 50,510.91
redo buffer allocation retries 530 0.01 0.37
redo entries 22,366,553 258.95 15,817.93
redo log space requests 497 0.01 0.35
redo log space wait time 2,194 0.03 1.55
redo ordering marks 483,380 5.60 341.85
redo size 35,420,224,292 410,085.04 25,049,663.57
redo synch time 1,643 0.02 1.16
redo synch writes 20,739 0.24 14.67
redo wastage 11,663,456 135.04 8,248.55
redo write time 172,393 2.00 121.92
redo writer latching time 1 0.00 0.00
redo writes 34,455 0.40 24.37
rollback changes - undo records applied 4 0.00 0.00
rollbacks only - consistent read gets 4,926 0.06 3.48
rows fetched via callback 866,213 10.03 612.60
session connect time 0 0.00 0.00
session cursor cache hits 2,772,863 32.10 1,961.01
session logical reads 633,109,538 7,329.96 447,743.66
session pga memory 127,639,408 1,477.77 90,268.32
session pga memory max 1,470,144,368 17,020.90 1,039,706.06
session uga memory ############### 5,221,577.88 318,955,236.12
session uga memory max 3,200,196,648 37,050.94 2,263,222.52
shared hash latch upgrades - no wait 2,495,055 28.89 1,764.54
shared hash latch upgrades - wait 10 0.00 0.01
sorts (disk) 4 0.00 0.00
sorts (memory) 1,403,234 16.25 992.39
sorts (rows) 119,265,550 1,380.82 84,346.22
sql area purged 91 0.00 0.06
summed dirty queue length 3,530,083 40.87 2,496.52
switch current to new buffer 1,687 0.02 1.19
table fetch by rowid 3,474,758 40.23 2,457.40
table fetch continued row 1,327 0.02 0.94
table scan blocks gotten 472,545,192 5,470.99 334,190.38
table scan rows gotten 23,681,956,407 274,182.79 16,748,201.14
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 233 0.00 0.16
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 44,218,811 511.95 31,272.14
total number of times SMON posted 197 0.00 0.14
transaction rollbacks 16 0.00 0.01
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 13 0.00 0.01
undo change vector size 2,081,656,492 24,100.81 1,472,175.74
user I/O wait time 876,367 10.15 619.78
user calls 108,323 1.25 76.61
user commits 1,404 0.02 0.99
user rollbacks 10 0.00 0.01
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 18 0.00 0.01
workarea executions - optimal 1,379,335 15.97 975.48
write clones created in background 102 0.00 0.07
write clones created in foreground 69 0.00 0.05

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 2,313,843 2,327,303
opened cursors current 57 51
workarea memory allocated 525 525
logons current 26 26

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 71 2.96

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)
TS_DWD 7,326,776 85 0.44 15.91 2,924,617 34 10 0.00
TS_LOCAL 2,129,208 25 1.74 12.21 288,566 3 37,091 2.63
USERS 2,334,005 27 0.56 1.00 176 0 95,015 3.39
TS_ODS 882,472 10 0.77 14.40 355,924 4 8 0.00
TS_DW 377,801 4 1.01 14.02 620 0 1,159 3.98
UNDOTBS1 152 0 4.87 1.00 189,291 2 53 0.00
TEMP 26,846 0 1.97 6.86 7,298 0 0 0.00
EBUSINESS 19,554 0 0.59 1.00 47 0 2,176 2.66
SYSAUX 9,034 0 2.16 1.21 8,256 0 0 0.00
SYSTEM 7,705 0 2.00 1.23 2,872 0 6 3.33
TS_DIM 438 0 5.71 1.44 49 0 27 4.44
TS_DM 432 0 6.97 3.43 50 0 25 4.80
TS_RPT 140 0 16.07 1.00 48 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)
EBUSINESS /oracle/hjfxdata2/hjfxdb/EBUSINESS.dbf 19,554 0 0.59 1.00 47 0 2,176 2.66
SYSAUX /oracle/hjfxdata2/hjfxdb/ts_local012.dbf 1,028 0 1.90 1.12 462 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/sysaux01.dbf 4,331 0 2.59 1.31 4,692 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/ts_local008.dbf 2,022 0 1.90 1.14 2,157 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/ts_local010.dbf 1,653 0 1.48 1.11 945 0 0 0.00
SYSTEM /oracle/hjfxdata2/hjfxdb/system02.dbf 936 0 5.71 1.78 442 0 1 10.00
SYSTEM /oracle/oradata/hjfxdb/system01.dbf 6,769 0 1.48 1.16 2,430 0 5 2.00
TEMP /oracle/oradata/hjfxdb/temp01.dbf 26,846 0 1.97 6.86 7,298 0 0  
TS_DIM /oracle/oradata/zzdb/ts_dim01.dbf 438 0 5.71 1.44 49 0 27 4.44
TS_DM /oracle/oradata/zzdb/ts_dm01.dbf 432 0 6.97 3.43 50 0 25 4.80
TS_DW /oracle/hjfxdata/zzdb/ts_dw05.dbf 48,853 1 0.93 14.17 96 0 90 3.44
TS_DW /oracle/hjfxdata/zzdb/ts_dw06.dbf 51,257 1 0.91 13.79 83 0 156 3.78
TS_DW /oracle/hjfxdata/zzdb/ts_dw07.dbf 49,792 1 0.86 14.28 48 0 66 4.70
TS_DW /oracle/hjfxdata/zzdb/ts_dw08.dbf 50,008 1 0.87 14.03 152 0 143 4.55
TS_DW /oracle/hjfxdata/zzdb/ts_dw09.dbf 50,637 1 0.83 13.80 48 0 245 3.96
TS_DW /oracle/oradata/zzdb/ts_dw01.dbf 30,288 0 1.20 13.82 50 0 150 4.13
TS_DW /oracle/oradata/zzdb/ts_dw02.dbf 29,816 0 1.26 14.34 47 0 39 3.59
TS_DW /oracle/oradata/zzdb/ts_dw03.dbf 28,821 0 1.26 14.29 48 0 65 5.08
TS_DW /oracle/oradata/zzdb/ts_dw04.dbf 38,329 0 1.32 13.82 48 0 205 3.37
TS_DWD /zzdb/tablespace/zzts001/ts_dwd001.dbf 77,504 1 0.41 15.95 33,365 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd002.dbf 78,360 1 0.41 15.95 32,612 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd003.dbf 78,015 1 0.41 15.95 23,778 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd004.dbf 78,580 1 0.41 15.95 31,176 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd005.dbf 75,916 1 0.40 15.94 32,921 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd006.dbf 76,439 1 0.41 15.94 27,224 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd007.dbf 77,375 1 0.41 15.95 31,933 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd008.dbf 76,350 1 0.41 15.94 29,856 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd009.dbf 74,688 1 0.40 15.94 29,398 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd010.dbf 74,934 1 0.43 15.94 35,778 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd011.dbf 75,307 1 0.42 15.94 28,920 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd012.dbf 77,816 1 0.41 15.94 37,118 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd013.dbf 79,814 1 0.40 15.95 26,755 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd014.dbf 79,444 1 0.42 15.95 29,717 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd015.dbf 79,444 1 0.40 15.95 39,661 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd016.dbf 76,464 1 0.42 15.94 44,021 1 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd017.dbf 77,727 1 0.39 15.95 31,169 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd018.dbf 76,409 1 0.40 15.95 30,338 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd019.dbf 78,522 1 0.38 15.94 38,930 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd020.dbf 76,582 1 0.39 15.95 40,036 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd021.dbf 80,047 1 0.38 15.95 34,885 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd022.dbf 79,999 1 0.40 15.94 37,075 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd023.dbf 77,245 1 0.40 15.94 37,480 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd024.dbf 76,433 1 0.40 15.94 36,205 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd025.dbf 76,547 1 0.42 15.94 36,363 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd026.dbf 77,641 1 0.42 15.94 36,565 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd027.dbf 77,667 1 0.41 15.94 38,024 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd028.dbf 78,022 1 0.44 15.89 28,046 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd029.dbf 80,091 1 0.42 15.91 36,937 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd030.dbf 77,201 1 0.43 15.87 33,792 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd031.dbf 1,896 0 3.67 14.18 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd032.dbf 236 0 26.27 2.06 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd033.dbf 232 0 26.77 1.39 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd034.dbf 236 0 26.27 1.50 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd035.dbf 265 0 28.79 1.00 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd036.dbf 271 0 28.27 1.15 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd037.dbf 929 0 8.77 11.46 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd038.dbf 7,384 0 1.40 15.42 55 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd039.dbf 6,962 0 1.43 15.37 60 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd040.dbf 9,257 0 1.08 15.55 51 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd041.dbf 11,746 0 0.94 15.64 54 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd042.dbf 11,047 0 0.95 15.63 52 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd043.dbf 12,997 0 0.89 15.52 50 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd044.dbf 18,133 0 0.76 15.76 4,423 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd045.dbf 20,963 0 0.65 15.80 5,391 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd046.dbf 19,186 0 0.72 15.55 31,897 0 5 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd047.dbf 18,015 0 0.70 15.76 30,872 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd048.dbf 17,981 0 0.74 15.76 31,413 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd049.dbf 16,516 0 0.78 15.72 31,044 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd050.dbf 18,338 0 0.76 15.77 32,110 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd051.dbf 18,911 0 0.71 15.77 32,151 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd052.dbf 18,976 0 0.72 15.77 31,028 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd053.dbf 19,014 0 0.76 15.68 26,679 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd054.dbf 17,366 0 0.73 15.66 26,611 0 5 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd055.dbf 16,329 0 0.78 15.58 27,164 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd056.dbf 16,796 0 0.79 15.60 26,991 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd057.dbf 18,400 0 0.73 15.73 26,932 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd058.dbf 17,305 0 0.79 15.72 26,430 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd059.dbf 18,445 0 0.70 15.73 25,853 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd060.dbf 17,177 0 0.72 15.72 28,036 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd061.dbf 18,902 0 0.65 15.66 20,805 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd062.dbf 18,783 0 0.62 15.75 24,920 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd063.dbf 18,905 0 0.65 15.75 25,645 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd064.dbf 53,272 1 0.50 15.84 25,286 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd065.dbf 48,099 1 0.52 15.88 27,109 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd066.dbf 48,641 1 0.50 15.88 27,593 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd067.dbf 45,812 1 0.54 15.88 25,831 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd068.dbf 47,645 1 0.51 15.88 26,191 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd069.dbf 44,426 1 0.50 15.88 26,396 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd070.dbf 76,188 1 0.43 15.92 25,466 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd071.dbf 73,106 1 0.43 15.92 26,511 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd072.dbf 72,073 1 0.43 15.91 28,532 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd073.dbf 66,804 1 0.45 15.91 27,840 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd074.dbf 62,348 1 0.44 15.90 24,929 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd075.dbf 57,535 1 0.48 15.88 26,023 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd076.dbf 54,143 1 0.49 15.88 27,748 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd077.dbf 51,334 1 0.49 15.87 24,527 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd078.dbf 51,498 1 0.47 15.88 24,724 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd079.dbf 50,722 1 0.47 15.88 24,723 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd080.dbf 75,804 1 0.44 15.91 25,211 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd081.dbf 75,342 1 0.45 15.92 24,551 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd082.dbf 77,440 1 0.44 15.92 25,795 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd083.dbf 80,594 1 0.43 15.92 26,512 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd084.dbf 82,870 1 0.42 15.92 26,075 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd085.dbf 85,354 1 0.46 15.93 20,470 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd086.dbf 83,991 1 0.44 15.92 26,119 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd087.dbf 79,566 1 0.43 15.92 26,931 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd088.dbf 83,288 1 0.42 15.93 25,973 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd089.dbf 84,142 1 0.42 15.92 25,318 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd090.dbf 86,889 1 0.45 15.93 26,090 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd091.dbf 87,623 1 0.41 15.93 20,317 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd092.dbf 85,359 1 0.42 15.92 25,396 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd093.dbf 89,030 1 0.41 15.93 25,764 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd094.dbf 86,695 1 0.42 15.93 23,612 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd095.dbf 85,859 1 0.45 15.92 24,852 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd096.dbf 86,696 1 0.43 15.92 23,183 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd097.dbf 85,223 1 0.42 15.92 24,021 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd098.dbf 83,064 1 0.43 15.92 24,873 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd099.dbf 82,627 1 0.41 15.92 24,309 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd100.dbf 43,799 1 0.52 15.87 24,899 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd101.dbf 14,775 0 0.86 15.63 24,295 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd102.dbf 17,164 0 0.76 15.68 24,292 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd103.dbf 17,214 0 0.71 15.69 25,708 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd104.dbf 16,886 0 0.75 15.68 25,809 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd105.dbf 16,859 0 0.75 15.69 26,079 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd106.dbf 80,943 1 0.41 15.92 25,043 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd107.dbf 81,311 1 0.40 15.92 25,003 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd108.dbf 79,891 1 0.41 15.92 25,200 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd109.dbf 78,656 1 0.40 15.92 26,957 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd120.dbf 78,429 1 0.41 15.92 26,813 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd121.dbf 78,320 1 0.40 15.92 27,972 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd122.dbf 77,137 1 0.40 15.92 27,706 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd123.dbf 78,973 1 0.42 15.92 28,371 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd124.dbf 79,726 1 0.42 15.92 28,353 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd125.dbf 77,920 1 0.42 15.92 29,112 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd126.dbf 77,606 1 0.42 15.91 27,891 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd127.dbf 78,933 1 0.40 15.91 33,001 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd128.dbf 181,318 2 0.30 15.95 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd129.dbf 177,402 2 0.28 15.95 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd130.dbf 285,606 3 0.31 15.96 47 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd131.dbf 282,324 3 0.28 15.96 47 0 0 0.00
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local.dbf 135,795 2 1.79 11.03 38,657 0 2,003 3.34
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local001.dbf 142,785 2 1.41 11.45 39,066 0 1,934 2.98
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local002.dbf 98,695 1 1.09 11.75 37,545 0 414 3.55
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local003.dbf 74,328 1 1.22 11.95 21,225 0 365 3.21
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local004.dbf 74,975 1 1.25 12.18 21,646 0 457 3.35
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local009.dbf 47 0 4.89 1.00 47 0 0 0.00
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local019.dbf 220,338 3 1.19 8.06 37,484 0 14,873 1.91
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local020.dbf 63,909 1 1.79 11.90 719 0 1,630 3.08
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local021.dbf 59,558 1 1.63 13.11 921 0 1,000 2.81
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local022.dbf 24,890 0 1.99 13.90 157 0 218 3.21
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local023.dbf 58,395 1 1.70 13.36 1,064 0 856 3.20
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local024.dbf 58,961 1 1.63 13.33 959 0 849 2.87
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local025.dbf 54,477 1 1.63 13.82 913 0 532 2.86
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local026.dbf 58,668 1 1.58 13.53 1,299 0 615 2.99
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local027.dbf 57,919 1 1.58 13.55 1,255 0 761 2.90
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local028.dbf 56,632 1 1.96 13.48 2,454 0 594 3.20
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local029.dbf 128,174 1 2.82 13.51 1,193 0 1,592 3.39
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local030.dbf 124,203 1 2.59 13.96 1,296 0 991 3.22
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local031.dbf 125,875 1 2.50 13.84 2,178 0 1,138 3.24
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local032.dbf 129,333 1 2.51 13.91 1,904 0 1,130 3.24
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local033.dbf 198 0 24.70 1.66 47 0 0 0.00
TS_LOCAL /oracle/oradata/hjfxdb/ts_local005.dbf 63,488 1 1.49 11.82 17,857 0 581 3.36
TS_LOCAL /oracle/oradata/hjfxdb/ts_local006.dbf 47 0 4.04 1.00 47 0 0 0.00
TS_LOCAL /oracle/oradata/hjfxdb/ts_local007.dbf 43,028 0 0.90 9.79 16,792 0 695 3.35
TS_LOCAL /oracle/oradata/hjfxdb/ts_local013.dbf 96,556 1 1.12 11.38 38,987 0 657 3.77
TS_LOCAL /oracle/oradata/hjfxdb/ts_local014.dbf 34,453 0 1.61 13.75 513 0 336 3.75
TS_LOCAL /oracle/oradata/hjfxdb/ts_local015.dbf 32,028 0 1.75 13.66 504 0 344 2.85
TS_LOCAL /oracle/oradata/hjfxdb/ts_local016.dbf 11,198 0 1.10 13.49 125 0 111 3.69
TS_LOCAL /oracle/oradata/hjfxdb/ts_local017.dbf 51,953 1 1.59 13.23 1,126 0 588 3.55
TS_LOCAL /oracle/oradata/hjfxdb/ts_local018.dbf 48,302 1 1.77 11.45 586 0 1,827 2.18
TS_ODS /oracle/hjfxdata/zzdb/ts_ods09.dbf 35,333 0 0.40 14.96 3,943 0 0 0.00
TS_ODS /oracle/hjfxdata/zzdb/ts_ods10.dbf 37,487 0 0.36 15.20 2,016 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods01.dbf 34,198 0 0.53 14.21 4,376 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods02.dbf 34,415 0 0.38 14.23 646 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods03.dbf 41,705 0 0.33 14.56 434 0 7 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods04.dbf 34,082 0 0.36 14.11 447 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods05.dbf 35,751 0 0.35 14.30 707 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods06.dbf 38,119 0 0.35 14.30 5,138 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods07.dbf 29,954 0 0.48 14.75 237 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods08.dbf 24,432 0 0.46 14.82 3,867 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods11.dbf 24,481 0 0.57 15.26 4,902 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods12.dbf 30,074 0 0.55 14.49 5,686 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods13.dbf 23,076 0 0.71 13.97 6,814 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods14.dbf 32,153 0 0.70 13.98 7,520 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods15.dbf 17,174 0 1.19 12.67 7,053 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods16.dbf 26,049 0 0.70 14.04 445 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods17.dbf 28,975 0 0.66 14.10 51 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods18.dbf 20,335 0 0.97 13.30 416 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods19.dbf 26,503 0 0.69 14.06 7,381 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods20.dbf 17,788 0 0.77 13.67 7,134 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods21.dbf 21,580 0 0.66 14.24 7,709 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods22.dbf 29,683 0 0.51 14.59 6,943 0 1 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods23.dbf 43,816 1 0.43 15.04 313 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods24.dbf 39,803 0 0.45 14.97 5,860 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods25.dbf 42,032 0 0.42 15.04 6,912 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods26.dbf 28,828 0 0.52 14.90 6,724 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods59.dbf 567 0 9.51 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods60.dbf 282 0 18.48 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods61.dbf 282 0 18.48 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods62.dbf 282 0 18.48 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods63.dbf 282 0 18.48 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods64.dbf 402 0 13.26 1.00 4,428 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods65.dbf 884 0 6.58 1.02 4,431 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods66.dbf 283 0 18.48 1.00 4,712 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods67.dbf 402 0 13.36 1.00 4,752 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods68.dbf 1,455 0 3.93 11.81 4,198 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods69.dbf 282 0 18.48 1.00 4,283 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods70.dbf 282 0 18.87 1.00 4,734 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods71.dbf 282 0 18.48 1.00 4,240 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods72.dbf 282 0 18.48 1.00 4,619 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods73.dbf 277 0 16.10 1.00 4,834 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods74.dbf 277 0 16.10 1.00 4,285 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods75.dbf 277 0 15.81 1.00 4,625 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods76.dbf 277 0 15.81 1.00 4,758 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods77.dbf 277 0 15.78 1.00 4,054 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods27.dbf 187 0 29.52 1.00 47 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods28.dbf 6,603 0 1.05 15.56 11,961 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods29.dbf 6,603 0 1.00 15.56 11,959 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods30.dbf 3,403 0 1.82 15.16 12,001 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods31.dbf 2,923 0 2.06 15.02 12,470 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods32.dbf 3,403 0 1.80 15.16 12,052 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods33.dbf 715 0 8.08 12.05 12,426 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods34.dbf 3,403 0 1.79 15.16 11,717 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods35.dbf 3,395 0 1.80 15.16 11,861 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods38.dbf 3,391 0 1.83 15.14 10,838 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods39.dbf 698 0 9.28 10.95 11,225 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods43.dbf 1,466 0 4.50 13.59 8,473 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods44.dbf 3,098 0 2.18 14.85 4,354 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods45.dbf 3,434 0 1.97 14.96 5,010 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods46.dbf 3,434 0 1.99 14.96 4,393 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods47.dbf 3,306 0 2.05 14.92 4,158 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods48.dbf 3,290 0 1.98 14.99 4,671 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods49.dbf 3,290 0 2.02 14.99 4,651 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods50.dbf 3,290 0 1.99 14.99 4,375 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods51.dbf 218 0 27.98 1.00 4,691 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods52.dbf 2,908 0 2.23 14.85 3,885 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods53.dbf 1,034 0 6.09 12.82 4,514 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods54.dbf 3,530 0 1.90 14.04 4,748 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods55.dbf 3,290 0 2.01 14.99 4,434 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods56.dbf 3,410 0 1.98 14.50 4,853 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods57.dbf 3,290 0 2.01 14.99 3,295 0 0 0.00
TS_RPT /oracle/oradata/zzdb/ts_rpt01.dbf 140 0 16.07 1.00 48 0 0 0.00
UNDOTBS1 /oracle/oradata/hjfxdb/undotbs001.dbf 78 0 5.26 1.00 92,014 1 0 0.00
UNDOTBS1 /oracle/oradata/hjfxdb/undotbs01.dbf 74 0 4.46 1.00 97,277 1 53 0.00
USERS /oracle/oradata/hjfxdb/users01.dbf 525,515 6 0.58 1.00 47 0 29,752 3.44
USERS /oracle/oradata/hjfxdb/users02.dbf 805,810 9 0.55 1.00 82 0 21,555 3.33
USERS /oracle/oradata/hjfxdb/users03.dbf 1,002,680 12 0.56 1.00 47 0 43,708 3.38

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 1,626,867 74 632,903,724 162,879,985 4,768,179 0 0 135,570


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 21 166 457 127 1843200 127  
E 0 21 185 479 184 1843200 184  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,312 0.10 162,688 1.14 22,017,742,258
D 2,624 0.20 325,376 1.07 20,729,834,573
D 3,936 0.30 488,064 1.03 20,063,233,079
D 5,248 0.40 650,752 1.02 19,877,803,007
D 6,560 0.50 813,440 1.02 19,774,522,080
D 7,872 0.60 976,128 1.01 19,659,336,528
D 9,184 0.70 1,138,816 1.01 19,567,739,959
D 10,496 0.80 1,301,504 1.01 19,502,577,502
D 11,808 0.90 1,464,192 1.00 19,447,545,199
D 13,120 1.00 1,626,880 1.00 19,397,127,299
D 14,432 1.10 1,789,568 1.00 19,349,428,390
D 15,744 1.20 1,952,256 1.00 19,300,293,689
D 17,056 1.30 2,114,944 0.99 19,228,041,473
D 18,368 1.40 2,277,632 0.98 19,070,404,323
D 19,680 1.50 2,440,320 0.97 18,754,698,439
D 20,992 1.60 2,603,008 0.94 18,325,896,295
D 22,304 1.70 2,765,696 0.93 17,993,080,676
D 23,616 1.80 2,928,384 0.92 17,792,010,244
D 24,928 1.90 3,091,072 0.91 17,610,065,494
D 26,240 2.00 3,253,760 0.90 17,379,608,700

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
85.11 18,014 3,152

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 4,572 4,036 260.47 0.00 0.00 0.00 0.00 468,170
E 4,572 4,035 263.49 0.00 0.00 0.00 0.00 468,170

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 1,376,276 1,376,276 0 0
64K 128K 206 206 0 0
128K 256K 60 60 0 0
256K 512K 78 78 0 0
512K 1024K 1,220 1,220 0 0
1M 2M 982 982 0 0
2M 4M 235 231 4 0
4M 8M 82 80 2 0
8M 16M 58 58 0 0
16M 32M 19 17 2 0
32M 64M 122 120 2 0
64M 128M 3 1 2 0
128M 256M 4 2 2 0
256M 512M 4 4 0 0
512M 1024M 4 0 4 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
572 0.13 4,373,570.72 499,603.47 90.00 18
1,143 0.25 4,373,570.72 450,446.98 91.00 0
2,286 0.50 4,373,570.72 450,446.98 91.00 0
3,429 0.75 4,373,570.72 450,446.98 91.00 0
4,572 1.00 4,373,570.72 372,941.32 92.00 0
5,486 1.20 4,373,570.72 271,507.05 94.00 0
6,401 1.40 4,373,570.72 271,507.05 94.00 0
7,315 1.60 4,373,570.72 271,507.05 94.00 0
8,230 1.80 4,373,570.72 271,507.05 94.00 0
9,144 2.00 4,373,570.72 271,507.05 94.00 0
13,716 3.00 4,373,570.72 271,507.05 94.00 0
18,288 4.00 4,373,570.72 271,507.05 94.00 0
27,432 6.00 4,373,570.72 271,507.05 94.00 0
36,576 8.00 4,373,570.72 271,507.05 94.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
480 0.88 75 6,401 1,029,156 1.00 1,951,638 1.00 186,581,368
544 1.00 130 10,372 1,029,463 1.00 1,951,331 1.00 186,691,186
608 1.12 193 15,599 1,029,767 1.00 1,951,027 1.00 186,799,495
672 1.24 256 19,597 1,030,070 1.00 1,950,724 1.00 186,907,288
736 1.35 319 24,271 1,030,372 1.00 1,950,422 1.00 187,014,524
800 1.47 382 28,459 1,030,672 1.00 1,950,122 1.00 187,121,128
864 1.59 443 32,996 1,030,971 1.00 1,949,823 1.00 187,227,086
928 1.71 506 36,951 1,031,268 1.00 1,949,526 1.00 187,332,403
992 1.82 569 40,882 1,031,563 1.00 1,949,231 1.00 187,437,119
1,056 1.94 632 45,252 1,031,856 1.00 1,948,938 1.00 187,541,301
1,120 2.06 695 48,567 1,032,148 1.00 1,948,646 1.00 187,645,011

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,432 0.25 19,904,968 20,729,709,937
6,864 0.50 19,126,005 19,775,371,274
10,296 0.75 18,954,783 19,567,822,012
13,728 1.00 18,815,548 19,397,127,292
17,160 1.25 18,678,194 19,228,372,285
20,592 1.50 18,322,581 18,755,082,379
24,024 1.75 18,322,581 17,791,045,152
27,456 2.00 18,320,699 17,379,826,054

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)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.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)
segment header 135,510 430 3
data block 6 0 3
undo header 53 0 0
file header block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 946,829 946,823 6 20 3 161.65
RO-Multiple Object Reuse (fast object reuse) 693 693 0 73 1 9.03
TX-Transaction 11,915 11,915 0 1 0 3.00
SQ-Sequence Cache 133 133 0 1 0 0.00

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 269.40 12,843 1,418 5 15/36.6333333333333333333333333333333333333 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
05-May 00:02 42 77 0 3 15 0/0 0/0/0/0/0/0
04-May 23:52 1 2 0 1 15 0/0 0/0/0/0/0/0
04-May 23:42 1 12 0 1 15 0/0 0/0/0/0/0/0
04-May 23:32 0 6 0 0 15 0/0 0/0/0/0/0/0
04-May 23:22 1 71 0 1 15 0/0 0/0/0/0/0/0
04-May 23:12 1 2 0 1 15 0/0 0/0/0/0/0/0
04-May 23:02 44 51 0 3 15 0/0 0/0/0/0/0/0
04-May 22:52 0 1 0 0 15 0/0 0/0/0/0/0/0
04-May 22:42 1 17 0 1 15 0/0 0/0/0/0/0/0
04-May 22:32 0 14 0 0 15 0/0 0/0/0/0/0/0
04-May 22:22 0 4 0 0 15 0/0 0/0/0/0/0/0
04-May 22:12 1 2 0 1 15 0/0 0/0/0/0/0/0
04-May 22:02 42 111 0 3 15 0/0 0/0/0/0/0/0
04-May 21:52 0 1 0 0 15 0/0 0/0/0/0/0/0
04-May 21:42 9 58 0 1 15 0/0 0/0/0/0/0/0
04-May 21:32 1 18 0 1 15 0/0 0/0/0/0/0/0
04-May 21:22 1 2 0 1 15 0/0 0/0/0/0/0/0
04-May 21:12 0 62 0 0 15 0/0 0/0/0/0/0/0
04-May 21:02 48 920 0 4 15 0/0 0/0/0/0/0/0
04-May 20:52 1 12 0 1 15 0/0 0/0/0/0/0/0
04-May 20:42 0 3 0 0 15 0/0 0/0/0/0/0/0
04-May 20:32 1 17 0 1 15 0/0 0/0/0/0/0/0
04-May 20:22 1 1 0 1 15 0/0 0/0/0/0/0/0
04-May 20:12 3 64 0 1 15 0/0 0/0/0/0/0/0
04-May 20:02 55 53 0 3 15 0/0 0/0/0/0/0/0
04-May 19:52 1 11 0 1 15 0/0 0/0/0/0/0/0
04-May 19:42 0 4 0 0 15 0/0 0/0/0/0/0/0
04-May 19:32 0 14 0 0 15 0/0 0/0/0/0/0/0
04-May 19:22 0 1 0 0 15 0/0 0/0/0/0/0/0
04-May 19:12 0 69 0 0 15 0/0 0/0/0/0/0/0
04-May 19:02 50 53 0 3 15 0/0 0/0/0/0/0/0
04-May 18:52 1 12 0 1 15 0/0 0/0/0/0/0/0
04-May 18:42 1 3 1,418 1 37 0/0 0/0/0/0/0/0
04-May 18:32 1 21 818 1 27 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 529,410 0.00   0 0  
Consistent RBA 34,536 0.01 0.00 0 0  
FAL request queue 1,869 0.00   0 0  
FAL subheap alocation 1,869 0.00   0 0  
FIB s.o chain latch 1,630 0.00   0 0  
FOB s.o list latch 32,102 0.00 0.00 0 0  
In memory undo latch 48,818 0.00 1.00 0 20,934 0.00
JS mem alloc latch 391 0.00   0 0  
JS queue access latch 391 0.00   0 0  
JS queue state obj latch 624,416 0.00   0 0  
JS slv state obj latch 1,578 0.00   0 0  
KMG MMAN ready and startup request latch 28,858 0.00   0 0  
KMG resize request state object freelist 64 0.00   0 0  
KTF sga latch 26,034 0.00   0 28,491 0.00
KWQMN job cache list latch 20 0.00   0 0  
KWQP Prop Status 48 0.00   0 0  
MQL Tracking Latch 0     0 1,726 0.00
Memory Management Latch 536 0.00   0 28,842 0.00
OS process 3,963 0.00   0 0  
OS process allocation 31,433 0.00   0 0  
OS process: request allocation 2,030 0.00   0 0  
PL/SQL warning settings 6,916 0.00   0 0  
Reserved Space Latch 213 0.00   0 0  
SGA IO buffer pool latch 9,987,938 0.00 0.00 0 9,988,086 0.00
SQL memory manager latch 24 0.00   0 28,676 0.00
SQL memory manager workarea list latch 3,742,852 0.00 0.00 0 0  
Shared B-Tree 3,155 0.00   0 0  
active checkpoint queue latch 118,959 0.03 0.00 0 0  
active service list 180,018 0.00   0 28,948 0.00
archive control 2,320 0.00   0 0  
archive process latch 30,545 0.00   0 0  
begin backup scn array 28,163 0.00   0 0  
buffer pool 503 0.00   0 0  
cache buffer handles 5,533,192 0.00 0.00 0 0  
cache buffers chains 1,488,745,447 0.00 0.02 0 318,454,304 0.00
cache buffers lru chain 14,884,888 0.39 0.00 0 306,962,790 0.02
cache table scan latch 0     0 10,180,056 0.00
channel handle pool latch 2,259 0.09 0.00 0 0  
channel operations parent latch 418,280 0.00 0.00 0 0  
checkpoint queue latch 8,935,490 0.00 0.02 0 4,584,030 0.01
client/application info 16,346 0.00   0 0  
commit callback allocation 136 0.00   0 0  
compile environment latch 6,896 0.00   0 0  
dictionary lookup 161 0.00   0 0  
dml lock allocation 36,653 0.00 0.00 0 0  
dummy allocation 2,240 0.04 0.00 0 0  
enqueue hash chains 11,128,754 0.13 0.00 0 10,008 0.00
enqueues 9,284,950 0.06 0.00 0 0  
event group latch 1,015 0.00   0 0  
file cache latch 15,614 0.00   0 0  
global KZLD latch for mem in SGA 670 0.00   0 0  
global tx hash mapping 658 0.00   0 0  
hash table column usage latch 2,632 0.00   0 149,077 0.00
hash table modification latch 1,891 0.00   0 0  
internal temp table object number allocation latc 1 0.00   0 0  
job workq parent latch 0     0 208 0.48
job_queue_processes parameter latch 1,538 0.00   0 0  
kks stats 6,431 0.00   0 0  
kmcptab latch 6 0.00   0 0  
kmcpvec latch 0     0 6 0.00
krbmrosl 1,015 0.00   0 0  
ksuosstats global area 5,806 0.00   0 0  
ktm global data 528 0.00   0 0  
kwqbsn:qsga 3,131 0.00   0 0  
lgwr LWN SCN 56,912 0.05 0.00 0 0  
library cache 12,639,933 0.05 0.00 0 12,182 0.07
library cache load lock 5,286 0.00   0 0  
library cache lock 420,150 0.00 0.00 0 0  
library cache lock allocation 9,091 0.00   0 0  
library cache pin 12,089,532 0.02 0.00 0 13 0.00
library cache pin allocation 3,774 0.00   0 0  
list of block allocation 297,821 0.00 0.00 0 0  
loader state object freelist 7,618 0.00   0 0  
logminer context allocation 24 0.00   0 0  
longop free list parent 332 0.00   0 153 0.00
message pool operations parent latch 555 0.00   0 0  
messages 849,971 0.01 0.00 0 0  
mostly latch-free SCN 57,823 1.60 0.00 0 0  
multiblock read objects 20,648,076 0.00 0.00 0 0  
ncodef allocation latch 1,379 0.00   0 0  
object queue header heap 510,328 0.00   0 512,655 0.00
object queue header operation 348,753,887 0.00 0.00 0 0  
object stats modification 217 0.00   0 0  
parallel query alloc buffer 11,472 0.00   0 0  
parameter list 110 0.00   0 0  
parameter table allocation management 1,480 0.07 0.00 0 0  
post/wait queue 2,743 0.00   0 1,189 0.00
process allocation 2,030 0.30 0.67 0 1,013 0.20
process group creation 2,030 0.00   0 0  
qmn task queue latch 12,332 0.00   0 0  
redo allocation 223,759 0.14 0.00 0 22,365,522 0.01
redo copy 0     0 22,366,773 0.01
redo writing 294,856 0.01 0.05 0 0  
reservation so alloc latch 142 0.00   0 0  
resmgr group change latch 4,554 0.00   0 0  
resmgr:actses active list 2,162 0.00   0 0  
resmgr:actses change group 967 0.00   0 0  
resmgr:free threads list 2,138 0.05 0.00 0 0  
resmgr:schema config 24 0.00   0 0  
row cache objects 15,863,117 0.04 0.00 0 1,088 0.00
rules engine rule set statistics 2,400 0.00   0 0  
sequence cache 5,911 0.00   0 0  
session allocation 43,227,331 0.00 0.00 0 0  
session idle bit 292,117 0.00 0.00 0 0  
session state list latch 2,727 0.00   0 0  
session switching 1,379 0.00   0 0  
session timer 28,948 0.00   0 0  
shared pool 21,043,454 0.00 0.08 0 0  
simulator hash latch 64,890,373 0.00 0.00 0 0  
simulator lru latch 34,234,964 0.18 0.00 0 10,833,856 0.01
slave class 51 0.00   0 0  
slave class create 204 10.78 1.00 1 0  
sort extent pool 3,788 0.00   0 0  
state object free list 48 0.00   0 0  
statistics aggregation 3,360 0.00   0 0  
temp lob duration state obj allocation 10 0.00   0 0  
threshold alerts latch 5,970 0.00   0 0  
transaction allocation 1,419 0.00   0 0  
transaction branch allocation 1,565 0.00   0 0  
undo global data 7,296,202 0.00 0.00 0 0  
user lock 3,048 0.13 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
simulator lru latch 34,234,964 62,453 45 62,408 0 0 0
cache buffers lru chain 14,884,888 58,228 89 58,139 0 0 0
cache buffers chains 1,488,745,447 44,720 751 43,985 0 0 0
enqueue hash chains 11,128,754 14,431 2 14,429 0 0 0
library cache 12,639,933 6,608 21 6,587 0 0 0
enqueues 9,284,950 5,120 1 5,119 0 0 0
object queue header operation 348,753,887 4,327 18 4,309 0 0 0
library cache pin 12,089,532 2,433 2 2,431 0 0 0
redo allocation 223,759 312 1 311 0 0 0
checkpoint queue latch 8,935,490 168 3 165 0 0 0
shared pool 21,043,454 156 12 144 0 0 0
redo writing 294,856 41 2 39 0 0 0
slave class create 204 22 22 0 0 0 0
process allocation 2,030 6 4 2 0 0 0
In memory undo latch 48,818 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 1,519 1,412
cache buffers chains kcbzib: multi-block read: nowait 0 17 0
cache buffers chains kcbrls: kslbegin 0 7 114
cache buffers chains kcbnew: new latch again 0 5 0
cache buffers chains kcbgcur: kslbegin 0 4 5
cache buffers chains kcbzwb 0 4 5
cache buffers chains kcbbic1 0 1 0
cache buffers chains kcbnlc 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 2
cache buffers lru chain kcbzgws 0 80 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 6 0
cache buffers lru chain kcbbwlru 0 2 2
cache buffers lru chain kcbo_write_process:free_unlink 0 1 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3 0
enqueue hash chains ksqgtl3 0 1 0
enqueue hash chains ksqrcl 0 1 2
enqueues ksqgel: create enqueue 0 1 0
library cache kglpndl: child: before processing 0 6 7
library cache kglpin: child: heap processing 0 2 6
library cache kglhdgc: child: 0 1 0
library cache kglobpn: child: 0 1 0
library cache lock kgllkdl: child: no lock handle 0 4 2
library cache pin kglpnc: child 0 1 1
library cache pin kglpndl 0 1 1
object queue header operation kcbo_write_q 0 10 0
object queue header operation kcbo_switch_cq 0 4 4
object queue header operation kcbw_link_q 0 4 3
process allocation ksucrp 0 4 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 1 0
redo writing kcrfsr: rba scn pair 0 2 0
shared pool kghfrunp: clatch: nowait 0 7 0
shared pool kgh: sim resz update 0 5 0
shared pool kghalo 0 3 5
shared pool kgh_next_free 0 1 0
shared pool kghalp 0 1 0
shared pool kghfrunp: alloc: cursor dur 0 1 0
shared pool kghupr1 0 1 2
simulator lru latch kcbs_simulate: simulate set 0 25 31
simulator lru latch kcbs_shrink_pool 0 17 0
simulator lru latch kcbs_free_granule_sim_buffers 0 1 0
simulator lru latch kcbs_lookup_setid 0 1 0
simulator lru latch kcbs_simbufseq 0 1 6
slave class create ksvcreate 0 22 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
CALNAV TS_LOCAL DIM_ORDER_TICKET_TELNUM   TABLE 307,832,528 48.62
CALNAV TS_LOCAL DIM_NUMBER_LIST   TABLE 60,824,240 9.61
CALNAV TS_LOCAL DIM_NUM_FOR_CITY   TABLE 21,680,272 3.42
GR_DWD TS_DWD TMP_LICAL_USER_CALL_LEN   TABLE 19,485,808 3.08
GR_ODS TS_ODS ODS_INCR_QBAR   TABLE 10,376,496 1.64

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
GR_ODS TS_ODS ODS_INCR_QBAR   TABLE 10,278,882 6.30
GR_DWD TS_DWD DWD_BILL_GSM_CALL_201404 PART_02 TABLE PARTITION 3,762,580 2.31
GR_DWD TS_DWD DWD_BILL_GSM_CALL_201403 PART_02 TABLE PARTITION 2,442,461 1.50
GR_DWD TS_DWD DWD_BILL_GSM_CALL_201403 PART_03 TABLE PARTITION 2,284,663 1.40
GR_DWD TS_DWD DWD_BILL_GSM_CALL_201404 PART_30 TABLE PARTITION 2,186,444 1.34

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSTEM IDL_UB2$   TABLE 4 28.57
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY_PK 1032_28649 INDEX PARTITION 2 14.29
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY_PK 1032_28649 INDEX PARTITION 2 14.29
SYS SYSAUX WRH$_FILESTATXS_PK 1032_28649 INDEX PARTITION 2 14.29
SYS SYSAUX WRH$_SEG_STAT_PK 1032_28649 INDEX PARTITION 2 14.29

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

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM JOB$   TABLE 2 100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 1,571 0.00 0   50 1
dc_database_links 1,366 0.00 0   0 8
dc_files 42,672 0.00 0   0 254
dc_global_oids 116,734 0.00 0   0 112
dc_histogram_data 41,464 1.83 0   286 17,510
dc_histogram_defs 43,385 6.32 0   282 18,868
dc_object_grants 1,327 2.49 0   0 203
dc_object_ids 169,227 0.16 0   82 2,704
dc_objects 34,888 1.10 0   421 7,867
dc_profiles 825 0.00 0   0 1
dc_rollback_segments 24,464 0.00 0   0 30
dc_segments 34,885 0.34 0   4,559 21,955
dc_sequences 132 0.00 0   132 11
dc_tablespace_quotas 3,655 0.00 0   1,978 4
dc_tablespaces 3,681,676 0.00 0   0 20
dc_usernames 3,899 0.00 0   0 32
dc_users 1,113,074 0.00 0   0 82
outstanding_alerts 2,064 0.00 0   0 13


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 1,656 0.06 11,382 0.44 49 0
CLUSTER 219 0.00 639 0.16 1 0
INDEX 150 15.33 560 8.04 18 0
JAVA RESOURCE 12 66.67 14 57.14 0 0
JAVA SOURCE 12 66.67 14 57.14 0 0
SQL AREA 1,783 32.81 5,840,637 0.09 3,138 376
TABLE/PROCEDURE 11,963 1.19 160,276 1.80 1,914 0
TRIGGER 1,586 0.50 1,948 0.98 11 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 173.13   6.18 13.19 59 73 28 28
  Freeable 86.25 0.00 5.39 8.63 32   16 16
  SQL 0.80 0.41 0.05 0.04 0 6 17 17
  PL/SQL 0.30 0.13 0.01 0.02 0 0 26 26
E Other 175.33   6.26 13.16 59 73 28 28
  Freeable 87.13 0.00 5.45 8.60 32   16 16
  SQL 0.71 0.37 0.04 0.04 0 240 17 16
  PL/SQL 0.34 0.13 0.01 0.02 0 0 26 26

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 13,774,094,336 13,757,317,120
Fixed Size 2,045,704  
Redo Buffers 14,729,216  
Variable Size 603,982,072 620,759,288

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 22.50   -100.00
shared CCursor 12.23   -100.00
shared Checkpoint queue 5.86   -100.00
shared FileOpenBlock 13.37   -100.00
shared KQR L PO 7.98   -100.00
shared KQR M PO 21.96   -100.00
shared KQR M SO 6.75   -100.00
shared PCursor 7.22   -100.00
shared XDB Schema Cac 7.02   -100.00
shared db_block_hash_buckets 67.25   -100.00
shared enqueue 9.76   -100.00
shared free memory 24.99 ################## ###############
shared kglsim heap 9.04   -100.00
shared kglsim object batch 25.65   -100.00
shared library cache 21.05   -100.00
shared obj stat memo 19.79   -100.00
shared object queue 19.49   -100.00
shared partitioning d 4.96   -100.00
shared private strands 6.93   -100.00
shared row cache 7.13   -100.00
shared sql area 32.19   -100.00
shared state objects 18.07   -100.00
streams free memory 16.00 16.00 0.00
  buffer_cache 13,136.00 13,120.00 -0.12
  fixed_sga 1.95 1.95 0.00
  log_buffer 14.05 14.05 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 298,101 0 0
QMON Slaves 141,773 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

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
enqueue_locks 16 7,100 7100 7100


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/hjfxdb/adump   
background_dump_dest /oracle/admin/hjfxdb/bdump   
compatible 10.2.0.1.0   
control_files /oracle/oradata/hjfxdb/control01.ctl, /oracle/oradata/hjfxdb/control02.ctl, /oracle/oradata/hjfxdb/control03.ctl   
core_dump_dest /oracle/admin/hjfxdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_files 1000   
db_name hjfxdb   
db_recovery_file_dest /oracle/hjfxdata3/hjfxdb/flash_recovery_area   
db_recovery_file_dest_size 322122547200   
dispatchers (PROTOCOL=TCP) (SERVICE=hjfxdbXDB)   
job_queue_processes 10   
log_archive_format %t_%s_%r.dbf   
log_archive_start TRUE   
open_cursors 1000   
pga_aggregate_target 4794089472   
processes 300   
remote_login_passwordfile EXCLUSIVE   
sessions 500   
sga_target 14394851328   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/hjfxdb/udump   


Back to Top

End of Report