WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
HJFXDB1975301032hjfxdb110.2.0.1.0NOhjfxdb2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2868705-May-14 00:00:3926 2.0
End Snap:2869705-May-14 10:00:5528 2.4
Elapsed:  600.26 (mins)  
DB Time:  303.77 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 15,291.86 884,026.40
Logical reads: 2,224.36 128,591.09
Block changes: 14.70 849.74
Physical reads: 759.18 43,888.55
Physical writes: 3.55 205.38
User calls: 0.79 45.76
Parses: 31.44 1,817.43
Hard parses: 0.03 1.46
Sorts: 6.83 395.04
Logons: 0.01 0.74
Executes: 35.79 2,068.83
Transactions: 0.02 

% Blocks changed per Read: 0.66Recursive Call %: 99.89
Rollback per transaction %: 0.00Rows per Sort: 358.85

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98Redo NoWait %: 100.00
Buffer Hit %: 65.90In-memory Sort %: 100.00
Library Hit %: 99.89Soft Parse %: 99.92
Execute to Parse %: 12.15Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 0.07% Non-Parse CPU: 99.79

Shared Pool Statistics

BeginEnd
Memory Usage %:##################################
% SQL with executions>1: 90.22 83.37
% Memory for SQL w/exec>1: 85.14 71.25

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  3,669  20.1 
db file scattered read 1,727,364 3,288 2 18.0User I/O
db file sequential read 1,167,745 1,034 1 5.7User I/O
control file parallel write 12,649 106 8 .6System I/O
db file parallel write 2,240 99 44 .5System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed 10,568.98 57.99
hard parse elapsed time 10,554.78 57.91
failed parse elapsed time 10,548.44 57.88
sql execute elapsed time 7,686.82 42.17
DB CPU 3,668.63 20.13
inbound PL/SQL rpc elapsed time 30.88 0.17
PL/SQL execution elapsed time 16.31 0.09
connection management call elapsed time 1.11 0.01
PL/SQL compilation elapsed time 0.96 0.01
hard parse (sharing criteria) elapsed time 0.21 0.00
sequence load elapsed time 0.02 0.00
RMAN cpu time (backup/restore) 0.01 0.00
repeated bind elapsed time 0.00 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 18,226.16  
background elapsed time 371.44  
background cpu time 51.09  

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 2,915,113 0.00 4,400 2 4,679.15
System I/O 1,494,220 0.00 285 0 2,398.43
Commit 427 0.00 7 16 0.69
Configuration 96 31.25 6 60 0.15
Network 75,642 0.00 4 0 121.42
Concurrency 169 0.00 3 17 0.27
Other 459 0.00 2 4 0.74
Application 517 0.00 1 2 0.83

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 1,727,364 0.00 3,288 2 2,772.65
db file sequential read 1,167,745 0.00 1,034 1 1,874.39
control file parallel write 12,649 0.00 106 8 20.30
db file parallel write 2,240 0.00 99 44 3.60
read by other session 16,303 0.00 71 4 26.17
log file parallel write 3,591 0.00 67 19 5.76
control file sequential read 1,474,551 0.00 8 0 2,366.86
log file sync 427 0.00 7 16 0.69
log buffer space 64 3.13 5 85 0.10
direct path write temp 999 0.00 5 5 1.60
log file sequential read 495 0.00 4 7 0.79
SQL*Net more data to client 16,139 0.00 4 0 25.91
os thread startup 64 0.00 3 45 0.10
db file parallel read 7 0.00 2 240 0.01
enq: RO - fast object reuse 63 0.00 1 20 0.10
rdbms ipc reply 288 0.00 1 4 0.46
SQL*Net more data from dblink 32,524 0.00 1 0 52.21
local write wait 75 0.00 1 9 0.12
recovery area: computing obsolete files 2 0.00 1 300 0.00
Log archive I/O 584 0.00 0 1 0.94
log file switch completion 3 0.00 0 91 0.00
latch free 11 0.00 0 16 0.02
control file single write 106 0.00 0 2 0.17
direct path write 372 0.00 0 0 0.60
direct path read 964 0.00 0 0 1.55
log file single write 4 0.00 0 8 0.01
SQL*Net break/reset to client 454 0.00 0 0 0.73
direct path read temp 1,284 0.00 0 0 2.06
SQL*Net more data from client 151 0.00 0 0 0.24
SQL*Net message to client 26,250 0.00 0 0 42.13
LGWR wait for redo copy 92 0.00 0 0 0.15
reliable message 52 0.00 0 0 0.08
latch: cache buffers lru chain 3 0.00 0 1 0.00
enq: CF - contention 1 0.00 0 2 0.00
latch: cache buffers chains 97 0.00 0 0 0.16
latch: object queue header operation 1 0.00 0 1 0.00
recovery area: computing dropped files 2 0.00 0 0 0.00
recovery area: computing backed up files 2 0.00 0 0 0.00
latch: library cache 2 0.00 0 0 0.00
SQL*Net message to dblink 574 0.00 0 0 0.92
recovery area: computing identical files 2 0.00 0 0 0.00
recovery area: computing applied logs 2 0.00 0 0 0.00
buffer busy waits 5 0.00 0 0 0.01
SQL*Net more data to dblink 4 0.00 0 0 0.01
latch: redo writing 1 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 0 0.00
undo segment extension 28 100.00 0 0 0.04
latch: checkpoint queue latch 1 0.00 0 0 0.00
virtual circuit status 1,201 100.00 35,068 29199 1.93
Streams AQ: qmn slave idle wait 1,286 0.00 35,036 27244 2.06
Streams AQ: qmn coordinator idle wait 2,576 50.08 35,036 13601 4.13
Streams AQ: waiting for time management or cleanup tasks 8 100.00 13,411 1676419 0.01
SQL*Net message from client 26,248 0.00 5,885 224 42.13
jobq slave wait 873 98.05 2,540 2909 1.40
class slave wait 21 100.00 103 4883 0.03
SQL*Net message from dblink 574 0.00 46 79 0.92
single-task message 8 0.00 0 49 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 12,437 0.00 104 8 19.96
db file parallel write 2,240 0.00 99 44 3.60
log file parallel write 3,592 0.00 67 19 5.77
log file sequential read 495 0.00 4 7 0.79
os thread startup 64 0.00 3 45 0.10
db file sequential read 2,066 0.00 1 0 3.32
control file sequential read 17,259 0.00 0 0 27.70
Log archive I/O 584 0.00 0 1 0.94
direct path write 246 0.00 0 0 0.39
direct path read 960 0.00 0 0 1.54
log file single write 4 0.00 0 8 0.01
events in waitclass Other 108 0.00 0 0 0.17
latch: redo writing 1 0.00 0 0 0.00
buffer busy waits 1 0.00 0 0 0.00
rdbms ipc message 130,500 98.01 412,221 3159 209.47
pmon timer 12,064 100.00 35,156 2914 19.36
Streams AQ: qmn slave idle wait 1,286 0.00 35,036 27244 2.06
Streams AQ: qmn coordinator idle wait 2,576 50.08 35,036 13601 4.13
smon timer 230 49.13 33,863 147229 0.37
Streams AQ: waiting for time management or cleanup tasks 8 100.00 13,411 1676419 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 41,998
AVG_IDLE_TIME 3,562,584
AVG_IOWAIT_TIME 46,710
AVG_SYS_TIME 13,445
AVG_USER_TIME 27,825
BUSY_TIME 518,336
IDLE_TIME 42,764,083
IOWAIT_TIME 574,340
SYS_TIME 174,641
USER_TIME 343,695
LOAD 0
OS_CPU_WAIT_TIME 871,000
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 10,940.20 384.40 1,901,663 1,989,390
SYS$USERS 7,280.10 3,284.00 25,427,513 77,289,222
SYS$BACKGROUND 0.00 0.00 12,846 832,922
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 121102 4186 0 0 0 0 28467 17
SYS$USERS 2780365 433742 104 1 0 0 46273 403
SYS$BACKGROUND 13642 2079 65 290 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,199 1,099 1 4199.22 23.04 8sm24w69k96dm SQL*Plus declare iv_date varchar2...
1,888 1,764 1 1887.75 10.36 g6b46bn5x3mtt SQL*Plus declare iv_date varchar2...
1,216 374 1 1216.38 6.67 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
1,208 257 1 1208.01 6.63 frw8vh6vd4458 SQL*Plus INSERT /*+APPEND */ INTO DM...
930 930 1 930.44 5.10 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
769 724 35,741 0.02 4.22 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
769 724 35,711 0.02 4.22 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
647 125 20 32.33 3.55 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
553 142 1 553.46 3.04 fn1cfbx3gj568 SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
532 532 1 532.36 2.92 7k4vyptuvcsx2 SQL*Plus INSERT INTO MID_DW_YYGH_USER_R...
530 133 1 529.83 2.91 4q30phyuzpatb SQL*Plus INSERT /*+APPEND */ INTO ...
377 2 1 376.82 2.07 551zps0xw2mt1 SQL*Plus INSERT /*+APPEND */ INTO DW_CU...
219 219 1 218.85 1.20 9vsgtggtbrgn2 SQL*Plus INSERT INTO MID_DW_YYGH_ORDER_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,764 1,888 1 1763.77 10.36 g6b46bn5x3mtt SQL*Plus declare iv_date varchar2...
1,099 4,199 1 1099.43 23.04 8sm24w69k96dm SQL*Plus declare iv_date varchar2...
930 930 1 930.44 5.10 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
724 769 35,741 0.02 4.22 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
724 769 35,711 0.02 4.22 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
532 532 1 532.13 2.92 7k4vyptuvcsx2 SQL*Plus INSERT INTO MID_DW_YYGH_USER_R...
374 1,216 1 373.50 6.67 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
257 1,208 1 257.00 6.63 frw8vh6vd4458 SQL*Plus INSERT /*+APPEND */ INTO DM...
219 219 1 218.79 1.20 9vsgtggtbrgn2 SQL*Plus INSERT INTO MID_DW_YYGH_ORDER_...
142 553 1 142.08 3.04 fn1cfbx3gj568 SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
133 530 1 133.10 2.91 4q30phyuzpatb SQL*Plus INSERT /*+APPEND */ INTO ...
125 647 20 6.23 3.55 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
2 377 1 1.73 2.07 551zps0xw2mt1 SQL*Plus INSERT /*+APPEND */ INTO DW_CU...

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
46,514,500 1 46,514,500.00 58.06 1763.77 1887.75 g6b46bn5x3mtt SQL*Plus declare iv_date varchar2...
23,821,267 1 23,821,267.00 29.73 930.44 930.44 fnhtmkf5j3n7r SQL*Plus INSERT INTO MID_ODS_YYGH_ORDER...
21,856,623 1 21,856,623.00 27.28 1099.43 4199.22 8sm24w69k96dm SQL*Plus declare iv_date varchar2...
19,586,068 35,741 548.00 24.45 724.08 769.36 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
19,569,628 35,711 548.00 24.43 723.99 768.61 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
12,921,605 1 12,921,605.00 16.13 532.13 532.36 7k4vyptuvcsx2 SQL*Plus INSERT INTO MID_DW_YYGH_USER_R...
8,648,731 1 8,648,731.00 10.80 373.50 1216.38 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
5,534,789 1 5,534,789.00 6.91 218.79 218.85 9vsgtggtbrgn2 SQL*Plus INSERT INTO MID_DW_YYGH_ORDER_...
5,243,107 1 5,243,107.00 6.54 257.00 1208.01 frw8vh6vd4458 SQL*Plus INSERT /*+APPEND */ INTO DM...
4,427,262 1,106,841 4.00 5.53 29.87 29.87 2ym6hhaq30r73   select type#, blocks, extents,...
3,856,385 20 192,819.25 4.81 124.51 646.57 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
2,639,336 1 2,639,336.00 3.29 142.08 553.46 fn1cfbx3gj568 SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
2,533,174 1 2,533,174.00 3.16 133.10 529.83 4q30phyuzpatb SQL*Plus INSERT /*+APPEND */ INTO ...
2,351,938 10 235,193.80 2.94 61.71 132.44 5k76jf9k4kd0v   DECLARE job BINARY_INTEGER := ...
2,306,491 10 230,649.10 2.88 61.20 131.91 d65ypzjzr3y68   INSERT INTO GR_ODS.MONITOR_DB_...
1,373,439 9,128 150.46 1.71 64.04 67.08 95un34c4r1fjn SQL*Plus SELECT COUNT(T.FLAG) FROM DIM_...
1,372,968 9,127 150.43 1.71 64.09 67.19 b44x8s2nj3970 SQL*Plus SELECT T.FLAG FROM DIM_NUMBER_...
809,367 1 809,367.00 1.01 21.18 35.18 70vhar7t3j8mk SQL*Plus INSERT INTO YSTONG_USER_INFO_2...

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
21,372,481 1 21,372,481.00 78.17 1099.43 4199.22 8sm24w69k96dm SQL*Plus declare iv_date varchar2...
8,629,354 1 8,629,354.00 31.56 373.50 1216.38 6gwmxvc9g5yvz SQL*Plus INSERT /*+APPEND */ INTO DW_CA...
5,225,613 1 5,225,613.00 19.11 257.00 1208.01 frw8vh6vd4458 SQL*Plus INSERT /*+APPEND */ INTO DM...
2,644,233 1 2,644,233.00 9.67 142.08 553.46 fn1cfbx3gj568 SQL*Plus INSERT INTO MID_ACTIVE_USER_Y ...
2,515,753 1 2,515,753.00 9.20 133.10 529.83 4q30phyuzpatb SQL*Plus INSERT /*+APPEND */ INTO ...
1,696,149 1 1,696,149.00 6.20 1763.77 1887.75 g6b46bn5x3mtt SQL*Plus declare iv_date varchar2...
808,929 1 808,929.00 2.96 21.18 35.18 70vhar7t3j8mk SQL*Plus INSERT INTO YSTONG_USER_INFO_2...
713,798 20 35,689.90 2.61 124.51 646.57 dzffdpu58dqgv SQL*Plus SELECT A.TABLESPACE_NAME||'|'|...
635,933 1 635,933.00 2.33 15.35 15.35 a0a6fjw2x8g15 SQL*Plus INSERT /*+APPEND */ INTO MID_D...
635,071 1 635,071.00 2.32 23.05 69.55 2yw1anskyaa07 SQL*Plus INSERT INTO MID_CUSTBEF_DEV_US...
634,271 1 634,271.00 2.32 11.21 11.21 9ysfzqvsrfbb8 SQL*Plus DELETE FROM DW_CUSTBEF_USER_IN...
446,919 1 446,919.00 1.63 11.85 27.57 1qacyj3mdktyw SQL*Plus DELETE FROM DW_YYGH_NUMBER_SOU...
377,198 10 37,719.80 1.38 61.71 132.44 5k76jf9k4kd0v   DECLARE job BINARY_INTEGER := ...
377,195 10 37,719.50 1.38 61.20 131.91 d65ypzjzr3y68   INSERT INTO GR_ODS.MONITOR_DB_...
289,236 1 289,236.00 1.06 27.78 35.52 6nfum9v59f80u SQL*Plus DELETE FROM ODS_YYGH_NUMBER_SO...
289,055 1 289,055.00 1.06 5.17 5.17 8nvcgangwkdsp SQL*Plus SELECT COUNT(T.NUM_114) FROM O...

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
1,106,841 1,106,779 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
35,741 35,741 1.00 0.00 0.00 2a76zc3gmuu58 SQL*Plus SELECT COUNT(T.FLAG) FROM DIM_...
35,741 35,741 1.00 0.02 0.02 drfyzt9x73p5z SQL*Plus SELECT COUNT(T.CITY_ID) FROM D...
35,711 35,711 1.00 0.02 0.02 8mxcwt4vvs1db SQL*Plus SELECT T.CITY_ID FROM DIM_NUM_...
9,128 9,128 1.00 0.01 0.01 95un34c4r1fjn SQL*Plus SELECT COUNT(T.FLAG) FROM DIM_...
9,127 9,127 1.00 0.01 0.01 b44x8s2nj3970 SQL*Plus SELECT T.FLAG FROM DIM_NUMBER_...
3,594 11 0.00 0.00 0.00 803b7z0t84sq7   select job, nvl2(last_date, ...
3,583 3,583 1.00 0.00 0.00 g2wr3u7s1gtf3   select count(*) from sys.job$ ...
2,148 1,620 0.75 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
1,695 4,390 2.59 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,106,840 1,106,841 97.76 2ym6hhaq30r73   select type#, blocks, extents,...
1,695 1,695 0.15 0h6b2sajwb74n   select privilege#, level from ...
1,357 1,357 0.12 bsa0wjtftg3uw   select file# from file$ where ...
1,250 1,250 0.11 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
1,124 1,124 0.10 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
1,124 1,124 0.10 g00cj285jmgsw   update sys.mon_mods$ set inser...
1,001 1,001 0.09 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
528 528 0.05 8km6u41w6z1yy   select STATSTYPE# from USTATS$...
418 418 0.04 49s332uhbnsma   declare vsn va...
410 870 0.04 3c1kubcdjnppq   update sys.col_usage$ set eq...

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
420 106 afy6x9s4h317u SQL*Plus INSERT INTO TB_114_SYS_LOG ( T...
225 35 bdv0rkkssq2jm PL/SQL Developer SELECT count(*) FROM user_poli...
225 35 bdv0rkkssq2jm PL/SQL Developer SELECT count(*) FROM user_poli...
224 35 fy9ta5zgkwqmp PL/SQL Developer SELECT count(*) FROM user_poli...
224 35 fy9ta5zgkwqmp PL/SQL Developer SELECT count(*) FROM user_poli...

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
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1qacyj3mdktywDELETE FROM DW_YYGH_NUMBER_SOURCE T WHERE T.STATICE_TIME=:B1
2a76zc3gmuu58SELECT COUNT(T.FLAG) FROM DIM_NUM_SUB_CARRIER T WHERE T.SUB_NUM = SUBSTR(:B1 , 1, 3)
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
2yw1anskyaa07INSERT INTO MID_CUSTBEF_DEV_USER NOLOGGING SELECT DISTINCT A.CALLING_NO, A.FLAG_114, A.FLAG_116114, A.FLAG_OTHER, A.CALL_114_CNT, A.CALL_116_CNT, A.CALL_OTH_CNT, A.CALL_114_TIME, A.CALL_116_TIME, A.CALL_OTH_TIME, (CASE WHEN B.CITY_ID IS NULL THEN '1' ELSE '0' END) FROM MID_CUSTBEF_ACTIVE_USER A, (SELECT CALLING_NO, CITY_ID FROM DW_CUSTBEF_USER_INFO_DAILY T WHERE T.CREATE_DATE<:B1 ) B WHERE A.CALLING_NO=B.CALLING_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
49s332uhbnsma declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end;
4q30phyuzpatb INSERT /*+APPEND */ INTO DW_CUSTBEF_ACTIVE_USER_Y2014 NOLOGGING SELECT '201405', '04', '20140504', 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=20140504
551zps0xw2mt1INSERT /*+APPEND */ INTO DW_CUSTBEF_USER_INFO_DAILY NOLOGGING SELECT T.CALLING_NO , T.CARRIER_TYPE, T.CITY_ID , T.DISTRICT_ID , T.CUST_TYPE , T.CUST_LEVEL , T.NUMBER_TYPE , :B1 CREATE_DATE, :B1 UPDATE_DATE , T.FLAG_114 , T.FLAG_116114 , T.FLAG_OTHER , NULL REMARK1 , NULL REMARK2 , NULL REMARK3 , NULL REMARK4 , NULL REMARK5 , SYSDATE INSERT_DATE FROM DW_CUSTBEF_ACTIVE_USER_D T WHERE T.STATICE_TIME=:B1 AND T.FLAG_NEW='1'
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;
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
6nfum9v59f80uDELETE FROM ODS_YYGH_NUMBER_SOURCE T WHERE T.DATA_TIME=TO_CHAR(TO_DATE(:B1 , 'yyyymmdd')+1, 'yyyymmdd')
70vhar7t3j8mk INSERT INTO YSTONG_USER_INFO_20140504 NOLOGGING SELECT STATICE_DATE, DEVICE_NO, CUST_NAME, PRE_FLAG, BRAND, GENDER, BIRTHDAY FROM (SELECT A.STATICE_DATE STATICE_DATE, A.DEVICE_NO DEVICE_NO, REPLACE(C.CUSTNAME, ' ', '') CUST_NAME, CASE WHEN D.SVCTYPE IN ('GD', 'GE', 'GM', 'GP', 'GW') AND D.PREFEEFLAG = '0' THEN '1' --'3Gºó¸¶·Ñ' WHEN D.SVCTYPE IN ('GD', 'GE', 'GM', 'GP', 'GW') AND D.PREFEEFLAG = '1' THEN '3' --'3GÔ¤¸¶·Ñ' WHEN D.SVCTYPE NOT IN ('GD', 'GE', 'GM', 'GP', 'GW') AND D.PREFEEFLAG = '0' THEN '2' --'2Gºó¸¶·Ñ' WHEN D.SVCTYPE NOT IN ('GD', 'GE', 'GM', 'GP', 'GW') AND D.PREFEEFLAG = '1' THEN '4' --'2GÔ¤¸¶·Ñ' ELSE '0' --'ÆäËû' END PRE_FLAG, B.BRAND BRAND, CASE WHEN C.CERTTYPE = '0' AND LENGTH(C.CERTNUM) = 18 AND LENGTH(C.CUSTNAME) < 5 AND SUBSTR(C.CERTNUM, 17, 1) IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '0') THEN MOD(SUBSTR(C.CERTNUM, 17, 1), 2) WHEN C.CERTTYPE = '0' AND LENGTH(C.CERTNUM) = 15 AND LENGTH(C.CUSTNAME) < 5 AND SUBSTR(C.CERTNUM, -1, 1) IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '0') THEN MOD(SUBSTR(C.CERTNUM, -1, 1), 2) WHEN C.CERTTYPE = '0' AND LENGTH(C.CERTNUM) = 15 AND LENGTH(C.CUSTNAME) < 5 AND UPPER(SUBSTR(C.CERTNUM, -1, 1)) = 'X' THEN 0 ELSE NULL END GENDER, CASE WHEN C.CERTTYPE = '0' AND LENGTH(C.CUSTNAME) < 5 AND LENGTH(C.CERTNUM) = 18 THEN SUBSTR(C.CERTNUM, 7, 8) WHEN C.CERTTYPE = '0' AND LENGTH(C.CUSTNAME) < 5 AND LENGTH(C.CERTNUM) = 15 THEN '19' || SUBSTR(C.CERTNUM, 7, 6) ELSE NULL END BIRTHDAY, ROW_NUMBER() OVER(PARTITION BY B.SVCNUM ORDER BY B.OPENDATE DESC) RN FROM YSTONG_UP_USERNO_20140504 A, ODS_GSM_USER_INFO B, ODS_GSM_CUST_INFO C, GR_DIM.DIM_GSM_SVCTYPE D WHERE A.DEVICE_NO = B.SVCNUM(+) AND B.CUSTID = C.CUSTID AND B.SVCTYPE = D.SVCTYPE) WHERE RN = 1
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)
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
8km6u41w6z1yyselect STATSTYPE# from USTATS$ where OBJ# = :1 and INTCOL# = :2
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)
8nvcgangwkdspSELECT COUNT(T.NUM_114) FROM ODS_YYGH_NUMBER_SOURCE T WHERE T.STATICE_TIME=:B1 AND T.NUM_114 IS NULL
8sm24w69k96dmdeclare iv_date varchar2(200); io_return varchar2(200); begin iv_date :=20140504; SP_114_CUST_BEFORE_RUN(iv_date, io_return); commit; end;
95un34c4r1fjnSELECT COUNT(T.FLAG) FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND ROWNUM<2
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
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
9vsgtggtbrgn2INSERT INTO MID_DW_YYGH_ORDER_FAIL NOLOGGING ( STATICE_TIME, STATICE_MONTH, FAIL_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.FAIL_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_ODS_YYGH_ORDER_FAIL T
9ysfzqvsrfbb8DELETE FROM DW_CUSTBEF_USER_INFO_DAILY NOLOGGING WHERE CREATE_DATE=:B1
a0a6fjw2x8g15INSERT /*+APPEND */ INTO MID_DW_USER_INFO_HISTORY NOLOGGING SELECT A.CALLING_NO , A.CARRIER_TYPE, A.CITY_ID , A.DISTRICT_ID , A.CUST_TYPE , A.CUST_LEVEL , A.NUMBER_TYPE , B.CREATE_DATE CREATE_DATE, :B1 UPDATE_DATE , A.FLAG_114 , A.FLAG_116114 , A.FLAG_OTHER FROM (SELECT * FROM DW_CUSTBEF_ACTIVE_USER_D T WHERE T.STATICE_TIME=:B1 AND T.FLAG_NEW='0' ) A, (SELECT * FROM DW_CUSTBEF_USER_INFO_DAILY WHERE CREATE_DATE<:B1 ) B WHERE A.CALLING_NO=B.CALLING_NO(+) AND A.CITY_ID<>B.CITY_ID
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 )
b44x8s2nj3970SELECT T.FLAG FROM DIM_NUMBER_LIST T WHERE T.SEGMENT_ID = SUBSTR(:B1 , 1, 4) AND ROWNUM<2
bdv0rkkssq2jmSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'
bsa0wjtftg3uwselect file# from file$ where ts#=:1
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
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
fn1cfbx3gj568INSERT INTO MID_ACTIVE_USER_Y NOLOGGING SELECT CALLING_NO FROM DW_CUSTBEF_ACTIVE_USER_D T WHERE T.STATICE_TIME=20140504 MINUS SELECT CALLING_NO FROM DW_CUSTBEF_ACTIVE_USER_Y2014 A WHERE STATICE_TIME<=20140504
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
frw8vh6vd4458 INSERT /*+APPEND */ INTO DM_CUST_BEFORE_VOLUME_USER_D NOLOGGING SELECT 20140504, 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=20140504 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<=04 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<=20140504 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
fy9ta5zgkwqmpSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'
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
g2wr3u7s1gtf3select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
g6b46bn5x3mttdeclare iv_date varchar2(200); oi_return varchar2(200); begin iv_date :=20140504; 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;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 368,958 10.24 592.23
CPU used when call started 360,339 10.01 578.39
CR blocks created 1,336 0.04 2.14
Cached Commit SCN referenced 8,648,735 240.14 13,882.40
Commit SCN cached 4,048 0.11 6.50
DB time 2,105,506 58.46 3,379.62
DBWR checkpoint buffers written 39,801 1.11 63.89
DBWR checkpoints 64 0.00 0.10
DBWR object drop buffers written 117 0.00 0.19
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 455 0.01 0.73
DBWR undo block writes 5,471 0.15 8.78
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 131 0.00 0.21
IMU Redo allocation size 1,229,300 34.13 1,973.19
IMU commits 466 0.01 0.75
IMU contention 0 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 2 0.00 0.00
IMU undo allocation size 3,571,888 99.18 5,733.37
IMU- failed to get a private strand 0 0.00 0.00
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 5 0.00 0.01
SQL*Net roundtrips to/from client 25,353 0.70 40.70
SQL*Net roundtrips to/from dblink 574 0.02 0.92
active txn count during cleanout 6,015 0.17 9.65
application wait time 127 0.00 0.20
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 127,921 3.55 205.33
branch node splits 1 0.00 0.00
buffer is not pinned count 1,815,126 50.40 2,913.52
buffer is pinned count 2,728,993 75.77 4,380.41
bytes received via SQL*Net from client 2,215,212 61.51 3,555.72
bytes received via SQL*Net from dblink 65,565,558 1,820.47 105,241.67
bytes sent via SQL*Net to client 43,158,267 1,198.31 69,274.91
bytes sent via SQL*Net to dblink 67,126 1.86 107.75
calls to get snapshot scn: kcmgss 3,144,272 87.30 5,046.99
calls to kcmgas 1,105,498 30.69 1,774.48
calls to kcmgcs 8,864 0.25 14.23
change write time 812 0.02 1.30
cleanout - number of ktugct calls 10,538 0.29 16.91
cleanouts and rollbacks - consistent read gets 3 0.00 0.00
cleanouts only - consistent read gets 4,189 0.12 6.72
cluster key scan block gets 1,170,906 32.51 1,879.46
cluster key scans 1,121,404 31.14 1,800.01
commit batch performed 1 0.00 0.00
commit batch requested 1 0.00 0.00
commit batch/immediate performed 3 0.00 0.00
commit batch/immediate requested 3 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 260 0.01 0.42
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 40,841 1.13 65.56
commit cleanouts successfully completed 40,581 1.13 65.14
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 4,889 0.14 7.85
concurrency wait time 290 0.01 0.47
consistent changes 2,145 0.06 3.44
consistent gets 79,270,808 2,201.00 127,240.46
consistent gets - examination 3,788,633 105.19 6,081.27
consistent gets direct 13 0.00 0.02
consistent gets from cache 79,270,795 2,201.00 127,240.44
current blocks converted for CR 0 0.00 0.00
cursor authentications 217 0.01 0.35
data blocks consistent reads - undo records applied 2,101 0.06 3.37
db block changes 529,391 14.70 849.74
db block gets 841,440 23.36 1,350.63
db block gets direct 50,085 1.39 80.39
db block gets from cache 791,355 21.97 1,270.23
deferred (CURRENT) block cleanout applications 27,399 0.76 43.98
dirty buffers inspected 14,058 0.39 22.57
enqueue conversions 8,804 0.24 14.13
enqueue releases 1,581,541 43.91 2,538.59
enqueue requests 1,581,546 43.91 2,538.60
enqueue timeouts 1 0.00 0.00
enqueue waits 56 0.00 0.09
execute count 1,288,879 35.79 2,068.83
frame signature mismatch 0 0.00 0.00
free buffer inspected 26,835,064 745.09 43,073.94
free buffer requested 27,336,163 759.00 43,878.27
global undo segment hints helped 0 0.00 0.00
heap block compress 448 0.01 0.72
hot buffers moved to head of LRU 961,385 26.69 1,543.15
immediate (CR) block cleanout applications 4,192 0.12 6.73
immediate (CURRENT) block cleanout applications 3,164 0.09 5.08
index fast full scans (full) 4 0.00 0.01
index fetch by key 3,150,484 87.48 5,056.96
index scans kdiixs1 161,573 4.49 259.35
leaf node 90-10 splits 271 0.01 0.43
leaf node splits 419 0.01 0.67
lob reads 2,938 0.08 4.72
lob writes 305 0.01 0.49
lob writes unaligned 305 0.01 0.49
logons cumulative 463 0.01 0.74
messages received 47,201 1.31 75.76
messages sent 47,201 1.31 75.76
no buffer to keep pinned count 1 0.00 0.00
no work - consistent read gets 73,435,781 2,038.99 117,874.45
opened cursors cumulative 1,137,377 31.58 1,825.65
parse count (failures) 147 0.00 0.24
parse count (hard) 911 0.03 1.46
parse count (total) 1,132,259 31.44 1,817.43
parse time cpu 787 0.02 1.26
parse time elapsed 1,081,827 30.04 1,736.48
physical read IO requests 2,894,848 80.38 4,646.63
physical read bytes ############### 6,219,224.22 359,535,019.35
physical read total IO requests 4,372,870 121.42 7,019.05
physical read total bytes ############### 6,995,990.30 404,440,074.68
physical read total multi block requests 1,732,353 48.10 2,780.66
physical reads 27,342,568 759.18 43,888.55
physical reads cache 27,319,858 758.55 43,852.10
physical reads cache prefetch 24,427,621 678.25 39,209.66
physical reads direct 22,710 0.63 36.45
physical reads direct (lob) 4 0.00 0.01
physical reads direct temporary tablespace 21,737 0.60 34.89
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 47,769 1.33 76.68
physical write bytes 1,048,199,168 29,103.87 1,682,502.68
physical write total IO requests 93,805 2.60 150.57
physical write total bytes 3,422,818,816 95,036.60 5,494,091.20
physical write total multi block requests 18,162 0.50 29.15
physical writes 127,954 3.55 205.38
physical writes direct 72,068 2.00 115.68
physical writes direct (lob) 9 0.00 0.01
physical writes direct temporary tablespace 21,737 0.60 34.89
physical writes from cache 55,886 1.55 89.70
physical writes non checkpoint 115,203 3.20 184.92
pinned buffers inspected 19 0.00 0.03
prefetch clients - default 10,506 0.29 16.86
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 41,403 1.15 66.46
queries parallelized 0 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive calls 26,068,796 723.82 41,843.97
recursive cpu usage 313,629 8.71 503.42
redo blocks read for recovery 0 0.00 0.00
redo blocks written 1,111,506 30.86 1,784.12
redo buffer allocation retries 67 0.00 0.11
redo entries 335,789 9.32 538.99
redo log space requests 3 0.00 0.00
redo log space wait time 28 0.00 0.04
redo ordering marks 5,616 0.16 9.01
redo size 550,748,448 15,291.86 884,026.40
redo synch time 681 0.02 1.09
redo synch writes 8,747 0.24 14.04
redo wastage 900,348 25.00 1,445.18
redo write time 6,908 0.19 11.09
redo writer latching time 1 0.00 0.00
redo writes 3,591 0.10 5.76
rollback changes - undo records applied 4 0.00 0.01
rollbacks only - consistent read gets 1,291 0.04 2.07
rows fetched via callback 157,744 4.38 253.20
session connect time 0 0.00 0.00
session cursor cache hits 1,125,489 31.25 1,806.56
session logical reads 80,112,248 2,224.36 128,591.09
session pga memory 127,109,088 3,529.26 204,027.43
session pga memory max 292,653,024 8,125.69 469,748.03
session uga memory ############### 5,011,228.49 289,700,462.30
session uga memory max 1,146,678,592 31,838.21 1,840,575.59
shared hash latch upgrades - no wait 161,820 4.49 259.74
shared hash latch upgrades - wait 2 0.00 0.00
sorts (disk) 1 0.00 0.00
sorts (memory) 246,112 6.83 395.04
sorts (rows) 88,316,507 2,452.16 141,760.04
sql area purged 53 0.00 0.09
summed dirty queue length 19,146 0.53 30.73
switch current to new buffer 1,366 0.04 2.19
table fetch by rowid 376,514 10.45 604.36
table fetch continued row 524 0.01 0.84
table scan blocks gotten 71,986,623 1,998.75 115,548.35
table scan rows gotten 7,873,068,017 218,600.41 12,637,348.34
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 40 0.00 0.06
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 146,029 4.05 234.40
total number of times SMON posted 117 0.00 0.19
transaction rollbacks 3 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 35,920,236 997.35 57,656.88
user I/O wait time 440,045 12.22 706.33
user calls 28,506 0.79 45.76
user commits 623 0.02 1.00
user rollbacks 0 0.00 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 6 0.00 0.01
workarea executions - optimal 236,811 6.58 380.11
write clones created in background 75 0.00 0.12
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 2,327,303 2,332,737
opened cursors current 51 67
workarea memory allocated 525 82,306
logons current 26 28

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 0.10

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_LOCAL 1,698,838 47 2.18 13.78 37,941 1 5,441 4.12
USERS 977,079 27 0.48 1.00 18 0 10,322 4.61
TS_DWD 122,818 3 2.83 15.49 683 0 6 0.00
TS_ODS 58,294 2 0.61 15.46 78 0 2 0.00
TS_DW 17,048 0 2.52 6.31 70 0 182 6.15
SYSAUX 7,100 0 1.85 1.28 4,325 0 0 0.00
EBUSINESS 8,290 0 0.50 1.00 1 0 342 4.97
SYSTEM 3,698 0 1.77 1.00 1,164 0 0 0.00
UNDOTBS1 42 0 3.81 1.00 2,644 0 4 0.00
TEMP 1,284 0 1.32 16.93 841 0 0 0.00
TS_DIM 144 0 1.32 2.26 2 0 5 4.00
TS_DM 87 0 0.80 1.00 1 0 4 5.00
TS_RPT 3 0 6.67 1.00 1 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 8,290 0 0.50 1.00 1 0 342 4.97
SYSAUX /oracle/hjfxdata2/hjfxdb/ts_local012.dbf 1,014 0 1.50 1.12 437 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/sysaux01.dbf 3,296 0 2.18 1.41 2,468 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/ts_local008.dbf 1,462 0 1.87 1.20 1,025 0 0 0.00
SYSAUX /oracle/oradata/hjfxdb/ts_local010.dbf 1,328 0 1.29 1.13 395 0 0 0.00
SYSTEM /oracle/hjfxdata2/hjfxdb/system02.dbf 482 0 4.61 1.00 153 0 0 0.00
SYSTEM /oracle/oradata/hjfxdb/system01.dbf 3,216 0 1.35 1.00 1,011 0 0 0.00
TEMP /oracle/oradata/hjfxdb/temp01.dbf 1,284 0 1.32 16.93 841 0 0  
TS_DIM /oracle/oradata/zzdb/ts_dim01.dbf 144 0 1.32 2.26 2 0 5 4.00
TS_DM /oracle/oradata/zzdb/ts_dm01.dbf 87 0 0.80 1.00 1 0 4 5.00
TS_DW /oracle/hjfxdata/zzdb/ts_dw05.dbf 1,995 0 2.81 6.39 13 0 14 8.57
TS_DW /oracle/hjfxdata/zzdb/ts_dw06.dbf 2,232 0 2.52 6.15 18 0 25 6.00
TS_DW /oracle/hjfxdata/zzdb/ts_dw07.dbf 1,921 0 2.77 7.44 1 0 10 6.00
TS_DW /oracle/hjfxdata/zzdb/ts_dw08.dbf 2,193 0 2.36 6.65 33 0 22 6.82
TS_DW /oracle/hjfxdata/zzdb/ts_dw09.dbf 2,595 0 2.15 5.45 1 0 40 8.75
TS_DW /oracle/oradata/zzdb/ts_dw01.dbf 1,522 0 2.05 5.53 1 0 23 6.52
TS_DW /oracle/oradata/zzdb/ts_dw02.dbf 1,120 0 2.76 7.74 1 0 6 3.33
TS_DW /oracle/oradata/zzdb/ts_dw03.dbf 1,257 0 2.65 6.91 1 0 10 5.00
TS_DW /oracle/oradata/zzdb/ts_dw04.dbf 2,213 0 2.75 5.56 1 0 32 2.19
TS_DWD /zzdb/tablespace/zzts001/ts_dwd001.dbf 1,159 0 4.45 15.67 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd002.dbf 1,032 0 3.52 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd003.dbf 693 0 2.84 15.44 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd004.dbf 1,160 0 3.15 15.66 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd005.dbf 1,158 0 3.15 15.68 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd006.dbf 1,158 0 3.20 15.57 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd007.dbf 1,159 0 3.11 15.67 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd008.dbf 1,032 0 3.55 15.65 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd009.dbf 901 0 3.97 15.68 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd010.dbf 1,097 0 3.32 15.64 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd011.dbf 967 0 3.86 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd012.dbf 1,158 0 3.13 15.68 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd013.dbf 229 0 14.72 15.50 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd014.dbf 1,542 0 2.43 15.68 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd015.dbf 1,412 0 2.57 15.68 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd016.dbf 1,605 0 2.37 15.70 11 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd017.dbf 1,605 0 2.29 15.67 45 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd018.dbf 1,605 0 1.29 15.70 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd019.dbf 1,604 0 2.26 15.70 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd020.dbf 1,604 0 2.35 15.70 21 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd021.dbf 1,349 0 2.77 15.69 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd022.dbf 1,606 0 2.29 15.69 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd023.dbf 1,606 0 2.28 15.69 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd024.dbf 1,606 0 2.23 15.68 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd025.dbf 1,605 0 2.34 15.70 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd026.dbf 1,604 0 1.48 15.71 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd027.dbf 1,606 0 1.38 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd028.dbf 1,221 0 2.96 14.46 1 0 1 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd029.dbf 1,656 0 2.20 15.24 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd030.dbf 1,751 0 0.40 14.43 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd031.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd032.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd033.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd034.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd035.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd036.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd037.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd038.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd039.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd040.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd041.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd042.dbf 5 0 0.00 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd043.dbf 54 0 0.37 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd044.dbf 71 0 1.83 14.46 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd045.dbf 22 0 6.36 11.86 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd046.dbf 1,756 0 0.45 14.43 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd047.dbf 1,608 0 0.42 15.63 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd048.dbf 1,609 0 0.52 15.62 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd049.dbf 1,617 0 0.40 15.62 2 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd050.dbf 1,616 0 0.34 15.63 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd051.dbf 1,617 0 1.34 15.64 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd052.dbf 1,408 0 2.74 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd053.dbf 1,164 0 3.12 14.94 18 0 1 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd054.dbf 1,161 0 3.20 14.90 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd055.dbf 1,165 0 3.14 14.97 9 0 1 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd056.dbf 1,168 0 3.17 14.94 9 0 2 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd057.dbf 1,119 0 3.32 15.51 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd058.dbf 1,115 0 3.27 15.60 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd059.dbf 1,117 0 3.30 15.57 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd060.dbf 1,121 0 3.32 15.52 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd061.dbf 780 0 4.65 14.52 18 0 1 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd062.dbf 1,116 0 3.22 15.59 51 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd063.dbf 1,117 0 3.28 15.57 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd064.dbf 1,166 0 3.20 14.96 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd065.dbf 1,113 0 3.28 15.50 17 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd066.dbf 1,115 0 3.27 15.60 74 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd067.dbf 1,117 0 3.32 15.57 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd068.dbf 1,119 0 3.29 15.47 23 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd069.dbf 1,116 0 3.16 15.59 11 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd070.dbf 1,109 0 3.27 15.58 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd071.dbf 1,118 0 3.37 15.45 17 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd072.dbf 1,118 0 3.26 15.56 15 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd073.dbf 1,119 0 3.30 15.55 14 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd074.dbf 1,115 0 3.32 15.53 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd075.dbf 1,117 0 3.26 15.53 12 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd076.dbf 1,118 0 3.19 15.56 18 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd077.dbf 1,118 0 3.24 15.50 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd078.dbf 1,117 0 3.26 15.57 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd079.dbf 1,117 0 3.23 15.51 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd080.dbf 1,119 0 3.30 15.55 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd081.dbf 1,118 0 3.34 15.56 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd082.dbf 1,118 0 3.18 15.56 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd083.dbf 1,120 0 3.27 15.46 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd084.dbf 1,117 0 3.31 15.57 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd085.dbf 1,114 0 3.34 15.56 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd086.dbf 1,117 0 3.26 15.57 8 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd087.dbf 1,117 0 3.29 15.56 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd088.dbf 1,116 0 3.33 15.58 9 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd089.dbf 1,107 0 3.26 15.60 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd090.dbf 1,107 0 3.31 15.60 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd091.dbf 1,106 0 3.17 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd092.dbf 1,106 0 3.25 15.60 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd093.dbf 1,106 0 3.32 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd094.dbf 947 0 3.80 15.57 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd095.dbf 1,075 0 3.43 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd096.dbf 980 0 3.65 15.57 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd097.dbf 1,107 0 3.28 15.60 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd098.dbf 1,108 0 3.31 15.52 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd099.dbf 1,108 0 3.30 15.58 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd100.dbf 1,106 0 3.31 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd101.dbf 1,107 0 3.35 15.60 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd102.dbf 1,108 0 3.33 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd103.dbf 1,107 0 3.30 15.55 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd104.dbf 1,110 0 3.30 15.56 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd105.dbf 1,108 0 3.31 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd106.dbf 1,107 0 3.22 15.49 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd107.dbf 1,108 0 3.33 15.57 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd108.dbf 1,106 0 3.28 15.61 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd109.dbf 1,108 0 3.30 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd120.dbf 1,105 0 3.19 15.58 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd121.dbf 1,108 0 3.36 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd122.dbf 1,106 0 3.32 15.57 13 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd123.dbf 1,104 0 1.89 15.64 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd124.dbf 1,166 0 3.04 15.40 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd125.dbf 1,162 0 3.12 15.63 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd126.dbf 907 0 4.18 15.58 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd127.dbf 1,165 0 3.08 15.59 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd128.dbf 7 0 1.43 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd129.dbf 7 0 1.43 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd130.dbf 7 0 1.43 1.00 1 0 0 0.00
TS_DWD /zzdb/tablespace/zzts001/ts_dwd131.dbf 7 0 1.43 1.00 1 0 0 0.00
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local.dbf 97,807 3 2.23 13.09 4,149 0 298 5.03
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local001.dbf 104,361 3 1.81 13.52 3,254 0 279 4.66
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local002.dbf 66,937 2 1.45 14.36 2,244 0 63 4.29
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local003.dbf 52,724 1 1.56 14.26 666 0 52 3.65
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local004.dbf 54,701 2 1.50 14.25 734 0 65 4.46
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local009.dbf 1 0 20.00 1.00 1 0 0 0.00
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local019.dbf 142,090 4 1.62 10.71 3,861 0 2,218 3.73
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local020.dbf 53,326 1 1.94 13.33 1,014 0 247 3.56
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local021.dbf 52,107 1 1.72 14.05 983 0 144 4.10
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local022.dbf 21,675 1 2.03 14.73 94 0 35 3.71
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local023.dbf 51,082 1 1.77 14.22 1,072 0 124 4.60
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local024.dbf 51,706 1 1.70 14.17 935 0 125 3.52
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local025.dbf 49,176 1 1.69 14.45 917 0 78 3.97
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local026.dbf 52,164 1 1.67 14.18 1,605 0 87 4.02
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local027.dbf 51,656 1 1.66 14.23 1,199 0 109 4.22
TS_LOCAL /oracle/hjfxdata2/hjfxdb/ts_local028.dbf 52,002 1 2.08 13.92 3,042 0 84 4.52
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local029.dbf 116,568 3 3.26 14.05 1,533 0 229 4.19
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local030.dbf 113,887 3 3.13 14.29 1,670 0 136 4.12
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local031.dbf 114,031 3 3.54 14.24 2,470 0 172 4.19
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local032.dbf 119,455 3 3.44 14.18 2,674 0 160 4.75
TS_LOCAL /oracle/hjfxdata4/hjfxdb/ts_local033.dbf 11 0 1.82 11.73 1 0 0 0.00
TS_LOCAL /oracle/oradata/hjfxdb/ts_local005.dbf 42,881 1 2.01 14.61 352 0 85 5.29
TS_LOCAL /oracle/oradata/hjfxdb/ts_local006.dbf 1 0 20.00 1.00 1 0 0 0.00
TS_LOCAL /oracle/oradata/hjfxdb/ts_local007.dbf 23,082 1 1.47 13.23 275 0 109 4.50
TS_LOCAL /oracle/oradata/hjfxdb/ts_local013.dbf 64,074 2 1.49 14.18 1,875 0 103 6.12
TS_LOCAL /oracle/oradata/hjfxdb/ts_local014.dbf 29,749 1 1.72 14.73 78 0 42 5.48
TS_LOCAL /oracle/oradata/hjfxdb/ts_local015.dbf 27,702 1 1.84 14.71 84 0 51 3.73
TS_LOCAL /oracle/oradata/hjfxdb/ts_local016.dbf 9,795 0 1.12 14.83 77 0 16 6.25
TS_LOCAL /oracle/oradata/hjfxdb/ts_local017.dbf 43,449 1 1.67 14.47 259 0 88 5.00
TS_LOCAL /oracle/oradata/hjfxdb/ts_local018.dbf 40,638 1 1.90 13.07 822 0 242 3.97
TS_ODS /oracle/hjfxdata/zzdb/ts_ods09.dbf 2,440 0 0.58 15.28 2 0 0 0.00
TS_ODS /oracle/hjfxdata/zzdb/ts_ods10.dbf 959 0 0.97 15.84 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods01.dbf 2,873 0 0.53 15.13 2 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods02.dbf 3,121 0 0.46 14.94 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods03.dbf 3,057 0 0.51 15.39 1 0 1 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods04.dbf 2,547 0 0.51 15.82 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods05.dbf 2,222 0 0.58 15.82 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods06.dbf 2,853 0 0.47 14.86 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods07.dbf 830 0 0.82 15.84 1 0 0 0.00
TS_ODS /oracle/hjfxdata2/hjfxdb/zzdb/ts_ods08.dbf 1,653 0 0.65 15.78 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods11.dbf 1,627 0 0.92 15.72 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods12.dbf 2,592 0 0.55 15.88 4 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods13.dbf 1,592 0 0.74 15.90 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods14.dbf 1,701 0 0.70 15.79 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods15.dbf 2,505 0 0.51 15.87 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods16.dbf 2,597 0 0.72 15.86 2 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods17.dbf 1,161 0 0.95 15.75 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods18.dbf 2,567 0 0.62 15.84 2 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods19.dbf 2,528 0 0.53 15.88 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods20.dbf 1,601 0 0.62 15.74 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods21.dbf 1,760 0 0.70 15.91 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods22.dbf 2,526 0 0.57 15.89 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods23.dbf 2,539 0 0.58 15.86 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods24.dbf 2,599 0 0.50 15.89 1 0 1 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods25.dbf 2,597 0 0.63 15.94 1 0 0 0.00
TS_ODS /oracle/hjfxdata4/zzdb/ts_ods26.dbf 1,489 0 0.78 15.88 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods59.dbf 105 0 0.76 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods60.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods61.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods62.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods63.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods64.dbf 55 0 0.55 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods65.dbf 251 0 0.48 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods66.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods67.dbf 55 0 0.55 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods68.dbf 71 0 0.85 4.32 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods69.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods70.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods71.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods72.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods73.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods74.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods75.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods76.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts001/ts_ods/ts_ods77.dbf 6 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods27.dbf 3 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods28.dbf 67 0 0.90 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods29.dbf 67 0 1.04 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods30.dbf 67 0 0.90 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods31.dbf 67 0 1.19 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods32.dbf 67 0 0.60 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods33.dbf 67 0 0.60 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods34.dbf 67 0 1.04 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods35.dbf 67 0 0.45 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods38.dbf 67 0 1.04 15.27 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods39.dbf 68 0 0.59 15.06 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods43.dbf 68 0 0.59 15.06 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods44.dbf 68 0 0.74 15.06 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods45.dbf 68 0 0.74 15.06 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods46.dbf 68 0 0.74 15.06 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods47.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods48.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods49.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods50.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods51.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods52.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods53.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods54.dbf 102 0 0.59 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods55.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods56.dbf 53 0 0.57 1.00 1 0 0 0.00
TS_ODS /zzdb/tablespace/zzts002/ts_ods57.dbf 4 0 0.00 1.00 1 0 0 0.00
TS_RPT /oracle/oradata/zzdb/ts_rpt01.dbf 3 0 6.67 1.00 1 0 0 0.00
UNDOTBS1 /oracle/oradata/hjfxdb/undotbs001.dbf 17 0 7.65 1.00 1,236 0 0 0.00
UNDOTBS1 /oracle/oradata/hjfxdb/undotbs01.dbf 25 0 1.20 1.00 1,408 0 4 0.00
USERS /oracle/oradata/hjfxdb/users01.dbf 220,580 6 0.46 1.00 1 0 3,129 4.06
USERS /oracle/oradata/hjfxdb/users02.dbf 335,468 9 0.48 1.00 16 0 2,288 4.06
USERS /oracle/oradata/hjfxdb/users03.dbf 421,031 12 0.49 1.00 1 0 4,905 5.21

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,628,850 66 80,061,647 27,319,841 55,886 0 0 16,308


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 185 479 184 1843200 184  
E 0 21 243 432 73686 1843200 73686  

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,048,052,046
D 2,624 0.20 325,376 1.07 20,759,917,539
D 3,936 0.30 488,064 1.03 20,092,223,894
D 5,248 0.40 650,752 1.02 19,906,509,999
D 6,560 0.50 813,440 1.02 19,803,180,130
D 7,872 0.60 976,128 1.01 19,687,684,277
D 9,184 0.70 1,138,816 1.01 19,595,635,063
D 10,496 0.80 1,301,504 1.01 19,530,474,226
D 11,808 0.90 1,464,192 1.00 19,475,443,386
D 13,120 1.00 1,626,880 1.00 19,425,028,745
D 13,136 1.00 1,628,864 1.00 19,424,447,132
D 14,432 1.10 1,789,568 1.00 19,377,331,533
D 15,744 1.20 1,952,256 1.00 19,328,201,170
D 17,056 1.30 2,114,944 0.99 19,255,955,443
D 18,368 1.40 2,277,632 0.98 19,098,332,086
D 19,680 1.50 2,440,320 0.97 18,782,653,405
D 20,992 1.60 2,603,008 0.94 18,351,127,144
D 22,304 1.70 2,765,696 0.93 18,015,398,466
D 23,616 1.80 2,928,384 0.92 17,814,316,388
D 24,928 1.90 3,091,072 0.91 17,632,380,757
D 26,240 2.00 3,253,760 0.90 17,401,907,802

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
90.72 3,747 383

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,035 263.49 0.00 0.00 0.00 0.00 468,170
E 4,572 4,036 343.77 79.86 23.23 100.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 235,659 235,659 0 0
64K 128K 82 82 0 0
128K 256K 12 12 0 0
256K 512K 20 20 0 0
512K 1024K 495 495 0 0
1M 2M 355 355 0 0
2M 4M 93 93 0 0
4M 8M 40 40 0 0
8M 16M 39 37 2 0
16M 32M 7 5 2 0
32M 64M 11 11 0 0
128M 256M 2 0 2 0
256M 512M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
572 0.13 4,377,315.66 500,118.38 90.00 18
1,143 0.25 4,377,315.66 450,961.89 91.00 0
2,286 0.50 4,377,315.66 450,961.89 91.00 0
3,429 0.75 4,377,315.66 450,961.89 91.00 0
4,572 1.00 4,377,315.66 373,133.01 92.00 0
5,486 1.20 4,377,315.66 271,662.87 94.00 0
6,401 1.40 4,377,315.66 271,662.87 94.00 0
7,315 1.60 4,377,315.66 271,662.87 94.00 0
8,230 1.80 4,377,315.66 271,662.87 94.00 0
9,144 2.00 4,377,315.66 271,662.87 94.00 0
13,716 3.00 4,377,315.66 271,662.87 94.00 0
18,288 4.00 4,377,315.66 271,662.87 94.00 0
27,432 6.00 4,377,315.66 271,662.87 94.00 0
36,576 8.00 4,377,315.66 271,662.87 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
512 1.00 67 5,750 1,029,327 1.00 1,961,900 1.00 186,666,884
592 1.16 128 9,996 1,029,638 1.00 1,961,589 1.00 186,777,953
656 1.28 191 14,476 1,029,943 1.00 1,961,284 1.00 186,886,781
720 1.41 254 19,284 1,030,247 1.00 1,960,980 1.00 186,994,720
784 1.53 317 23,375 1,030,549 1.00 1,960,678 1.00 187,102,108
848 1.66 380 27,973 1,030,850 1.00 1,960,377 1.00 187,208,887
912 1.78 443 32,510 1,031,149 1.00 1,960,078 1.00 187,315,016
976 1.91 505 36,385 1,031,446 1.00 1,959,781 1.00 187,420,500
1,040 2.03 568 40,576 1,031,741 1.00 1,959,486 1.00 187,525,372

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,924,250 20,760,844,536
6,864 0.50 19,144,531 19,803,219,503
10,296 0.75 18,973,144 19,595,377,964
13,728 1.00 18,833,774 19,424,442,867
17,160 1.25 18,698,171 19,255,450,214
20,592 1.50 18,340,329 18,783,436,252
24,024 1.75 18,338,446 17,814,156,553
27,456 2.00 18,338,446 17,402,358,365

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 16,303 73 4
undo header 4 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)
RO-Multiple Object Reuse (fast object reuse) 567 567 0 55 1 23.16
CF-Controlfile Transaction 168,406 168,406 0 1 0 2.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 4.97 4,598 1,127 4 15/31.75 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 10:02 40 121 576 3 22 0/0 0/0/0/0/0/0
05-May 09:52 13 92 0 3 15 0/0 0/0/0/0/0/0
05-May 09:42 1 9 249 2 16 0/0 0/0/0/0/0/0
05-May 09:32 447 60 0 1 15 0/0 0/0/0/0/0/0
05-May 09:22 0 2 0 0 15 0/0 0/0/0/0/0/0
05-May 09:12 1 108 0 1 15 0/0 0/0/0/0/0/0
05-May 09:02 60 60 0 3 15 0/0 0/0/0/0/0/0
05-May 08:52 1 68 0 1 15 0/0 0/0/0/0/0/0
05-May 08:42 27 62 0 2 15 0/0 0/0/0/0/0/0
05-May 08:32 39 102 996 3 30 0/0 0/0/0/0/0/0
05-May 08:22 30 122 396 2 20 0/0 0/0/0/0/0/0
05-May 08:12 114 304 355 2 19 0/0 0/0/0/0/0/0
05-May 08:02 53 60 0 3 15 0/0 0/0/0/0/0/0
05-May 07:52 0 8 0 0 15 0/0 0/0/0/0/0/0
05-May 07:42 1 3 0 1 15 0/0 0/0/0/0/0/0
05-May 07:32 4 219 0 1 15 0/0 0/0/0/0/0/0
05-May 07:22 2,512 713 0 3 15 0/0 0/0/0/0/0/0
05-May 07:12 0 7 0 0 15 0/0 0/0/0/0/0/0
05-May 07:02 54 100 0 3 15 0/0 0/0/0/0/0/0
05-May 06:52 0 3 0 0 15 0/0 0/0/0/0/0/0
05-May 06:42 5 97 1,127 2 32 0/0 0/0/0/0/0/0
05-May 06:32 0 36 526 1 22 0/0 0/0/0/0/0/0
05-May 06:22 480 234 549 3 22 0/0 0/0/0/0/0/0
05-May 06:12 18 150 517 2 22 0/0 0/0/0/0/0/0
05-May 06:02 703 483 348 4 19 0/0 0/0/0/0/0/0
05-May 05:52 51 139 1,115 3 32 0/0 0/0/0/0/0/0
05-May 05:42 1 6 516 2 22 0/0 0/0/0/0/0/0
05-May 05:32 23 263 0 3 15 0/0 0/0/0/0/0/0
05-May 05:22 1 67 0 1 15 0/0 0/0/0/0/0/0
05-May 05:12 0 6 0 0 15 0/0 0/0/0/0/0/0
05-May 05:02 43 52 0 3 15 0/0 0/0/0/0/0/0
05-May 04:52 1 2 0 1 15 0/0 0/0/0/0/0/0
05-May 04:42 1 12 0 1 15 0/0 0/0/0/0/0/0
05-May 04:32 1 6 0 1 15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AWR Alerted Metric Element list 220,403 0.00   0 0  
Consistent RBA 3,592 0.00   0 0  
FAL request queue 722 0.00   0 0  
FAL subheap alocation 722 0.00   0 0  
FIB s.o chain latch 66 0.00   0 0  
FOB s.o list latch 11,594 0.00   0 0  
In memory undo latch 20,490 0.00   0 8,768 0.00
JS mem alloc latch 56 0.00   0 0  
JS queue access latch 56 0.00   0 0  
JS queue state obj latch 260,348 0.00   0 0  
JS slv state obj latch 229 0.00   0 0  
KMG MMAN ready and startup request latch 12,005 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 5,502 0.00   0 11,896 0.00
KWQMN job cache list latch 8 0.00   0 0  
KWQP Prop Status 20 0.00   0 0  
MQL Tracking Latch 0     0 720 0.00
Memory Management Latch 20 0.00   0 12,005 0.00
OS process 1,641 0.00   0 0  
OS process allocation 13,101 0.01 0.00 0 0  
OS process: request allocation 840 0.12 0.00 0 0  
PL/SQL warning settings 2,330 0.00   0 0  
Reserved Space Latch 3 0.00   0 0  
SGA IO buffer pool latch 1,594,255 0.00   0 1,594,256 0.00
SQL memory manager latch 10 0.00   0 11,969 0.00
SQL memory manager workarea list latch 1,109,299 0.00   0 0  
Shared B-Tree 1,316 0.00   0 0  
active checkpoint queue latch 69,365 0.01 0.00 0 0  
active service list 75,040 0.00   0 12,064 0.00
archive control 872 0.00   0 0  
archive process latch 12,691 0.00   0 0  
begin backup scn array 5,444 0.00   0 0  
buffer pool 65 0.00   0 0  
cache buffer handles 10,770 0.00   0 0  
cache buffers chains 185,131,647 0.00 0.02 0 51,515,869 0.00
cache buffers lru chain 394,670 0.13 0.01 0 34,314,351 0.01
cache table scan latch 0     0 1,727,398 0.00
channel handle pool latch 968 0.10 0.00 0 0  
channel operations parent latch 172,627 0.01 0.00 0 0  
checkpoint queue latch 2,002,539 0.00 0.04 0 54,625 0.00
client/application info 6,005 0.00   0 0  
commit callback allocation 98 0.00   0 0  
compile environment latch 2,542 0.00   0 0  
dictionary lookup 136 0.00   0 0  
dml lock allocation 13,988 0.00   0 0  
dummy allocation 924 0.00   0 0  
enqueue hash chains 3,172,050 0.02 0.00 0 4,036 0.00
enqueues 3,142,401 0.03 0.00 0 0  
event group latch 421 0.24 0.00 0 0  
file cache latch 4,737 0.00   0 0  
global KZLD latch for mem in SGA 277 0.00   0 0  
global tx hash mapping 297 0.00   0 0  
hash table column usage latch 866 0.00   0 24,704 0.00
hash table modification latch 838 0.00   0 0  
job workq parent latch 0     0 86 0.00
job_queue_processes parameter latch 641 0.00   0 0  
kks stats 2,972 0.00   0 0  
kmcptab latch 2 0.00   0 0  
kmcpvec latch 0     0 2 0.00
krbmrosl 271 0.00   0 0  
ksuosstats global area 2,421 0.00   0 0  
ktm global data 240 0.00   0 0  
kwqbsn:qsga 1,306 0.00   0 0  
lgwr LWN SCN 13,480 0.00   0 0  
library cache 5,275,532 0.02 0.00 0 2,190 0.00
library cache load lock 2,540 0.00   0 0  
library cache lock 180,063 0.00 0.00 0 0  
library cache lock allocation 3,677 0.00   0 0  
library cache pin 5,021,042 0.01 0.00 0 0  
library cache pin allocation 1,453 0.00   0 0  
list of block allocation 3,447 0.00   0 0  
loader state object freelist 296 0.00   0 0  
logminer context allocation 10 0.00   0 0  
longop free list parent 37 0.00   0 9 0.00
message pool operations parent latch 427 0.23 0.00 0 0  
messages 354,693 0.01 0.00 0 0  
mostly latch-free SCN 13,492 0.07 0.00 0 0  
multiblock read objects 3,500,889 0.00   0 0  
ncodef allocation latch 574 0.00   0 0  
object queue header heap 217,646 0.00   0 212,447 0.00
object queue header operation 55,206,005 0.00 0.04 0 0  
object stats modification 166 0.00   0 0  
parallel query alloc buffer 4,788 0.00   0 0  
parameter list 1 0.00   0 0  
parameter table allocation management 531 0.00   0 0  
post/wait queue 1,262 0.00   0 495 0.00
process allocation 840 0.12 0.00 0 420 0.24
process group creation 840 0.00   0 0  
qmn task queue latch 5,144 0.00   0 0  
redo allocation 48,444 0.01 0.00 0 335,748 0.00
redo copy 0     0 335,750 0.03
redo writing 104,992 0.01 0.10 0 0  
reservation so alloc latch 2 0.00   0 0  
resmgr group change latch 1,634 0.00   0 0  
resmgr:actses active list 890 0.00   0 0  
resmgr:actses change group 400 0.00   0 0  
resmgr:free threads list 880 0.00   0 0  
resmgr:schema config 10 0.00   0 0  
row cache objects 5,241,803 0.02 0.00 0 258 0.00
rules engine rule set statistics 1,000 0.00   0 0  
sequence cache 2,354 0.00   0 0  
session allocation 17,796,212 0.00 0.00 0 0  
session idle bit 88,129 0.00 0.00 0 0  
session state list latch 1,062 0.00   0 0  
session switching 574 0.00   0 0  
session timer 12,064 0.00   0 0  
shared pool 3,680,187 0.00   0 0  
simulator hash latch 9,988,479 0.00 0.00 0 0  
simulator lru latch 5,489,235 0.01 0.00 0 1,780,327 0.00
slave class 22 0.00   0 0  
slave class create 88 11.36 1.00 0 0  
sort extent pool 1,186 0.00   0 0  
state object free list 20 0.00   0 0  
statistics aggregation 1,400 0.00   0 0  
temp lob duration state obj allocation 4 0.00   0 0  
threshold alerts latch 2,487 0.00   0 0  
transaction allocation 701 0.00   0 0  
transaction branch allocation 666 0.00   0 0  
undo global data 57,428 0.00   0 0  
user lock 1,191 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 185,131,647 4,650 97 4,555 0 0 0
library cache 5,275,532 1,092 2 1,090 0 0 0
enqueues 3,142,401 845 1 844 0 0 0
cache buffers lru chain 394,670 498 3 495 0 0 0
library cache pin 5,021,042 429 1 428 0 0 0
object queue header operation 55,206,005 28 1 27 0 0 0
checkpoint queue latch 2,002,539 25 1 24 0 0 0
redo writing 104,992 10 1 9 0 0 0
slave class create 88 10 10 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 282 281
cache buffers chains kcbrls: kslbegin 0 3 1
cache buffers lru chain kcbzgws 0 3 0
checkpoint queue latch kcbkubc 0 1 1
enqueues ksqgel: create enqueue 0 1 0
library cache pin kglpnc: child 0 1 0
object queue header operation kcbo_write_q 0 1 0
redo writing kcrfsr: rba scn pair 0 1 0
shared pool kghfrunp: clatch: nowait 0 2 0
slave class create ksvcreate 0 10 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_NUM_FOR_CITY   TABLE 39,161,184 48.88
SYS SYSTEM I_FILE#_BLOCK#   INDEX 3,321,616 4.15
CALNAV TS_LOCAL DIM_NUMBER_LIST   TABLE 2,747,136 3.43
GR_DWD TS_DWD TMP_LICAL_USER_CALL_LEN   TABLE 1,929,856 2.41
CALNAV TS_LOCAL DW_CUSTBEF_USER_INFO_DAILY   TABLE 1,903,360 2.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CALNAV TS_LOCAL DW_CUSTBEF_USER_INFO_DAILY   TABLE 1,902,830 6.96
GR_DWD TS_DWD TMP_LICAL_USER_CALL_LEN   TABLE 1,897,251 6.94
GR_ODS TS_ODS ODS_GSM_USER_INFO   TABLE 808,570 2.96
CALNAV TS_LOCAL ODS_YYGH_NUMBER_SOURCE ART_201401 TABLE PARTITION 354,876 1.30
CALNAV TS_LOCAL ODS_YYGH_NUMBER_SOURCE ART_201402 TABLE PARTITION 308,712 1.13

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 682 0.00 0   22 1
dc_database_links 755 0.00 0   0 8
dc_files 17,780 0.00 0   0 254
dc_global_oids 73,684 0.00 0   0 112
dc_histogram_data 12,892 5.48 0   286 18,466
dc_histogram_defs 12,929 16.71 0   282 17,819
dc_object_grants 75 0.00 0   0 203
dc_object_ids 85,269 0.20 0   68 2,746
dc_objects 6,195 3.79 0   295 7,789
dc_profiles 341 0.00 0   0 1
dc_rollback_segments 10,128 0.00 0   0 30
dc_segments 17,282 0.29 0   1,111 21,839
dc_sequences 49 0.00 0   49 11
dc_tablespace_quotas 733 0.00 0   52 4
dc_tablespaces 1,270,381 0.00 0   0 20
dc_usernames 1,555 0.00 0   0 32
dc_users 243,148 0.00 0   0 82
outstanding_alerts 860 0.00 0   0 13


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 596 0.00 3,647 0.11 4 0
CLUSTER 36 0.00 102 0.98 1 0
INDEX 86 22.09 347 10.66 17 0
JAVA RESOURCE 3 100.00 5 60.00 0 0
JAVA SOURCE 3 100.00 5 60.00 0 0
SQL AREA 686 27.11 2,413,330 0.06 714 228
TABLE/PROCEDURE 6,557 1.01 86,119 1.43 704 0
TRIGGER 265 1.13 306 1.31 1 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 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
E Other 173.97   5.80 12.80 59 73 30 30
  Freeable 88.69 0.00 5.22 8.38 32   17 17
  SQL 80.67 80.22 4.25 16.81 73 240 19 18
  PL/SQL 0.45 0.18 0.02 0.02 0 0 28 28

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

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 free memory ################## ################## -0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 13,120.00 13,136.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 109,441 0 0
QMON Slaves 54,095 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 18 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