Enter value for report_name: Using the report name awrrpt_1_7670_7673.html AWR Report for DB: UPSMDB, Inst: upsmdb, Snaps: 7670-7673

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
UPSMDB42358002upsmdb110.2.0.5.0NOITSMWF2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:767007-Jul-12 08:00:5686 18.8
End Snap:767307-Jul-12 11:00:3388 24.7
Elapsed:  179.62 (mins)  
DB Time:  327.84 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 2,464M 2,464MStd Block Size: 8K
Shared Pool Size: 2,576M 2,576MLog Buffer: 14,356K

Load Profile

Per SecondPer Transaction
Redo size: 739.02 1,957.35
Logical reads: 143,357.33 379,692.39
Block changes: 2.44 6.46
Physical reads: 1.66 4.39
Physical writes: 0.41 1.08
User calls: 117.56 311.36
Parses: 22.32 59.12
Hard parses: 0.45 1.20
Sorts: 2.25 5.95
Logons: 0.01 0.02
Executes: 23.44 62.08
Transactions: 0.38 

% Blocks changed per Read: 0.00Recursive Call %: 33.63
Rollback per transaction %: 74.66Rows per Sort: 24.92

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 95.59Soft Parse %: 97.98
Execute to Parse %: 4.78Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 60.98% Non-Parse CPU: 99.85

Shared Pool Statistics

BeginEnd
Memory Usage %: 88.45 88.15
% SQL with executions>1: 99.18 96.09
% Memory for SQL w/exec>1: 97.71 94.16

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  12,893  65.5 
control file parallel write 3,581 4 1 .0System I/O
control file sequential read 15,047 4 0 .0System I/O
db file sequential read 16,618 3 0 .0User I/O
io done 6,240 2 0 .0System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 19,590.69 99.60
DB CPU 12,893.36 65.55
parse time elapsed 31.85 0.16
hard parse elapsed time 18.02 0.09
PL/SQL execution elapsed time 0.73 0.00
hard parse (sharing criteria) elapsed time 0.63 0.00
connection management call elapsed time 0.17 0.00
PL/SQL compilation elapsed time 0.08 0.00
hard parse (bind mismatch) elapsed time 0.03 0.00
failed parse elapsed time 0.01 0.00
repeated bind elapsed time 0.00 0.00
DB time 19,670.14  
background elapsed time 49.21  
background cpu time 24.30  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     12,893   65.55
System I/O 30,473   11 0 0.06
Concurrency 3,824 3 4 1 0.02
User I/O 17,928   4 0 0.02
Network 1,080,564   2 0 0.01
Commit 1,092   1 1 0.00
Other 211 2 1 2 0.00
Application 65   0 2 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 3,581   4 1 0.88
control file sequential read 15,047   4 0 3.70
db file sequential read 16,618   3 0 4.08
io done 6,240   2 0 1.53
cursor: pin S wait on X 139 82 2 14 0.03
os thread startup 30   2 55 0.01
SQL*Net message to client 1,055,484   1 0 259.40
log file parallel write 2,471   1 0 0.61
log file sync 1,092   1 1 0.27
SQL*Net more data to client 20,792   1 0 5.11
SQL*Net more data from client 4,288   0 0 1.05
db file parallel write 3,134   0 0 0.77
latch: cache buffers chains 3,639   0 0 0.89
latch free 66   0 4 0.02
kksfbc child completion 5 80 0 44 0.00
enq: TX - row lock contention 1   0 62 0.00
local write wait 88   0 1 0.02
enq: RO - fast object reuse 22   0 1 0.01
SQL*Net break/reset to client 42   0 0 0.01
rdbms ipc reply 1   0 9 0.00
LGWR wait for redo copy 114   0 0 0.03
reliable message 22   0 0 0.01
direct path read 1,169   0 0 0.29
cursor: mutex S 9   0 0 0.00
direct path write 53   0 0 0.01
latch: session allocation 1   0 0 0.00
cursor: mutex X 3   0 0 0.00
cursor: pin S 2   0 0 0.00
latch: library cache 2   0 0 0.00
buffer busy waits 2   0 0 0.00
SQL*Net message from client 1,055,525   332,037 315 259.41
i/o slave wait 296,067 77 231,521 782 72.76
Streams AQ: qmn slave idle wait 384   10,521 27399 0.09
Streams AQ: qmn coordinator idle wait 720 54 10,521 14613 0.18
virtual circuit status 359 100 10,479 29190 0.09
Streams AQ: waiting for time management or cleanup tasks 3 100 4,960 1653461 0.00
jobq slave wait 120 100 353 2939 0.03
class slave wait 24   0 1 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 3,581   4 1 0.88
control file sequential read 7,880   2 0 1.94
io done 6,240   2 0 1.53
os thread startup 30   2 55 0.01
log file parallel write 2,471   1 0 0.61
db file parallel write 3,134   0 0 0.77
events in waitclass Other 169   0 0 0.04
direct path write 1   0 0 0.00
i/o slave wait 296,067 77 231,521 782 72.76
rdbms ipc message 36,417 95 113,052 3104 8.95
Streams AQ: qmn slave idle wait 384   10,521 27399 0.09
Streams AQ: qmn coordinator idle wait 720 54 10,521 14613 0.18
pmon timer 3,592 100 10,516 2928 0.88
smon timer 36 100 10,460 290557 0.01
Streams AQ: waiting for time management or cleanup tasks 3 100 4,960 1653461 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 131,747
AVG_IDLE_TIME 945,110
AVG_IOWAIT_TIME 4,679
AVG_SYS_TIME 5,021
AVG_USER_TIME 126,392
BUSY_TIME 2,113,441
IDLE_TIME 15,126,923
IOWAIT_TIME 80,400
SYS_TIME 85,739
USER_TIME 2,027,702
LOAD 0
OS_CPU_WAIT_TIME 11,515,740,500
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 15,728,640
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 34,179,989,504
NUM_CPUS 16
NUM_CPU_SOCKETS 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 19,666.60 12,889.90 17,828 1,544,627,667
upsmdb 3.40 3.40 0 254,086
SYS$BACKGROUND 0.00 0.00 37 67,136
upsmdbXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 17847 4 3794 2 0 0 1080010 2
upsmdb 0 0 0 0 0 0 382 0
SYS$BACKGROUND 81 0 30 2 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
13,652 8,750 107,586 0.13 69.40 3p1pdpapac3yu   select * from up_notify where ...
170 126 530 0.32 0.86 1v6xzjh36s3k3   select workSheetType, workshee...
149 111 467 0.32 0.76 f31408dszv4kh   select workSheetType, workshee...
111 83 352 0.32 0.57 bdj5vcsfkp6gc   select workSheetType, workshee...
110 81 346 0.32 0.56 gt108r1qxfh2g   select workSheetType, workshee...
106 78 327 0.32 0.54 3tfg9d6urzjup   select workSheetType, workshee...
86 63 266 0.32 0.44 g56bfpwfn5s6z   select workSheetType, workshee...
85 63 262 0.32 0.43 3p252d7ms591z   select workSheetType, workshee...
83 62 260 0.32 0.42 bupycrmgc5ggx   select workSheetType, workshee...
79 58 246 0.32 0.40 5d9c6h8pagf8x   select workSheetType, workshee...

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
8,750 13,652 107,586 0.08 67.87 69.40 3p1pdpapac3yu   select * from up_notify where ...
126 170 530 0.24 0.98 0.86 1v6xzjh36s3k3   select workSheetType, workshee...
111 149 467 0.24 0.86 0.76 f31408dszv4kh   select workSheetType, workshee...
83 111 352 0.24 0.64 0.57 bdj5vcsfkp6gc   select workSheetType, workshee...
81 110 346 0.24 0.63 0.56 gt108r1qxfh2g   select workSheetType, workshee...
78 106 327 0.24 0.60 0.54 3tfg9d6urzjup   select workSheetType, workshee...
63 86 266 0.24 0.49 0.44 g56bfpwfn5s6z   select workSheetType, workshee...
63 85 262 0.24 0.49 0.43 3p252d7ms591z   select workSheetType, workshee...
62 83 260 0.24 0.48 0.42 bupycrmgc5ggx   select workSheetType, workshee...
58 79 246 0.24 0.45 0.40 5d9c6h8pagf8x   select workSheetType, workshee...

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,234,084,702 107,586 11,470.68 79.88 8750.24 13651.52 3p1pdpapac3yu   select * from up_notify where ...
5,555,526 530 10,482.12 0.36 125.75 169.95 1v6xzjh36s3k3   select workSheetType, workshee...
4,890,310 467 10,471.76 0.32 111.21 149.32 f31408dszv4kh   select workSheetType, workshee...
4,700,332 527 8,919.04 0.30 32.17 56.25 1rhwt6d444mzf   select worksheettype, workshee...
4,700,321 527 8,919.02 0.30 32.37 56.32 gs1m1b8d7qwby   select task.worksheettype, tas...
4,120,588 462 8,919.02 0.27 27.82 48.83 93nhjb0cf3r1r   select worksheettype, workshee...
4,120,585 462 8,919.02 0.27 27.94 48.52 6bu9b1z06tvtv   select task.worksheettype, tas...
3,652,447 352 10,376.27 0.24 82.94 111.21 bdj5vcsfkp6gc   select workSheetType, workshee...
3,632,689 346 10,499.10 0.24 81.31 109.52 gt108r1qxfh2g   select workSheetType, workshee...
3,432,235 327 10,496.13 0.22 77.80 105.68 3tfg9d6urzjup   select workSheetType, workshee...

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
26 78 0.33 0.15 0.01 0.17 dv6f0zrg1f7zm   update up_ITSM_CHG set serialN...
17 1 17.00 0.10 0.01 0.02 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
16 11 1.45 0.09 0.00 0.22 2fm3yx420zd3f   update up_ITSM_INC set serialN...
0 3 0.00 0.00 0.01 0.00 0103qb611xu3g DBMS_SCHEDULER update sys.scheduler$_job set ...
0 1,246 0.00 0.00 20.96 32.79 09qmkp7yk8d04   select modlog0_.actionId as ac...
0 221 0.00 0.00 52.05 70.49 0czmfncyt5van   select workSheetType, workshee...
0 114 0.00 0.00 7.05 11.71 0djdn7u5s0rwz   select worksheettype, workshee...
0 192 0.00 0.00 0.02 0.02 0h6b2sajwb74n   select privilege#, level from ...
0 3 0.00 0.00 0.01 0.01 0ut2yw7mxf0aq   insert into WRM$_SNAPSHOT (sna...
0 6 0.00 0.00 0.02 0.01 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...

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
107,586 98 0.00 0.08 0.13 3p1pdpapac3yu   select * from up_notify where ...
16,800 16,800 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
14,854 14,854 1.00 0.00 0.00 b3ptckwgjzwb0   select groupuser0_.id as id127...
6,173 6,173 1.00 0.00 0.00 4cpndujy1w4dj   select CURRENT_DATE from dual
5,034 3,152 0.63 0.00 0.00 bubukxagjjrw4   select roleuser0_.id as id134_...
3,364 3,347 0.99 0.00 0.00 27jgnqdk36rjx   select dictionary0_.id as id12...
3,174 3,174 1.00 0.00 0.00 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
2,980 2,980 1.00 0.00 0.00 5jkbkg8b3ns0z   select role0_.id as id131_1_, ...
2,276 2,276 1.00 0.00 0.00 9babjv8yq8ru3 SQL*Plus BEGIN DBMS_OUTPUT.GET_LINES(:L...
2,144 8 0.00 0.00 0.00 bn4px769mjdhk   select dictionary0_.id as id12...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
107,586 107,586 44.73 3p1pdpapac3yu   select * from up_notify where ...
16,800 16,800 6.98 2ym6hhaq30r73   select type#, blocks, extents,...
14,854 14,854 6.18 b3ptckwgjzwb0   select groupuser0_.id as id127...
6,173 6,173 2.57 4cpndujy1w4dj   select CURRENT_DATE from dual
5,034 5,034 2.09 bubukxagjjrw4   select roleuser0_.id as id134_...
3,364 3,364 1.40 27jgnqdk36rjx   select dictionary0_.id as id12...
3,174 3,174 1.32 1cjy8v3c0agny   select sys_nc_oid$ from xdb.xd...
2,980 2,980 1.24 5jkbkg8b3ns0z   select role0_.id as id131_1_, ...
2,276 2,276 0.95 9babjv8yq8ru3 SQL*Plus BEGIN DBMS_OUTPUT.GET_LINES(:L...
2,144 2,144 0.89 bn4px769mjdhk   select dictionary0_.id as id12...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
3,185,009 3 0.12 31a13pnjps7j3   SELECT source, (case when time...
1,826,363 18 0.07 gss16ydr1c9gw   update up_ITSM_RELS set serial...
1,601,333 3 0.06 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sna...
1,204,054 8 0.04 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...
1,174,603 11 0.04 2fm3yx420zd3f   update up_ITSM_INC set serialN...
1,094,688 6 0.04 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
1,067,933 3 0.04 6vcyb6tyd0bxh   select * from ( select task0_....

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
53 3 b5yyh2vc9g8tm   SELECT sx.id, sum(decode(e.sna...
45 3 gvynt9bqh451z   SELECT sum(case when snap_id =...
45 3 gvynt9bqh451z   SELECT sum(case when snap_id =...
40 6 10xj8nynmpqtq   SELECT dbin.db_name, dbin.inst...
40 3 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
34 3 5an8d9ctcysja   SELECT (case when snap_id = :s...
34 18 gss16ydr1c9gw   update up_ITSM_RELS set serial...
31 3 cgd5z4rq28y6k   SELECT COUNT(*) FROM SYS.WRI$_...
31 78 dv6f0zrg1f7zm   update up_ITSM_CHG set serialN...
30 3 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
28 3 31a13pnjps7j3   SELECT source, (case when time...
27 3 0103qb611xu3g DBMS_SCHEDULER update sys.scheduler$_job set ...
26 3 36g2yq0mxjx2y   insert into wrh$_pgastat (snap...
26 7 3wuqyh299q7yc SQL*Plus insert into P$AUTOEXTENDEDLINK...
26 25 5rygsj4dbw6jt   insert into sys.mon_mods$ (obj...
26 3 71y370j6428cb   insert into wrh$_thread (snap_...
25 3 7qjhf5dzmazsr   SELECT snap_id , OBJ#, DATAOBJ...
25 3 a7vpmzwvcfs9y   insert into wrh$_tempstatxs (s...
24 3 cph1jbcxx1f25   UPDATE SYS.WRI$_ADV_TASKS SET ...
23 3 0ut2yw7mxf0aq   insert into WRM$_SNAPSHOT (sna...
23 6 cc3c5yr3y2rh1   INSERT INTO wrh$_sqltext (sql_...
23 3 dnwpm0gdccrph   insert into wrh$_process_memor...
21 3 aktbxfjwnzgmu   update WRM$_DATABASE_INSTANCE ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0103qb611xu3gupdate sys.scheduler$_job set next_run_date = :1, last_enabled_time = :2, job_status = :3 where obj# = :4
09qmkp7yk8d04select modlog0_.actionId as actionId1_, modlog0_.id as id1_, modlog0_.id as id23_0_, modlog0_.propertyName as property2_23_0_, modlog0_.oldValue as oldValue23_0_, modlog0_.newValue as newValue23_0_, modlog0_.sheetType as sheetType23_0_, modlog0_.actionId as actionId23_0_ from up_ITSM_CHG_modlog modlog0_ where ( modlog0_.sheetType='ITSM_CHG') and modlog0_.actionId=:1 order by modlog0_.id
0czmfncyt5vanselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'yangjie13' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='yangjie13') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'yangjie13' and task.state='27' and task.acDescId='-13')
0djdn7u5s0rwzselect worksheettype, worksheetid from os_task task where task.actor = 'qianweiming' and task.worksheettype <> 'NOTICE' and task.status = 2 group by worksheetid, worksheettype
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0ut2yw7mxf0aqinsert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1)
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
1cjy8v3c0agnyselect sys_nc_oid$ from xdb.xdb$resource where rowid = :1
1rhwt6d444mzfselect worksheettype, worksheetid from os_task task where task.actor = 'kongjianyu' and task.worksheettype <> 'NOTICE' and task.status = 2 group by worksheetid, worksheettype
1v6xzjh36s3k3select workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'kongjianyu' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='kongjianyu') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'kongjianyu' and task.state='27' and task.acDescId='-13')
27jgnqdk36rjxselect dictionary0_.id as id124_, dictionary0_.DEFAULTVALUE as DEFAULTV2_124_, dictionary0_.DESCRIPTION as DESCRIPT3_124_, dictionary0_.dictionaryflag as dictiona4_124_, dictionary0_.fullname as fullname124_, dictionary0_.name as name124_, dictionary0_.orderby as orderby124_, dictionary0_.status as status124_, dictionary0_.DICTTYPEID as DICTTYPEID124_, dictionary0_.value as value124_, dictionary0_.parentid as parentid124_, dictionary0_.remark1 as remark11_124_, dictionary0_.remark2 as remark12_124_, dictionary0_.remark3 as remark13_124_ from sys_resdictionarydata dictionary0_, sys_resdictionarytype dictionary1_ where dictionary0_.DICTTYPEID=dictionary1_.id and dictionary1_.Code=:1 and dictionary0_.parentid=:2
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2fm3yx420zd3fupdate up_ITSM_INC set serialNumber=:1, sheetType=:2, sheetName=:3, workFlowName=:4, creator=:5, creatorId=:6, creatorGroup=:7, creatorGroupID=:8, createDate=:9, sendDate=:10, finishDate=:11, closeDate=:12, status=:13, statusDisplay=:14, entryId=:15, request_mobile=:16, request_depart=:17, sources=:18, event_system=:19, nature=:20, request_name=:21, event_time=:22, incidentclass=:23, incidentclass_id=:24, attach=:25, isreissue=:26, request_telephone=:27, titles=:28, request_company=:29, impact_level=:30, priority_level=:31, description=:32, request_email=:33, urgent_level=:34, event_address=:35, solution=:36, ostype_id=:37, ostype_value=:38, environmenttype=:39, sheetclass_value=:40, alarmId=:41, moname=:42, ipaddr=:43, currentActor=:44, treatmentProcess=:45, currentActorDepart=:46 where sheetId=:47
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
36g2yq0mxjx2yinsert into wrh$_pgastat (snap_id, dbid, instance_number, name, value) select :snap_id, :dbid, :instance_number, name, value from v$pgastat where value > 0
3p1pdpapac3yuselect * from up_notify where notifytype = :1 and flag = :2
3p252d7ms591zselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'zhanyulin' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='zhanyulin') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'zhanyulin' and task.state='27' and task.acDescId='-13')
3tfg9d6urzjupselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'lizhiqiang' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='lizhiqiang') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'lizhiqiang' and task.state='27' and task.acDescId='-13')
3wuqyh299q7ycinsert into P$AUTOEXTENDEDLINKS values('dest', '/oracle/product/admin/upsmdb/cdump', '/oracle')
4cpndujy1w4djselect CURRENT_DATE from dual
5an8d9ctcysjaSELECT (case when snap_id = :startsn then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :instance_number AND (pga.snap_id = :startsn OR pga.snap_id = :endsn) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
5d9c6h8pagf8xselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'fengquanxian' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='fengquanxian') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'fengquanxian' and task.state='27' and task.acDescId='-13')
5jkbkg8b3ns0zselect role0_.id as id131_1_, role0_.CREATEUSER as CREATEUSER131_1_, role0_.Belong as Belong131_1_, role0_.DESCRIPTION as DESCRIPT3_131_1_, role0_.roleflag as roleflag131_1_, role0_.NAME as NAME131_1_, role0_.PARENTID as PARENTID131_1_, group1_.id as id126_0_, group1_.description as descript2_126_0_, group1_.fax as fax126_0_, group1_.groupflag as groupflag126_0_, group1_.fullname as fullname126_0_, group1_.name as name126_0_, group1_.numid as numid126_0_, group1_.orderby as orderby126_0_, group1_.orgid as orgid126_0_, group1_.orgtype as orgtype126_0_, group1_.parentid as parentid126_0_, group1_.phone as phone126_0_, group1_.status as status126_0_, group1_.type as type126_0_, group1_.dnid as dnid126_0_, group1_.memo as memo126_0_, group1_.memonum as memonum126_0_ from sys_role role0_ left outer join sys_group group1_ on role0_.Belong=group1_.id where role0_.id=:1
5rygsj4dbw6jtinsert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
6bu9b1z06tvtvselect task.worksheettype, task.taskid from os_task task where task.actor = 'liuxing8' and task.status = 1 and task.state =17
6vcyb6tyd0bxh select * from ( select task0_.taskId as taskId71_, task0_.entryId as entryId71_, task0_.pre_taskId as pre3_71_, task0_.top_taskId as top4_71_, task0_.par_taskId as par5_71_, task0_.par_entryId as par6_71_, task0_.top_par_entryId as top7_71_, task0_.priority_level as priority8_71_, task0_.createDate as createDate71_, task0_.actor as actor71_, task0_.actorCircleId as actorCi11_71_, task0_.actorCircleName as actorCi12_71_, task0_.actorName as actorName71_, task0_.actorType as actorType71_, task0_.taskName as taskName71_, task0_.createTime as createTime71_, task0_.endTime as endTime71_, task0_.acceptDate as acceptDate71_, task0_.dueDate as dueDate71_, task0_.accepTimeLimit as accepTi20_71_, task0_.dueTimeLimit as dueTime21_71_, task0_.isTimeOut as isTimeOut71_, task0_.appPropertyXML as appProp23_71_, task0_.policy as policy71_, task0_.upGradePolicy as upGrade25_71_, task0_.pressStr as pressStr71_, task0_.creator as creator71_, task0_.nextStepActorStr as nextSte28_71_, task0_.status as status71_, task0_.state as state71_, task0_.stateDisplay as stateDi31_71_, task0_.stepStatus as stepStatus71_, task0_.stepStatusDisplay as stepSta33_71_, task0_.stepDescId as stepDescId71_, task0_.stepDesc as stepDesc71_, task0_.acDescId as acDescId71_, task0_.endAcDescId as endAcDe37_71_, task0_.parentStepDescId as parentS38_71_, task0_.workSheetId as workShe39_71_, task0_.workSheetType as workShe40_71_, task0_.subFlow as subFlow71_, task0_.workSheetTitle as workShe42_71_, task0_.workSheetProType as workShe43_71_, task0_.workSheetUrgentLevel as workShe44_71_, task0_.phaseNo as phaseNo71_, task0_.prePhaseNo as prePhaseNo71_, task0_.orgTaskId as orgTaskId71_, task0_.orgAssignTaskId as orgAssi48_71_, task0_.flagDuplicated as flagDup49_71_, task0_.flagEndDuplicated as flagEnd50_71_, task0_.flagPredefined as flagPre51_71_, task0_.flagPredefineTransfer as flagPre52_71_, task0_.flowId as flowId71_, task0_.parentFlowId as parentF54_71_, task0_.notice_level as notice55_71_, task0_.failure_time as failure56_71_, task0_.effective_time as effective57_71_, task0_.notice_isexist as notice58_71_ from OS_TASK task0_ where 1=1 and (task0_.actor='zhubin2' and task0_.actorType='1' or (task0_.actor in (select groupuser1_.GROUPID from sys_groupuser groupuser1_ where groupuser1_.USERID='zhubin2')) and task0_.actorType=2) and (task0_.workSheetType like '%ITSM_PRO%') and task0_.status='1' or task0_.actor='zhubin2' and task0_.state='27' and task0_.acDescId='-13' and (task0_.workSheetType like '%ITSM_PRO%') order by task0_.createTime desc ) where rownum <= :1
71y370j6428cbinsert into wrh$_thread (snap_id, dbid, instance_number, thread#, thread_instance_number, status, open_time, current_group#, sequence#) select :snap_id, :dbid, :instance_number, t.thread#, i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from v$thread t, v$instance i where i.thread#(+) = t.thread#
7qjhf5dzmazsrSELECT snap_id , OBJ#, DATAOBJ# FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.OBJN_KEWRSEG OBJ#, t1.OBJD_KEWRSEG DATAOBJ# FROM X$KEWRTSEGSTAT t1, WRH$_SEG_STAT_OBJ t2 WHERE t2.dbid(+) = :dbid AND t2.OBJ#(+) = t1.OBJN_KEWRSEG AND t2.DATAOBJ#(+) = t1.OBJD_KEWRSEG) WHERE nvl(snap_id, 0) < :snap_id
8mrg623amm8rx 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, 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, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 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.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))) 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 <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, 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 <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), 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 f.type# = 69 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, 3, 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 ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
93nhjb0cf3r1rselect worksheettype, worksheetid from os_task task where task.actor = 'liuxing8' and task.worksheettype <> 'NOTICE' and task.status = 2 group by worksheetid, worksheettype
9babjv8yq8ru3BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
a7vpmzwvcfs9yinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw, x$kccfn fn where fn.fnfno = ts.kcftiofno and fn.fntyp = 7 and tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
aktbxfjwnzgmuupdate WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
b3ptckwgjzwb0 select groupuser0_.id as id127_2_, groupuser0_.GROUPID as GROUPID127_2_, groupuser0_.Memo as Memo127_2_, groupuser0_.USERID as USERID127_2_, group1_.id as id126_0_, group1_.description as descript2_126_0_, group1_.fax as fax126_0_, group1_.groupflag as groupflag126_0_, group1_.fullname as fullname126_0_, group1_.name as name126_0_, group1_.numid as numid126_0_, group1_.orderby as orderby126_0_, group1_.orgid as orgid126_0_, group1_.orgtype as orgtype126_0_, group1_.parentid as parentid126_0_, group1_.phone as phone126_0_, group1_.status as status126_0_, group1_.type as type126_0_, group1_.dnid as dnid126_0_, group1_.memo as memo126_0_, group1_.memonum as memonum126_0_, user2_.id as id136_1_, user2_.ARPMODEL as ARPMODEL136_1_, user2_.ARPPOSITION as ARPPOSIT3_136_1_, user2_.Memo as Memo136_1_, user2_.OFFICENUM as OFFICENUM136_1_, user2_.SKINTYPE as SKINTYPE136_1_, user2_.BELONGGROUPID as BELONGGR7_136_1_, user2_.CompanyID as CompanyID136_1_, user2_.CREATER as CREATER136_1_, user2_.DEPARTID as DEPARTID136_1_, user2_.DESCRIPTION as DESCRIP10_136_1_, user2_.FAX as FAX136_1_, user2_.FULLNAME as FULLNAME136_1_, user2_.LOGINNAME as LOGINNAME136_1_, user2_.MAIL as MAIL136_1_, user2_.MOBILE as MOBILE136_1_, user2_.MSN as MSN136_1_, user2_.ORDERBY as ORDERBY136_1_, user2_.PASSWORD as PASSWORD136_1_, user2_.PHONE as PHONE136_1_, user2_.Position as Position136_1_, user2_.SEX as SEX136_1_, user2_.STATUS as STATUS136_1_, user2_.TYPE as TYPE136_1_ from sys_groupuser groupuser0_ left outer join sys_group group1_ on groupuser0_.GROUPID=group1_.id left outer join sys_user user2_ on groupuser0_.USERID=user2_.id where groupuser0_.id=:1
b5yyh2vc9g8tmSELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id
bdj5vcsfkp6gcselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'zhanglong3' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='zhanglong3') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'zhanglong3' and task.state='27' and task.acDescId='-13')
bn4px769mjdhk select dictionary0_.id as id124_1_, dictionary0_.DEFAULTVALUE as DEFAULTV2_124_1_, dictionary0_.DESCRIPTION as DESCRIPT3_124_1_, dictionary0_.dictionaryflag as dictiona4_124_1_, dictionary0_.fullname as fullname124_1_, dictionary0_.name as name124_1_, dictionary0_.orderby as orderby124_1_, dictionary0_.status as status124_1_, dictionary0_.DICTTYPEID as DICTTYPEID124_1_, dictionary0_.value as value124_1_, dictionary0_.parentid as parentid124_1_, dictionary0_.remark1 as remark11_124_1_, dictionary0_.remark2 as remark12_124_1_, dictionary0_.remark3 as remark13_124_1_, dictionary1_.id as id124_0_, dictionary1_.DEFAULTVALUE as DEFAULTV2_124_0_, dictionary1_.DESCRIPTION as DESCRIPT3_124_0_, dictionary1_.dictionaryflag as dictiona4_124_0_, dictionary1_.fullname as fullname124_0_, dictionary1_.name as name124_0_, dictionary1_.orderby as orderby124_0_, dictionary1_.status as status124_0_, dictionary1_.DICTTYPEID as DICTTYPEID124_0_, dictionary1_.value as value124_0_, dictionary1_.parentid as parentid124_0_, dictionary1_.remark1 as remark11_124_0_, dictionary1_.remark2 as remark12_124_0_, dictionary1_.remark3 as remark13_124_0_ from sys_resdictionarydata dictionary0_ left outer join sys_resdictionarydata dictionary1_ on dictionary0_.parentid=dictionary1_.id where dictionary0_.id=:1
bubukxagjjrw4select roleuser0_.id as id134_, roleuser0_.assigner as assigner134_, roleuser0_.ROLEID as ROLEID134_, roleuser0_.USERID as USERID134_ from sys_roleuser roleuser0_ where roleuser0_.USERID=:1
bupycrmgc5ggxselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'hujiming' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='hujiming') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'hujiming' and task.state='27' and task.acDescId='-13')
cc3c5yr3y2rh1INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, ref_count) SELECT sqlid_kewrstx, :dbid, sqlfulltext_kewrstx, cmdtype_kewrstx, :lah_snap_id, 0 ref_count FROM x$kewrtsqltext
cgd5z4rq28y6kSELECT COUNT(*) FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND A.OWNER# = :B2 AND BITAND(A.PROPERTY, :B1 ) = :B1
cph1jbcxx1f25UPDATE SYS.WRI$_ADV_TASKS SET STATUS = :B2 , EXEC_START = SYSDATE, MTIME = SYSDATE, CLEANUP = 1 WHERE ID = :B1
dnwpm0gdccrphinsert into wrh$_process_memory_summary (snap_id, dbid, instance_number, category, num_processes, non_zero_allocs, used_total, allocated_total, allocated_stddev, allocated_max, max_allocated_max) select :snap_id, :dbid, :instance_number, category, COUNT(*) num_processes, SUM(DECODE(allocated, 0, 0, 1)) non_zero_allocs, SUM(used) used_total, SUM(allocated) allocated_total, STDDEV(allocated) allocated_stddev, MAX(allocated) allocated_max, MAX(max_allocated) max_allocated_max from v$process_memory group by category
dv6f0zrg1f7zmupdate up_ITSM_CHG set serialNumber=:1, sheetType=:2, sheetName=:3, workFlowName=:4, creator=:5, creatorId=:6, creatorGroup=:7, creatorGroupID=:8, createDate=:9, sendDate=:10, finishDate=:11, closeDate=:12, status=:13, statusDisplay=:14, entryId=:15, change_type=:16, request_mobile=:17, request_depart=:18, plan_end_time=:19, changeclass=:20, changeclass_id=:21, request_name=:22, change_system=:23, attach=:24, isreissue=:25, isintermit=:26, request_telephone=:27, titles=:28, request_company=:29, plan_start_time=:30, impact_level=:31, priority_level=:32, description=:33, request_email=:34, urgent_level=:35, risk_level=:36, ostype_id=:37, environmenttype=:38, sheetclass_value=:39, ostype_value=:40, currentActor=:41, chaResource=:42, planBusStopTime=:43, treatmentProcess=:44, currentActorDepart=:45, change_plan=:46 where sheetId=:47
f31408dszv4khselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'liuxing8' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='liuxing8') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'liuxing8' and task.state='27' and task.acDescId='-13')
g56bfpwfn5s6zselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'biyongjun' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='biyongjun') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'biyongjun' and task.state='27' and task.acDescId='-13')
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gs1m1b8d7qwbyselect task.worksheettype, task.taskid from os_task task where task.actor = 'kongjianyu' and task.status = 1 and task.state =17
gss16ydr1c9gwupdate up_ITSM_RELS set serialNumber=:1, sheetType=:2, sheetName=:3, workFlowName=:4, creator=:5, creatorId=:6, creatorGroup=:7, creatorGroupID=:8, createDate=:9, sendDate=:10, finishDate=:11, closeDate=:12, status=:13, statusDisplay=:14, entryId=:15, request_mobile=:16, request_depart=:17, plan_end_time=:18, releasesources=:19, request_name=:20, tasklevel=:21, request_telephone=:22, titles=:23, request_company=:24, plan_start_time=:25, attachs=:26, description=:27, request_email=:28, release_type=:29, impact_evaluation=:30, currentactor=:31, impact_level=:32, urgent_level=:33, priority_level=:34, environmentType=:35, outSerTime=:36, docDesc=:37, itResRequire=:38, planOutSerTime=:39, treatmentProcess=:40, currentActorDepart=:41, treatmentProcessL=:42 where sheetId=:43
gt108r1qxfh2gselect workSheetType, worksheetid, taskId from os_task task where ( (task.actor = 'qianweiming' and task.actortype=1) or ( task.actor in (select u.groupid from sys_groupuser u where u.userid='qianweiming') and task.actortype=2)) and task.worksheettype <> 'NOTICE' and task.status = 1 or ( task.actor = 'qianweiming' and task.state='27' and task.acDescId='-13')
gvynt9bqh451zSELECT sum(case when snap_id = :startsn then value else 0 end) as begin_sga, sum(case when snap_id = :endsn then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :instance_number AND (sga.snap_id = :startsn OR sga.snap_id = :endsn)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,285,398 119.27 315.90
CPU used when call started 1,284,551 119.19 315.69
CR blocks created 447 0.04 0.11
Cached Commit SCN referenced 352 0.03 0.09
Commit SCN cached 3 0.00 0.00
DB time 2,051,908 190.40 504.28
DBWR checkpoint buffers written 4,138 0.38 1.02
DBWR checkpoints 22 0.00 0.01
DBWR object drop buffers written 88 0.01 0.02
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 227 0.02 0.06
DBWR undo block writes 613 0.06 0.15
IMU CR rollbacks 107 0.01 0.03
IMU Flushes 172 0.02 0.04
IMU Redo allocation size 1,607,072 149.12 394.96
IMU commits 861 0.08 0.21
IMU contention 8 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 2 0.00 0.00
IMU undo allocation size 6,646,560 616.73 1,633.46
IMU- failed to get a private strand 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
RowCR - row contention 3 0.00 0.00
RowCR attempts 378 0.04 0.09
RowCR hits 375 0.03 0.09
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 1,055,334 97.92 259.36
active txn count during cleanout 317 0.03 0.08
application wait time 11 0.00 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 34,525 3.20 8.48
branch node splits 1 0.00 0.00
buffer is not pinned count 1,234,889,192 114,585.14 303,487.14
buffer is pinned count 1,496,051,623 138,818.35 367,670.59
bytes received via SQL*Net from client 106,643,747 9,895.45 26,208.83
bytes sent via SQL*Net to client 381,604,124 35,408.98 93,783.27
calls to get snapshot scn: kcmgss 2,454,698 227.77 603.27
calls to kcmgas 20,337 1.89 5.00
calls to kcmgcs 184 0.02 0.05
change write time 28 0.00 0.01
cleanout - number of ktugct calls 334 0.03 0.08
cleanouts and rollbacks - consistent read gets 153 0.01 0.04
cleanouts only - consistent read gets 13 0.00 0.00
cluster key scan block gets 46,757 4.34 11.49
cluster key scans 37,178 3.45 9.14
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 3 0.00 0.00
commit batch/immediate requested 3 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: callback failure 15 0.00 0.00
commit cleanout failures: cannot pin 4 0.00 0.00
commit cleanouts 4,953 0.46 1.22
commit cleanouts successfully completed 4,934 0.46 1.21
commit immediate performed 3 0.00 0.00
commit immediate requested 3 0.00 0.00
commit txn count during cleanout 265 0.02 0.07
concurrency wait time 400 0.04 0.10
consistent changes 727 0.07 0.18
consistent gets 1,544,937,655 143,354.48 379,684.85
consistent gets - examination 464,944 43.14 114.26
consistent gets direct 1,318 0.12 0.32
consistent gets from cache 1,544,936,338 143,354.36 379,684.53
current blocks converted for CR 0 0.00 0.00
cursor authentications 1,468 0.14 0.36
data blocks consistent reads - undo records applied 654 0.06 0.16
db block changes 26,299 2.44 6.46
db block gets 30,737 2.85 7.55
db block gets direct 98 0.01 0.02
db block gets from cache 30,639 2.84 7.53
deferred (CURRENT) block cleanout applications 2,888 0.27 0.71
enqueue conversions 2,323 0.22 0.57
enqueue releases 117,878 10.94 28.97
enqueue requests 117,873 10.94 28.97
enqueue timeouts 0 0.00 0.00
enqueue waits 23 0.00 0.01
execute count 252,609 23.44 62.08
failed probes on index block reclamation 2 0.00 0.00
free buffer inspected 681 0.06 0.17
free buffer requested 18,654 1.73 4.58
heap block compress 392 0.04 0.10
hot buffers moved to head of LRU 432 0.04 0.11
immediate (CR) block cleanout applications 166 0.02 0.04
immediate (CURRENT) block cleanout applications 349 0.03 0.09
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 8,762 0.81 2.15
index fast full scans (full) 8 0.00 0.00
index fetch by key 237,809 22.07 58.44
index scans kdiixs1 129,863 12.05 31.92
leaf node 90-10 splits 31 0.00 0.01
leaf node splits 53 0.00 0.01
lob reads 516 0.05 0.13
lob writes 380 0.04 0.09
lob writes unaligned 369 0.03 0.09
logons cumulative 91 0.01 0.02
messages received 5,625 0.52 1.38
messages sent 5,625 0.52 1.38
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,542,284,910 143,108.33 379,032.91
opened cursors cumulative 242,137 22.47 59.51
parse count (failures) 18 0.00 0.00
parse count (hard) 4,863 0.45 1.20
parse count (total) 240,543 22.32 59.12
parse time cpu 1,894 0.18 0.47
parse time elapsed 3,106 0.29 0.76
physical read IO requests 17,751 1.65 4.36
physical read bytes 146,350,080 13,579.80 35,967.09
physical read total IO requests 32,834 3.05 8.07
physical read total bytes 393,175,040 36,482.64 96,626.95
physical read total multi block requests 114 0.01 0.03
physical reads 17,865 1.66 4.39
physical reads cache 16,550 1.54 4.07
physical reads cache prefetch 0 0.00 0.00
physical reads direct 1,315 0.12 0.32
physical reads direct (lob) 1,283 0.12 0.32
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 3,192 0.30 0.78
physical write bytes 36,143,104 3,353.71 8,882.55
physical write total IO requests 16,409 1.52 4.03
physical write total bytes 221,390,848 20,542.82 54,409.15
physical write total multi block requests 1,326 0.12 0.33
physical writes 4,412 0.41 1.08
physical writes direct 98 0.01 0.02
physical writes direct (lob) 50 0.00 0.01
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 4,314 0.40 1.06
physical writes non checkpoint 1,285 0.12 0.32
pinned buffers inspected 0 0.00 0.00
pinned cursors current 82 0.01 0.02
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 10,502 0.97 2.58
recursive calls 642,100 59.58 157.80
recursive cpu usage 2,284 0.21 0.56
redo blocks written 9,018 0.84 2.22
redo entries 13,478 1.25 3.31
redo ordering marks 336 0.03 0.08
redo size 7,964,464 739.02 1,957.35
redo subscn max counts 1,458 0.14 0.36
redo synch time 65 0.01 0.02
redo synch writes 1,061 0.10 0.26
redo wastage 1,120,816 104.00 275.45
redo write time 102 0.01 0.03
redo writer latching time 0 0.00 0.00
redo writes 2,471 0.23 0.61
rollback changes - undo records applied 9 0.00 0.00
rollbacks only - consistent read gets 294 0.03 0.07
rows fetched via callback 162,510 15.08 39.94
session connect time 0 0.00 0.00
session cursor cache hits 179,196 16.63 44.04
session logical reads 1,544,968,350 143,357.33 379,692.39
shared hash latch upgrades - no wait 9,172 0.85 2.25
shared hash latch upgrades - wait 0 0.00 0.00
sorts (memory) 24,205 2.25 5.95
sorts (rows) 603,071 55.96 148.21
sql area evicted 5,107 0.47 1.26
sql area purged 46 0.00 0.01
switch current to new buffer 776 0.07 0.19
table fetch by rowid 249,490 23.15 61.31
table fetch continued row 61 0.01 0.01
table scan blocks gotten 1,542,015,587 143,083.34 378,966.72
table scan rows gotten 17,831,719,699 1,654,601.95 4,382,334.65
table scans (long tables) 0 0.00 0.00
table scans (short tables) 304,597 28.26 74.86
total number of times SMON posted 0 0.00 0.00
transaction rollbacks 3 0.00 0.00
undo change vector size 2,441,976 226.59 600.14
user I/O wait time 356 0.03 0.09
user calls 1,266,935 117.56 311.36
user commits 1,031 0.10 0.25
user rollbacks 3,038 0.28 0.75
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 25,642 2.38 6.30
write clones created in background 88 0.01 0.02
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 4,596,659,144 4,642,794,728
session cursor cache count 524,255 525,586
session uga memory 1.1E+13 1.1E+13
opened cursors current 1,613 2,176
workarea memory allocated 0 698
logons current 86 88
session uga memory max 44,248,717,200 44,382,209,528
session pga memory 3,135,152,488 3,149,850,536

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.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)
ULTRACMDB_DEFAULT 10,787 1 0.20 1.00 170 0 0 0.00
DOMS 5,405 1 0.22 1.00 197 0 0 0.00
BPMRELEASE_DATA 1,346 0 0.68 1.08 1,318 0 0 0.00
SYSAUX 37 0 0.81 1.00 608 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 487 0 2 0.00
PATROL_DATA 176 0 0.45 1.00 165 0 0 0.00
SYSTEM 0 0 0.00 0.00 206 0 0 0.00
KMPLAT 0 0 0.00 0.00 41 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)
BPMRELEASE_DATA /dev/vgupsmdb/rlvbpms_bpms_data 1,346 0 0.68 1.08 1,318 0 0 0.00
DOMS /dev/vgupsmdb/rlvbpms_doms 5,405 1 0.22 1.00 197 0 0 0.00
KMPLAT /dev/vgupsmdb/rlvbpms_user 0 0     41 0 0 0.00
PATROL_DATA /dev/vgupsmdb/rlvPATROL_DATA 176 0 0.45 1.00 165 0 0 0.00
SYSAUX /dev/vgupsmdb/rlvbpms_sysaux 37 0 0.81 1.00 608 0 0 0.00
SYSTEM /dev/vgupsmdb/rlvbpms_system 0 0     206 0 0 0.00
ULTRACMDB_DEFAULT /dev/vgupsmdb/rlvbpms_ULTRACMDB_DEFAULT01 10,787 1 0.20 1.00 170 0 0 0.00
UNDOTBS1 /dev/vgupsmdb/rlvbpms_undotbs1 0 0     487 0 2 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 304,766 100 1,544,922,344 16,550 4,314 0 0 2


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 11 262 496 688 2354670 688  
E 0 11 186 428 985 2354670 985  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 240 0.10 29,685 395.03 3,126,954,769
D 480 0.19 59,370 7.67 60,722,722
D 720 0.29 89,055 2.82 22,285,465
D 960 0.39 118,740 1.46 11,566,621
D 1,200 0.49 148,425 1.09 8,613,364
D 1,440 0.58 178,110 1.04 8,224,417
D 1,680 0.68 207,795 1.02 8,092,629
D 1,920 0.78 237,480 1.01 8,021,880
D 2,160 0.88 267,165 1.00 7,941,073
D 2,400 0.97 296,850 1.00 7,918,704
D 2,464 1.00 304,766 1.00 7,915,756
D 2,640 1.07 326,535 1.00 7,901,190
D 2,880 1.17 356,220 1.00 7,890,612
D 3,120 1.27 385,905 1.00 7,876,393
D 3,360 1.36 415,590 0.99 7,856,105
D 3,600 1.46 445,275 0.99 7,837,377
D 3,840 1.56 474,960 0.99 7,831,134
D 4,080 1.66 504,645 0.99 7,821,944
D 4,320 1.75 534,330 0.99 7,810,846
D 4,560 1.85 564,015 0.99 7,802,349
D 4,800 1.95 593,700 0.99 7,800,789

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 12,982 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 1,024 859 121.47 0.00 0.00 0.00 0.00 104,850
E 1,024 853 131.67 0.44 0.33 100.00 0.00 104,850

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 9,867 9,867 0 0
64K 128K 71 71 0 0
128K 256K 164 164 0 0
256K 512K 56 56 0 0
512K 1024K 15,274 15,274 0 0
1M 2M 205 205 0 0
2M 4M 5 5 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
128 0.13 3,382,406.70 1,438.94 100.00 0
256 0.25 3,382,406.70 1,438.94 100.00 0
512 0.50 3,382,406.70 1,438.94 100.00 0
768 0.75 3,382,406.70 1,438.94 100.00 0
1,024 1.00 3,382,406.70 1,438.94 100.00 0
1,229 1.20 3,382,406.70 0.00 100.00 0
1,434 1.40 3,382,406.70 0.00 100.00 0
1,638 1.60 3,382,406.70 0.00 100.00 0
1,843 1.80 3,382,406.70 0.00 100.00 0
2,048 2.00 3,382,406.70 0.00 100.00 0
3,072 3.00 3,382,406.70 0.00 100.00 0
4,096 4.00 3,382,406.70 0.00 100.00 0
6,144 6.00 3,382,406.70 0.00 100.00 0
8,192 8.00 3,382,406.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 (K)
672 0.26 292 39,069 252,675 0.99 11,201 1.18 49,808
944 0.37 561 53,099 253,443 1.00 10,433 1.10 49,970
1,216 0.47 832 66,223 253,623 1.00 10,253 1.08 50,014
1,488 0.58 1,103 79,040 253,923 1.00 9,953 1.05 50,089
1,760 0.68 1,374 92,560 254,131 1.00 9,745 1.03 50,141
2,032 0.79 1,645 106,740 254,231 1.00 9,645 1.02 50,162
2,304 0.89 1,916 120,618 254,315 1.00 9,561 1.01 50,177
2,576 1.00 2,187 134,517 254,387 1.00 9,489 1.00 50,191
2,848 1.11 2,458 147,686 254,423 1.00 9,453 1.00 50,198
3,120 1.21 2,729 161,981 254,452 1.00 9,424 0.99 50,205
3,392 1.32 3,000 176,188 254,472 1.00 9,404 0.99 50,209
3,664 1.42 3,271 189,798 254,484 1.00 9,392 0.99 50,212
3,936 1.53 3,542 203,745 254,493 1.00 9,383 0.99 50,214
4,208 1.63 3,813 217,327 254,505 1.00 9,371 0.99 50,217
4,480 1.74 4,084 231,284 254,525 1.00 9,351 0.99 50,219
4,752 1.84 4,355 245,540 254,534 1.00 9,342 0.98 50,221
5,024 1.95 4,626 259,250 254,547 1.00 9,329 0.98 50,223
5,296 2.06 4,897 272,910 254,558 1.00 9,318 0.98 50,225

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,280 0.25 6,895,053 59,920,690
2,560 0.50 6,876,490 8,499,147
3,840 0.75 6,875,115 8,115,233
5,120 1.00 6,875,114 7,915,756
6,400 1.25 6,875,115 7,835,807
7,680 1.50 6,875,115 7,813,643
8,960 1.75 6,875,115 7,733,694
10,240 2.00 6,875,116 7,697,281

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)
undo block 1 0 0
undo header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 1 1 0 1 0 64.00
RO-Multiple Object Reuse (fast object reuse) 198 198 0 22 0 1.36

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 0.41 2,638 153 4 106395.8/107133.5 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
07-Jul 11:09 50 344 6 3 106,980 0/0 0/0/0/0/0/0
07-Jul 10:59 4 12 150 4 107,133 0/0 0/0/0/0/0/0
07-Jul 10:49 9 116 141 2 107,015 0/0 0/0/0/0/0/0
07-Jul 10:39 25 97 21 2 106,810 0/0 0/0/0/0/0/0
07-Jul 10:29 24 117 138 2 106,826 0/0 0/0/0/0/0/0
07-Jul 10:19 14 204 0 2 106,920 0/0 0/0/0/0/0/0
07-Jul 10:09 5 108 9 2 106,932 0/0 0/0/0/0/0/0
07-Jul 09:59 66 124 126 3 106,406 0/0 0/0/0/0/0/0
07-Jul 09:49 15 150 150 2 106,832 0/0 0/0/0/0/0/0
07-Jul 09:39 34 159 153 2 106,714 0/0 0/0/0/0/0/0
07-Jul 09:29 8 97 117 1 106,890 0/0 0/0/0/0/0/0
07-Jul 09:19 8 59 140 2 106,702 0/0 0/0/0/0/0/0
07-Jul 09:09 68 518 135 3 106,396 0/0 0/0/0/0/0/0
07-Jul 08:59 5 83 132 2 106,656 0/0 0/0/0/0/0/0
07-Jul 08:49 7 49 69 3 106,610 0/0 0/0/0/0/0/0
07-Jul 08:39 10 96 60 2 106,610 0/0 0/0/0/0/0/0
07-Jul 08:29 2 16 45 2 106,665 0/0 0/0/0/0/0/0
07-Jul 08:19 2 51 24 1 106,662 0/0 0/0/0/0/0/0
07-Jul 08:09 56 238 39 4 106,425 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 7,207 0.00   0 0  
AWR Alerted Metric Element list 51,135 0.00   0 0  
Consistent RBA 2,472 0.00   0 0  
FAL request queue 215 0.00   0 0  
FAL subheap alocation 215 0.00   0 0  
FOB s.o list latch 564 0.00   0 0  
In memory undo latch 12,637 0.00   0 3,694 0.03
JS mem alloc latch 50 0.00   0 0  
JS queue access latch 50 0.00   0 0  
JS queue state obj latch 77,574 0.00   0 0  
JS slv state obj latch 12 0.00   0 0  
KMG MMAN ready and startup request latch 3,581 0.00   0 0  
KTF sga latch 12,727 0.00   0 3,402 0.00
KWQMN job cache list latch 3 0.00   0 0  
MQL Tracking Latch 0     0 214 0.00
Memory Management Latch 0     0 3,581 0.00
OS process 429 0.00   0 0  
OS process allocation 3,869 0.00   0 0  
OS process: request allocation 168 0.00   0 0  
PL/SQL warning settings 2,489 0.00   0 0  
SQL memory manager latch 3 0.00   0 3,581 0.00
SQL memory manager workarea list latch 264,813 0.00 0.00 0 0  
Shared B-Tree 384 0.00   0 0  
active checkpoint queue latch 6,990 0.04 0.00 0 0  
active service list 22,335 0.00   0 8,066 0.00
archive control 375 0.00   0 0  
archive process latch 4,011 0.00   0 0  
begin backup scn array 58 0.00   0 0  
cache buffer handles 1,210 0.00   0 0  
cache buffers chains 3,089,551,973 0.00 0.03 0 14,211 0.01
cache buffers lru chain 20,278 0.00   0 35,560 0.00
channel handle pool latch 168 0.00   0 0  
channel operations parent latch 50,870 0.00   0 0  
checkpoint queue latch 657,558 0.00 0.00 0 4,094 0.00
client/application info 458 0.00   0 0  
commit callback allocation 22 0.00   0 0  
compile environment latch 91 0.00   0 0  
dictionary lookup 26 0.00   0 0  
direct msg latch 5,608 0.00   0 0  
dml lock allocation 7,715 0.04 0.00 0 0  
done queue latch 5,608 0.00   0 5,608 0.00
dummy allocation 180 0.00   0 0  
enqueue hash chains 238,135 0.00 0.00 0 1 0.00
enqueues 369,577 0.00 0.00 0 0  
event group latch 85 0.00   0 0  
file cache latch 655 0.00   0 0  
global KZLD latch for mem in SGA 55 0.00   0 0  
hash table column usage latch 785 0.00   0 74,176 0.00
hash table modification latch 279 0.00   0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 184 0.00   0 0  
kks stats 31,979 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 12,708 0.00   0 0  
ksfv messages 11,216 0.00   0 0  
ksuosstats global area 724 0.00   0 0  
ktm global data 36 0.00   0 0  
kwqbsn:qsga 384 0.00   0 0  
lgwr LWN SCN 5,484 0.00   0 0  
library cache 508,168 0.01 0.06 0 20,195 0.01
library cache load lock 364 0.00   0 0  
library cache lock 866,225 0.00 0.00 0 0  
library cache lock allocation 1,170 0.00   0 0  
library cache pin 76,352 0.00   0 0  
library cache pin allocation 196 0.00   0 0  
list of block allocation 167 0.00   0 0  
loader state object freelist 792 0.00   0 0  
message pool operations parent latch 66 0.00   0 0  
messages 82,347 0.05 0.00 0 0  
mostly latch-free SCN 5,496 0.05 0.00 0 0  
msg queue latch 0     0 11,295 4.36
ncodef allocation latch 171 0.00   0 0  
object queue header heap 65,389 0.00 0.00 0 9,482 0.14
object queue header operation 115,785 0.02 0.00 0 0  
object stats modification 25 0.00   0 0  
parallel query alloc buffer 1,436 0.00   0 0  
parameter list 375 0.00   0 0  
parameter table management 186 0.00   0 0  
post/wait queue 1,618 0.00   0 1,092 0.00
process allocation 168 0.00   0 85 0.00
process group creation 168 0.00   0 0  
qmn task queue latch 1,536 3.65 0.96 0 0  
redo allocation 20,819 0.03 0.00 0 13,501 0.07
redo copy 0     0 13,502 0.86
redo writing 21,893 0.00   0 0  
resmgr group change latch 87 0.00   0 0  
resmgr:active threads 135 0.00   0 0  
resmgr:actses change group 61 0.00   0 0  
resmgr:free threads list 132 0.00   0 0  
resmgr:resource group CPU method 59 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 1,060,412 0.00 0.00 0 82 0.00
sequence cache 472 0.00   0 0  
session allocation 292,746 0.01 0.04 0 0  
session idle bit 2,679,841 0.00 0.00 0 0  
session queue latch 5,608 0.00   0 0  
session state list latch 208 0.00   0 0  
session switching 586 0.00   0 0  
session timer 3,592 0.00   0 0  
shared pool 263,360 0.00 0.00 0 0  
shared pool simulator 40,263 0.00   0 0  
simulator hash latch 97,153,084 0.00 0.00 0 0  
simulator lru latch 4,318 0.28 0.00 0 97,148,641 0.16
slave class 24 0.00   0 0  
slave class create 96 6.25 1.00 0 0  
sort extent pool 305 0.00   0 0  
state object free list 6 0.00   0 0  
statistics aggregation 1,680 0.00   0 0  
threshold alerts latch 701 0.00   0 0  
transaction allocation 517,387 0.00   0 0  
transaction branch allocation 3,592 0.00   0 0  
undo global data 28,862 0.00   0 0  
user lock 228 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 3,089,551,973 142,993 3,639 139,452 0 0 0
simulator hash latch 97,153,084 1,823 6 1,818 0 0 0
qmn task queue latch 1,536 56 54 2 0 0 0
library cache 508,168 36 2 35 0 0 0
session allocation 292,746 24 1 23 0 0 0
slave class create 96 6 6 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 12,705 10,690
cache buffers chains kcbrls: kslbegin 0 2,309 4,326
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers chains kcbbic2 0 1 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 0
event range base latch No latch 0 54 54
library cache kglobpn: child: 0 2 0
session allocation ksufap: active sessions 0 1 0
simulator hash latch kcbsacc: lookup dba 0 5 6
simulator hash latch kcbsacc: insert dba 0 1 0
slave class create ksvcreate 0 6 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
BPMS BPMRELEASE_DATA UP_NOTIFY   TABLE 1,235,129,088 79.95
BPMS BPMRELEASE_DATA OS_TASK   TABLE 269,145,312 17.42
BPMS BPMRELEASE_DATA SYS_GROUPUSER   TABLE 15,508,704 1.00
BPMS BPMRELEASE_DATA UP_BASEINFOR   TABLE 10,005,024 0.65
DOMS DOMS APP_PLAN_VALUE   TABLE 6,386,896 0.41

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
BPMS BPMRELEASE_DATA SYS_LOB0000058677C00042$$   LOB 190 1.06
BPMS BPMRELEASE_DATA SYS_LOB0000058667C00041$$   LOB 142 0.79
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 58002_7664 TABLE PARTITION 35 0.20
BPMS BPMRELEASE_DATA PK_SYS_GROUPUSER   INDEX 5 0.03
BPMS BPMRELEASE_DATA BIN$sER+eYW1GargRAAiZANCvw==$0   INDEX 1 0.01

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
BPMS BPMRELEASE_DATA PK_SYS_GROUPUSER   INDEX 6 42.86
BPMS BPMRELEASE_DATA SYS_C0010376   INDEX 4 28.57
BPMS BPMRELEASE_DATA OS_TASK   TABLE 2 14.29
BPMS BPMRELEASE_DATA BIN$sER+eYWwGargRAAiZANCvw==$0   INDEX 1 7.14
SYS SYSTEM SMON_SCN_TIME   TABLE 1 7.14

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 194 0.00 0   6 1
dc_database_links 116 0.00 0   0 1
dc_files 696 0.00 0   0 12
dc_global_oids 13,285 0.00 0   0 82
dc_histogram_data 113,411 0.24 0   0 8,237
dc_histogram_defs 134,515 0.30 0   0 4,237
dc_object_grants 43 0.00 0   0 78
dc_object_ids 47,748 0.05 0   0 1,457
dc_objects 8,824 0.06 0   39 932
dc_profiles 67 0.00 0   0 1
dc_rollback_segments 6,872 0.00 0   0 94
dc_segments 22,603 0.04 0   36 1,392
dc_sequences 5 0.00 0   5 5
dc_tablespaces 40,303 0.00 0   0 16
dc_usernames 566 0.00 0   0 42
dc_users 41,465 0.00 0   0 80
outstanding_alerts 234 0.00 0   0 13


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 50 0.00 2,408 0.00 0 0
CLUSTER 34 0.00 43 0.00 0 0
INDEX 32 34.38 74 14.86 0 0
SQL AREA 66,689 13.38 290,427 4.88 341 95
TABLE/PROCEDURE 1,155 0.26 32,639 0.52 63 0
TRIGGER 22 0.00 44 0.00 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 81.65   0.93 1.96 11 11 88 88
  Freeable 38.25 0.00 0.91 0.27 1   42 42
  SQL 1.35 0.34 0.02 0.03 0 16 56 48
  PL/SQL 0.27 0.11 0.00 0.01 0 0 86 86
E Other 89.16   0.99 1.93 11 11 90 90
  Freeable 40.56 0.00 0.86 0.30 1   47 47
  SQL 1.67 0.43 0.03 0.03 0 16 58 47
  PL/SQL 0.33 0.16 0.00 0.01 0 0 88 88

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 2,583,691,264  
Fixed Size 2,075,488  
Redo Buffers 14,700,544  
Variable Size 2,768,241,824  

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 30.97 30.97 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 260.04 258.45 -0.61
shared PCursor 202.52 200.74 -0.88
shared free memory 297.56 305.35 2.62
shared kglsim object batch 43.08 43.08 0.00
shared library cache 178.72 176.45 -1.27
shared sql area 1,340.11 1,337.05 -0.23
  buffer_cache 2,464.00 2,464.00 0.00
  fixed_sga 1.98 1.98 0.00
  log_buffer 14.02 14.02 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)
audit_file_dest /oracle/product/admin/upsmdb/adump   
background_dump_dest /oracle/product/admin/upsmdb/bdump   
backup_tape_io_slaves TRUE   
compatible 10.2.0.5.0   
control_files /dev/vgupsmdb/rlvbpms_ctrl01, /dev/vgupsmdb/rlvbpms_ctrl02, /dev/vgupsmdb/rlvbpms_ctrl03   
core_dump_dest /oracle/product/admin/upsmdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name upsmdb   
dbwr_io_slaves 20   
disk_asynch_io FALSE   
dispatchers (PROTOCOL=TCP) (SERVICE=upsmdbXDB)   
job_queue_processes 10   
log_archive_dest_1 LOCATION=/oraarch   
open_cursors 1000   
pga_aggregate_target 1073741824   
processes 1000   
remote_login_passwordfile EXCLUSIVE   
sessions 1105   
sga_target 5368709120   
spfile /dev/vgupsmdb/rlvbpms_spfile   
tape_asynch_io TRUE   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/product/admin/upsmdb/udump   


Back to Top

End of Report Report written to awrrpt_1_7670_7673.html