awr-2007-10-08_22-00
- Thomas Amsler
Owned by Thomas Amsler
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
SAKAI 530514751 sakai 1 10.2.0.3.0 NO caje
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 3268 08-Oct-07 22:00:26 1,040 35.2
End Snap: 3269 08-Oct-07 22:47:26 1,038 35.5
Elapsed: 47.00 (mins)
DB Time: 49.53 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 752M 720M Std Block Size: 8K
Shared Pool Size: 704M 736M Log Buffer: 15,148K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 30,382.37 10,079.58
Logical reads: 19,158.10 6,355.84
Block changes: 199.82 66.29
Physical reads: 481.44 159.72
Physical writes: 12.48 4.14
User calls: 717.10 237.90
Parses: 21.13 7.01
Hard parses: 0.95 0.31
Sorts: 16.71 5.54
Logons: 0.05 0.02
Executes: 253.23 84.01
Transactions: 3.01
% Blocks changed per Read: 1.04 Recursive Call %: 34.90
Rollback per transaction %: 1.04 Rows per Sort: 1000.80
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.92 Redo NoWait %: 100.00
Buffer Hit %: 97.73 In-memory Sort %: 100.00
Library Hit %: 99.00 Soft Parse %: 95.51
Execute to Parse %: 91.66 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 25.98 % Non-Parse CPU: 99.32
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 87.75 89.11
% SQL with executions>1: 94.72 81.84
% Memory for SQL w/exec>1: 93.33 84.89
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 820 27.6
db file scattered read 92,856 540 6 18.2 User I/O
read by other session 43,785 315 7 10.6 User I/O
db file sequential read 224,842 254 1 8.5 User I/O
log file parallel write 8,632 210 24 7.1 System I/O
-------------------------------------------------------------
Time Model Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total time in database user-calls (DB Time): 2972.1s
-> 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 2,803.5 94.3
PL/SQL execution elapsed time 892.4 30.0
DB CPU 820.2 27.6
parse time elapsed 33.0 1.1
hard parse elapsed time 28.5 1.0
failed parse elapsed time 11.1 .4
repeated bind elapsed time 4.5 .2
hard parse (sharing criteria) elapsed time 1.0 .0
connection management call elapsed time 0.3 .0
hard parse (bind mismatch) elapsed time 0.3 .0
sequence load elapsed time 0.2 .0
PL/SQL compilation elapsed time 0.0 .0
DB time 2,972.1 N/A
background elapsed time 398.0 N/A
background cpu time 12.4 N/A
-------------------------------------------------------------
Wait Class DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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 427,945 .0 1,110 3 50.3
System I/O 13,780 .0 242 18 1.6
Commit 6,370 .0 160 25 0.7
Network 2,992,425 .0 52 0 352.1
Concurrency 563 .5 6 11 0.1
Other 552 .0 0 1 0.1
Application 209 .0 0 1 0.0
-------------------------------------------------------------
Wait Events DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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 scattered read 92,856 .0 540 6 10.9
read by other session 43,785 .0 315 7 5.2
db file sequential read 224,842 .0 254 1 26.5
log file parallel write 8,632 .0 210 24 1.0
log file sync 6,370 .0 160 25 0.7
SQL*Net more data from clien 255,288 .0 34 0 30.0
control file parallel write 929 .0 32 34 0.1
SQL*Net more data to client 738,725 .0 10 0 86.9
SQL*Net message to client 1,997,377 .0 8 0 235.0
os thread startup 33 3.0 4 129 0.0
library cache load lock 6 .0 2 251 0.0
direct path read 63,197 .0 0 0 7.4
SQL*Net break/reset to clien 207 .0 0 1 0.0
latch free 238 .0 0 1 0.0
latch: cache buffers chains 470 .0 0 1 0.1
control file sequential read 4,219 .0 0 0 0.5
db file parallel read 983 .0 0 0 0.1
latch: library cache 34 .0 0 2 0.0
buffer busy waits 11 .0 0 6 0.0
cursor: pin S wait on X 2 100.0 0 28 0.0
latch: cache buffers lru cha 132 .0 0 0 0.0
cursor: pin S 1 .0 0 33 0.0
LGWR wait for redo copy 172 .0 0 0 0.0
enq: TX - row lock contentio 2 .0 0 12 0.0
direct path write temp 2,042 .0 0 0 0.2
latch: shared pool 3 .0 0 4 0.0
SQL*Net more data from dblin 78 .0 0 0 0.0
SQL*Net message to dblink 906 .0 0 0 0.1
latch: redo allocation 3 .0 0 0 0.0
direct path write 127 .0 0 0 0.0
SQL*Net more data to dblink 51 .0 0 0 0.0
direct path read temp 113 .0 0 0 0.0
latch: row cache objects 4 .0 0 0 0.0
latch: session allocation 5 .0 0 0 0.0
latch: object queue header o 1 .0 0 0 0.0
SQL*Net message from client 1,997,376 .0 2,640,624 1322 235.0
jobq slave wait 1,192 96.6 3,453 2897 0.1
Streams AQ: qmn slave idle w 101 .0 2,766 27384 0.0
Streams AQ: qmn coordinator 204 50.5 2,766 13558 0.0
Streams AQ: waiting for mess 564 100.0 2,754 4883 0.1
virtual circuit status 94 100.0 2,754 29294 0.0
SQL*Net message from dblink 906 .0 730 806 0.1
single-task message 41 .0 4 108 0.0
PL/SQL lock timer 1 100.0 1 978 0.0
SGA: MMAN sleep for componen 65 95.4 1 11 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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 8,631 .0 210 24 1.0
control file parallel write 929 .0 32 34 0.1
os thread startup 33 3.0 4 129 0.0
db file scattered read 110 .0 0 1 0.0
db file sequential read 1,335 .0 0 0 0.2
events in waitclass Other 175 .0 0 0 0.0
control file sequential read 315 .0 0 0 0.0
rdbms ipc message 17,376 51.3 29,337 1688 2.0
Streams AQ: qmn slave idle w 101 .0 2,766 27384 0.0
Streams AQ: qmn coordinator 204 50.5 2,766 13558 0.0
pmon timer 946 100.0 2,755 2912 0.1
smon timer 93 2.2 2,503 26912 0.0
SGA: MMAN sleep for componen 65 95.4 1 11 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
Statistic Total
-------------------------------- --------------------
BUSY_TIME 97,144
IDLE_TIME 466,837
IOWAIT_TIME 84,800
NICE_TIME 0
SYS_TIME 30,805
USER_TIME 63,637
LOAD 2
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 24,072
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS 2,972.1 820.3 1,354,623 ##########
SYS$BACKGROUND 0.0 0.0 3,278 18,687
sakai.ucdavis.edu 0.0 0.0 0 0
sakaiXDB 0.0 0.0 0 0
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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
--------- --------- --------- --------- --------- --------- --------- ---------
SYS$USERS
425706 110865 530 197 0 0 2992335 5218
SYS$BACKGROUND
2242 96 33 424 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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
---------- ---------- ------------ ---------- ------- -------------
482 45 1 481.5 16.2 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )
464 127 1 464.5 15.6 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )
432 33 229 1.9 14.5 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null
431 19 923 0.5 14.5 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
86 86 83,331 0.0 2.9 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
47 44 1 47.2 1.6 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc
28 28 2 14.2 1.0 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
SELECT sectioncmi0_.eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, secti
oncmi0_.title AS title248_, sectioncmi0_.description AS descript4_248_, sectionc
mi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_248_, sec
tioncmi0_.lastmodifiedby AS lastmodi7_248_, sectioncmi0_.lastmodifieddate AS las
24 23 923 0.0 0.8 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS
20 1 602 0.0 0.7 0ybwd63u2any5
insert into sys.wri$_optstat_histgrm_history (obj#,intcol#,savtime,bucket, endpo
int,epvalue) select hg.obj#,hg.intcol#,:3,hg.bucket,hg.endpoint, hg.epvalue from
sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2
13 13 11,936 0.0 0.4 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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
---------- ---------- ------------ ----------- ------- -------------
127 464 1 126.78 15.6 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )
86 86 83,331 0.00 2.9 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
45 482 1 44.95 16.2 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )
44 47 1 44.39 1.6 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc
33 432 229 0.14 14.5 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null
28 28 2 14.08 1.0 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
SELECT sectioncmi0_.eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, secti
oncmi0_.title AS title248_, sectioncmi0_.description AS descript4_248_, sectionc
mi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_248_, sec
tioncmi0_.lastmodifiedby AS lastmodi7_248_, sectioncmi0_.lastmodifieddate AS las
23 24 923 0.02 0.8 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS
19 431 923 0.02 14.5 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
13 13 11,936 0.00 0.4 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
12 12 11,601 0.00 0.4 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> 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
---------- ---------- ------------ ----------- ------- -------------
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 54,024,654
-> Captured SQL account for 97.1% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
14,010,298 1 ############ 25.9 44.39 47.24 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc
12,840,072 2 6,420,036.0 23.8 28.15 28.33 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
SELECT sectioncmi0_.eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, secti
oncmi0_.title AS title248_, sectioncmi0_.description AS descript4_248_, sectionc
mi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_248_, sec
tioncmi0_.lastmodifiedby AS lastmodi7_248_, sectioncmi0_.lastmodifieddate AS las
4,620,375 751 6,152.3 8.6 10.65 10.93 f9f27aadm1pr0
Module: JDBC Thin Client
select dbmembersh0_.ID as ID37_0_, openforumi1_.ID as ID34_1_, areaimpl2_.ID as
ID30_2_, permission3_.ID as ID38_3_, dbmembersh0_.VERSION as VERSION37_0_, dbmem
bersh0_.UUID as UUID37_0_, dbmembersh0_.CREATED as CREATED37_0_, dbmembersh0_.CR
EATED_BY as CREATED5_37_0_, dbmembersh0_.MODIFIED as MODIFIED37_0_, dbmembersh0_
3,016,904 229 13,174.3 5.6 33.07 432.14 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null
2,725,245 83,331 32.7 5.0 85.87 85.97 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
1,883,778 2 941,889.0 3.5 4.00 4.80 7usr9gxxt325w
Module: TOAD 8.5.3.2
/* Formatted on 2007/10/08 22:22 (Formatter Plus v4.8.6) */ SELECT sectioncmi0_.
eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, sectioncmi0_.title
AS title248_, sectioncmi0_.description AS descript4_248_, section
cmi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_2
1,750,701 1 1,750,701.0 3.2 44.95 481.51 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )
1,706,849 1 1,706,849.0 3.2 126.78 464.48 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )
861,956 923 933.9 1.6 19.16 430.57 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
801,748 923 868.6 1.5 22.76 24.09 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 54,024,654
-> Captured SQL account for 97.1% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS
765,603 418 1,831.6 1.4 7.62 9.42 22331rjyzgm79
Module: JDBC Thin Client
select coursesete0_.COURSEOFFERING_EID as COURSEOF1_0_, coursesete0_.COURSESET_E
ID as COURSESET2_0_ from BANNER_OFFERING_COURSESETS coursesete0_ where courseset
e0_.COURSEOFFERING_EID=:1
703,671 2,792 252.0 1.3 9.94 10.08 20ux4jqcvrgps
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0
653,042 28 23,322.9 1.2 3.48 3.58 gsytpx8b8g7kg
Module: JDBC Thin Client
select topicimpl0_.ID as ID31_0_, messagesse1_.ID as ID32_1_, topicimpl0_.VERSIO
N as VERSION31_0_, topicimpl0_.UUID as UUID31_0_, topicimpl0_.CREATED as CREATED
31_0_, topicimpl0_.CREATED_BY as CREATED6_31_0_, topicimpl0_.MODIFIED as MODIFIE
D31_0_, topicimpl0_.MODIFIED_BY as MODIFIED8_31_0_, topicimpl0_.DEFAULTASSIGNNAM
601,727 66,858 9.0 1.1 4.40 4.42 5r6vhfx4563bb
Module: JDBC Thin Client
select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SR
RG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = S
RR.ROLE_KEY where SR.REALM_ID = :1 and SRRG.USER_ID = :2 and SRRG.ACTIVE = '1'
600,669 6,525 92.1 1.1 6.31 6.31 c6x6a16zphs25
Module: JDBC Thin Client
SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_FUNCTION.FUNCTION_NAME FROM SAKAI
_REALM_RL_FN INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_FN
.REALM_KEY AND SAKAI_REALM.REALM_ID = :1 INNER JOIN SAKAI_REALM_ROLE ON SAKAI_RE
ALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_FN.ROLE_KEY INNER JOIN SAKAI_REALM_FUNCTION O
560,327 11,936 46.9 1.0 12.79 12.90 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
540,824 536 1,009.0 1.0 4.74 5.20 6p68587y4yccm
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Disk Reads: 1,357,629
-> Captured SQL account for 122.5% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
552,947 1 552,947.0 40.7 126.78 464.48 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )
437,588 1 437,588.0 32.2 44.95 481.51 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )
436,427 923 472.8 32.1 19.16 430.57 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
54,212 2 27,106.0 4.0 4.00 4.80 7usr9gxxt325w
Module: TOAD 8.5.3.2
/* Formatted on 2007/10/08 22:22 (Formatter Plus v4.8.6) */ SELECT sectioncmi0_.
eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, sectioncmi0_.title
AS title248_, sectioncmi0_.description AS descript4_248_, section
cmi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_2
53,564 2 26,782.0 3.9 28.15 28.33 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
SELECT sectioncmi0_.eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, secti
oncmi0_.title AS title248_, sectioncmi0_.description AS descript4_248_, sectionc
mi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_248_, sec
tioncmi0_.lastmodifiedby AS lastmodi7_248_, sectioncmi0_.lastmodifieddate AS las
52,208 229 228.0 3.8 33.07 432.14 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null
36,005 1 36,005.0 2.7 0.67 6.63 6hun1u5a30088
Module: DBMS_SCHEDULER
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact u
se_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count("RESOURCE_
UUID"),count("FILE_PATH") from "SAKAI"."CONTENT_RESOURCE" t
6,524 2 3,262.0 0.5 0.37 5.77 fh44j45a5k7p5
Module: JDBC Thin Client
select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_USER_AGENT,SESS
ION_START,SESSION_END from SAKAI_SESSION where SESSION_START = SESSION_END ORDER
BY SESSION_SERVER ASC, SESSION_START ASC
6,201 1 6,201.0 0.5 0.37 5.54 bxbuuskdn20bh
Module: DBMS_SCHEDULER
select /*+ no_parallel_index(t,"SYS_C004181") dbms_stats cursor_sharing_exact us
e_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t,"SYS_C0
04181") */ count(*) as nrw,count(distinct sys_op_lbid(46575,'L',t.rowid)) as nlb
,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SAKAI"."SAKAI
4,843 1 4,843.0 0.4 0.94 5.63 6y660ngt2q7sq
Module: DBMS_SCHEDULER
select /*+ no_parallel_index(t,"FK_SAKAI_REALM_RL_FN_FUNC") dbms_stats cursor_sh
aring_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index
_ffs(t,"FK_SAKAI_REALM_RL_FN_FUNC") */ count(*) as nrw,count(distinct sys_op_lbi
d(46572,'L',t.rowid)) as nlb,count(distinct "FUNCTION_KEY") as ndk,sys_op_countc
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Executions: 714,094
-> Captured SQL account for 42.3% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
83,331 83,331 1.0 0.00 0.00 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
66,858 66,858 1.0 0.00 0.00 5r6vhfx4563bb
Module: JDBC Thin Client
select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SR
RG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = S
RR.ROLE_KEY where SR.REALM_ID = :1 and SRRG.USER_ID = :2 and SRRG.ACTIVE = '1'
49,376 49,256 1.0 0.00 0.00 g15u20xaysjyr
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin
11,936 11,936 1.0 0.00 0.00 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
11,601 11,601 1.0 0.00 0.00 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US
9,353 36,798 3.9 0.00 0.00 8a1pvy4cy8hgv
insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epvalue) values(:1,:
2,:3,:4,:5,:6,:7)
7,345 7,345 1.0 0.00 0.00 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and
7,340 7,340 1.0 0.00 0.00 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :
6,525 951,756 145.9 0.00 0.00 c6x6a16zphs25
Module: JDBC Thin Client
SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_FUNCTION.FUNCTION_NAME FROM SAKAI
_REALM_RL_FN INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_FN
.REALM_KEY AND SAKAI_REALM.REALM_ID = :1 INNER JOIN SAKAI_REALM_ROLE ON SAKAI_RE
ALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_FN.ROLE_KEY INNER JOIN SAKAI_REALM_FUNCTION O
4,981 4,981 1.0 0.00 0.00 6nrr3a3qqtnsk
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Executions: 714,094
-> Captured SQL account for 42.3% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
Module: JDBC Thin Client
select 1 from DUAL
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Parse Calls: 59,573
-> Captured SQL account for 44.1% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
4,981 4,981 8.36 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
4,730 4,730 7.94 2ym6hhaq30r73
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis
ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro
m seg$ where ts#=:1 and file#=:2 and block#=:3
1,328 1,328 2.23 fkw8xn3uyux0h
select null from partobj$ where obj#=:1
923 923 1.55 3vycvc6n3uhbn
Module: DBMS_SCHEDULER
select chain_pcent from wri$_adv_objspace_chrow_data
923 923 1.55 bxrry8kxks9hz
Module: DBMS_SCHEDULER
select sn.startup_time timepoint, s.space_used_delta delta_space_usage, s.space_
allocated_delta delta_space_alloc, NULL total_space_usage, NULL total_space_allo
c, s.instance_number instance_number, s.dataobj# objn from sys.wrh$_seg_stat s,
sys.wrh$_seg_stat_obj so, sys.wrm$_snapshot sn , sys.obj$ obj where sn.snap_id
923 923 1.55 ggpw9s044z93d
Module: DBMS_SCHEDULER
select timepoint, space_usage, space_alloc from wri$_adv_objspace_trend_data or
der by timepoint
922 923 1.55 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))
922 922 1.55 c435jg0kk315y
Module: DBMS_SCHEDULER
delete from wri$_adv_objspace_trend_data
922 922 1.55 gnux0zb3sxduk
Module: DBMS_SCHEDULER
SELECT TIMEPOINT, DELTA_SPACE_USAGE, DELTA_SPACE_ALLOC, TOTAL_SPACE_USAGE, TOTAL
_SPACE_ALLOC, INSTANCE_NUMBER, OBJN FROM TABLE(DBMS_SPACE.OBJECT_GROWTH_TREND_SW
RF(:B1 , :B2 , :B3 , :B4 )) ORDER BY TIMEPOINT
887 887 1.49 0wymay7v2c2z6
select ts#,file#,block#, pctfree$, initrans, type# from ind$ where obj#=:1
823 823 1.38 8hd36umbhpgsz
select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, de
finitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextp
ct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(t
runc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpar
643 643 1.08 27xdav1rg5g14
select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property,1024),0,0,
1) from ind$ i,obj$ o,user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.us
er#
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
34,947,496 N/A 4.53 0nmzn7vrra627
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8)) and FUNCT
ION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME =
:9) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1'
6,491,952 1 0.84 dc6dj7p1ybyjh
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
4,787,237 270 0.62 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
= :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =
3,809,848 35 0.49 camts4vh6qv7r
Module: JDBC Thin Client
update SAKAI_SITE set TITLE = :1,TYPE = :2,SHORT_DESC = :3,DESCRIPTION = :4,ICON
_URL = :5,INFO_URL = :6,SKIN = :7,PUBLISHED = :8,JOINABLE = :9,PUBVIEW = :10,JOI
N_ROLE = :11,IS_SPECIAL = :12,IS_USER = :13,CREATEDBY = :14,MODIFIEDBY = :15,CRE
ATEDON = :16,MODIFIEDON = :17,CUSTOM_PAGE_ORDERED = :18 where ( SITE_ID = :19 )
1,579,206 22 0.20 6ma5vzd75tgv3
Module: TOAD 8.5.3.2
INSERT INTO "TOAD_PLAN_TABLE" ("STATEMENT_ID","TIMESTAMP","OPERATION","OPTIONS"
,"OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_INSTANCE","OBJECT_TYPE","SEA
RCH_COLUMNS","ID","PARENT_ID","POSITION","OTHER","OPTIMIZER","COST","CARDINALITY
","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","DISTRIB
1,571,909 11,936 0.20 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
1,282,056 552 0.17 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
664 N/A 0nmzn7vrra627
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8)) and FUNCT
ION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME =
:9) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1'
489 11,936 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
212 1 dc6dj7p1ybyjh
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
211 7,340 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :
208 35 camts4vh6qv7r
Module: JDBC Thin Client
update SAKAI_SITE set TITLE = :1,TYPE = :2,SHORT_DESC = :3,DESCRIPTION = :4,ICON
_URL = :5,INFO_URL = :6,SKIN = :7,PUBLISHED = :8,JOINABLE = :9,PUBVIEW = :10,JOI
N_ROLE = :11,IS_SPECIAL = :12,IS_USER = :13,CREATEDBY = :14,MODIFIEDBY = :15,CRE
ATEDON = :16,MODIFIEDON = :17,CUSTOM_PAGE_ORDERED = :18 where ( SITE_ID = :19 )
138 270 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
= :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =
76 22 6ma5vzd75tgv3
Module: TOAD 8.5.3.2
INSERT INTO "TOAD_PLAN_TABLE" ("STATEMENT_ID","TIMESTAMP","OPERATION","OPTIONS"
,"OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_INSTANCE","OBJECT_TYPE","SEA
RCH_COLUMNS","ID","PARENT_ID","POSITION","OTHER","OPTIMIZER","COST","CARDINALITY
","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","DISTRIB
60 552 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join
60 552 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join
46 14 9z4r824szyb5f
Module: JDBC Thin Client
insert into MFR_MESSAGE_T (VERSION, UUID, CREATED, CREATED_BY, MODIFIED, MODIFIE
D_BY, TITLE, BODY, AUTHOR, HAS_ATTACHMENTS, GRADECOMMENT, GRADEASSIGNMENTNAME, L
ABEL, IN_REPLY_TO, GRADEBOOK, GRADEBOOK_ASSIGNMENT, TYPE_UUID, APPROVED, DRAFT,
DELETED, surrogateKey, MESSAGE_DTYPE, ID) values (:1, :2, :3, :4, :5, :6, :7, :8
38 35 fdja9g0p9m49n
Module: JDBC Thin Client
INSERT INTO SAKAI_REALM_RL_GR (REALM_KEY, USER_ID, ROLE_KEY, ACTIVE, PROVIDED) V
ALUES ( (SELECT REALM_KEY FROM SAKAI_REALM WHERE REALM_ID = :1), :2, (SELECT RO
LE_KEY FROM SAKAI_REALM_ROLE WHERE ROLE_NAME = :3), :4, :5)
36 83,331 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
36 7,345 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and
33 2 1szjknxf56j5c
Module: JDBC Thin Client
update MFR_OPEN_FORUM_T set VERSION=:1, UUID=:2, CREATED=:3, CREATED_BY=:4, MODI
FIED=:5, MODIFIED_BY=:6, DEFAULTASSIGNNAME=:7, TITLE=:8, SHORT_DESCRIPTION=:9, E
XTENDED_DESCRIPTION=:10, TYPE_UUID=:11, SORT_INDEX=:12, LOCKED=:13, DRAFT=:14, s
urrogateKey=:15, MODERATED=:16 where ID=:17 and VERSION=:18
30 28 f1nzkyqwq6sq3
Module: JDBC Thin Client
update MFR_TOPIC_T set VERSION=:1, UUID=:2, CREATED=:3, CREATED_BY=:4, MODIFIED=
:5, MODIFIED_BY=:6, DEFAULTASSIGNNAME=:7, TITLE=:8, SHORT_DESCRIPTION=:9, EXTEND
ED_DESCRIPTION=:10, MODERATED=:11, MUTABLE=:12, SORT_INDEX=:13, TYPE_UUID=:14, o
f_surrogateKey=:15, pf_surrogateKey=:16, LOCKED=:17, DRAFT=:18, CONFIDENTIAL_RES
24 898 9vfd0br7guzvm
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0 and (messageimp0_.APPROVED=1 or messageimp0
-------------------------------------------------------------
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 65,148 23.1 7.7
CPU used when call started 47,444 16.8 5.6
CR blocks created 2,830 1.0 0.3
Cached Commit SCN referenced 134,300 47.6 15.8
Commit SCN cached 1,019 0.4 0.1
DB time 920,881 326.6 108.3
DBWR checkpoint buffers written 1,222 0.4 0.1
DBWR checkpoints 0 0.0 0.0
DBWR object drop buffers written 0 0.0 0.0
DBWR revisited being-written buf 0 0.0 0.0
DBWR tablespace checkpoint buffe 0 0.0 0.0
DBWR thread checkpoint buffers w 1,222 0.4 0.1
DBWR transaction table writes 31 0.0 0.0
DBWR undo block writes 4,868 1.7 0.6
IMU CR rollbacks 120 0.0 0.0
IMU Flushes 3,906 1.4 0.5
IMU Redo allocation size 4,278,828 1,517.4 503.4
IMU commits 5,036 1.8 0.6
IMU contention 34 0.0 0.0
IMU ktichg flush 514 0.2 0.1
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 25 0.0 0.0
IMU undo allocation size 13,847,772 4,910.7 1,629.2
IMU- failed to get a private str 0 0.0 0.0
SMON posted for dropping temp se 0 0.0 0.0
SMON posted for undo segment rec 0 0.0 0.0
SMON posted for undo segment shr 0 0.0 0.0
SQL*Net roundtrips to/from clien 1,996,699 708.1 234.9
SQL*Net roundtrips to/from dblin 906 0.3 0.1
active txn count during cleanout 867 0.3 0.1
application wait time 31 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 9,023 3.2 1.1
branch node splits 3 0.0 0.0
buffer is not pinned count 23,525,263 8,342.5 2,767.7
buffer is pinned count 29,792,933 10,565.1 3,505.1
bytes received via SQL*Net from 1,016,492,017 360,466.1 119,587.3
bytes received via SQL*Net from 370,264 131.3 43.6
bytes sent via SQL*Net to client 2,272,412,393 805,837.7 267,342.6
bytes sent via SQL*Net to dblink 381,215 135.2 44.9
calls to get snapshot scn: kcmgs 2,614,733 927.2 307.6
calls to kcmgas 37,357 13.3 4.4
calls to kcmgcs 1,808 0.6 0.2
change write time 1,274 0.5 0.2
cleanout - number of ktugct call 6,274 2.2 0.7
cleanouts and rollbacks - consis 25 0.0 0.0
cleanouts only - consistent read 5,151 1.8 0.6
cluster key scan block gets 194,465 69.0 22.9
cluster key scans 72,006 25.5 8.5
commit batch performed 41 0.0 0.0
commit batch requested 41 0.0 0.0
commit batch/immediate performed 69 0.0 0.0
commit batch/immediate requested 69 0.0 0.0
commit cleanout failures: block 1,776 0.6 0.2
commit cleanout failures: buffer 1 0.0 0.0
commit cleanout failures: callba 180 0.1 0.0
commit cleanout failures: cannot 8 0.0 0.0
commit cleanouts 38,160 13.5 4.5
commit cleanouts successfully co 36,195 12.8 4.3
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed 28 0.0 0.0
commit immediate requested 28 0.0 0.0
commit txn count during cleanout 6,785 2.4 0.8
concurrency wait time 620 0.2 0.1
consistent changes 52,321 18.6 6.2
consistent gets 53,377,406 18,928.6 6,279.7
consistent gets - examination 10,509,539 3,726.9 1,236.4
consistent gets direct 63,544 22.5 7.5
consistent gets from cache 53,313,863 18,906.0 6,272.2
current blocks converted for CR 0 0.0 0.0
cursor authentications 697 0.3 0.1
data blocks consistent reads - u 3,889 1.4 0.5
db block changes 563,477 199.8 66.3
db block gets 647,259 229.5 76.2
db block gets direct 14,298 5.1 1.7
db block gets from cache 632,961 224.5 74.5
deferred (CURRENT) block cleanou 16,577 5.9 2.0
dirty buffers inspected 14,452 5.1 1.7
enqueue conversions 3,807 1.4 0.5
enqueue releases 77,323 27.4 9.1
enqueue requests 77,351 27.4 9.1
enqueue timeouts 32 0.0 0.0
enqueue waits 2 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 714,094 253.2 84.0
failed probes on index block rec 12 0.0 0.0
frame signature mismatch 0 0.0 0.0
free buffer inspected 1,489,604 528.2 175.3
free buffer requested 1,308,099 463.9 153.9
heap block compress 1,103 0.4 0.1
hot buffers moved to head of LRU 162,612 57.7 19.1
immediate (CR) block cleanout ap 5,176 1.8 0.6
immediate (CURRENT) block cleano 7,761 2.8 0.9
index crx upgrade (found) 10 0.0 0.0
index crx upgrade (positioned) 541,480 192.0 63.7
index fast full scans (full) 2,078 0.7 0.2
index fetch by key 3,720,925 1,319.5 437.8
index scans kdiixs1 5,390,023 1,911.4 634.1
leaf node 90-10 splits 134 0.1 0.0
leaf node splits 558 0.2 0.1
lob reads 36,851 13.1 4.3
lob writes 40,636 14.4 4.8
lob writes unaligned 40,441 14.3 4.8
logons cumulative 143 0.1 0.0
messages received 9,776 3.5 1.2
messages sent 9,776 3.5 1.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 41,659,821 14,773.3 4,901.2
opened cursors cumulative 72,689 25.8 8.6
parse count (failures) 1,294 0.5 0.2
parse count (hard) 2,675 1.0 0.3
parse count (total) 59,573 21.1 7.0
parse time cpu 554 0.2 0.1
parse time elapsed 2,132 0.8 0.3
physical read IO requests 386,175 136.9 45.4
physical read bytes 11,121,688,576 3,943,947.9 1,308,434.0
physical read total IO requests 390,451 138.5 45.9
physical read total bytes 11,191,237,632 3,968,611.2 1,316,616.2
physical read total multi block 93,205 33.1 11.0
physical reads 1,357,629 481.4 159.7
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache 1,292,422 458.3 152.1
physical reads cache prefetch 974,110 345.4 114.6
physical reads direct 65,206 23.1 7.7
physical reads direct (lob) 63,446 22.5 7.5
physical reads direct temporary 1,695 0.6 0.2
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 14,575 5.2 1.7
physical write bytes 288,268,288 102,225.0 33,913.9
physical write total IO requests 33,153 11.8 3.9
physical write total bytes 515,702,784 182,877.4 60,670.9
physical write total multi block 20,107 7.1 2.4
physical writes 35,189 12.5 4.1
physical writes direct 15,993 5.7 1.9
physical writes direct (lob) 140 0.1 0.0
physical writes direct temporary 15,847 5.6 1.9
physical writes from cache 19,196 6.8 2.3
physical writes non checkpoint 33,968 12.1 4.0
pinned buffers inspected 170 0.1 0.0
prefetch clients - default 0 0.0 0.0
prefetch warmup blocks aged out 0 0.0 0.0
prefetched blocks aged out befor 388,295 137.7 45.7
process last non-idle time 1,921 0.7 0.2
recovery blocks read 0 0.0 0.0
recursive calls 1,084,204 384.5 127.6
recursive cpu usage 19,286 6.8 2.3
redo blocks read for recovery 0 0.0 0.0
redo blocks written 177,498 62.9 20.9
redo buffer allocation retries 0 0.0 0.0
redo entries 249,909 88.6 29.4
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 1 0.0 0.0
redo size 85,676,396 30,382.4 10,079.6
redo synch time 16,385 5.8 1.9
redo synch writes 274,616 97.4 32.3
redo wastage 2,206,848 782.6 259.6
redo write time 21,535 7.6 2.5
redo writer latching time 5 0.0 0.0
redo writes 8,627 3.1 1.0
rollback changes - undo records 0 0.0 0.0
rollbacks only - consistent read 2,806 1.0 0.3
rows fetched via callback 3,349,418 1,187.8 394.1
session connect time 0 0.0 0.0
session cursor cache hits 66,174 23.5 7.8
session logical reads 54,024,654 19,158.1 6,355.8
session pga memory 69,523,268 24,654.2 8,179.2
session pga memory max 79,567,304 28,216.0 9,360.9
session uga memory 188,984,507,364 67,017,256.2 22,233,471.5
session uga memory max 80,916,464 28,694.4 9,519.6
shared hash latch upgrades - no 582,222 206.5 68.5
shared hash latch upgrades - wai 10 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 47,116 16.7 5.5
sorts (rows) 47,153,796 16,721.6 5,547.5
sql area evicted 231 0.1 0.0
sql area purged 1,398 0.5 0.2
summed dirty queue length 19,140 6.8 2.3
switch current to new buffer 1,697 0.6 0.2
table fetch by rowid 20,150,691 7,145.8 2,370.7
table fetch continued row 88,586 31.4 10.4
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
table scan blocks gotten 22,255,933 7,892.4 2,618.4
table scan rows gotten 533,315,251 189,123.0 62,743.0
table scans (long tables) 39 0.0 0.0
table scans (short tables) 74,498 26.4 8.8
total number of times SMON poste 91 0.0 0.0
transaction rollbacks 69 0.0 0.0
transaction tables consistent re 0 0.0 0.0
transaction tables consistent re 0 0.0 0.0
undo change vector size 32,375,276 11,480.9 3,808.9
user I/O wait time 110,921 39.3 13.1
user calls 2,022,185 717.1 237.9
user commits 8,412 3.0 1.0
user rollbacks 88 0.0 0.0
workarea executions - onepass 6 0.0 0.0
workarea executions - optimal 39,263 13.9 4.6
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 69 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: SAKAI/sakai Snaps: 3268-32
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 391,290 393,756
opened cursors current 36,655 36,893
workarea memory allocated 1,433 1,433
logons current 1,040 1,038
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai Snaps: 3268-326
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
-------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DATA_TS
365,253 130 1.9 3.5 6,691 2 43,781 7.4
SYSAUX
9,752 3 7.8 3.1 2,681 1 0 0.0
SYSTEM
5,712 2 3.6 1.6 1,440 1 14 8.6
ARCH_TS
4,466 2 5.9 9.2 0 0 0 0.0
TEMP
749 0 2.5 14.9 2,518 1 0 0.0
UNDOTBS1
486 0 2.5 1.0 1,227 0 1 0.0
INDEX_TS
58 0 2.2 1.3 18 0 0 0.0
TEMP2
1 0 40.0 1.0 0 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ARCH_TS /local/d02/oracle/sakai/arch01.dbf
4,466 2 5.9 9.2 0 0 0 0.0
DATA_TS /local/d02/oracle/sakai/data01.dbf
322,751 114 2.0 3.6 5,408 2 39,523 7.0
DATA_TS /local/d02/oracle/sakai/data02.dbf
42,502 15 1.1 2.2 1,283 0 4,258 11.0
INDEX_TS /local/d02/oracle/sakai/index01.dbf
58 0 2.2 1.3 18 0 0 0.0
SYSAUX /local/d02/oracle/sakai/sysaux01.dbf
9,752 3 7.8 3.1 2,681 1 0 0.0
SYSTEM /local/d02/oracle/sakai/system01.dbf
5,712 2 3.6 1.6 1,440 1 14 8.6
TEMP /local/d02/oracle/sakai/temp01.dbf
7 0 8.6 1.0 7 0 0 N/A
TEMP /local/d02/oracle/sakai/temp02.dbf
742 0 2.4 15.0 2,511 1 0 N/A
TEMP2 /local/d03/oracle/sakai/temp03.dbf
1 0 40.0 1.0 0 0 0 N/A
UNDOTBS1 /local/d02/oracle/sakai/undotbs01.dbf
486 0 2.5 1.0 1,227 0 1 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Writ Buffer
Number of Pool Buffer Physical Physical Buff Comp Busy
P Buffers Hit% Gets Reads Writes Wait Wait Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D 88,589 98 53,944,455 1,292,515 19,196 0 0 43,796
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> B: Begin snapshot, E: End snapshot
Targt Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B 0 0 1182 26744 25969 737280 25969 N/A
E 0 0 2011 35349 35373 737280 35373 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: SAKAI/sakai Snap: 3269
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate
Est
Phys
Size for Size Buffers for Read Estimated
P Est (M) Factor Estimate Factor Physical Reads
--- -------- ------ ---------------- ------ ------------------
D 64 .1 7,996 1.6 595,506,772
D 128 .2 15,992 1.4 515,898,522
D 192 .3 23,988 1.2 458,956,633
D 256 .4 31,984 1.1 425,210,203
D 320 .4 39,980 1.1 402,429,389
D 384 .5 47,976 1.0 388,936,925
D 448 .6 55,972 1.0 380,942,255
D 512 .7 63,968 1.0 376,943,710
D 576 .8 71,964 1.0 375,407,251
D 640 .9 79,960 1.0 374,766,293
D 704 1.0 87,956 1.0 374,534,782
D 720 1.0 89,955 1.0 374,495,224
D 768 1.1 95,952 1.0 374,376,857
D 832 1.2 103,948 1.0 374,258,367
D 896 1.2 111,944 1.0 374,169,937
D 960 1.3 119,940 1.0 374,101,184
D 1,024 1.4 127,936 1.0 374,043,842
D 1,088 1.5 135,932 1.0 373,992,572
D 1,152 1.6 143,928 1.0 373,950,819
D 1,216 1.7 151,924 1.0 373,891,758
D 1,280 1.8 159,920 1.0 373,851,744
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ------------------ --------------------------
98.3 2,669 45
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem - percentage of workarea memory under manual control
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- ---------- ---------- ---------- ---------- ------ ------ ------ ----------
B 800 152 1,008.9 1.4 .1 100.0 .0 102,400
E 800 151 961.6 1.4 .1 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 36,604 36,604 0 0
64K 128K 374 374 0 0
128K 256K 509 509 0 0
256K 512K 189 189 0 0
512K 1024K 1,227 1,227 0 0
1M 2M 281 281 0 0
2M 4M 26 26 0 0
4M 8M 23 19 4 0
8M 16M 13 11 2 0
32M 64M 23 23 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: SAKAI/sakai Snap: 3269
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr Processed Written to Disk Hit % Count
---------- ------- ---------------- ---------------- -------- ----------
100 0.1 406,587.1 54,975.7 88.0 2,422
200 0.3 406,587.1 54,937.8 88.0 2,422
400 0.5 406,587.1 51,801.1 89.0 2,313
600 0.8 406,587.1 36,730.8 92.0 1,247
800 1.0 406,587.1 3,476.5 99.0 0
960 1.2 406,587.1 3,337.4 99.0 0
1,120 1.4 406,587.1 3,337.4 99.0 0
1,280 1.6 406,587.1 3,337.4 99.0 0
1,440 1.8 406,587.1 3,337.4 99.0 0
1,600 2.0 406,587.1 3,337.4 99.0 0
2,400 3.0 406,587.1 3,337.4 99.0 0
3,200 4.0 406,587.1 3,337.4 99.0 0
4,800 6.0 406,587.1 3,337.4 99.0 0
6,400 8.0 406,587.1 3,337.4 99.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: SAKAI/sakai Snap: 3269
-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid.
Est LC Est LC Est LC Est LC
Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
256 .3 88 9,177 ####### 1.0 ####### 52.3 27,736,785
336 .5 164 11,466 ####### 1.0 ####### 35.8 27,761,117
416 .6 243 14,706 ####### 1.0 92,660 22.3 27,781,215
496 .7 322 17,504 ####### 1.0 58,911 14.2 27,793,576
576 .8 401 22,075 ####### 1.0 35,911 8.6 27,801,900
656 .9 480 26,029 ####### 1.0 18,325 4.4 27,806,522
736 1.0 559 29,669 ####### 1.0 4,158 1.0 27,809,336
816 1.1 638 35,537 ####### 1.0 1 .0 27,811,500
896 1.2 717 39,510 ####### 1.0 1 .0 27,813,358
976 1.3 796 43,073 ####### 1.0 1 .0 27,815,011
1,056 1.4 865 48,375 ####### 1.0 1 .0 27,816,514
1,136 1.5 865 48,375 ####### 1.0 1 .0 27,818,027
1,216 1.7 865 48,375 ####### 1.0 1 .0 27,819,464
1,296 1.8 944 51,988 ####### 1.0 1 .0 27,820,897
1,376 1.9 1,017 55,329 ####### 1.0 1 .0 27,822,323
1,456 2.0 1,017 55,329 ####### 1.0 1 .0 27,823,746
1,536 2.1 1,017 55,329 ####### 1.0 1 .0 27,825,170
-------------------------------------------------------------
SGA Target Advisory DB/Inst: SAKAI/sakai Snap: 3269
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
752 0.5 340,778 515,529,696
1,128 0.8 269,291 402,132,637
1,504 1.0 255,494 374,494,912
1,880 1.3 255,239 373,783,372
2,256 1.5 255,187 373,596,124
2,632 1.8 255,187 373,596,124
3,008 2.0 255,187 373,596,124
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: SAKAI/sakai Snap: 3269
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: SAKAI/sakai Snap: 3269
Est LC Est LC Est LC Est LC
Java JP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
16 1.0 2 76 1 1.0 4,158 1.0 76
32 2.0 2 76 1 1.0 4,158 1.0 76
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 43,791 324 7
segment header 4 0 10
undo header 1 0 0
-------------------------------------------------------------
Enqueue Activity DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc
Enqueue Type (Request Reason)
------------------------------------------------------------------------------
Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
TX-Transaction (row lock contention)
2 2 0 2 0 15.00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count, OOS - Out of Space count
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
1 4.4 10,670 1,459 11 5760/5760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Most recent 35 Undostat rows, ordered by Time desc
Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
08-Oct 22:40 256 1,458 222 9 5,760 0/0 0/0/0/0/0/0
08-Oct 22:30 292 1,679 913 4 5,760 0/0 0/0/0/0/0/0
08-Oct 22:20 174 1,346 1,459 9 5,760 0/0 0/0/0/0/0/0
08-Oct 22:10 3,642 6,187 858 11 5,760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch 1,858 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 62,847 0.0 N/A 0 0 N/A
Consistent RBA 8,630 0.0 N/A 0 0 N/A
FAL request queue 57 0.0 N/A 0 0 N/A
FAL subheap alocation 57 0.0 N/A 0 0 N/A
FIB s.o chain latch 4 0.0 N/A 0 0 N/A
FOB s.o list latch 308 0.0 N/A 0 0 N/A
In memory undo latch 59,228 0.0 N/A 0 10,890 0.0
JS mem alloc latch 10 0.0 N/A 0 0 N/A
JS queue access latch 10 0.0 N/A 0 0 N/A
JS queue state obj latch 20,320 0.0 N/A 0 0 N/A
JS slv state obj latch 200 0.0 N/A 0 0 N/A
KMG MMAN ready and start 1,004 0.0 N/A 0 0 N/A
KMG resize request state 2 0.0 N/A 0 0 N/A
KTF sga latch 5 0.0 N/A 0 831 0.0
MQL Tracking Latch 0 N/A N/A 0 56 0.0
Memory Management Latch 100 1.0 1.0 0 1,004 0.0
OS process 495 0.0 N/A 0 0 N/A
OS process allocation 1,267 0.0 N/A 0 0 N/A
OS process: request allo 199 0.0 N/A 0 0 N/A
PL/SQL warning settings 784 0.0 N/A 0 0 N/A
SGA IO buffer pool latch 401 0.0 N/A 0 401 0.0
SQL memory manager latch 1 0.0 N/A 0 929 0.0
SQL memory manager worka 1,104,406 0.0 0.0 0 0 N/A
Shared B-Tree 111 0.0 N/A 0 0 N/A
active checkpoint queue 1,505 0.0 N/A 0 0 N/A
active service list 7,104 0.0 N/A 0 946 0.0
archive control 342 0.0 N/A 0 0 N/A
archive process latch 986 0.0 N/A 0 0 N/A
begin backup scn array 141 0.0 N/A 0 0 N/A
buffer pool 3 0.0 N/A 0 0 N/A
cache buffer handles 577,079 0.0 0.0 0 0 N/A
cache buffers chains 100,040,284 0.0 0.1 0 3,082,692 0.0
cache buffers lru chain 1,374,048 0.2 0.0 0 1,245,057 0.3
cache table scan latch 0 N/A N/A 0 92,788 0.1
channel handle pool latc 371 0.0 N/A 0 0 N/A
channel operations paren 14,282 0.0 0.0 0 0 N/A
checkpoint queue latch 38,740 0.0 N/A 0 22,059 0.0
client/application info 63 0.0 N/A 0 0 N/A
commit callback allocati 100 0.0 N/A 0 0 N/A
compile environment latc 289,520 0.0 N/A 0 0 N/A
constraint object alloca 82 0.0 N/A 0 0 N/A
dictionary lookup 61 0.0 N/A 0 0 N/A
dml lock allocation 43,381 0.0 N/A 0 0 N/A
dummy allocation 288 0.0 N/A 0 0 N/A
enqueue hash chains 158,506 0.0 0.0 0 221 0.0
enqueues 376,735 0.0 0.0 0 0 N/A
event group latch 98 0.0 N/A 0 0 N/A
file cache latch 139 0.0 N/A 0 0 N/A
global KZLD latch for me 64 0.0 N/A 0 0 N/A
global tx hash mapping 5,890 0.0 N/A 0 0 N/A
hash table column usage 153 0.0 N/A 0 71,889 0.0
hash table modification 125 0.0 N/A 0 0 N/A
job workq parent latch 0 N/A N/A 0 69 0.0
job_queue_processes para 63 0.0 N/A 0 0 N/A
kks stats 4,593 0.0 N/A 0 0 N/A
ksuosstats global area 190 0.0 N/A 0 0 N/A
ktm global data 93 0.0 N/A 0 0 N/A
kwqbsn:qsga 111 0.0 N/A 0 0 N/A
lgwr LWN SCN 9,104 0.0 N/A 0 0 N/A
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
library cache 671,051 0.0 0.2 0 780 0.0
library cache load lock 2,038 0.0 N/A 0 2 0.0
library cache lock 199,682 0.0 0.0 0 0 N/A
library cache lock alloc 3,026 0.2 0.8 0 0 N/A
library cache pin 74,024 0.0 0.0 0 0 N/A
library cache pin alloca 2,607 0.0 N/A 0 0 N/A
list of block allocation 1,081 0.0 N/A 0 0 N/A
loader state object free 64,756 0.0 N/A 0 0 N/A
longop free list parent 262 0.0 N/A 0 271 0.0
message pool operations 196 0.0 N/A 0 0 N/A
messages 47,586 0.0 N/A 0 0 N/A
mostly latch-free SCN 9,102 0.0 N/A 0 0 N/A
multiblock read objects 226,426 0.0 0.5 0 0 N/A
ncodef allocation latch 45 0.0 N/A 0 0 N/A
object queue header heap 7,091 0.0 N/A 0 5,728 0.0
object queue header oper 2,677,263 0.0 0.0 0 3,968 0.0
object stats modificatio 175 0.0 N/A 0 0 N/A
parallel query alloc buf 372 0.0 N/A 0 0 N/A
parameter table allocati 230 0.0 N/A 0 0 N/A
post/wait queue 16,533 0.0 N/A 0 6,369 0.0
process allocation 199 0.0 N/A 0 98 0.0
process group creation 199 0.0 N/A 0 0 N/A
qmn task queue latch 404 0.0 N/A 0 0 N/A
redo allocation 289,409 0.0 0.1 0 0 N/A
redo copy 0 N/A N/A 0 249,899 0.1
redo writing 29,261 0.0 N/A 0 0 N/A
row cache objects 3,430,761 0.0 0.0 0 0 N/A
sequence cache 19,694 0.0 N/A 0 0 N/A
session allocation 862,955 0.0 0.0 0 0 N/A
session idle bit 4,334,554 0.0 0.1 0 0 N/A
session state list latch 375 0.0 N/A 0 0 N/A
session switching 56 0.0 N/A 0 0 N/A
session timer 946 0.0 N/A 0 0 N/A
shared pool 169,459 0.0 0.2 0 0 N/A
shared pool sim alloc 47 0.0 N/A 0 0 N/A
shared pool simulator 19,676 0.0 N/A 0 0 N/A
simulator hash latch 2,300,374 0.0 0.0 0 0 N/A
simulator lru latch 2,086,781 0.1 0.1 0 97,222 0.1
slave class 2 0.0 N/A 0 0 N/A
slave class create 7 0.0 N/A 0 0 N/A
sort extent pool 863 0.0 N/A 0 0 N/A
state object free list 2 0.0 N/A 0 0 N/A
statistics aggregation 140 0.0 N/A 0 0 N/A
temp lob duration state 4 0.0 N/A 0 0 N/A
temporary table state ob 13 0.0 N/A 0 0 N/A
threshold alerts latch 227 0.0 N/A 0 0 N/A
transaction allocation 556 0.0 N/A 0 0 N/A
transaction branch alloc 4,664 0.0 N/A 0 0 N/A
undo global data 70,258 0.0 0.0 0 0 N/A
user lock 524 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
100,040,284 3,750 470 3,430 0 0 0
cache buffers lru chain
1,374,048 2,991 132 2,866 0 0 0
simulator lru latch
2,086,781 2,367 204 2,198 0 0 0
session idle bit
4,334,554 168 25 144 0 0 0
session allocation
862,955 166 5 161 0 0 0
library cache
671,051 143 34 109 0 0 0
row cache objects
3,430,761 141 4 137 0 0 0
object queue header operation
2,677,263 45 1 44 0 0 0
redo allocation
289,409 36 3 33 0 0 0
shared pool
169,459 20 3 17 0 0 0
multiblock read objects
226,426 8 4 5 0 0 0
library cache lock allocation
3,026 5 4 1 0 0 0
Memory Management Latch
100 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
Memory Management Latch kmgs_perform_parameter_upd 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 443 482
cache buffers chains kcbrls: kslbegin 0 58 41
cache buffers chains kcbgtcr: fast path 0 32 10
cache buffers chains kcbzwb 0 21 21
cache buffers chains kcbchg: kslbegin: bufs not 0 6 1
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers chains kcbzib: finish free bufs 0 1 7
cache buffers lru chain kcbzgws_1 0 120 125
cache buffers lru chain kcbzar: KSLNBEGIN 0 10 0
cache buffers lru chain kcbzgm 0 2 0
library cache kglic 0 17 0
library cache kglLockCursor 0 6 7
library cache kgldti: 2child 0 2 0
library cache kgldte: child 0 0 1 19
library cache kglhdgc: child: 0 1 0
library cache kglhdiv: child 0 1 0
library cache kglobpn: child: 0 1 3
library cache kglpin 0 1 1
library cache kglpndl: child: before pro 0 1 1
library cache kglpur: child 0 1 2
library cache lock kgllkdl: child: no lock ha 0 2 1
library cache lock alloc kgllkget 0 4 4
multiblock read objects kcbzib: normal mbr free 0 4 2
object queue header oper kcbw_unlink_q 0 1 0
redo allocation kcrfw_redo_gen 0 3 3
row cache objects kqreqd 0 2 0
row cache objects kqreqd: reget 0 2 0
session allocation ksudlc 0 3 1
session allocation ksuprc 0 2 1
session idle bit ksupuc: clear busy 0 14 8
session idle bit ksupuc: set busy 0 12 15
session idle bit ksuxds 0 1 4
shared pool kgh_next_free 0 3 0
simulator lru latch kcbs_simulate: simulate se 0 200 203
simulator lru latch kcbs_lookup_setid 0 3 0
simulator lru latch kcbs_free_granule_sim_buff 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Logical Reads: 54,024,654
-> Captured Segments account for 91.4% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI_EXTE DATA_TS COURSEMANAGEMENT_INS TABLE 10,982,288 20.33
SAKAI_EXTE DATA_TS CM_INST_TA_PERSON_ID INDEX 3,658,144 6.77
SYS SYSTEM IND$ TABLE 3,491,856 6.46
SYS SYSTEM TAB$ TABLE 3,476,544 6.44
SYS SYSTEM CLU$ TABLE 3,466,080 6.42
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> Total Physical Reads: 1,357,629
-> Captured Segments account for 45.9% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS CONTENT_RESOURCE TABLE 174,818 12.88
SAKAI_EXTE DATA_TS COURSEMANAGEMENT_SEC TABLE 154,680 11.39
SAKAI DATA_TS SAKAI_SESSION TABLE 58,931 4.34
SAKAI DATA_TS SYS_LOB0000046053C00 LOB 42,598 3.14
SAKAI DATA_TS CONTENT_COLLECTION TABLE 36,669 2.70
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SYS_C004168 INDEX 32 41.03
SAKAI DATA_TS IE_SAKAI_SITE_FLAGS INDEX 31 39.74
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 4 5.13
SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ INDEX 4 5.13
SAKAI DATA_TS SYS_C003787 INDEX 2 2.56
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM SUM$ TABLE 6 60.00
SYS SYSTEM I_JOB_NEXT INDEX 2 20.00
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 1 10.00
SAKAI DATA_TS SAKAI_SESSION TABLE 1 10.00
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> "Pct Misses" should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control 51 0.0 0 N/A 2 1
dc_constraints 312 33.3 0 N/A 312 1
dc_database_links 491 0.0 0 N/A 0 6
dc_global_oids 78 0.0 0 N/A 0 151
dc_histogram_data 9,853 23.1 0 N/A 4,421 12,264
dc_histogram_defs 14,976 22.8 0 N/A 2,505 5,713
dc_object_ids 17,524 0.4 0 N/A 51 2,539
dc_objects 9,034 3.2 0 N/A 145 3,238
dc_profiles 110 0.0 0 N/A 0 1
dc_rollback_segments 12,316 0.0 0 N/A 0 392
dc_segments 13,166 0.1 0 N/A 5 2,465
dc_sequences 355 0.0 0 N/A 355 55
dc_table_scns 35 100.0 0 N/A 0 0
dc_tablespace_quotas 2 0.0 0 N/A 1 6
dc_tablespaces 526,368 0.0 0 N/A 0 9
dc_usernames 2,624 0.0 0 N/A 0 36
dc_users 536,412 0.0 0 N/A 0 88
global database name 82 0.0 0 N/A 0 1
outstanding_alerts 88 0.0 0 N/A 0 17
-------------------------------------------------------------
Library Cache Activity DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,031 0.0 1,263 0.0 0 0
CLUSTER 34 0.0 79 0.0 0 0
INDEX 922 14.4 3,263 9.0 0 0
SQL AREA 1,066 100.0 744,672 0.9 1,487 266
TABLE/PROCEDURE 5,325 1.0 30,196 2.6 340 0
TRIGGER 558 0.0 652 0.0 0 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> B: Begin snap E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
-> Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> ordered by Begin/End snapshot, Alloc (MB) desc
Hist
Avg Std Dev Max Max
Alloc Used Alloc Alloc Alloc Alloc Num Num
Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other 772.9 N/A .7 2.3 64 64 1,042 1,042
Freeable 162.9 .0 .7 2.8 45 N/A 245 245
SQL 71.3 22.8 .1 .1 1 106 1,031 1,023
PL/SQL 2.7 .6 .0 .0 0 0 1,040 1,040
E Other 767.0 N/A .7 2.3 64 64 1,039 1,039
Freeable 121.3 .0 .5 .3 1 N/A 241 241
SQL 71.6 22.8 .1 .1 1 106 1,028 1,022
PL/SQL 2.6 .4 .0 .0 0 0 1,037 1,037
-------------------------------------------------------------
SGA Memory Summary DB/Inst: SAKAI/sakai Snaps: 3268-3269
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 788,529,152 754,974,720
Fixed Size 1,262,764
Redo Buffers 15,511,552
Variable Size 1,291,848,532 1,325,402,964
-------------------
sum 2,097,152,000
-------------------------------------------------------------
SGA breakdown difference DB/Inst: SAKAI/sakai Snaps: 3268-3269
-> ordered by Pool, Name
-> N/A value for Begin MB or End MB indicates the size of that Pool/Name was
insignificant, or zero in that snapshot
Pool Name Begin MB End MB % Diff
------ ------------------------------ -------------- -------------- -------
java free memory 11.8 11.8 0.00
java joxlod exec hp 4.1 4.1 0.00
large free memory 15.9 15.9 0.00
shared CCursor 54.9 58.6 6.68
shared Heap0: KGL 10.5 11.0 4.65
shared KGH: NO ACCESS 69.3 69.3 0.00
shared KGLS heap 10.5 9.2 -12.17
shared KTI-UNDO 14.7 14.7 0.00
shared PCursor 20.1 20.9 4.00
shared event statistics per sess 15.7 15.7 0.00
shared free memory 86.2 80.1 -7.06
shared library cache 32.6 33.9 3.85
shared private strands 14.2 14.2 0.00
shared sessions 9.4 9.4 0.00
shared sql area 307.9 339.8 10.36
shared trace buffer 16.5 16.5 0.00
buffer_cache 752.0 720.0 -4.26
fixed_sga 1.2 1.2 0.00
log_buffer 14.8 14.8 0.00
-------------------------------------------------------------
Streams CPU/IO Usage DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: SAKAI/sakai Snaps: 3268-3269
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: SAKAI/sakai Snap: 3269
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: SAKAI/sakai Snaps: 3268-3269
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /opt/pkg/oracle/product/10.2.0/ad
background_dump_dest /opt/pkg/oracle/product/10.2.0/ad
compatible 10.2.0.1.0
control_files /opt/pkg/oracle/data/sakai/contro
core_dump_dest /opt/pkg/oracle/product/10.2.0/ad
db_block_size 8192
db_domain ucdavis.edu
db_file_multiblock_read_count 16
db_name sakai
dispatchers (PROTOCOL=TCP) (SERVICE=sakaiXDB)
job_queue_processes 10
log_archive_dest /opt/pkg/oracle/data/sakai/archiv
open_cursors 300
optimizer_mode FIRST_ROWS
pga_aggregate_target 838860800
processes 1850
remote_login_passwordfile EXCLUSIVE
sga_max_size 2097152000
sga_target 1577058304
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest /opt/pkg/oracle/product/10.2.0/ad
-------------------------------------------------------------
End of Report