awr-2007-10-09_10-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: 3283 09-Oct-07 10:00:44 1,036 9.5
End Snap: 3287 09-Oct-07 14:00:50 1,029 12.7
Elapsed: 240.10 (mins)
DB Time: 41.49 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 688M 688M Std Block Size: 8K
Shared Pool Size: 768M 768M Log Buffer: 15,148K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 9,352.09 4,825.98
Logical reads: 7,660.87 3,953.25
Block changes: 43.50 22.45
Physical reads: 28.44 14.68
Physical writes: 3.36 1.73
User calls: 624.71 322.37
Parses: 8.26 4.26
Hard parses: 0.06 0.03
Sorts: 10.13 5.23
Logons: 0.05 0.02
Executes: 228.29 117.81
Transactions: 1.94
% Blocks changed per Read: 0.57 Recursive Call %: 11.92
Rollback per transaction %: 0.97 Rows per Sort: 9.54
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.85 In-memory Sort %: 100.00
Library Hit %: 99.93 Soft Parse %: 99.31
Execute to Parse %: 96.38 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 15.09 % Non-Parse CPU: 99.65
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 87.56 89.94
% SQL with executions>1: 97.04 97.40
% Memory for SQL w/exec>1: 94.40 95.13
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 2,112 84.9
log file sync 27,695 342 12 13.7 Commit
log file parallel write 28,318 336 12 13.5 System I/O
SQL*Net more data from client 1,202,059 129 0 5.2 Network
control file parallel write 4,770 104 22 4.2 System I/O
-------------------------------------------------------------
Time Model Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total time in database user-calls (DB Time): 2489.4s
-> 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
------------------------------------------ ------------------ ------------
DB CPU 2,112.4 84.9
sql execute elapsed time 2,018.2 81.1
parse time elapsed 42.5 1.7
hard parse elapsed time 35.7 1.4
failed parse elapsed time 26.4 1.1
PL/SQL execution elapsed time 24.0 1.0
repeated bind elapsed time 17.1 .7
hard parse (sharing criteria) elapsed time 1.9 .1
connection management call elapsed time 0.9 .0
hard parse (bind mismatch) elapsed time 0.9 .0
sequence load elapsed time 0.7 .0
PL/SQL compilation elapsed time 0.0 .0
DB time 2,489.4 N/A
background elapsed time 640.8 N/A
background cpu time 46.8 N/A
-------------------------------------------------------------
Wait Class DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
-------------------- ---------------- ------ ---------------- ------- ---------
System I/O 49,216 .0 441 9 1.8
Commit 27,695 .0 342 12 1.0
Network 13,395,137 .0 213 0 479.8
User I/O 374,002 .0 52 0 13.4
Concurrency 1,042 1.4 11 10 0.0
Other 462 .0 1 1 0.0
Application 18 .0 0 6 0.0
-------------------------------------------------------------
Wait Events DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
---------------------------- -------------- ------ ----------- ------- ---------
log file sync 27,695 .0 342 12 1.0
log file parallel write 28,318 .0 336 12 1.0
SQL*Net more data from clien 1,202,059 .0 129 0 43.1
control file parallel write 4,770 .0 104 22 0.2
SQL*Net more data to client 3,018,424 .0 39 0 108.1
db file sequential read 246,249 .0 37 0 8.8
SQL*Net message to client 8,907,624 .0 35 0 319.1
db file parallel read 4,938 .0 14 3 0.2
SQL*Net more data from dblin 3,901 .0 8 2 0.1
os thread startup 173 .0 6 36 0.0
library cache load lock 24 .0 3 137 0.0
SQL*Net message to dblink 262,873 .0 1 0 9.4
direct path read 119,963 .0 1 0 4.3
db file scattered read 1,847 .0 1 0 0.1
latch free 232 .0 0 2 0.0
latch: library cache 92 .0 0 3 0.0
control file sequential read 16,128 .0 0 0 0.6
latch: cache buffers chains 485 .0 0 0 0.0
cursor: pin S wait on X 15 100.0 0 13 0.0
latch: row cache objects 231 .0 0 1 0.0
SQL*Net break/reset to clien 16 .0 0 6 0.0
buffer busy waits 10 .0 0 6 0.0
latch: library cache pin 5 .0 0 9 0.0
latch: cache buffers lru cha 19 .0 0 2 0.0
latch: enqueue hash chains 4 .0 0 5 0.0
cursor: pin S 113 .0 0 0 0.0
LGWR wait for redo copy 43 .0 0 0 0.0
latch: library cache lock 2 .0 0 6 0.0
latch: session allocation 25 .0 0 0 0.0
latch: object queue header o 5 .0 0 2 0.0
latch: cache buffer handles 20 .0 0 0 0.0
direct path write 775 .0 0 0 0.0
SQL*Net more data to dblink 256 .0 0 0 0.0
latch: shared pool 2 .0 0 2 0.0
direct path write temp 114 .0 0 0 0.0
direct path read temp 114 .0 0 0 0.0
enq: TX - row lock contentio 2 .0 0 0 0.0
read by other session 2 .0 0 0 0.0
latch: In memory undo latch 3 .0 0 0 0.0
latch: undo global data 1 .0 0 0 0.0
SQL*Net message from client 8,907,625 .0 13,056,516 1466 319.1
jobq slave wait 5,236 97.2 15,174 2898 0.2
Streams AQ: waiting for mess 2,881 100.0 14,059 4880 0.1
virtual circuit status 480 100.0 14,013 29193 0.0
Streams AQ: qmn slave idle w 512 .0 13,980 27304 0.0
Streams AQ: qmn coordinator 1,056 51.5 13,979 13238 0.0
Streams AQ: waiting for time 56 92.9 13,435 239911 0.0
SQL*Net message from dblink 262,873 .0 403 2 9.4
single-task message 208 .0 26 125 0.0
class slave wait 2 .0 0 0 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 28,318 .0 336 12 1.0
control file parallel write 4,770 .0 104 22 0.2
os thread startup 173 .0 6 36 0.0
db file scattered read 280 .0 0 0 0.0
control file sequential read 4,904 .0 0 0 0.2
db file sequential read 507 .0 0 0 0.0
events in waitclass Other 50 .0 0 1 0.0
log file sync 1 .0 0 11 0.0
latch: library cache 6 .0 0 0 0.0
buffer busy waits 1 .0 0 0 0.0
direct path read 7 .0 0 0 0.0
direct path write 7 .0 0 0 0.0
rdbms ipc message 76,501 60.3 151,444 1980 2.7
pmon timer 4,824 100.0 14,051 2913 0.2
Streams AQ: qmn slave idle w 512 .0 13,980 27304 0.0
Streams AQ: qmn coordinator 1,056 51.5 13,979 13238 0.0
smon timer 111 13.5 13,441 121093 0.0
Streams AQ: waiting for time 56 92.9 13,435 239911 0.0
class slave wait 1 .0 0 0 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
Statistic Total
-------------------------------- --------------------
BUSY_TIME 302,266
IDLE_TIME 2,579,032
IOWAIT_TIME 94,012
NICE_TIME 0
SYS_TIME 89,821
USER_TIME 208,721
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 32,088
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS 2,489.4 2,112.4 402,987 ##########
SYS$BACKGROUND 0.0 0.0 6,752 84,088
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: 3283-3287
-> 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
370115 5117 861 429 0 0 13394586 21249
SYS$BACKGROUND
3886 74 180 630 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
---------- ---------- ------------ ---------- ------- -------------
675 674 706,190 0.0 27.1 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
149 147 1,196 0.1 6.0 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
131 129 1,626 0.1 5.3 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
62 62 60,092 0.0 2.5 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 =
54 54 58,361 0.0 2.2 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_
54 53 16,635 0.0 2.2 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
53 53 59,171 0.0 2.1 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
49 49 53,068 0.0 2.0 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
43 43 43,259 0.0 1.7 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 = :
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
---------- ---------- ------------ ---------- ------- -------------
28 20 1 28.4 1.1 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
28 27 3,334 0.0 1.1 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
28 20 1 28.2 1.1 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|
27 27 2,011 0.0 1.1 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_
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
---------- ---------- ------------ ----------- ------- -------------
674 675 706,190 0.00 27.1 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
147 149 1,196 0.12 6.0 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
129 131 1,626 0.08 5.3 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
62 62 60,092 0.00 2.5 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 =
54 54 58,361 0.00 2.2 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_
53 54 16,635 0.00 2.2 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
53 53 59,171 0.00 2.1 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
49 49 53,068 0.00 2.0 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
43 43 43,259 0.00 1.7 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 = :
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
---------- ---------- ------------ ----------- ------- -------------
27 28 3,334 0.01 1.1 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
27 27 2,011 0.01 1.1 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_
20 28 1 19.64 1.1 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
20 28 1 19.63 1.1 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 110,362,993
-> Captured SQL account for 87.0% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
23,192,087 706,190 32.8 21.0 674.23 675.07 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
15,756,145 1,196 13,174.0 14.3 146.85 149.06 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
12,417,883 2,011 6,175.0 11.3 26.71 27.09 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_
8,030,814 1,626 4,939.0 7.3 129.22 131.06 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
4,102,130 16,635 246.6 3.7 53.02 53.58 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
3,364,006 3,334 1,009.0 3.0 27.15 28.31 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
3,118,706 60,092 51.9 2.8 62.43 62.48 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 =
2,789,121 58,361 47.8 2.5 53.69 53.79 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_
2,487,366 59,171 42.0 2.3 52.91 52.95 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
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 110,362,993
-> Captured SQL account for 87.0% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
2,405,427 53,068 45.3 2.2 48.54 48.55 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
2,154,855 24,012 89.7 2.0 17.11 17.13 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
1,777,632 43,259 41.1 1.6 42.75 42.81 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 = :
1,633,324 6,496 251.4 1.5 17.49 17.54 c3j0mtm1put5u
Module: JDBC Thin Client
select areaimpl0_.ID as ID30_0_, membership1_.ID as ID37_1_, areaimpl0_.VERSION
as VERSION30_0_, areaimpl0_.UUID as UUID30_0_, areaimpl0_.CREATED as CREATED30_0
_, areaimpl0_.CREATED_BY as CREATED5_30_0_, areaimpl0_.MODIFIED as MODIFIED30_0_
, areaimpl0_.MODIFIED_BY as MODIFIED7_30_0_, areaimpl0_.CONTEXT_ID as CONTEXT8_3
1,486,827 45,811 32.5 1.3 10.20 10.20 c55kf9dj75jy4
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL
_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND
MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REAL
M_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where ( ROLES.ROLE_NAME in(
1,421,670 18,463 77.0 1.3 5.62 5.62 6n5nww1af3q5h
Module: JDBC Thin Client
SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_RL_GR.USER_ID, SAKAI_REALM_RL_GR.
ACTIVE, SAKAI_REALM_RL_GR.PROVIDED FROM SAKAI_REALM_RL_GR INNER JOIN SAKAI_REALM
ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_GR.REALM_KEY AND SAKAI_REALM.REALM_ID
= :1 INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_
1,361,646 18 75,647.0 1.2 5.97 5.98 gks5ryymzw06b
Module: JDBC Thin Client
SELECT OBJECT_NAME, OWNER, 'T' MYTYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABL
E' AND OBJECT_NAME NOT LIKE 'BIN$%' AND UPPER(OWNER) = 'SYS' UNION SELECT VIEW_N
AME, OWNER, 'V' MYTYPE FROM ALL_VIEWS WHERE UPPER(OWNER) = 'SYS'
1,170,317 130,035 9.0 1.1 6.47 6.48 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'
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Disk Reads: 409,767
-> Captured SQL account for 40.3% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
67,487 3,230 20.9 16.5 8.37 20.05 bkybw545h5vaj
Module: JDBC Thin Client
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
56,959 53,683 1.1 13.9 9.17 10.99 5nrt9j3990q58
Module: JDBC Thin Client
select enrollment0_.EID as EID244_, enrollment0_.PERSON_EID as PERSON2_244_, enr
ollment0_.LASTMODIFIEDBY as LASTMODI3_244_, enrollment0_.LASTMODIFIEDDATE as LAS
TMODI4_244_, enrollment0_.CREATEDBY as CREATEDBY244_, enrollment0_.CREATEDDATE a
s CREATEDD6_244_, enrollment0_.ENROLLMENTSTATUS as ENROLLME7_244_, enrollment0_.
10,812 3,230 3.3 2.6 2.56 8.32 6jqzv0wqt7xnn
Module: JDBC Thin Client
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
3,665 7,185 0.5 0.9 7.23 7.23 dub7v8sr436fw
Module: JDBC Thin Client
select XML from ASSIGNMENT_SUBMISSION where CONTEXT = :1
3,292 194,466 0.0 0.8 10.41 10.47 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )
2,422 1 2,422.0 0.6 19.63 28.17 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|
2,422 1 2,422.0 0.6 19.64 28.43 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2,220 24 92.5 0.5 8.36 10.98 fju4kkaxxx1nf
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_INSTRUCTORS"'); :m
ydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2,052 58,361 0.0 0.5 53.69 53.79 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,959 129,876 0.0 0.5 8.24 8.28 29gxrqhdg4yd6
Module: JDBC Thin Client
select XML from CONTENT_RESOURCE where ( RESOURCE_ID = :1 )
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Executions: 3,288,782
-> Captured SQL account for 61.3% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
706,190 706,188 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
260,723 260,273 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
194,466 170,819 0.9 0.00 0.00 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )
130,035 130,035 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'
129,876 100,186 0.8 0.00 0.00 29gxrqhdg4yd6
Module: JDBC Thin Client
select XML from CONTENT_RESOURCE where ( RESOURCE_ID = :1 )
60,092 60,092 1.0 0.00 0.00 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 =
59,171 59,171 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
58,361 58,361 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_
53,683 53,683 1.0 0.00 0.00 5nrt9j3990q58
Module: JDBC Thin Client
select enrollment0_.EID as EID244_, enrollment0_.PERSON_EID as PERSON2_244_, enr
ollment0_.LASTMODIFIEDBY as LASTMODI3_244_, enrollment0_.LASTMODIFIEDDATE as LAS
TMODI4_244_, enrollment0_.CREATEDBY as CREATEDBY244_, enrollment0_.CREATEDDATE a
s CREATEDD6_244_, enrollment0_.ENROLLMENTSTATUS as ENROLLME7_244_, enrollment0_.
53,068 53,068 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
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Executions: 3,288,782
-> Captured SQL account for 61.3% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
_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
45,811 45,811 1.0 0.00 0.00 c55kf9dj75jy4
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL
_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND
MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REAL
M_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where ( ROLES.ROLE_NAME in(
43,259 43,259 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 = :
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Parse Calls: 118,984
-> Captured SQL account for 40.3% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
23,974 23,974 20.15 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
1,564 1,564 1.31 4m7m0t6fjcs5x
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1
1,171 1,171 0.98 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
1,171 1,171 0.98 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
+ :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn
915 915 0.77 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
626 626 0.53 2uunxrv2wj57b
update sum$ set containerobj#=:2,containertype=:3,containernam=:4,fullrefreshtim
=:5,increfreshtim=:6,lastrefreshscn=:7,lastrefreshdate=:8,refreshmode=:9,pflags=
:10,mflags=:11,numdetailtab=:12,numaggregates=:13,numkeycolumns=:14,numjoins=:15
,numinlines=:16,sumtextlen=:17,sumtext=:18,fromoffset=:19,fromlen=:20,objcount=:
539 1,865 0.45 9ar2vv44swxvr
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_
535 2,033 0.45 5q1r2z4czhzh1
Module: JDBC Thin Client
update SAKAI_SESSION set SESSION_END = :1 where SESSION_ID = :2
533 1,196 0.45 az3hmnt1dny3j
Module: JDBC Thin Client
select SERVER_ID from SAKAI_CLUSTER where SERVER_ID != :1 and UPDATE_TIME < (CUR
RENT_TIMESTAMP - 0.0069444445 )
528 528 0.44 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
39,905,796 N/A 4.96 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'
7,833,724 41 0.97 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
5,283,329 60,092 0.66 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 =
4,502,596 124 0.56 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 )
2,321,014 29 0.29 b4db60sxry09y
Module: JDBC Thin Client
select gradingeve0_.ID as ID275_, gradingeve0_.GRADABLE_OBJECT_ID as GRADABLE2_2
75_, gradingeve0_.GRADER_ID as GRADER3_275_, gradingeve0_.STUDENT_ID as STUDENT4
_275_, gradingeve0_.DATE_GRADED as DATE5_275_, gradingeve0_.GRADE as GRADE275_ f
rom GB_GRADING_EVENT_T gradingeve0_ where gradingeve0_.GRADABLE_OBJECT_ID=:1 and
2,274,676 1,637 0.28 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
2,207,852 25 0.27 7c5hgrz01137b
Module: JDBC Thin Client
select comment0_.ID as ID283_, comment0_.VERSION as VERSION283_, comment0_.GRADE
R_ID as GRADER3_283_, comment0_.STUDENT_ID as STUDENT4_283_, comment0_.COMMENT_T
EXT as COMMENT5_283_, comment0_.DATE_RECORDED as DATE6_283_, comment0_.GRADABLE_
OBJECT_ID as GRADABLE7_283_ from GB_COMMENT_T comment0_ where comment0_.GRADABLE
1,731,901 7 0.22 dyw9r78qz1842
Module: JDBC Thin Client
update SAKAI_PERSON_T set VERSION=:1, UUID=:2, LAST_MODIFIED_BY=:3, LAST_MODIFIE
D_DATE=:4, CREATED_BY=:5, CREATED_DATE=:6, AGENT_UUID=:7, TYPE_UUID=:8, COMMON_N
AME=:9, DESCRIPTION=:10, SEE_ALSO=:11, STREET=:12, SURNAME=:13, TELEPHONE_NUMBER
=:14, FAX_NUMBER=:15, LOCALITY_NAME=:16, OU=:17, PHYSICAL_DELIVERY_OFFICE_NAME=:
1,622,253 58,361 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 (
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
755 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'
490 58,361 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_
241 41 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
229 124 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 )
212 43,259 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 = :
146 60,092 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 =
83 29 b4db60sxry09y
Module: JDBC Thin Client
select gradingeve0_.ID as ID275_, gradingeve0_.GRADABLE_OBJECT_ID as GRADABLE2_2
75_, gradingeve0_.GRADER_ID as GRADER3_275_, gradingeve0_.STUDENT_ID as STUDENT4
_275_, gradingeve0_.DATE_GRADED as DATE5_275_, gradingeve0_.GRADE as GRADE275_ f
rom GB_GRADING_EVENT_T gradingeve0_ where gradingeve0_.GRADABLE_OBJECT_ID=:1 and
83 1,637 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
83 1,637 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: 3283-3287
-> 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
74 120 3hrf4q4yrr6ka
Module: JDBC Thin Client
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = :1 WHERE JOB_NAME = :2 AND JOB_GROUP =
:3 AND TRIGGER_STATE = :4
69 25 7c5hgrz01137b
Module: JDBC Thin Client
select comment0_.ID as ID283_, comment0_.VERSION as VERSION283_, comment0_.GRADE
R_ID as GRADER3_283_, comment0_.STUDENT_ID as STUDENT4_283_, comment0_.COMMENT_T
EXT as COMMENT5_283_, comment0_.DATE_RECORDED as DATE6_283_, comment0_.GRADABLE_
OBJECT_ID as GRADABLE7_283_ from GB_COMMENT_T comment0_ where comment0_.GRADABLE
57 227 bwht4rhzyb6nh
Module: JDBC Thin Client
update SAKAI_REALM set PROVIDER_ID = :1,MAINTAIN_ROLE = (select MAX(ROLE_KEY) fr
om SAKAI_REALM_ROLE where ROLE_NAME = :2),CREATEDBY = :3,MODIFIEDBY = :4,CREATED
ON = :5,MODIFIEDON = :6 where ( REALM_ID = :7 )
52 23 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
43 2 2g69rythn19tc
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_ENROLLMENT enr where enr.PERSON_EID = '000000' and se
c.ENROLLMENTSET_EID = enr.ENROLLMENTSET_EID and enr.dropped=0
43 2 5s8ka1shknpdr
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_INSTRUCTORS ins where ins.SECTION_EID = sec.EID and i
ns.PERSON_EID = '00166200'
42 7 dyw9r78qz1842
Module: JDBC Thin Client
update SAKAI_PERSON_T set VERSION=:1, UUID=:2, LAST_MODIFIED_BY=:3, LAST_MODIFIE
D_DATE=:4, CREATED_BY=:5, CREATED_DATE=:6, AGENT_UUID=:7, TYPE_UUID=:8, COMMON_N
AME=:9, DESCRIPTION=:10, SEE_ALSO=:11, STREET=:12, SURNAME=:13, TELEPHONE_NUMBER
=:14, FAX_NUMBER=:15, LOCALITY_NAME=:16, OU=:17, PHYSICAL_DELIVERY_OFFICE_NAME=:
39 127 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)
38 29 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
37 706,190 aby75s01s29un
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
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
37 53,068 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
29 2,758 8cmaff91xudg4
Module: JDBC Thin Client
select DISTINCT FUNCTION_NAME from SAKAI_REALM_FUNCTION SRF inner join SAKAI_REA
LM_RL_FN SRRF on SRF.FUNCTION_KEY = SRRF.FUNCTION_KEY inner join SAKAI_REALM_ROL
E SRR on SRRF.ROLE_KEY = SRR.ROLE_KEY inner join SAKAI_REALM SR on SRRF.REALM_KE
Y = SR.REALM_KEY where SRR.ROLE_NAME = :1 and SR.REALM_ID IN (:2,:3)
27 56 g5zb5g33d48m1
Module: JDBC Thin Client
update SAKAI_PREFERENCES set XML = :1 where ( PREFERENCES_ID = :2 )
26 48 b6gqns0qyhkj3
Module: JDBC Thin Client
update rwikiobject set version=:1, name=:2, realm=:3, referenced=:4, userid=:5,
owner=:6, ownerRead=:7, ownerWrite=:8, ownerAdmin=:9, groupRead=:10, groupWrite=
:11, groupAdmin=:12, publicRead=:13, publicWrite=:14, sha1=:15, revision=:16 whe
re id=:17 and version=:18
25 4 8qsfufqdcygru
Module: JDBC Thin Client
DELETE FROM SAKAI_REALM_RL_GR WHERE REALM_KEY IN (SELECT REALM_KEY FROM SAKAI_RE
ALM WHERE REALM_ID = :1) AND ROLE_KEY IN (SELECT ROLE_KEY FROM SAKAI_REALM_ROLE
WHERE ROLE_NAME = :2) AND USER_ID = :3 AND ACTIVE = :4 AND PROVIDED = :5
24 2,593 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: 3283-3287
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 208,050 14.4 7.5
CPU used when call started 203,258 14.1 7.3
CR blocks created 155 0.0 0.0
Cached Commit SCN referenced 485 0.0 0.0
Commit SCN cached 14 0.0 0.0
DB time 3,310,858 229.8 118.6
DBWR checkpoint buffers written 7,807 0.5 0.3
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 7,807 0.5 0.3
DBWR transaction table writes 128 0.0 0.0
DBWR undo block writes 9,989 0.7 0.4
IMU CR rollbacks 69 0.0 0.0
IMU Flushes 8,369 0.6 0.3
IMU Redo allocation size 14,351,872 996.2 514.1
IMU commits 22,173 1.5 0.8
IMU contention 26 0.0 0.0
IMU ktichg flush 69 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 82 0.0 0.0
IMU undo allocation size 53,790,748 3,733.9 1,926.8
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 8,907,357 618.3 319.1
SQL*Net roundtrips to/from dblin 262,590 18.2 9.4
active txn count during cleanout 2,738 0.2 0.1
application wait time 10 0.0 0.0
background checkpoints completed 1 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 46,278 3.2 1.7
branch node splits 6 0.0 0.0
buffer is not pinned count 45,926,069 3,188.0 1,645.1
buffer is pinned count 49,443,194 3,432.1 1,771.1
bytes received via SQL*Net from 5,110,818,931 354,768.8 183,071.9
bytes received via SQL*Net from 29,912,085 2,076.4 1,071.5
bytes sent via SQL*Net to client 9,687,192,945 672,438.9 346,999.8
bytes sent via SQL*Net to dblink 16,683,871 1,158.1 597.6
calls to get snapshot scn: kcmgs 7,444,590 516.8 266.7
calls to kcmgas 36,149 2.5 1.3
calls to kcmgcs 4,148 0.3 0.2
change write time 342 0.0 0.0
cleanout - number of ktugct call 3,228 0.2 0.1
cleanouts and rollbacks - consis 41 0.0 0.0
cleanouts only - consistent read 174 0.0 0.0
cluster key scan block gets 20,556 1.4 0.7
cluster key scans 1,762 0.1 0.1
commit batch performed 208 0.0 0.0
commit batch requested 208 0.0 0.0
commit batch/immediate performed 221 0.0 0.0
commit batch/immediate requested 221 0.0 0.0
commit cleanout failures: block 68 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callba 106 0.0 0.0
commit cleanout failures: cannot 7 0.0 0.0
commit cleanouts 102,904 7.1 3.7
commit cleanouts successfully co 102,723 7.1 3.7
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed 13 0.0 0.0
commit immediate requested 13 0.0 0.0
commit txn count during cleanout 4,397 0.3 0.2
concurrency wait time 1,059 0.1 0.0
consistent changes 2,088 0.1 0.1
consistent gets 109,490,148 7,600.3 3,922.0
consistent gets - examination 33,566,616 2,330.0 1,202.4
consistent gets direct 122,110 8.5 4.4
consistent gets from cache 109,368,038 7,591.8 3,917.6
current blocks converted for CR 0 0.0 0.0
cursor authentications 712 0.1 0.0
data blocks consistent reads - u 220 0.0 0.0
db block changes 626,677 43.5 22.5
db block gets 872,845 60.6 31.3
db block gets direct 816 0.1 0.0
db block gets from cache 872,029 60.5 31.2
deferred (CURRENT) block cleanou 44,363 3.1 1.6
dirty buffers inspected 29,888 2.1 1.1
enqueue conversions 6,915 0.5 0.3
enqueue releases 258,868 18.0 9.3
enqueue requests 258,956 18.0 9.3
enqueue timeouts 94 0.0 0.0
enqueue waits 2 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 3,288,782 228.3 117.8
failed probes on index block rec 0 0.0 0.0
frame signature mismatch 0 0.0 0.0
free buffer inspected 464,540 32.3 16.6
free buffer requested 296,089 20.6 10.6
heap block compress 3,402 0.2 0.1
hot buffers moved to head of LRU 817,719 56.8 29.3
immediate (CR) block cleanout ap 215 0.0 0.0
immediate (CURRENT) block cleano 11,298 0.8 0.4
index crx upgrade (found) 237 0.0 0.0
index crx upgrade (positioned) 4,154,120 288.4 148.8
index fast full scans (full) 17 0.0 0.0
index fetch by key 12,618,328 875.9 452.0
index scans kdiixs1 22,809,248 1,583.3 817.0
leaf node 90-10 splits 164 0.0 0.0
leaf node splits 538 0.0 0.0
lob reads 74,511 5.2 2.7
lob writes 5,374 0.4 0.2
lob writes unaligned 4,637 0.3 0.2
logons cumulative 694 0.1 0.0
messages received 33,703 2.3 1.2
messages sent 33,703 2.3 1.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 71,296,436 4,949.1 2,553.9
opened cursors cumulative 120,193 8.3 4.3
parse count (failures) 261 0.0 0.0
parse count (hard) 826 0.1 0.0
parse count (total) 118,984 8.3 4.3
parse time cpu 734 0.1 0.0
parse time elapsed 4,864 0.3 0.2
physical read IO requests 393,219 27.3 14.1
physical read bytes 3,356,811,264 233,013.9 120,242.6
physical read total IO requests 409,599 28.4 14.7
physical read total bytes 3,623,116,800 251,499.6 129,781.7
physical read total multi block 3,127 0.2 0.1
physical reads 409,767 28.4 14.7
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache 286,263 19.9 10.3
physical reads cache prefetch 34,067 2.4 1.2
physical reads direct 123,504 8.6 4.4
physical reads direct (lob) 121,183 8.4 4.3
physical reads direct temporary 1,710 0.1 0.1
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 29,981 2.1 1.1
physical write bytes 395,952,128 27,485.1 14,183.2
physical write total IO requests 97,820 6.8 3.5
physical write total bytes 924,112,896 64,147.5 33,102.2
physical write total multi block 59,536 4.1 2.1
physical writes 48,334 3.4 1.7
physical writes direct 2,533 0.2 0.1
physical writes direct (lob) 816 0.1 0.0
physical writes direct temporary 1,710 0.1 0.1
physical writes from cache 45,801 3.2 1.6
physical writes non checkpoint 42,472 3.0 1.5
pinned buffers inspected 20 0.0 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 1,720 0.1 0.1
process last non-idle time 12,263 0.9 0.4
recovery blocks read 0 0.0 0.0
recursive calls 1,217,450 84.5 43.6
recursive cpu usage 5,690 0.4 0.2
redo blocks read for recovery 0 0.0 0.0
redo blocks written 286,870 19.9 10.3
redo buffer allocation retries 0 0.0 0.0
redo entries 230,696 16.0 8.3
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 0 0.0 0.0
redo size 134,726,776 9,352.1 4,826.0
redo synch time 35,224 2.5 1.3
redo synch writes 787,266 54.7 28.2
redo wastage 7,505,524 521.0 268.9
redo write time 34,511 2.4 1.2
redo writer latching time 2 0.0 0.0
redo writes 28,318 2.0 1.0
rollback changes - undo records 95 0.0 0.0
rollbacks only - consistent read 104 0.0 0.0
rows fetched via callback 10,388,551 721.1 372.1
session connect time 0 0.0 0.0
session cursor cache hits 45,301 3.1 1.6
session logical reads 110,362,993 7,660.9 3,953.3
session pga memory 309,049,692 21,452.8 11,070.3
session pga memory max 464,974,288 32,276.3 16,655.6
session uga memory 932,036,019,064 64,697,514.7 33,385,966.2
session uga memory max 462,370,552 32,095.6 16,562.3
shared hash latch upgrades - no 4,272,972 296.6 153.1
shared hash latch upgrades - wai 237 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 145,970 10.1 5.2
sorts (rows) 1,393,063 96.7 49.9
sql area evicted 12 0.0 0.0
sql area purged 261 0.0 0.0
summed dirty queue length 31,102 2.2 1.1
switch current to new buffer 1,829 0.1 0.1
table fetch by rowid 30,856,453 2,141.9 1,105.3
table fetch continued row 234,997 16.3 8.4
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
table scan blocks gotten 30,186,941 2,095.4 1,081.3
table scan rows gotten 1,884,066,173 130,782.9 67,488.1
table scans (long tables) 20 0.0 0.0
table scans (short tables) 89,507 6.2 3.2
total number of times SMON poste 96 0.0 0.0
transaction rollbacks 221 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 41,463,176 2,878.2 1,485.2
user I/O wait time 5,194 0.4 0.2
user calls 8,999,556 624.7 322.4
user commits 27,646 1.9 1.0
user rollbacks 271 0.0 0.0
workarea executions - onepass 2 0.0 0.0
workarea executions - optimal 124,755 8.7 4.5
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 18 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: SAKAI/sakai Snaps: 3283-32
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 435,603 447,723
opened cursors current 9,825 13,083
logons current 1,036 1,029
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai Snaps: 3283-328
-> 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: 3283-3287
-> 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
387,376 27 0.1 1.0 26,592 2 3 0.0
SYSAUX
3,288 0 0.2 1.6 869 0 0 0.0
SYSTEM
2,383 0 0.1 2.6 454 0 8 6.3
UNDOTBS1
21 0 0.0 1.0 1,947 0 1 0.0
TEMP2
114 0 16.7 15.0 114 0 0 0.0
TEMP
0 0 0.0 N/A 3 0 0 0.0
ARCH_TS
1 0 0.0 1.0 1 0 0 0.0
INDEX_TS
1 0 0.0 1.0 1 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
1 0 0.0 1.0 1 0 0 0.0
DATA_TS /local/d02/oracle/sakai/data01.dbf
235,556 16 0.1 1.0 22,769 2 2 0.0
DATA_TS /local/d02/oracle/sakai/data02.dbf
151,820 11 0.2 1.0 3,823 0 1 0.0
INDEX_TS /local/d02/oracle/sakai/index01.dbf
1 0 0.0 1.0 1 0 0 0.0
SYSAUX /local/d02/oracle/sakai/sysaux01.dbf
3,288 0 0.2 1.6 869 0 0 0.0
SYSTEM /local/d02/oracle/sakai/system01.dbf
2,383 0 0.1 2.6 454 0 8 6.3
TEMP /local/d02/oracle/sakai/temp01.dbf
0 0 N/A N/A 1 0 0 N/A
TEMP /local/d02/oracle/sakai/temp02.dbf
0 0 N/A N/A 2 0 0 N/A
TEMP2 /local/d03/oracle/sakai/temp03.dbf
114 0 16.7 15.0 114 0 0 N/A
UNDOTBS1 /local/d02/oracle/sakai/undotbs01.dbf
21 0 0.0 1.0 1,947 0 1 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 84,600 100 110,237,488 286,260 45,801 0 0 12
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 9167 122171 121890 737280 121890 N/A
E 0 0 2053 28754 28486 737280 28486 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: SAKAI/sakai Snap: 3287
-> 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 609,514,845
D 128 .2 15,992 1.4 524,031,588
D 192 .3 23,988 1.2 462,695,989
D 256 .4 31,984 1.1 427,635,259
D 320 .5 39,980 1.1 404,495,339
D 384 .6 47,976 1.0 390,850,898
D 448 .7 55,972 1.0 382,769,502
D 512 .7 63,968 1.0 378,692,216
D 576 .8 71,964 1.0 377,082,278
D 640 .9 79,960 1.0 376,393,877
D 688 1.0 85,957 1.0 376,205,959
D 704 1.0 87,956 1.0 376,144,068
D 768 1.1 95,952 1.0 375,971,067
D 832 1.2 103,948 1.0 375,841,762
D 896 1.3 111,944 1.0 375,745,604
D 960 1.4 119,940 1.0 375,669,232
D 1,024 1.5 127,936 1.0 375,605,841
D 1,088 1.6 135,932 1.0 375,550,992
D 1,152 1.7 143,928 1.0 375,505,588
D 1,216 1.8 151,924 1.0 375,436,228
D 1,280 1.9 159,920 1.0 375,393,722
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
--------------- ------------------ --------------------------
99.6 7,968 35
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 340 709.4 0.0 .0 .0 .0 102,400
E 800 331 727.8 0.0 .0 .0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 113,419 113,419 0 0
64K 128K 1,107 1,107 0 0
128K 256K 586 586 0 0
256K 512K 692 692 0 0
512K 1024K 7,034 7,034 0 0
1M 2M 1,908 1,908 0 0
2M 4M 4 4 0 0
8M 16M 4 4 0 0
16M 32M 2 0 2 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: SAKAI/sakai Snap: 3287
-> 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 422,885.6 59,916.5 88.0 2,640
200 0.3 422,885.6 59,878.6 88.0 2,640
400 0.5 422,885.6 53,367.5 89.0 2,502
600 0.8 422,885.6 37,945.5 92.0 1,350
800 1.0 422,885.6 3,940.8 99.0 0
960 1.2 422,885.6 3,784.4 99.0 0
1,120 1.4 422,885.6 3,784.4 99.0 0
1,280 1.6 422,885.6 3,784.4 99.0 0
1,440 1.8 422,885.6 3,784.4 99.0 0
1,600 2.0 422,885.6 3,784.4 99.0 0
2,400 3.0 422,885.6 3,784.4 99.0 0
3,200 4.0 422,885.6 3,784.4 99.0 0
4,800 6.0 422,885.6 3,784.4 99.0 0
6,400 8.0 422,885.6 3,784.4 99.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: SAKAI/sakai Snap: 3287
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
288 .4 89 8,432 ####### 1.0 ####### 48.6 30,714,337
368 .5 165 11,433 ####### 1.0 ####### 31.9 30,739,090
448 .6 244 14,991 ####### 1.0 90,011 20.6 30,756,575
528 .7 322 17,808 ####### 1.0 55,560 12.7 30,768,548
608 .8 401 20,662 ####### 1.0 34,724 8.0 30,775,540
688 .9 480 25,196 ####### 1.0 17,205 3.9 30,779,939
768 1.0 559 29,081 ####### 1.0 4,367 1.0 30,782,522
848 1.1 638 32,775 ####### 1.0 1 .0 30,784,613
928 1.2 717 38,592 ####### 1.0 1 .0 30,786,430
1,008 1.3 796 42,554 ####### 1.0 1 .0 30,788,076
1,088 1.4 875 46,215 ####### 1.0 1 .0 30,789,632
1,168 1.5 939 51,208 ####### 1.0 1 .0 30,791,131
1,248 1.6 939 51,208 ####### 1.0 1 .0 30,792,567
1,328 1.7 1,017 54,765 ####### 1.0 1 .0 30,794,035
1,408 1.8 1,089 58,100 ####### 1.0 1 .0 30,795,460
1,488 1.9 1,089 58,100 ####### 1.0 1 .0 30,796,883
1,568 2.0 1,089 58,100 ####### 1.0 1 .0 30,798,307
-------------------------------------------------------------
SGA Target Advisory DB/Inst: SAKAI/sakai Snap: 3287
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
752 0.5 369,053 522,812,707
1,128 0.8 275,827 403,555,581
1,504 1.0 261,944 376,205,445
1,880 1.3 261,446 374,738,244
2,256 1.5 261,368 374,512,520
2,632 1.8 261,368 374,512,520
3,008 2.0 261,368 374,512,520
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: SAKAI/sakai Snap: 3287
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: SAKAI/sakai Snap: 3287
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,367 1.0 76
32 2.0 2 76 1 1.0 4,367 1.0 76
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 11 0 5
undo header 1 0 0
-------------------------------------------------------------
Enqueue Activity DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 .00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 5.7 32,371 1,994 8 5760/5760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
09-Oct 14:00 293 1,749 67 3 5,760 0/0 0/0/0/0/0/0
09-Oct 13:50 194 1,174 1,994 4 5,760 0/0 0/0/0/0/0/0
09-Oct 13:40 126 1,030 1,393 8 5,760 0/0 0/0/0/0/0/0
09-Oct 13:30 132 1,128 791 2 5,760 0/0 0/0/0/0/0/0
09-Oct 13:20 186 1,644 1,151 7 5,760 0/0 0/0/0/0/0/0
09-Oct 13:10 207 1,397 372 6 5,760 0/0 0/0/0/0/0/0
09-Oct 13:00 152 1,259 312 3 5,760 0/0 0/0/0/0/0/0
09-Oct 12:50 231 1,534 62 5 5,760 0/0 0/0/0/0/0/0
09-Oct 12:40 185 1,287 657 8 5,760 0/0 0/0/0/0/0/0
09-Oct 12:30 114 953 113 3 5,760 0/0 0/0/0/0/0/0
09-Oct 12:20 140 1,273 454 4 5,760 0/0 0/0/0/0/0/0
09-Oct 12:10 195 1,150 1,399 8 5,760 0/0 0/0/0/0/0/0
09-Oct 12:00 195 1,227 798 3 5,760 0/0 0/0/0/0/0/0
09-Oct 11:50 240 1,376 195 4 5,760 0/0 0/0/0/0/0/0
09-Oct 11:40 200 1,240 0 8 5,760 0/0 0/0/0/0/0/0
09-Oct 11:30 113 946 869 2 5,760 0/0 0/0/0/0/0/0
09-Oct 11:20 161 1,302 357 5 5,760 0/0 0/0/0/0/0/0
09-Oct 11:10 188 1,536 164 8 5,760 0/0 0/0/0/0/0/0
09-Oct 11:00 288 1,994 263 3 5,760 0/0 0/0/0/0/0/0
09-Oct 10:50 190 1,403 0 5 5,760 0/0 0/0/0/0/0/0
09-Oct 10:40 252 1,505 247 7 5,760 0/0 0/0/0/0/0/0
09-Oct 10:30 113 1,091 298 2 5,760 0/0 0/0/0/0/0/0
09-Oct 10:20 130 1,248 141 7 5,760 0/0 0/0/0/0/0/0
09-Oct 10:10 1,461 1,925 598 8 5,760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> "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 9,529 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 318,696 0.0 N/A 0 0 N/A
Consistent RBA 28,318 0.0 N/A 0 0 N/A
FAL request queue 288 0.0 N/A 0 0 N/A
FAL subheap alocation 288 0.0 N/A 0 0 N/A
FOB s.o list latch 1,352 0.0 N/A 0 0 N/A
In memory undo latch 217,226 0.0 0.6 0 39,171 0.0
JS mem alloc latch 19 0.0 N/A 0 0 N/A
JS queue access latch 19 0.0 N/A 0 0 N/A
JS queue state obj latch 104,068 0.0 N/A 0 0 N/A
JS slv state obj latch 547 0.0 N/A 0 0 N/A
KMG MMAN ready and start 4,801 0.0 N/A 0 0 N/A
KTF sga latch 27 0.0 N/A 0 4,144 0.0
KWQMN job cache list lat 64 0.0 N/A 0 0 N/A
MQL Tracking Latch 0 N/A N/A 0 288 0.0
Memory Management Latch 0 N/A N/A 0 4,801 0.0
OS process 2,490 0.0 N/A 0 0 N/A
OS process allocation 6,454 0.0 N/A 0 0 N/A
OS process: request allo 961 0.0 N/A 0 0 N/A
PL/SQL warning settings 2,832 0.0 N/A 0 0 N/A
SGA IO buffer pool latch 177 0.0 N/A 0 209 0.0
SQL memory manager latch 4 0.0 N/A 0 4,764 0.0
SQL memory manager worka 8,596,595 0.0 0.1 0 0 N/A
Shared B-Tree 560 0.0 N/A 0 0 N/A
active checkpoint queue 7,667 0.0 N/A 0 0 N/A
active service list 36,265 0.0 N/A 0 4,824 0.0
archive control 1,480 0.0 N/A 0 0 N/A
archive process latch 5,052 0.0 N/A 0 0 N/A
begin backup scn array 813 0.0 N/A 0 0 N/A
cache buffer handles 4,515,950 0.0 0.0 0 0 N/A
cache buffers chains 189,126,618 0.0 0.0 0 424,554 0.0
cache buffers lru chain 392,874 0.0 0.2 0 90,868 0.0
cache table scan latch 0 N/A N/A 0 1,847 0.0
channel handle pool latc 1,099 0.0 N/A 0 0 N/A
channel operations paren 69,627 0.0 N/A 0 0 N/A
checkpoint queue latch 140,177 0.0 N/A 0 32,644 0.0
client/application info 298 0.0 N/A 0 0 N/A
commit callback allocati 513 0.0 N/A 0 0 N/A
compile environment latc 1,008,728 0.0 0.0 0 0 N/A
constraint object alloca 417 0.0 N/A 0 0 N/A
dml lock allocation 136,519 0.0 0.0 0 0 N/A
dummy allocation 1,395 0.0 N/A 0 0 N/A
enqueue hash chains 524,729 0.0 0.1 0 345 0.0
enqueues 1,320,994 0.0 0.2 0 0 N/A
event group latch 477 0.0 N/A 0 0 N/A
file cache latch 681 0.0 N/A 0 0 N/A
global KZLD latch for me 304 0.0 N/A 0 0 N/A
global tx hash mapping 7,880 0.0 N/A 0 0 N/A
hash table column usage 500 0.0 N/A 0 46,301 0.0
hash table modification 386 0.0 N/A 0 0 N/A
job workq parent latch 0 N/A N/A 0 360 0.0
job_queue_processes para 328 0.0 N/A 0 0 N/A
kks stats 743 0.0 N/A 0 0 N/A
kmcptab latch 1 0.0 N/A 0 0 N/A
kmcpvec latch 0 N/A N/A 0 1 0.0
ksuosstats global area 968 0.0 N/A 0 0 N/A
ktm global data 111 0.0 N/A 0 0 N/A
kwqbsn:qsga 560 0.0 N/A 0 0 N/A
lgwr LWN SCN 30,878 0.0 0.0 0 0 N/A
library cache 1,779,518 0.0 0.2 0 0 N/A
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> "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 load lock 750 0.0 N/A 0 4 0.0
library cache lock 371,851 0.0 0.0 0 0 N/A
library cache lock alloc 10,923 0.0 0.0 0 0 N/A
library cache pin 134,510 0.0 0.5 0 0 N/A
library cache pin alloca 2,283 0.0 0.0 0 0 N/A
list of block allocation 3,335 0.0 N/A 0 0 N/A
loader state object free 137,808 0.0 N/A 0 0 N/A
message pool operations 218 0.0 N/A 0 0 N/A
messages 193,801 0.0 0.0 0 0 N/A
mostly latch-free SCN 30,823 0.0 N/A 0 0 N/A
multiblock read objects 27,984 0.0 N/A 0 0 N/A
ncodef allocation latch 230 0.0 N/A 0 0 N/A
object queue header heap 9,016 0.0 N/A 0 1,370 0.0
object queue header oper 733,068 0.0 0.2 0 0 N/A
object stats modificatio 179 0.0 N/A 0 0 N/A
parallel query alloc buf 1,904 0.0 N/A 0 0 N/A
parameter table allocati 1,126 0.0 N/A 0 0 N/A
post/wait queue 69,495 0.0 N/A 0 27,688 0.0
process allocation 961 0.0 N/A 0 477 0.0
process group creation 961 0.0 N/A 0 0 N/A
qmn task queue latch 2,048 0.0 N/A 0 0 N/A
redo allocation 368,156 0.0 0.0 0 0 N/A
redo copy 0 N/A N/A 0 230,679 0.0
redo writing 102,200 0.0 N/A 0 0 N/A
row cache objects 25,794,299 0.0 0.1 0 0 N/A
sequence cache 97,151 0.0 N/A 0 0 N/A
session allocation 2,057,669 0.0 0.2 0 0 N/A
session idle bit 19,006,692 0.0 0.1 0 0 N/A
session state list latch 1,801 0.6 0.8 0 0 N/A
session switching 230 0.0 N/A 0 0 N/A
session timer 4,824 0.0 N/A 0 0 N/A
shared pool 83,593 0.1 0.0 0 0 N/A
shared pool sim alloc 10 0.0 N/A 0 0 N/A
shared pool simulator 14,821 0.0 N/A 0 0 N/A
simulator hash latch 5,046,089 0.0 1.0 0 0 N/A
simulator lru latch 5,016,335 0.1 0.1 0 21,112 0.0
slave class 8 0.0 N/A 0 0 N/A
slave class create 32 12.5 1.0 0 0 N/A
sort extent pool 1,142 0.0 N/A 0 0 N/A
state object free list 8 0.0 N/A 0 0 N/A
statistics aggregation 560 0.0 N/A 0 0 N/A
temp lob duration state 3 0.0 N/A 0 0 N/A
temporary table state ob 40 0.0 N/A 0 0 N/A
threshold alerts latch 1,316 0.0 N/A 0 0 N/A
transaction allocation 1,043 0.0 N/A 0 0 N/A
transaction branch alloc 1,063 0.0 N/A 0 0 N/A
undo global data 239,490 0.0 0.5 0 0 N/A
user lock 1,651 0.1 0.0 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
189,126,618 15,105 485 14,631 0 0 0
row cache objects
25,794,299 3,319 231 3,100 0 0 0
simulator lru latch
5,016,335 2,981 167 2,818 0 0 0
session idle bit
19,006,692 688 41 647 0 0 0
cache buffer handles
4,515,950 434 20 414 0 0 0
library cache
1,779,518 415 92 326 0 0 0
session allocation
2,057,669 140 25 115 0 0 0
cache buffers lru chain
392,874 123 19 104 0 0 0
library cache lock
371,851 93 2 91 0 0 0
SQL memory manager workarea list latch
8,596,595 72 7 65 0 0 0
shared pool
83,593 51 2 49 0 0 0
enqueue hash chains
524,729 28 4 25 0 0 0
object queue header operation
733,068 23 5 18 0 0 0
enqueues
1,320,994 15 3 12 0 0 0
session state list latch
1,801 11 9 2 0 0 0
library cache pin
134,510 10 5 5 0 0 0
In memory undo latch
217,226 5 3 2 0 0 0
slave class create
32 4 4 0 0 0 0
undo global data
239,490 2 1 1 0 0 0
simulator hash latch
5,046,089 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch kticmt: child 0 2 0
In memory undo latch ktiFlush: child 0 1 1
SQL memory manager worka qesmmIRegisterWorkArea 0 3 5
SQL memory manager worka qesmmIUnRegisterWorkArea 0 3 2
SQL memory manager worka qesmmIRefreshBound 0 1 0
cache buffer handles kcbzgs 0 11 19
cache buffer handles kcbzfs 0 9 1
cache buffers chains kcbgtcr: fast path 0 306 203
cache buffers chains kcbgtcr: kslbegin excl 0 157 257
cache buffers chains kcbrls: kslbegin 0 119 122
cache buffers chains kcbgcur: kslbegin 0 2 0
cache buffers lru chain kcbzgws_1 0 15 17
cache buffers lru chain kcbbwlru 0 3 2
cache buffers lru chain kcbbxsv: move to being wri 0 1 0
enqueue hash chains ksqgtl3 0 4 1
enqueues ksqgel: create enqueue 0 2 0
enqueues ksqdel 0 1 0
library cache kglic 0 63 0
library cache kglLockCursor 0 13 2
library cache kgldte: child 0 0 5 66
library cache kglobpn: child: 0 3 6
library cache kglpin 0 3 1
library cache kglhdgn: child: 0 2 16
library cache kglScanDependency 0 1 0
library cache kglpndl: child: after proc 0 1 0
library cache kglukp: child 0 1 0
library cache lock kgllkal: child: multiinsta 0 2 1
library cache pin kglpnal: child: alloc spac 0 5 5
object queue header oper kcbw_unlink_q 0 3 1
object queue header oper kcbw_link_q 0 2 0
object queue header oper kcbo_switch_cq 0 1 3
row cache objects kqreqd: reget 0 142 0
row cache objects kqrpre: find obj 0 53 231
row cache objects kqreqd 0 36 0
session allocation ksufap: active sessions 0 18 0
session allocation ksuxds: not user session 0 3 2
session allocation ksucri 0 1 22
session allocation ksudlp 0 1 0
session allocation ksuprc 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 1 1
session idle bit ksupuc: set busy 0 21 30
session idle bit ksupuc: clear busy 0 19 10
session idle bit ksuxds 0 1 1
session state list latch kpseqd 0 7 0
session state list latch kpscad 0 1 0
session state list latch kpseqa 0 1 35
shared pool kghfrh 0 2 0
simulator hash latch kcbsacc: lookup dba 0 1 0
simulator lru latch kcbs_simulate: simulate se 0 166 166
simulator lru latch kcbs_simbufseq 0 1 1
slave class create ksvcreate 0 4 0
undo global data ktucof: at start 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Logical Reads: 110,362,993
-> Captured Segments account for 93.7% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SAKAI_SESSION TABLE 16,087,952 14.58
SAKAI DATA_TS AK_SAKAI_REALM_ID INDEX 10,342,752 9.37
SAKAI DATA_TS SYS_C004181 INDEX 9,376,448 8.50
SAKAI_EXTE DATA_TS BANNER_OFFER_COURSES INDEX 8,027,376 7.27
SAKAI DATA_TS SAKAI_REALM_RL_GR_RA INDEX 6,201,008 5.62
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> Total Physical Reads: 409,767
-> Captured Segments account for 38.2% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SYS_LOB0000046053C00 LOB 56,729 13.84
SAKAI DATA_TS SYS_LOB0000046147C00 LOB 16,141 3.94
SAKAI DATA_TS SYS_C004181 INDEX 8,621 2.10
SAKAI DATA_TS CONTENT_RESOURCE TABLE 7,522 1.84
SAKAI DATA_TS ASSIGNMENT_SUBMISSIO TABLE 7,119 1.74
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> % 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 97 39.43
SAKAI DATA_TS IE_SAKAI_SITE_FLAGS INDEX 95 38.62
SAKAI DATA_TS SYS_C003787 INDEX 21 8.54
SAKAI DATA_TS SYS_C004290 INDEX 9 3.66
SAKAI DATA_TS SYS_C004212 INDEX 5 2.03
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> % 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 DBMS_LOCK_ALLOCATED TABLE 4 44.44
SYS SYSTEM JOB$ TABLE 2 22.22
SYS SYSTEM I_JOB_NEXT INDEX 1 11.11
SAKAI DATA_TS SAKAI_REALM TABLE 1 11.11
SYS SYSTEM SUM$ TABLE 1 11.11
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> "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 260 0.0 0 N/A 8 1
dc_database_links 199,599 0.0 0 N/A 0 6
dc_global_oids 51 0.0 0 N/A 0 153
dc_histogram_data 7,080 1.5 0 N/A 0 13,491
dc_histogram_defs 7,373 1.7 0 N/A 0 6,478
dc_object_ids 19,597 0.0 0 N/A 0 2,574
dc_objects 4,669 0.1 0 N/A 20 3,329
dc_profiles 528 0.0 0 N/A 0 1
dc_rollback_segments 57,436 0.0 0 N/A 0 392
dc_segments 8,141 0.0 0 N/A 29 2,473
dc_sequences 1,564 0.0 0 N/A 1,564 59
dc_tablespace_quotas 10 0.0 0 N/A 10 6
dc_tablespaces 4,141,555 0.0 0 N/A 0 9
dc_usernames 1,947 0.0 0 N/A 0 37
dc_users 4,161,046 0.0 0 N/A 0 88
global database name 416 0.0 0 N/A 0 1
outstanding_alerts 512 0.0 0 N/A 0 17
-------------------------------------------------------------
Library Cache Activity DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 5,086 0.0 5,582 0.0 0 0
CLUSTER 11 0.0 17 0.0 0 0
SQL AREA 210 81.0 3,310,798 0.1 350 1
TABLE/PROCEDURE 1,731 0.3 47,232 0.8 10 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 616.6 N/A .6 2.3 64 64 1,038 1,038
Freeable 72.8 .0 .9 .3 1 N/A 84 84
SQL 18.3 5.3 .0 .1 0 106 1,026 1,021
PL/SQL 2.6 .4 .0 .0 0 0 1,036 1,036
E Other 617.4 N/A .6 2.3 64 64 1,031 1,031
Freeable 85.7 .0 .9 .2 1 N/A 100 100
SQL 23.4 6.8 .0 .1 0 106 1,020 1,019
PL/SQL 2.3 .3 .0 .0 0 0 1,029 1,029
-------------------------------------------------------------
SGA Memory Summary DB/Inst: SAKAI/sakai Snaps: 3283-3287
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 721,420,288
Fixed Size 1,262,764
Redo Buffers 15,511,552
Variable Size 1,358,957,396
-------------------
sum 2,097,152,000
-------------------------------------------------------------
SGA breakdown difference DB/Inst: SAKAI/sakai Snaps: 3283-3287
-> 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 59.5 62.1 4.38
shared Heap0: KGL 10.4 10.4 0.25
shared KGH: NO ACCESS 53.4 53.4 0.00
shared KGLS heap 10.4 10.6 1.57
shared KTI-UNDO 14.7 14.7 0.00
shared PCursor 21.5 21.9 1.65
shared event statistics per sess 15.7 15.7 0.00
shared free memory 95.5 77.3 -19.14
shared library cache 34.8 35.2 0.98
shared private strands 14.2 14.2 0.00
shared sessions 9.4 9.4 0.00
shared sql area 351.7 366.4 4.17
shared trace buffer 16.5 16.5 0.00
buffer_cache 688.0 688.0 0.00
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: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: SAKAI/sakai Snaps: 3283-3287
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: SAKAI/sakai Snap: 3287
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: SAKAI/sakai Snaps: 3283-3287
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