AWR Report
Hello everyone,
My developers are saying that whenever they perform an update the update is very badly slow.
I took an AWR report and found nothing significant. Its taken at one of the hour they mentioned the problem.
How could I improve the situation? Any guide?
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
DEV XXXXXXXXXX DEV 1 10.2.0.4.0 NO KCHSQL
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 15231 21-Jul-11 09:00:29 50 12.5
End Snap: 15232 21-Jul-11 10:00:21 59 12.5
Elapsed: 59.87 (mins)
DB Time: 10.24 (mins)
Cache Sizes
*~~~~~~~~~~~ Begin End*
---------- ----------
Buffer Cache: 48M 48M Std Block Size: 8K
Shared Pool Size: 968M 968M Log Buffer: 56,076K
Load Profile
*~~~~~~~~~~~~ Per Second Per Transaction*
--------------- ---------------
Redo size: 8,149.41 8,901.07
Logical reads: 3,659.33 3,996.85
Block changes: 57.74 63.07
Physical reads: 15.06 16.45
Physical writes: 1.48 1.62
User calls: 15.73 17.19
Parses: 7.99 8.73
Hard parses: 0.02 0.03
Sorts: 29.72 32.46
Logons: 0.04 0.04
Executes: 314.73 343.76
Transactions: 0.92
*% Blocks changed per Read: 1.58 Recursive Call %: 96.09*
Rollback per transaction %: 3.47 Rows per Sort: 2.12
Instance Efficiency Percentages (Target 100%)
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.59 In-memory Sort %: 100.00
Library Hit %: 101.32 Soft Parse %: 99.71
Execute to Parse %: 97.46 Latch Hit %: 99.02
Parse CPU to Parse Elapsd %: 91.14 % Non-Parse CPU: 88.87
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 93.56 93.63
*% SQL with executions>1: 96.60 96.52*
*% Memory for SQL w/exec>1: 96.13 95.29*
Top 5 Timed Events Avg %Total
*~~~~~~~~~~~~~~~~~~ wait Call*
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 372 60.5
db file sequential read 25,417 188 7 30.7 User I/O
log file parallel write 2,812 45 16 7.3 System I/O
db file parallel write 3,010 28 9 4.5 System I/O
log file sync 1,854 27 15 4.4 Commit
-------------------------------------------------------------
Time Model Statistics DB/Inst: DEV/DEV Snaps: 15231-15232
-> Total time in database user-calls (DB Time): 614.7s
-> Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time 594.4 96.7
DB CPU 372.1 60.5
PL/SQL execution elapsed time 74.4 12.1
parse time elapsed 46.0 7.5
hard parse elapsed time 44.8 7.3
PL/SQL compilation elapsed time 1.0 .2
repeated bind elapsed time 0.3 .1
hard parse (sharing criteria) elapsed time 0.3 .0
connection management call elapsed time 0.2 .0
sequence load elapsed time 0.1 .0
failed parse elapsed time 0.0 .0
hard parse (bind mismatch) elapsed time 0.0 .0
DB time 614.7 N/A
background elapsed time 137.7 N/A
background cpu time 6.0 N/A
-------------------------------------------------------------
Wait Class DB/Inst: DEV/DEV Snaps: 15231-15232
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc
Avg
*%Time Total Wait wait Waits*
Wait Class Waits -outs Time (s) (ms) /txn
-------------------- ---------------- ------ ---------------- ------- ---------
User I/O 27,885 .0 210 8 8.5
System I/O 10,922 .0 109 10 3.3
Commit 1,854 .0 27 15 0.6
Network 82,175 .0 23 0 25.0
Concurrency 80 20.0 1 11 0.0
Configuration 2 .0 0 148 0.0
Other 102 .0 0 3 0.0
Application 22 .0 0 0 0.0
-------------------------------------------------------------
Wait Events DB/Inst: DEV/DEV Snaps: 15231-15232
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
*%Time Total Wait wait Waits*
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
db file sequential read 25,417 .0 188 7 7.7
log file parallel write 2,812 .0 45 16 0.9
db file parallel write 3,010 .0 28 9 0.9
log file sync 1,854 .0 27 15 0.6
SQLNet more data to client 33,629 .0 22 1 10.2*
db file scattered read 2,406 .0 21 9 0.7
control file sequential read 3,814 .0 19 5 1.2
control file parallel write 1,217 .0 16 13 0.4
SQLNet more data from clien 601 .0 1 2 0.2*
Log archive I/O 26 .0 1 30 0.0
log file sequential read 37 .0 1 21 0.0
os thread startup 62 .0 1 11 0.0
log file switch completion 2 .0 0 148 0.0
cursor: pin S wait on X 16 100.0 0 11 0.0
rdbms ipc reply 3 .0 0 52 0.0
SQLNet message to client 47,665 .0 0 0 14.5*
enq: JS - queue lock 1 .0 0 104 0.0
local write wait 3 .0 0 34 0.0
direct path read 40 .0 0 2 0.0
direct path write 14 .0 0 5 0.0
log file single write 6 .0 0 7 0.0
db file single write 3 .0 0 13 0.0
SQLNet break/reset to clien 18 .0 0 0 0.0*
SQLNet more data from dblin 10 .0 0 0 0.0*
SQLNet message to dblink 269 .0 0 0 0.1*
LGWR wait for redo copy 24 .0 0 0 0.0
read by other session 2 .0 0 0 0.0
cursor: pin S 73 .0 0 0 0.0
latch: cache buffers chains 2 .0 0 0 0.0
SQLNet break/reset to dblin 4 .0 0 0 0.0*
SQLNet more data to dblink 1 .0 0 0 0.0*
latch free 1 .0 0 0 0.0
SQLNet message from client 47,655 .0 22,333 469 14.5*
pipe get 718 100.0 3,584 4992 0.2
Streams AQ: qmn slave idle w 128 .0 3,569 27886 0.0
Streams AQ: qmn coordinator 259 50.6 3,569 13781 0.1
Streams AQ: waiting for time 65 67.7 3,499 53824 0.0
jobq slave wait 613 99.5 1,835 2994 0.2
SQLNet message from dblink 269 .0 2 6 0.1*
single-task message 2 .0 0 239 0.0
class slave wait 2 .0 0 0 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: DEV/DEV Snaps: 15231-15232
-> ordered by wait time desc, waits desc (idle events last)
Avg
*%Time Total Wait wait Waits*
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
log file parallel write 2,812 .0 45 16 0.9
db file parallel write 3,010 .0 28 9 0.9
control file sequential read 3,022 .0 18 6 0.9
control file parallel write 1,208 .0 16 13 0.4
db file sequential read 2,061 .0 10 5 0.6
db file scattered read 125 .0 1 11 0.0
Log archive I/O 26 .0 1 30 0.0
log file sequential read 37 .0 1 21 0.0
os thread startup 62 .0 1 11 0.0
events in waitclass Other 25 .0 0 4 0.0
direct path write 14 .0 0 5 0.0
log file single write 6 .0 0 7 0.0
direct path read 14 .0 0 0 0.0
rdbms ipc message 14,127 83.1 70,589 4997 4.3
pmon timer 1,310 100.0 3,592 2742 0.4
Streams AQ: qmn slave idle w 128 .0 3,569 27886 0.0
Streams AQ: qmn coordinator 259 50.6 3,569 13781 0.1
Streams AQ: waiting for time 65 67.7 3,499 53824 0.0
smon timer 59 5.1 3,325 56352 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: DEV/DEV Snaps: 15231-15232
Statistic Total
-------------------------------- --------------------
AVG_BUSY_TIME 31,517
AVG_IDLE_TIME 327,747
AVG_SYS_TIME 6,176
AVG_USER_TIME 25,251
BUSY_TIME 126,447
IDLE_TIME 1,311,328
SYS_TIME 25,070
USER_TIME 101,377
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 1,748,992
VM_OUT_BYTES 6,684,672
PHYSICAL_MEMORY_BYTES 4,109,881,344
NUM_CPUS 4
NUM_CPU_CORES 2
-------------------------------------------------------------
Service Statistics DB/Inst: DEV/DEV Snaps: 15231-15232
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
DEV 592.5 370.0 46,866 ##########
SYS$USERS 22.1 2.1 2,023 19,396
SYS$BACKGROUND 0.0 0.0 5,240 34,122
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: DEV/DEV Snaps: 15231-15232
-> Wait Class info for services in the Service Statistics section.
-> Total Waits and Time Waited displayed for the following wait
classes: User I/O, Concurrency, Administrative, Network
-> Time Waited (Wt Time) in centisecond (100th of a second)
Service Name
----------------------------------------------------------------
User I/O User I/O Concurcy Concurcy Admin Admin Network Network
Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
DEV
*23584 17636 18 17 0 0 82130 2319*
SYS$USERS
*1259 1365 0 0 0 0 0 0*
SYS$BACKGROUND
*3045 1977 62 68 0 0 0 0*
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
Elapsed CPU Elap per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ---------- ------- -------------
*247 244 13 19.0 40.1 aztkn6v7zas27*
Module: stage.exe
select ColumnDefId, ColumnD
efTypeId, Name, DataTypeId,
DataSize, EffectiveDated from common.ColumnD
efs where ObjectDefId = :objectDefId and Colum
*80 78 543,363 0.0 13.0 3c17bpkvgzn1y*
Module: dllhost.exe
SELECT C.COLUMNDEFID, C.COLUMNDEFTYPEID, C.NAME, C.BUSINESSNAME, NVL(EC.EXTERNAL
NAME, C.NAME), C.OBJECTDEFID, YC.PROPERTYDEFID, NVL(TC.SOURCECOLUMNDEFID, NVL(LC
*.VALUECOLUMNDEFID, NC.SOURCECOLUMNDEFID)), LC.ENDPOINTID, LC.VALUEHANDLERID, LC.*
VALUEHANDLERPARAMETER, TC.TRANSLATIONTABLEID, XC.EXPRESSIONID, XS.SYNTAX, C.DOMA
*54 48 13 4.2 8.8 6wfxnn05mr6sh*
Module: stage.exe
begin possecommonconfig.pkg_QueryView.NewOrModify(:1,:2); end;
*31 2 2 15.3 5.0 dc9bdxa7xpv8s*
Module: PL/SQL Developer
declare t_owner varchar2(30); t_name varchar2(30); procedure check_mvie
w is dummy integer; begin if :object_type = 'TABLE' then select
*/*+rule*/ 1 into dummy from sys.all_objects where owner = :object_ow*
ner and object_name = :object_name and object_type = 'MATERIALIZED V
*31 2 2 15.3 5.0 44mwxbkuxcrsa*
Module: PL/SQL Developer
SELECT /+rule*/ S.TABLE_OWNER, S.TABLE_NAME FROM ALL_SYNONYMS S WHERE S.SYNONYM*
_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1*
*29 2 10 2.9 4.7 bc9zbdxkcr0qj*
Module: marshal.exe
select CapturableItemTypeId, ConfigId,
ItemGuid from possecommonconfig.CapturableItems
*25 13 540 0.0 4.1 51g04nvn9gh7a*
Module: dllhost.exe
select ColumnDefId, ColumnDefTypeId, ObjectDefId, Name, BusinessName,
DataTypeId, DataSize, DataScale, DomainId, Enterable, Mandatory, A
ctive, CopyFromRelatedObject, MicrohelpText, ConstrainValuesToList, SeqN
um, DisplayStyleId, Width, Height, AutoSelect, AutoHScroll, AutoVScr
*23 1 28 0.8 3.7 282tmrbt9tahw*
Module: dllhost.exe
select InstanceId, PropertyDefId, BindTypeId, BoundColumnDefId, BoundE
xpressionId, BoundPropertyDefId, BoundCustomPropertyDefId, BoundEnumeratio
nValueId, BoundConstantValue from common.PaneWidgetPropertyValues where Object
DefId = :1 and SystemId = :2
*15 15 128,316 0.0 2.5 d4g9kdfta4kwy*
Module: dllhost.exe
SELECT EB.EXPRESSIONBINDINGID, BV.NAME, BV.DATATYPEID, EB.BINDTYPEID, BV.DATASIZ
E, BV.DATASCALE, EB.BOUNDCOLUMNDEFID, EB.BOUNDEXPRESSIONID, EB.BOUNDCONSTANTVALU
E FROM EXPRESSIONBINDVARIABLES BV LEFT OUTER JOIN EXPRESSIONBINDINGS EB ON EB.EX
PRESSIONID = :B2 AND EB.BINDVARIABLEID = BV.BINDVARIABLEID AND (EB.PARENTEXPRESS
*15 1 60 0.2 2.4 6gvch1xu9ca3g*
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
*= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date*
SQL ordered by Elapsed Time DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
Elapsed CPU Elap per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ---------- ------- -------------
begin stage.pkg_PaneUpdate.Remove(:1); end;
*6 5 1 6.2 1.0 c8khjbn635s3c*
Module: plsqldev.exe
select s.synonym_name object_name, o.object_type from all_synonyms s, sys.a
ll_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o
*.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TY*
PE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
CPU Elapsed CPU per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ----------- ------- -------------
*244 247 13 18.78 40.1 aztkn6v7zas27*
Module: stage.exe
select ColumnDefId, ColumnD
efTypeId, Name, DataTypeId,
DataSize, EffectiveDated from common.ColumnD
efs where ObjectDefId = :objectDefId and Colum
*78 80 543,363 0.00 13.0 3c17bpkvgzn1y*
Module: dllhost.exe
SELECT C.COLUMNDEFID, C.COLUMNDEFTYPEID, C.NAME, C.BUSINESSNAME, NVL(EC.EXTERNAL
NAME, C.NAME), C.OBJECTDEFID, YC.PROPERTYDEFID, NVL(TC.SOURCECOLUMNDEFID, NVL(LC
*.VALUECOLUMNDEFID, NC.SOURCECOLUMNDEFID)), LC.ENDPOINTID, LC.VALUEHANDLERID, LC.*
VALUEHANDLERPARAMETER, TC.TRANSLATIONTABLEID, XC.EXPRESSIONID, XS.SYNTAX, C.DOMA
*48 54 13 3.72 8.8 6wfxnn05mr6sh*
Module: stage.exe
begin possecommonconfig.pkg_QueryView.NewOrModify(:1,:2); end;
*15 15 128,316 0.00 2.5 d4g9kdfta4kwy*
Module: dllhost.exe
SELECT EB.EXPRESSIONBINDINGID, BV.NAME, BV.DATATYPEID, EB.BINDTYPEID, BV.DATASIZ
E, BV.DATASCALE, EB.BOUNDCOLUMNDEFID, EB.BOUNDEXPRESSIONID, EB.BOUNDCONSTANTVALU
E FROM EXPRESSIONBINDVARIABLES BV LEFT OUTER JOIN EXPRESSIONBINDINGS EB ON EB.EX
PRESSIONID = :B2 AND EB.BINDVARIABLEID = BV.BINDVARIABLEID AND (EB.PARENTEXPRESS
*13 25 540 0.02 4.1 51g04nvn9gh7a*
Module: dllhost.exe
select ColumnDefId, ColumnDefTypeId, ObjectDefId, Name, BusinessName,
DataTypeId, DataSize, DataScale, DomainId, Enterable, Mandatory, A
ctive, CopyFromRelatedObject, MicrohelpText, ConstrainValuesToList, SeqN
um, DisplayStyleId, Width, Height, AutoSelect, AutoHScroll, AutoVScr
*13 13 98,824 0.00 2.1 84udxhj96p86n*
Module: dllhost.exe
SELECT BINDVARIABLEID, NAME, DATATYPEID, DATASIZE, DATASCALE FROM EXPRESSIONBIND
VARIABLES WHERE EXPRESSIONID = :B1 ORDER BY SEQNUM
*10 11 63,651 0.00 1.8 bun148rxvrj0q*
Module: dllhost.exe
SELECT COUNT() FROM COMMONCFG.EXPRESSIONBINDVARIABLES BV WHERE EXPRESSIONID = :*
B1 AND NOT EXISTS ( SELECT 1 FROM COMMONCFG.EXPRESSIONBINDINGS WHERE EXPRESSIONI
D = :B1 AND BINDVARIABLEID = BV.BINDVARIABLEID AND PARENTEXPRESSIONBINDINGID IS
NULL )
*9 13 98,817 0.00 2.1 181ty7zc0vyhq*
Module: dllhost.exe
SELECT EXPRESSIONID, EXPRESSIONTYPEID, DATATYPEID, DATASIZE, DATASCALE, NATIVESY
NTAX FROM EXPRESSIONS WHERE EXPRESSIONID = :B1
*9 10 1 8.53 1.6 bd502nbh9abbs*
Module: plsqldev.exe
select s.synonym_name object_name, o.object_type from all_synonyms s, sys.a
ll_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner an
d o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE',
*'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')*
*7 7 62,938 0.00 1.2 4hg660yv7p7cj*
Module: dllhost.exe
SELECT COUNT() FROM COMMONCFG.EXPRESSIONBINDINGS EB JOIN COMMONCFG.EXPRESSIONBI*
NDVARIABLES BV ON BV.EXPRESSIONID = EB.BOUNDEXPRESSIONID WHERE EB.EXPRESSIONID =
SQL ordered by CPU Time DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
CPU Elapsed CPU per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ----------- ------- -------------
*:B1 AND NOT EXISTS ( SELECT 1 FROM COMMONCFG.EXPRESSIONBINDINGS WHERE EXPRESSIO*
NID = :B1 AND BINDVARIABLEID = BV.BINDVARIABLEID AND PARENTEXPRESSIONBINDINGID =
*5 6 1 5.01 1.0 c8khjbn635s3c*
Module: plsqldev.exe
select s.synonym_name object_name, o.object_type from all_synonyms s, sys.a
ll_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o
*.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TY*
PE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
*5 10 20 0.24 1.6 2n734g9z4uugu*
Module: stage.exe
begin stage.pkg_WidgetUpdate.ReplaceWidgets(:1,:2,:3,:4,:5,:6); end;
*3 9 490 0.01 1.4 a3cvfmgsrk9cb*
Module: stage.exe
begin stage.pkg_ColumnDefUpdate.Resequence(:1,:2); end;
*3 7 6 0.43 1.1 cwxxh732dhc0y*
Module: stage.exe
begin stage.pkg_PaneUpdate.Remove(:1); end;
*2 29 10 0.21 4.7 bc9zbdxkcr0qj*
Module: marshal.exe
select CapturableItemTypeId, ConfigId,
ItemGuid from possecommonconfig.CapturableItems
*2 31 2 0.81 5.0 44mwxbkuxcrsa*
Module: PL/SQL Developer
SELECT /+rule*/ S.TABLE_OWNER, S.TABLE_NAME FROM ALL_SYNONYMS S WHERE S.SYNONYM*
_NAME = :B1 AND S.OWNER = 'PUBLIC' AND ROWNUM = 1*
*2 31 2 0.81 5.0 dc9bdxa7xpv8s*
Module: PL/SQL Developer
declare t_owner varchar2(30); t_name varchar2(30); procedure check_mvie
w is dummy integer; begin if :object_type = 'TABLE' then select
*/*+rule*/ 1 into dummy from sys.all_objects where owner = :object_ow*
ner and object_name = :object_name and object_type = 'MATERIALIZED V
*1 7 57 0.02 1.2 g2f268ahnbxdw*
Module: dllhost.exe
begin :1 := common.pkg_ObjectQuery.LookupCandidates(:2,:3,:4,:5,:6,:7,:8); end;
*1 15 60 0.02 2.4 6gvch1xu9ca3g*
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
*= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date*
*; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;*
*1 9 2,647 0.00 1.4 awxp8qp9cjs86*
Module: dllhost.exe
select ColumnDefId,
Value from common.StoredColumnValues
where ObjectId = :objectId
*1 23 28 0.03 3.7 282tmrbt9tahw*
Module: dllhost.exe
select InstanceId, PropertyDefId, BindTypeId, BoundColumnDefId, BoundE
xpressionId, BoundPropertyDefId, BoundCustomPropertyDefId, BoundEnumeratio
nValueId, BoundConstantValue from common.PaneWidgetPropertyValues where Object
SQL ordered by CPU Time DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
CPU Elapsed CPU per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ----------- ------- -------------
DefId = :1 and SystemId = :2
*0 8 18 0.02 1.4 f64cp84pfrjav*
Module: dllhost.exe
select v.BoundConstantValue,
v.PresentationId from ( select PresentationI
d from common.ListPresentations where Sy
stemId = :systemId union all select Presen
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: DEV/DEV Snaps: 15231-15232
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 13,145,634
-> Captured SQL account for 175.3% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
*10,028,297 13 771,407.5 76.3 244.13 246.73 aztkn6v7zas27*