WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
CC1955445242cc110.2.0.4.0NOocsdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1822827-Mar-13 03:04:0283 37.5
End Snap:1824427-Mar-13 19:00:59352 51.2
Elapsed:  956.94 (mins)  
DB Time:  3,523.56 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 8,720M 8,992MStd Block Size: 8K
Shared Pool Size: 1,472M 1,184MLog Buffer: 14,328K

Load Profile

Per SecondPer Transaction
Redo size: 441,420.30 10,875.41
Logical reads: 150,498.57 3,707.88
Block changes: 1,517.16 37.38
Physical reads: 1,196.80 29.49
Physical writes: 269.24 6.63
User calls: 2,175.80 53.61
Parses: 156.28 3.85
Hard parses: 32.11 0.79
Sorts: 158.24 3.90
Logons: 0.14 0.00
Executes: 1,139.53 28.07
Transactions: 40.59 

% Blocks changed per Read: 1.01Recursive Call %: 24.91
Rollback per transaction %: 22.65Rows per Sort: 124.96

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.81In-memory Sort %: 100.00
Library Hit %: 93.93Soft Parse %: 79.46
Execute to Parse %: 86.29Latch Hit %: 99.41
Parse CPU to Parse Elapsd %: 13.45% Non-Parse CPU: 99.36

Shared Pool Statistics

BeginEnd
Memory Usage %: 86.90 43.31
% SQL with executions>1: 2.68 35.35
% Memory for SQL w/exec>1: 3.95 41.14

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 9,693,656 112,749 12 53.3User I/O
CPU time  72,698  34.4 
RMAN backup & recovery I/O 567,572 8,787 15 4.2System I/O
log file sync 2,559,552 7,087 3 3.4Commit
direct path read 2,961,849 6,634 2 3.1User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 195,772.63 92.60
DB CPU 72,698.46 34.39
parse time elapsed 3,746.67 1.77
hard parse elapsed time 3,232.84 1.53
RMAN cpu time (backup/restore) 429.91 0.20
PL/SQL execution elapsed time 97.26 0.05
repeated bind elapsed time 89.89 0.04
sequence load elapsed time 85.16 0.04
PL/SQL compilation elapsed time 25.68 0.01
connection management call elapsed time 18.11 0.01
hard parse (sharing criteria) elapsed time 9.78 0.00
failed parse elapsed time 3.75 0.00
hard parse (bind mismatch) elapsed time 2.11 0.00
inbound PL/SQL rpc elapsed time 0.01 0.00
DB time 211,413.56  
background elapsed time 13,554.80  
background cpu time 1,144.64  

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 15,009,325 0.00 129,518 9 6.44
System I/O 4,664,193 0.00 11,787 3 2.00
Commit 2,559,552 0.03 7,087 3 1.10
Other 32,430,565 91.51 4,495 0 13.92
Network 178,044,849 0.00 1,566 0 76.40
Concurrency 618,971 7.05 1,387 2 0.27
Configuration 7,578 50.03 717 95 0.00
Application 67,131 0.00 59 1 0.03
Administrative 117 0.00 5 44 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 9,693,656 0.00 112,749 12 4.16
RMAN backup & recovery I/O 567,572 0.00 8,787 15 0.24
log file sync 2,559,552 0.03 7,087 3 1.10
direct path read 2,961,849 0.00 6,634 2 1.27
PX Deq Credit: send blkd 2,651,873 0.00 4,173 2 1.14
read by other session 107,553 0.06 3,850 36 0.05
direct path read temp 1,399,098 0.00 3,267 2 0.60
db file scattered read 653,325 0.00 2,775 4 0.28
log file parallel write 2,567,406 0.00 1,739 1 1.10
SQL*Net more data to client 57,154,326 0.00 1,423 0 24.52
enq: TX - index contention 18,407 0.00 835 45 0.01
db file parallel write 1,200,627 0.00 491 0 0.52
cursor: pin S wait on X 44,111 98.85 429 10 0.02
control file sequential read 237,309 0.00 412 2 0.10
log file switch completion 1,932 9.37 407 211 0.00
Streams AQ: enqueue blocked on low memory 1 100.00 293 292969 0.00
SGA: allocation forcing component growth 19,605 98.14 193 10 0.01
log file sequential read 27,813 0.00 171 6 0.01
Data file init write 65,222 0.00 118 2 0.03
direct path write temp 117,460 0.00 118 1 0.05
Log archive I/O 27,307 0.00 117 4 0.01
SQL*Net message to client 120,734,025 0.00 100 0 51.81
PX qref latch 29,675,860 99.93 63 0 12.73
control file parallel write 34,891 0.00 48 1 0.01
latch: shared pool 28,823 0.00 43 1 0.01
SQL*Net more data from client 156,498 0.00 42 0 0.07
latch: library cache 5,987 0.00 38 6 0.00
enq: TX - row lock contention 44,128 0.00 29 1 0.02
control file single write 280 0.00 22 78 0.00
buffer busy waits 57,485 0.01 18 0 0.02
enq: TC - contention 6 83.33 16 2598 0.00
enq: KO - fast object checkpoint 20,069 0.00 13 1 0.01
rdbms ipc reply 3,950 0.00 13 3 0.00
enq: TM - contention 52 0.00 9 181 0.00
os thread startup 282 0.00 9 32 0.00
enq: SQ - contention 1,244 0.08 9 7 0.00
latch free 2,949 0.00 8 3 0.00
PX Deq: Table Q Get Keys 1,083 0.00 8 7 0.00
reliable message 16,760 0.00 8 0 0.01
enq: RO - fast object reuse 340 0.00 7 21 0.00
log file switch (private strand flush incomplete) 59 0.00 7 117 0.00
library cache load lock 380 0.00 7 18 0.00
kksfbc child completion 165 75.76 6 37 0.00
switch logfile command 117 0.00 5 44 0.00
latch: cache buffers chains 67,119 0.00 4 0 0.03
db file parallel read 337 0.00 4 12 0.00
local write wait 2,037 0.00 3 1 0.00
enq: CF - contention 101 0.00 2 23 0.00
cursor: mutex X 380,111 0.00 2 0 0.16
PX Deq: Table Q qref 1,227 0.00 1 1 0.00
PX Deq: Signal ACK 5,694 15.23 1 0 0.00
latch: In memory undo latch 15,615 0.00 1 0 0.01
log buffer space 705 0.00 1 1 0.00
SQL*Net break/reset to client 2,541 0.00 1 0 0.00
LGWR wait for redo copy 19,582 0.00 1 0 0.01
row cache lock 371 0.00 1 2 0.00
cursor: pin S 29,109 0.00 0 0 0.01
library cache lock 11 0.00 0 42 0.00
kupp process wait 3 100.00 0 98 0.00
latch: session allocation 573 0.00 0 0 0.00
log file single write 988 0.00 0 0 0.00
latch: undo global data 62 0.00 0 3 0.00
buffer exterminate 4 0.00 0 52 0.00
direct path write 8,747 0.00 0 0 0.00
db file single write 41 0.00 0 2 0.00
enq: UL - contention 1 0.00 0 73 0.00
latch: object queue header operation 226 0.00 0 0 0.00
latch: cache buffers lru chain 299 0.00 0 0 0.00
latch: row cache objects 188 0.00 0 0 0.00
enq: TX - allocate ITL entry 9 0.00 0 3 0.00
enq: PS - contention 337 0.00 0 0 0.00
latch: enqueue hash chains 119 0.00 0 0 0.00
latch: parallel query alloc buffer 40 0.00 0 0 0.00
undo segment extension 3,619 99.70 0 0 0.00
log file switch (checkpoint incomplete) 4 0.00 0 3 0.00
enq: TX - contention 5 0.00 0 2 0.00
buffer deadlock 848 98.47 0 0 0.00
latch: redo allocation 60 0.00 0 0 0.00
latch: library cache lock 26 0.00 0 0 0.00
latch: library cache pin 14 0.00 0 0 0.00
Streams AQ: qmn coordinator waiting for slave to start 1 0.00 0 4 0.00
enq: HW - contention 2 0.00 0 2 0.00
latch: checkpoint queue latch 11 0.00 0 0 0.00
enq: US - contention 3 0.00 0 0 0.00
enq: FB - contention 6 0.00 0 0 0.00
latch: redo writing 3 0.00 0 0 0.00
latch: messages 4 0.00 0 0 0.00
cursor: mutex S 41 0.00 0 0 0.00
SQL*Net message from client 120,733,762 0.00 12,063,544 100 51.81
Streams AQ: qmn slave idle wait 2,400 0.04 56,084 23368 0.00
Streams AQ: qmn coordinator idle wait 4,777 50.01 55,918 11706 0.00
virtual circuit status 1,914 100.00 55,866 29188 0.00
PX Deq: Execution Msg 94,095 15.35 32,731 348 0.04
Streams AQ: waiting for time management or cleanup tasks 15 93.33 18,782 1252125 0.00
PX Deq: Table Q Normal 17,304,488 0.01 17,579 1 7.43
PX Idle Wait 13,139 61.21 16,825 1281 0.01
jobq slave wait 4,513 99.03 13,162 2916 0.00
PX Deq: Execute Reply 56,469 1.32 2,379 42 0.02
PX Deq: Table Q Sample 6,351 2.98 416 65 0.00
PX Deq Credit: need buffer 730,739 0.00 378 1 0.31
PX Deq: Parse Reply 3,306 0.00 4 1 0.00
PX Deq: Msg Fragment 5,247 0.00 2 0 0.00
wait for unread message on broadcast channel 6 0.00 1 203 0.00
PL/SQL lock timer 11 100.00 1 98 0.00
PX Deq: Join ACK 2,864 0.00 1 0 0.00
SGA: MMAN sleep for component shrink 72 43.06 0 5 0.00
class slave wait 32 0.00 0 0 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 2,567,438 0.00 1,739 1 1.10
db file parallel write 1,200,627 0.00 491 0 0.52
control file sequential read 69,486 0.00 317 5 0.03
Streams AQ: enqueue blocked on low memory 1 100.00 293 292969 0.00
log file sequential read 26,908 0.00 163 6 0.01
Log archive I/O 26,470 0.00 115 4 0.01
control file parallel write 31,433 0.00 47 1 0.01
db file sequential read 1,535 0.00 23 15 0.00
events in waitclass Other 23,752 2.92 13 1 0.01
direct path read 8,594 0.00 10 1 0.00
os thread startup 248 0.00 8 33 0.00
db file scattered read 1,287 0.00 5 4 0.00
log file switch completion 7 42.86 4 546 0.00
latch: shared pool 287 0.00 1 3 0.00
latch: library cache 18 0.00 1 49 0.00
log file single write 988 0.00 0 0 0.00
log buffer space 702 0.00 0 0 0.00
direct path write 8,595 0.00 0 0 0.00
cursor: pin S wait on X 1 100.00 0 10 0.00
buffer busy waits 80 0.00 0 0 0.00
latch: redo writing 3 0.00 0 0 0.00
latch: row cache objects 2 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
latch: cache buffers chains 2 0.00 0 0 0.00
enq: HW - contention 1 0.00 0 0 0.00
rdbms ipc message 3,041,362 5.93 599,780 197 1.31
pmon timer 19,143 99.96 56,043 2928 0.01
Streams AQ: qmn slave idle wait 2,385 0.00 55,918 23446 0.00
Streams AQ: qmn coordinator idle wait 4,777 50.01 55,918 11706 0.00
smon timer 2,043 2.69 54,787 26817 0.00
Streams AQ: waiting for time management or cleanup tasks 15 93.33 18,782 1252125 0.00
SGA: MMAN sleep for component shrink 72 43.06 0 5 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 1,141,289
AVG_IDLE_TIME 4,599,834
AVG_IOWAIT_TIME 948,867
AVG_SYS_TIME 268,604
AVG_USER_TIME 871,044
BUSY_TIME 9,144,071
IDLE_TIME 36,812,046
IOWAIT_TIME 7,604,235
SYS_TIME 2,162,304
USER_TIME 6,981,767
LOAD 0
OS_CPU_WAIT_TIME 9,336,100
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,151,778,816
NUM_CPUS 8
NUM_CPU_CORES 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 184,786.30 53,228.20 63,312,090 4,738,810,640
cc 26,556.00 19,454.20 5,364,452 3,899,884,222
SYS$BACKGROUND 0.00 0.00 37,511 1,019,894
ccXDB 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 13747111 12479174 562808 137034 0 0 177552598 153668
cc 1223342 457915 55356 632 0 0 484742 2877
SYS$BACKGROUND 38783 14297 717 1001 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
18,579 325 201,154 0.09 8.79 2q7xx2jpyq4nj JDBC Thin Client SELECT DISTINCT A.PRICE_PLAN_I...
17,645 1,702 724,788 0.02 8.35 c1cgc2w6pat1r JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
17,492 15,584 66,061 0.26 8.27 5gxk7c8nk1d08 JDBC Thin Client SELECT DATA_.* FROM (SELECT ...
11,855 68 11,201 1.06 5.61 gmgstyn706km7 JDBC Thin Client SELECT COUNT(1) VALUE FROM acc...
6,677 389 701,433 0.01 3.16 5p1x50sgu9x6u JDBC Thin Client SELECT A.SUBS_UPP_INST_ID, A....
6,494 1,450 1,836,845 0.00 3.07 5qyt8mfx73k94 JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
6,157 4,089 11,003 0.56 2.91 8hapcfq7jgc5r CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...
5,327 749 274,903 0.02 2.52 5rv49239kcwcc JDBC Thin Client insert into cust_contact(cust_...
4,651 765 272,499 0.02 2.20 9054c5n52fjp5 JDBC Thin Client INSERT INTO ADVICE_HIS B (...
4,192 3,837 8,164 0.51 1.98 73vvk3pn1pka9 CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
3,281 549 198,731 0.02 1.55 cmjwh5agfc246 JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
3,170 712 763,539 0.00 1.50 gw9sd12xq1qyh JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
3,154 2,856 7,716 0.41 1.49 64vruxp06m37k CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
2,872 447 809,915 0.00 1.36 210awqcc8rpxc JDBC Thin Client SELECT T.BILL_ID, T.BILL_NBR, ...
2,825 602 189,506 0.01 1.34 4p9fy188gb0rr JDBC Thin Client SELECT A.RES_ID FROM USED_RES ...
2,461 2,201 11,953 0.21 1.16 4sv506pk03h8p CustCache@ocs2 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...

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
15,584 17,492 66,061 0.24 8.27 5gxk7c8nk1d08 JDBC Thin Client SELECT DATA_.* FROM (SELECT ...
4,089 6,157 11,003 0.37 2.91 8hapcfq7jgc5r CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...
3,837 4,192 8,164 0.47 1.98 73vvk3pn1pka9 CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
2,856 3,154 7,716 0.37 1.49 64vruxp06m37k CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
2,201 2,461 11,953 0.18 1.16 4sv506pk03h8p CustCache@ocs2 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...
1,702 17,645 724,788 0.00 8.35 c1cgc2w6pat1r JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
1,639 1,891 8,961 0.18 0.89 7rh0unadm78kh CustCache@ocs2 (TNS V1-V3) SELECT /*+ ORDERED*/ A....
1,450 6,494 1,836,845 0.00 3.07 5qyt8mfx73k94 JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
1,183 1,330 48,365 0.02 0.63 3dapbubjf2rkt pretreat@ocsdb2 (TNS V1-V3) SELECT FILE_ID, FILE_NAME, F...
1,129 1,373 18,082 0.06 0.65 b5sjhr002nvd3 CustCache@ocs1 (TNS V1-V3) SELECT MIN(CHANGE_NOTIF_ID) MI...
765 4,651 272,499 0.00 2.20 9054c5n52fjp5 JDBC Thin Client INSERT INTO ADVICE_HIS B (...
749 5,327 274,903 0.00 2.52 5rv49239kcwcc JDBC Thin Client insert into cust_contact(cust_...
712 3,170 763,539 0.00 1.50 gw9sd12xq1qyh JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
602 2,825 189,506 0.00 1.34 4p9fy188gb0rr JDBC Thin Client SELECT A.RES_ID FROM USED_RES ...
549 3,281 198,731 0.00 1.55 cmjwh5agfc246 JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
447 2,872 809,915 0.00 1.36 210awqcc8rpxc JDBC Thin Client SELECT T.BILL_ID, T.BILL_NBR, ...
389 6,677 701,433 0.00 3.16 5p1x50sgu9x6u JDBC Thin Client SELECT A.SUBS_UPP_INST_ID, A....
325 18,579 201,154 0.00 8.79 2q7xx2jpyq4nj JDBC Thin Client SELECT DISTINCT A.PRICE_PLAN_I...
68 11,855 11,201 0.01 5.61 gmgstyn706km7 JDBC Thin Client SELECT COUNT(1) VALUE FROM acc...

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
3,066,963,683 66,061 46,426.24 35.49 15584.12 17492.33 5gxk7c8nk1d08 JDBC Thin Client SELECT DATA_.* FROM (SELECT ...
843,617,289 11,003 76,671.57 9.76 4088.90 6156.51 8hapcfq7jgc5r CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...
778,849,075 8,164 95,400.43 9.01 3836.62 4192.10 73vvk3pn1pka9 CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
589,605,977 7,716 76,413.42 6.82 2855.93 3153.98 64vruxp06m37k CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED */ A...
454,778,676 11,953 38,047.24 5.26 2201.26 2461.47 4sv506pk03h8p CustCache@ocs2 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_UP...
342,249,463 8,961 38,193.22 3.96 1639.30 1890.77 7rh0unadm78kh CustCache@ocs2 (TNS V1-V3) SELECT /*+ ORDERED*/ A....
243,106,649 18,082 13,444.68 2.81 1128.90 1372.80 b5sjhr002nvd3 CustCache@ocs1 (TNS V1-V3) SELECT MIN(CHANGE_NOTIF_ID) MI...
212,986,601 5,570 38,238.17 2.46 1029.71 1158.97 4dafta9sdk89k mservcache@ocsdb2 (TNS V1-V3) SELECT /*+ RULE*/ A.SUBS_ID SU...
183,171,359 9,592 19,096.26 2.12 845.64 1024.22 5pv1pdy7khs73 mservcache@ocsdb2 (TNS V1-V3) SELECT MIN(CHANGE_NOTIF_ID) MI...
170,615,800 37 4,611,237.84 1.97 739.80 1553.40 97ysbnpd43da6 JDBC Thin Client SELECT COUNT(*) CNT ...
167,738,231 39 4,300,980.28 1.94 575.85 614.26 86k6c8nwkyjxk JDBC Thin Client SELECT * FROM (SELECT * ...
150,446,579 7,868 19,121.32 1.74 676.68 798.32 76v4wrvvjs14m CustCache@ocs1 (TNS V1-V3) SELECT /*+ ORDERED*/ A.SUBS_ID...
139,070,165 7,279 19,105.67 1.61 647.97 801.31 7c9n4drcbykvn CustCache@ocs2 (TNS V1-V3) SELECT MIN(CHANGE_NOTIF_ID) MI...

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
13,679,985 0   19.91 48.98 121.77 dj3sxn9x3vqty SQL*Plus BEGIN DBMS_STATS.GATHER_SCHEMA...
1,187,222 201,154 5.90 1.73 324.82 18579.01 2q7xx2jpyq4nj JDBC Thin Client SELECT DISTINCT A.PRICE_PLAN_I...
1,015,892 1 1,015,892.00 1.48 107.38 1177.40 g6602vqpc615j SQL*Plus select min(minbkt), maxbkt, su...
1,010,648 724,788 1.39 1.47 1702.38 17645.40 c1cgc2w6pat1r JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
993,731 11,201 88.72 1.45 67.69 11854.62 gmgstyn706km7 JDBC Thin Client SELECT COUNT(1) VALUE FROM acc...
784,567 1 784,567.00 1.14 85.20 803.15 cmxtgu0a7bkdg SQL*Plus select /*+ parallel(t, 16) par...
719,396 701,433 1.03 1.05 388.89 6677.22 5p1x50sgu9x6u JDBC Thin Client SELECT A.SUBS_UPP_INST_ID, A....
526,760 1 526,760.00 0.77 48.83 201.34 2pm0hyugpp3hx SQL*Plus select min(minbkt), maxbkt, su...
524,929 1 524,929.00 0.76 49.19 187.17 13f42myq0tsvb SQL*Plus select min(minbkt), maxbkt, su...
490,551 1 490,551.00 0.71 172.35 671.09 du2qvwh2ddry6 SQL*Plus select min(minbkt), maxbkt, su...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
2,737,142 1,235 0.00 0.00 0.00 9ndkt7x0zghtd JDBC Thin Client SELECT A.VALUE, C.BLACKLIST_TY...
1,836,845 2,122,881 1.16 0.00 0.00 5qyt8mfx73k94 JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
1,760,697 1,760,631 1.00 0.00 0.00 2drzzmj77h1g8 JDBC Thin Client SELECT A.ACCT_ID, A.CUST_ID, A...
1,639,829 1,639,732 1.00 0.00 0.00 45d0kmvk9vmj4 JDBC Thin Client SELECT A.BILLING_CYCLE_ID, A.B...
1,473,017 1,472,891 1.00 0.00 0.00 3mhhf4jvgzx6n JDBC Thin Client SELECT ACCT_ID, CUST_ID, AC...
1,457,675 1,457,671 1.00 0.00 0.00 194tahhfmx4g2 JDBC Thin Client SELECT A.PROD_SPEC_ID, A.ATTR_...
1,454,622 1,454,323 1.00 0.00 0.00 47r1y8yn34jmj   select default$ from col$ wher...
1,143,434 1,142,316 1.00 0.00 0.00 aac27xy2wa8xm JDBC Thin Client SELECT A.SUBS_ID, A.AC...
870,387 987,644 1.13 0.00 0.00 dck0671qxub6d JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, A....
809,915 748,160 0.92 0.00 0.00 210awqcc8rpxc JDBC Thin Client SELECT T.BILL_ID, T.BILL_NBR, ...
763,539 740,678 0.97 0.00 0.00 gw9sd12xq1qyh JDBC Thin Client SELECT A.SUBS_ID, A.PREFIX, ...
753,555 753,454 1.00 0.00 0.00 5vxd8cgx4g02j JDBC Thin Client SELECT ACCT_ID, CUST_ID, ACCT_...
724,788 901,997 1.24 0.00 0.02 c1cgc2w6pat1r JDBC Thin Client INSERT INTO ACCT_BOOK(ACCT_...
701,433 789,258 1.13 0.00 0.01 5p1x50sgu9x6u JDBC Thin Client SELECT A.SUBS_UPP_INST_ID, A....
669,383 526,797 0.79 0.00 0.00 56cpaj7dsk2j0 JDBC Thin Client SELECT T.ADVICE_ID, T.ADVICE_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,454,589 1,454,622 16.21 47r1y8yn34jmj   select default$ from col$ wher...
561,449 561,501 6.26 atj60ptcuz6vu JDBC Thin Client SELECT CUST_CONTACT_ID_SEQ.NEX...
378,571 378,575 4.22 7hn921np4kpjr JDBC Thin Client SELECT RE_CC_INST_ID_SEQ.NEXTV...
362,944 362,943 4.04 arubu9bzfvjkv JDBC Thin Client SELECT PRICE_PLAN_ID FROM ACC...
276,628 276,634 3.08 55w0ahzxnbvfs JDBC Thin Client SELECT SUBS_ORDER_ID_SEQ.NEXTV...
276,622 276,633 3.08 2pmtqzw43yuhr JDBC Thin Client SELECT CUST_ORDER_ID_SEQ.NEXTV...
190,064 190,065 2.12 1wdtf3v47wm56 JDBC Thin Client SELECT ADVICE_ID_SEQ.NEXTVAL F...
170,609 170,610 1.90 4cun1ks8fmns7 JDBC Thin Client SELECT AB_BATCH_ID.NEXTVAL FRO...
146,297 146,296 1.63 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
139,902 139,902 1.56 9h8tvw8wwvwjy JDBC Thin Client SELECT SUBS_UPP_ORDER_ID_SEQ.N...
139,667 139,667 1.56 4wm6xwgd11d4m JDBC Thin Client SELECT SUBS_UPP_INST_ID_SEQ.NE...
92,280 92,300 1.03 46uqh8unfhpcx oracle@ocsdb2 (TNS V1-V3) SELECT 1 FROM "DUAL" "A1"

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
13f42myq0tsvbselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"STATE_DATE" val, ntile(254) over (order by "STATE_DATE") bkt from "CC"."CC_EVENT_HIS" t where TBL$OR$IDX$PART$NUM("CC"."CC_EVENT_HIS", 0, 4, 0, "ROWID") = :objn and "STATE_DATE" is not null) group by val) group by maxbkt order by maxbkt
194tahhfmx4g2SELECT A.PROD_SPEC_ID, A.ATTR_ID, A.ATTR_VALUE_ID, A.DISP_ORDER, B.ATTR_NAME, B.ATTR_TYPE, B.ATTR_CODE, C.INPUT_TYPE, C.DEFAULT_VALUE, C.NULLABLE, C.VALUE_SCRIPT, D.VALUE_MARK, D.VALUE, B.CSR_VISIBLE, B.INSTANTIATABLE, C.BASE_ATTR_ID FROM PROD_SPEC_ATTR A , ATTR B, BASE_ATTR C, ATTR_VALUE D, PROD_SPEC E WHERE A.ATTR_ID=B.ATTR_ID AND A.PROD_SPEC_ID=E.PROD_SPEC_ID AND B.ATTR_ID=C.BASE_ATTR_ID AND A.ATTR_VALUE_ID=D.ATTR_VALUE_ID AND A.ATTR_ID=D.BASE_ATTR_ID AND B.INSTANTIATABLE='N' AND A.PROD_SPEC_ID=:1
1wdtf3v47wm56SELECT ADVICE_ID_SEQ.NEXTVAL FROM DUAL
210awqcc8rpxcSELECT T.BILL_ID, T.BILL_NBR, T.ACCT_ID, T.BILLING_CYCLE_ID, NVL(T.PRE_BALANCE, 0) PRE_BALANCE, NVL(T.DUE, 0) DUE, NVL(T.ADJUST_CHARGE, 0) ADJUST_CHARGE, NVL(T.DISPUTE_CHARGE, 0) DISPUTE_CHARGE, NVL(T.RECV_CHARGE, 0) RECV_CHARGE, NVL(T.PAST_ADJUST_CHARGE, 0) PAST_ADJUST_CHARGE FROM BILL T WHERE T.ACCT_ID = :1 AND T.BILLING_CYCLE_ID = :2
2drzzmj77h1g8SELECT A.ACCT_ID, A.CUST_ID, A.ACCT_NBR, A.BILLING_CYCLE_TYPE_ID, A.PAYMENT_TYPE, A.BANK_ID, A.BANK_ACCT_NBR, A.BANK_ACCT_NAME, A.CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, A.POSTPAID, A.ROUTING_ID, A.SP_ID, B.PAYMENT_TYPE_NAME, C.BILLING_CYCLE_TYPE_NAME, D.BANK_NAME FROM ACCT A, PAYMENT_TYPE B, BILLING_CYCLE_TYPE C, BANK D WHERE A.PAYMENT_TYPE=B.PAYMENT_TYPE AND A.BILLING_CYCLE_TYPE_ID=C.BILLING_CYCLE_TYPE_ID AND A.ACCT_ID=:1 AND A.BANK_ID=D.BANK_ID(+)
2pm0hyugpp3hxselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"CREATED_DATE" val, ntile(254) over (order by "CREATED_DATE") bkt from "CC"."CC_EVENT_HIS" t where TBL$OR$IDX$PART$NUM("CC"."CC_EVENT_HIS", 0, 4, 0, "ROWID") = :objn and "CREATED_DATE" is not null) group by val) group by maxbkt order by maxbkt
2pmtqzw43yuhrSELECT CUST_ORDER_ID_SEQ.NEXTVAL FROM DUAL
2q7xx2jpyq4njSELECT DISTINCT A.PRICE_PLAN_ID FROM SUBS_UPP_INST A WHERE A.SUBS_ID = :1 AND A.STATE = 'A' AND A.EFF_DATE <= SYSDATE AND (A.EXP_DATE IS NULL OR A.EXP_DATE > SYSDATE) AND A.PROD_ID IS NULL
3dapbubjf2rktSELECT FILE_ID, FILE_NAME, FILE_SIZE, CLT_LINK_ID, STATE FROM (SELECT * FROM CLT_FILELIST A WHERE A.CLT_LINK_ID = :LINK_ID AND A.STATE IN ('I', 'W', 'A') ORDER BY A.FILE_ID ) WHERE ROWNUM <= :ROWNO
3mhhf4jvgzx6nSELECT ACCT_ID, CUST_ID, ACCT_NBR, BILLING_CYCLE_TYPE_ID, PAYMENT_TYPE, BANK_ID, BANK_ACCT_NBR, BANK_ACCT_NAME, CREATED_DATE, UPDATE_DATE, STATE, STATE_DATE, POSTPAID, ROUTING_ID, SP_ID FROM ACCT WHERE ACCT_ID=:1
45d0kmvk9vmj4SELECT A.BILLING_CYCLE_ID, A.BILLING_CYCLE_TYPE_ID FROM BILLING_CYCLE A, ACCT B WHERE A.CYCLE_BEGIN_DATE <= SYSDATE AND A.CYCLE_END_DATE > SYSDATE AND A.BILLING_CYCLE_TYPE_ID = B.BILLING_CYCLE_TYPE_ID AND B.ACCT_ID = (SELECT ACCT_ID FROM SUBS WHERE SUBS_ID = :1)
46uqh8unfhpcxSELECT 1 FROM "DUAL" "A1"
47r1y8yn34jmjselect default$ from col$ where rowid=:1
4cun1ks8fmns7SELECT AB_BATCH_ID.NEXTVAL FROM DUAL
4dafta9sdk89k SELECT /*+ RULE*/ A.SUBS_ID SUBS_ID, 0 SUBS_SEQ, A.PREFIX, A.ACC_NBR, A.PREFIX||A.ACC_NBR PRE_NBR, A.CUST_ID, A.USER_ID, NVL(A.DEF_LANG_ID, -1) DEF_LANG_ID, A.ACCT_ID, NVL(A.AGENT_ID, -1) AGENT_ID, A.PRICE_PLAN_ID, NVL(A.AREA_ID, -1) AREA_ID, NVL(A.ROUTING_ID, 0) ROUTING_ID, A.IMSI, A.PPS_PWD, B.CREATED_DATE, A.UPDATE_DATE UPDATE_DATE, B.STATE, B.STATE_DATE, B.COMPLETED_DATE EFF_DATE, TO_DATE('30000101000000', 'YYYYMMDDHH24MISS') EXP_DATE, CHANGE_NOTIF_ID FROM SUBS A, PROD B, CHANGE_NOTIF C WHERE A.SUBS_ID=B.PROD_ID AND A.SUBS_ID>0 AND (A.UPDATE_DATE> TRUNC(SYSDATE) -(:P_DAYS) OR :P_DAYS<0) AND C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS' AND C.KEY_VALUE=A.SUBS_ID AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ RULE*/ A.SUBS_ID SUBS_ID, A.SEQ SUBS_SEQ, A.PREFIX, A.ACC_NBR, A.PREFIX||A.ACC_NBR PRE_NBR, A.CUST_ID, A.USER_ID, NVL(A.DEF_LANG_ID, -1) DEF_LANG_ID, A.ACCT_ID, NVL(A.AGENT_ID, -1) AGENT_ID, A.PRICE_PLAN_ID, NVL(A.AREA_ID, -1) AREA_ID, 0 ROUTING_ID, A.IMSI, '' PPS_PWD, TO_DATE('1', 'YYYY') CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, A.EFF_DATE, A.EXP_DATE, CHANGE_NOTIF_ID FROM SUBS_HIS A, CHANGE_NOTIF C , SUBS Z WHERE A.SUBS_ID>0 AND (A.UPDATE_DATE> TRUNC(SYSDATE) -(:P_DAYS) OR :P_DAYS<0) AND C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHA NGE_NOTIF_ID AND C.TABLE_NAME='SUBS' AND C.KEY_VALUE=A.SUBS_ID AND A.SUBS_ID=Z.SUBS_ID AND NVL(Z.ROUTING_ID, 0) =0 ORDER BY CHANGE_NOTIF_ID
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4p9fy188gb0rrSELECT A.RES_ID FROM USED_RES A WHERE A.RES_TYPE=:1 AND A.STATE='A' AND A.PROD_ID=:2
4sv506pk03h8p SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID, A.ATTR_ID, A.VALUE, 0 SEQ, A.EFF_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) EXP_DATE, CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, SUBS_UPP_INST_VALUE A, SHM_UPLOAD_ATTR F , SUBS_UPP_INST B WHERE C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS_UPP_INST' AND B.SUBS_UPP_INST_ID=A.SUBS_UPP_INST_ID AND A.SUBS_UPP_INST_ID=TO_NUMBER(SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1)) AND A.ATTR_ID=F.ATTR_ID AND F.TABLE_NAME='SUBS_UPP_INST_VALUE' AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID, A.ATTR_ID, A.VALUE, A.SEQ, A.EFF_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) EXP_DATE, CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, SUBS_UPP_INST_VALUE_HIS A, SHM_UPLOAD_ATTR F, SUBS_UPP_INST B WHERE C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS_UPP_INST' AND A.SUBS_UPP_INST_ID=TO_NUMBER(SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1)) AND B.SUBS_UPP_INST_ID=A.SUBS_UPP_INST_ID AND A.ATTR_ID=F.ATTR_ID AND F.TABLE_NAME='SUBS_UPP_INST_VALUE' AND NVL(A.ROUTING_ID, 0) =0
4wm6xwgd11d4mSELECT SUBS_UPP_INST_ID_SEQ.NEXTVAL FROM DUAL
55w0ahzxnbvfsSELECT SUBS_ORDER_ID_SEQ.NEXTVAL FROM DUAL
56cpaj7dsk2j0SELECT T.ADVICE_ID, T.ADVICE_TYPE, T.SUBS_ID, T.PREFIX, T.ACC_NBR, T.MSG , T.STATE, T.MSG_PARAM, STD_CODE FROM ADVICE T, ADVICE_TYPE AT WHERE T.ADVICE_ID = :1 AND AT.ADVICE_TYPE=T.ADVICE_TYPE
5gxk7c8nk1d08SELECT DATA_.* FROM (SELECT T.ADVICE_ID, T.ADVICE_TYPE, T.SUBS_ID, B.STD_CODE, T.PREFIX, T.ACC_NBR, T.STATE, T.STATE_DATE, T.COMMENTS, T.MSG, T.MSG_PARAM, T.SENDER_PARAM, B.PRIORITY FROM ADVICE T, ADVICE_TYPE B WHERE (T.STATE = 'A' OR T.STATE = 'I') AND T.ADVICE_TYPE = B.ADVICE_TYPE AND B.ADVICE_CHANNEL = :1 AND DECODE(B.PRIORITY, NULL, 1, B.PRIORITY) = :2 AND TO_CHAR(SYSDATE, 'HH24:MI:SS') > = DECODE(B.EFF_TIME, NULL, '00:00:00', TO_CHAR(B.EFF_TIME, 'HH24:MI:SS')) AND TO_CHAR(SYSDATE, 'HH24:MI:SS') < = DECODE(B.EXP_TIME, NULL, '23:59:59', TO_CHAR(B.EXP_TIME, 'HH24:MI:SS')) AND (SYSDATE-T.CREATED_DATE)*24*3600>NVL(B.DELAY_TIME, 0) ) DATA_ WHERE ROWNUM <= :3 ORDER BY ADVICE_ID
5p1x50sgu9x6uSELECT A.SUBS_UPP_INST_ID, A.SUBS_ID, A.PRICE_PLAN_ID, A.CREATED_DATE, A.EFF_DATE, A.EXP_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, A.PROD_ID, A.SP_ID, A.OFFER_ID, A.COMPLETED_DATE, B.PRICE_PLAN_NAME, B.PRICE_PLAN_CODE, B.APPLY_LEVEL, B.STATE PRICE_PLAN_STATE, B.PRIORITY, B.STATE_DATE PRICE_PLAN_STATE_DATE, C.OFFER_NAME, SPP.PRICE_PLAN_TYPE FROM SUBS_UPP_INST A, PRICE_PLAN B, OFFER C, SUBS_PRICE_PLAN SPP WHERE A.STATE != 'X' AND (A.EXP_DATE IS NULL OR A.EXP_DATE > SYSDATE) AND A.PRICE_PLAN_ID = B.PRICE_PLAN_ID AND A.OFFER_ID = C.OFFER_ID(+) AND A.PRICE_PLAN_ID = SPP.PRICE_PLAN_ID AND A.SUBS_ID = :1
5pv1pdy7khs73SELECT MIN(CHANGE_NOTIF_ID) MIN_CHANGE_NOTIF_ID, MAX(CHANGE_NOTIF_ID) MAX_CHANGE_NOTIF_ID, DECODE(UPPER(TABLE_NAME), 'ACCT', 1, 'SUBS', 2, 'SUBS_UPP_INST', 3, 'PROD', 4, 'PROD_ATTR_VALUE', 5, 'SUBS_ACCT', 6, 'FELLOW_NBR', 7, 'ROUTING', 8, 'SIM_CARD', 9, 'ROUTING_TABLE', 10, 'CALLING_CIRCLE_MEM', 11, 'ACC_NBR', 12, 'SUBS_UPP_INST_VALUE', 13, 'PAYMENT_TRANSFER', 14, 'DEPEND_PROD_SPEC', 15, 'BUNDLE_SUBS_INST', 16, 'INDEP_PROD_RELA', 17, 'BAL_ACCT_ITEM_TYPE', 18, 'BAL_SHARE', 19, 'CUST_ATTR_VALUE', 20, 'ACCT_ATTR_VALUE', 21, 0) TABLE_ID FROM CHANGE_NOTIF WHERE CHANGE_NOTIF_ID>:P_CHANGE_NOTIF_ID AND CREATED_DATE<=SYSDATE-:P_DELAY_SECOND/24/60/60 GROUP BY TABLE_NAME
5qyt8mfx73k94SELECT A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.CUST_ID, A.USER_ID, A.ACCT_ID, A.AGENT_ID, A.PRICE_PLAN_ID, A.AREA_ID, A.UPDATE_DATE, A.CREDIT_LIMIT, A.CREDIT_LIMIT_PLAN_ID, A.BONUS_AMOUNT, A.ROUTING_ID, A.DEF_LANG_ID, NVL(A.SP_ID, 0) SP_ID, A.PPS_PWD, A.IMSI, B.CUST_CODE, B.CUST_NAME, B.CUST_TYPE, B.CERT_ID, B.PARENT_ID, B.ZIPCODE, B.ADDRESS, B.CREATED_DATE CUST_CREATED_DATE, B.UPDATE_DATE CUST_UPDATE_DATE, B.PARTY_TYPE, B.PARTY_CODE, B.EMAIL, B.STATE CUST_STATE, B.STATE_DATE CUST_STATE_DATE, B.PWD, B.PARTY_TYPE, B.PARTY_CODE, C.PROD_ID, C.CREATED_DATE, C.COMPLETED_DATE, C.PROD_STATE, C.PROD_STATE_DATE, C.UPDATE_DATE PROD_UPDATE_DATE, C.PROD_STATE_DATE, C.BLOCK_REASON, C.PROD_EXP_DATE, C.PROD_SPEC_ID, C.OFFER_ID FROM SUBS A, CUST B, PROD C WHERE A.CUST_ID = B.CUST_ID AND A.SUBS_ID = C.PROD_ID AND A.PREFIX = :1 AND A.ACC_NBR = :2 ORDER BY C.COMPLETED_DATE DESC
5rv49239kcwccinsert into cust_contact(cust_contact_id, contact_channel_id, cust_id, created_date, contact_type , party_type, party_code, contact_obj, ip_port, contact_content, app_id, sp_id) values(:1, :2, :3, sysdate, :4, :5, :6, :7, :8, :9, :10, :11)
5vxd8cgx4g02jSELECT ACCT_ID, CUST_ID, ACCT_NBR, BILLING_CYCLE_TYPE_ID, PAYMENT_TYPE, BANK_ID, BANK_ACCT_NBR, BANK_ACCT_NAME, CREATED_DATE, UPDATE_DATE, STATE, STATE_DATE, POSTPAID, ROUTING_ID, SP_ID, BILL_FORMAT_ID FROM ACCT WHERE ACCT_ID= :1 FOR UPDATE NOWAIT
64vruxp06m37k SELECT /*+ ORDERED */ A.SUBS_ID ||'~'||0 ||'~'||A.PREFIX ||'~'||A.ACC_NBR ||'~'||A.PREFIX||A.ACC_NBR ||'~'||A.CUST_ID ||'~'||A.USER_ID ||'~'||A.SP_ID ||'~'||NVL(A.DEF_LANG_ID, -1) ||'~'||A.ACCT_ID ||'~'||NVL(A.AGENT_ID, -1) ||'~'||A.PRICE_PLAN_ID ||'~'||NVL(A.AREA_ID, -1) ||'~'||NVL(A.ROUTING_ID, 0) ||'~'||IMSI ||'~'||PPS_PWD ||'~'||TO_CHAR(B.CREATED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||B.STATE ||'~'||TO_CHAR(B.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(B.COMPLETED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||A.IMSI2 AS RETSTRING, CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, SUBS A, PROD B WHERE C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS' AND A.SUBS_ID= TO_NUMBER(SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1)) AND B.PROD_ID=A.SUBS_ID AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED */ A.SUBS_ID ||'~'||A.SEQ ||'~'||A.PREFIX ||'~'||A.ACC_NBR ||'~'||A.PREFIX||A.ACC_NBR ||'~'||A.CUST_ID ||'~'||A.USER_ID ||'~'||A.SP_ID ||'~'||NVL(A.DEF_LANG_ID, -1) ||'~'| |A.ACCT_ID ||'~'||NVL(A.AGENT_ID, -1) ||'~'||A.PRICE_PLAN_ID ||'~'||NVL(A.AREA_ID, -1) ||'~'||NVL(A.ROUTING_ID, 0) ||'~'||A.IMSI ||'~'||' ' ||'~'||TO_CHAR(TO_DATE('19710101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.STATE ||'~'||TO_CHAR(A.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.EFF_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.EXP_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.IMSI2 AS RETSTRING, CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, SUBS_HIS A WHERE C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS' AND A.SUBS_ID= TO_NUMBER(SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1)) AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED */ A.SUBS_ID ||'~'||0 ||'~'||A.PREFIX ||'~'||A.ACC_NBR ||'~'||A.PREFIX||A.ACC_NBR ||'~'||A.CUST_ID ||'~'||A.USER_ID ||'~'||A.SP_ID ||'~'||NVL(A.DEF_LANG_ID, -1) ||'~'||A.ACCT_ID ||'~'||NVL(A.AGENT_ID, -1) ||'~'||A.PRICE_PLAN_ID ||'~'||NVL(A.AREA_ID, -1) ||'~'||NVL(A.ROUTING_ID, 0) ||'~'||IMSI ||'~'||PPS_PWD ||'~'||TO_CHAR(B.CREATED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||B.STATE ||'~'||TO_CHAR(B.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(B.COMPLETED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||A.IMSI2 AS RETSTRING, D.CHANGE_NOTIF_ID, D.KEY_VALUE FROM CHANGE_NOTIF D, SUBS A, PROD B, INDEP_PROD_SPEC C WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='SUBS' AND A.SUBS_ID= TO_NUMBER(SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1)) AND B.PROD_ID=A.SUBS_ID AND B.PROD_SPEC_ID = C.INDEP_PROD_SPEC_ID AND C.SERV_TYPE=25 AND NVL(A.ROUTING_ID, 0) ! =0 UNION ALL SELECT /*+ ORDERED*/ A.SUBS_ID ||'~'||A.SEQ ||'~'||A.PREFIX ||'~'||A.ACC_NBR ||'~'||A.PREFIX||A.ACC_NBR ||'~'||A.CUST_ID ||'~'||A.USER_ID ||'~'||A.SP_ID ||'~'||NVL(A.DEF_LANG_ID, -1) ||'~'||A.ACCT_ID ||'~'||NVL(A.AGENT_ID, -1) ||'~'||A.PRICE_PLAN_ID ||'~'||NVL(A.AREA_ID, -1) ||'~'||NVL(A.ROUTING_ID, 0) ||'~'||A.IMSI ||'~'||' ' ||'~'||TO_CHAR(TO_DATE('19710101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.STATE ||'~'||TO_CHAR(A.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.EFF_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CH AR(A.EXP_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.IMSI2 AS RETSTRING, E.CHANGE_NOTIF_ID, E.KEY_VALUE FROM CHANGE_NOTIF E, SUBS_HIS A, PROD_HIS B, INDEP_PROD_SPEC C WHERE TO_NUMBER(E.CHANGE_NOTIF_ID)>=:P_MIN_CHANGE_NOTIF_ID AND TO_NUMBER(E.CHANGE_NOTIF_ID)<=:P_MAX_CHANGE_NOTIF_ID AND E.TABLE_NAME='SUBS' AND A.SUBS_ID= TO_NUMBER(SUBSTR(E.KEY_VALUE, 0, DECODE(INSTR(E.KEY_VALUE, '-'), 0, LENGTH(E.KEY_VALUE) + 1, INSTR(E.KEY_VALUE, '-')) - 1)) AND B.PROD_ID=A.SUBS_ID AND B.PROD_SPEC_ID = C.INDEP_PROD_SPEC_ID AND C.SERV_TYPE=25 AND NVL(A.ROUTING_ID, 0) ! =0
73vvk3pn1pka9 SELECT /*+ ORDERED */ A.PROD_ID ||'~'||A.ATTR_ID ||'~'||0 ||'~'||VALUE ||'~'||TO_CHAR(DECODE(SIGN(A.UPDATE_DATE-A.EFF_DATE), 1, A.UPDATE_DATE, A.EFF_DATE), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('19710101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') AS RETSTRING, CHANGE_NOTIF_ID, D.KEY_VALUE, NVL(ACTION_TYPE, 'E') ACTION_TYPE, SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1) DELETE_PROD_ID, SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-')+1)) DELETE_ATTR, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS') REC_EFF_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS') REC_EXP_DATE FROM CHANGE_NOTIF D, PROD_ATTR_VALUE A, SHM_UPLOAD_ATTR F WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='PROD_ATTR_VALUE' AND A.PROD_ID= SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-'))-1) AND F.TABLE_NAME='PROD_ATTR_VALUE' AND A.ATTR_ID = F.ATTR_ID AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED */ A.PROD_ID ||'~'||A.AT TR_ID ||'~'||SEQ ||'~'||VALUE ||'~'||TO_CHAR(DECODE(SIGN(A.EFF_DATE-A.REC_EFF_DATE), 1, A.EFF_DATE, A.REC_EFF_DATE), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(DECODE(SIGN(NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'))- A.REC_EXP_DATE), 1, A.REC_EXP_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'))), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(A.REC_EFF_DATE, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS')), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(A.REC_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')), 'YYYYMMDDHH24MISS') AS RETSTRING, CHANGE_NOTIF_ID, D.KEY_VALUE, NVL(ACTION_TYPE, 'E') ACTION_TYPE, SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1) DELETE_PROD_ID, SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-')+1)) DELETE_ATTR, NVL(A.REC_EFF_DATE, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS')) REC_EFF_DATE, NVL(A.REC_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) REC_EXP_DATE FROM CHANGE_NOTIF D, PROD_ATTR_VALUE_HIS A, SHM_UPLOAD_ATTR F WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='PROD_ATTR_VALUE' AND A.PROD_ID=SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-'))-1) AND F.TABLE_NAME ='PROD_ATTR_VALUE' AND A.ATTR_ID=F.ATTR_ID AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED */ A.PROD_ID ||'~'||A.ATTR_ID ||'~'||0 ||'~'||VALUE ||'~'||TO_CHAR(DECODE(SIGN(A.UPDATE_DATE-A.EFF_DATE), 1, A.UPDATE_DATE, A.EFF_DATE), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('19710101000000', 'YYYYMMDDHH24MISS'), 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(TO_DATE('21000101000000', 'YYYYMMDDHH24MISS') , 'YYYYMMDDHH24MISS') AS RETSTRING, CHANGE_NOTIF_ID, D.KEY_VALUE, NVL(ACTION_TYPE, 'E') ACTION_TYPE, SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1) DELETE_PROD_ID, SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-')+1)) DELETE_ATTR, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS') REC_EFF_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS') REC_EXP_DATE FROM CHANGE_NOTIF D, PROD_ATTR_VALUE A, SHM_UPLOAD_ATTR F, PROD C, INDEP_PROD_SPEC G WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='PROD_ATTR_VALUE' AND A.PROD_ID= SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-'))-1) AND F.TABLE_NAME='PROD_ATTR_VALUE ' AND A.ATTR_ID = F.ATTR_ID AND C.PROD_ID = A.PROD_ID AND C.PROD_SPEC_ID=G.INDEP_PROD_SPEC_ID AND G.SERV_TYPE=25 AND NVL(A.ROUTING_ID, 0) ! =0 UNION ALL SELECT /*+ ORDERED */ A.PROD_ID ||'~'||A.ATTR_ID ||'~'||SEQ ||'~'||VALUE ||'~'||TO_CHAR(DECODE(SIGN(A.EFF_DATE-A.REC_EFF_DATE), 1, A.EFF_DATE, A.REC_EFF_DATE) , 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(DECODE(SIGN(NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'))- A.REC_EXP_DATE), 1, A.REC_EXP_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS'))) , 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(A.REC_EFF_DATE, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS')) , 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(A.REC_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) , 'YYYYMMDDHH24MISS') AS RETSTRING, CHANGE_NOTIF_ID, D.KEY_VALUE, NVL(ACTION_TYPE, 'E') ACTION_TYPE, SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1) DELETE_PROD_ID, SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-')+1)) DELETE_ATTR, NVL(A.REC_EFF_DATE, TO_DATE('19710101000000', 'YYYYMMDDHH24MISS')) REC_EFF_DATE, NVL(A.REC_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) REC_EXP_DATE FROM CHANGE_NOTIF D, PROD_ATTR_VALUE_HIS A, SHM_UPLOAD_ATTR F, PROD C, INDEP_PROD_SPEC G WHERE D.CHANGE_NOTI F_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='PROD_ATTR_VALUE' AND A.PROD_ID=SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-'))-1) AND F.TABLE_NAME='PROD_ATTR_VALUE' AND A.ATTR_ID=F.ATTR_ID AND C.PROD_ID = A.PROD_ID AND C.PROD_SPEC_ID=G.INDEP_PROD_SPEC_ID AND G.SERV_TYPE=25 AND NVL(A.ROUTING_ID, 0) ! =0 UNION ALL SELECT /*+ ORDERED*/ SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-'))-1) || '~' || SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE)+1, INSTR(D.KEY_VALUE, '-')+1)) || '~' ||0 || '~' ||0 || '~' ||TO_CHAR(sysdate - 100, 'YYYYMMDDHH24MISS') || '~' ||TO_CHAR(sysdate + 1, 'YYYYMMDDHH24MISS') || '~' || '' || '~' ||TO_CHAR(sysdate - 100, 'YYYYMMDDHH24MISS') || '~' ||TO_CHAR(sysdate + 1, 'YYYYMMDDHH24MISS') AS RETSTRING, CHANGE_NOTIF_ID, D.KEY_VALUE, NVL(ACTION_TYPE, 'E') ACTION_TYPE, SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1) DELETE_PROD_ID, SUBSTR(D.KEY_VALUE, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-') + 1)) DELETE_ATTR, TO_DATE('1', 'YYYY') REC_EFF_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS') REC_EXP_DATE FROM CHANGE_NOTIF D WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_ NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='PROD_ATTR_VALUE' AND D.ACTION_TYPE ='D'
76v4wrvvjs14mSELECT /*+ ORDERED*/ A.SUBS_ID SUBS_ID, NVL(A.CREDIT_LIMIT, 0) CREDIT_LIMIT, NVL(A.CREDIT_LIMIT_PLAN_ID, -1) CREDIT_LIMIT_PLAN_ID, NVL(A.BONUS_AMOUNT, 0) BONUS_AMOUNT, CHANGE_NOTIF_ID, B.STATE, A.UPDATE_DATE FROM CHANGE_NOTIF C, SUBS A, PROD B WHERE C.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND C.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND C.TABLE_NAME='SUBS' AND A.SUBS_ID=TO_NUMBER(SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1)) AND B.PROD_ID=A.SUBS_ID AND NVL(A.ROUTING_ID, 0) =0
7c9n4drcbykvnSELECT MIN(CHANGE_NOTIF_ID) MIN_CHANGE_NOTIF_ID, MAX(CHANGE_NOTIF_ID) MAX_CHANGE_NOTIF_ID, COUNT(1) COUNT, DECODE(UPPER(TABLE_NAME), 'ATTR', 1, 'ACCT', 2, 'SUBS', 3, 'SUBS_UPP_INST', 4, 'PROD', 5, 'PROD_ATTR_VALUE', 6, 'CUST', 7, 'SUBS_ACCT', 8, 'FELLOW_NBR', 9, 'SUBS_UPP_INST_VALUE', 10, 'SUBS_HOME_ZONE', 11, 'SUBS_HOME_CELL', 12, 'BUNDLE_SUBS_INST', 13, 'SUBS_RELA', 14, 'BAL_ACCT_ITEM_TYPE', 15, 'BAL_SHARE', 16, 'CUST_ATTR_VALUE', 17, 'ACCT_ATTR_VALUE', 18, 'NP_DB', 19, 'DEPOSIT_BAL', 20, 'CC_SUBS', 21, 'CC_ACCT', 22, 'SUBS_RELA_ATTR_VALUE', 23, 'SUBS_ACCNBR_RELA', 24, 0) TABLE_ID FROM CHANGE_NOTIF WHERE CHANGE_NOTIF_ID BETWEEN :P_CHANGE_NOTIF_ID_LAST AND :P_CHANGE_NOTIF_ID_NEXT GROUP BY TABLE_NAME
7hn921np4kpjrSELECT RE_CC_INST_ID_SEQ.NEXTVAL FROM DUAL
7rh0unadm78kh SELECT /*+ ORDERED*/ A.PROD_ID ||'~'||0 ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, PROD_SPEC_ID, -1) ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, -1, PROD_SPEC_ID) ||'~'||NVL(INDEP_PROD_ID, -1) ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, 'M', 'R') ||'~'||PROD_STATE ||'~'||TO_CHAR(PROD_STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.COMPLETED_DATE, 'YYYYMMDDHH24MISS') ||'~'||NVL(BLOCK_REASON, '') ||'~'||TO_CHAR(A.CREATED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.STATE ||'~'||TO_CHAR(A.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE , 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(NVL(PROD_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) , 'YYYYMMDDHH24MISS') ||'~'||A.OFFER_ID ||'~'||OFFER_TYPE ||'~'||OFFER_CODE AS RETSTRING, C.CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, PROD A , OFFER G WHERE C.CHANGE_NOTIF_ID>=to_NUMBER(:P_MIN_CHANGE_NOTIF_ID) AND C.CHANGE_NOTIF_ID<=to_NUMBER(:P_MAX_CHANGE_NOTIF_ID) AND C.TABLE_NAME='PROD' AND A.PROD_ID=SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1) AND (A.OFFER_ID=G.OFFER_ID(+)) AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED*/ A.PROD_ID ||'~'||A.SEQ ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, PROD_SPEC_ID , -1) ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, -1, PROD_SPEC_ID) ||'~'||NVL(INDEP_PROD_ID, -1) ||'~'||DECODE(NVL(INDEP_PROD_ID, -1), -1, 'M', 'R') ||'~'||PROD_STATE ||'~'||TO_CHAR(PROD_STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.COMPLETED_DATE, 'YYYYMMDDHH24MISS') ||'~'||NVL(BLOCK_REASON, '') ||'~'||TO_CHAR(A.CREATED_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.UPDATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.STATE ||'~'||TO_CHAR(A.STATE_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.EFF_DATE, 'YYYYMMDDHH24MISS') ||'~'||TO_CHAR(A.EXP_DATE, 'YYYYMMDDHH24MISS') ||'~'||A.OFFER_ID ||'~'||OFFER_TYPE ||'~'||OFFER_CODE AS RETSTRING, C.CHANGE_NOTIF_ID, C.KEY_VALUE FROM CHANGE_NOTIF C, PROD_HIS A , OFFER G WHERE C.CHANGE_NOTIF_ID>=to_NUMBER(:P_MIN_CHANGE_NOTIF_ID) AND C.CHANGE_NOTIF_ID<=to_NUMBER(:P_MAX_CHANGE_NOTIF_ID) AND C.TABLE_NAME='PROD' AND A.PROD_ID=SUBSTR(C.KEY_VALUE, 0, DECODE(INSTR(C.KEY_VALUE, '-'), 0, LENGTH(C.KEY_VALUE) + 1, INSTR(C.KEY_VALUE, '-')) - 1) AND (A.OFFER_ID=G.OFFER_ID(+)) AND NVL(A.ROUTING_ID, 0) =0
86k6c8nwkyjxk SELECT * FROM (SELECT * FROM (SELECT DISTINCT A.ACCT_BOOK_ID, A.CREATED_DATE, F.ACCT_BOOK_TYPE_NAME, A.PRE_BALANCE, A.PRE_EXP_DATE, A.CHARGE, H.ACCT_RES_NAME, A.PARTY_CODE, A.PRE_SUTTLE_BAL, A.SECONDS / 86400 DAYS, A.SECONDS, G.CONTACT_CHANNEL_NAME, DECODE(N.BAL_EVENT_NAME, NULL, E.EVENT_NAME, N.BAL_EVENT_NAME) EVENT_NAME, I.PARTY_TYPE_NAME, FOR_COMM_QUERY.GET_PARTY_CODE_NAME(A.PARTY_TYPE, A.PARTY_CODE) PARTY_CODE_NAME, A.ACCT_BOOK_TYPE, J.POSTPAID, A.ACCT_ID, A.BILL_ID, H.IS_CURRENCY, K.VOUCHER, K.SCRATCH_CARD_PWD, DECODE(SIGN(A.CHARGE), -1, A.CHARGE, NULL) IN_CHA RGE, DECODE(SIGN(A.CHARGE), -1, NULL, A.CHARGE) OUT_CHARGE, A.PRE_SUTTLE_BAL + A.CHARGE BALANCE_AFTER, A2.ADJUST_REASON_NAME, A.ACCT_RES_ID, C.REF_ATTR FROM ACCT_BOOK A, RE_AB_INST B, RE_CC_INST C, SUBS_RE_EVENT D, SUBS_EVENT E, ACCT_BOOK_TYPE F, CONTACT_CHANNEL G, ACCT_RES H, PARTY_TYPE I, ACCT J, PAYMENT K, ADJUST A1, ADJUST_REASON A2, AB_EVENT_BENEFIT L, BAL_EVENT_INST M, BAL_EVENT N WHERE 1=1 AND A.ACCT_BOOK_ID = B.ACCT_BOOK_ID(+) AND B.EVENT_INST_ID = C.EVENT_INST_ID(+) AND A.ACCT_BOOK_ID = K.PAYMENT_ID(+) AND A.ACCT_BOOK_TYPE = F.ACCT_BOOK_TYPE AND A.CONTACT_CHANNEL_ID = G.CONTACT_CHANNEL_ID(+) AND C.RE_ID = D.RE_ID(+) AND D.SUBS_EVENT_ID = E.SUBS_EVENT_ID(+) AND A.ACCT_RES_ID = H.A CCT_RES_ID AND A.PARTY_TYPE = I.PARTY_TYPE AND A.ACCT_ID = J.ACCT_ID AND A.ACCT_BOOK_ID = A1.ADJUST_ID(+) AND A1.ADJUST_REASON_ID = A2.ADJUST_REASON_ID(+) AND A.ACCT_BOOK_ID = L.ACCT_BOOK_ID(+) AND L.BAL_EVENT_INST_ID = M.BAL_EVENT_INST_ID(+) AND M.BAL_EVENT = N.BAL_EVENT(+) AND A.ACCT_BOOK_TYPE != 'Q' AND A.ACCT_ID = :1 AND A.CREATED_DATE >= TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS') AND A.CREATED_DATE <= TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS') AND A.ACCT_BOOK_TYPE NOT IN ('I') AND NVL(A.SP_ID, 0) = :4 UNION SELECT DISTINCT A.ACCT_BOOK_ID, A.CREATED_DATE, F.ACCT_BOOK_TYPE_NAME, A.PRE_BALANCE, A.PRE_EXP_DATE, A.CHARGE, H.ACCT_RES_NAME, A.PARTY_CODE, A.PRE_SUTTLE_BAL, A.SECONDS / 86400 DAYS, A.SECONDS, G.CONTACT_CHANNEL_NAME, DECODE(E.EV ENT_NAME, NULL, P.PRICE_NAME, E.EVENT_NAME) EVENT_NAME, I.PARTY_TYPE_NAME, FOR_COMM_QUERY.GET_PARTY_CODE_NAME(A.PARTY_TYPE, A.PARTY_CODE) PARTY_CODE_NAME, A.ACCT_BOOK_TYPE, J.POSTPAID, A.ACCT_ID, A.BILL_ID, H.IS_CURRENCY, K.VOUCHER, K.SCRATCH_CARD_PWD, DECODE(SIGN(A.CHARGE), -1, A.CHARGE, NULL) IN_CHARGE, DECODE(SIGN(A.CHARGE), -1, NULL, A.CHARGE) OUT_CHARGE, A.PRE_SUTTLE_BAL + A.CHARGE BALANCE_AFTER, '' AS ADJUST_REASON_NAME, A.ACCT_RES_ID, C.REF_ATTR FROM ACCT_BOOK A, RE_CC_INST C, SUBS_RE_EVENT D, SUBS_EVENT E, ACCT_BOOK_TYPE F, CONTACT_CHANNEL G, ACCT_RES H, PARTY_TYPE I, ACCT J, PAYMENT K, EVENT_CHARGE M, PRICE P WHERE A.ACCT_BOOK_ID = K.PAYMENT_ID(+) AND A.EVENT_INST_ID = C.EVENT_INST_ID(+) AND A.EVENT_INST_ID = M.EVENT_INST_ID(+) AND A.ACCT_BOOK_TYPE = F.ACCT_BOOK_TYPE AND A.CONTACT_CHANNEL_ID = G.CONTACT_CHANNEL_ID(+) AND C.RE_ID = D.RE_ID(+) AND D.SUBS_EVENT_ID = E.SUBS_EVENT_ID(+) AND M.PRICE_ID = P.PRICE_ID AND A.ACCT_RES_ID = H.ACCT_RES_ID AND A.PARTY_TYPE = I.PARTY_TYPE AND A.ACCT_ID = J.ACCT_ID AND A.ACCT_ID = :5 AND A.ACCT_BOOK_TYPE = 'Q' AND A.CREATED_DATE >= TO_DATE(:6, 'YYYY-MM-DD HH24:MI:SS') AND A.CREATED_DATE <= TO_DATE(:7, 'YYYY-MM-DD HH24:MI:SS') AND A.ACCT_BOOK_TYPE NOT IN ('I') AND NVL(A.SP_ID, 0) = :8 ) T ORDER BY T.CREATED_DATE DESC) T2 WHERE 1 = 1 AND ROWNUM<=:9
8hapcfq7jgc5r SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID INST_ID, 0 SEQ, A.SUBS_ID, NVL(A.PRICE_PLAN_ID, 0) PRICE_PLAN_ID, A.CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, DECODE(SIGN(A.EFF_DATE-A.UPDATE_DATE), 1, A.EFF_DATE, A.UPDATE_DATE) EFF_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) EXP_DATE, NVL(B.BUNDLE_INST_ID, 0) BUNDLE_INST_ID, NVL(B.AGM_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) AGM_EXP_DATE, NVL(C.BUNDLE_ID, 0) BUNDLE_ID, D.CHANGE_NOTIF_ID, A.COMPLETED_DATE, A.EFF_DATE REAL_EFF_DATE, D.KEY_VALUE FROM CHANGE_NOTIF D, SUBS_UPP_INST A, BUNDLE_UPP_INST B, BUNDLE_INST C WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='SUBS_UPP_INST' AND A.SUBS_UPP_INST_ID=TO_NUMBER(SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1)) AND A.SUBS_UPP_INST_ID=B.SUBS_UPP_INST_ID(+) AND B.BUNDLE_INST_ID=C.BUNDLE_INST_ID(+) AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID INST_ID, A.SEQ, A.SUBS_ID, NVL(A.PRICE_PLAN_ID, 0) PRICE_PLAN_ID, A.CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, DECODE(SIGN(A.EFF_DATE-A.REC_EFF_DATE), 1, A.EFF_DATE, A.REC_EFF_DATE) EFF_DATE, DECODE(SIGN(NVL(A.EXP_DATE, SYSDATE+10000)-A.REC_EXP_DATE), -1, NVL(A.EXP_DATE, SYSDATE+10000), A.REC_EXP_DATE) EXP_DATE, NVL(B.BUNDLE_INST_ID, 0) BUNDLE_INST_ID, NVL(B.AGM_E XP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) AGM_EXP_DATE, NVL(C.BUNDLE_ID, 0) BUNDLE_ID, D.CHANGE_NOTIF_ID, A.COMPLETED_DATE, A.EFF_DATE REAL_EFF_DATE, D.KEY_VALUE FROM CHANGE_NOTIF D, SUBS_UPP_INST_HIS A, BUNDLE_UPP_INST B, BUNDLE_INST C WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='SUBS_UPP_INST' AND A.SUBS_UPP_INST_ID=TO_NUMBER(SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1)) AND A.SUBS_UPP_INST_ID=B.SUBS_UPP_INST_ID(+) AND B.BUNDLE_INST_ID=C.BUNDLE_INST_ID(+) AND NVL(A.ROUTING_ID, 0) =0 UNION ALL SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID INST_ID, 0 SEQ, A.SUBS_ID, NVL(A.PRICE_PLAN_ID, 0) PRICE_PLAN_ID, A.CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, DECODE(SIGN(A.EFF_DATE-A.UPDATE_DATE), 1, A.EFF_DATE, A.UPDATE_DATE) EFF_DATE, NVL(A.EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) EXP_DATE, NVL(B.BUNDLE_INST_ID, 0) BUNDLE_INST_ID, NVL(B.AGM_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) AGM_EXP_DATE, NVL(C.BUNDLE_ID, 0) BUNDLE_ID, D.CHANGE_NOTIF_ID, A.COMPLETED_DATE, A.EFF_DATE REAL_EFF_DATE, D.KEY_VALUE FROM CHANGE_NOTIF D, SUBS_UPP_INST A, BUNDLE_UPP_INST B, BUNDLE_INST C WHERE D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.TABLE_NAME='SUBS_UPP_INST' AND A.SUBS_UPP_INST_ID=T O_NUMBER(SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1)) AND A.SUBS_UPP_INST_ID=B.SUBS_UPP_INST_ID(+) AND B.BUNDLE_INST_ID=C.BUNDLE_INST_ID(+) AND EXISTS (SELECT D.SUBS_ID FROM SUBS D, PROD E, INDEP_PROD_SPEC F WHERE A.SUBS_ID=D.SUBS_ID AND D.SUBS_ID=E.PROD_ID AND E.PROD_SPEC_ID = F.INDEP_PROD_SPEC_ID AND F.SERV_TYPE=25 AND NVL(D.ROUTING_ID, 0) ! =0 UNION ALL SELECT D.SUBS_ID FROM SUBS_HIS D, PROD_HIS B, INDEP_PROD_SPEC C WHERE A.SUBS_ID=D.SUBS_ID AND D.SUBS_ID = B.PROD_ID AND B.PROD_SPEC_ID = C.INDEP_PROD_SPEC_ID AND C.SERV_TYPE=25 AND NVL(D.ROUTING_ID, 0) ! =0 ) UNION ALL SELECT /*+ ORDERED*/ A.SUBS_UPP_INST_ID INST_ID, A.SEQ, A.SUBS_ID, NVL(A.PRICE_PLAN_ID, 0) PRICE_PLAN_ID, A.CREATED_DATE, A.UPDATE_DATE, A.STATE, A.STATE_DATE, DECODE(SIGN(A.EFF_DATE-A.REC_EFF_DATE), 1, A.EFF_DATE, A.REC_EFF_DATE) EFF_DATE, DECODE(SIGN(NVL(A.EXP_DATE, SYSDATE+10000)-A.REC_EXP_DATE), -1, NVL(A.EXP_DATE, SYSDATE+10000), A.REC_EXP_DATE) EXP_DATE, NVL(B.BUNDLE_INST_ID, 0) BUNDLE_INST_ID, NVL(B.AGM_EXP_DATE, TO_DATE('21000101000000', 'YYYYMMDDHH24MISS')) AGM_EXP_DATE, NVL(C.BUNDLE_ID, 0) BUNDLE_ID, D.CHANGE_NOTIF_ID, A.COMPLETED_DATE, A.EFF_DATE REAL_EFF_DATE, D.KEY_VALUE FROM CHANGE_NOTIF D, SUBS_UPP_INST_HIS A, BUNDLE_UPP_INST B, BUNDLE_INST C WHERE D.CHANGE_NOTIF_ID>=:P_MIN_CHANGE_NOTIF_ID AND D.CHANGE_NOTIF_ID<=:P_MAX_CHANGE_NOTIF_ID AND D.TABLE_NAME='SUBS_UPP_INST' AND A.SUBS_UPP_INST_ID=TO_NUMBER(SUBSTR(D.KEY_VALUE, 0, DECODE(INSTR(D.KEY_VALUE, '-'), 0, LENGTH(D.KEY_VALUE) + 1, INSTR(D.KEY_VALUE, '-')) - 1)) AND A.SUBS_UPP_INST_ID=B.SUBS_UPP_INST_ID(+) AND B.BUNDLE_INST_ID=C.BUNDLE_INST_ID(+) AND EXISTS (SELECT D.SUBS_ID FROM SUBS D, PROD E, INDEP_PROD_SPEC F WHERE A.SUBS_ID=D.SUBS_ID AND D.SUBS_ID=E.PROD_ID AND E.PROD_SPEC_ID = F.INDEP_PROD_SPEC_ID AND F.SERV_TYPE=25 AND NVL(D.ROUTING_ID, 0) ! =0 UNION ALL SELECT D.SUBS_ID FROM SUBS_HIS D, PROD_HIS B, INDEP_PROD_SPEC C WHERE A.SUBS_ID=D.SUBS_ID AND D.SUBS_ID = B.PROD_ID AND B.PROD_SPEC_ID = C.INDEP_PROD_SPEC_ID AND C.SERV_TYPE=25 AND NVL(D.ROUTING_ID, 0) ! =0 )
9054c5n52fjp5INSERT INTO ADVICE_HIS B (ADVICE_ID, ADVICE_TYPE, SUBS_ID, PREFIX, ACC_NBR, MSG, CREATED_DATE, STATE, STATE_DATE, COMMENTS, MSG_PARAM, SENDER_PARAM, ADVICE_CHANNEL) SELECT A.ADVICE_ID, A.ADVICE_TYPE, A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.MSG, A.CREATED_DATE, 'C', SYSDATE, A.COMMENTS, A.MSG_PARAM, A.SENDER_PARAM, B.ADVICE_CHANNEL FROM ADVICE A, ADVICE_TYPE B WHERE A.ADVICE_TYPE = B.ADVICE_TYPE AND A.ADVICE_ID = :1
97ysbnpd43da6 SELECT COUNT(*) CNT FROM (SELECT DISTINCT A.ACCT_BOOK_ID, A.CREATED_DATE, F.ACCT_BOOK_TYPE_NAME, A.PRE_BALANCE, A.PRE_EXP_DATE, A.CHARGE, H.ACCT_RES_NAME, A.PARTY_CODE, A.PRE_SUTTLE_BAL, A.SECONDS / 86400 DAYS, A.SECONDS, G.CONTACT_CHANNEL_NAME, DECODE(N.BAL_EVENT_NAME, NULL, E.EVENT_NAME, N.BAL_EVENT_NAME) EVENT_NAME, I.PARTY_TYPE_NAME, FOR_COMM_QUERY.GET_PARTY_CODE_NAME(A.PARTY_TYPE, A.PARTY_CODE) PARTY_CODE_NAME, A.ACCT_BOOK_TYPE, J.POSTPAID, A.ACCT_ID, A.BILL_ID, H.IS_CURRENCY, K.VOUCHER, K.SCRATCH_CARD_PWD, DECODE(SIGN(A.CHARGE), -1, A.CHARGE, NULL) IN_CHARGE, DECODE(SIGN(A.CHARGE), -1, NULL, A.CHARGE) OUT_CHARGE, A.PRE_SUTTLE_BAL + A.CHARGE BALANCE_AFTER, A2.ADJUST_REASON_NAME, A.ACCT_RES_ID, C.REF_ATTR FROM ACCT_BOOK A, RE_AB_INST B, RE_CC_INST C, SUBS_RE_EVENT D, SUBS_EVENT E, ACCT_BOOK_TYPE F, CONTACT_CHANNEL G, ACCT_RES H, PARTY_TYPE I, ACCT J, PAYMENT K, ADJUST A1, ADJUST_REASON A2, AB_EVENT_BENEFIT L, BAL_EVENT_INST M, BAL_EVENT N WHERE 1=1 AND A.ACCT_BOOK_ID = B.ACCT_BOOK_ID(+) AND B.EVENT_INST_ID = C.EVENT_INST_ID(+) AND A.ACCT_BOOK_ID = K.PAYMENT_ID(+) AND A.ACCT_BOOK_TYPE = F.ACCT_BOOK_TYPE AND A.CONTACT_CHANNEL_ID = G.CONTACT_CHANNEL_ID(+) AND C.RE_ID = D.RE_ID(+) AND D.SUBS_EVENT_ID = E.SUBS_EVENT_ID(+) AND A.ACCT_RES_ID = H.ACCT_RE S_ID AND A.PARTY_TYPE = I.PARTY_TYPE AND A.ACCT_ID = J.ACCT_ID AND A.ACCT_BOOK_ID = A1.ADJUST_ID(+) AND A1.ADJUST_REASON_ID = A2.ADJUST_REASON_ID(+) AND A.ACCT_BOOK_ID = L.ACCT_BOOK_ID(+) AND L.BAL_EVENT_INST_ID = M.BAL_EVENT_INST_ID(+) AND M.BAL_EVENT = N.BAL_EVENT(+) AND A.ACCT_BOOK_TYPE != 'Q' AND A.ACCT_ID = :1 AND A.CREATED_DATE >= TO_DATE(:2, 'YYYY-MM-DD HH24:MI:SS') AND A.CREATED_DATE <= TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS') AND A.ACCT_BOOK_TYPE NOT IN ('I') AND NVL(A.SP_ID, 0) = :4 UNION SELECT DISTINCT A.ACCT_BOOK_ID, A.CREATED_DATE, F.ACCT_BOOK_TYPE_NAME, A.PRE_BALANCE, A.PRE_EXP_DATE, A.CHARGE, H.ACCT_RES_NAME, A.PARTY_CODE, A.PRE_SUTTLE_BAL, A.SECONDS / 86400 DAYS, A.SECONDS, G.CONTACT_CHANNEL_NAME, DECODE(E.EVENT_NA ME, NULL, P.PRICE_NAME, E.EVENT_NAME) EVENT_NAME, I.PARTY_TYPE_NAME, FOR_COMM_QUERY.GET_PARTY_CODE_NAME(A.PARTY_TYPE, A.PARTY_CODE) PARTY_CODE_NAME, A.ACCT_BOOK_TYPE, J.POSTPAID, A.ACCT_ID, A.BILL_ID, H.IS_CURRENCY, K.VOUCHER, K.SCRATCH_CARD_PWD, DECODE(SIGN(A.CHARGE), -1, A.CHARGE, NULL) IN_CHARGE, DECODE(SIGN(A.CHARGE), -1, NULL, A.CHARGE) OUT_CHARGE, A.PRE_SUTTLE_BAL + A.CHARGE BALANCE_AFTER, '' AS ADJUST_REASON_NAME, A.ACCT_RES_ID, C.REF_ATTR FROM ACCT_BOOK A, RE_CC_INST C, SUBS_RE_EVENT D, SUBS_EVENT E, ACCT_BOOK_TYPE F, CONTACT_CHANNEL G, ACCT_RES H, PARTY_TYPE I, ACCT J, PAYMENT K, EVENT_CHARGE M, PRICE P WHERE A.ACCT_BOOK_ID = K.PAYMENT_ID(+) AND A.EVENT_INST_ID = C.EVENT_INST_ID(+) AND A.EVENT_INST_ID = M.EVENT_INST_ID(+) AND A.ACCT_BOOK_TYPE = F.ACCT_BOOK_TYPE AND A.CONTACT_CHANNEL_ID = G.CONTACT_CHANNEL_ID(+) AND C.RE_ID = D.RE_ID(+) AND D.SUBS_EVENT_ID = E.SUBS_EVENT_ID(+) AND M.PRICE_ID = P.PRICE_ID AND A.ACCT_RES_ID = H.ACCT_RES_ID AND A.PARTY_TYPE = I.PARTY_TYPE AND A.ACCT_ID = J.ACCT_ID AND A.ACCT_ID = :5 AND A.ACCT_BOOK_TYPE = 'Q' AND A.CREATED_DATE >= TO_DATE(:6, 'YYYY-MM-DD HH24:MI:SS') AND A.CREATED_DATE <= TO_DATE(:7, 'YYYY-MM-DD HH24:MI:SS') AND A.ACCT_BOOK_TYPE NOT IN ('I') AND NVL(A.SP_ID, 0) = :8 )
9h8tvw8wwvwjySELECT SUBS_UPP_ORDER_ID_SEQ.NEXTVAL FROM DUAL
9ndkt7x0zghtdSELECT A.VALUE, C.BLACKLIST_TYPE, C.FAILURE_COUNT FROM PROD_ATTR_VALUE A, ATTR B, (SELECT SUBS_ID, BLACKLIST_TYPE, STATE, STATE_DATE, FAILURE_COUNT, SP_ID, CASE BLACKLIST_TYPE WHEN 'A' THEN 'EXP_RECH_BLDATE' WHEN 'B' THEN 'EXP_CALL_BLDATE' WHEN 'C' THEN 'EXP_MGN_BLDATE' ELSE 'EXP_REFILL_ERROR' END ATTR_CODE FROM BLACKLIST_SUBS WHERE STATE='A' AND SUBS_ID=:1 AND BLACKLIST_TYPE IN ('A', 'B', 'C', 'D')) C WHERE B.ATTR_CODE IN ('EXP_RECH_BLDATE', 'EXP_CALL_BLDATE', 'EXP_MGN_BLDATE', 'EXP_REFILL_ERROR') AND A.ATTR_ID=B.ATTR_ID AND A.PROD_ID=C.SUBS_ID AND A.VALUE IS NOT NULL AND C.STATE = 'A' AND B.ATTR_CODE=C.ATTR_CODE AND A.PROD_ID=:2
aac27xy2wa8xmSELECT A.SUBS_ID, A.ACCT_ID, B.ROUTING_ID, B.ACCT_NBR, P.PROD_SPEC_ID, P.COMPLETED_DATE, P.PROD_STATE, P.BLOCK_REASON, A.PRICE_PLAN_ID, B.BILLING_CYCLE_TYPE_ID, B.SP_ID FROM SUBS A, PROD P, ACCT B WHERE A.SUBS_ID= P.PROD_ID AND A.ACCT_ID=B.ACCT_ID AND P.STATE = 'A' AND P.PROD_STATE NOT IN ('B', 'F') AND A.PREFIX = :1 AND A.ACC_NBR = :2
arubu9bzfvjkvSELECT PRICE_PLAN_ID FROM ACCT_PRICE_PLAN WHERE PRICE_PLAN_TYPE = '1'
atj60ptcuz6vuSELECT CUST_CONTACT_ID_SEQ.NEXTVAL FROM DUAL
b5sjhr002nvd3SELECT MIN(CHANGE_NOTIF_ID) MIN_CHANGE_NOTIF_ID, MAX(CHANGE_NOTIF_ID) MAX_CHANGE_NOTIF_ID, COUNT(1) COUNT, DECODE(UPPER(TABLE_NAME), 'ATTR', 1, 'ACCT', 2, 'SUBS', 3, 'SUBS_UPP_INST', 4, 'PROD', 5, 'PROD_ATTR_VALUE', 6, 'CUST', 7, 'SUBS_ACCT', 8, 'FELLOW_NBR', 9, 'SUBS_UPP_INST_VALUE', 10, 'SUBS_HOME_ZONE', 11, 'SUBS_HOME_CELL', 12, 'BUNDLE_SUBS_INST', 13, 'SUBS_RELA', 14, 'BAL_ACCT_ITEM_TYPE', 15, 'BAL_SHARE', 16, 'CUST_ATTR_VALUE', 17, 'ACCT_ATTR_VALUE', 18, 'NP_DB', 19, 'DEPOSIT_BAL', 20, 'CC_SUBS', 21, 'CC_ACCT', 22, 'SUBS_RELA_ATTR_VALUE', 23, 'SUBS_ACCNBR_RELA', 24, 0) TABLE_ID FROM CHANGE_NOTIF WHERE CHANGE_NOTIF_ID>:P_CHANGE_NOTIF_ID AND CREATED_DATE<=SYSDATE-:P_DELAY_SECOND/24/60/60 GROUP BY TABLE_NAME
c1cgc2w6pat1rINSERT INTO ACCT_BOOK(ACCT_BOOK_ID, ACCT_ID, ACCT_RES_ID, ACCT_BOOK_TYPE, CREATED_DATE, PRE_BALANCE, PRE_EXP_DATE, CHARGE, BILL_ID, PARTY_TYPE, PARTY_CODE, PRE_SUTTLE_BAL, SECONDS, BAL_ID, CONTACT_CHANNEL_ID, SP_ID, EVENT_INST_ID) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
cmjwh5agfc246INSERT INTO ACCT_BOOK(ACCT_BOOK_ID, ACCT_ID, ACCT_RES_ID, ACCT_BOOK_TYPE, CREATED_DATE, PRE_BALANCE, PRE_EXP_DATE, CHARGE, BILL_ID, PARTY_TYPE, PARTY_CODE, PRE_SUTTLE_BAL, SECONDS, BAL_ID, CONTACT_CHANNEL_ID, SP_ID) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
cmxtgu0a7bkdgselect /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("EVENT_PARAM"), count(distinct "EVENT_PARAM"), count("COMMENTS"), sum(sys_op_opnsize("COMMENTS")), count(distinct "EVENT_ID"), count("SUBS_ID"), count("ACC_NBR") from "CC"."CC_EVENT_HIS" t where TBL$OR$IDX$PART$NUM("CC"."CC_EVENT_HIS", 0, 4, 0, "ROWID") = :objn
dck0671qxub6dSELECT A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.CUST_ID, A.USER_ID, A.ACCT_ID, A.AGENT_ID, A.PRICE_PLAN_ID, A.AREA_ID, A.UPDATE_DATE, A.CREDIT_LIMIT, A.CREDIT_LIMIT_PLAN_ID, A.BONUS_AMOUNT, A.ROUTING_ID, A.DEF_LANG_ID, A.PPS_PWD, A.IMSI, A.SP_ID, B.CREATED_DATE, B.COMPLETED_DATE, B.PROD_STATE, B.STATE, B.STATE_DATE, B.UPDATE_DATE, B.PROD_STATE_DATE, B.BLOCK_REASON, B.PROD_EXP_DATE, B.INDEP_PROD_ID, B.PROD_SPEC_ID, B.OFFER_ID FROM SUBS A, PROD B WHERE A.SUBS_ID = B.PROD_ID AND A.PREFIX = :1 AND A.ACC_NBR = :2 ORDER BY B.COMPLETED_DATE DESC
dj3sxn9x3vqtyBEGIN DBMS_STATS.GATHER_SCHEMA_STATS (ownname=>'cc', estimate_percent=>10, method_opt=>'FOR ALL INDEXED COLUMNS', degree=>3, cascade=>true, options=>'GATHER AUTO'); END;
du2qvwh2ddry6select min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"CUST_CONTACT_ID" val, ntile(254) over (order by "CUST_CONTACT_ID") bkt from "CC"."CUST_CONTACT" t where TBL$OR$IDX$PART$NUM("CC"."CUST_CONTACT", 0, 4, 0, "ROWID") = :objn and "CUST_CONTACT_ID" is not null) group by val) group by maxbkt order by maxbkt
g6602vqpc615jselect min(minbkt), maxbkt, substrb(dump(min(val), 16, 0, 32), 1, 120) minval, substrb(dump(max(val), 16, 0, 32), 1, 120) maxval, sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val, min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */substrb("CONTACT_CONTENT", 1, 32) val, ntile(254) over (order by nlssort(substrb("CONTACT_CONTENT", 1, 32), 'NLS_SORT = binary')) bkt from "CC"."CUST_CONTACT" t where TBL$OR$IDX$PART$NUM("CC"."CUST_CONTACT", 0, 4, 0, "ROWID") = :objn and substrb("CONTACT_CONTENT", 1, 32) is not null) group by val) group by maxbkt order by maxbkt
gmgstyn706km7SELECT COUNT(1) VALUE FROM acct_book WHERE acct_id=:1 AND acct_book_type='P'
gw9sd12xq1qyhSELECT A.SUBS_ID, A.PREFIX, A.ACC_NBR, A.CUST_ID, A.USER_ID, A.ACCT_ID, A.AGENT_ID, A.PRICE_PLAN_ID, A.AREA_ID, A.UPDATE_DATE, A.CREDIT_LIMIT, A.CREDIT_LIMIT_PLAN_ID, A.BONUS_AMOUNT, A.ROUTING_ID, A.DEF_LANG_ID, A.SP_ID, A.PPS_PWD, A.IMSI, B.PROD_ID, B.CREATED_DATE, B.COMPLETED_DATE, B.PROD_STATE, B.PROD_STATE_DATE, B.UPDATE_DATE PROD_UPDATE_DATE, B.PROD_STATE_DATE, B.BLOCK_REASON, B.PROD_EXP_DATE, B.PROD_SPEC_ID, C.ACC_NBR_ID FROM SUBS A, PROD B, ACC_NBR C, INDEP_PROD_SPEC D WHERE A.SUBS_ID = B.PROD_ID AND A.PREFIX=C.PREFIX AND A.ACC_NBR=C.ACC_NBR AND B.PROD_STATE NOT IN ('B', 'F') AND B.PROD_SPEC_ID=D.INDEP_PROD_SPEC_ID AND A.SUBS_ID = :1 ORDER BY B.COMPLETED_DATE DESC

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 4,732,380 82.42 2.03
CPU used when call started 5,112,834 89.05 2.19
CR blocks created 768,058 13.38 0.33
Cached Commit SCN referenced 6,328,756 110.23 2.72
Commit SCN cached 760 0.01 0.00
DB time 28,376,653 494.23 12.18
DBWR checkpoint buffers written 7,788,023 135.64 3.34
DBWR checkpoints 20,440 0.36 0.01
DBWR object drop buffers written 57,347 1.00 0.02
DBWR parallel query checkpoint buffers written 5,521 0.10 0.00
DBWR tablespace checkpoint buffers written 145,441 2.53 0.06
DBWR thread checkpoint buffers written 1,544,791 26.91 0.66
DBWR transaction table writes 22,346 0.39 0.01
DBWR undo block writes 2,231,490 38.86 0.96
DFO trees parallelized 264 0.00 0.00
IMU CR rollbacks 165,212 2.88 0.07
IMU Flushes 1,282,058 22.33 0.55
IMU Redo allocation size 5,090,037,752 88,651.22 2,184.13
IMU commits 877,979 15.29 0.38
IMU contention 491,275 8.56 0.21
IMU ktichg flush 7 0.00 0.00
IMU pool not allocated 131,318 2.29 0.06
IMU recursive-transaction flush 2,440 0.04 0.00
IMU undo allocation size 9,171,291,376 159,732.83 3,935.39
IMU- failed to get a private strand 131,318 2.29 0.06
PX local messages recv'd 24,021,538 418.37 10.31
PX local messages sent 24,021,570 418.37 10.31
Parallel operations not downgraded 264 0.00 0.00
SMON posted for undo segment recovery 2 0.00 0.00
SMON posted for undo segment shrink 124 0.00 0.00
SQL*Net roundtrips to/from client 120,741,970 2,102.92 51.81
active txn count during cleanout 2,877,610 50.12 1.23
application wait time 5,906 0.10 0.00
background checkpoints completed 247 0.00 0.00
background checkpoints started 249 0.00 0.00
background timeouts 184,685 3.22 0.08
branch node splits 286 0.00 0.00
buffer is not pinned count 755,487,351 13,158.03 324.18
buffer is pinned count 855,076,683 14,892.54 366.91
bytes received via SQL*Net from client 12,352,360,991 215,136.29 5,300.38
bytes sent via SQL*Net to client ############### 3,986,423.26 98,214.76
calls to get snapshot scn: kcmgss 132,910,613 2,314.85 57.03
calls to kcmgas 6,637,967 115.61 2.85
calls to kcmgcs 544,917 9.49 0.23
change write time 42,327 0.74 0.02
cleanout - number of ktugct calls 2,444,069 42.57 1.05
cleanouts and rollbacks - consistent read gets 504,915 8.79 0.22
cleanouts only - consistent read gets 547,991 9.54 0.24
cluster key scan block gets 2,050,807 35.72 0.88
cluster key scans 1,295,347 22.56 0.56
commit batch/immediate performed 536,803 9.35 0.23
commit batch/immediate requested 536,803 9.35 0.23
commit cleanout failures: block lost 11 0.00 0.00
commit cleanout failures: buffer being written 102 0.00 0.00
commit cleanout failures: callback failure 17,643 0.31 0.01
commit cleanout failures: cannot pin 550,578 9.59 0.24
commit cleanouts 24,942,842 434.42 10.70
commit cleanouts successfully completed 24,374,508 424.52 10.46
commit immediate performed 536,803 9.35 0.23
commit immediate requested 536,803 9.35 0.23
commit txn count during cleanout 7,705,745 134.21 3.31
concurrency wait time 138,675 2.42 0.06
consistent changes 2,069,679 36.05 0.89
consistent gets 8,530,661,411 148,575.23 3,660.49
consistent gets - examination 311,013,816 5,416.81 133.46
consistent gets direct 92,571,940 1,612.29 39.72
consistent gets from cache 8,438,089,480 146,962.94 3,620.77
current blocks converted for CR 801 0.01 0.00
cursor authentications 51,683 0.90 0.02
data blocks consistent reads - undo records applied 1,801,980 31.38 0.77
db block changes 87,110,126 1,517.16 37.38
db block gets 110,431,813 1,923.35 47.39
db block gets direct 304,727 5.31 0.13
db block gets from cache 110,127,086 1,918.04 47.26
deferred (CURRENT) block cleanout applications 7,871,244 137.09 3.38
dirty buffers inspected 86,271 1.50 0.04
enqueue conversions 1,005,605 17.51 0.43
enqueue releases 25,004,263 435.49 10.73
enqueue requests 25,006,622 435.53 10.73
enqueue timeouts 2,350 0.04 0.00
enqueue waits 81,474 1.42 0.03
exchange deadlocks 848 0.01 0.00
execute count 65,427,633 1,139.53 28.07
failed probes on index block reclamation 60 0.00 0.00
free buffer inspected 17,146,092 298.63 7.36
free buffer requested 19,733,637 343.69 8.47
heap block compress 76,079 1.33 0.03
hot buffers moved to head of LRU 12,298,306 214.19 5.28
immediate (CR) block cleanout applications 1,052,906 18.34 0.45
immediate (CURRENT) block cleanout applications 2,831,078 49.31 1.21
index crx upgrade (found) 1,314 0.02 0.00
index crx upgrade (positioned) 5,877,142 102.36 2.52
index fast full scans (direct read) 3,190 0.06 0.00
index fast full scans (full) 24,610 0.43 0.01
index fast full scans (rowid ranges) 8,105 0.14 0.00
index fetch by key 77,180,975 1,344.23 33.12
index scans kdiixs1 128,576,890 2,239.37 55.17
leaf node 90-10 splits 30,883 0.54 0.01
leaf node splits 86,111 1.50 0.04
lob reads 12,889 0.22 0.01
lob writes 2,542 0.04 0.00
lob writes unaligned 2,542 0.04 0.00
logons cumulative 7,905 0.14 0.00
messages received 4,062,227 70.75 1.74
messages sent 4,062,227 70.75 1.74
no buffer to keep pinned count 58 0.00 0.00
no work - consistent read gets 8,144,087,388 141,842.42 3,494.62
opened cursors cumulative 7,971,906 138.84 3.42
parse count (failures) 1,016 0.02 0.00
parse count (hard) 1,843,417 32.11 0.79
parse count (total) 8,973,046 156.28 3.85
parse time cpu 46,667 0.81 0.02
parse time elapsed 346,955 6.04 0.15
physical read IO requests 14,787,310 257.54 6.35
physical read bytes ############### 9,804,160.86 241,548.18
physical read total IO requests 15,968,375 278.12 6.85
physical read total bytes ############### 18,671,557.18 460,017.00
physical read total multi block requests 4,851,168 84.49 2.08
physical reads 68,715,828 1,196.80 29.49
physical reads cache 16,312,799 284.11 7.00
physical reads cache prefetch 6,109,735 106.41 2.62
physical reads direct 52,403,029 912.68 22.49
physical reads direct (lob) 648 0.01 0.00
physical reads direct temporary tablespace 6,861,656 119.51 2.94
physical reads prefetch warmup 197,038 3.43 0.08
physical write IO requests 5,334,646 92.91 2.29
physical write bytes ############### 2,205,580.60 54,339.58
physical write total IO requests 10,967,479 191.02 4.71
physical write total bytes ############### 12,880,436.14 317,339.34
physical write total multi block requests 6,048,340 105.34 2.60
physical writes 15,458,569 269.24 6.63
physical writes direct 7,199,021 125.38 3.09
physical writes direct (lob) 97 0.00 0.00
physical writes direct temporary tablespace 6,994,143 121.81 3.00
physical writes from cache 8,259,548 143.85 3.54
physical writes non checkpoint 13,332,641 232.21 5.72
pinned buffers inspected 18,939 0.33 0.01
prefetch warmup blocks aged out before use 281,998 4.91 0.12
prefetched blocks aged out before use 336,488 5.86 0.14
process last non-idle time 50,964 0.89 0.02
queries parallelized 264 0.00 0.00
recursive calls 41,448,399 721.89 17.79
recursive cpu usage 507,238 8.83 0.22
redo blocks written 52,450,102 913.50 22.51
redo buffer allocation retries 2,300 0.04 0.00
redo entries 33,380,581 581.38 14.32
redo log space requests 2,910 0.05 0.00
redo log space wait time 42,500 0.74 0.02
redo ordering marks 1,766,186 30.76 0.76
redo size 25,344,784,468 441,420.30 10,875.41
redo subscn max counts 2,935,828 51.13 1.26
redo synch time 728,704 12.69 0.31
redo synch writes 2,581,105 44.95 1.11
redo wastage 657,680,232 11,454.56 282.21
redo write time 194,139 3.38 0.08
redo writer latching time 64 0.00 0.00
redo writes 2,567,823 44.72 1.10
rollback changes - undo records applied 843,848 14.70 0.36
rollbacks only - consistent read gets 255,124 4.44 0.11
rows fetched via callback 65,490,103 1,140.62 28.10
session connect time 0 0.00 0.00
session cursor cache hits 6,841,723 119.16 2.94
session logical reads 8,641,093,038 150,498.57 3,707.88
session pga memory 4,167,773,432 72,588.50 1,788.39
session pga memory max ############### 4,440,859.85 109,410.85
session uga memory ############### 16,918,721.59 416,831.84
session uga memory max 38,240,717,968 666,023.78 16,409.04
shared hash latch upgrades - no wait 9,131,199 159.03 3.92
shared hash latch upgrades - wait 4,538 0.08 0.00
sorts (disk) 117 0.00 0.00
sorts (memory) 9,085,534 158.24 3.90
sorts (rows) 1,135,345,392 19,773.87 487.18
sql area evicted 1,870,597 32.58 0.80
sql area purged 1,436 0.03 0.00
summed dirty queue length 1,092,447 19.03 0.47
switch current to new buffer 182,039 3.17 0.08
table fetch by rowid 696,020,408 12,122.32 298.66
table fetch continued row 1,330,875 23.18 0.57
table scan blocks gotten 7,504,435,945 130,701.86 3,220.14
table scan rows gotten ############### 10,388,398.28 255,942.22
table scans (cache partitions) 2,582 0.04 0.00
table scans (direct read) 41,742 0.73 0.02
table scans (long tables) 46,339 0.81 0.02
table scans (rowid ranges) 29,123 0.51 0.01
table scans (short tables) 16,969,897 295.56 7.28
total number of times SMON posted 1,988 0.03 0.00
transaction rollbacks 536,803 9.35 0.23
transaction tables consistent read rollbacks 410 0.01 0.00
transaction tables consistent reads - undo records applied 98,835 1.72 0.04
undo change vector size 11,369,408,296 198,016.58 4,878.60
user I/O wait time 12,956,247 225.65 5.56
user calls 124,926,444 2,175.80 53.61
user commits 1,802,716 31.40 0.77
user rollbacks 527,751 9.19 0.23
workarea executions - multipass 132 0.00 0.00
workarea executions - onepass 2,883 0.05 0.00
workarea executions - optimal 5,579,708 97.18 2.39
write clones created in background 2,039 0.04 0.00
write clones created in foreground 354 0.01 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 1,702 44,235
opened cursors current 3,112 18,010
logons current 83 352

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 249 15.61

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)
TAB_CC 8,545,520 149 16.69 6.40 1,232,090 21 36,452 8.13
IDX_CC 4,538,844 79 16.55 1.32 3,547,565 62 118,970 30.72
TEMP 1,531,266 27 3.34 5.07 262,608 5 181 2.27
UNDOTBS1 53,605 1 45.44 1.00 275,660 5 7,193 0.03
SYSTEM 92,873 2 7.80 1.21 5,087 0 223 5.11
SYSAUX 15,364 0 9.56 1.04 5,800 0 0 0.00
TAB_DEF 7,455 0 24.81 7.12 5,053 0 1,871 2.55
USERS 238 0 45.38 1.00 237 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)
IDX_CC /dev/rcc_data_03 150,942 3 7.67 1.17 61,499 1 2,343 1.84
IDX_CC /dev/rcc_data_06 546,232 10 15.02 1.34 421,886 7 11,495 26.32
IDX_CC /dev/rcc_data_07 542,957 9 15.19 1.34 400,966 7 9,323 27.83
IDX_CC /dev/rcc_data_21 585,929 10 15.22 1.31 449,021 8 13,179 22.29
IDX_CC /dev/rcc_data_22 566,532 10 15.23 1.35 446,481 8 11,979 32.69
IDX_CC /dev/rcc_data_23 576,163 10 15.88 1.33 410,021 7 11,316 34.70
IDX_CC /dev/rcc_data_24 628,627 11 15.51 1.33 454,416 8 13,443 35.54
IDX_CC /dev/rcc_data_25 459,090 8 21.93 1.32 446,957 8 18,933 40.20
IDX_CC /dev/rcc_data_26 467,652 8 22.62 1.31 444,740 8 23,051 33.10
IDX_CC /dev/rcc_data_27 9,059 0 28.93 1.00 7,568 0 3,332 1.69
IDX_CC /dev/rcc_data_28 5,661 0 28.76 1.00 4,010 0 576 5.87
SYSAUX /dev/rcc_sysaux_01 13,120 0 8.99 1.04 4,526 0 0 0.00
SYSAUX /dev/rcc_sysaux_02 2,244 0 12.93 1.04 1,274 0 0 0.00
SYSTEM /dev/rcc_system_01 92,873 2 7.80 1.21 5,087 0 223 5.11
TAB_CC /dev/rcc_data_01 275,034 5 8.91 5.47 30,009 1 1,420 5.19
TAB_CC /dev/rcc_data_02 280,864 5 9.33 5.56 28,122 0 1,408 3.97
TAB_CC /dev/rcc_data_04 213,224 4 11.94 6.82 23,317 0 1,603 4.17
TAB_CC /dev/rcc_data_05 187,833 3 12.94 7.19 48,457 1 1,404 3.85
TAB_CC /dev/rcc_data_08 610,527 11 16.49 6.17 137,454 2 3,394 5.30
TAB_CC /dev/rcc_data_09 557,491 10 18.16 6.28 109,721 2 4,165 3.84
TAB_CC /dev/rcc_data_10 467,776 8 19.04 6.97 79,228 1 2,808 4.53
TAB_CC /dev/rcc_data_11 462,428 8 18.99 7.03 85,001 1 3,072 8.35
TAB_CC /dev/rcc_data_12 576,782 10 17.56 6.17 78,444 1 3,533 5.79
TAB_CC /dev/rcc_data_13 626,563 11 16.76 6.27 58,888 1 2,946 5.92
TAB_CC /dev/rcc_data_14 579,235 10 17.82 6.71 77,929 1 1,202 10.43
TAB_CC /dev/rcc_data_15 591,519 10 17.75 6.35 83,005 1 1,488 17.22
TAB_CC /dev/rcc_data_16 579,134 10 18.70 6.80 46,991 1 1,921 8.77
TAB_CC /dev/rcc_data_17 646,243 11 16.77 6.26 102,527 2 1,530 26.35
TAB_CC /dev/rcc_data_18 653,422 11 16.38 6.15 81,510 1 1,495 17.44
TAB_CC /dev/rcc_data_19 606,694 11 17.41 6.51 67,201 1 1,231 15.66
TAB_CC /dev/rcc_data_20 630,751 11 16.43 6.33 94,286 2 1,832 11.07
TAB_DEF /dev/rcc_def_01 2,975 0 23.34 6.29 4,526 0 780 2.45
TAB_DEF /dev/rcc_def_02 2,335 0 25.63 7.25 257 0 649 2.45
TAB_DEF /dev/rcc_def_03 2,145 0 25.95 8.14 270 0 442 2.90
TEMP /dev/rcc_temp_01 1,390,539 24 2.34 3.91 207,634 4 0  
TEMP /dev/rcc_temp_02 140,727 2 13.23 16.48 54,974 1 181 2.27
UNDOTBS1 /dev/rcc_undotbs1_01 22,439 0 26.66 1.00 88,588 2 3,760 0.04
UNDOTBS1 /dev/rcc_undotbs1_02 31,166 1 58.95 1.00 187,072 3 3,433 0.03
USERS /dev/rcc_users_01 238 0 45.38 1.00 237 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 1,110,409 100 8,545,038,548 16,311,801 8,259,529 0 0 165,071


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 35 53832 180214 1638540 1638540    
E 0 23 25322 114857 638454 1638540 638454  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 896 0.10 110,824 4.32 73,660,222
D 1,792 0.20 221,648 2.56 43,648,303
D 2,688 0.30 332,472 2.09 35,559,692
D 3,584 0.40 443,296 1.81 30,817,046
D 4,480 0.50 554,120 1.61 27,400,332
D 5,376 0.60 664,944 1.44 24,609,031
D 6,272 0.70 775,768 1.31 22,324,929
D 7,168 0.80 886,592 1.18 20,188,171
D 8,064 0.90 997,416 1.09 18,523,782
D 8,960 1.00 1,108,240 1.00 17,100,518
D 8,992 1.00 1,112,198 1.00 17,046,131
D 9,856 1.10 1,219,064 0.93 15,851,681
D 10,752 1.20 1,329,888 0.87 14,866,399
D 11,648 1.30 1,440,712 0.83 14,183,802
D 12,544 1.40 1,551,536 0.80 13,655,219
D 13,440 1.49 1,662,360 0.77 13,176,429
D 14,336 1.59 1,773,184 0.75 12,702,690
D 15,232 1.69 1,884,008 0.73 12,379,138
D 16,128 1.79 1,994,832 0.71 12,117,718
D 17,024 1.89 2,105,656 0.70 11,868,051
D 17,920 1.99 2,216,480 0.68 11,624,142

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
54.26 173,426 146,179

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 2,048 1,742 227.00 0.00 0.00 0.00 0.00 209,710
E 2,048 1,197 1,037.74 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 5,537,741 5,537,741 0 0
64K 128K 1,127 1,127 0 0
128K 256K 2,083 2,083 0 0
256K 512K 607 607 0 0
512K 1024K 32,848 32,848 0 0
1M 2M 2,539 2,539 0 0
2M 4M 822 794 28 0
4M 8M 1,825 714 1,111 0
8M 16M 462 285 177 0
16M 32M 862 361 501 0
32M 64M 977 252 687 38
64M 128M 370 6 316 48
128M 256M 110 16 52 42
256M 512M 7 0 3 4
512M 1024M 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
256 0.13 160,779.76 211,866.36 43.00 283
512 0.25 160,779.76 205,220.13 44.00 244
1,024 0.50 160,779.76 67,553.93 70.00 0
1,536 0.75 160,779.76 65,187.87 71.00 0
2,048 1.00 160,779.76 53,218.52 75.00 0
2,458 1.20 160,779.76 11,834.53 93.00 0
2,867 1.40 160,779.76 9,657.17 94.00 0
3,277 1.60 160,779.76 6,219.03 96.00 0
3,686 1.80 160,779.76 4,499.75 97.00 0
4,096 2.00 160,779.76 4,499.75 97.00 0
6,144 3.00 160,779.76 1,419.50 99.00 0
8,192 4.00 160,779.76 1,419.50 99.00 0
12,288 6.00 160,779.76 1,419.50 99.00 0
16,384 8.00 160,779.76 1,419.50 99.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
416 0.35 150 13,883 4,632,774 0.95 238,278 62.20 38,088,841
544 0.46 276 22,447 4,684,490 0.96 186,562 48.70 38,135,631
672 0.57 403 31,150 4,760,048 0.98 111,004 28.98 38,148,560
800 0.68 530 39,760 4,788,642 0.98 82,410 21.51 38,157,322
928 0.78 657 48,421 4,812,141 0.99 58,911 15.38 38,164,278
1,056 0.89 784 57,103 4,827,665 0.99 43,387 11.33 38,169,237
1,184 1.00 911 65,814 4,867,221 1.00 3,831 1.00 38,172,821
1,312 1.11 1,038 74,472 4,885,090 1.00 1 0.00 38,175,665
1,440 1.22 1,165 83,120 4,893,135 1.01 1 0.00 38,177,521
1,568 1.32 1,292 91,677 4,906,928 1.01 1 0.00 38,180,245
1,696 1.43 1,417 100,224 4,912,308 1.01 1 0.00 38,182,390
1,824 1.54 1,544 108,836 4,925,473 1.01 1 0.00 38,185,795
1,952 1.65 1,668 117,212 4,931,962 1.01 1 0.00 38,187,894
2,080 1.76 1,795 125,785 4,941,887 1.02 1 0.00 38,189,685
2,208 1.86 1,922 134,563 4,957,061 1.02 1 0.00 38,192,303
2,336 1.97 2,049 143,202 4,959,486 1.02 1 0.00 38,193,090
2,464 2.08 2,176 151,790 4,962,206 1.02 1 0.00 38,193,823

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,560 0.25 647,119 43,653,771
5,120 0.50 379,572 30,820,343
7,680 0.75 277,315 22,327,233
10,240 1.00 213,746 17,047,593
12,800 1.25 179,270 14,185,302
15,360 1.50 161,444 12,703,866
17,920 1.75 151,398 11,868,534
20,480 2.00 148,448 11,624,754

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)
data block 154,237 3,950 26
segment header 2,683 10 4
extent map 169 1 4
1st level bmb 617 0 0
undo header 4,723 0 0
2nd level bmb 40 0 3
undo block 2,468 0 0
file header block 2 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 (index contention) 47,506 47,506 0 18,290 856 46.78
TX-Transaction (row lock contention) 44,002 43,996 6 43,899 30 0.68
TC-Tablespace Checkpoint 3 3 0 1 16 15,964.00
KO-Multiple Object Checkpoint (fast object checkpoint) 179,118 179,118 0 17,319 13 0.78
TM-DML 17,724,930 17,724,887 25 52 10 185.12
SQ-Sequence Cache 154,714 154,714 0 1,234 9 7.16
RO-Multiple Object Reuse (fast object reuse) 2,592 2,592 0 288 7 25.94
CF-Controlfile Transaction 38,271 38,261 10 92 2 26.46
UL-User-defined 38 38 0 1 0 74.00
PS-PX Process Reservation 22,378 20,135 2,242 244 0 0.14
TX-Transaction (allocate ITL entry) 1,395 1,395 0 9 0 3.11
TX-Transaction 2,990,528 2,990,796 0 5 0 2.40
HW-Segment High Water Mark 20,667 20,667 0 2 0 2.00
FB-Format Block 12,133 12,133 0 5 0 0.20
US-Undo Segment 5,658 5,658 0 3 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 2,224.53 3,002,817 23,535 119 290.983333333333333333333333333333333333/1298.7 0/0 0/0/0/11/92288/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
27-Mar 19:03 5,303 25,340 136 20 1,299 0/0 0/0/0/0/0/0
27-Mar 18:53 4,957 23,833 78 15 1,288 0/0 0/0/0/0/0/0
27-Mar 18:43 4,807 23,274 149 17 1,278 0/0 0/0/0/0/0/0
27-Mar 18:33 4,825 23,072 78 18 1,267 0/0 0/0/0/0/0/0
27-Mar 18:23 4,727 22,827 137 24 1,256 0/0 0/0/0/0/0/0
27-Mar 18:13 4,655 21,980 690 22 1,245 0/0 0/0/0/0/0/0
27-Mar 18:03 4,584 21,904 32 16 1,234 0/0 0/0/0/0/0/0
27-Mar 17:53 4,407 21,231 139 17 1,223 0/0 0/0/0/0/0/0
27-Mar 17:43 4,410 21,232 66 20 1,212 0/0 0/0/0/0/0/0
27-Mar 17:33 4,424 20,972 74 16 1,201 0/0 0/0/0/0/0/0
27-Mar 17:23 4,385 21,547 130 17 1,190 0/0 0/0/0/0/0/0
27-Mar 17:13 4,290 20,652 1,053 12 1,178 0/0 0/0/0/0/0/0
27-Mar 17:03 4,263 20,512 453 13 1,167 0/0 0/0/0/0/0/0
27-Mar 16:53 4,223 20,056 102 15 1,155 0/0 0/0/0/0/0/0
27-Mar 16:43 4,207 20,386 116 15 1,144 0/0 0/0/0/0/0/0
27-Mar 16:33 4,302 20,294 43 12 1,132 0/0 0/0/0/0/0/0
27-Mar 16:23 3,947 19,441 5 12 1,121 0/0 0/0/0/0/0/0
27-Mar 16:13 4,036 19,317 55 13 1,109 0/0 0/0/0/0/0/0
27-Mar 16:03 4,083 19,200 150 13 1,097 0/0 0/0/0/0/0/0
27-Mar 15:53 4,121 19,598 116 12 1,085 0/0 0/0/0/0/0/0
27-Mar 15:43 4,143 19,783 66 16 1,073 0/0 0/0/0/0/0/0
27-Mar 15:33 3,846 18,504 490 13 1,061 0/0 0/0/0/0/0/0
27-Mar 15:23 4,032 19,490 40 14 1,049 0/0 0/0/0/0/0/0
27-Mar 15:13 3,970 18,797 10 14 1,037 0/0 0/0/0/0/0/0
27-Mar 15:03 3,956 18,872 240 16 1,025 0/0 0/0/0/0/0/0
27-Mar 14:53 4,013 19,357 51 17 1,013 0/0 0/0/0/0/0/0
27-Mar 14:43 3,878 18,121 67 15 1,001 0/0 0/0/0/0/0/0
27-Mar 14:33 4,022 19,126 33 16 988 0/0 0/0/0/0/0/0
27-Mar 14:23 4,095 19,594 140 14 976 0/0 0/0/0/0/0/0
27-Mar 14:13 4,187 20,215 70 13 964 0/0 0/0/0/0/0/0
27-Mar 14:03 4,103 18,943 74 13 951 0/0 0/0/0/0/0/0
27-Mar 13:53 4,247 20,766 142 14 939 0/0 0/0/0/0/0/0
27-Mar 13:43 4,525 22,568 90 18 927 0/0 0/0/0/0/0/0
27-Mar 13:33 4,272 20,350 37 13 914 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
ASM db client latch 83,972 0.00   0 0  
AWR Alerted Metric Element list 519,108 0.00   0 0  
Consistent RBA 2,567,855 0.00 0.02 0 0  
FAL request queue 1,644 0.00   0 0  
FAL subheap alocation 1,644 0.00   0 0  
FIB s.o chain latch 6,582 0.00   0 0  
FOB s.o list latch 26,287 0.49 0.00 0 0  
In memory undo latch 25,808,665 0.08 0.73 1 2,307,089 0.00
JS mem alloc latch 121 0.00   0 0  
JS queue access latch 121 0.00   0 0  
JS queue state obj latch 415,010 0.00   0 0  
JS slv state obj latch 1,828 0.00   0 0  
KMG MMAN ready and startup request latch 20,285 0.00   0 0  
KMG resize request state object freelist 200 0.00   0 0  
KTF sga latch 133 0.00   0 19,169 0.00
KWQMN job cache list latch 23 0.00   0 0  
KWQP Prop Status 10 0.00   0 0  
MQL Tracking Latch 0     0 1,148 0.00
Memory Management Latch 2,826 0.28 1.00 0 20,239 0.00
Memory Queue Message Subscriber #1 14 0.00   0 0  
Memory Queue Message Subscriber #2 2 0.00   0 0  
Memory Queue Message Subscriber #3 2 0.00   0 0  
Memory Queue Message Subscriber #4 2 0.00   0 0  
Memory Queue Subscriber 17 0.00   0 0  
NLS data objects 2 0.00   0 0  
OS process 8,937 0.00   0 0  
OS process allocation 25,368 0.02 0.00 0 0  
OS process: request allocation 5,102 0.06 0.00 0 0  
PL/SQL warning settings 35,071 0.00   0 0  
QMT 1 0.00   0 0  
SGA IO buffer pool latch 406,283 0.13 0.07 0 409,508 0.11
SQL memory manager latch 17 0.00   0 19,071 0.00
SQL memory manager workarea list latch 4,901,587 0.00 0.00 0 0  
STREAMS LCR 2 0.00   0 0  
STREAMS Pool Advisor 3 0.00   0 3 0.00
Shared B-Tree 2,078 0.00   0 0  
Streams Generic 2 0.00   0 0  
X$KSFQP 265 0.00   0 0  
active checkpoint queue latch 1,625,111 0.01 0.02 0 0  
active service list 154,414 1.32 0.03 0 19,142 0.00
archive control 3,196 0.00   0 0  
archive process latch 22,891 0.00   0 0  
begin backup scn array 29,896 0.00   0 0  
buffer pool 3,879 0.00   0 0  
bufq statistics 9 0.00   0 0  
cache buffer handles 433,335 0.04 0.00 0 0  
cache buffers chains 17,085,361,305 0.69 0.00 4 33,013,930 0.00
cache buffers lru chain 18,070,041 0.11 0.02 0 32,333,095 0.19
cache table scan latch 0     0 592,597 0.26
channel handle pool latch 8,986 0.23 0.00 0 0  
channel operations parent latch 614,088 0.01 0.04 0 0  
checkpoint queue latch 33,593,277 0.01 0.01 0 8,125,573 0.01
client/application info 60,001 0.00 0.00 0 0  
commit callback allocation 312 0.00   0 0  
compile environment latch 7,917 0.00   0 0  
datapump attach fixed tables latch 4 0.00   0 0  
datapump job fixed tables latch 5 0.00   0 0  
device information 70 0.00   0 0  
dictionary lookup 449 0.00   0 0  
dml lock allocation 35,169,656 0.16 0.00 0 0  
dummy allocation 15,605 5.13 0.00 0 0  
enqueue hash chains 51,115,683 0.05 0.00 0 50,326 0.00
enqueue sob latch 4 0.00   0 0  
enqueues 12,815,853 0.54 0.01 0 0  
error message lists 10,316 3.61 0.00 0 0  
event group latch 2,685 0.00   0 0  
event range base latch 37 0.00   0 0  
file cache latch 13,913 0.00   0 0  
file number translation table 2 0.00   0 0  
global KZLD latch for mem in SGA 1,832 0.00   0 0  
global tx hash mapping 1,673,534 0.00 0.00 0 0  
hash table column usage latch 15,178 0.23 0.00 0 6,144,704 0.00
hash table modification latch 1,395 0.00   0 0  
image handles of buffered messages latch 14 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 452 0.00
job_queue_processes free list latch 1 0.00   0 0  
job_queue_processes parameter latch 1,087 0.00   0 0  
kks stats 11,436,573 0.05 0.04 1 0  
kmcptab latch 3 0.00   0 0  
kmcpvec latch 0     0 3 0.00
kokc descriptor allocation latch 174,460 0.00   0 0  
krbmrosl 2,950 0.00   0 0  
ksuosstats global area 3,860 0.00   0 0  
ktm global data 2,294 0.00   0 0  
kupp process latch 5 0.00   0 1 0.00
kwqbsgn:msghdr 30 0.00   0 0  
kwqbsn:qsga 2,066 0.00   0 2 50.00
kwqbsn:qxl 34 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 2,584,054 0.15 0.00 0 0  
library cache 141,291,735 0.15 0.03 38 7,780,969 9.21
library cache load lock 257,814 0.00 0.00 0 390 0.00
library cache lock 53,938,883 0.02 0.00 0 89 0.00
library cache lock allocation 1,517,079 0.00 0.00 0 0  
library cache pin 49,810,614 0.01 0.00 0 0  
library cache pin allocation 1,122,400 0.00 0.00 0 0  
list of block allocation 356,806 0.00 0.00 0 0  
loader state object freelist 95,226 0.05 0.00 0 0  
logminer context allocation 2 0.00   0 0  
longop free list parent 7,250 0.00   0 71,682 0.00
message pool operations parent latch 64,368 0.00   0 0  
messages 11,497,884 0.02 0.00 0 0  
mostly latch-free SCN 2,583,427 0.36 0.00 0 0  
multiblock read objects 1,786,748 0.03 0.03 0 0  
ncodef allocation latch 917 0.00   0 0  
object queue header heap 6,075,787 0.00 0.00 0 61,625 0.01
object queue header operation 68,547,569 0.03 0.01 0 194,428 0.16
object stats modification 21,592 0.00   0 0  
parallel query alloc buffer 249,808 5.12 0.00 0 0  
parallel query stats 5,818 12.24 0.00 0 0  
parameter list 6,000 0.00   0 0  
parameter table allocation management 8,378 21.51 0.09 0 0  
pass worker exception to master 2 0.00   0 0  
post/wait queue 3,846,436 0.01 0.01 0 2,569,937 0.02
process allocation 5,366 0.07 0.75 0 2,684 0.04
process group creation 5,102 0.06 0.00 0 0  
process queue 159,310 0.69 0.00 0 0  
process queue reference 1,225,042,023 0.01 0.00 0 27,828,214 106.88
qm_init_sga 1 0.00   0 0  
qmn state object latch 2 0.00   0 0  
qmn task queue latch 9,569 0.01 0.00 0 0  
query server freelists 148,928 10.34 0.00 0 0  
query server process 32 0.00   0 32 0.00
queue sender's info. latch 22 0.00   0 0  
redo allocation 12,353,033 0.04 0.01 0 33,356,468 0.17
redo copy 32 0.00   0 33,380,468 0.08
redo writing 9,317,239 0.01 0.00 0 0  
resmgr group change latch 13,844 0.00   0 0  
resmgr:active threads 15,551 0.00   0 0  
resmgr:actses change group 7,656 0.00   0 0  
resmgr:free threads list 15,535 8.98 0.00 0 0  
resmgr:schema config 16 0.00   0 0  
resumable state object 2 0.00   0 0  
row cache objects 157,900,669 0.19 0.00 0 184,129 0.51
rules engine aggregate statistics 12 0.00   0 0  
rules engine evaluation context statistics 2 0.00   0 0  
rules engine rule set statistics 241 0.00   0 0  
rules engine rule statistics 8 0.00   0 0  
sequence cache 9,507,146 0.05 0.00 0 0  
session allocation 39,071,571 0.14 0.01 0 0  
session idle bit 254,158,994 0.01 0.01 0 0  
session state list latch 15,642 5.67 0.00 0 0  
session switching 917 0.00   0 0  
session timer 19,143 0.00   0 0  
shared pool 92,780,159 0.33 0.09 43 0  
shared pool sim alloc 11,190 0.02 0.00 0 0  
shared pool simulator 124,639,945 0.01 0.08 5 0  
shrink stat allocation latch 1,406,060 0.00   0 0  
simulator hash latch 540,022,595 0.00 0.00 1 0  
simulator lru latch 8,280,473 0.36 0.00 0 530,196,686 1.19
slave class 35 0.00   0 0  
slave class create 140 11.43 1.00 0 0  
sort extent pool 53,136 0.05 0.00 0 0  
spilled messages latch 10 0.00   0 0  
state object free list 32 0.00   0 0  
statistics aggregation 8,960 0.00   0 0  
temp lob duration state obj allocation 32 0.00   0 0  
temporary table state object allocation 758 5.28 0.00 0 0  
threshold alerts latch 2,816 0.00   0 0  
trace latch 302 0.00   0 0  
transaction allocation 220,738 0.00   0 0  
transaction branch allocation 1,638,788 0.39 0.00 0 0  
undo global data 25,829,418 0.02 0.01 0 124 0.00
user lock 7,412 0.31 0.26 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 17,085,361,305 117,828,213 67,119 117,762,969 0 0 0
shared pool 92,780,159 308,512 28,823 281,495 0 0 0
row cache objects 157,900,669 293,403 188 293,216 0 0 0
library cache 141,291,735 212,885 5,987 207,625 0 0 0
process queue reference 1,225,042,023 101,176 374 100,802 0 0 0
enqueues 12,815,853 68,829 659 68,196 0 0 0
dml lock allocation 35,169,656 56,481 83 56,399 0 0 0
session allocation 39,071,571 53,074 573 52,515 0 0 0
session idle bit 254,158,994 31,273 258 31,019 0 0 0
simulator lru latch 8,280,473 29,854 140 29,716 0 0 0
enqueue hash chains 51,115,683 26,796 119 26,685 0 0 0
In memory undo latch 25,808,665 21,327 15,616 5,755 0 0 0
cache buffers lru chain 18,070,041 19,289 299 18,990 0 0 0
simulator hash latch 540,022,595 18,660 62 18,600 0 0 0
object queue header operation 68,547,569 17,233 226 17,008 0 0 0
query server freelists 148,928 15,393 38 15,355 0 0 0
parallel query alloc buffer 249,808 12,781 40 12,741 0 0 0
library cache lock 53,938,883 12,271 26 12,245 0 0 0
mostly latch-free SCN 2,583,427 9,402 15 9,387 0 0 0
shared pool simulator 124,639,945 9,047 752 8,300 0 0 0
transaction branch allocation 1,638,788 6,433 29 6,404 0 0 0
library cache pin 49,810,614 5,630 14 5,616 0 0 0
undo global data 25,829,418 5,549 62 5,487 0 0 0
redo allocation 12,353,033 5,337 60 5,277 0 0 0
kks stats 11,436,573 5,292 208 5,093 0 0 0
sequence cache 9,507,146 4,544 4 4,540 0 0 0
lgwr LWN SCN 2,584,054 3,933 3 3,930 0 0 0
messages 11,497,884 2,199 4 2,195 0 0 0
active service list 154,414 2,044 54 1,990 0 0 0
checkpoint queue latch 33,593,277 1,981 11 1,970 0 0 0
parameter table allocation management 8,378 1,802 169 1,633 0 0 0
resmgr:free threads list 15,535 1,395 2 1,393 0 0 0
process queue 159,310 1,107 1 1,106 0 0 0
session state list latch 15,642 887 3 884 0 0 0
redo writing 9,317,239 726 3 723 0 0 0
parallel query stats 5,818 712 1 711 0 0 0
SGA IO buffer pool latch 406,283 534 38 496 0 0 0
multiblock read objects 1,786,748 456 13 444 0 0 0
post/wait queue 3,846,436 447 3 444 0 0 0
active checkpoint queue latch 1,625,111 126 3 123 0 0 0
Consistent RBA 2,567,855 98 2 96 0 0 0
channel operations parent latch 614,088 53 2 51 0 0 0
user lock 7,412 23 6 17 0 0 0
slave class create 140 16 16 0 0 0 0
Memory Management Latch 2,826 8 8 0 0 0 0
process allocation 5,366 4 3 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 16,666 3,732
In memory undo latch kticmt: child 0 1,240 831
In memory undo latch ktichg: child 0 141 12,780
In memory undo latch kturbk 0 5 676
In memory undo latch ktbgfc 0 1 42
Memory Management Latch kmgs_perform_parameter_updates1 0 8 8
SGA IO buffer pool latch ksfd_free_sgabuffer 0 23 38
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 15 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 3 0
active service list ksws_event: ksws event 0 245 251
active service list kswsgsnp: get service name ptr 0 17 11
cache buffers chains kcbgtcr: kslbegin excl 0 76,690 52,460
cache buffers chains kcbrls: kslbegin 0 14,886 38,631
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 4,200 3,488
cache buffers chains kcbget: pin buffer 0 860 299
cache buffers chains kcbgtcr: fast path 0 370 141
cache buffers chains kcbgcur: kslbegin 0 332 143
cache buffers chains kcbgtcr: kslbegin shared 0 111 51
cache buffers chains kcbzwb 0 82 67
cache buffers chains kcbnlc 0 32 214
cache buffers chains kcbzgb: scan from tail. nowait 0 27 0
cache buffers chains kcbchg: kslbegin: call CR func 0 20 1,629
cache buffers chains kcbget: exchange 0 15 13
cache buffers chains kcbget: exchange rls 0 15 11
cache buffers chains kcbnew: new latch again 0 10 0
cache buffers chains kcbzib: multi-block read: nowait 0 6 0
cache buffers chains kcbcge 0 3 239
cache buffers chains kcb_is_private 0 2 133
cache buffers chains kcbbic1 0 1 2
cache buffers chains kcbbxsv 0 1 0
cache buffers chains kcbw_examine_granule 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 2
cache buffers lru chain kcbzgws 0 279 0
cache buffers lru chain kcbw_activate_granule 0 10 0
cache buffers lru chain kcbbwlru 0 3 6
cache buffers lru chain kcbbxsv: move to being written 0 2 163
cache buffers lru chain kcbw_make_free_nowait 0 2 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
cache buffers lru chain kcbzib 0 1 0
cache buffers lru chain kcbzswcu 0 1 0
channel operations parent latch ksrchdelete() 0 2 2
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 10 0
checkpoint queue latch kcbk_get_cqlt_nowait2 0 1 0
cost function kzulgt: find user res 0 6 6
dml lock allocation ktaiam 0 43 68
dml lock allocation ktaidm 0 40 15
enqueue hash chains ksqrcl 0 55 41
enqueue hash chains ksqgtl3 0 48 73
enqueue hash chains ksqcnl 0 16 5
enqueues ksqdel 0 355 169
enqueues ksqgel: create enqueue 0 288 457
enqueues ksqies 0 16 33
kks stats kks stats alloc/free 0 208 208
lgwr LWN SCN kcs023 0 7 0
library cache kglobpn: child: 0 1,421 859
library cache kglpndl: child: after processing 0 685 52
library cache kgldti: 2child 0 267 169
library cache kglukp: child 0 221 387
library cache kglhdgn: child: 0 177 1,085
library cache kglhdgc: child: 0 120 19
library cache kgldte: child 0 0 92 341
library cache kglpndl: child: before processing 0 71 334
library cache kglLockCursor 0 46 63
library cache kglpin 0 44 217
library cache kglScanDependency 0 26 0
library cache kglobld 0 17 48
library cache kglpnp: child 0 10 181
library cache kglhdiv: child 0 4 0
library cache kglati 0 3 0
library cache kglget: unpin heap 0 0 3 7
library cache kglic 0 2 1
library cache kglivl: child 0 1 0
library cache lock kgllkdl: child: no lock handle 0 197 196
library cache lock kgllkdl: child: cleanup 0 16 14
library cache lock kgllkal: child: multiinstance 0 10 13
library cache pin kglpndl 0 9 4
library cache pin kglpnal: child: alloc space 0 4 10
library cache pin kglpnp: child 0 1 1
messages ksarcv 0 2 1
messages ksaamb: after wakeup 0 1 2
messages ksarcv: after wait 0 1 1
mostly latch-free SCN kcslcu3 0 8 18
mostly latch-free SCN kcs024 0 3 0
mostly latch-free SCN kcs01 0 1 2
mostly latch-free SCN kcsnew_scn_rba 0 1 0
multiblock read objects kcbzib: mbr get 0 7 2
multiblock read objects kcbzib: normal mbr free 0 6 11
object queue header operation kcbw_unlink_q 0 89 42
object queue header operation kcbw_link_q 0 56 23
object queue header operation kcbo_switch_cq 0 49 92
object queue header operation kcbo_switch_mq_bg 0 33 64
object queue header operation kcbo_write_q 0 26 0
object queue header operation kcbo_switch_q_bg 0 12 10
object queue header operation kcbo_swap_buf_bg 0 11 56
object queue header operation kcbo_service_ockpt 0 6 0
object queue header operation kcbw_make_free_nowait 0 4 0
object queue header operation kcbo_ivbo 0 1 0
parallel query alloc buffer kxfpbfre 0 40 33
parallel query stats kxfprst: KSLBEGIN:1 0 1 1
parameter table allocation management ksp_param_table_free 0 169 169
post/wait queue ksliwat:add:wait 0 3 0
process allocation ksucrp 0 3 0
process queue kxfpqsnd: KSLBEGIN 0 1 0
process queue reference kxfpqrsnd 0 374 0
query server freelists kxfpobrmf 0 38 38
redo allocation kcrfw_redo_gen: redo allocation 1 0 60 0
redo writing kcrfw_post: rba scn pair 0 3 0
resmgr:free threads list kgskthrcreate 0 2 2
row cache objects kqreqd: reget 0 132 5
row cache objects kqrpre: find obj 0 33 158
row cache objects kqreqd 0 12 17
row cache objects kqrso 0 4 1
row cache objects kqrsrd 0 1 3
sequence cache kdnnxt: cached seq 0 3 0
sequence cache kdnssd 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 237 291
session allocation ksursi 0 126 176
session allocation kxfpqidqr 0 66 21
session allocation kxfprdp 0 59 5
session allocation ksuprc 0 18 12
session allocation ksuxds: not user session 0 18 30
session allocation ksufap: active sessions 0 15 0
session allocation ksucri 0 10 22
session allocation ksudlc 0 9 13
session allocation kspallmod 0 8 0
session allocation ksusin 0 7 3
session idle bit ksupuc: set busy 0 219 130
session idle bit ksupuc: clear busy 0 134 230
session idle bit ksuxds 0 15 8
session state list latch kpseqd 0 3 0
shared pool kghalo 0 15,216 12,321
shared pool kghfrunp: alloc: wait 0 4,910 342
shared pool kghfrunp: alloc: session dur 0 3,607 715
shared pool kghupr1 0 2,564 7,536
shared pool kghfrunp: clatch: wait 0 1,536 2,033
shared pool kghfrunp: clatch: nowait 0 1,046 0
shared pool kghalp 0 757 5,144
shared pool kgh_next_free 0 741 122
shared pool kghfre 0 624 1,934
shared pool kghasp 0 155 679
shared pool kgh: add extent to quiesced list 0 114 22
shared pool kgh: quiesce extents 0 51 0
shared pool kghfrunp: alloc: cursor dur 0 47 1
shared pool kgh: sim resz update 0 23 0
shared pool kghfrunp 0 14 3
shared pool kghquiesce: clatch: nowait 0 4 0
shared pool simulator kglsim_unpin_simhp 0 605 12
shared pool simulator kglsim_unpin_simhp: fast path 0 96 675
shared pool simulator kglsim_chg_simhp_free 0 23 0
shared pool simulator kglsim_scan_lru: scan 0 21 46
shared pool simulator kglsim_upd_newhp 0 7 19
simulator hash latch kcbsacc: lookup dba 0 42 46
simulator hash latch kcbs_lookup_setid: lookup dba 0 15 14
simulator hash latch kcbs_get_or_extract_simbufseq 0 4 1
simulator hash latch kcbsacc: remove dba 0 1 1
simulator lru latch kcbs_simulate: simulate set 0 88 0
simulator lru latch kcbs_free_granule_sim_buffers 0 29 0
simulator lru latch kcbs_resize_pool : interpolation 0 12 0
simulator lru latch kcbs_grow_pool 0 6 0
simulator lru latch kcbs_shrink_pool 0 5 0
slave class create ksvcreate 0 16 0
transaction branch allocation ksupuc 0 29 29
undo global data ktudba: KSLBEGIN 0 62 60

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
CC TAB_CC ACCT_BOOK P3 TABLE PARTITION 344,522,736 3.99
CC TAB_CC CHANGE_NOTIF P26 TABLE PARTITION 303,829,824 3.52
CC TAB_CC ADVICE P4 TABLE PARTITION 241,271,616 2.79
CC TAB_CC CHANGE_NOTIF P14 TABLE PARTITION 220,735,360 2.55
CC TAB_CC CHANGE_NOTIF P22 TABLE PARTITION 220,719,632 2.55

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
CC TAB_CC SUBS_ORDER P3 TABLE PARTITION 3,848,318 5.60
CC TAB_CC SUBS_UPP_INST   TABLE 3,279,373 4.77
CC TAB_CC CC_EVENT_HIS P3 TABLE PARTITION 3,059,087 4.45
CC TAB_CC CUST_CONTACT P3 TABLE PARTITION 2,932,235 4.27
CC TAB_CC ADVICE_HIS P3 TABLE PARTITION 887,364 1.29

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
CC TAB_CC ADVICE P27 TABLE PARTITION 78,262 53.50
CC TAB_DEF POLL_LOCKS   TABLE 9,512 6.50
CC IDX_CC IDX_AB_CDATE_PARTY_NEW P3 INDEX PARTITION 9,156 6.26
CC IDX_CC PK_ACCT_BOOK_NEW P3 INDEX PARTITION 7,124 4.87
CC IDX_CC PK_CUST   INDEX 6,962 4.76

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
CC IDX_CC PK_ACCT_BOOK_NEW P3 INDEX PARTITION 234 17.89
CC IDX_CC IDX_AB_CDATE_PARTY_NEW P3 INDEX PARTITION 170 13.00
CC IDX_CC PK_ADJUST_NEW P3 INDEX PARTITION 126 9.63
CC IDX_CC IDX_CO_ACC_DATE_NEW P3 INDEX PARTITION 67 5.12
CC IDX_CC PK_BATCH_ACCT_BOOK_NEW P3 INDEX PARTITION 61 4.66

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
CC TAB_CC ADVICE P27 TABLE PARTITION 12,676 26.23
CC IDX_CC IDX_AB_CDATE_PARTY_NEW P3 INDEX PARTITION 6,233 12.90
CC IDX_CC PK_ADVICE_HIS_NEW P3 INDEX PARTITION 4,629 9.58
CC IDX_CC PK_ACCT_BOOK_NEW P3 INDEX PARTITION 3,359 6.95
CC IDX_CC PK_CUST_CONTACT_NEW P3 INDEX PARTITION 2,601 5.38

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 1,021 27.03 0   32 1
dc_constraints 570 34.74 0   570 1
dc_database_links 4,268 0.02 0   0 1
dc_files 7,465 29.69 0   6 28
dc_global_oids 90,105 1.07 0   7 3
dc_histogram_data 3,911,219 6.43 0   3,517 1,706
dc_histogram_defs 2,921,897 11.40 0   3,313 1,457
dc_object_grants 9,734 12.45 0   0 151
dc_object_ids 22,641,843 0.13 0   156 622
dc_objects 3,763,406 0.84 0   878 899
dc_profiles 2,091 2.20 0   0 1
dc_rollback_segments 60,788 0.09 0   185 119
dc_segments 2,010,622 4.09 0   3,118 1,758
dc_sequences 156,203 0.24 0   156,203 26
dc_table_scns 73 100.00 0   0 0
dc_tablespace_quotas 1,280 1.17 0   1,280 3
dc_tablespaces 3,626,842 0.01 0   0 8
dc_usernames 68,326 2.02 0   0 8
dc_users 15,546,736 0.00 0   0 64
global database name 1 100.00 0   0 0
outstanding_alerts 855 49.59 0   0 8


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 15,717 2.72 53,191 1.55 391 0
CLUSTER 3,160 5.66 8,705 3.33 111 0
INDEX 3,997,731 0.05 5,180,021 0.10 2,759 0
JAVA RESOURCE 13 69.23 15 60.00 0 0
JAVA SOURCE 13 69.23 15 60.00 0 0
SQL AREA 4,685,078 78.01 72,068,226 7.72 21,528 10,347
TABLE/PROCEDURE 1,510,208 2.03 15,550,836 0.78 33,268 0
TRIGGER 4,883 8.52 939,295 0.08 327 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 161.52   1.90 3.89 22 26 85 85
  Freeable 53.88 0.00 0.78 1.00 6   69 69
  SQL 10.20 4.65 0.14 0.06 0 6 75 72
  PL/SQL 1.53 1.28 0.02 0.01 0 0 83 83
E Other 762.77   2.15 3.09 41 41 354 354
  Freeable 217.13 0.00 0.86 1.19 19   252 252
  SQL 50.70 22.05 0.15 0.12 0 17 345 329
  PL/SQL 7.28 5.75 0.02 0.02 0 15 352 352

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 9,143,582,720 9,428,795,392
Fixed Size 2,101,912  
Redo Buffers 14,671,872  
Variable Size 1,577,061,736 1,291,849,064

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 15.50 15.50 0.00
shared CCursor 190.13 40.69 -78.60
shared Cursor Stats 18.36 21.45 16.86
shared KGH: NO ACCESS   306.27  
shared PCursor 144.89 27.37 -81.11
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 192.81 671.20 248.11
shared kglsim heap   20.14  
shared kglsim object batch   36.71  
shared library cache 80.46 34.85 -56.68
shared sql area 634.74 117.72 -81.45
streams free memory   16.00  
  buffer_cache 8,720.00 8,992.00 3.12
  fixed_sga 2.00 2.00 0.00
  log_buffer 13.99 13.99 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 480,193 0 0
QMON Slaves 154,688 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 3 0 0 5 10

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
sessions 361 448 555 555


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/admin/cc/adump   
background_dump_dest /oracle/admin/cc/bdump   
compatible 10.2.0.3.0   
control_file_record_keep_time 14   
control_files /dev/rcc_crontrol_1, /dev/rcc_crontrol_2, /dev/rcc_crontrol_3   
core_dump_dest /oracle/admin/cc/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name cc   
dispatchers (PROTOCOL=TCP) (SERVICE=ccXDB)   
job_queue_processes 10   
log_archive_dest_1 LOCATION=/archcc   
open_cursors 500   
pga_aggregate_target 2147483648   
processes 500   
remote_login_passwordfile EXCLUSIVE   
sessions 555   
sga_max_size 10737418240   
sga_target 10737418240   
spfile /dev/rcc_spfile_01   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/cc/udump   


Back to Top

End of Report