WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
COM30004107837388com3000110.2.0.4.0NODNDBA

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:622510-1? -13 18:00:02614 .9
End Snap:622910-1? -13 22:00:09617 1.0
Elapsed:  240.11 (mins)  
DB Time:  498.00 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,344M 1,344MStd Block Size: 8K
Shared Pool Size: 5,632M 5,632MLog Buffer: 14,336K

Load Profile

Per SecondPer Transaction
Redo size: 219,585.09 6,150.64
Logical reads: 78,178.86 2,189.81
Block changes: 1,222.54 34.24
Physical reads: 1.65 0.05
Physical writes: 21.25 0.60
User calls: 620.92 17.39
Parses: 255.20 7.15
Hard parses: 173.34 4.86
Sorts: 17.26 0.48
Logons: 0.06 0.00
Executes: 256.97 7.20
Transactions: 35.70 

% Blocks changed per Read: 1.56Recursive Call %: 42.02
Rollback per transaction %: 0.00Rows per Sort: 76.38

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 72.59Soft Parse %: 32.08
Execute to Parse %: 0.69Latch Hit %: 99.25
Parse CPU to Parse Elapsd %: 5.41% Non-Parse CPU: 95.30

Shared Pool Statistics

BeginEnd
Memory Usage %: 63.92 63.98
% SQL with executions>1: 25.85 40.66
% Memory for SQL w/exec>1: 25.92 40.80

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  15,948  53.4 
latch: library cache 1,152,690 10,442 9 34.9Concurrency
latch: shared pool 863,510 1,008 1 3.4Concurrency
log file sync 519,178 471 1 1.6Commit
latch free 122,854 417 3 1.4Other

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 15,948.29 53.37
sql execute elapsed time 13,767.46 46.08
parse time elapsed 13,518.19 45.24
hard parse elapsed time 8,269.31 27.67
sequence load elapsed time 247.18 0.83
connection management call elapsed time 4.73 0.02
PL/SQL execution elapsed time 3.38 0.01
PL/SQL compilation elapsed time 0.57 0.00
repeated bind elapsed time 0.06 0.00
hard parse (sharing criteria) elapsed time 0.01 0.00
failed parse elapsed time 0.01 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 29,880.15  
background elapsed time 418.87  
background cpu time 112.92  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 2,266,148 0.00 12,011 5 4.41
Commit 519,178 0.00 471 1 1.01
Other 138,781 2.61 428 3 0.27
System I/O 557,785 0.00 288 1 1.08
Configuration 39,201 1.49 215 5 0.08
Application 466,859 0.00 160 0 0.91
Network 5,511,572 0.00 6 0 10.72
User I/O 16,283 0.00 4 0 0.03

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch: library cache 1,152,690 0.00 10,442 9 2.24
latch: shared pool 863,510 0.00 1,008 1 1.68
log file sync 519,178 0.00 471 1 1.01
latch free 122,854 0.00 417 3 0.24
buffer busy waits 130,442 0.01 375 3 0.25
log file parallel write 491,274 0.00 247 1 0.96
enq: SQ - contention 38,201 0.00 213 6 0.07
SQL*Net break/reset to client 466,856 0.00 160 0 0.91
enq: TX - index contention 20,387 0.00 66 3 0.04
latch: row cache objects 11,624 0.00 51 4 0.02
latch: cache buffers chains 11,087 0.00 38 3 0.02
db file parallel write 50,933 0.00 37 1 0.10
latch: library cache lock 2,304 0.00 10 4 0.00
latch: In memory undo latch 13,134 0.00 9 1 0.03
latch: library cache pin 1,711 0.00 7 4 0.00
SQL*Net message to client 5,510,346 0.00 6 0 10.71
latch: undo global data 1,548 0.00 5 3 0.00
control file parallel write 5,753 0.00 4 1 0.01
db file sequential read 15,459 0.00 4 0 0.03
latch: enqueue hash chains 577 0.00 2 4 0.00
log file switch completion 407 0.00 2 5 0.00
os thread startup 19 0.00 2 112 0.00
wait list latch free 194 0.00 2 11 0.00
LGWR wait for redo copy 7,712 0.18 1 0 0.01
cursor: pin S wait on X 103 100.00 1 11 0.00
buffer deadlock 3,668 98.26 1 0 0.01
cursor: mutex X 59,134 0.00 1 0 0.11
db file scattered read 322 0.00 0 1 0.00
rdbms ipc reply 610 0.00 0 1 0.00
library cache load lock 3 0.00 0 103 0.00
latch: redo allocation 210 0.00 0 1 0.00
control file sequential read 9,757 0.00 0 0 0.02
read by other session 17 0.00 0 3 0.00
latch: session allocation 24 0.00 0 1 0.00
cursor: pin S 1,370 0.00 0 0 0.00
SQL*Net more data from client 613 0.00 0 0 0.00
SQL*Net more data to client 613 0.00 0 0 0.00
direct path write 243 0.00 0 0 0.00
enq: TX - contention 3 0.00 0 4 0.00
latch: object queue header operation 1 0.00 0 9 0.00
undo segment extension 590 99.15 0 0 0.00
log file single write 34 0.00 0 0 0.00
latch: messages 8 0.00 0 1 0.00
enq: HW - contention 2 0.00 0 1 0.00
enq: TX - row lock contention 3 0.00 0 1 0.00
latch: cache buffers lru chain 2 0.00 0 0 0.00
db file parallel read 4 0.00 0 0 0.00
direct path read 238 0.00 0 0 0.00
log file sequential read 34 0.00 0 0 0.00
latch: redo writing 1 0.00 0 0 0.00
SQL*Net message from client 5,510,346 0.00 6,721,345 1220 10.71
virtual circuit status 481 100.00 14,063 29236 0.00
jobq slave wait 4,795 94.85 13,998 2919 0.01
PL/SQL lock timer 1 100.00 1 977 0.00
class slave wait 5 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 491,275 0.00 247 1 0.96
db file parallel write 50,920 0.00 37 1 0.10
control file parallel write 5,753 0.00 4 1 0.01
os thread startup 19 0.00 2 112 0.00
events in waitclass Other 8,481 0.17 2 0 0.02
latch: shared pool 110 0.00 1 7 0.00
latch: library cache 37 0.00 0 13 0.00
control file sequential read 7,055 0.00 0 0 0.01
db file scattered read 27 0.00 0 1 0.00
buffer busy waits 72 0.00 0 0 0.00
direct path write 237 0.00 0 0 0.00
db file sequential read 61 0.00 0 0 0.00
log file single write 34 0.00 0 0 0.00
latch: cache buffers chains 2 0.00 0 1 0.00
direct path read 238 0.00 0 0 0.00
log file sequential read 34 0.00 0 0 0.00
latch: redo writing 1 0.00 0 0 0.00
rdbms ipc message 520,982 8.74 122,953 236 1.01
pmon timer 5,073 100.00 14,060 2772 0.01
smon timer 212 16.04 13,712 64680 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 183,690
AVG_IDLE_TIME 1,257,713
AVG_IOWAIT_TIME 910
AVG_SYS_TIME 11,080
AVG_USER_TIME 172,157
BUSY_TIME 1,472,856
IDLE_TIME 10,065,152
IOWAIT_TIME 9,218
SYS_TIME 92,116
USER_TIME 1,380,740
LOAD 0
OS_CPU_WAIT_TIME 1,893,900
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 16,441,671,680
NUM_CPUS 8
NUM_CPU_CORES 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
com3000 25,545.50 11,630.80 9,582 669,259,916
SYS$USERS 4,334.80 4,317.60 7,761 456,887,784
SYS$BACKGROUND 0.00 0.00 1,224 156,490
com3000XDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
com3000 9598 156 2265446 1200298 0 0 5509119 613
SYS$USERS 5305 234 378 314 0 0 0 0
SYS$BACKGROUND 1339 13 240 342 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
68 59 1,092 0.06 0.23 5au14t0dvnmkt master.exe select distinct a.acquireperio...
51 36 1,361 0.04 0.17 6bmhtsgarc5ur quarantine_console.exe select min(id) from dbtranssql
51 51 13,813 0.00 0.17 8kxms920bsy53 DataDispose.exe select ID, termid, ammeterid, ...
51 27 2,880 0.02 0.17 1zcr51dwxp9nu Maintenance.exe select c.termid, t.name, c.sta...
49 28 2,881 0.02 0.17 1t1sv5qw5dvc2 Maintenance.exe select c.termid, t.name, c.sta...
41 33 22,862 0.00 0.14 65xxzpg1hbc73 master.exe select count(*) from task_timi...
36 27 14,580 0.00 0.12 cp3m11q3jbcu5 master.exe select count(*) from task_timi...
36 33 1 35.69 0.12 3rtjm633gamtt DataDispose.exe select w.termid, m.ammeterid, ...
35 34 1 35.15 0.12 4vcvt1z0740r5 DataDispose.exe select w.termid, m.ammeterid, ...
35 34 1 35.15 0.12 b50u5u0549v1x DataDispose.exe select w.termid, m.ammeterid, ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
59 68 1,092 0.05 0.23 5au14t0dvnmkt master.exe select distinct a.acquireperio...
51 51 13,813 0.00 0.17 8kxms920bsy53 DataDispose.exe select ID, termid, ammeterid, ...
36 51 1,361 0.03 0.17 6bmhtsgarc5ur quarantine_console.exe select min(id) from dbtranssql
34 35 1 34.43 0.12 6tym23bgd7wm5 DataDispose.exe select w.termid, m.ammeterid, ...
34 35 1 34.41 0.12 csr21n8234jnf DataDispose.exe select w.termid, m.ammeterid, ...
34 35 1 34.32 0.12 4vcvt1z0740r5 DataDispose.exe select w.termid, m.ammeterid, ...
34 35 1 34.24 0.12 96p427nmc6m53 DataDispose.exe select w.termid, m.ammeterid, ...
34 35 1 34.23 0.12 763007dncjtn3 DataDispose.exe select w.termid, m.ammeterid, ...
34 35 1 34.12 0.12 b50u5u0549v1x DataDispose.exe select w.termid, m.ammeterid, ...
34 34 1 34.02 0.11 ajwmu7kj8nc3p DataDispose.exe select w.termid, m.ammeterid, ...

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
10,864,251 2,881 3,771.00 0.96 27.57 49.49 1t1sv5qw5dvc2 Maintenance.exe select c.termid, t.name, c.sta...
10,860,480 2,880 3,771.00 0.96 27.44 50.60 1zcr51dwxp9nu Maintenance.exe select c.termid, t.name, c.sta...
10,401,189 13,813 753.00 0.92 50.59 50.93 8kxms920bsy53 DataDispose.exe select ID, termid, ammeterid, ...
9,159,903 1,361 6,730.27 0.81 36.43 50.95 6bmhtsgarc5ur quarantine_console.exe select min(id) from dbtranssql
8,187,446 22,862 358.12 0.73 33.25 40.72 65xxzpg1hbc73 master.exe select count(*) from task_timi...
6,842,648 14,580 469.32 0.61 27.41 35.96 cp3m11q3jbcu5 master.exe select count(*) from task_timi...
6,341,361 3,601 1,761.00 0.56 26.66 30.62 d2nqyczp27rg8 statisticobject.exe select * from (select a.taskid...
5,781,813 5,611 1,030.44 0.51 19.93 32.36 8hq4ck26sqwc4 master.exe select count(*) from task_timi...
5,131,073 2,881 1,781.00 0.46 25.02 31.25 4xz0jg0j7am7k Maintenance.exe select a.*, decode(b.status, 1...
4,714,201 2,677 1,761.00 0.42 19.22 21.04 3cas94b93bbht DataDispose.exe select * from (select batchno,...

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,188 1 1,188.00 5.00 3.18 6.17 5ps3p5ma94bkh DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...
1,050 68 15.44 4.42 3.51 3.67 fyrbzparfb4gb DBMS_SCHEDULER SELECT OWNER, SEGMENT_NAME, ...
463 1 463.00 1.95 0.21 0.30 1b28hzmjun5t0 DBMS_SCHEDULER MERGE INTO SYS.MON_MODS_ALL$ M...
127 1,751 0.07 0.53 0.23 0.25 db78fxqxwxt7r   select /*+ rule */ bucket, en...
37 445 0.08 0.16 0.03 0.04 04xtrk7uyhknh   select obj#, type#, ctime, mti...
34 6,062 0.01 0.14 0.16 0.19 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
15 604 0.02 0.06 0.02 0.02 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
15 2 7.50 0.06 0.12 0.14 fvsvt0v8srj08 DBMS_SCHEDULER SELECT DISTINCT(COMPOSITE) FRO...
13 4 3.25 0.05 0.07 0.07 32whwm2babwpt   insert into wrh$_seg_stat_obj ...
12 3,213 0.00 0.05 1.00 2.27 bhkvap5pa7bmu master.exe insert into dbtranssql values(...

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
233,389 233,382 1.00 0.00 0.00 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
63,093 63,093 1.00 0.00 0.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
22,862 22,862 1.00 0.00 0.00 65xxzpg1hbc73 master.exe select count(*) from task_timi...
18,753 18,753 1.00 0.00 0.00 0r0t4z6ngzcqy master.exe insert into dbtranssql values(...
18,753 38 0.00 0.00 0.00 632zghnbahhbh master.exe select termid from task_timing...
18,753 233,633 12.46 0.00 0.00 6pbsrf3sr1fyd master.exe select channel, avg(ratio) as...
18,753 280 0.01 0.00 0.00 7q0nj3xgf6a80 master.exe select a.taskid as taskid, a....
18,753 66 0.00 0.00 0.00 7vc66tgtdj2qk master.exe delete from task_timing_task a...
18,753 67 0.00 0.00 0.00 gyg2rzjbgncwr master.exe select termid from task_timing...
14,580 14,580 1.00 0.00 0.00 cp3m11q3jbcu5 master.exe select count(*) from task_timi...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
233,369 233,389 6.35 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
63,093 63,093 1.72 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
22,862 22,862 0.62 65xxzpg1hbc73 master.exe select count(*) from task_timi...
18,753 18,753 0.51 0r0t4z6ngzcqy master.exe insert into dbtranssql values(...
18,753 18,753 0.51 632zghnbahhbh master.exe select termid from task_timing...
18,753 18,753 0.51 6pbsrf3sr1fyd master.exe select channel, avg(ratio) as...
18,753 18,753 0.51 7q0nj3xgf6a80 master.exe select a.taskid as taskid, a....
18,753 18,753 0.51 7vc66tgtdj2qk master.exe delete from task_timing_task a...
18,753 18,753 0.51 gyg2rzjbgncwr master.exe select termid from task_timing...
14,580 14,580 0.40 cp3m11q3jbcu5 master.exe select count(*) from task_timi...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,461,874 1 0.04 5ps3p5ma94bkh DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0r0t4z6ngzcqyinsert into dbtranssql values(dbtranssql_seq.nextval, 'delete from task_timing_task a where a.status = 2 and a.conntrytimes = 3 and a.areacode = ''50700'' and a.datatype in (37, 38, 39, 40, 31, 32, 33)')
1b28hzmjun5t0MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0)
1t1sv5qw5dvc2select c.termid, t.name, c.status, c.tasknum, c.datatype from term_info t, (select a.termid, a.status, count(*)as tasknum, 14 as datatype from task_instant_task a where a.datatype = 14 and a.areacode = '50796' group by a.termid, a.status union all select a.termid, a.status, count(*)as tasknum, 12 as datatype from task_instant_task a, task_term_channel_config b where a.datatype = 12 and a.areacode = '50796' group by a.termid, a.status union all select a.termid, a.status, count(*)as tasknum, 0 as datatype from task_instant_task a where a.datatype != 12 and a.datatype != 14 and a.areacode = '50796' group by a.termid, a.status order by termid) c where t.termid = c.termid order by t.name, c.datatype
1zcr51dwxp9nuselect c.termid, t.name, c.status, c.tasknum, c.datatype from term_info t, (select a.termid, a.status, count(*)as tasknum, 14 as datatype from task_instant_task a where a.datatype = 14 and a.areacode = '50792' group by a.termid, a.status union all select a.termid, a.status, count(*)as tasknum, 12 as datatype from task_instant_task a, task_term_channel_config b where a.datatype = 12 and a.areacode = '50792' group by a.termid, a.status union all select a.termid, a.status, count(*)as tasknum, 0 as datatype from task_instant_task a where a.datatype != 12 and a.datatype != 14 and a.areacode = '50792' group by a.termid, a.status order by termid) c where t.termid = c.termid order by t.name, c.datatype
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
32whwm2babwpt insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , decode(ss1.objtype_kewrseg, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 'UNDEFINED') , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_kewrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 6, 7, 9)))) and ss1.objna me_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
3cas94b93bbhtselect * from (select batchno, to_char(begintime, 'yyyymmdd hh24'), datatype, id, taskstatus from task_data_process_task where mod(id, 10) = 1 and datatype not in (13) order by taskstatus, batchno, begintime) t where taskstatus not in (-1, -3) and rownum <= 1
3rtjm633gamttselect w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:180000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:180000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507829 order by w.termid, m.ammeterid, time, l.linetype
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4vcvt1z0740r5select w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507565 order by w.termid, m.ammeterid, time, l.linetype
4xz0jg0j7am7kselect a.*, decode(b.status, 1, 1, 0) as status from (select d.frontid, d.name, d.ip, d.port, d.directorypath, a.channelid as channelid, 0 as comid, 1 as type from front_net_channel a , front_info d where a.frontid(+) = d.frontid and d.areacode = '50796' union all select d.frontid, d.name, d.ip, d.port, d.directorypath, a.channelid as channelid, a.comid as comid, 2 as type from front_dial_channel a , front_info d where a.frontid(+) = d.frontid and d.areacode = '50796' union all select d.frontid, d.name, d.ip, d.port, d.directorypath, a.channelid as channelid, 0 as comid, 3 as type from front_ddn_channel a , front_info d where a.frontid(+) = d.frontid and d.areacode = '50796') a, (select distinct t.channelid1, t.status from task_timing_task t where t.status = 1 union select distinct t.channelid1, t.status from task_instant_task t where t.status = 1 ) b where a.channelid = b.channelid1(+) order by a.name, a.comid, a.channelid
5au14t0dvnmktselect distinct a.acquireperiodid, a.acquireperiodorder, a.begintime, a.endtime from init_acquire_period a, init_acquire_pattern b, init_acquire_item_pattern c, (select distinct acquireitemid from am_ammeter_acquire_param where areacode = '50700' and priority = 1) d where a.acquireperiodid = b.acquireperiodid and c.acquirepatternid = b.acquirepatternid and c.acquireitemid = d.acquireitemid
5ngzsfstg8tmyselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5ps3p5ma94bkh MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > .5 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), (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, :B4 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M WHERE :B1 IS NOT NULL 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 (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) > (.1 * 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, :B3 SID, :B2 SERIAL#, PART#, BO# 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), (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.PART# PART#, T.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M 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 ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * 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), (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) * :B4 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M 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 ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE :B5 IS NOT NULL 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, :B3 SID, :B2 SERIAL#, PART#, BO# 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), (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# 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 WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# A ND 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 ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL 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 ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * 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, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, (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 (:B8 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 (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > .1 * 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), (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, :B4 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# 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 WHERE :B1 IS NOT NULL 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 (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * 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, :B3 SID, :B2 SERIAL#, PART#, BO# 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), (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# 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 WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# A ND 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 ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE :B5 IS NOT NULL UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (:B8 IS NOT NULL) AND :B1 IS NOT NULL 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*:B4 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.PART# PART#, I.BO# BO# FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PA RT#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND :B5 IS NOT NULL 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*:B4 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.SUBPART# PART#, I.POBJ# BO# FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (:B8 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 ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL 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, :B3 , :B2 , NEW.PART#, NEW.BO#)
632zghnbahhbhselect termid from task_timing_task where status = 2 and errtype = 2 and trytimes = 0 and areacode = '50700' group by termid
65xxzpg1hbc73select count(*) from task_timing_task where areacode = '50700'
6bmhtsgarc5urselect min(id) from dbtranssql
6pbsrf3sr1fydselect channel, avg(ratio) as ra from (select channel1 as channel, ratio1 as ratio from task_taskexec_status where channel1 != -1 and areacode = '50700' union all select channel2 as channel, ratio2 as ratio from task_taskexec_status where channel2 != -1 and areacode = '50700' union all select channel3 as channel, ratio3 as ratio from task_taskexec_status where channel3 != -1 and areacode = '50700' union all select channel4 as channel, ratio4 as ratio from task_taskexec_status where channel4 != -1 and areacode = '50700') a group by channel order by ra desc
6tym23bgd7wm5select w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:190000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:190000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10508357 order by w.termid, m.ammeterid, time, l.linetype
763007dncjtn3select w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:200000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:200000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10508719 order by w.termid, m.ammeterid, time, l.linetype
7q0nj3xgf6a80select a.taskid as taskid, a.termid as termid, a.termaddr as termaddr, a.protocoltype as protocoltype, a.datatype as datatype, a.interval as interval, a.begintime as begintime, a.endtime as endtime, a.lap as lap, a.status as status, a.errtype as errtype, a.trytimes as trytimes, a.conntrytimes as conntrytimes, a.channelid1 as channelid1, a.dispatchtime as dispatchtime, a.timeout as timeout, b.channel1 as channel1, b.ratio1 as ratio1, b.channel2 as channel2, b.ratio2 as ratio2, b.channel3 as channel3, b.ratio3 as ratio3, b.channel4 as channel4, b.ratio4 as ratio4, a.areacode as areacode from task_timing_task a, task_taskexec_status b where a.termid = b.termid and a.status = 2 and a.conntrytimes = 3 and a.areacode = '50700' and a.datatype not in (37, 38, 39, 40, 31, 32, 33)
7vc66tgtdj2qkdelete from task_timing_task a where a.status = 2 and a.conntrytimes = 3 and a.areacode = '50700' and a.datatype in (37, 38, 39, 40, 31, 32, 33)
8hq4ck26sqwc4select count(*) from task_timing_task where areacode = '50793'
8kxms920bsy53select ID, termid, ammeterid, taskday, tasktime, taskexecutecount from task_data_process_error_task order by termid, ammeterid, taskday
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
96p427nmc6m53select w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507469 order by w.termid, m.ammeterid, time, l.linetype
ajwmu7kj8nc3pselect w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507459 order by w.termid, m.ammeterid, time, l.linetype
b50u5u0549v1xselect w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:170000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507623 order by w.termid, m.ammeterid, time, l.linetype
bhkvap5pa7bmuinsert into dbtranssql values(dbtranssql_seq.nextval, 'delete from task_timing_task a where a.status = 2 and a.conntrytimes = 3 and a.areacode = ''50793'' and a.datatype in (37, 38, 39, 40, 31, 32, 33)')
cp3m11q3jbcu5select count(*) from task_timing_task where areacode = '50794'
csr21n8234jnfselect w.termid, m.ammeterid, l.linetype, w.totalvalue, w.apexvalue, w.smoothvalue, w.valevalue, w.tinevalue, to_char(w.time, 'yyyymmdd hh24miss') as time, w.totalstatus, w.apexstatus, w.smoothstatus, w.valestatus, w.tinestatus, m.formid, w.batchno from data_windowvalue partition(PAR20130110) w, am_line_info l, am_ammeter_info m where w.ilineid = l.lineid and l.ammeterid = m.ammeterid and m.qcombineflag = 1 and l.linetype in ('Q1', 'Q2', 'Q3', 'Q4') and w.time >= to_Date('20130110:180000', 'YYYYMMDD:HH24MISS') and w.time <= to_Date('20130110:180000', 'YYYYMMDD:HH24MISS')+1/24 and w.batchno = 10507985 order by w.termid, m.ammeterid, time, l.linetype
d2nqyczp27rg8select * from (select a.taskid, a.id, a.type, a.priority, a.timestart, a.timeend from object_task a order by a.priority, a.timestart asc ) where rownum = 1
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fvsvt0v8srj08SELECT DISTINCT(COMPOSITE) FROM DBA_IND_PARTITIONS WHERE INDEX_OWNER = :B2 AND INDEX_NAME = :B1
fyrbzparfb4gbSELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, TABLESPACE_ID FROM SYS_DBA_SEGS WHERE SEGMENT_OBJD = :B1
gyg2rzjbgncwrselect termid from task_timing_task where status = 2 and ((errtype = 2 and trytimes = 1) or (errtype = 1)) and conntrytimes < 3 and areacode = '50700' group by termid

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 809,453 56.19 1.57
CPU used when call started 586,324 40.70 1.14
CR blocks created 2,140,114 148.55 4.16
Cached Commit SCN referenced 618 0.04 0.00
Commit SCN cached 4 0.00 0.00
DB time 4,288,223 297.65 8.34
DBWR checkpoint buffers written 261,575 18.16 0.51
DBWR checkpoints 17 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 4,084 0.28 0.01
DBWR undo block writes 162,480 11.28 0.32
IMU CR rollbacks 3,097 0.21 0.01
IMU Flushes 222,799 15.46 0.43
IMU Redo allocation size 773,337,652 53,678.63 1,503.55
IMU commits 272,006 18.88 0.53
IMU contention 145,914 10.13 0.28
IMU ktichg flush 3 0.00 0.00
IMU pool not allocated 19,675 1.37 0.04
IMU recursive-transaction flush 38 0.00 0.00
IMU undo allocation size 1,576,812,488 109,449.13 3,065.70
IMU- failed to get a private strand 19,675 1.37 0.04
Misses for writing mapping 0 0.00 0.00
SMON posted for undo segment shrink 178 0.01 0.00
SQL*Net roundtrips to/from client 5,509,103 382.40 10.71
active txn count during cleanout 27,475,832 1,907.14 53.42
application wait time 16,009 1.11 0.03
background checkpoints completed 17 0.00 0.00
background checkpoints started 17 0.00 0.00
background timeouts 46,070 3.20 0.09
branch node splits 50 0.00 0.00
buffer is not pinned count 588,400,224 40,841.82 1,143.99
buffer is pinned count 4,315,461,792 299,543.25 8,390.29
bytes received via SQL*Net from client 1,262,587,641 87,638.27 2,454.77
bytes sent via SQL*Net to client 887,637,918 61,612.40 1,725.78
calls to get snapshot scn: kcmgss 8,464,963 587.57 16.46
calls to kcmgas 2,863,703 198.77 5.57
calls to kcmgcs 16,027,500 1,112.49 31.16
change write time 9,899 0.69 0.02
cleanout - number of ktugct calls 17,690,080 1,227.90 34.39
cleanouts and rollbacks - consistent read gets 1,628,544 113.04 3.17
cleanouts only - consistent read gets 11,401 0.79 0.02
cluster key scan block gets 1,351,815 93.83 2.63
cluster key scans 1,325,875 92.03 2.58
commit batch/immediate performed 1,921 0.13 0.00
commit batch/immediate requested 1,921 0.13 0.00
commit cleanout failures: block lost 214 0.01 0.00
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 8,475 0.59 0.02
commit cleanout failures: cannot pin 74,369 5.16 0.14
commit cleanouts 1,922,393 133.44 3.74
commit cleanouts successfully completed 1,839,334 127.67 3.58
commit immediate performed 1,921 0.13 0.00
commit immediate requested 1,921 0.13 0.00
commit txn count during cleanout 338,481 23.49 0.66
concurrency wait time 1,200,955 83.36 2.33
consistent changes 141,294,094 9,807.45 274.71
consistent gets 1,085,259,675 75,329.65 2,110.00
consistent gets - examination 197,097,203 13,680.84 383.20
consistent gets direct 0 0.00 0.00
consistent gets from cache 1,085,259,693 75,329.65 2,110.00
current blocks converted for CR 10 0.00 0.00
cursor authentications 20,273 1.41 0.04
data blocks consistent reads - undo records applied 141,279,623 9,806.45 274.68
db block changes 17,612,911 1,222.54 34.24
db block gets 41,047,885 2,849.20 79.81
db block gets direct 69 0.00 0.00
db block gets from cache 41,047,816 2,849.20 79.81
deferred (CURRENT) block cleanout applications 451,570 31.34 0.88
dirty buffers inspected 19,526 1.36 0.04
enqueue conversions 3,115 0.22 0.01
enqueue deadlocks 0 0.00 0.00
enqueue releases 4,863,279 337.57 9.46
enqueue requests 4,863,306 337.57 9.46
enqueue timeouts 20 0.00 0.00
enqueue waits 57,573 4.00 0.11
exchange deadlocks 3,669 0.25 0.01
execute count 3,702,049 256.97 7.20
failed probes on index block reclamation 166 0.01 0.00
free buffer inspected 313,503 21.76 0.61
free buffer requested 2,284,899 158.60 4.44
heap block compress 1,345,143 93.37 2.62
hot buffers moved to head of LRU 267,820 18.59 0.52
immediate (CR) block cleanout applications 1,639,945 113.83 3.19
immediate (CURRENT) block cleanout applications 70,707 4.91 0.14
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 41,284 2.87 0.08
index fast full scans (full) 29 0.00 0.00
index fetch by key 14,750,675 1,023.87 28.68
index scans kdiixs1 552,242 38.33 1.07
leaf node 90-10 splits 5,006 0.35 0.01
leaf node splits 12,595 0.87 0.02
lob reads 1,406 0.10 0.00
lob writes 283 0.02 0.00
lob writes unaligned 283 0.02 0.00
logons cumulative 887 0.06 0.00
messages received 542,984 37.69 1.06
messages sent 542,984 37.69 1.06
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 880,917,103 61,145.89 1,712.71
opened cursors cumulative 3,688,665 256.04 7.17
parse count (failures) 9 0.00 0.00
parse count (hard) 2,497,262 173.34 4.86
parse count (total) 3,676,598 255.20 7.15
parse time cpu 75,033 5.21 0.15
parse time elapsed 1,386,665 96.25 2.70
physical read IO requests 19,573 1.36 0.04
physical read bytes 194,756,608 13,518.37 378.65
physical read total IO requests 29,421 2.04 0.06
physical read total bytes 355,099,648 24,648.05 690.40
physical read total multi block requests 493 0.03 0.00
physical reads 23,774 1.65 0.05
physical reads cache 23,536 1.63 0.05
physical reads cache prefetch 4,484 0.31 0.01
physical reads direct 238 0.02 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 67,173 4.66 0.13
physical write bytes 2,508,382,208 174,110.91 4,876.90
physical write total IO requests 658,679 45.72 1.28
physical write total bytes 6,195,685,376 430,052.64 12,045.89
physical write total multi block requests 571,516 39.67 1.11
physical writes 306,199 21.25 0.60
physical writes direct 307 0.02 0.00
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 305,892 21.23 0.59
physical writes non checkpoint 127,547 8.85 0.25
pinned buffers inspected 80 0.01 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 14,403 1.00 0.03
recursive aborts on index block reclamation 4 0.00 0.00
recursive calls 6,482,477 449.96 12.60
recursive cpu usage 276,986 19.23 0.54
redo blocks written 6,649,442 461.55 12.93
redo buffer allocation retries 246 0.02 0.00
redo entries 8,623,312 598.56 16.77
redo log space requests 407 0.03 0.00
redo log space wait time 232 0.02 0.00
redo ordering marks 136,349 9.46 0.27
redo size 3,163,519,992 219,585.09 6,150.64
redo subscn max counts 192,439 13.36 0.37
redo synch time 48,387 3.36 0.09
redo synch writes 518,669 36.00 1.01
redo wastage 130,816,936 9,080.22 254.34
redo write time 27,336 1.90 0.05
redo writer latching time 146 0.01 0.00
redo writes 491,281 34.10 0.96
rollback changes - undo records applied 241,004 16.73 0.47
rollbacks only - consistent read gets 512,513 35.57 1.00
rows fetched via callback 11,427,063 793.17 22.22
session connect time 0 0.00 0.00
session cursor cache hits 791,974 54.97 1.54
session logical reads 1,126,307,744 78,178.86 2,189.81
session pga memory 486,415,632 33,762.90 945.71
session pga memory max 1,128,782,448 78,350.63 2,194.62
session uga memory ############### 76,022,963.88 2,129,424.44
session uga memory max 735,398,368 51,045.20 1,429.79
shared hash latch upgrades - no wait 67,336 4.67 0.13
shared hash latch upgrades - wait 1,168 0.08 0.00
sorts (memory) 248,717 17.26 0.48
sorts (rows) 18,995,942 1,318.54 36.93
sql area evicted 2,495,728 173.23 4.85
sql area purged 11 0.00 0.00
summed dirty queue length 28,551 1.98 0.06
switch current to new buffer 3,361 0.23 0.01
table fetch by rowid 2,442,468,363 169,535.72 4,748.74
table fetch continued row 513 0.04 0.00
table scan blocks gotten 218,127,691 15,140.60 424.09
table scan rows gotten 28,098,410,962 1,950,356.59 54,630.03
table scans (long tables) 1 0.00 0.00
table scans (short tables) 851,619 59.11 1.66
total number of times SMON posted 178 0.01 0.00
transaction rollbacks 1,921 0.13 0.00
transaction tables consistent read rollbacks 5 0.00 0.00
transaction tables consistent reads - undo records applied 86 0.01 0.00
undo change vector size 1,179,505,556 81,871.41 2,293.24
user I/O wait time 485 0.03 0.00
user calls 8,945,458 620.92 17.39
user commits 514,336 35.70 1.00
user rollbacks 4 0.00 0.00
workarea executions - optimal 252,567 17.53 0.49
write clones created in background 0 0.00 0.00
write clones created in foreground 554 0.04 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 1,409,113 1,419,543
opened cursors current 533 625
workarea memory allocated 2,419 2,419
logons current 614 617

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 17 4.25

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)
COM3000 13,215 1 0.23 1.00 36,166 3 113,826 3.27
UNDOTBS1 119 0 0.17 1.00 29,122 2 16,612 0.57
SYSAUX 1,185 0 0.46 2.10 1,404 0 0 0.00
SYSTEM 1,364 0 0.32 1.96 477 0 11 0.00
USERS 17 0 0.59 1.00 17 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
COM3000 /home/oracle/oradata/com3000/com3000_1.dbf 3,003 0 0.40 1.00 12,718 1 109,696 3.27
COM3000 /home/oracle/oradata/com3000/com3000_10.dbf 910 0 0.08 1.00 1,847 0 9 1.11
COM3000 /home/oracle/oradata/com3000/com3000_2.dbf 1,568 0 0.20 1.00 2,951 0 648 0.65
COM3000 /home/oracle/oradata/com3000/com3000_3.dbf 1,333 0 0.15 1.00 2,377 0 25 40.00
COM3000 /home/oracle/oradata/com3000/com3000_4.dbf 1,916 0 0.18 1.00 5,393 0 9 80.00
COM3000 /home/oracle/oradata/com3000/com3000_5.dbf 764 0 0.27 1.00 1,914 0 2,252 2.99
COM3000 /home/oracle/oradata/com3000/com3000_6.dbf 582 0 0.70 1.00 2,416 0 1,057 0.22
COM3000 /home/oracle/oradata/com3000/com3000_7.dbf 1,546 0 0.09 1.00 2,861 0 19 253.68
COM3000 /home/oracle/oradata/com3000/com3000_8.dbf 655 0 0.15 1.00 2,022 0 31 1.61
COM3000 /home/oracle/oradata/com3000/com3000_9.dbf 938 0 0.06 1.00 1,667 0 80 0.13
SYSAUX /home/oracle/oradata/com3000/sysaux01.dbf 1,185 0 0.46 2.10 1,404 0 0 0.00
SYSTEM /home/oracle/oradata/com3000/system01.dbf 1,364 0 0.32 1.96 477 0 11 0.00
UNDOTBS1 /home/oracle/oradata/com3000/undotbs01.dbf 119 0 0.17 1.00 29,122 2 16,612 0.57
USERS /home/oracle/oradata/com3000/users01.dbf 17 0 0.59 1.00 17 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 166,236 100 1,125,644,350 20,992 305,892 0 0 130,457


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 14 653 4279 1474560 1474560 1581304  
E 0 14 834 6042 1474560 1474560 1663991  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 128 0.09 15,832 22.48 176,757,553
D 256 0.19 31,664 6.70 52,688,387
D 384 0.28 47,496 1.78 13,989,006
D 512 0.38 63,328 1.19 9,380,239
D 640 0.47 79,160 1.06 8,361,405
D 768 0.56 94,992 1.03 8,073,223
D 896 0.66 110,824 1.01 7,968,468
D 1,024 0.75 126,656 1.00 7,896,806
D 1,152 0.85 142,488 1.00 7,874,320
D 1,280 0.94 158,320 1.00 7,864,831
D 1,360 1.00 168,215 1.00 7,861,676
D 1,408 1.04 174,152 1.00 7,858,992
D 1,536 1.13 189,984 1.00 7,855,325
D 1,664 1.22 205,816 1.00 7,852,892
D 1,792 1.32 221,648 1.00 7,850,755
D 1,920 1.41 237,480 1.00 7,849,151
D 2,048 1.51 253,312 1.00 7,847,609
D 2,176 1.60 269,144 1.00 7,846,505
D 2,304 1.69 284,976 1.00 7,845,815
D 2,432 1.79 300,808 1.00 7,845,274
D 2,560 1.88 316,640 0.62 4,906,994

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 47,088 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 2,342 1,759 816.29 2.36 0.29 100.00 0.00 239,820
E 2,342 1,752 869.82 2.36 0.27 100.00 0.00 239,820

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 217,052 217,052 0 0
64K 128K 480 480 0 0
128K 256K 234 234 0 0
256K 512K 210 210 0 0
512K 1024K 880 880 0 0
1M 2M 33,705 33,705 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
293 0.13 4,150,691.70 232,153.08 95.00 41,946
586 0.25 4,150,691.70 0.00 100.00 0
1,171 0.50 4,150,691.70 0.00 100.00 0
1,757 0.75 4,150,691.70 0.00 100.00 0
2,342 1.00 4,150,691.70 0.00 100.00 0
2,810 1.20 4,150,691.70 0.00 100.00 0
3,279 1.40 4,150,691.70 0.00 100.00 0
3,747 1.60 4,150,691.70 0.00 100.00 0
4,216 1.80 4,150,691.70 0.00 100.00 0
4,684 2.00 4,150,691.70 0.00 100.00 0
7,026 3.00 4,150,691.70 0.00 100.00 0
9,368 4.00 4,150,691.70 0.00 100.00 0
14,052 6.00 4,150,691.70 0.00 100.00 0
18,736 8.00 4,150,691.70 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,600 0.28 653 118,871 1,334,779 0.97 1,467,865 1.03 443,002,368
2,176 0.39 1,228 162,116 1,356,347 0.99 1,446,297 1.01 444,018,088
2,752 0.49 1,799 210,191 1,363,873 0.99 1,438,771 1.01 444,576,959
3,328 0.59 2,373 264,168 1,367,639 1.00 1,435,005 1.00 444,875,720
3,904 0.69 2,948 310,037 1,369,327 1.00 1,433,317 1.00 445,085,318
4,480 0.80 3,523 357,982 1,370,913 1.00 1,431,731 1.00 445,251,907
5,056 0.90 4,098 402,530 1,371,486 1.00 1,431,158 1.00 445,396,603
5,632 1.00 4,673 452,562 1,372,069 1.00 1,430,575 1.00 445,519,775
6,208 1.10 5,248 498,989 1,376,633 1.00 1,426,011 1.00 445,621,632
6,784 1.20 5,823 553,077 1,377,075 1.00 1,425,569 1.00 445,706,344
7,360 1.31 6,398 594,987 1,377,448 1.00 1,425,196 1.00 445,768,085
7,936 1.41 6,973 645,669 1,377,735 1.00 1,424,909 1.00 445,823,817
8,512 1.51 7,548 693,045 1,377,874 1.00 1,424,770 1.00 445,872,412
9,088 1.61 8,123 744,093 1,377,968 1.00 1,424,676 1.00 445,931,886
9,664 1.72 8,698 795,318 1,378,068 1.00 1,424,576 1.00 446,023,421
10,240 1.82 9,273 841,914 1,378,205 1.00 1,424,439 1.00 446,200,298
10,816 1.92 9,848 893,639 1,379,853 1.01 1,422,791 0.99 446,510,165
11,392 2.02 10,420 942,491 1,447,981 1.06 1,354,663 0.95 446,981,779

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,760 0.25 2,948,076 171,925,959
3,520 0.50 2,790,575 7,851,325
5,280 0.75 2,783,630 7,851,325
7,040 1.00 2,777,797 7,851,325
8,800 1.25 2,776,130 4,772,820
10,560 1.50 2,775,019 4,772,820
12,320 1.75 2,708,352 7,749,258
14,080 2.00 2,706,685 4,772,820

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 111,716 371 3
undo header 15,680 9 1
1st level bmb 1,989 1 1
undo block 924 0 0
2nd level bmb 127 0 0
segment header 4 0 0
file header block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 99,739 99,739 0 37,518 219 5.83
TX-Transaction (index contention) 20,361 20,361 0 20,047 68 3.40
TX-Transaction 600,253 600,478 0 3 0 3.67
TX-Transaction (row lock contention) 3 3 0 3 0 0.67
HW-Segment High Water Mark 3,901 3,901 0 2 0 1.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 158.89 600,410 326 66 15/18.15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
10-1? 21:57 4,219 26,459 145 5 15 0/0 0/0/0/0/0/0
10-1? 21:47 36,671 118,654 42 65 15 0/0 0/0/0/0/0/0
10-1? 21:37 161 793 143 4 15 0/0 0/0/0/0/0/0
10-1? 21:27 159 836 0 3 15 0/0 0/0/0/0/0/0
10-1? 21:17 185 1,277 160 3 15 0/0 0/0/0/0/0/0
10-1? 21:07 375 1,313 326 3 17 0/0 0/0/0/0/0/0
10-1? 20:57 4,063 28,134 115 4 15 0/0 0/0/0/0/0/0
10-1? 20:47 34,116 115,722 78 66 15 0/0 0/0/0/0/0/0
10-1? 20:37 164 823 0 3 15 0/0 0/0/0/0/0/0
10-1? 20:27 175 861 0 3 15 0/0 0/0/0/0/0/0
10-1? 20:17 1,412 5,958 0 7 15 0/0 0/0/0/0/0/0
10-1? 20:07 363 1,349 317 3 17 0/0 0/0/0/0/0/0
10-1? 19:57 4,420 24,246 0 4 15 0/0 0/0/0/0/0/0
10-1? 19:47 32,251 116,774 142 62 15 0/0 0/0/0/0/0/0
10-1? 19:37 176 833 0 3 15 0/0 0/0/0/0/0/0
10-1? 19:27 156 721 0 3 15 0/0 0/0/0/0/0/0
10-1? 19:17 179 1,071 0 3 15 0/0 0/0/0/0/0/0
10-1? 19:07 346 1,403 308 3 18 0/0 0/0/0/0/0/0
10-1? 18:57 2,876 27,586 113 4 15 0/0 0/0/0/0/0/0
10-1? 18:47 34,219 116,568 105 62 15 0/0 0/0/0/0/0/0
10-1? 18:37 186 833 0 3 15 0/0 0/0/0/0/0/0
10-1? 18:27 177 861 70 3 15 0/0 0/0/0/0/0/0
10-1? 18:17 176 805 0 3 15 0/0 0/0/0/0/0/0
10-1? 18:07 1,660 6,530 299 7 18 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 10,220 0.00   0 0  
AWR Alerted Metric Element list 182,296 0.00   0 0  
Consistent RBA 491,433 0.02 0.00 0 0  
FOB s.o list latch 1,284 0.55 0.00 0 0  
In memory undo latch 6,160,585 0.33 0.66 9 531,480 0.00
JS Sh mem access 2 0.00   0 0  
JS mem alloc latch 40 0.00   0 0  
JS queue access latch 40 0.00   0 0  
JS queue state obj latch 104,276 0.00   0 0  
JS slv state obj latch 3,707 0.00   0 0  
KMG MMAN ready and startup request latch 4,803 0.00   0 0  
KTF sga latch 31 0.00   0 4,130 0.00
MQL Tracking Latch 0     0 286 0.00
Memory Management Latch 0     0 4,803 0.00
OS process 2,001 0.00   0 0  
OS process allocation 6,139 0.28 0.00 0 0  
OS process: request allocation 1,261 0.40 0.00 0 0  
PL/SQL warning settings 1,472 0.00   0 0  
SGA IO buffer pool latch 2,097 0.00   0 2,097 0.00
SQL memory manager latch 4 0.00   0 4,798 0.00
SQL memory manager workarea list latch 950,146 0.00 0.00 0 0  
active checkpoint queue latch 55,859 0.00   0 0  
active service list 33,157 0.17 0.00 0 5,073 0.00
archive control 34 0.00   0 0  
begin backup scn array 5 0.00   0 0  
cache buffer handles 11,675 0.04 0.00 0 0  
cache buffers chains 2,382,749,026 0.29 0.00 38 1,825,821 1.73
cache buffers lru chain 621,488 0.04 0.01 0 4,406,927 0.23
cache table scan latch 0     0 333 0.00
channel handle pool latch 1,261 0.16 0.00 0 0  
channel operations parent latch 72,265 0.00 0.00 0 0  
checkpoint queue latch 1,341,559 0.00 0.00 0 303,259 0.00
client/application info 9,723 0.00   0 0  
compile environment latch 887 0.00   0 0  
dictionary lookup 1 0.00   0 0  
dml lock allocation 3,041,225 0.42 0.01 0 0  
dummy allocation 1,771 0.85 0.00 0 0  
enqueue hash chains 9,789,482 0.20 0.03 2 5,057 0.08
enqueues 6,110,436 0.61 0.02 2 0  
event group latch 632 0.00   0 0  
file cache latch 1,606 0.00   0 0  
global KZLD latch for mem in SGA 613 0.00   0 0  
hash table column usage latch 1,838 0.00   0 12,119,300 0.00
hash table modification latch 353 0.00   0 0  
job workq parent latch 0     0 514 0.00
job_queue_processes parameter latch 495 0.00   0 0  
kks stats 12,699,285 2.41 0.40 395 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 247 0.00   0 0  
ksuosstats global area 968 0.00   0 0  
ktm global data 569 0.00   0 0  
lgwr LWN SCN 493,465 0.15 0.00 0 0  
library cache 108,889,502 3.20 0.33 10442 3,027,486 86.93
library cache load lock 6,786 0.00   0 0  
library cache lock 32,516,432 0.38 0.02 10 0  
library cache lock allocation 10,454 0.03 0.00 0 0  
library cache pin 32,852,648 0.24 0.02 7 0  
library cache pin allocation 136,663 0.02 0.03 0 0  
list of block allocation 36,779 0.02 0.00 0 0  
loader state object freelist 212 0.00   0 0  
longop free list parent 1 0.00   0 1 0.00
messages 1,716,099 0.05 0.01 0 0  
mostly latch-free SCN 499,874 1.42 0.00 0 0  
multiblock read objects 1,306 0.00   0 0  
ncodef allocation latch 241 0.00   0 0  
object queue header heap 224,585 0.00   0 513 0.00
object queue header operation 1,419,856 0.01 0.01 0 0  
object stats modification 6 0.00   0 0  
parallel query alloc buffer 1,920 0.00   0 0  
parameter list 6,320 0.00   0 0  
parameter table allocation management 897 7.92 0.00 0 0  
post/wait queue 755,305 0.01 0.03 0 519,308 0.08
process allocation 1,261 0.24 0.67 0 631 0.16
process group creation 1,261 0.95 0.00 0 0  
redo allocation 2,633,427 0.17 0.05 0 8,610,071 0.74
redo copy 0     0 8,623,415 0.27
redo writing 1,625,884 0.00 0.02 0 0  
resmgr group change latch 2,130 0.00   0 0  
resmgr:active threads 1,759 0.00   0 0  
resmgr:actses change group 870 0.00   0 0  
resmgr:free threads list 1,755 1.88 0.00 0 0  
resmgr:schema config 4 0.00   0 0  
row cache objects 134,025,957 2.68 0.00 51 3,699 12.87
sequence cache 3,950,502 0.56 0.01 1 0  
session allocation 2,453,743 0.41 0.00 0 0  
session idle bit 18,715,915 0.03 0.02 0 0  
session state list latch 614 0.00   0 0  
session switching 241 0.00   0 0  
session timer 5,073 0.00   0 0  
shared pool 102,897,642 6.94 0.12 1008 0  
shared pool simulator 68,776,291 0.07 0.01 17 0  
simulator hash latch 70,054,488 0.00 0.01 0 0  
simulator lru latch 305,892 0.19 0.00 0 69,737,305 0.44
slave class 8 0.00   0 0  
slave class create 32 12.50 1.00 1 0  
sort extent pool 537 0.00   0 0  
state object free list 8 0.00   0 0  
statistics aggregation 2,240 0.00   0 0  
temp lob duration state obj allocation 1 0.00   0 0  
temporary table state object allocation 1 0.00   0 0  
threshold alerts latch 620 0.00   0 0  
transaction allocation 7,999 0.03 0.00 0 0  
transaction branch allocation 5,073 0.00   0 0  
undo global data 33,435,881 2.92 0.00 5 0  
user lock 2,964 4.42 0.02 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
shared pool 102,897,642 7,143,031 863,510 6,363,895 0 0 0
cache buffers chains 2,382,749,026 6,998,596 11,083 6,994,481 0 0 0
row cache objects 134,025,957 3,597,527 11,624 3,586,008 0 0 0
library cache 108,889,502 3,488,141 1,152,690 2,428,500 0 0 0
undo global data 33,435,881 976,545 1,548 975,037 0 0 0
kks stats 12,699,285 305,928 121,302 194,802 0 0 0
library cache lock 32,516,432 122,384 2,304 120,090 0 0 0
library cache pin 32,852,648 77,662 1,711 75,959 0 0 0
shared pool simulator 68,776,291 44,782 566 44,224 0 0 0
enqueues 6,110,436 37,090 630 36,461 0 0 0
sequence cache 3,950,502 22,226 161 22,067 0 0 0
In memory undo latch 6,160,585 20,037 13,134 6,961 0 0 0
enqueue hash chains 9,789,482 19,411 577 18,837 0 0 0
dml lock allocation 3,041,225 12,784 67 12,717 0 0 0
session allocation 2,453,743 10,157 24 10,133 0 0 0
session idle bit 18,715,915 5,901 97 5,804 0 0 0
redo allocation 2,633,427 4,511 210 4,303 0 0 0
simulator hash latch 70,054,488 1,277 19 1,259 0 0 0
messages 1,716,099 924 8 916 0 0 0
simulator lru latch 305,892 575 1 574 0 0 0
cache buffers lru chain 621,488 239 2 237 0 0 0
user lock 2,964 131 2 129 0 0 0
object queue header operation 1,419,856 94 1 93 0 0 0
post/wait queue 755,305 89 3 86 0 0 0
redo writing 1,625,884 53 1 52 0 0 0
library cache pin allocation 136,663 30 1 29 0 0 0
slave class create 32 4 4 0 0 0 0
process allocation 1,261 3 2 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 9,146 13,982
In memory undo latch kticmt: child 0 6,652 2,446
In memory undo latch ktichg: child 0 1,045 389
In memory undo latch kturbk 0 4 31
active service list ksws_event: ksws event 0 26 26
cache buffers chains kcbgtcr: kslbegin excl 0 21,494 3,254
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 12,230 24,539
cache buffers chains kcbgcur: kslbegin 0 2,495 4,165
cache buffers chains kcbrls: kslbegin 0 2,138 1,148
cache buffers chains kcbchg: kslbegin: call CR func 0 1,397 6,889
cache buffers chains kcbgtcr: fast path 0 985 799
cache buffers chains kcbget: pin buffer 0 372 509
cache buffers chains kcbget: exchange rls 0 238 17
cache buffers chains kcbget: exchange 0 152 42
cache buffers chains kcbzgb: scan from tail. nowait 0 85 0
cache buffers chains kcbzwb 0 71 116
cache buffers chains kcbnlc 0 37 36
cache buffers chains kcbcge 0 16 83
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 11 0
cache buffers chains kcb_pre_apply: kcbhq61 0 6 11
cache buffers chains kcbesc: escalate 0 6 0
cache buffers chains kcbnew: new latch again 0 6 0
cache buffers chains kcb_post_apply: kcbhq62 0 3 1
cache buffers chains kcbso1: set no access 0 3 3
cache buffers chains kcb_is_private 0 2 153
cache buffers lru chain kcbzgws 0 2 0
cost function kzulgt: find user res 0 2 2
dml lock allocation ktaiam 0 47 53
dml lock allocation ktaidm 0 20 14
enqueue hash chains ksqrcl 0 306 134
enqueue hash chains ksqgtl3 0 242 256
enqueue hash chains ksqcmi: get hash chain latch after wait 0 29 187
enqueues ksqgel: create enqueue 0 299 326
enqueues ksqdel 0 244 223
enqueues ksqies 0 86 81
enqueues ksqgtl2 0 1 0
kks stats kks stats alloc/free 0 121,300 121,300
library cache kglpndl: child: after processing 0 293,035 3,340
library cache kglobpn: child: 0 189,474 306,259
library cache kgldti: 2child 0 181,675 59,702
library cache kglpin 0 113,862 25,905
library cache kglukp: child 0 99,307 120,723
library cache kglhdgn: child: 0 37,945 255,101
library cache kgldte: child 0 0 36,387 50,901
library cache kglhdgc: child: 0 14,088 3,861
library cache kglpndl: child: before processing 0 10,820 151,153
library cache kglLockCursor 0 10,016 478
library cache kglobld 0 2,402 8,425
library cache kglati 0 670 13
library cache lock kgllkdl: child: no lock handle 0 101,077 133,457
library cache lock kgllkdl: child: cleanup 0 1,224 791
library cache lock kgllkal: child: multiinstance 0 952 1,511
library cache lock kglget: un-set reserved lock 0 128 2
library cache pin kglpndl 0 1,048 535
library cache pin kglpnal: child: alloc space 0 663 1,176
library cache pin allocation kglpnrel 0 1 0
messages ksaamb: after wakeup 0 6 5
messages ksarcv: after wait 0 2 1
object queue header operation kcbo_switch_cq 0 1 0
post/wait queue ksliwat:add:nowait 0 2 0
post/wait queue ksliwat:remove 0 1 0
process allocation ksucrp 0 2 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 189 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 12 60
redo allocation kcrfw_redo_write: more space 0 6 87
redo allocation kcrfw_redo_write: before write 0 3 63
redo writing kcrfw_post: after write 0 1 0
row cache objects kqreqd: reget 0 10,171 95
row cache objects kqrpre: find obj 0 1,060 11,236
row cache objects kqreqd 0 275 244
row cache objects kqrso 0 114 49
sequence cache kdnssd 0 129 0
sequence cache kdnnxt: cached seq 0 26 8
sequence cache kdnss 0 6 152
session allocation ksucri 0 12 15
session allocation ksuxds: not user session 0 6 6
session allocation ksufap: active sessions 0 3 0
session allocation ksuxds: KSUSFCLC not set 0 2 3
session allocation ksudlp 0 1 0
session idle bit ksupuc: set busy 0 63 30
session idle bit ksupuc: clear busy 0 44 77
session idle bit ksuxds 0 9 9
shared pool kghalo 0 416,618 345,959
shared pool kghupr1 0 158,359 227,721
shared pool kghfrunp: alloc: session dur 0 122,247 7,620
shared pool kghalp 0 109,558 185,874
shared pool kghfre 0 40,553 42,142
shared pool kghfrunp: clatch: nowait 0 39,237 0
shared pool kghfrunp: clatch: wait 0 22,678 33,352
shared pool kghasp 0 16,157 54,168
shared pool kghfree_extents: scan 0 6 18
shared pool kghfen: not perm alloc class 0 1 2
shared pool simulator kglsim_unpin_simhp 0 256 149
shared pool simulator kglsim_upd_newhp 0 236 153
shared pool simulator kglsim_unpin_simhp: fast path 0 40 144
shared pool simulator kglsim_scan_lru: scan 0 26 110
shared pool simulator kglsim_chg_simhp_free 0 7 5
shared pool simulator kglsim_chg_simhp_noob 0 1 5
simulator hash latch kcbsacc: lookup dba 0 19 18
simulator lru latch kcbs_simulate: simulate set 0 1 0
slave class create ksvcreate 0 4 0
undo global data ktudba: KSLBEGIN 0 1,535 1,529
undo global data ktubnd:child 0 10 1
undo global data ktudnx:child 0 3 6

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
COM3K COM3000 DATA_WINDOWVALUE AR20130110 TABLE PARTITION 563,714,304 50.05
COM3K COM3000 IDX_WINDOWVALUE_TIME AR20130110 INDEX PARTITION 76,549,760 6.80
COM3K COM3000 TASK_TIMING_TASK   TABLE 76,021,296 6.75
COM3K COM3000 TASK_INSTANT_TASK   TABLE 57,974,064 5.15
COM3K COM3000 TASK_DATA_PROCESS_TASK   TABLE 56,293,744 5.00

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
COM3K COM3000 DATA_WINDOWVALUE AR20130110 TABLE PARTITION 4,338 18.25
COM3K COM3000 DBTRANSSQL   TABLE 3,139 13.20
COM3K COM3000 IDX_WINDOWVALUE_TIME AR20130110 INDEX PARTITION 1,680 7.07
COM3K COM3000 PK_WINDOWVALUE_IDX AR20130110 INDEX PARTITION 1,395 5.87
SYS SYSAUX WRI$_ADV_OBJECTS   TABLE 885 3.72

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
COM3K COM3000 PK_DBTRANSSQL   INDEX 20,341 99.23
COM3K COM3000 IDX_WINDOWVALUE_TIME AR20130110 INDEX PARTITION 83 0.40
COM3K COM3000 PK_WINDOWVALUE_IDX AR20130110 INDEX PARTITION 36 0.18
COM3K COM3000 PK_SYS_NETUSABLE_STATUS   INDEX 24 0.12
COM3K COM3000 PK_AMMETERSTATUS_IDX AR20130110 INDEX PARTITION 7 0.03

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
COM3K COM3000 PK_DBTRANSSQL   INDEX 64,790 57.26
COM3K COM3000 DBTRANSSQL   TABLE 42,796 37.82
COM3K COM3000 TASK_TIMING_TASK   TABLE 3,072 2.72
COM3K COM3000 DATA_AMMETERSTATUSVALUE AR20130110 TABLE PARTITION 1,278 1.13
COM3K COM3000 PK_AMMETERSTATUS_IDX AR20130110 INDEX PARTITION 460 0.41

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 260 0.00 0   8 1
dc_database_links 1,234 0.00 0   0 1
dc_global_oids 1,242 4.75 0   0 31
dc_histogram_data 12,112,753 0.01 0   0 1,636
dc_histogram_defs 9,187,448 0.07 0   7 1,942
dc_object_grants 12 33.33 0   0 6
dc_object_ids 14,659,815 0.00 0   1 584
dc_objects 4,971,295 0.01 0   25 538
dc_profiles 881 0.00 0   0 1
dc_rollback_segments 10,103 0.00 0   0 119
dc_segments 3,233,045 0.16 0   29 660
dc_sequences 63,093 0.01 0   63,093 5
dc_tablespace_quotas 13 0.00 0   13 1
dc_tablespaces 821,453 0.00 0   0 6
dc_usernames 11,920 0.06 0   0 44
dc_users 7,592,358 0.00 0   0 66
outstanding_alerts 168 0.00 0   0 6


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 2,850 1.54 3,689 1.22 0 0
CLUSTER 81 1.23 194 1.55 2 0
INDEX 2,062 3.78 2,003,719 0.00 12 0
SQL AREA 5,386,949 92.51 9,020,250 83.05 5,179 6
TABLE/PROCEDURE 49,845 1.05 16,315,012 0.01 1,855 0
TRIGGER 141 3.55 407 1.23 0 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 465.06   0.75 0.89 22 24 616 616
  Freeable 341.56 0.00 0.77 0.34 5   444 444
  SQL 8.01 4.81 0.01 0.10 2 7 609 445
  PL/SQL 1.57 0.43 0.00 0.00 0 0 614 614
E Other 501.57   0.81 1.37 26 26 619 619
  Freeable 357.44 0.00 0.79 0.44 7   454 454
  SQL 9.05 5.34 0.01 0.10 2 14 611 452
  PL/SQL 1.86 0.64 0.00 0.01 0 0 617 617

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1,409,286,144  
Fixed Size 2,095,448  
Redo Buffers 14,680,064  
Variable Size 5,955,913,384  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 488.49 468.75 -4.04
shared Cursor Stats 89.80 89.80 0.00
shared PCursor 664.05 670.05 0.90
shared free memory 2,031.99 2,028.80 -0.16
shared kglsim heap 127.59 127.59 0.00
shared kglsim object batch 149.76 149.76 0.00
shared library cache 337.04 325.86 -3.32
shared sql area 1,445.52 1,469.04 1.63
  buffer_cache 1,344.00 1,344.00 0.00
  fixed_sga 2.00 2.00 0.00
  log_buffer 14.00 14.00 0.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

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
aq_tm_processes 0   
audit_file_dest /home/oracle/admin/com3000/adump   
background_dump_dest /home/oracle/admin/com3000/bdump   
compatible 10.2.0.1.0   
control_files /home/oracle/oradata/com3000/control01.ctl, /home/oracle/oradata/com3000/control02.ctl, /home/oracle/oradata/com3000/control03.ctl   
core_dump_dest /home/oracle/admin/com3000/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name com3000   
db_recovery_file_dest /home/oracle/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=com3000XDB)   
job_queue_processes 10   
nls_language SIMPLIFIED CHINESE   
nls_length_semantics BYTE   
nls_territory CHINA   
open_cursors 30000   
pga_aggregate_target 2455764992   
processes 3000   
remote_login_passwordfile EXCLUSIVE   
resource_manager_plan      
sessions 3305   
sga_target 7381975040   
undo_management AUTO   
undo_retention 900   
undo_tablespace UNDOTBS1   
user_dump_dest /home/oracle/admin/com3000/udump   


Back to Top

End of Report