WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
ORA11G4172642243ora11g128-Aug-12 03:0811.1.0.7.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
TOTO1Linux x86 64-bit 4 4 1 15.60

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:905411-Mar-13 21:00:1871 6.4
End Snap:905511-Mar-13 22:00:2073 6.9
Elapsed:  60.03 (mins)  
DB Time:  19.36 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 2,112M 2,112MStd Block Size: 8K
Shared Pool Size: 2,064M 2,064MLog Buffer: 10,444K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.3 3.2 0.00 0.00
DB CPU(s): 0.1 0.7 0.00 0.00
Redo size: 1,372.0 13,576.5  
Logical reads: 905.9 8,964.7  
Block changes: 10.1 99.9  
Physical reads: 1.2 12.2  
Physical writes: 0.6 5.9  
User calls: 253.8 2,511.7  
Parses: 74.9 741.3  
Hard parses: 36.8 364.2  
W/A MB processed: 132,731.8 1,313,482.6  
Logons: 0.8 8.0  
Executes: 163.4 1,617.3  
Rollbacks: 0.0 0.0  
Transactions: 0.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.86In-memory Sort %: 100.00
Library Hit %: 69.73Soft Parse %: 50.87
Execute to Parse %: 54.16Latch Hit %: 99.38
Parse CPU to Parse Elapsd %: 0.00% Non-Parse CPU: 68.30

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.83 83.44
% SQL with executions>1: 81.32 78.33
% Memory for SQL w/exec>1: 82.04 78.98

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
row cache lock183722394662.18Concurrency
DB CPU 251 21.62 
library cache lock393310648.02Concurrency
db file sequential read3,778920.74User I/O
control file sequential read32,721700.64System I/O

Host CPU (CPUs: 4 Cores: 4 Sockets: 1)

Load Average BeginLoad Average End%User%System%WIO%Idle
2.22 2.05 6.0 8.7 1.6 85.1
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
1.8 12.1 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 15,974.4 15,974.4
SGA use (MB): 5,200.0 5,200.0
PGA use (MB): 260.2 331.6
% Host Mem used for SGA+PGA: 34.18 34.18

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed886.3376.32
hard parse elapsed time818.0570.44
DB CPU251.1321.62
sql execute elapsed time198.8517.12
connection management call elapsed time97.908.43
PL/SQL execution elapsed time38.763.34
failed parse elapsed time0.550.05
PL/SQL compilation elapsed time0.540.05
hard parse (sharing criteria) elapsed time0.400.03
hard parse (bind mismatch) elapsed time0.300.03
sequence load elapsed time0.120.01
Java execution elapsed time0.100.01
repeated bind elapsed time0.030.00
DB time1,161.32 
background elapsed time41.99 
background cpu time10.06 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME216,562 
IDLE_TIME1,233,421 
IOWAIT_TIME23,305 
NICE_TIME8 
SYS_TIME126,789 
USER_TIME87,587 
LOAD22
RSRC_MGR_CPU_WAIT_TIME0 
PHYSICAL_MEMORY_BYTES16,750,383,104 
NUM_CPUS4 
NUM_CPU_CORES4 
NUM_CPU_SOCKETS1 
GLOBAL_RECEIVE_SIZE_MAX8,388,608 
GLOBAL_SEND_SIZE_MAX8,388,608 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX174,760 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX131,072 
TCP_SEND_SIZE_MIN4,096 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
11-Mar 21:00:182.22     
11-Mar 22:00:202.0514.946.048.741.6185.06

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
Concurrency10,626378227770.75
DB CPU  251 21.62
User I/O3,8050920.75
System I/O32,7210700.64
Network658,8530100.06
Commit7770110.04
Other33139010.02
Scheduler30010.00
Application0 0 0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
row cache lock183272239460.5062.18
library cache lock3093310640.018.02
db file sequential read3,77809210.380.74
control file sequential read32,72107089.890.64
latch: shared pool6,29404117.290.38
library cache: mutex X3,9621002010.880.16
SQL*Net message to client658,8530101,810.040.06
log file sync7770112.130.04
cursor: pin S128100010.350.01
db file scattered read190070.050.01
latch free920000.250.00
latch: session allocation1090000.300.00
cursor: mutex X7100020.020.00
latch: row cache objects240000.070.00
direct path write temp80010.020.00
latch: cache buffers chains1530000.420.00
resmgr:cpu quantum30010.010.00
SQL*Net message from client658,8740101,7211541,810.09 
jobq slave wait763982,26229652.10 
PL/SQL lock timer1100110020.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
row cache lock21001260110.0128.64
library cache lock10769890.0016.65
os thread startup9204410.258.90
log file parallel write2,7690107.613.08
control file sequential read4,60701012.662.94
control file parallel write1,2860113.532.56
db file parallel write1,2220003.361.02
SQL*Net break/reset to client3,3700009.260.69
rdbms ipc reply1002340.000.56
latch: shared pool260040.070.23
enq: PR - contention200370.010.17
db file sequential read120050.030.15
SQL*Net message to client9,42900025.900.06
latch free100130.000.03
log file sync20020.010.01
direct path write temp10010.000.00
rdbms ipc message16,9098354,195320546.45 
DIAG idle wait7,2381007,240100019.88 
smon timer131003,9003000040.04 
dispatcher timer611003,660600050.17 
Streams AQ: qmn coordinator idle wait260503,641140030.71 
Streams AQ: qmn slave idle wait13203,641275810.36 
shared server idle wait1211003,631300040.33 
pmon timer1,268953,62128563.48 
Space Manager: slave idle wait7251003,62049931.99 
fbar timer121003,6003000070.03 
JOX Jit Process Sleep179412573560.05 
SQL*Net message from client9,42906125.90 
class slave wait160000.04 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
LGWR wait for redo copy18100.0       
SQL*Net break/reset to client337099.2.6.1.0    
SQL*Net message to client667K100.0.0.0     
control file parallel write128687.85.35.91.0    
control file sequential read37K98.7.7.6.1.0.0  
cursor: mutex X757.114.314.314.3    
cursor: pin S12875.03.911.76.32.3.8  
db file parallel write122296.02.31.6.1    
db file scattered read1921.110.521.1 42.15.3  
db file sequential read379076.6.51.28.812.3.3.1 
direct path write temp933.344.422.2     
enq: PR - contention2    50.0 50.0 
latch free9388.29.71.1 1.1   
latch: cache buffer handles2100.0       
latch: cache buffers chains15398.01.3.7     
latch: row cache objects2483.312.54.2     
latch: session allocation11196.41.81.8     
latch: shared pool632193.93.11.2.4.5.6.4 
library cache lock3       100.0
library cache: mutex X396487.44.65.71.8.5.1.0 
log file parallel write276991.24.83.5.4.0   
log file sync77981.610.86.01.3.3   
os thread startup92     75.025.0 
rdbms ipc reply1      100.0 
reliable message2100.0       
resmgr:cpu quantum333.366.7      
row cache lock18559.521.62.2    16.8
DIAG idle wait7239      100.0 
JOX Jit Process Sleep175.9      94.1
PL/SQL lock timer1      100.0 
SQL*Net message from client668K20.42.221.320.317.18.89.5.5
Space Manager: slave idle wait725.1      99.9
Streams AQ: qmn coordinator idle wait26048.5.8.8    50.0
Streams AQ: qmn slave idle wait1321.5      98.5
class slave wait1693.8 6.3     
dispatcher timer61       100.0
fbar timer12       100.0
jobq slave wait764.1     1.298.7
pmon timer12664.7      95.3
rdbms ipc message16K2.9.1.1.1.61.130.065.0
shared server idle wait121       100.0
smon timer13       100.0

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
ora11g1,03820522,888
SYS$USERS120463323
SYS$BACKGROUND00054
ora11gXDB0000

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
ora11g 1702210534728006493871
SYS$USERS 2103687930094840
SYS$BACKGROUND 130113230000

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
3850 3.31b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
3830 3.266jbrg916bjmqc DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
3620 3.096mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
3421,6850.022.9259d21tvx4xn3q   update user$ set name=:2, pass...
320131.962.7541nh2c90gr1k0 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.952.753arkx25br7r04 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.892.75cd74yg75x2fu2 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.872.749cbrztp2kuyth TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.812.74f25b2uq9782hs TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.812.749c3wpx57j8s48 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.752.7320az9juxuc2xm TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.742.734f2m73y9bbjk4 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.712.73fg9xkrrvss5h9 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.612.721qy8g4tp3gxfy TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.612.729r80g3qtwjdwr TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.602.729q741698yf7f7 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
320131.582.726b6qaxupcs4kf TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.482.716yj7zd66pd0ff TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.472.714s52ca35p6gvc TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.452.71dmkz69q5nr108 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.452.711c88bzqws4ga5 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.432.7171czant8wzc1g TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.432.711fw5q7qt5q4kb TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
310131.432.7149p14jx65u179 TOTO@TOTO1 (TNS V1-V3) select SUBSCRIBERID, RESOURCEN...
157114,7250.001.27du3npcpzq82sp TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
88120.633.010.6559p216atzcyfh amosperf@TOTO1 (TNS V1-V3) select sql_text from (select s...
77120.612.930.643uhm3u5jynbak amosperf@TOTO1 (TNS V1-V3) select sql_text from (select s...
77120.612.930.64byzbk6f5n4upz amosperf@TOTO1 (TNS V1-V3) select sql_text from (select s...
715114,7250.002.761.27du3npcpzq82sp TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
5380 2.133.31b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
5514.531.800.40b5vd6xtzncv5v DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
3380 1.303.266jbrg916bjmqc DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
33120.221.070.23d98d5kh4u6ufx amosperf@TOTO1 (TNS V1-V3) select o.sid, o.user_name, o...
25114,7230.000.910.4712kbqx41uwvdn TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
2341,6850.000.812.9259d21tvx4xn3q   update user$ set name=:2, pass...

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
1,491,962114,72513.0045.726.9214.77du3npcpzq82sp TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
458,928114,7234.0014.062.285.4612kbqx41uwvdn TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
142,2730 4.365.3638.44b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
120,91239,9043.033.711.162.137br6xgmpmhukc TOTO@TOTO1 (TNS V1-V3) Select sScreenNumber, sScreenT...
106,3980 3.263.2737.856jbrg916bjmqc DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
79,047200395.242.421.121.88424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, fo...
78,327178,327.002.404.534.59b5vd6xtzncv5v DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
28,4280 0.871.6535.866mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
12,811112,811.000.390.810.856ajkhukk78nsr   begin prvt_hdm.auto_execute( :...
10,86072415.000.330.390.470khbp2znt4394 sqlplus@TOTO1 (TNS V1-V3) select tablespace_name, statu...

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
1,6490 37.191.6535.866mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
9890 22.303.2737.856jbrg916bjmqc DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
7321261.0016.510.300.380u3a2gth3r9vw amosperf@TOTO1 (TNS V1-V3) select sum(bytes)/1024 from DB...
5792289.5013.060.831.078ghxkaspgqdag DBMS_SCHEDULER select sql_id, plan_hash_valu...
76176.001.710.401.12d2nmbb77yzhm5 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
62162.001.400.060.339f559qjupqp79 DBMS_SCHEDULER SELECT dtp.tablespace_name , ...
36113.270.810.000.41dckagq5arxva5 TOTO@TOTO1 (TNS V1-V3) delete from t_bme...
34113.090.770.040.426s2jxg0nq736d TOTO@TOTO1 (TNS V1-V3) delete from TOTO...
16111.450.360.020.195ungsgg5wj7cd TOTO@TOTO1 (TNS V1-V3) delete from R...
102000.050.231.121.88424h0nf7bhqzd DBMS_SCHEDULER SELECT sqlset_row(sql_id, fo...

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
114,725114,7341.000.000.00du3npcpzq82sp TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
114,723114,7311.000.000.0012kbqx41uwvdn TOTO@TOTO1 (TNS V1-V3) select sSubscriberID, sSubscri...
39,9041,0700.030.000.007br6xgmpmhukc TOTO@TOTO1 (TNS V1-V3) Select sScreenNumber, sScreenT...
3,6043,6041.000.000.00a5ks9fhw2v9s1 TOTO@TOTO1 (TNS V1-V3) select * from dual
3,0272,1100.700.000.0096g93hntrzjtr   select /*+ rule */ bucket_cnt,...
2,5282,5281.000.000.009tgj4g8y4rwy8   select type#, blocks, extents,...
1,68500.000.000.003972rvxu3knn3 TOTO@TOTO1 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
1,6851,6851.000.000.0259d21tvx4xn3q   update user$ set name=:2, pass...
1,6851,6851.000.000.00a6u3yjca29nqc TOTO@TOTO1 (TNS V1-V3) declare m_stmt varchar2(512...
1,3641,3290.970.000.003c1kubcdjnppq   update sys.col_usage$ set eq...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
3,6043,6041.34a5ks9fhw2v9s1 TOTO@TOTO1 (TNS V1-V3) select * from dual
2,5282,5280.949tgj4g8y4rwy8   select type#, blocks, extents,...
1,6851,6850.623972rvxu3knn3 TOTO@TOTO1 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
1,6851,6850.6259d21tvx4xn3q   update user$ set name=:2, pass...
1,6851,6850.62a6u3yjca29nqc TOTO@TOTO1 (TNS V1-V3) declare m_stmt varchar2(512...
1,1031,1030.410ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
1,1031,1030.41459f3z9u4fb3u   select value$ from props$ wher...
9049040.34520mkxqpf15q8 TOTO@TOTO1 (TNS V1-V3) select 1 from dual
7247240.270khbp2znt4394 sqlplus@TOTO1 (TNS V1-V3) select tablespace_name, statu...
7247240.276v3dub2363sa5 sqlplus@TOTO1 (TNS V1-V3) select name, open_mode from v...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
15,359,97030.71803u6vwz0ah1p   select OBJOID, CLSOID, RUNT...
3,289,400150.15bn4b3vjw2mj3u   SELECT OBJOID, CLSOID, DE...
2,274,57740.116kqztxmbnwzht TOTO@TOTO1 (TNS V1-V3) update TOTO ...
2,127,429120.10g278wv0zzpn5j   select unique objn from ((sele...
2,127,364120.1099xa2xfxq7xmc amosperf@TOTO1 (TNS V1-V3) select * from (select event, ...
2,099,700180.107bdgxpmaqxx89 TOTO@TOTO1 (TNS V1-V3) update TOTO ...
1,806,85810.08b5vd6xtzncv5v DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
2,164350v3dvmc22qnam   insert into sys.col_usage$ (ob...
302311gfaj4z5hn1kf   delete from dependency$ where ...
293157ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
241981gu8t96d0bdmu   select t.ts#, t.file#, t.block...
222,5289tgj4g8y4rwy8   select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0khbp2znt4394select tablespace_name, status from dba_tablespaces
0u3a2gth3r9vwselect sum(bytes)/1024 from DBA_FREE_SPACE
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
12kbqx41uwvdnselect sSubscriberID, sSubscriberNumber, sMainType, sUserType, sUserSort , sUserState, sServiceActiveFlag, sActiveRoute, sActiveType, nSingleMain , sBarringFlag, sFeeType, sChargeAccount, sSameCallFlag from TOTO WHERE sSubscriberID=:sSubscriberID
1c88bzqws4ga5select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359107092'
1fw5q7qt5q4kbselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615395994089'
1gfaj4z5hn1kfdelete from dependency$ where d_obj#=:1
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1qy8g4tp3gxfyselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615306057355'
20az9juxuc2xmselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615345977023'
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3arkx25br7r04select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359013429'
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3uhm3u5jynbakselect sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6
41nh2c90gr1k0select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615375910786'
424h0nf7bhqzd SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NULL as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED, sfetches as fetch es, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, command_type, optimizer_env, bind_data, parsing_schema_name, parsing_user_id, plan_hash_value, optimizer_cost FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, rows_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.d bid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0)) T1, (SELECT sql_id, plan_hash_value, sum(CPU_TIME) AS scpu, sum(BUFFER_GETS) AS sbgets, sum(DISK_READS) AS sdreads, sum(DIRECT_WRITES) AS swrites, sum(ROWS_PROCESSED) AS srow, sum(FETCHES) AS sfetches, sum(EXECUTIONS) AS sexec, sum(END_OF_FETCH_COUNT) AS seofc, sum(ELAPSED_TIME) AS selap, MAX(SNAP_ID) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS snap_id, MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST ORDER BY ELAPSED_TIME) AS instance_number FROM (SELECT s.snap_id, s.dbid, s.instance_number, s.sql_id, s.force_matching_signature, sql_text, t.command_type, module, action, fetches_delta as FETCHES, executions_delta as EXECUTIONS, end_of_fetch_count_delta as END_OF_FETCH_COUNT, disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES, buffer_gets_delta as BUFFER_GETS, optimizer_env, row s_processed_delta as ROWS_PROCESSED, cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME, optimizer_cost, s.parsing_schema_name, s.parsing_user_id, plan_hash_value, loaded_versions, bind_data FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t, DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and s.dbid = e.dbid(+) and s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and s.dbid = d.dbid and /* only capture sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S )
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
49p14jx65u179select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618059321318'
4f2m73y9bbjk4select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615306971679'
4s52ca35p6gvcselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960806108'
520mkxqpf15q8select 1 from dual
59d21tvx4xn3qupdate user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15, spare4=:16 where user#=:1
59p216atzcyfhselect sql_text from (select sql_text from v$sqlarea order by loads desc) where rownum<6
5ungsgg5wj7cddelete from TOTO_ASSOCIATEDNUM where SSUBSCRIBERID = :0
6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6b6qaxupcs4kfselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613358209016'
6jbrg916bjmqcDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6kqztxmbnwzhtupdate TOTO set sSubscriberNumber = :0 where sSubscriberNumber = :1
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6s2jxg0nq736ddelete from TOTOla where 1=1 and subscriberID = :0
6v3dub2363sa5select name, open_mode from v$database
6yj7zd66pd0ffselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618020636076'
71czant8wzc1gselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618950322153'
7bdgxpmaqxx89update TOTO set sSubscriberid = :0 , sUserState = :1 , sActiveType = :2 , nSingleMain = :3 , sActiveRoute = :4 , SCHARGEACCOUNT = :5 where sSubscriberNumber = :6
7br6xgmpmhukcSelect sScreenNumber, sScreenType, sScreenFlow from R_BWList_SubscriberBWList where nServiceID =:nServiceID and sSubscriberNumber=:sSubscriberNumber and sSubscriberNumType=:sSubscriberNumType and sScreenNumber=:sScreenNumber and sScreenNumberType=:sScreenNumberType and sScreenType=:sScreenType and (sScreenFlow=:sScreenFlow or sScreenFlow=0) and sSPID=:sSPID and sMatchType=0 and rownum =1
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
803u6vwz0ah1p select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
8ghxkaspgqdag select sql_id, plan_hash_value, bucket_id, begin_snap, end_snap from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io, row_number() over (partition by bucket_id order by cpu_plus_io desc) as within_bucket_rnk from (select dbid, sql_id, bucket_id, max(plan_hash_value) keep (dense_rank last order by cpu_plus_io) plan_hash_value, max(begin_snap) keep (dense_rank last order by cpu_plus_io) begin_snap, max(end_snap) keep (dense_rank last order by cpu_plus_io) end_snap, max(cpu_plus_io) cpu_plus_io from (select dbid, sql_id, plan_hash_value, begin_snap, end_snap, bucket_id, cpu_time + buffer_gets * 10000 as cpu_plus_io from (select dbid, begin_snap, end_snap, sql_id, plan_hash_value, case when bucket_id = 0 then cpu_time / executions else cpu_time end as cpu_time, case when bucket_id = 0 then buffer_gets / executions else buffer_gets end as buffer_gets, bucket_id from (select dbid, min(snap_id) begin_snap, max(snap_id) end_snap, sql_id, plan_hash_value, sum(cpu_time) cpu_time, sum(buffer_gets) buffer_gets, decode(sum(executions), 0, 1, sum(executions)) executions, decode(grouping_id(snap_id, hour_id, day_id), 3, 0, 5, 1, 6, 2, 3) bucket_id from (select f.dbid, f.snap_id, sql_id, plan_hash_value, to_number(to_char(begin_interval_time + 0, 'DDD')) day_id, (to_number(to_char(begin_interval_time + 0, 'DDD')) - 1)*24 + to_number(to_char(begin_interval_time + 0, 'HH24')) hour_id, cpu_time, buffer_gets, executions from (select v1.* from ( select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions from (select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions, row_number() over(partition by dbid, snap_id order by(cpu_time + buffer_gets * 10000) desc) as within_snap_rnk from (select /*+ cardinality(d 1) */ sq.dbid, sq.snap_id, min(sq.instance_number) min_inst_num, sq.sql_id, plan_hash_value, sum(cpu_time_delta) cpu_time, sum(buffer_gets_delta) buffer_gets, sum(executions_delta) executions from dba_hist_sqlstat sq, v$database d, dba_hist_sqltext st where sq.dbid = d.dbid and st.dbid = sq.dbid and st.sql_id = sq.sql_id and sq.snap_id between :bid and :eid and st.command_type in (3) and bitand(nvl(sq.flag, 0), 1) = 0 group by sq.dbid, sq.snap_id, sq.sql_id, plan_hash_value)) where within_snap_rnk <= 150 ) v1, (select sq.sql_id from dba_hist_sqlstat sq, v$database d where sq.dbid = d.dbid and sq.snap_id between :bid and :eid group by sq.dbid, sq.sql_id having sum(nvl(executions_delta, 0)) >= 2) v2 where v1.sql_id = v2.sql_id) f, dba_hist_snapshot s where f.snap_id = s.snap_id and f.dbid = s.dbid and s.instance_number = f.min_inst_num) group by grouping sets ((dbid, sql_id, plan_hash_value, snap_id), (dbid, sql_id, plan_hash_value, day_id), (dbid, sql_id, plan_hash_value, hour_id), (dbid, sql_id, plan_hash_value))))) group by dbid, sql_id, bucket_id) where cpu_plus_io >= decode(bucket_id, 0, (10 * 1000000), 1, (60 * 1000000), 2, (240 * 1000000), (480 * 1000000)))where within_bucket_rnk <= 150) order by bucket_id asc, cpu_plus_io desc
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
99xa2xfxq7xmcselect * from (select event, count(*) from v$session_wait group by event order by count(*) desc) where rownum < 6
9c3wpx57j8s48select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359113379'
9cbrztp2kuythselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613328952025'
9f559qjupqp79 SELECT dtp.tablespace_name , dtp.status , dtp.contents , dtp.extent_management , dtp.allocation_type , dtp.logging , '' , dtp.initial_extent , dtp.next_extent , dtp.pct_increase , dtp.max_extents , '', dtp.min_extents, dtp.min_extlen, dtp.segment_space_management , dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) ts, (SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f WHERE dtp.tablespace_name = ts.tablespace_name (+) AND dtp.tablespace_name = f.tablespace_name (+) AND NOT (dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY') UNION ALL SELECT dtp.tablespace_name , dtp.status , dtp.contents , dtp.extent_management , dtp.allocation_type , dtp.logging , '', dtp.initial_extent , dtp.next_extent , dtp.pct_increase , dtp.max_extents , '', dtp.min_extents, dtp.min_extlen, dtp.segment_space_management , dtp.block_size, dtp.bigfile FROM sys.dba_t ablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.tablespace_name = ts.name group by ss.tablespace_name) t WHERE dtp.tablespace_name = a.tablespace_name (+) AND dtp.tablespace_name = t.tablespace_name (+) AND dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY'
9q741698yf7f7select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618060306888'
9r80g3qtwjdwrselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618159931791'
9tgj4g8y4rwy8select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a5ks9fhw2v9s1select * from dual
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
b5vd6xtzncv5v MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > LOG(0.01, NVL(LOC_STALE_PCT, :B1 )/100) THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND (T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMEN T_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND( M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAG S, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BIT AND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND O T.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER # = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE _GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
bn4b3vjw2mj3u SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
byzbk6f5n4upzselect sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6
cd74yg75x2fu2select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618046061557'
d2nmbb77yzhm5DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
d98d5kh4u6ufxselect o.sid, o.user_name, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid group by o.sid, o.user_name, osuser, machine order by o.user_name desc
dckagq5arxva5delete from t_bme_subscriber where resourceNumber = :0
dmkz69q5nr108select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618950331289'
du3npcpzq82spselect sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4, sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8, sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList from TOTO_AssociatedNum WHERE sAssociatedNum1 =:sAssociatedNum1 OR sAssociatedNum2 =:sAssociatedNum2 OR sAssociatedNum3 =:sAssociatedNum3 OR sAssociatedNum4 =:sAssociatedNum4 OR sAssociatedNum5 =:sAssociatedNum5 OR sAssociatedNum6 =:sAssociatedNum6 OR sAssociatedNum7 =:sAssociatedNum7 OR sAssociatedNum8 =:sAssociatedNum8 OR sAssociatedNum9 =:sAssociatedNum9 OR sAssociatedNum10 =:sAssociatedNum10
f25b2uq9782hsselect SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960985622'
fg9xkrrvss5h9select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613328292207'
g278wv0zzpn5jselect unique objn from ((select objn from SYS_MFBA_STAGE_RID) union all (select d.objn "OBJN" from SYS_FBA_DL d, SYS_MFBA_TRACKED_TXN t where (d.usn=t.usn) and (d.slot = t.slot)))

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count00.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count00.000.00
Batched IO same unit count00.000.00
Batched IO single block count00.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count00.000.00
Batched IO vector read count00.000.00
Block Cleanout Optim referenced10.000.00
CCursor + sql area evicted1,7570.494.83
CPU used by this session16,7314.6445.96
CPU used when call started15,3624.2642.20
CR blocks created170.000.05
Cached Commit SCN referenced00.000.00
Commit SCN cached00.000.00
DB time327,46290.91899.62
DBWR checkpoint buffers written1,5700.444.31
DBWR checkpoints00.000.00
DBWR revisited being-written buffer00.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR transaction table writes1140.030.31
DBWR undo block writes3140.090.86
Effective IO time00.000.00
HSC Heap Segment Block Changes4,9891.3913.71
Heap Segment Array Inserts1020.030.28
Heap Segment Array Updates50.000.01
IMU CR rollbacks260.010.07
IMU Flushes400.010.11
IMU Redo allocation size159,15244.18437.23
IMU commits3150.090.87
IMU contention20.000.01
IMU ktichg flush20.000.01
IMU pool not allocated00.000.00
IMU recursive-transaction flush10.000.00
IMU undo allocation size1,216,592337.753,342.29
IMU- failed to get a private strand00.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
RowCR - row contention00.000.00
RowCR attempts00.000.00
RowCR hits00.000.00
SMON posted for undo segment shrink00.000.00
SQL*Net roundtrips to/from client658,814182.901,809.93
active txn count during cleanout1460.040.40
application wait time00.000.00
auto extends on undo tablespace00.000.00
background checkpoints completed00.000.00
background checkpoints started00.000.00
background timeouts14,1003.9138.74
branch node splits00.000.00
buffer is not pinned count2,232,811619.876,134.10
buffer is pinned count106,65229.61293.00
bytes received via SQL*Net from client162,236,32645,039.89445,704.19
bytes sent via SQL*Net to client441,050,067122,443.881,211,676.01
calls to get snapshot scn: kcmgss615,747170.941,691.61
calls to kcmgas9,4762.6326.03
calls to kcmgcs46,03812.78126.48
cell physical IO interconnect bytes798,262,272221,612.772,193,028.22
change write time400.010.11
cleanout - number of ktugct calls980.030.27
cleanouts and rollbacks - consistent read gets140.000.04
cleanouts only - consistent read gets90.000.02
cluster key scan block gets19,6765.4654.05
cluster key scans16,7674.6546.06
commit batch/immediate performed00.000.00
commit batch/immediate requested00.000.00
commit cleanout failures: block lost20.000.01
commit cleanout failures: buffer being written00.000.00
commit cleanout failures: callback failure80.000.02
commit cleanout failures: cannot pin00.000.00
commit cleanouts4,7581.3213.07
commit cleanouts successfully completed4,7481.3213.04
commit immediate performed00.000.00
commit immediate requested00.000.00
commit txn count during cleanout890.020.24
concurrency wait time84,43623.44231.97
consistent changes14,5934.0540.09
consistent gets3,196,850887.518,782.55
consistent gets - examination1,624,819451.084,463.79
consistent gets direct00.000.00
consistent gets from cache3,196,850887.518,782.55
consistent gets from cache (fastpath)523,663145.381,438.63
current blocks converted for CR00.000.00
cursor authentications32,2228.9588.52
data blocks consistent reads - undo records applied300.010.08
db block changes36,36510.1099.90
db block gets66,29918.41182.14
db block gets direct5790.161.59
db block gets from cache65,72018.25180.55
db block gets from cache (fastpath)8,3802.3323.02
deferred (CURRENT) block cleanout applications3,2960.929.05
dirty buffers inspected10.000.00
drop segment calls in space pressure00.000.00
enqueue conversions7350.202.02
enqueue deadlocks00.000.00
enqueue releases180,42950.09495.68
enqueue requests180,46550.10495.78
enqueue timeouts00.000.00
enqueue waits20.000.01
exchange deadlocks00.000.00
execute count588,710163.441,617.34
failed probes on index block reclamation00.000.00
frame signature mismatch00.000.00
free buffer inspected2,9990.838.24
free buffer requested9,5882.6626.34
global undo segment hints helped00.000.00
heap block compress570.020.16
hot buffers moved to head of LRU8,5002.3623.35
immediate (CR) block cleanout applications230.010.06
immediate (CURRENT) block cleanout applications3780.101.04
index crx upgrade (positioned)00.000.00
index crx upgrade (prefetch)120.000.03
index fast full scans (full)160.000.04
index fetch by key480,783133.471,320.83
index scans kdiixs11,208,265335.443,319.41
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap live object count00.000.00
java call heap live object count max00.000.00
java call heap live size00.000.00
java call heap live size max00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
leaf node 90-10 splits250.010.07
leaf node splits340.010.09
lob reads2,7950.787.68
lob writes5,3121.4714.59
lob writes unaligned5,3121.4714.59
local undo segment hints helped00.000.00
logons cumulative2,8930.807.95
messages received4,0961.1411.25
messages sent4,0961.1411.25
min active SCN optimization applied to CR290.010.08
no work - consistent read gets482,441133.931,325.39
opened cursors cumulative303,39684.23833.51
parse count (describe)380.010.10
parse count (failures)80.000.02
parse count (hard)132,57436.81364.21
parse count (total)269,84374.91741.33
parse time cpu7,9602.2121.87
parse time elapsed83,82923.27230.30
physical IO disk bytes798,262,272221,612.772,193,028.22
physical read IO requests3,7971.0510.43
physical read bytes36,323,32810,084.0599,789.36
physical read total IO requests41,13711.42113.01
physical read total bytes648,003,584179,898.101,780,229.63
physical read total multi block requests60.000.02
physical reads4,4341.2312.18
physical reads cache4,4341.2312.18
physical reads cache prefetch6370.181.75
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests1,2480.353.43
physical write bytes17,612,8004,889.6548,386.81
physical write total IO requests11,7343.2632.24
physical write total bytes150,258,68841,714.67412,798.59
physical write total multi block requests260.010.07
physical writes2,1500.605.91
physical writes direct5790.161.59
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace5790.161.59
physical writes from cache1,5710.444.32
physical writes non checkpoint1,0570.292.90
pinned buffers inspected10.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time12,4323.4534.15
recursive calls1,070,346297.152,940.51
recursive cpu usage7,5702.1020.80
redo blocks checksummed by FG (exclusive)2,9410.828.08
redo blocks written12,1623.3833.41
redo buffer allocation retries00.000.00
redo entries10,7292.9829.48
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks2240.060.62
redo size4,941,8561,371.9513,576.53
redo size for direct writes00.000.00
redo subscn max counts6330.181.74
redo synch time650.020.18
redo synch writes1,9670.555.40
redo wastage1,059,128294.032,909.69
redo write time1610.040.44
redo writer latching time00.000.00
redo writes2,7690.777.61
rollback changes - undo records applied00.000.00
rollbacks only - consistent read gets30.000.01
rows fetched via callback153,37142.58421.35
session connect time00.000.00
session cursor cache hits52,67814.62144.72
session logical reads3,263,149905.918,964.70
shared hash latch upgrades - no wait1,033,285286.862,838.70
shared hash latch upgrades - wait1,0410.292.86
sorts (memory)10,3772.8828.51
sorts (rows)969,922269.272,664.62
space was found by tune down00.000.00
sql area evicted134,05337.22368.28
sql area purged130.000.04
steps of tune down ret. in space pressure00.000.00
summed dirty queue length10.000.00
switch current to new buffer1,7540.494.82
table fetch by rowid345,51195.92949.21
table fetch continued row7730.212.12
table scan blocks gotten66,50618.46182.71
table scan rows gotten1,684,255467.584,627.07
table scans (direct read)00.000.00
table scans (long tables)00.000.00
table scans (short tables)20,5085.6956.34
total number of times SMON posted00.000.00
transaction rollbacks00.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
tune down retentions in space pressure00.000.00
undo change vector size1,696,844471.084,661.66
user I/O wait time8770.242.41
user calls914,247253.812,511.67
user commits3560.100.98
user rollbacks80.000.02
workarea executions - optimal7,9052.1921.72
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory194,337,955,362,016194,389,624,923,608
opened cursors current456505
workarea memory allocated0364
logons current7173
session uga memory max4,184,322,711,1364,185,263,809,984
session pga memory101,110,808,336101,195,064,272
session pga memory max130,431,155,984130,523,079,632
session cursor cache count41,586,88541,596,456

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)00.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TOTO_USER_IDX 1,71302.771.00179000.00
SYSAUX 1,55300.401.00282000.00
TOTO_USER_DAT 16408.291.00458000.00
SYSTEM 36005.361.1870000.00
UNDOTBS1 000.000.00234000.00
TEMP 704.2982.7125000.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)
TOTO_USER_DAT/dev/vx/rdsk/vgphydb/lvdata 16408.291.00458000.00
TOTO_USER_IDX/dev/vx/rdsk/vgphydb/lvindex 1,71302.771.00179000.00
SYSAUX/dev/vx/rdsk/vgora/lvsysaux 1,55300.401.00282000.00
SYSTEM/dev/vx/rdsk/vgora/lvsystem 36005.361.1870000.00
TEMP/dev/vx/rdsk/vgora/lvtemp 704.2982.712500 
UNDOTBS1/dev/vx/rdsk/vgora/lvundo 00  234000.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
D260,1721003,262,9814,4341,571000


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
B0103391367354992160003549 
E0114833469623592160006235 

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D2080.1025,623194.713,244,907,607
D4160.2051,246117.171,952,732,438
D6240.3076,86965.411,090,060,033
D8320.39102,49231.33522,067,763
D1,0400.49128,11512.95215,878,232
D1,2480.59153,7386.05100,866,527
D1,4560.69179,3613.2854,665,241
D1,6640.79204,9841.9432,247,718
D1,8720.89230,6071.2721,232,778
D2,0800.98256,2301.0216,972,271
D2,1121.00260,1721.0016,665,506
D2,2881.08281,8530.9014,996,556
D2,4961.18307,4760.8313,800,487
D2,7041.28333,0990.7812,981,608
D2,9121.38358,7220.7412,286,226
D3,1201.48384,3450.7011,712,633
D3,3281.58409,9680.6711,203,837
D3,5361.67435,5910.6510,750,758
D3,7441.77461,2140.6210,374,706
D3,9521.87486,8370.6010,022,676
D4,1601.97512,4600.589,711,823

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.004580

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K7,4227,42200
64K128K565600
256K512K2200
512K1024K19819800
1M2M22522500
2M4M8800

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 CountEstd Time
3500.131,230,647.330.00100.000184,577,252
7000.251,230,647.330.00100.000184,577,252
1,4000.501,230,647.330.00100.000184,577,252
2,1000.751,230,647.330.00100.000184,577,252
2,8001.001,230,647.330.00100.000184,577,252
3,3601.201,230,647.330.00100.000184,577,252
3,9201.401,230,647.330.00100.000184,577,252
4,4801.601,230,647.330.00100.000184,577,252
5,0401.801,230,647.330.00100.000184,577,252
5,6002.001,230,647.330.00100.000184,577,252
8,4003.001,230,647.330.00100.000184,577,252
11,2004.001,230,647.330.00100.000184,577,252
16,8006.001,230,647.330.00100.000184,577,252
22,4008.001,230,647.330.00100.000184,577,252

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 (K)
4000.1920936,66316,931,7790.981,251,2601.34292,262
6080.2941747,93517,046,4440.991,136,5951.22304,302
8160.4062559,82317,102,4210.991,080,6181.16310,231
1,0240.5083372,72517,138,9990.991,044,0401.12313,918
1,2320.601,04184,38817,168,0391.001,015,0001.09316,966
1,4400.701,24996,58017,191,7281.00991,3111.06319,469
1,6480.801,457108,83117,212,2301.00970,8091.04321,651
1,8560.901,665121,04417,230,7451.00952,2941.02323,621
2,0641.001,872133,90217,247,6241.00935,4151.00325,441
2,2721.102,080145,76217,262,9641.00920,0750.98327,105
2,4801.202,288158,62217,276,9351.00906,1040.97328,641
2,6881.302,496170,72417,289,8791.00893,1600.95330,084
2,8961.402,704182,64817,302,0341.00881,0050.94331,446
3,1041.502,912195,68017,313,3611.00869,6780.93332,729
3,3121.603,120208,61117,324,0241.00859,0150.92333,945
3,5201.713,328220,90717,334,1381.01848,9010.91335,103
3,7281.813,536234,11417,343,7381.01839,3010.90336,208
3,9361.913,744246,05217,353,5461.01829,4930.89337,259
4,1442.014,034263,50317,364,4751.01818,5640.88338,469

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,9500.387,067,0181,532,696,221
2,6000.502,470,772169,443,158
3,2500.631,885,04925,311,564
3,9000.751,775,17416,665,502
4,5500.881,711,48316,665,502
5,2001.001,667,30016,665,502
5,8501.131,631,78713,080,753
6,5001.251,602,10913,080,753
7,1501.381,567,59513,320,736
7,8001.501,557,09110,189,288
8,4501.631,552,4238,794,385
9,1001.751,549,2557,866,117
9,7501.881,548,4227,622,801
10,4002.001,548,4227,622,801

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
161.002504,3021.00935,4151.0035,769
322.0091774,3021.00935,4151.00128,760

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PR-Process Startup 929202040.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
20.202,5381,201363563.6/63710.30/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
11-Mar 21:53153321,195163,7090/00/0/0/0/0/0
11-Mar 21:4319392594263,6990/00/0/0/0/0/0
11-Mar 21:33193411,197263,7020/00/0/0/0/0/0
11-Mar 21:2321381597263,6960/00/0/0/0/0/0
11-Mar 21:13143271,201163,7100/00/0/0/0/0/0
11-Mar 21:03107765601363,5640/00/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 latch2,4130.00 00 
ASM map operation hash table10.00 00 
AWR Alerted Metric Element list25,6880.00 00 
Change Notification Hash table latch1,2150.00 00 
Consistent RBA2,7690.00 00 
DML lock allocation1,801,9980.00 00 
Event Group Locks2,8810.00 00 
FAL request queue960.00 00 
FOB s.o list latch14,9100.00 00 
File State Object Pool Parent Latch10.00 00 
IPC stats buffer allocation latch130.00 00 
In memory undo latch7,8050.00 02,8290.00
JOX JIT latch10.00 010.00
JOX SGA heap latch8950.00 00 
JS Sh mem access90.00 00 
JS broadcast autostart latch20.00 00 
JS mem alloc latch270.00 00 
JS queue access latch280.00 00 
JS queue state obj latch26,2960.00 00 
JS slv state obj latch2550.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFR redo allocation latch10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list130.00 00 
KJCT flow control latch130.00 00 
KMG MMAN ready and startup request latch1,2070.00 00 
KTF sga latch480.00 09370.00
Locator state objects pool parent latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch130.00 01,2070.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch618,5420.030.0000 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process69,8320.00 00 
OS process allocation7,3330.00 00 
OS process: request allocation5,7580.00 00 
PL/SQL warning settings4,6120.00 00 
QMT10.00 00 
Real-time plan statistics latch4,1410.00 00 
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,2060.00
SQL memory manager workarea list latch84,5210.00 00 
Shared B-Tree1310.00 00 
Streams Generic10.00 00 
Testing130.00 00 
Token Manager10.00 00 
Write State Object Pool Parent Latch10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch2,4290.00 00 
active service list17,6350.020.0002,718,2170.00
archive control1,3820.00 00 
archive process latch1,3980.00 00 
buffer pool130.00 00 
business card10.00 00 
cache buffer handles1,382,1850.120.0000 
cache buffers chains4,989,6030.180.0206,2140.10
cache buffers lru chain7,2810.00 016,2590.14
cache table scan latch190.00 0190.00
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5,7810.00 00 
channel operations parent latch28,2590.00 00 
checkpoint queue latch58,9500.00 01,5990.00
client/application info8,4550.00 00 
commit callback allocation70.00 00 
compile environment latch2,8920.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch610.00 00 
cvmap freelist lock10.00 00 
database property service latch80.00 00 
deferred cleanup latch610.00 00 
dictionary lookup40.00 00 
dml lock allocation610.00 00 
done queue latch130.00 00 
dummy allocation5,7830.00 00 
enqueue hash chains361,6840.020.0000 
enqueues342,4440.110.0200 
fifth spare latch130.00 00 
file cache latch1720.00 00 
flashback archiver latch120.00 00 
flashback copy10.00 00 
gc element10.00 00 
gcs commit scn state130.00 00 
gcs partitioned table hash130.00 00 
gcs pcm hashed value bucket hash130.00 00 
gcs resource freelist130.00 00 
gcs resource hash130.00 00 
gcs resource scan list130.00 00 
gcs shadows freelist130.00 00 
ges domain table130.00 00 
ges enqueue table freelist130.00 00 
ges group table130.00 00 
ges process hash list130.00 00 
ges process parent latch130.00 00 
ges resource hash list130.00 00 
ges resource scan list130.00 00 
ges resource table freelist130.00 00 
ges value block free list130.00 00 
global KZLD latch for mem in SGA1,7140.00 00 
global tx hash mapping10.00 00 
granule operation130.00 00 
hash table column usage latch8060.00 01,119,3120.08
hash table modification latch1020.00 00 
heartbeat check130.00 00 
internal temp table object number allocation latch60.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch10.00 0270.00
job_queue_processes free list latch130.00 00 
job_queue_processes parameter latch8660.00 00 
k2q lock allocation10.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kks stats824,8930.140.0700 
kmcptab latch30.00 00 
kmcpvec latch0  010.00
kokc descriptor allocation latch2020.00 00 
ksfv messages130.00 00 
kss move lock490.00 00 
ksuosstats global area2440.00 00 
ksv allocation latch1330.00 00 
ksv class latch850.00 00 
ksv msg queue latch130.00 00 
ksz_so allocation latch5,7580.00 00 
ktm global data200.00 00 
kwqbsn:qsga1300.00 00 
lgwr LWN SCN2,7810.00 00 
list of block allocation3,4370.00 00 
loader state object freelist180.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer work area10.00 00 
longop free list parent140.00 020.00
mapped buffers lru chain10.00 00 
message pool operations parent latch300.00 00 
messages42,1590.000.0000 
mostly latch-free SCN2,7820.00 00 
msg queue latch130.00 00 
multiblock read objects420.00 00 
name-service namespace bucket130.00 00 
ncodef allocation latch610.00 00 
object queue header heap630.00 0180.00
object queue header operation16,4930.020.0000 
object stats modification350.00 00 
parallel query alloc buffer4730.00 00 
parallel query stats10.00 00 
parameter list7,4060.00 00 
parameter table management5,7880.00 00 
peshm10.00 00 
pesom_free_list5950.00 00 
pesom_hash_node5950.00 00 
pesom_heap_alloc60.00 00 
post/wait queue1,1610.00 07860.00
process allocation5,8500.021.0002,8800.00
process group creation5,7580.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch5310.00 00 
query server freelists10.00 00 
queued dump request130.00 00 
recovery domain hash list130.00 00 
redo allocation13,9960.030.00010,7760.02
redo copy130.00 010,7760.29
redo writing13,2700.00 00 
resmgr group change latch2,2180.00 00 
resmgr:active threads5,8010.00 0110.00
resmgr:actses change group1,1400.00 00 
resmgr:actses change state70.00 00 
resmgr:free threads list5,7840.00 00 
resmgr:method mem alloc latch160.00 00 
resmgr:plan CPU method31,3630.00 00 
resmgr:resource group CPU method3,8510.00 00 
resmgr:schema config920.00 010.00
resmgr:session queuing37,6250.00 00 
rm cas latch10.00 00 
row cache objects17,672,0270.930.0002,1440.05
second spare latch130.00 00 
sequence cache5,5130.00 00 
session allocation1,076,7080.280.0400 
session idle bit2,359,5660.010.0300 
session queue latch130.00 00 
session state list latch2,4110.00 00 
session switching740.00 00 
session timer1,2680.00 00 
shared pool6,816,4711.080.0950 
shared pool sim alloc10.00 00 
shared pool simulator1,346,8120.000.0000 
sim partition latch130.00 00 
simulator hash latch187,9820.00 00 
simulator lru latch130.00 0187,9210.15
sort extent pool1530.00 00 
space background state object latch100.00 00 
space background task latch2,6750.040.0002,4140.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain130.00 00 
temp lob duration state obj allocation50.00 00 
temporary table state object allocation40.00 00 
test excl. parent l0130.00 00 
test excl. parent2 l0130.00 00 
third spare latch130.00 00 
threshold alerts latch1660.00 00 
trace latch10.00 00 
transaction allocation560,6980.00 00 
undo global data11,0230.00 00 
user lock6,8910.00 00 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects17,672,027164,24824164,224
shared pool6,816,47173,8126,59867,505
cache buffers chains4,989,6038,9281578,775
session allocation1,076,7083,0101162,900
cache buffer handles1,382,1851,64321,641
kks stats824,8931,159801,085
enqueues342,4443878379
session idle bit2,359,5663489339
process allocation5,850110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffer handleskcbzfs020
cache buffers chainskcbgtcr_90292307
cache buffers chainskcbgtcr: fast path03412
cache buffers chainskcbrls_20916
enqueuesksqdel060
enqueuesksqgel: create enqueue028
kks statskksAllocChildStat08080
process allocationksudlp010
row cache objectskqreqd: reget0160
row cache objectskqrpre: find obj0421
row cache objectskqreqd032
row cache objectskqrcmt: clear flag010
session allocationksufap: active sessions0400
session allocationksuxds: KSUSFCLC not set0320
session allocationksuxds: not user session02812
session allocationksucri016102
session idle bitksupuc: set busy061
session idle bitksuxds025
session idle bitksupuc: clear busy013
shared poolkghalo04,3553,450
shared poolkghalp01,5641,408
shared poolkghupr105191,430
shared poolkgh_heap_sizes088144
shared poolkghfre04156
shared poolkghasp031110

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn2 1061,044372
Library Cachekglobpn1 71941445
Library Cachekglpin1 4637378
Library Cachekglhdgn1 62278296
Library Cachekglpndl1 95254130
Library Cachekglpnal1 9023049
Library Cachekgllkdl1 8522774
Library Cachekglget2 220340
Library Cachekgldtin1 4214953
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]712
Library CachekglGetHandleReference 11510
Library Cachekgllkc1 5710

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
TOTOTOTO_USER_IDXI_BME_PERSON_SUB_NUMBER INDEX724,67222.21
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX347,20010.64
TOTOTOTO_USER_DATSYS_C0011178 INDEX346,65610.62
TOTOTOTO_USER_DATTOTO_ASSOCIATEDNUM TABLE123,1843.78
TOTOTOTO_USER_DATTOTO TABLE121,0883.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
TOTOTOTO_USER_IDXI_BME_PERSON_SUB_NUMBER INDEX1,66737.60
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX290.65
TOTOTOTO_USER_DATINDEX_ONENUMBER_NUMBER INDEX210.47
TOTOTOTO_USER_DATTOTOLA TABLE150.34
TOTOTOTO_USER_IDXPK_SUBRELA_PER INDEX120.27

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
TOTOTOTO_USER_IDXI_BME_PERSON_SUB_NUMBER INDEX793.67
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX763.53
TOTOTOTO_USER_DATINDEX_ONENUMBER_NUMBER INDEX733.40
TOTOTOTO_USER_DATTOTO_ASSOCIATEDNUM TABLE512.37
TOTOTOTO_USER_DATTOTOLA TABLE502.33

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
SYSSYSTEMI_OBJ2 INDEX425.00
SYSSYSTEMI_HH_OBJ#_INTCOL# INDEX16.25
SYSSYSTEMI_OBJ1 INDEX16.25

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
TOTOTOTO_USER_DATINDEX_ONENUMBER_NUMBER INDEX808.06
SYSSYSAUXWRH$_EVENT_HISTOGRAM_PK42243_9044INDEX PARTITION646.45
SYSSYSAUXWRH$_SQLSTAT42243_9044TABLE PARTITION646.45
SYSSYSAUXWRH$_SQLSTAT_INDEX42243_9044INDEX PARTITION646.45
SYSSYSAUXWRH$_SYSSTAT42243_9044TABLE PARTITION646.45

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
TOTOTOTO_USER_IDXPK_SUBRELA_PER INDEX225.00
TOTOTOTO_USER_IDXPK_SUBSCR_PER INDEX225.00
TOTOTOTO_USER_DATSYS_C0011178 INDEX225.00
TOTOTOTO_USER_DATINDEX_BIND_NUMBER1 INDEX112.50
TOTOTOTO_USER_IDXI_BME_PERSON_SUB_NUMBER INDEX112.50

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1650.000 21
dc_database_links4,5040.000 01
dc_files2340.000 06
dc_global_oids29314.330 038
dc_histogram_data1,720,1110.080 01,311
dc_histogram_defs2,245,7980.140 142,209
dc_object_grants4621.740 010
dc_objects2,119,1210.050 411,184
dc_profiles1,7620.060 02
dc_rollback_segments8660.000 022
dc_segments528,5380.150 6614
dc_sequences1675.000 167
dc_tablespaces65,5620.000 08
dc_users342,6700.030 1,686119
global database name3,5670.000 01
outstanding_alerts4875.000 07
sch_lj_objs4100.000 04


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY14264.0856517.1700
CLUSTER5890.852302.1700
INDEX12020.009427.6600
JAVA DATA20.000 00
SQL AREA510,72173.11862,32745.8012,59913
TABLE/PROCEDURE2,381,7790.05446,6630.465110
TRIGGER1,6970.351,6970.3500


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache2,112.002,112.002,112.002,576.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target2,800.002,800.002,800.003,280.000SHR/DEF
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target5,200.005,200.004,720.005,200.000GRO/DEF
Shared IO Pool944.00944.00944.00944.000STA/
java pool16.0016.0016.0032.000SHR/DEF
large pool16.0016.0016.0016.000STA/
shared pool2,064.002,064.001,104.002,064.000GRO/DEF
streams pool0.000.000.000.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to 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
BOther215.44 2.955.3522227373
 Freeable38.560.000.841.057 4646
 SQL3.740.110.070.080115643
 JAVA2.362.361.181.672422
 PL/SQL0.240.110.000.01007171
EOther270.52 3.616.8540407575
 Freeable51.880.001.081.487 4848
 SQL6.322.100.110.302115845
 JAVA2.362.361.181.672422
 PL/SQL0.530.300.010.02007373

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers2,214,592,512 
Fixed Size2,176,320 
Redo Buffers10,694,656 
Variable Size6,123,686,592 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory4.354.350.00
javajoxlod exec hp11.1911.190.00
javajoxs heap0.460.460.00
largePX msg pool0.990.990.00
largefree memory15.0115.010.00
sharedCCursor214.70210.42-2.00
sharedCursor Stats26.9726.970.00
sharedKGL handle76.0076.100.14
sharedPCursor212.51209.75-1.30
shareddb_block_hash_buckets22.2522.250.00
sharedfree memory313.02341.799.19
sharedkglsim object batch36.2836.280.00
sharedsql area993.72961.39-3.25
 buffer_cache2,112.002,112.000.00
 fixed_sga2.082.080.00
 log_buffer10.2010.200.00
 shared_io_pool944.00944.000.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/oracle/app/admin/ora11g/adump  
audit_trailNONE  
compatible11.1.0.0.0  
control_files/dev/vx/rdsk/vgora/lvctl1, /dev/vx/rdsk/vgora/lvctl2, /dev/vx/rdsk/vgora/lvctl3  
db_block_size8192  
db_domain    
db_nameora11g  
db_recovery_file_dest    
db_recovery_file_dest_size2147483648  
diagnostic_dest/oracle/app  
dispatchers(PROTOCOL=TCP) (SERVICE=ora11gXDB)  
local_listener    
log_archive_dest_1location=/home/oracle/archive  
memory_target8388608000  
open_cursors300  
processes150  
remote_listener    
remote_login_passwordfileEXCLUSIVE  
resource_manager_plan  SCHEDULER[0x2C53]:DEFAULT_MAINTENANCE_PLAN
sec_case_sensitive_logonFALSE  
spfile/dev/vx/rdsk/vgora/lvspfile  
undo_tablespaceUNDOTBS1  


Back to Top

End of Report