WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
HJFXDB1975059769hjfxdb110.2.0.1.0NOhjfxdb3

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2480304-May-14 00:00:1829 2.2
End Snap:2482705-May-14 00:00:4523 2.1
Elapsed:  1,440.45 (mins)  
DB Time:  303.12 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 4,448M 4,432MStd Block Size: 8K
Shared Pool Size: 368M 384MLog Buffer: 14,400K

Load Profile

Per SecondPer Transaction
Redo size: 1,174,067.99 6,215.06
Logical reads: 3,616.20 19.14
Block changes: 1,688.87 8.94
Physical reads: 449.39 2.38
Physical writes: 174.15 0.92
User calls: 391.04 2.07
Parses: 3.20 0.02
Hard parses: 0.17 0.00
Sorts: 1.10 0.01
Logons: 0.08 0.00
Executes: 193.64 1.03
Transactions: 188.91 

% Blocks changed per Read: 46.70Recursive Call %: 37.37
Rollback per transaction %: 0.00Rows per Sort: 13.47

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 87.68In-memory Sort %: 100.00
Library Hit %: 99.82Soft Parse %: 94.82
Execute to Parse %: 98.34Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 33.63% Non-Parse CPU: 99.84

Shared Pool Statistics

BeginEnd
Memory Usage %: 97.17 88.15
% SQL with executions>1: 97.25 94.66
% Memory for SQL w/exec>1: 78.65 88.13

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  16,259  89.4 
log file sync 16,321,425 6,473 0 35.6Commit
log file parallel write 16,350,622 6,072 0 33.4System I/O
db file parallel write 550,712 2,077 4 11.4System I/O
db file scattered read 2,413,062 1,362 1 7.5User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 16,258.98 89.40
sql execute elapsed time 10,541.40 57.96
parse time elapsed 78.09 0.43
hard parse elapsed time 33.56 0.18
PL/SQL execution elapsed time 27.20 0.15
inbound PL/SQL rpc elapsed time 18.32 0.10
connection management call elapsed time 11.47 0.06
hard parse (sharing criteria) elapsed time 1.91 0.01
PL/SQL compilation elapsed time 1.18 0.01
hard parse (bind mismatch) elapsed time 0.35 0.00
sequence load elapsed time 0.13 0.00
RMAN cpu time (backup/restore) 0.10 0.00
failed parse elapsed time 0.09 0.00
repeated bind elapsed time 0.04 0.00
DB time 18,187.39  
background elapsed time 10,167.76  
background cpu time 858.61  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O 17,725,678 0.00 9,200 1 1.09
Commit 16,321,425 0.00 6,473 0 1.00
User I/O 2,564,898 0.00 1,697 1 0.16
Network 73,365,964 0.00 355 0 4.49
Concurrency 2,602 0.00 66 25 0.00
Application 33,112 0.03 35 1 0.00
Other 20,505 0.00 13 1 0.00
Configuration 2,208 92.21 3 2 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file sync 16,321,425 0.00 6,473 0 1.00
log file parallel write 16,350,622 0.00 6,072 0 1.00
db file parallel write 550,712 0.00 2,077 4 0.03
db file scattered read 2,413,062 0.00 1,362 1 0.15
log file sequential read 104,204 0.00 925 9 0.01
SQL*Net more data from client 35,239,982 0.00 292 0 2.16
db file sequential read 91,825 0.00 163 2 0.01
read by other session 30,504 0.00 87 3 0.00
direct path read temp 10,919 0.00 75 7 0.00
Log archive I/O 124,746 0.00 72 1 0.01
os thread startup 1,332 0.00 65 49 0.00
SQL*Net more data to client 4,373,262 0.00 49 0 0.27
control file parallel write 35,878 0.00 34 1 0.00
enq: TX - row lock contention 14 71.43 31 2224 0.00
control file sequential read 558,966 0.00 17 0 0.03
SQL*Net message to client 33,750,959 0.00 14 0 2.07
rdbms ipc reply 17,682 0.00 12 1 0.00
direct path write temp 10,919 0.00 5 0 0.00
enq: RO - fast object reuse 1,302 0.00 4 3 0.00
local write wait 2,889 0.00 4 1 0.00
log file switch completion 74 1.35 3 47 0.00
control file single write 448 0.00 3 7 0.00
direct path read 2,470 0.00 1 0 0.00
latch free 178 0.00 1 5 0.00
latch: library cache 346 0.00 1 2 0.00
latch: shared pool 507 0.00 1 1 0.00
SQL*Net break/reset to client 31,796 0.00 1 0 0.00
log file single write 102 0.00 0 3 0.00
reliable message 788 0.00 0 0 0.00
SQL*Net more data from dblink 1,721 0.00 0 0 0.00
LGWR wait for redo copy 1,571 0.00 0 0 0.00
direct path write 2,310 0.00 0 0 0.00
latch: cache buffers lru chain 172 0.00 0 0 0.00
enq: CF - contention 1 0.00 0 24 0.00
latch: cache buffers chains 243 0.00 0 0 0.00
undo segment extension 2,041 99.71 0 0 0.00
enq: TX - contention 3 0.00 0 3 0.00
recovery area: computing obsolete files 14 0.00 0 0 0.00
enq: CI - contention 10 0.00 0 1 0.00
buffer busy waits 172 0.00 0 0 0.00
recovery area: computing dropped files 14 0.00 0 0 0.00
latch: redo writing 93 0.00 0 0 0.00
recovery area: computing backed up files 14 0.00 0 0 0.00
recovery area: computing applied logs 14 0.00 0 0 0.00
latch: enqueue hash chains 13 0.00 0 0 0.00
latch: messages 9 0.00 0 0 0.00
latch: row cache objects 2 0.00 0 0 0.00
latch: object queue header operation 13 0.00 0 0 0.00
latch: checkpoint queue latch 5 0.00 0 0 0.00
latch: redo allocation 4 0.00 0 0 0.00
SQL*Net message to dblink 40 0.00 0 0 0.00
Streams AQ: qmn slave idle wait 3,125 0.00 84,146 26927 0.00
Streams AQ: qmn coordinator idle wait 6,625 47.05 84,146 12701 0.00
virtual circuit status 2,881 100.00 84,119 29198 0.00
jobq slave wait 26,708 99.63 78,068 2923 0.00
Streams AQ: waiting for time management or cleanup tasks 21 100.00 60,205 2866884 0.00
SQL*Net message from client 33,750,965 0.00 44,231 1 2.07
class slave wait 41 100.00 200 4883 0.00
single-task message 2 0.00 0 58 0.00
SQL*Net message from dblink 40 0.00 0 3 0.00
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
log file parallel write 16,350,621 0.00 6,072 0 1.00
db file parallel write 550,712 0.00 2,077 4 0.03
log file sequential read 104,204 0.00 925 9 0.01
Log archive I/O 124,746 0.00 72 1 0.01
os thread startup 1,332 0.00 65 49 0.00
control file parallel write 33,447 0.00 33 1 0.00
db file scattered read 10,727 0.00 12 1 0.00
control file sequential read 34,387 0.00 9 0 0.00
db file sequential read 5,727 0.00 4 1 0.00
direct path read 1,377 0.00 1 1 0.00
log file single write 102 0.00 0 3 0.00
events in waitclass Other 2,560 0.00 0 0 0.00
latch: library cache 4 0.00 0 16 0.00
direct path write 1,377 0.00 0 0 0.00
buffer busy waits 72 0.00 0 0 0.00
latch: redo writing 93 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
rdbms ipc message 16,678,529 1.62 897,644 54 1.02
pmon timer 29,432 100.00 84,364 2866 0.00
Streams AQ: qmn slave idle wait 3,125 0.00 84,146 26927 0.00
Streams AQ: qmn coordinator idle wait 6,625 47.05 84,146 12701 0.00
smon timer 2,152 11.25 81,495 37869 0.00
Streams AQ: waiting for time management or cleanup tasks 21 100.00 60,205 2866884 0.00
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 1,275,005
AVG_IDLE_TIME 7,384,742
AVG_IOWAIT_TIME 212,050
AVG_SYS_TIME 517,688
AVG_USER_TIME 755,431
BUSY_TIME 5,108,704
IDLE_TIME 29,547,745
IOWAIT_TIME 856,989
SYS_TIME 2,079,465
USER_TIME 3,029,239
LOAD 0
OS_CPU_WAIT_TIME 10,467,100
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 17,179,869,184
NUM_CPUS 4
NUM_CPU_CORES 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 18,183.40 16,257.00 38,688,031 307,624,165
hjfxdb 4.00 1.90 40 99,755
SYS$BACKGROUND 0.00 0.00 151,074 4,814,409
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
SYS$USERS 2539072 166751 1148 100 0 0 73358597 35469
hjfxdb 40 17 0 0 0 0 332 1
SYS$BACKGROUND 25786 2943 1452 6504 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
1,765 1,763 5,097,667 0.00 9.70 8kyudmnh5n5nq SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER (PAR...
1,560 1,559 4,809,789 0.00 8.58 dkjwfukzdcpfu SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVCSTA...
540 404 1 540.41 2.97 f9mzcbwxgj895 SQL*Plus delete from TI_CRM_USER_SVC...
440 439 1,503,985 0.00 2.42 7d77yhq6b7t9r SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_INFOCH...
381 380 1,042,029 0.00 2.09 g5qu5acjj2bbv SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_GROUPM...
343 342 1,219,852 0.00 1.88 8dmvks9ksswcr SQL Loader Conventional Path Load INSERT INTO TI_CRM_TRADE (TR...
303 303 535,638 0.00 1.67 8awnpu7d730dr SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SP (...
271 215 1 271.29 1.49 4sjhtt4cxs9vd SQL*Plus delete from TI_CRM_USER_ITE...
241 47 3 80.36 1.33 81qnwktdc1g9h oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT "A1"."TASK_ID", MAX(DEC...
206 86 1 205.72 1.13 7nu3m2jfnu2hn oracle@hjfxdb2 (TNS V1-V3) SELECT "A1"."START_DATE", "A1"...
192 192 829,959 0.00 1.06 g8vtadgavaqav SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVC_IT...

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,763 1,765 5,097,667 0.00 9.70 8kyudmnh5n5nq SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER (PAR...
1,559 1,560 4,809,789 0.00 8.58 dkjwfukzdcpfu SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVCSTA...
439 440 1,503,985 0.00 2.42 7d77yhq6b7t9r SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_INFOCH...
404 540 1 404.12 2.97 f9mzcbwxgj895 SQL*Plus delete from TI_CRM_USER_SVC...
380 381 1,042,029 0.00 2.09 g5qu5acjj2bbv SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_GROUPM...
342 343 1,219,852 0.00 1.88 8dmvks9ksswcr SQL Loader Conventional Path Load INSERT INTO TI_CRM_TRADE (TR...
303 303 535,638 0.00 1.67 8awnpu7d730dr SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SP (...
215 271 1 215.18 1.49 4sjhtt4cxs9vd SQL*Plus delete from TI_CRM_USER_ITE...
192 192 829,959 0.00 1.06 g8vtadgavaqav SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVC_IT...
163 173 1 163.35 0.95 gqxj3bu3gjudp oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
86 206 1 86.02 1.13 7nu3m2jfnu2hn oracle@hjfxdb2 (TNS V1-V3) SELECT "A1"."START_DATE", "A1"...
47 241 3 15.64 1.33 81qnwktdc1g9h oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT "A1"."TASK_ID", MAX(DEC...

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
49,370,641 5,097,667 9.68 15.80 1762.57 1764.65 8kyudmnh5n5nq SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER (PAR...
47,230,488 4,809,789 9.82 15.11 1559.09 1559.95 dkjwfukzdcpfu SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVCSTA...
18,226,516 1,503,985 12.12 5.83 439.40 439.69 7d77yhq6b7t9r SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_INFOCH...
9,601,592 1 9,601,592.00 3.07 404.12 540.41 f9mzcbwxgj895 SQL*Plus delete from TI_CRM_USER_SVC...
9,567,227 535,638 17.86 3.06 303.03 303.26 8awnpu7d730dr SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SP (...
9,028,018 1,042,029 8.66 2.89 380.30 380.63 g5qu5acjj2bbv SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_GROUPM...
8,929,773 1,219,852 7.32 2.86 342.44 342.55 8dmvks9ksswcr SQL Loader Conventional Path Load INSERT INTO TI_CRM_TRADE (TR...
8,264,745 829,959 9.96 2.64 192.12 192.33 g8vtadgavaqav SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVC_IT...
5,006,476 538,048 9.30 1.60 145.95 146.00 1vv0r6sukjyk9 SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_DISCNT...
4,720,268 1 4,720,268.00 1.51 215.18 271.29 4sjhtt4cxs9vd SQL*Plus delete from TI_CRM_USER_ITE...

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
9,600,907 1 9,600,907.00 24.72 404.12 540.41 f9mzcbwxgj895 SQL*Plus delete from TI_CRM_USER_SVC...
4,719,487 1 4,719,487.00 12.15 215.18 271.29 4sjhtt4cxs9vd SQL*Plus delete from TI_CRM_USER_ITE...
2,812,362 1 2,812,362.00 7.24 87.46 129.75 b3zyut8n5350d SQL*Plus delete from TI_CRM_TRADE wh...
2,059,852 1 2,059,852.00 5.30 75.65 102.65 34dr73x404gxb SQL*Plus delete from TI_CRM_TRADE_DI...
1,917,197 1 1,917,197.00 4.94 65.87 89.16 g95yuw3u9h2t7 SQL*Plus delete from TI_CRM_CUST_PER...
1,551,671 1 1,551,671.00 4.00 86.02 205.72 7nu3m2jfnu2hn oracle@hjfxdb2 (TNS V1-V3) SELECT "A1"."START_DATE", "A1"...
1,480,957 1 1,480,957.00 3.81 54.67 75.86 90auk3pxw1vmq SQL*Plus delete from TI_CRM_CUSTOMER...
1,465,921 1 1,465,921.00 3.77 53.41 69.95 3a27gnjst4ty6 SQL*Plus delete from TI_CRM_ACCOUNT ...
1,352,349 1 1,352,349.00 3.48 147.73 166.66 bgw2v929ws708 oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT "END_DATE", "MSISDN", "...
1,352,243 1 1,352,243.00 3.48 26.87 59.92 ghpn0aaynsbuh SQL*Plus select count(*) from TI_BIL_GS...
1,352,171 1 1,352,171.00 3.48 163.35 172.61 gqxj3bu3gjudp oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
1,230,588 1 1,230,588.00 3.17 53.46 73.91 d7asga0n8bncu SQL*Plus delete from TI_CRM_USER_PRO...
1,230,572 1 1,230,572.00 3.17 47.03 128.19 ct91xzzquzxrb SQL*Plus INSERT INTO TI_CONTRACT_USER N...
1,038,828 3 346,276.00 2.67 46.92 241.09 81qnwktdc1g9h oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT "A1"."TASK_ID", MAX(DEC...
742,171 1 742,171.00 1.91 28.21 38.36 dwy3t2d67r8d0 SQL*Plus delete from TI_CRM_RELATION...
452,997 1 452,997.00 1.17 9.05 20.50 9nkpcbuhv1cs8 SQL*Plus select count(*) from TI_BIL_GS...
452,593 1 452,593.00 1.17 33.39 35.64 6f69jd49t88z0 oraclehjfxdb@hjfxdb2 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...

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
5,097,667 86,466,463 16.96 0.00 0.00 8kyudmnh5n5nq SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER (PAR...
4,809,789 307,191,113 63.87 0.00 0.00 dkjwfukzdcpfu SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVCSTA...
1,503,985 96,010,815 63.84 0.00 0.00 7d77yhq6b7t9r SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_INFOCH...
1,219,852 19,491,990 15.98 0.00 0.00 8dmvks9ksswcr SQL Loader Conventional Path Load INSERT INTO TI_CRM_TRADE (TR...
1,042,029 8,320,476 7.98 0.00 0.00 g5qu5acjj2bbv SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_GROUPM...
829,959 53,014,887 63.88 0.00 0.00 g8vtadgavaqav SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SVC_IT...
538,048 34,365,278 63.87 0.00 0.00 1vv0r6sukjyk9 SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_DISCNT...
535,638 30,915,894 57.72 0.00 0.00 8awnpu7d730dr SQL Loader Conventional Path Load INSERT INTO TI_CRM_USER_SP (...
309,681 1,547,268 5.00 0.00 0.00 43xyffxsnvh5p SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_GROUP ...
195,060 5,205,946 26.69 0.00 0.00 b622brt1685fc SQL Loader Conventional Path Load INSERT INTO TI_CRM_CUST_CONTAC...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
37,312 37,291 13.47 2ym6hhaq30r73   select type#, blocks, extents,...
27,768 27,768 10.02 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
20,856 20,856 7.53 bsa0wjtftg3uw   select file# from file$ where ...
13,028 13,028 4.70 0h6b2sajwb74n   select privilege#, level from ...
5,774 5,774 2.08 0k8522rmdzg4k   select privilege# from sysauth...
4,518 4,518 1.63 5ur69atw3vfhj   select decode(failover_method,...
4,413 4,413 1.59 459f3z9u4fb3u   select value$ from props$ wher...
4,378 4,378 1.58 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
4,055 4,055 1.46 350f5yrnnmshs   lock table sys.mon_mods$ in ex...
4,055 4,055 1.46 g00cj285jmgsw   update sys.mon_mods$ set inser...
3,974 3,974 1.43 ca7fk0wugft6v sqlplus@hjfxdb3 (TNS V1-V3) ALTER SESSION SET NLS_LANGUAGE...
3,750 3,750 1.35 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...

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
78 190 4gb7r5dm6hnzs   SELECT CONF#, NAME, VALUE FR...
62 2,324 18naypzfmabd6   INSERT INTO MGMT_SYSTEM_PERFOR...

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
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1vv0r6sukjyk9INSERT INTO TI_CRM_USER_DISCNT_ITEM (PARTITION_ID, ITEM_ID, ATTR_CODE, ATTR_VALUE, START_DATE, END_DATE, DATE_FLAG) VALUES (:PARTITION_ID, :ITEM_ID, :ATTR_CODE, :ATTR_VALUE, :START_DATE, :END_DATE, nvl(:"DATE_FLAG", '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
34dr73x404gxb delete from TI_CRM_TRADE_DISCNT where date_flag=20140503
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3a27gnjst4ty6 delete from TI_CRM_ACCOUNT where date_flag=20140503
43xyffxsnvh5p INSERT INTO TI_CRM_CUST_GROUP (CUST_ID, GROUP_ID, CUST_NAME, GROUP_TYPE, CLASS_ID, LAST_CLASS_ID, CLASS_CHANGE_DATE, CUST_CLASS_TYPE, GROUP_ATTR, GROUP_STATUS, GROUP_ADDR, EPARCHY_CODE, CITY_CODE, SUPER_GROUP_ID, MP_GROUP_CUST_CODE, UNIFY_PAY_CODE, ORG_STRUCT_CODE, CUST_MANAGER_ID, CUST_MANAGER_APPR, ASSIGN_DATE, ASSIGN_STAFF_ID, CALLING_TYPE_CODE, SUB_CALLING_TYPE_CODE, CALLING_AREA_CODE, GROUP_CONTACT_PHONE, ENTERPRISE_TYPE_CODE, ENTERPRISE_SIZE_CODE, ENTERPRISE_SCOPE, JURISTIC_TYPE_CODE, JURISTIC_CUST_ID, JURISTIC_NAME, BUSI_LICENCE_TYPE, BUSI_LICENCE_NO, BUSI_LICENCE_VALID_DATE, GROUP_MEMO, BANK_ACCT, BANK_NAME, REG_MONEY, REG_DATE, CUST_AIM, SCOPE, MAIN_BUSI, MAIN_TRADE, EMP_LSAVE, LATENCY_FEE_SUM, YEAR_GAIN, TURNOVER, CONSUME, COMM_BUDGET, GTEL_BUDGET, LTEL_BUDGET, GROUP_ADVERSARY, VPMN_GROUP_ID, VPMN_NUM, USER_NUM, EMP_NUM_LOCAL, EMP_NUM_CHINA, EMP_NUM_ALL, TELECOM_NUM_GH, TELECOM_NUM_XLT, MOBILE_NUM_CHINAGO, MOBILE_NUM_GLOBAL, MOBILE_NUM_MZONE, MOBILE_NUM_LOCAL, UNICOM_NUM_G, UNICOM_NUM_C, UNICOM_NUM_GC, PRODUCT_NUM_LOCAL, PRODUCT_NUM_OTHER, PRODUCT_NUM_USE, EMPLOYEE_ARPU, NETRENT_PAYOUT, MOBILE_PAYOUT, UNICOM_PAYOUT, TELECOM_PAYOUT_XLT, GROUP_PAY_MODE, PAYFOR_WAY_CODE, WRITEFEE_COUNT, WRITEFEE_SUM, USER_NUM_FULLFREE, USER_NUM_WRITEOFF, BOSS_FEE_SUM, DOYEN_STAFF_ID, NEWTRADE_COMMENT, LIKE_MOBILE_TRADE, LIKE_DISCNT_MODE, FINANCE_EARNING, SUBCLASS_ID, WEBSITE, FAX_NBR, EMAIL, POST_CODE, REMOVE_TAG, REMOVE_DATE, REMOVE_STAFF_ID, REMOVE_CHANGE, UPDATE_TIME, UPDATE_STAFF _ID, UPDATE_DEPART_ID, REMARK, RSRV_NUM1, RSRV_NUM2, RSRV_NUM3, RSRV_STR1, RSRV_STR2, RSRV_STR3, RSRV_STR4, RSRV_STR5, RSRV_STR6, RSRV_STR7, RSRV_STR8, RSRV_DATE1, RSRV_DATE2, RSRV_DATE3, RSRV_TAG1, RSRV_TAG2, RSRV_TAG3, CLASS_ID2, ACCEPT_CHANNEL, CALL_TYPE, AGREEMENT, BUSI_TYPE, REMOVE_FLAG, REMOVE_METHOD, REMOVE_REASON_CODE, AUDIT_STATE, AUDIT_DATE, AUDIT_STAFF_ID, AUDIT_NOTE, EARNING_ORDER, PNATIONAL_GROUP_ID, PROVINCE_CODE, PNATIONAL_GROUP_NAME, GROUP_VALID_SCORE, GROUP_SUM_SCORE, GROUP_MGR_SN, GROUP_MGR_USER_ID, GROUP_MGR_CUST_NAME, BASE_ACCESS_NO, BASE_ACCESS_NO_KIND, CUST_SERV_NBR, IF_SHORT_PIN, CALLING_POLICY_FORCE, CALLING_TYPE_CODE_DETAIL, SERVER_ASSIGN_DATE, SERVER_ASSIGN_STAFF_ID, TURN_INNET_DATE, TURN_INNET_STAFF_ID, TAKE_PICTURE_TAG, CUST_MANAGER_ID_B, CLASS_ID2_START_DATE, CLASS_ID2_END_DATE, IF_RELATION_CUST, AREA_OFFICE, MANAGE_CODE, INTERNATIONAL, FILE_CODE, FINANCE_INSTANCE, GROW_POTENTIAL, CREDIT_DEGREE, BELONG_TEAM_ID, BELONG_TEAM_ID_B, LAST_CLASS_ID2, CLASS2_CHANGE_DATE, LICENCE_AUDIT_PERSON, LICENCE_AUDIT_FILE_ID, JURISTIC_PSPT_ID, JURISTIC_PSPT_TYPE, TEL_DECISION_TYPE, BUSI_TAX_ID, DATE_FLAG) VALUES (:CUST_ID, :GROUP_ID, :CUST_NAME, :GROUP_TYPE, :CLASS_ID, :LAST_CLASS_ID, :CLASS_CHANGE_DATE, :CUST_CLASS_TYPE, :GROUP_ATTR, :GROUP_STATUS, :GROUP_ADDR, :EPARCHY_CODE, :CITY_CODE, :SUPER_GROUP_ID, :MP_GROUP_CUST_CODE, :UNIFY_PAY_CODE, :ORG_STRUCT_CODE, :CUST_MANAGER_ID, :CUST_MANAGER_APPR, :ASSIGN_DATE, :ASSIGN_STAFF_ID, :CALLING_TYPE_CODE, :SUB_CALLING_TYP E_CODE, :CALLING_AREA_CODE, :GROUP_CONTACT_PHONE, :ENTERPRISE_TYPE_CODE, :ENTERPRISE_SIZE_CODE, :ENTERPRISE_SCOPE, :JURISTIC_TYPE_CODE, :JURISTIC_CUST_ID, :JURISTIC_NAME, :BUSI_LICENCE_TYPE, :BUSI_LICENCE_NO, :BUSI_LICENCE_VALID_DATE, :GROUP_MEMO, :BANK_ACCT, :BANK_NAME, :REG_MONEY, :REG_DATE, :CUST_AIM, :SCOPE, :MAIN_BUSI, :MAIN_TRADE, :EMP_LSAVE, :LATENCY_FEE_SUM, :YEAR_GAIN, :TURNOVER, :CONSUME, :COMM_BUDGET, :GTEL_BUDGET, :LTEL_BUDGET, :GROUP_ADVERSARY, :VPMN_GROUP_ID, :VPMN_NUM, :USER_NUM, :EMP_NUM_LOCAL, :EMP_NUM_CHINA, :EMP_NUM_ALL, :TELECOM_NUM_GH, :TELECOM_NUM_XLT, :MOBILE_NUM_CHINAGO, :MOBILE_NUM_GLOBAL, :MOBILE_NUM_MZONE, :MOBILE_NUM_LOCAL, :UNICOM_NUM_G, :UNICOM_NUM_C, :UNICOM_NUM_GC, :PRODUCT_NUM_LOCAL, :PRODUCT_NUM_OTHER, :PRODUCT_NUM_USE, :EMPLOYEE_ARPU, :NETRENT_PAYOUT, :MOBILE_PAYOUT, :UNICOM_PAYOUT, :TELECOM_PAYOUT_XLT, :GROUP_PAY_MODE, :PAYFOR_WAY_CODE, :WRITEFEE_COUNT, :WRITEFEE_SUM, :USER_NUM_FULLFREE, :USER_NUM_WRITEOFF, :BOSS_FEE_SUM, :DOYEN_STAFF_ID, :NEWTRADE_COMMENT, :LIKE_MOBILE_TRADE, :LIKE_DISCNT_MODE, :FINANCE_EARNING, :SUBCLASS_ID, :WEBSITE, :FAX_NBR, :EMAIL, :POST_CODE, :REMOVE_TAG, :REMOVE_DATE, :REMOVE_STAFF_ID, :REMOVE_CHANGE, :UPDATE_TIME, :UPDATE_STAFF_ID, :UPDATE_DEPART_ID, :REMARK, :RSRV_NUM1, :RSRV_NUM2, :RSRV_NUM3, :RSRV_STR1, :RSRV_STR2, :RSRV_STR3, :RSRV_STR4, :RSRV_STR5, :RSRV_STR6, :RSRV_STR7, :RSRV_STR8, :RSRV_DATE1, :RSRV_DATE2, :RSRV_DATE3, :RSRV_TAG1, :RSRV_TAG2, :RSRV_TAG3, :CLASS_ID2, :ACCEPT_CHANNEL, :CALL_TYPE, :AGREEMENT, :BUSI_TYPE, :REMOVE_FLAG, :REMOVE_METHOD, :REMOVE_REASON_CODE, :AUDIT_STATE, :AUDIT_DATE, :AUDIT_STAFF_ID, :AUDIT_NOTE, :EARNING_ORDER, :PNATIONAL_GROUP_ID, :PROVINCE_CODE, :PNATIONAL_GROUP_NAME, :GROUP_VALID_SCORE, :GROUP_SUM_SCORE, :GROUP_MGR_SN, :GROUP_MGR_USER_ID, :GROUP_MGR_CUST_NAME, :BASE_ACCESS_NO, :BASE_ACCESS_NO_KIND, :CUST_SERV_NBR, :IF_SHORT_PIN, :CALLING_POLICY_FORCE, :CALLING_TYPE_CODE_DETAIL, :SERVER_ASSIGN_DATE, :SERVER_ASSIGN_STAFF_ID, :TURN_INNET_DATE, :TURN_INNET_STAFF_ID, :TAKE_PICTURE_TAG, :CUST_MANAGER_ID_B, :CLASS_ID2_START_DATE, :CLASS_ID2_END_DATE, :IF_RELATION_CUST, :AREA_OFFICE, :MANAGE_CODE, :INTERNATIONAL, :FILE_CODE, :FINANCE_INSTANCE, :GROW_POTENTIAL, :CREDIT_DEGREE, :BELONG_TEAM_ID, :BELONG_TEAM_ID_B, :LAST_CLASS_ID2, :CLASS2_CHANGE_DATE, :LICENCE_AUDIT_PERSON, :LICENCE_AUDIT_FILE_ID, :JURISTIC_PSPT_ID, :JURISTIC_PSPT_TYPE, :TEL_DECISION_TYPE, :BUSI_TAX_ID, nvl(:"DATE_FLAG", '20140503'))
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4gb7r5dm6hnzsSELECT CONF#, NAME, VALUE FROM V$RMAN_CONFIGURATION RM WHERE ((:B2 IS NULL OR UPPER(:B2 ) = UPPER(RM.NAME)) AND (:B1 IS NULL OR UPPER(:B1 ) = UPPER(RM.VALUE)))
4sjhtt4cxs9vd delete from TI_CRM_USER_ITEM where date_flag=20140503
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6f69jd49t88z0SELECT /*+ OPAQUE_TRANSFORM */ "DEAL_TIME", "CALL_TYPE", "MSISDN", "OTHER_PARTY", "SEND_STATUS" FROM "TI_BIL_GSM_SMS_20140503" "T"
7d77yhq6b7t9rINSERT INTO TI_CRM_USER_INFOCHANGE (PARTITION_ID, USER_ID, PRODUCT_ID, BRAND_CODE, SERIAL_NUMBER, IMSI, IMSI2, START_DATE, END_DATE, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :PRODUCT_ID, :BRAND_CODE, :SERIAL_NUMBER, :IMSI, :IMSI2, :START_DATE, :END_DATE, nvl(:"DATE_FLAG", '20140503'))
7nu3m2jfnu2hnSELECT "A1"."START_DATE", "A1"."MSISDN", "A1"."B_MSISDN", COUNT(*) FROM "HJFX"."TI_BIL_GSM_CALL_20140503" "A1" WHERE "A1"."START_DATE"='20140503' GROUP BY "A1"."START_DATE", "A1"."MSISDN", "A1"."B_MSISDN"
81qnwktdc1g9h SELECT "A1"."TASK_ID", MAX(DECODE("A1"."FTP_DOWN_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_DOWN_STATUS")), MAX(DECODE("A1"."FTP_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."FTP_CHECK_STATUS")), MAX(DECODE("A1"."CREATE_LOG_STATUS", '1001', NULL, '1000', NULL, "A1"."CREATE_LOG_STATUS")), MAX(DECODE("A1"."INTERFACE_CHECK_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_CHECK_STATUS")), MAX(DECODE("A1"."MK_CTL_STATUS", '1001', NULL, '1000', NULL, "A1"."MK_CTL_STATUS")), MAX(DECODE("A1"."IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."IMPORT_STATUS")), MAX(DECODE("A1"."CHECK_IMPORT_STATUS", '1001', NULL, '1000', NULL, "A1"."CHECK_IMPORT_STATUS")), MAX(DECODE("A1"."INTERFACE_GZIP_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_GZIP_STATUS")), MAX(DECODE("A1"."INTERFACE_COMPRESS_STATUS", '1001', NULL, '1000', NULL, "A1"."INTERFACE_COMPRESS_STATUS")), "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE" FROM "TI_INTERFACE_PERIOD_STATUS" "A1" WHERE ("A1"."FTP_DOWN_STATUS">'1001' OR "A1"."FTP_CHECK_STATUS">'1001' OR "A1"."CREATE_LOG_STATUS">'1001' OR "A1"."INTERFACE_CHECK_STATUS">'1001' OR "A1"."MK_CTL_STATUS">'1001' OR "A1"."IMPORT_STATUS">'1001' OR "A1"."CHECK_IMPORT_STATUS">'1001' OR "A1"."INTERFACE_GZIP_STATUS">'1001' OR "A1"."INTERFACE_COMPRESS_STATUS">'1001') AND ("A1"."TASK_DATE"=:1 AND "A1"."INTERFACE_SOURCE"<>'hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A4" WHERE "A4"."TASK_DATE"=: 2 AND "A4"."INTERFACE_SOURCE"<>'hospital_register' AND "A4"."TASK_ID"<>'1007' AND "A4"."TASK_ID"<>'1008' AND "A4"."FTP_DOWN_STATUS"<'1002' AND "A4"."FTP_CHECK_STATUS"<'1002' AND "A4"."CREATE_LOG_STATUS"<'1002' AND "A4"."INTERFACE_CHECK_STATUS"<'1002' AND "A4"."MK_CTL_STATUS"<'1002' AND "A4"."IMPORT_STATUS"<'1002' AND "A4"."CHECK_IMPORT_STATUS"<'1002' AND "A4"."INTERFACE_GZIP_STATUS"<'1002' AND "A4"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A4"."TASK_ID" HAVING LNNVL("A4"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:3 AND "A1"."INTERFACE_SOURCE"='hospital_register' AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A3" WHERE "A3"."TASK_DATE"=:4 AND "A3"."INTERFACE_SOURCE"='hospital_register' AND "A3"."FTP_DOWN_STATUS"<'1002' AND "A3"."FTP_CHECK_STATUS"<'1002' AND "A3"."CREATE_LOG_STATUS"<'1002' AND "A3"."INTERFACE_CHECK_STATUS"<'1002' AND "A3"."MK_CTL_STATUS"<'1002' AND "A3"."IMPORT_STATUS"<'1002' AND "A3"."CHECK_IMPORT_STATUS"<'1002' AND "A3"."INTERFACE_GZIP_STATUS"<'1002' AND "A3"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A3"."TASK_ID" HAVING LNNVL("A3"."TASK_ID"<>"A1"."TASK_ID")) OR "A1"."TASK_DATE"=:5 AND ("A1"."TASK_ID"='1007' OR "A1"."TASK_ID"='1008') AND NOT EXISTS (SELECT 0 FROM "TI_INTERFACE_PERIOD_STATUS" "A2" WHERE "A2"."TASK_DATE"=:6 AND ("A2"."TASK_ID"='1007' OR "A2"."TASK_ID"='1008') AND "A2"."FTP_DOWN_STATUS"<'1002' AND "A2"."FTP_CHECK_STATUS"<'1002' AN D "A2"."CREATE_LOG_STATUS"<'1002' AND "A2"."INTERFACE_CHECK_STATUS"<'1002' AND "A2"."MK_CTL_STATUS"<'1002' AND "A2"."IMPORT_STATUS"<'1002' AND "A2"."CHECK_IMPORT_STATUS"<'1002' AND "A2"."INTERFACE_GZIP_STATUS"<'1002' AND "A2"."INTERFACE_COMPRESS_STATUS"<'1002' GROUP BY "A2"."TASK_ID" HAVING LNNVL("A2"."TASK_ID"<>"A1"."TASK_ID"))) GROUP BY "A1"."TASK_ID", "A1"."TASK_DATE", "A1"."EXECUTE_ID", "A1"."INTERFACE_SOURCE"
8awnpu7d730drINSERT INTO TI_CRM_USER_SP (PARTITION_ID, USER_ID, SERIAL_NUMBER, PRODUCT_ID, PACKAGE_ID, PARTY_ID, SP_ID, SP_PRODUCT_ID, FIRST_BUY_TIME, PAY_SERIAL_NUMBER, START_DATE, END_DATE, UPDATE_TIME, PAY_USER_ID, SP_SERVICE_ID, ITEM_ID, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :SERIAL_NUMBER, :PRODUCT_ID, :PACKAGE_ID, :PARTY_ID, :SP_ID, :SP_PRODUCT_ID, :FIRST_BUY_TIME, :PAY_SERIAL_NUMBER, :START_DATE, :END_DATE, :UPDATE_TIME, :PAY_USER_ID, :SP_SERVICE_ID, :ITEM_ID, nvl(:"DATE_FLAG", '20140503'))
8dmvks9ksswcr INSERT INTO TI_CRM_TRADE (TRADE_ID, SUBSCRIBE_ID, BPM_ID, TRADE_TYPE_CODE, IN_MODE_CODE, PRIORITY, SUBSCRIBE_STATE, NEXT_DEAL_TAG, PRODUCT_ID, BRAND_CODE, USER_ID, CUST_ID, USECUST_ID, ACCT_ID, USER_DIFF_CODE, NET_TYPE_CODE, SERIAL_NUMBER, CUST_NAME, ACCEPT_DATE, ACCEPT_MONTH, TRADE_STAFF_ID, TRADE_DEPART_ID, TRADE_CITY_CODE, TRADE_EPARCHY_CODE, TERM_IP, EPARCHY_CODE, CITY_CODE, OLCOM_TAG, EXEC_TIME, FINISH_DATE, OPER_FEE, FORINVOICE_NOEGIFT, ADVANCE_PAY, INVOICE_NO, FEE_STATE, FEE_TIME, FEE_STAFF_ID, CANCEL_TAG, CANCEL_DATE, CANCEL_STAFF_ID, CANCEL_DEPART_ID, CANCEL_CITY_CODE, CANCEL_EPARCHY_CODE, CHECK_TYPE_CODE, CHK_TAG, AUDIT_TAG, AUDIT_BATCH_NO, ACTOR_NAME, ACTOR_CERTTYPEID, ACTOR_PHONE, ACTOR_CERTNUM, CONTACT, CONTACT_PHONE, CONTACT_ADDRESS, REMARK, IF_MAINTENANCE, ORDER_ID, SUB_ORDER_ID, DATE_FLAG) VALUES (:TRADE_ID, :SUBSCRIBE_ID, :BPM_ID, :TRADE_TYPE_CODE, :IN_MODE_CODE, :PRIORITY, :SUBSCRIBE_STATE, :NEXT_DEAL_TAG, :PRODUCT_ID, :BRAND_CODE, :USER_ID, :CUST_ID, :USECUST_ID, :ACCT_ID, :USER_DIFF_CODE, :NET_TYPE_CODE, :SERIAL_NUMBER, :CUST_NAME, :ACCEPT_DATE, :ACCEPT_MONTH, :TRADE_STAFF_ID, :TRADE_DEPART_ID, :TRADE_CITY_CODE, :TRADE_EPARCHY_CODE, :TERM_IP, :EPARCHY_CODE, :CITY_CODE, :OLCOM_TAG, :EXEC_TIME, :FINISH_DATE, :OPER_FEE, :FORINVOICE_NOEGIFT, :ADVANCE_PAY, :INVOICE_NO, :FEE_STATE, :FEE_TIME, :FEE_STAFF_ID, :CANCEL_TAG, :CANCEL_DATE, :CANCEL_STAFF_ID, :CANCEL_DEPART_ID, :CANCEL_CITY_CODE, :CANCEL_EPARCHY_CODE, :CHECK_TYPE_CODE, :CHK_TAG, :AUDIT_TAG, :AUDIT_BAT CH_NO, :ACTOR_NAME, :ACTOR_CERTTYPEID, :ACTOR_PHONE, :ACTOR_CERTNUM, :CONTACT, :CONTACT_PHONE, :CONTACT_ADDRESS, :REMARK, :IF_MAINTENANCE, :ORDER_ID, :SUB_ORDER_ID, nvl(:"DATE_FLAG", '20140503'))
8kyudmnh5n5nq INSERT INTO TI_CRM_USER (PARTITION_ID, USER_ID, CUST_ID, USECUST_ID, BRAND_CODE, PRODUCT_ID, EPARCHY_CODE, CITY_CODE, USER_PASSWD, USER_DIFF_CODE, USER_TYPE_CODE, SERIAL_NUMBER, NET_TYPE_CODE, SCORE_VALUE, CREDIT_CLASS, BASIC_CREDIT_VALUE, CREDIT_VALUE, ACCT_TAG, PREPAY_TAG, IN_DATE, OPEN_DATE, OPEN_MODE, OPEN_DEPART_ID, OPEN_STAFF_ID, IN_DEPART_ID, IN_STAFF_ID, REMOVE_TAG, DESTROY_TIME, REMOVE_EPARCHY_CODE, REMOVE_CITY_CODE, REMOVE_DEPART_ID, REMOVE_REASON_CODE, PRE_DESTROY_TIME, FIRST_CALL_TIME, LAST_STOP_TIME, USER_STATE_CODESET, MPUTE_MONTH_FEE, MPUTE_DATE, UPDATE_TIME, ASSURE_CUST_ID, ASSURE_TYPE_CODE, ASSURE_DATE, DEVELOP_STAFF_ID, DEVELOP_DATE, DEVELOP_EPARCHY_CODE, DEVELOP_CITY_CODE, DEVELOP_DEPART_ID, DEVELOP_NO, REMARK, CREDIT_RULE_ID, CONTRACT_ID, CHANGEUSER_DATE, IN_NET_MODE, PRODUCT_TYPE_CODE, MAIN_DISCNT_CODE, PRODUCT_SPEC, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :CUST_ID, :USECUST_ID, :BRAND_CODE, :PRODUCT_ID, :EPARCHY_CODE, :CITY_CODE, :USER_PASSWD, :USER_DIFF_CODE, :USER_TYPE_CODE, :SERIAL_NUMBER, :NET_TYPE_CODE, :SCORE_VALUE, :CREDIT_CLASS, :BASIC_CREDIT_VALUE, :CREDIT_VALUE, :ACCT_TAG, :PREPAY_TAG, :IN_DATE, :OPEN_DATE, :OPEN_MODE, :OPEN_DEPART_ID, :OPEN_STAFF_ID, :IN_DEPART_ID, :IN_STAFF_ID, :REMOVE_TAG, :DESTROY_TIME, :REMOVE_EPARCHY_CODE, :REMOVE_CITY_CODE, :REMOVE_DEPART_ID, :REMOVE_REASON_CODE, :PRE_DESTROY_TIME, :FIRST_CALL_TIME, :LAST_STOP_TIME, :USER_STATE_CODESET, :MPUTE_MONTH_FEE, :MPUTE_DATE, :UPDATE_TIME, :ASSURE_CUST_ID, :ASSURE_TYPE_CODE , :ASSURE_DATE, :DEVELOP_STAFF_ID, :DEVELOP_DATE, :DEVELOP_EPARCHY_CODE, :DEVELOP_CITY_CODE, :DEVELOP_DEPART_ID, :DEVELOP_NO, :REMARK, :CREDIT_RULE_ID, :CONTRACT_ID, :CHANGEUSER_DATE, :IN_NET_MODE, :PRODUCT_TYPE_CODE, :MAIN_DISCNT_CODE, :PRODUCT_SPEC, nvl(:"DATE_FLAG", '20140503'))
90auk3pxw1vmq delete from TI_CRM_CUSTOMER where date_flag=20140503
9nkpcbuhv1cs8select count(*) from TI_BIL_GSM_SMS_20140503
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
b3zyut8n5350d delete from TI_CRM_TRADE where date_flag=20140503
b622brt1685fcINSERT INTO TI_CRM_CUST_CONTACT (CONTACT_ID, CUST_ID, MYSELF_FLAG, CONTACT_NAME, CONTACT_PHONE, CONTACT_FAX, CONTACT_EMAIL, CONTACT_POST_CODE, CONTACT_POST_ADDR, CONTACT_HOME_ADDR, CONTACT_PSPT_TYPE_CODE, CONTACT_PSPT_ID, CONTACT_WORK_NAME, CONTACT_WORK_ADDR, CONTACT_DEPART, CONTACT_DUTY, BEST_CONTACT_TIME, FIRST_CONTACT_MODE, UPDATE_TIME, UPDATE_STAFF_ID, UPDATE_DEPART_ID, REMARK, RSRV_NUM1, RSRV_NUM2, RSRV_NUM3, RSRV_STR1, RSRV_STR2, RSRV_STR3, RSRV_STR4, RSRV_STR5, RSRV_STR6, RSRV_DATE1, RSRV_DATE2, RSRV_TAG1, RSRV_TAG2, DATE_FLAG) VALUES (:CONTACT_ID, :CUST_ID, :MYSELF_FLAG, :CONTACT_NAME, :CONTACT_PHONE, :CONTACT_FAX, :CONTACT_EMAIL, :CONTACT_POST_CODE, :CONTACT_POST_ADDR, :CONTACT_HOME_ADDR, :CONTACT_PSPT_TYPE_CODE, :CONTACT_PSPT_ID, :CONTACT_WORK_NAME, :CONTACT_WORK_ADDR, :CONTACT_DEPART, :CONTACT_DUTY, :BEST_CONTACT_TIME, :FIRST_CONTACT_MODE, :UPDATE_TIME, :UPDATE_STAFF_ID, :UPDATE_DEPART_ID, :REMARK, :RSRV_NUM1, :RSRV_NUM2, :RSRV_NUM3, :RSRV_STR1, :RSRV_STR2, :RSRV_STR3, :RSRV_STR4, :RSRV_STR5, :RSRV_STR6, :RSRV_DATE1, :RSRV_DATE2, :RSRV_TAG1, :RSRV_TAG2, nvl(:"DATE_FLAG", '20140503'))
bgw2v929ws708SELECT "END_DATE", "MSISDN", "B_MSISDN" FROM "HJFX"."TI_BIL_GSM_CALL_20140503" "T" WHERE LENGTH("MSISDN")=11 AND "END_DATE"='20140503' AND (SUBSTR("MSISDN", 1, 3)='130' OR SUBSTR("MSISDN", 1, 3)='131' OR SUBSTR("MSISDN", 1, 3)='132' OR SUBSTR("MSISDN", 1, 3)='155' OR SUBSTR("MSISDN", 1, 3)='156' OR SUBSTR("MSISDN", 1, 3)='185' OR SUBSTR("MSISDN", 1, 3)='186')
bsa0wjtftg3uwselect file# from file$ where ts#=:1
ca7fk0wugft6vALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '., ' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP= 'BINARY' NLS_DUAL_CURRENCY= '$' NLS_TIME_FORMAT= 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT= 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT= 'DD-MON-RR HH.MI.SSXFF AM TZR'
ct91xzzquzxrbINSERT INTO TI_CONTRACT_USER NOLOGGING SELECT SERIAL_NUMBER, PRODUCT_NAME, SYSDATE INSERT_DATE FROM (SELECT SERIAL_NUMBER, PRODUCT_NAME, OPEN_DATE, ROW_NUMBER() OVER(PARTITION BY SERIAL_NUMBER ORDER BY OPEN_DATE DESC) RN FROM (SELECT A.SERIAL_NUMBER, C.PRODUCT_NAME, A.OPEN_DATE FROM TI_CRM_USER A, Ti_Crm_User_Product B, GR_DIM.DIM_ACRM_PRODUCT_ID@TO_HJFX81_CAL C WHERE A.USER_ID = B.USER_ID AND A.PRODUCT_ID = C.PRODUCT_ID AND A.NET_TYPE_CODE IN ('10', '16', '17', '33') AND A.REMOVE_TAG IN ('0', '1', '3') AND B.PRODUCT_MODE = '50' AND SUBSTR(A.SERIAL_NUMBER, 1, 3) <> '145' AND SUBSTR(B.START_DATE, 1, 8) = TO_CHAR(SYSDATE-1, 'yyyymmdd'))) WHERE RN = 1
d7asga0n8bncu delete from TI_CRM_USER_PRODUCT where date_flag=20140503
dkjwfukzdcpfuINSERT INTO TI_CRM_USER_SVCSTATE (PARTITION_ID, USER_ID, SERVICE_ID, MAIN_TAG, STATE_CODE, START_DATE, END_DATE, UPDATE_TIME, DATE_FLAG) VALUES (:PARTITION_ID, :USER_ID, :SERVICE_ID, :MAIN_TAG, :STATE_CODE, :START_DATE, :END_DATE, :UPDATE_TIME, nvl(:"DATE_FLAG", '20140503'))
dwy3t2d67r8d0 delete from TI_CRM_RELATION_UU where date_flag=20140503
f9mzcbwxgj895 delete from TI_CRM_USER_SVC where date_flag=20140503
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
g5qu5acjj2bbv INSERT INTO TI_CRM_CUST_GROUPMEMBER (CUST_ID, GROUP_ID, GROUP_CUST_NAME, GROUP_TYPE, MEMBER_KIND, MEMBER_CUST_ID, USECUST_ID, USER_ID, SERIAL_NUMBER, NET_TYPE_CODE, CUST_NAME, USECUST_NAME, USEPSPT_TYPE_CODE, USEPSPT_ID, USEPSPT_END_DATE, USEPSPT_ADDR, USEPHONE, USEPOST_ADDR, EPARCHY_CODE, CITY_CODE, STRU_ID, VPMN_GROUP_ID, VIP_ID, VIP_TYPE_CODE, VIP_CLASS_ID, VIP_TYPE_CODE_B, VIP_CLASS_ID_B, JOIN_TYPE, JOIN_DATE, JOIN_STAFF_ID, JOIN_DEPART_ID, CONTRACT_NO, MONTH_FEE, FEE_PAYMODE, DEPART, DUTY, HVALUE_TAG, CUST_MANAGER_ID, CUST_MANAGER_APPR, LIKE_MOBILE_BUSI, LIKE_DISCNT_TYPE, LIKE_ACT, SVC_MODE_CODE, CONTACT_ORDER, BRAND_CODE, PRODUCT_ID, USER_TYPE_CODE, USER_STATE_CODESET, OPEN_DATE, OPEN_MODE, OPEN_DEPART_ID, OPEN_STAFF_ID, IN_DATE, IN_NET_MODE, IN_DEPART_ID, IN_STAFF_ID, DEVELOP_DATE, DEVELOP_EPARCHY_CODE, DEVELOP_CITY_CODE, DEVELOP_STAFF_ID, DEVELOP_DEPART_ID, FIRST_CALL_TIME, LAST_STOP_TIME, CREDIT_CLASS, SCORE_VALUE, BASIC_CREDIT_VALUE, CREDIT_VALUE, CREDIT_TYPE, CREDIT_TRADE_TAG, CTAG_SET, CHECK_NO, REMOVE_TAG, REMOVE_DATE, REMOVE_STAFF_ID, REMOVE_REASON, UPDATE_TIME, UPDATE_STAFF_ID, UPDATE_DEPART_ID, REMARK, RSRV_NUM1, RSRV_NUM2, RSRV_NUM3, RSRV_NUM4, RSRV_NUM5, RSRV_STR1, RSRV_STR2, RSRV_STR3, RSRV_STR4, RSRV_STR5, RSRV_STR6, RSRV_STR7, RSRV_STR8, RSRV_DATE1, RSRV_DATE2, RSRV_DATE3, RSRV_DATE4, RSRV_DATE5, RSRV_TAG1, RSRV_TAG2, RSRV_TAG3, RSRV_TAG4, RSRV_TAG5, MEMBER_BELONG, TRADE_ID, CANCEL_TAG, CLUB_ID, ASSIGN_DATE, ASSIGN_STAFF_ID, MEMBER_ATTACH_TAG, TAKE_PICT URE_TAG, SUB_GROUP_ID, TEAM_ID, DATE_FLAG) VALUES (:CUST_ID, :GROUP_ID, :GROUP_CUST_NAME, :GROUP_TYPE, :MEMBER_KIND, :MEMBER_CUST_ID, :USECUST_ID, :USER_ID, :SERIAL_NUMBER, :NET_TYPE_CODE, :CUST_NAME, :USECUST_NAME, :USEPSPT_TYPE_CODE, :USEPSPT_ID, :USEPSPT_END_DATE, :USEPSPT_ADDR, :USEPHONE, :USEPOST_ADDR, :EPARCHY_CODE, :CITY_CODE, :STRU_ID, :VPMN_GROUP_ID, :VIP_ID, :VIP_TYPE_CODE, :VIP_CLASS_ID, :VIP_TYPE_CODE_B, :VIP_CLASS_ID_B, :JOIN_TYPE, :JOIN_DATE, :JOIN_STAFF_ID, :JOIN_DEPART_ID, :CONTRACT_NO, :MONTH_FEE, :FEE_PAYMODE, :DEPART, :DUTY, :HVALUE_TAG, :CUST_MANAGER_ID, :CUST_MANAGER_APPR, :LIKE_MOBILE_BUSI, :LIKE_DISCNT_TYPE, :LIKE_ACT, :SVC_MODE_CODE, :CONTACT_ORDER, :BRAND_CODE, :PRODUCT_ID, :USER_TYPE_CODE, :USER_STATE_CODESET, :OPEN_DATE, :OPEN_MODE, :OPEN_DEPART_ID, :OPEN_STAFF_ID, :IN_DATE, :IN_NET_MODE, :IN_DEPART_ID, :IN_STAFF_ID, :DEVELOP_DATE, :DEVELOP_EPARCHY_CODE, :DEVELOP_CITY_CODE, :DEVELOP_STAFF_ID, :DEVELOP_DEPART_ID, :FIRST_CALL_TIME, :LAST_STOP_TIME, :CREDIT_CLASS, :SCORE_VALUE, :BASIC_CREDIT_VALUE, :CREDIT_VALUE, :CREDIT_TYPE, :CREDIT_TRADE_TAG, :CTAG_SET, :CHECK_NO, :REMOVE_TAG, :REMOVE_DATE, :REMOVE_STAFF_ID, :REMOVE_REASON, :UPDATE_TIME, :UPDATE_STAFF_ID, :UPDATE_DEPART_ID, :REMARK, :RSRV_NUM1, :RSRV_NUM2, :RSRV_NUM3, :RSRV_NUM4, :RSRV_NUM5, :RSRV_STR1, :RSRV_STR2, :RSRV_STR3, :RSRV_STR4, :RSRV_STR5, :RSRV_STR6, :RSRV_STR7, :RSRV_STR8, :RSRV_DATE1, :RSRV_DATE2, :RSRV_DATE3, :RSRV_DATE4, :RSRV_DATE5, :RSRV_TAG1, :RSRV_TAG2, :RSRV_TAG3, :RSRV_TAG4, :R SRV_TAG5, :MEMBER_BELONG, :TRADE_ID, :CANCEL_TAG, :CLUB_ID, :ASSIGN_DATE, :ASSIGN_STAFF_ID, :MEMBER_ATTACH_TAG, :TAKE_PICTURE_TAG, :SUB_GROUP_ID, :TEAM_ID, nvl(:"DATE_FLAG", '20140503'))
g8vtadgavaqavINSERT INTO TI_CRM_USER_SVC_ITEM (PARTITION_ID, ITEM_ID, ATTR_CODE, ATTR_VALUE, START_DATE, END_DATE, DATE_FLAG) VALUES (:PARTITION_ID, :ITEM_ID, :ATTR_CODE, :ATTR_VALUE, :START_DATE, :END_DATE, nvl(:"DATE_FLAG", '20140503'))
g95yuw3u9h2t7 delete from TI_CRM_CUST_PERSON where date_flag=20140503
ghpn0aaynsbuhselect count(*) from TI_BIL_GSM_CALL_20140503
gqxj3bu3gjudpSELECT /*+ OPAQUE_TRANSFORM */ "SOURCE_TYPE", "BIZ_TYPE", "FID", "RR_FLAG", "START_DATE", "START_TIME", "END_DATE", "END_TIME", "CALL_TYPE", "IMSI_NUMBER", "MSISDN", "SERVICE_TYPE", "SERVICE_CODE", "IMEI", "VISIT_AREA_CODE", "B_MSISDN", "CALLED_CODE", "LONG_TYPE1", "LONG_TYPE2", "ROAM_TYPE", "CALL_DURATION", "CFEE", "LFEE", "OTHERFEE", "DISCOUNT_CFEE", "DISCOUNT_LFEE", "DISCOUNT_OTHERFEE", "TARIFF_FEE" FROM "TI_BIL_GSM_CALL_20140503" "T"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 438,108 5.07 0.03
CPU used when call started 432,849 5.01 0.03
CR blocks created 30,633 0.35 0.00
Cached Commit SCN referenced 8,881,255 102.76 0.54
Commit SCN cached 138 0.00 0.00
DB time 9,874,487 114.25 0.60
DBWR checkpoint buffers written 6,664,997 77.12 0.41
DBWR checkpoints 1,096 0.01 0.00
DBWR object drop buffers written 6,554 0.08 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 410 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 2,400 0.03 0.00
DBWR undo block writes 531,705 6.15 0.03
DFO trees parallelized 0 0.00 0.00
IMU CR rollbacks 286 0.00 0.00
IMU Flushes 16,231,388 187.80 0.99
IMU Redo allocation size ############### 1,534,349.21 8,122.25
IMU commits 42,754 0.49 0.00
IMU contention 2 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 54,464 0.63 0.00
IMU recursive-transaction flush 1 0.00 0.00
IMU undo allocation size 16,038,108,400 185,567.64 982.32
IMU- failed to get a private strand 54,464 0.63 0.00
Misses for writing mapping 1 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 not downgraded 0 0.00 0.00
SMON posted for dropping temp segment 690 0.01 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 118 0.00 0.00
SQL*Net roundtrips to/from client 33,744,648 390.44 2.07
SQL*Net roundtrips to/from dblink 40 0.00 0.00
active txn count during cleanout 7,003,465 81.03 0.43
application wait time 3,540 0.04 0.00
background checkpoints completed 51 0.00 0.00
background checkpoints started 51 0.00 0.00
background timeouts 278,250 3.22 0.02
branch node splits 0 0.00 0.00
buffer is not pinned count 3,636,709 42.08 0.22
buffer is pinned count 1,911,535 22.12 0.12
bytes received via SQL*Net from client ############### 1,158,170.95 6,130.91
bytes received via SQL*Net from dblink 3,468,858 40.14 0.21
bytes sent via SQL*Net to client 12,280,274,092 142,087.92 752.16
bytes sent via SQL*Net to dblink 8,415 0.10 0.00
calls to get snapshot scn: kcmgss 28,347,186 327.99 1.74
calls to kcmgas 17,128,122 198.18 1.05
calls to kcmgcs 11,047,160 127.82 0.68
change write time 92,581 1.07 0.01
cleanout - number of ktugct calls 7,003,824 81.04 0.43
cleanouts and rollbacks - consistent read gets 177 0.00 0.00
cleanouts only - consistent read gets 214 0.00 0.00
cluster key scan block gets 2,890,313 33.44 0.18
cluster key scans 88,388 1.02 0.01
commit batch performed 695 0.01 0.00
commit batch requested 695 0.01 0.00
commit batch/immediate performed 698 0.01 0.00
commit batch/immediate requested 698 0.01 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 459 0.01 0.00
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 27,596,140 319.30 1.69
commit cleanouts successfully completed 27,595,681 319.29 1.69
commit immediate performed 3 0.00 0.00
commit immediate requested 3 0.00 0.00
commit txn count during cleanout 778 0.01 0.00
concurrency wait time 6,604 0.08 0.00
consistent changes 148,377 1.72 0.01
consistent gets 148,162,527 1,714.30 9.07
consistent gets - examination 7,693,876 89.02 0.47
consistent gets direct 1,111 0.01 0.00
consistent gets from cache 148,161,416 1,714.29 9.07
current blocks converted for CR 5 0.00 0.00
cursor authentications 1,912 0.02 0.00
data blocks consistent reads - undo records applied 42,303 0.49 0.00
db block changes 145,964,253 1,688.87 8.94
db block gets 164,375,881 1,901.90 10.07
db block gets direct 2,445,058 28.29 0.15
db block gets from cache 161,930,823 1,873.61 9.92
deferred (CURRENT) block cleanout applications 11,910,208 137.81 0.73
dirty buffers inspected 4,073,276 47.13 0.25
enqueue conversions 908,288 10.51 0.06
enqueue releases 35,424,536 409.88 2.17
enqueue requests 35,424,549 409.88 2.17
enqueue timeouts 13 0.00 0.00
enqueue waits 1,062 0.01 0.00
execute count 16,735,654 193.64 1.03
free buffer inspected 50,439,397 583.60 3.09
free buffer requested 50,572,867 585.15 3.10
heap block compress 34,305 0.40 0.00
hot buffers moved to head of LRU 134,025 1.55 0.01
immediate (CR) block cleanout applications 391 0.00 0.00
immediate (CURRENT) block cleanout applications 7,763 0.09 0.00
index fast full scans (full) 96 0.00 0.00
index fetch by key 517,977 5.99 0.03
index scans kdiixs1 343,630 3.98 0.02
leaf node 90-10 splits 251 0.00 0.00
leaf node splits 363 0.00 0.00
lob reads 10,811 0.13 0.00
lob writes 27,939 0.32 0.00
lob writes unaligned 27,927 0.32 0.00
logons cumulative 7,248 0.08 0.00
messages received 16,944,684 196.06 1.04
messages sent 16,944,684 196.06 1.04
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 128,537,623 1,487.23 7.87
opened cursors cumulative 280,992 3.25 0.02
parse count (failures) 28 0.00 0.00
parse count (hard) 14,341 0.17 0.00
parse count (total) 276,992 3.20 0.02
parse time cpu 2,602 0.03 0.00
parse time elapsed 7,737 0.09 0.00
physical read IO requests 2,517,246 29.13 0.15
physical read bytes ############### 3,681,363.08 19,487.71
physical read total IO requests 3,181,448 36.81 0.19
physical read total bytes ############### 5,100,786.10 27,001.59
physical read total multi block requests 2,533,856 29.32 0.16
physical reads 38,839,140 449.39 2.38
physical reads cache 38,498,163 445.44 2.36
physical reads cache prefetch 35,994,324 416.47 2.20
physical reads direct 340,977 3.95 0.02
physical reads direct (lob) 1,093 0.01 0.00
physical reads direct temporary tablespace 338,489 3.92 0.02
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 3,917,453 45.33 0.24
physical write bytes ############### 1,426,607.93 7,551.91
physical write total IO requests 20,413,605 236.19 1.25
physical write total bytes ############### 3,970,245.50 21,016.94
physical write total multi block requests 17,139,087 198.31 1.05
physical writes 15,051,008 174.15 0.92
physical writes direct 2,784,924 32.22 0.17
physical writes direct (lob) 18 0.00 0.00
physical writes direct temporary tablespace 338,489 3.92 0.02
physical writes from cache 12,266,084 141.92 0.75
physical writes non checkpoint 14,811,035 171.37 0.91
pinned buffers inspected 1,710 0.02 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 145,858 1.69 0.01
queries parallelized 0 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive calls 20,161,201 233.27 1.23
recursive cpu usage 24,353 0.28 0.00
redo blocks read for recovery 0 0.00 0.00
redo blocks written 212,162,106 2,454.80 12.99
redo buffer allocation retries 98 0.00 0.00
redo entries 97,802,586 1,131.62 5.99
redo log space requests 99 0.00 0.00
redo log space wait time 353 0.00 0.00
redo ordering marks 690,849 7.99 0.04
redo size ############### 1,174,067.99 6,215.06
redo synch time 672,865 7.79 0.04
redo synch writes 16,351,218 189.19 1.00
redo wastage 3,721,411,184 43,058.29 227.93
redo write time 653,766 7.56 0.04
redo writer latching time 10 0.00 0.00
redo writes 16,350,622 189.18 1.00
rollback changes - undo records applied 6 0.00 0.00
rollbacks only - consistent read gets 30,419 0.35 0.00
rows fetched via callback 171,948 1.99 0.01
session connect time 0 0.00 0.00
session cursor cache hits 125,769 1.46 0.01
session logical reads 312,538,408 3,616.20 19.14
session pga memory 1,912,648,968 22,130.15 117.15
session pga memory max 1,960,293,640 22,681.42 120.07
session uga memory ############### 68,531,105.76 362,777.15
session uga memory max 4,601,911,368 53,246.04 281.86
shared hash latch upgrades - no wait 344,743 3.99 0.02
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 95,050 1.10 0.01
sorts (rows) 1,280,112 14.81 0.08
sql area purged 1,109 0.01 0.00
summed dirty queue length 13,611,295 157.49 0.83
switch current to new buffer 2,833 0.03 0.00
table fetch by rowid 561,294 6.49 0.03
table fetch continued row 804 0.01 0.00
table scan blocks gotten 125,362,781 1,450.50 7.68
table scan rows gotten 6,174,740,225 71,444.33 378.20
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 928 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 73,580 0.85 0.00
total number of times SMON posted 1,910 0.02 0.00
transaction rollbacks 698 0.01 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 4,115,355,388 47,616.39 252.06
user I/O wait time 169,710 1.96 0.01
user calls 33,796,241 391.04 2.07
user commits 16,326,001 188.90 1.00
user rollbacks 710 0.01 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 8 0.00 0.00
workarea executions - optimal 51,288 0.59 0.00
write clones created in background 2,889 0.03 0.00
write clones created in foreground 194 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 18,013,203 18,100,051
opened cursors current 65 48
logons current 29 23

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 51 2.12

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_CDR 2,480,814 29 0.62 15.46 3,813,527 44 30,506 2.92
UNDOTBS1 102 0 55.20 1.00 78,499 1 170 0.00
TEMP 10,919 0 8.33 31.00 10,919 0 0 0.00
SYSTEM 17,221 0 1.25 8.36 3,769 0 0 0.00
SYSAUX 6,933 0 2.21 1.09 10,323 0 0 0.00
TS_YYGH 1,062 0 5.27 1.31 212 0 0 0.00
TS_LOCAL 102 0 74.80 1.00 102 0 0 0.00
TS_TEMP 51 0 74.31 1.00 51 0 0 0.00
USERS 51 0 73.92 1.00 51 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)
SYSAUX /oracle/hjfxdata/oradata/hjfxdb/sysaux01.dbf 6,933 0 2.21 1.09 10,323 0 0 0.00
SYSTEM /oracle/hjfxdata/oradata/hjfxdb/system01.dbf 17,221 0 1.25 8.36 3,769 0 0 0.00
TEMP /oracle/hjfxdata/oradata/hjfxdb/temp01.dbf 10,919 0 8.33 31.00 10,919 0 0  
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR003.dbf 49,455 1 1.27 15.04 16,798 0 1,432 2.07
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR004.dbf 128,185 1 0.65 15.59 156,896 2 1,638 2.39
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR005.dbf 125,489 1 0.67 15.53 194,433 2 1,339 2.08
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR006.dbf 140,531 2 0.63 15.50 157,213 2 1,799 3.97
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR007.dbf 41,670 0 0.98 15.45 18,585 0 1,087 1.37
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR009.dbf 190,875 2 0.55 15.68 190,458 2 1,244 3.21
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR010.dbf 186,660 2 0.59 15.69 161,583 2 1,893 2.03
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR011.dbf 72,014 1 0.93 15.38 106,589 1 1,683 2.11
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR012.dbf 186,222 2 0.62 15.51 165,578 2 1,741 2.30
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR014.dbf 137,721 2 0.65 15.59 168,354 2 1,645 2.13
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR015.dbf 133,814 2 0.61 15.68 155,495 2 1,689 1.60
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_CDR016.dbf 213,300 2 0.58 15.65 148,347 2 1,970 1.45
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/TS_cdr008.dbf 225,474 3 0.56 15.65 205,378 2 2,111 3.15
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/ts_cdr01.dbf 238,267 3 0.64 14.73 214,793 2 4,634 4.96
TS_CDR /oracle/hjfxdata/oradata/hjfxdb/ts_cdr02.dbf 215,771 2 0.62 14.93 190,906 2 3,739 4.39
TS_CDR /oracle/hjfxdata02/oradata/hjfxdb/TS_CDR017.dbf 65,657 1 0.39 15.91 522,207 6 160 0.63
TS_CDR /oracle/hjfxdata02/oradata/hjfxdb/TS_CDR018.dbf 63,202 1 0.39 15.90 521,394 6 159 0.50
TS_CDR /oracle/hjfxdata02/oradata/hjfxdb/TS_CDR019.dbf 66,507 1 0.40 15.39 518,520 6 543 0.44
TS_LOCAL /oracle/hjfxdata/oradata/hjfxdb/TS_LOCAL005.dbf 51 0 74.71 1.00 51 0 0 0.00
TS_LOCAL /oracle/hjfxdata/oradata/hjfxdb/ts_local01.dbf 51 0 74.90 1.00 51 0 0 0.00
TS_TEMP /oracle/hjfxdata/oradata/hjfxdb/TS_TEMP.dbf 51 0 74.31 1.00 51 0 0 0.00
TS_YYGH /oracle/hjfxdata/oradata/hjfxdb/ts_yygh01.dbf 1,062 0 5.27 1.31 212 0 0 0.00
UNDOTBS1 /oracle/hjfxdata/oradata/hjfxdb/UNDOTBS2.dbf 51 0 37.84 1.00 35,464 0 0 0.00
UNDOTBS1 /oracle/hjfxdata/oradata/hjfxdb/undotbs01.dbf 51 0 72.55 1.00 43,035 0 170 0.00
USERS /oracle/hjfxdata/oradata/hjfxdb/users01.dbf 51 0 73.92 1.00 51 0 0 0.00

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 549,560 88 310,091,355 38,498,162 12,266,084 0 0 30,676


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 12 184 326 674 15099480 674  
E 0 12 181 255 567 15099480 567  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 432 0.10 53,568 1.01 10,584,338,369
D 864 0.19 107,136 1.01 10,569,841,340
D 1,296 0.29 160,704 1.01 10,554,553,000
D 1,728 0.39 214,272 1.01 10,538,291,546
D 2,160 0.49 267,840 1.01 10,522,072,470
D 2,592 0.58 321,408 1.00 10,506,910,661
D 3,024 0.68 374,976 1.00 10,492,943,445
D 3,456 0.78 428,544 1.00 10,480,218,285
D 3,888 0.88 482,112 1.00 10,468,636,021
D 4,320 0.97 535,680 1.00 10,457,983,897
D 4,432 1.00 549,568 1.00 10,455,417,341
D 4,752 1.07 589,248 1.00 10,448,084,042
D 5,184 1.17 642,816 1.00 10,438,780,844
D 5,616 1.27 696,384 1.00 10,429,951,776
D 6,048 1.36 749,952 1.00 10,421,427,530
D 6,480 1.46 803,520 1.00 10,412,969,080
D 6,912 1.56 857,088 1.00 10,404,370,848
D 7,344 1.66 910,656 0.99 10,395,457,071
D 7,776 1.75 964,224 0.99 10,386,034,904
D 8,208 1.85 1,017,792 0.99 10,375,863,621
D 8,640 1.95 1,071,360 0.99 10,364,822,292

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
54.95 9,368 7,680

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 1,628 1,392 200.95 0.00 0.00 0.00 0.00 166,700
E 1,628 1,395 192.83 0.00 0.00 0.00 0.00 166,700

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 49,453 49,453 0 0
64K 128K 194 194 0 0
128K 256K 6 6 0 0
256K 512K 4 4 0 0
512K 1024K 889 889 0 0
1M 2M 728 728 0 0
2M 4M 13 13 0 0
8M 16M 1 1 0 0
256M 512M 4 0 4 0
1G 2G 2 0 2 0
2G 4G 2 0 2 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
204 0.13 2,826,892.09 2,747,196.89 51.00 38
407 0.25 2,826,892.09 1,537,856.63 65.00 0
814 0.50 2,826,892.09 1,502,828.92 65.00 0
1,221 0.75 2,826,892.09 1,502,828.92 65.00 0
1,628 1.00 2,826,892.09 1,367,089.26 67.00 0
1,954 1.20 2,826,892.09 1,150,479.55 71.00 0
2,279 1.40 2,826,892.09 1,150,479.55 71.00 0
2,605 1.60 2,826,892.09 1,150,479.55 71.00 0
2,930 1.80 2,826,892.09 1,150,479.55 71.00 0
3,256 2.00 2,826,892.09 1,150,479.55 71.00 0
4,884 3.00 2,826,892.09 1,150,479.55 71.00 0
6,512 4.00 2,826,892.09 1,150,479.55 71.00 0
9,768 6.00 2,826,892.09 1,150,479.55 71.00 0
13,024 8.00 2,826,892.09 1,150,479.55 71.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
288 0.75 48 2,982 855,347 1.00 26,996 1.04 228,506,329
336 0.88 95 4,721 855,897 1.00 26,446 1.02 228,740,000
384 1.00 142 7,227 856,439 1.00 25,904 1.00 228,970,745
432 1.13 189 8,610 856,963 1.00 25,380 0.98 229,192,244
480 1.25 236 12,895 857,468 1.00 24,875 0.96 229,402,222
528 1.38 283 19,227 857,957 1.00 24,386 0.94 229,601,345
576 1.50 330 21,749 858,431 1.00 23,912 0.92 229,789,462
624 1.63 377 23,444 858,891 1.00 23,452 0.91 229,967,647
672 1.75 424 25,024 859,336 1.00 23,007 0.89 230,136,671
720 1.88 471 27,128 859,764 1.00 22,579 0.87 230,296,644
768 2.00 518 29,794 860,176 1.00 22,167 0.86 230,448,868

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,224 0.25 4,850,498 10,577,745,723
2,448 0.50 4,811,549 10,529,650,803
3,672 0.75 4,776,401 10,487,829,134
4,896 1.00 4,749,802 10,455,417,340
6,120 1.25 4,727,478 10,428,233,255
7,344 1.50 4,709,429 10,411,504,587
8,568 1.75 4,685,680 10,383,274,960
9,792 2.00 4,675,705 10,371,774,001

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 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
segment header 6,736 53 8
data block 23,769 36 2
undo header 170 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)
TX-Transaction (row lock contention) 4 4 0 4 32 7,969.75
RO-Multiple Object Reuse (fast object reuse) 9,405 9,405 0 1,044 4 3.69
CF-Controlfile Transaction 192,015 192,013 2 1 0 25.00
TX-Transaction 16,365,461 16,365,461 0 3 0 3.00
CI-Cross-Instance Call Invocation 37,471 37,471 0 10 0 0.40

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 530.05 16,366,693 1,430 4 15/37.8333333333333333333333333333333333333 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:08 65 188 0 3 15 0/0 0/0/0/0/0/0
04-May 23:58 4 47 0 1 15 0/0 0/0/0/0/0/0
04-May 23:48 5 59 0 1 15 0/0 0/0/0/0/0/0
04-May 23:38 2 47 0 1 15 0/0 0/0/0/0/0/0
04-May 23:28 6 84 0 1 15 0/0 0/0/0/0/0/0
04-May 23:18 4 50 0 1 15 0/0 0/0/0/0/0/0
04-May 23:08 40 152 0 3 15 0/0 0/0/0/0/0/0
04-May 22:58 4 44 0 1 15 0/0 0/0/0/0/0/0
04-May 22:48 1 61 0 1 15 0/0 0/0/0/0/0/0
04-May 22:38 4 63 0 1 15 0/0 0/0/0/0/0/0
04-May 22:28 2 33 0 1 15 0/0 0/0/0/0/0/0
04-May 22:18 3 126 0 1 15 0/0 0/0/0/0/0/0
04-May 22:08 55 94 0 3 15 0/0 0/0/0/0/0/0
04-May 21:58 7 61 0 3 15 0/0 0/0/0/0/0/0
04-May 21:48 3 44 0 1 15 0/0 0/0/0/0/0/0
04-May 21:38 4 73 0 1 15 0/0 0/0/0/0/0/0
04-May 21:28 5 44 0 1 15 0/0 0/0/0/0/0/0
04-May 21:18 4 173 0 1 15 0/0 0/0/0/0/0/0
04-May 21:08 52 92 0 2 15 0/0 0/0/0/0/0/0
04-May 20:58 2 76 0 1 15 0/0 0/0/0/0/0/0
04-May 20:48 5 44 0 1 15 0/0 0/0/0/0/0/0
04-May 20:38 9 287 0 3 15 0/0 0/0/0/0/0/0
04-May 20:28 3,618 727 0 3 15 0/0 0/0/0/0/0/0
04-May 20:18 3 98 0 1 15 0/0 0/0/0/0/0/0
04-May 20:08 559 6,060 0 4 15 0/0 0/0/0/0/0/0
04-May 19:58 4 44 0 1 15 0/0 0/0/0/0/0/0
04-May 19:48 3 55 0 1 15 0/0 0/0/0/0/0/0
04-May 19:38 7 53 0 3 15 0/0 0/0/0/0/0/0
04-May 19:28 2 58 0 1 15 0/0 0/0/0/0/0/0
04-May 19:18 4 47 0 1 15 0/0 0/0/0/0/0/0
04-May 19:08 51 159 0 2 15 0/0 0/0/0/0/0/0
04-May 18:58 7 44 0 1 15 0/0 0/0/0/0/0/0
04-May 18:48 3 61 0 1 15 0/0 0/0/0/0/0/0
04-May 18:38 3 51 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 333,865 0.00   0 0  
Consistent RBA 16,350,674 0.00 0.00 0 0  
FAL request queue 1,829 0.00   0 0  
FAL subheap alocation 1,829 0.00   0 0  
FIB s.o chain latch 824 0.00   0 0  
FOB s.o list latch 32,044 0.01 0.00 0 0  
In memory undo latch 82,739,969 0.00 0.00 0 16,347,994 0.00
JS mem alloc latch 367 0.00   0 0  
JS queue access latch 367 0.00   0 0  
JS queue state obj latch 624,364 0.00   0 0  
JS slv state obj latch 4,093 0.00   0 0  
KMG MMAN ready and startup request latch 28,809 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 15,605 0.00   0 27,855 0.00
KWQMN job cache list latch 21 0.00   0 0  
KWQP Prop Status 48 0.00   0 0  
MQL Tracking Latch 0     0 1,722 0.00
Memory Management Latch 21 0.00   0 28,809 0.00
OS process 25,617 0.00   0 0  
OS process allocation 45,881 0.00   0 0  
OS process: request allocation 11,744 0.01 0.00 0 0  
PL/SQL warning settings 19,105 0.00   0 0  
Reserved Space Latch 153 0.00   0 0  
SGA IO buffer pool latch 2,470,518 0.00 0.05 0 2,470,518 0.00
SQL memory manager latch 24 0.00   0 28,796 0.00
SQL memory manager workarea list latch 1,970,550 0.00   0 0  
Shared B-Tree 3,157 0.00   0 0  
active checkpoint queue latch 617,538 0.00   0 0  
active service list 211,894 0.00 0.00 0 29,432 0.00
archive control 2,272 0.00   0 0  
archive process latch 30,625 0.03 0.80 0 0  
begin backup scn array 78,824 0.00   0 0  
buffer pool 2 0.00   0 0  
cache buffer handles 16,021,116 0.00   0 0  
cache buffers chains 1,035,731,014 0.02 0.00 0 87,307,453 0.00
cache buffers lru chain 37,016,792 0.18 0.00 0 173,898,617 0.05
cache table scan latch 0     0 2,412,937 0.01
channel handle pool latch 15,770 0.01 0.00 0 0  
channel operations parent latch 551,165 0.00 0.00 0 0  
checkpoint queue latch 16,978,496 0.01 0.00 0 12,262,227 0.01
client/application info 84,678 0.00   0 0  
commit callback allocation 206 0.00   0 0  
compile environment latch 16,362,076 0.00   0 0  
dictionary lookup 1,286 0.00   0 0  
dml lock allocation 32,767,585 0.00 0.00 0 0  
dummy allocation 14,502 0.00   0 0  
enqueue hash chains 71,760,686 0.00 0.00 0 8,538 0.05
enqueues 21,699,464 0.02 0.00 0 0  
event group latch 5,869 0.00   0 0  
file cache latch 42,946 0.00   0 0  
global KZLD latch for mem in SGA 4,345 0.00   0 0  
global tx hash mapping 885,750 0.00   0 0  
hash table column usage latch 2,475 0.00   0 205,452 0.00
hash table modification latch 1,968 0.00   0 0  
internal temp table object number allocation latc 2 0.00   0 0  
job workq parent latch 0     0 2,758 0.00
job_queue_processes parameter latch 2,818 0.00   0 0  
kks stats 50,365 0.00   0 0  
kmcptab latch 6 0.00   0 0  
kmcpvec latch 0     0 6 0.00
krbmrosl 921 0.00   0 0  
ksuosstats global area 5,810 0.00   0 0  
ktm global data 3,768 0.00   0 0  
kwqbsn:qsga 3,133 0.00   0 0  
lgwr LWN SCN 16,566,118 0.72 0.00 0 0  
library cache 52,160,333 0.01 0.09 1 45,970 1.08
library cache load lock 7,752 0.00   0 0  
library cache lock 1,199,264 0.00 0.00 0 0  
library cache lock allocation 65,879 0.00   0 0  
library cache pin 34,510,009 0.00 0.00 0 0  
library cache pin allocation 24,574 0.00   0 0  
list of block allocation 9,430 0.00   0 0  
loader state object freelist 3,774 0.00   0 0  
logminer context allocation 24 0.00   0 0  
longop free list parent 754 0.00   0 89 0.00
message pool operations parent latch 5,333 0.00   0 0  
messages 50,921,423 0.00 0.00 0 0  
mostly latch-free SCN 16,369,203 0.00 0.00 0 0  
multiblock read objects 4,913,782 0.00 0.04 0 0  
ncodef allocation latch 1,401 0.00   0 0  
object queue header heap 11,196 0.00   0 10,935 0.00
object queue header operation 137,910,265 0.01 0.00 0 0  
object stats modification 2,110 0.00   0 0  
parallel query alloc buffer 10,552 0.00   0 0  
parameter list 23 0.00   0 0  
parameter table allocation management 7,466 0.00   0 0  
post/wait queue 24,490,837 0.00   0 16,321,517 0.00
process allocation 11,744 0.01 0.00 0 5,868 0.02
process group creation 11,744 0.00   0 0  
qmn task queue latch 18,550 0.03 0.67 0 0  
redo allocation 81,743,103 0.00 0.00 0 97,800,873 0.00
redo copy 0     0 97,802,647 0.00
redo writing 49,724,783 0.00 0.07 0 0  
reservation so alloc latch 102 0.00   0 0  
resmgr group change latch 18,144 0.00   0 0  
resmgr:actses active list 14,424 0.00   0 0  
resmgr:actses change group 5,916 0.00   0 0  
resmgr:free threads list 14,400 0.00   0 0  
resmgr:schema config 24 0.00   0 0  
row cache objects 3,413,098 0.19 0.00 0 359 0.00
rules engine rule set statistics 2,400 0.00   0 0  
sequence cache 16,473 0.00   0 0  
session allocation 34,494,279 0.00 0.00 0 0  
session idle bit 84,017,006 0.00 0.00 0 0  
session state list latch 21,538 0.00   0 0  
session switching 1,401 0.00   0 0  
session timer 29,432 0.00   0 0  
shared pool 22,488,919 0.01 0.35 1 0  
simulator hash latch 63,498,236 0.00 0.02 0 0  
simulator lru latch 40,795,679 0.06 0.00 0 5,943,547 0.00
slave class 51 0.00   0 0  
slave class create 204 11.76 1.00 1 0  
sort extent pool 6,805 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 18 0.00   0 0  
threshold alerts latch 4,535 0.00   0 0  
transaction allocation 20,682 0.00   0 0  
transaction branch allocation 887,085 0.00   0 0  
undo global data 87,891,854 0.00 0.00 0 0  
user lock 20,160 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 1,035,731,014 168,564 243 168,337 0 0 0
lgwr LWN SCN 16,566,118 118,712 62 118,650 0 0 0
cache buffers lru chain 37,016,792 67,759 172 67,587 0 0 0
simulator lru latch 40,795,679 22,521 71 22,451 0 0 0
object queue header operation 137,910,265 9,527 13 9,514 0 0 0
row cache objects 3,413,098 6,486 2 6,484 0 0 0
library cache 52,160,333 3,787 346 3,447 0 0 0
enqueues 21,699,464 3,462 2 3,460 0 0 0
enqueue hash chains 71,760,686 2,893 13 2,880 0 0 0
messages 50,921,423 2,224 9 2,215 0 0 0
shared pool 22,488,919 1,431 507 925 0 0 0
redo writing 49,724,783 1,252 93 1,159 0 0 0
checkpoint queue latch 16,978,496 1,052 5 1,047 0 0 0
redo allocation 81,743,103 1,001 4 997 0 0 0
mostly latch-free SCN 16,369,203 665 1 664 0 0 0
simulator hash latch 63,498,236 176 3 173 0 0 0
SGA IO buffer pool latch 2,470,518 42 2 40 0 0 0
slave class create 204 24 24 0 0 0 0
multiblock read objects 4,913,782 23 1 22 0 0 0
archive process latch 30,625 10 8 2 0 0 0
qmn task queue latch 18,550 6 4 2 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 1 2
archive process latch kcrrsarc 0 8 0
cache buffers chains kcbgtcr: kslbegin excl 0 1,773 1,782
cache buffers chains kcbrls: kslbegin 0 168 152
cache buffers chains kcbzwb 0 7 18
cache buffers chains kcbzib: finish free bufs 0 4 3
cache buffers chains kcbzib: multi-block read: nowait 0 4 0
cache buffers chains kcbbic2 0 2 1
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers chains kcbnew: new latch again 0 2 0
cache buffers chains kcbbxsv 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers lru chain kcbzgws 0 169 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 2 0
cache buffers lru chain kcbzgm 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 5 0
enqueue hash chains ksqrcl 0 6 5
enqueue hash chains ksqgtl3 0 5 8
enqueue hash chains ksqcnl 0 2 0
enqueues ksqgel: create enqueue 0 1 1
enqueues ksqies 0 1 1
event range base latch No latch 0 4 4
lgwr LWN SCN kcs023 0 1 0
library cache kglpndl: child: before processing 0 24 102
library cache kglic 0 6 1
library cache kglpnc: child 0 4 110
library cache kglpin: child: heap processing 0 3 35
library cache kglhdgc: child: 0 2 0
library cache kglivl: child 0 2 0
library cache kglobpn: child: 0 2 6
library cache kglpndl: child: after processing 0 2 1
library cache kgldte: child 0 0 1 59
library cache lock kgllkdl: child: no lock handle 0 5 0
messages ksaamb: after wakeup 0 3 3
messages ksarcv 0 3 0
messages ksarcv: after wait 0 3 6
mostly latch-free SCN kcs024 0 62 0
multiblock read objects kcbzib: mbr get 0 1 1
object queue header operation kcbo_switch_cq 0 10 3
object queue header operation kcbo_switch_q_bg 0 2 6
object queue header operation kcbw_link_q 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 4 0
redo writing kcrfsr: rba scn pair 0 78 1
redo writing kcrfw_post: rba scn pair 0 7 1
redo writing kcrfw_post: after write 0 5 56
redo writing kcrfw_cal_target_rba 0 1 23
redo writing kcrfwcr 0 1 12
redo writing kctmttrca 0 1 0
row cache objects kqreqd: reget 0 2 0
session idle bit ksupuc: set busy 0 1 0
shared pool kghfrunp: alloc: cursor dur 0 448 0
shared pool kghfrunp: clatch: nowait 0 284 0
shared pool kghalo 0 29 24
shared pool kghalp 0 18 0
shared pool kghfrunp: clatch: wait 0 11 20
shared pool kghupr1 0 8 474
shared pool kghfre 0 2 8
shared pool kghfrunp: alloc: session dur 0 2 0
simulator hash latch kcbsacc: insert dba 0 2 0
simulator hash latch kcbs_get_or_extract_simbufseq 0 1 0
simulator lru latch kcbs_simulate: simulate set 0 69 45
simulator lru latch kcbs_simbufseq 0 2 26
slave class create ksvcreate 0 24 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
HJFX TS_CDR TI_INTERFACE_PERIOD_STATUS   TABLE 86,878,352 27.80
HJFX TS_CDR TI_CRM_USER   TABLE 37,355,472 11.95
HJFX TS_CDR TI_CRM_USER_SVCSTATE   TABLE 35,691,312 11.42
HJFX TS_CDR TI_CRM_USER_INFOCHANGE   TABLE 13,947,648 4.46
HJFX TS_CDR TI_CRM_USER_SVC   TABLE 9,623,872 3.08

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HJFX TS_CDR TI_CRM_USER_SVC   TABLE 9,600,908 24.72
HJFX TS_CDR TI_BIL_GSM_CALL_20140503   TABLE 5,409,185 13.93
HJFX TS_CDR TI_CRM_USER_ITEM   TABLE 4,719,487 12.15
HJFX TS_CDR TI_CRM_TRADE   TABLE 2,812,364 7.24
HJFX TS_CDR TI_INTERFACE_PERIOD_STATUS   TABLE 2,467,195 6.35

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HJFX TS_CDR TI_INTERFACE_PERIOD_STATUS   TABLE 8 100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HJFX TS_CDR TI_INTERFACE_PERIOD_STATUS   TABLE 1 100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 1,568 0.00 0   50 1
dc_database_links 278 0.00 0   0 4
dc_files 2,700 0.00 0   0 27
dc_global_oids 92,654 0.00 0   0 115
dc_histogram_data 44,545 1.43 0   220 11,976
dc_histogram_defs 60,661 5.60 0   282 15,378
dc_object_grants 1,932 0.93 0   0 278
dc_object_ids 172,429 0.71 0   94 2,377
dc_objects 63,619 0.76 0   1,534 2,469
dc_profiles 5,774 0.00 0   0 1
dc_rollback_segments 16,266 0.00 0   0 22
dc_segments 63,204 1.22 0   29,424 2,184
dc_sequences 300 0.00 0   300 8
dc_tablespace_quotas 16,287 0.00 0   46 2
dc_tablespaces 166,719 0.00 0   0 11
dc_usernames 13,699 0.00 0   0 21
dc_users 496,338 0.00 0   0 75
outstanding_alerts 1,440 0.00 0   0 9


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 20,595 0.02 38,987 0.12 43 0
CLUSTER 85 1.18 398 1.26 4 0
INDEX 188 10.11 659 6.37 23 0
SQL AREA 9,527 80.15 16,939,131 0.14 6,987 3,159
TABLE/PROCEDURE 17,526 1.49 247,516 2.87 2,884 0
TRIGGER 7,094 0.00 10,928 0.14 15 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 169.66   5.47 14.30 74 80 31 31
  Freeable 30.06 0.00 1.88 2.40 10   16 16
  SQL 0.70 0.38 0.03 0.03 0 147 22 20
  PL/SQL 0.60 0.32 0.02 0.02 0 0 29 29
E Other 163.87   6.55 15.79 74 80 25 25
  Freeable 28.06 0.00 2.00 2.55 10   14 14
  SQL 0.56 0.30 0.03 0.04 0 8 16 14
  PL/SQL 0.36 0.16 0.02 0.02 0 0 23 23

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 4,664,066,048 4,647,288,832
Fixed Size 2,027,968  
Redo Buffers 14,745,600  
Variable Size 452,988,480 469,765,696

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.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 8.00 8.00 0.00
shared CCursor 36.49 20.61 -43.53
shared CURSOR STATS   3.53  
shared Heap0: KGL 3.74   -100.00
shared KCB Table Scan Buffer 4.00 4.00 0.00
shared KGH: NO ACCESS 31.66   -100.00
shared KGLS heap 7.28 5.49 -24.61
shared KQR M PO 9.44 9.91 4.92
shared KQR M SO 6.03 5.28 -12.33
shared KSFD SGA I/O b 4.00 4.00 0.00
shared PCursor 29.54 15.27 -48.30
shared XDB Schema Cac 7.18 8.59 19.62
shared db_block_hash_buckets 33.63 33.63 0.00
shared free memory 10.40 45.52 337.76
shared kglsim hash table bkts 4.00 4.00 0.00
shared kglsim heap 7.03 7.03 0.00
shared kglsim object batch 20.26 20.26 0.00
shared krbmror 4.44 4.44 0.00
shared library cache 44.71 42.97 -3.89
shared row cache 7.13 7.13 0.00
shared sql area 37.28 51.25 37.47
streams free memory 32.00 32.00 0.00
  buffer_cache 4,448.00 4,432.00 -0.36
  fixed_sga 1.93 1.93 0.00
  log_buffer 14.06 14.06 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 234,996 0 0
QMON Slaves 162,276 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

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

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/hjfxdata/admin/hjfxdb/adump   
background_dump_dest /oracle/hjfxdata/admin/hjfxdb/bdump   
compatible 10.2.0.1.0   
control_files /oracle/hjfxdata/oradata/hjfxdb/control01.ctl, /oracle/hjfxdata/oradata/hjfxdb/control02.ctl, /oracle/hjfxdata/oradata/hjfxdb/control03.ctl   
core_dump_dest /oracle/hjfxdata/admin/hjfxdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name hjfxdb   
db_recovery_file_dest /oracle/hjfxdata/flash_recovery_area   
db_recovery_file_dest_size 214748364800   
dispatchers (PROTOCOL=TCP) (SERVICE=hjfxdbXDB)   
job_queue_processes 10   
log_archive_start TRUE   
open_cursors 300   
pga_aggregate_target 1707081728   
processes 150   
remote_login_passwordfile EXCLUSIVE   
sga_target 5133828096   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/hjfxdata/admin/hjfxdb/udump   


Back to Top

End of Report