awr-2007-10-07_13-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: 3235 07-Oct-07 13:00:32 1,039 34.5
End Snap: 3236 07-Oct-07 14:00:34 1,044 34.3
Elapsed: 60.02 (mins)
DB Time: 5.91 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 848M 848M Std Block Size: 8K
Shared Pool Size: 608M 608M Log Buffer: 15,148K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 4,412.77 3,525.41
Logical reads: 4,495.32 3,591.36
Block changes: 24.35 19.45
Physical reads: 17.24 13.78
Physical writes: 1.76 1.41
User calls: 329.37 263.14
Parses: 6.20 4.95
Hard parses: 0.06 0.04
Sorts: 6.26 5.00
Logons: 0.05 0.04
Executes: 114.81 91.72
Transactions: 1.25
% Blocks changed per Read: 0.54 Recursive Call %: 11.04
Rollback per transaction %: 0.62 Rows per Sort: 15.80
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 100.05 In-memory Sort %: 100.00
Library Hit %: 99.86 Soft Parse %: 99.10
Execute to Parse %: 94.60 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 17.16 % Non-Parse CPU: 99.40
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 86.41 87.19
% SQL with executions>1: 96.06 96.08
% Memory for SQL w/exec>1: 94.44 94.37
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 291 82.1
log file sync 4,435 63 14 17.9 Commit
log file parallel write 4,610 60 13 16.8 System I/O
SQL*Net more data from client 174,808 26 0 7.4 Network
control file parallel write 1,191 26 22 7.2 System I/O
-------------------------------------------------------------
Time Model Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total time in database user-calls (DB Time): 354.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 290.8 82.1
sql execute elapsed time 276.7 78.1
parse time elapsed 7.8 2.2
hard parse elapsed time 6.6 1.9
PL/SQL execution elapsed time 6.1 1.7
failed parse elapsed time 5.9 1.7
repeated bind elapsed time 2.1 .6
connection management call elapsed time 0.3 .1
hard parse (sharing criteria) elapsed time 0.2 .1
sequence load elapsed time 0.1 .0
hard parse (bind mismatch) elapsed time 0.1 .0
DB time 354.4 N/A
background elapsed time 122.8 N/A
background cpu time 11.0 N/A
-------------------------------------------------------------
Wait Class DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 9,831 .0 85 9 2.2
Commit 4,435 .0 63 14 1.0
Network 1,821,046 .0 37 0 404.0
User I/O 60,197 .0 9 0 13.4
Concurrency 83 .0 2 28 0.0
Other 19 .0 0 2 0.0
Application 6 .0 0 3 0.0
Configuration 1 .0 0 0 0.0
-------------------------------------------------------------
Wait Events DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 4,435 .0 63 14 1.0
log file parallel write 4,610 .0 60 13 1.0
SQL*Net more data from clien 174,808 .0 26 0 38.8
control file parallel write 1,191 .0 26 22 0.3
db file sequential read 25,102 .0 8 0 5.6
SQL*Net more data to client 475,109 .0 6 0 105.4
SQL*Net message to client 1,169,974 .0 4 0 259.5
os thread startup 43 .0 2 42 0.0
library cache load lock 5 .0 0 84 0.0
db file scattered read 260 .0 0 2 0.1
direct path read 34,771 .0 0 0 7.7
control file sequential read 4,030 .0 0 0 0.9
latch: library cache 5 .0 0 10 0.0
latch free 14 .0 0 3 0.0
buffer busy waits 6 .0 0 6 0.0
latch: library cache pin 1 .0 0 23 0.0
SQL*Net break/reset to clien 6 .0 0 3 0.0
latch: library cache lock 1 .0 0 6 0.0
SQL*Net message to dblink 1,026 .0 0 0 0.2
latch: cache buffers chains 16 .0 0 0 0.0
latch: row cache objects 6 .0 0 0 0.0
SQL*Net more data to dblink 64 .0 0 0 0.0
latch: enqueue hash chains 1 .0 0 1 0.0
SQL*Net more data from dblin 65 .0 0 0 0.0
latch: session allocation 1 .0 0 1 0.0
latch: cache buffer handles 1 .0 0 1 0.0
enq: SQ - contention 1 .0 0 0 0.0
direct path write 62 .0 0 0 0.0
db file parallel read 2 .0 0 0 0.0
LGWR wait for redo copy 2 .0 0 0 0.0
SQL*Net message from client 1,169,970 .0 3,181,455 2719 259.5
jobq slave wait 1,278 97.1 3,706 2900 0.3
Streams AQ: waiting for mess 720 100.0 3,516 4883 0.2
virtual circuit status 120 100.0 3,515 29294 0.0
Streams AQ: qmn slave idle w 128 .0 3,515 27460 0.0
Streams AQ: qmn coordinator 263 51.3 3,515 13364 0.1
Streams AQ: waiting for time 4 50.0 2,571 642648 0.0
SQL*Net message from dblink 1,026 .0 46 45 0.2
single-task message 52 .0 5 94 0.0
class slave wait 1 .0 0 0 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 4,610 .0 60 13 1.0
control file parallel write 1,191 .0 26 22 0.3
os thread startup 43 .0 2 42 0.0
db file scattered read 88 .0 0 3 0.0
log file sync 1 .0 0 28 0.0
db file sequential read 19 .0 0 1 0.0
control file sequential read 1,224 .0 0 0 0.3
events in waitclass Other 2 .0 0 0 0.0
rdbms ipc message 16,372 70.5 36,964 2258 3.6
smon timer 41 7.3 3,515 85737 0.0
Streams AQ: qmn slave idle w 128 .0 3,515 27460 0.0
Streams AQ: qmn coordinator 263 51.3 3,515 13364 0.1
pmon timer 1,205 100.0 3,513 2916 0.3
Streams AQ: waiting for time 4 50.0 2,571 642648 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
Statistic Total
-------------------------------- --------------------
BUSY_TIME 47,591
IDLE_TIME 672,712
IOWAIT_TIME 22,421
NICE_TIME 0
SYS_TIME 15,397
USER_TIME 31,561
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 32,840
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS 354.3 290.7 60,932 ##########
SYS$BACKGROUND 0.0 0.0 1,189 19,193
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: 3235-3236
-> 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
59640 821 40 55 0 0 1820863 3667
SYS$BACKGROUND
559 56 43 179 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
---------- ---------- ------------ ---------- ------- -------------
101 101 111,070 0.0 28.6 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
35 35 300 0.1 10.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
9 9 79 0.1 2.5 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
8 8 10,195 0.0 2.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
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US
8 8 8,380 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_
7 7 8,448 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
5 5 2,922 0.0 1.5 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
5 5 4,961 0.0 1.4 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 = :
4 4 231 0.0 1.1 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
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
---------- ---------- ------------ ---------- ------- -------------
4 3 427 0.0 1.0 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 CPU Time DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
---------- ---------- ------------ ----------- ------- -------------
101 101 111,070 0.00 28.6 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
35 35 300 0.12 10.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
9 9 79 0.11 2.5 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
8 8 10,195 0.00 2.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
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US
8 8 8,380 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_
7 7 8,448 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
5 5 2,922 0.00 1.5 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
5 5 4,961 0.00 1.4 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 = :
4 4 231 0.02 1.1 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
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
---------- ---------- ------------ ----------- ------- -------------
3 4 427 0.01 1.0 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 Gets DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 16,189,850
-> Captured SQL account for 87.5% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
3,952,206 300 13,174.0 24.4 35.08 35.38 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
3,644,829 111,070 32.8 22.5 101.21 101.23 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,040,589 79 13,172.0 6.4 8.95 9.01 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
853,949 142 6,013.7 5.3 1.83 1.85 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_
624,812 25 24,992.5 3.9 1.54 1.54 3hb0b3njra0kq
Module: JDBC Thin Client
select sr.REALM_ID from SAKAI_REALM sr INNER JOIN SAKAI_REALM_PROVIDER srp on sr
.REALM_KEY = srp.REALM_KEY where srp.PROVIDER_ID=:1
430,843 427 1,009.0 2.7 3.42 3.51 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
415,258 8,380 49.6 2.6 7.95 7.95 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_
409,252 10,195 40.1 2.5 8.43 8.44 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
403,204 231 1,745.5 2.5 3.75 3.78 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
399,526 2,922 136.7 2.5 5.30 5.33 20ux4jqcvrgps
Module: JDBC Thin Client
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 16,189,850
-> Captured SQL account for 87.5% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
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
371,602 8,448 44.0 2.3 7.24 7.24 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
232,823 6,227 37.4 1.4 1.49 1.50 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(
222,740 886 251.4 1.4 2.32 2.32 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
195,614 4,961 39.4 1.2 5.03 5.04 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 = :
176,049 1,938 90.8 1.1 1.40 1.41 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
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total Disk Reads: 62,101
-> Captured SQL account for 27.4% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
6,412 347 18.5 10.3 0.67 1.33 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
4,736 6,342 0.7 7.6 0.77 0.85 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_.
1,124 347 3.2 1.8 0.15 0.31 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
896 1,041 0.9 1.4 0.71 1.05 6vj7vwqayjv96
Module: JDBC Thin Client
select SR.REALM_ID from SAKAI_REALM_FUNCTION SRF inner join SAKAI_REALM_RL_FN SR
RF on SRF.FUNCTION_KEY = SRRF.FUNCTION_KEY inner join SAKAI_REALM_RL_GR SRRG on
SRRF.ROLE_KEY = SRRG.ROLE_KEY and SRRF.REALM_KEY = SRRG.REALM_KEY inner join SAK
AI_REALM SR on SRRF.REALM_KEY = SR.REALM_KEY where SRF.FUNCTION_NAME = :1 and SR
869 3,090 0.3 1.4 0.88 1.11 d8hgvrcs9x1yw
Module: JDBC Thin Client
select TOOL_ID, PAGE_ID, REGISTRATION, TITLE, LAYOUT_HINTS, PAGE_ORDER from SAKA
I_SITE_TOOL where SITE_ID = :1 order by PAGE_ID, PAGE_ORDER ASC
747 1,248 0.6 1.2 1.86 1.86 dub7v8sr436fw
Module: JDBC Thin Client
select XML from ASSIGNMENT_SUBMISSION where CONTEXT = :1
358 22,179 0.0 0.6 1.19 1.23 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )
276 331 0.8 0.4 0.33 0.39 2n6s0wa0t4zcr
Module: JDBC Thin Client
insert into SAKAI_SESSION (SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SES
SION_USER_AGENT,SESSION_START,SESSION_END) values (:1, :2, :3, :4, :5, :6, :7)
260 347 0.7 0.4 0.08 0.09 0rkdbapw8nsya
Module: JDBC Thin Client
select sectioncmi0_.EID as col_0_0_, membership1_.ROLE as col_1_0_ from COURSEMA
NAGEMENT_SECTION sectioncmi0_, COURSEMANAGEMENT_MEMBERSHIP membership1_ where me
mbership1_.PERSON_EID=:1 and membership1_.SECTION_EID=sectioncmi0_.EID
245 3 81.7 0.4 0.02 0.02 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
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total Executions: 413,479
-> Captured SQL account for 57.2% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
111,070 111,070 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
25,187 24,984 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
22,179 19,749 0.9 0.00 0.00 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )
10,195 10,195 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
8,448 8,448 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
8,380 8,380 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_
6,342 6,342 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_.
6,227 6,227 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(
5,993 5,993 1.0 0.00 0.00 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
4,961 4,961 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
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total Executions: 413,479
-> Captured SQL account for 57.2% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
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: 3235-3236
-> Total Parse Calls: 22,324
-> Captured SQL account for 43.3% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
5,993 5,993 26.85 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
272 272 1.22 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
272 272 1.22 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
266 266 1.19 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
205 205 0.92 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
156 156 0.70 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=:
144 144 0.65 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
137 137 0.61 459f3z9u4fb3u
select value$ from props$ where name = 'GLOBAL_DB_NAME'
89 89 0.40 ftj9uawt4wwzb
select condition from cdef$ where rowid=:1
85 85 0.38 0ws7ahf1d78qa
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_
NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE
_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from
v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
13,637,788 N/A 2.14 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'
4,363,624 12 0.68 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
2,299,413 174 0.36 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 =
1,995,508 27 0.31 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,718,865 8,380 0.27 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,214,610 2 0.19 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
1,214,591 2 0.19 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'
1,136,697 2 0.18 40vs0d973zp4z
Module: SQL*Plus
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_ENROLLM
ENT where ENROLLMENTSET_EID = 'http://ucdavis.edu/course/enrollmentset/58553/200
703'
1,055,622 2 0.17 dwyf59gxj5tp8
Module: SQL*Plus
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_ENROLLM
ENT enr where enr.enrollmentSet_eid='http://ucdavis.edu/course/enrollmentset/585
53/200703' and enr.PERSON_EID='00000'
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
488 8,380 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_
273 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'
211 4,961 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 = :
166 12 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
154 27 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 )
86 174 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 =
48 2 40vs0d973zp4z
Module: SQL*Plus
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_ENROLLM
ENT where ENROLLMENTSET_EID = 'http://ucdavis.edu/course/enrollmentset/58553/200
703'
48 2 dwyf59gxj5tp8
Module: SQL*Plus
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_ENROLLM
ENT enr where enr.enrollmentSet_eid='http://ucdavis.edu/course/enrollmentset/585
53/200703' and enr.PERSON_EID='00000'
45 2 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
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
36 111,070 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
35 8,448 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
34 3 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
26 2 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
24 146 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
23 1 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=:
22 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
22 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'
22 2 870bapc3b0kcx
Module: SQL*Plus
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_INSTRUC
TORS where ENROLLMENTSET_EID = 'http://ucdavis.edu/course/enrollmentset/58553/20
0703'
-------------------------------------------------------------
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 29,066 8.1 6.5
CPU used when call started 28,419 7.9 6.3
CR blocks created 39 0.0 0.0
Cached Commit SCN referenced 105 0.0 0.0
Commit SCN cached 2 0.0 0.0
DB time 781,480 217.0 173.4
DBWR checkpoint buffers written 3,441 1.0 0.8
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 3,441 1.0 0.8
DBWR transaction table writes 32 0.0 0.0
DBWR undo block writes 848 0.2 0.2
IMU CR rollbacks 23 0.0 0.0
IMU Flushes 1,477 0.4 0.3
IMU Redo allocation size 1,883,960 523.1 417.9
IMU commits 3,727 1.0 0.8
IMU contention 6 0.0 0.0
IMU ktichg flush 23 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 11 0.0 0.0
IMU undo allocation size 8,234,672 2,286.5 1,826.7
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,169,903 324.8 259.5
SQL*Net roundtrips to/from dblin 1,026 0.3 0.2
active txn count during cleanout 149 0.0 0.0
application wait time 2 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 11,574 3.2 2.6
branch node splits 0 0.0 0.0
buffer is not pinned count 5,020,266 1,393.9 1,113.6
buffer is pinned count 6,174,209 1,714.4 1,369.6
bytes received via SQL*Net from 698,261,062 193,881.3 154,893.8
bytes received via SQL*Net from 359,529 99.8 79.8
bytes sent via SQL*Net to client 1,446,772,483 401,715.3 320,934.5
bytes sent via SQL*Net to dblink 438,336 121.7 97.2
calls to get snapshot scn: kcmgs 1,042,296 289.4 231.2
calls to kcmgas 6,107 1.7 1.4
calls to kcmgcs 468 0.1 0.1
change write time 60 0.0 0.0
cleanout - number of ktugct call 235 0.1 0.1
cleanouts and rollbacks - consis 16 0.0 0.0
cleanouts only - consistent read 37 0.0 0.0
cluster key scan block gets 1,253 0.4 0.3
cluster key scans 810 0.2 0.2
commit batch performed 52 0.0 0.0
commit batch requested 52 0.0 0.0
commit batch/immediate performed 52 0.0 0.0
commit batch/immediate requested 52 0.0 0.0
commit cleanout failures: block 22 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callba 22 0.0 0.0
commit cleanout failures: cannot 3 0.0 0.0
commit cleanouts 17,646 4.9 3.9
commit cleanouts successfully co 17,599 4.9 3.9
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed 0 0.0 0.0
commit immediate requested 0 0.0 0.0
commit txn count during cleanout 533 0.2 0.1
concurrency wait time 233 0.1 0.1
consistent changes 788 0.2 0.2
consistent gets 16,074,263 4,463.2 3,565.7
consistent gets - examination 4,069,714 1,130.0 902.8
consistent gets direct 34,968 9.7 7.8
consistent gets from cache 16,039,295 4,453.5 3,558.0
current blocks converted for CR 0 0.0 0.0
cursor authentications 94 0.0 0.0
data blocks consistent reads - u 62 0.0 0.0
db block changes 87,696 24.4 19.5
db block gets 115,638 32.1 25.7
db block gets direct 135 0.0 0.0
db block gets from cache 115,503 32.1 25.6
deferred (CURRENT) block cleanou 7,912 2.2 1.8
dirty buffers inspected 2,030 0.6 0.5
enqueue conversions 1,615 0.5 0.4
enqueue releases 57,786 16.1 12.8
enqueue requests 57,812 16.1 12.8
enqueue timeouts 22 0.0 0.0
enqueue waits 1 0.0 0.0
execute count 413,479 114.8 91.7
failed probes on index block rec 0 0.0 0.0
frame signature mismatch 0 0.0 0.0
free buffer inspected 34,612 9.6 7.7
free buffer requested 28,604 7.9 6.4
heap block compress 161 0.0 0.0
hot buffers moved to head of LRU 61,170 17.0 13.6
immediate (CR) block cleanout ap 53 0.0 0.0
immediate (CURRENT) block cleano 1,916 0.5 0.4
index crx upgrade (found) 11 0.0 0.0
index crx upgrade (positioned) 598,620 166.2 132.8
index fast full scans (full) 64 0.0 0.0
index fetch by key 1,733,870 481.4 384.6
index scans kdiixs1 2,921,728 811.3 648.1
leaf node 90-10 splits 33 0.0 0.0
leaf node splits 99 0.0 0.0
lob reads 15,117 4.2 3.4
lob writes 835 0.2 0.2
lob writes unaligned 794 0.2 0.2
logons cumulative 185 0.1 0.0
messages received 5,464 1.5 1.2
messages sent 5,464 1.5 1.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 11,327,930 3,145.4 2,512.9
opened cursors cumulative 22,361 6.2 5.0
parse count (failures) 111 0.0 0.0
parse count (hard) 201 0.1 0.0
parse count (total) 22,324 6.2 5.0
parse time cpu 174 0.1 0.0
parse time elapsed 1,014 0.3 0.2
physical read IO requests 60,054 16.7 13.3
physical read bytes 508,731,392 141,255.9 112,850.8
physical read total IO requests 64,147 17.8 14.2
physical read total bytes 575,275,008 159,732.6 127,612.0
physical read total multi block 385 0.1 0.1
physical reads 62,101 17.2 13.8
physical reads cache 27,143 7.5 6.0
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache prefetch 1,902 0.5 0.4
physical reads direct 34,958 9.7 7.8
physical reads direct (lob) 34,918 9.7 7.8
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 4,421 1.2 1.0
physical write bytes 52,027,392 14,446.1 11,541.1
physical write total IO requests 17,209 4.8 3.8
physical write total bytes 146,135,040 40,576.3 32,416.8
physical write total multi block 9,556 2.7 2.1
physical writes 6,351 1.8 1.4
physical writes direct 135 0.0 0.0
physical writes direct (lob) 135 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 6,216 1.7 1.4
physical writes non checkpoint 4,623 1.3 1.0
pinned buffers inspected 3 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 0 0.0 0.0
process last non-idle time 5,517 1.5 1.2
recovery blocks read 0 0.0 0.0
recursive calls 147,248 40.9 32.7
recursive cpu usage 787 0.2 0.2
redo blocks read for recovery 0 0.0 0.0
redo blocks written 34,734 9.6 7.7
redo buffer allocation retries 0 0.0 0.0
redo entries 29,588 8.2 6.6
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 15,892,528 4,412.8 3,525.4
redo synch time 6,480 1.8 1.4
redo synch writes 96,317 26.7 21.4
redo wastage 1,220,004 338.8 270.6
redo write time 6,073 1.7 1.4
redo writer latching time 0 0.0 0.0
redo writes 4,611 1.3 1.0
rollback changes - undo records 0 0.0 0.0
rollbacks only - consistent read 22 0.0 0.0
rows fetched via callback 913,483 253.6 202.6
session connect time 0 0.0 0.0
session cursor cache hits 9,285 2.6 2.1
session logical reads 16,189,850 4,495.3 3,591.4
session pga memory 77,114,072 21,411.7 17,106.1
session pga memory max 96,774,872 26,870.8 21,467.4
session uga memory 231,932,893,580 64,399,203.3 51,449,177.8
session uga memory max 95,213,596 26,437.3 21,121.0
shared hash latch upgrades - no 607,506 168.7 134.8
shared hash latch upgrades - wai 11 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 22,560 6.3 5.0
sorts (rows) 356,517 99.0 79.1
sql area evicted 0 0.0 0.0
sql area purged 111 0.0 0.0
summed dirty queue length 2,106 0.6 0.5
switch current to new buffer 341 0.1 0.1
table fetch by rowid 3,653,204 1,014.4 810.4
table fetch continued row 22,652 6.3 5.0
table scan blocks gotten 7,073,510 1,964.1 1,569.1
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
table scan rows gotten 361,737,626 100,441.2 80,243.5
table scans (long tables) 22 0.0 0.0
table scans (short tables) 11,903 3.3 2.6
total number of times SMON poste 38 0.0 0.0
transaction rollbacks 52 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 5,129,140 1,424.2 1,137.8
user I/O wait time 873 0.2 0.2
user calls 1,186,217 329.4 263.1
user commits 4,480 1.2 1.0
user rollbacks 28 0.0 0.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 18,412 5.1 4.1
write clones created in backgrou 0 0.0 0.0
write clones created in foregrou 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: SAKAI/sakai Snaps: 3235-32
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 290,397 293,525
opened cursors current 35,796 35,800
workarea memory allocated 1,009 1,009
logons current 1,039 1,044
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai Snaps: 3235-323
-> 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: 3235-3236
-> 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
58,906 16 0.1 1.0 4,026 1 0 0.0
SYSAUX
536 0 0.5 2.3 226 0 0 0.0
SYSTEM
627 0 0.7 2.1 62 0 6 5.0
UNDOTBS1
1 0 0.0 1.0 94 0 0 0.0
TEMP
0 0 0.0 N/A 13 0 0 0.0
INDEX_TS
5 0 0.0 1.0 0 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DATA_TS /local/d02/oracle/sakai/data01.dbf
47,100 13 0.2 1.0 3,467 1 0 0.0
DATA_TS /local/d02/oracle/sakai/data02.dbf
11,806 3 0.1 1.0 559 0 0 0.0
INDEX_TS /local/d02/oracle/sakai/index01.dbf
5 0 0.0 1.0 0 0 0 0.0
SYSAUX /local/d02/oracle/sakai/sysaux01.dbf
536 0 0.5 2.3 226 0 0 0.0
SYSTEM /local/d02/oracle/sakai/system01.dbf
627 0 0.7 2.1 62 0 6 5.0
TEMP /local/d02/oracle/sakai/temp01.dbf
0 0 N/A N/A 2 0 0 N/A
TEMP /local/d02/oracle/sakai/temp02.dbf
0 0 N/A N/A 11 0 0 N/A
UNDOTBS1 /local/d02/oracle/sakai/undotbs01.dbf
1 0 0.0 1.0 94 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 104,581 100 16,153,627 27,165 6,216 0 0 6
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 1913 13370 13093 737280 13093 N/A
E 0 0 1452 15824 15638 737280 15638 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: SAKAI/sakai Snap: 3236
-> 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 80 .1 9,995 1.5 544,372,524
D 160 .2 19,990 1.3 466,311,823
D 240 .3 29,985 1.1 423,768,088
D 320 .4 39,980 1.1 396,277,225
D 400 .5 49,975 1.0 379,914,429
D 480 .6 59,970 1.0 372,499,926
D 560 .7 69,965 1.0 370,463,022
D 640 .8 79,960 1.0 369,792,721
D 720 .8 89,955 1.0 369,571,143
D 800 .9 99,950 1.0 369,443,215
D 848 1.0 105,947 1.0 369,393,039
D 880 1.0 109,945 1.0 369,359,115
D 960 1.1 119,940 1.0 369,299,980
D 1,040 1.2 129,935 1.0 369,254,955
D 1,120 1.3 139,930 1.0 369,215,399
D 1,200 1.4 149,925 1.0 369,182,353
D 1,280 1.5 159,920 1.0 369,152,763
D 1,360 1.6 169,915 1.0 369,126,130
D 1,440 1.7 179,910 1.0 369,104,979
D 1,520 1.8 189,905 1.0 369,083,357
D 1,600 1.9 199,900 1.0 369,046,923
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
--------------- ------------------ --------------------------
100.0 792 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 168 933.9 1.0 .1 100.0 .0 102,400
E 800 167 939.3 1.0 .1 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 17,249 17,249 0 0
64K 128K 319 319 0 0
128K 256K 20 20 0 0
256K 512K 16 16 0 0
512K 1024K 640 640 0 0
1M 2M 159 159 0 0
2M 4M 1 1 0 0
8M 16M 8 8 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: SAKAI/sakai Snap: 3236
-> 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 362,825.2 37,550.5 91.0 1,665
200 0.3 362,825.2 37,512.5 91.0 1,665
400 0.5 362,825.2 34,375.9 91.0 1,556
600 0.8 362,825.2 19,305.6 95.0 490
800 1.0 362,825.2 2,060.9 99.0 0
960 1.2 362,825.2 1,997.1 99.0 0
1,120 1.4 362,825.2 1,997.1 99.0 0
1,280 1.6 362,825.2 1,997.1 99.0 0
1,440 1.8 362,825.2 1,997.1 99.0 0
1,600 2.0 362,825.2 1,997.1 99.0 0
2,400 3.0 362,825.2 1,997.1 99.0 0
3,200 4.0 362,825.2 1,997.1 99.0 0
4,800 6.0 362,825.2 1,997.1 99.0 0
6,400 8.0 362,825.2 1,997.1 99.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: SAKAI/sakai Snap: 3236
-> 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 .5 77 6,775 ####### 1.0 ####### 47.1 19,042,774
352 .6 137 9,022 ####### 1.0 ####### 32.3 19,063,037
416 .7 196 11,198 ####### 1.0 71,125 19.4 19,079,866
480 .8 259 16,063 ####### 1.0 41,827 11.4 19,090,804
544 .9 321 18,795 ####### 1.0 20,044 5.5 19,098,393
608 1.0 384 21,578 ####### 1.0 3,670 1.0 19,103,391
672 1.1 447 25,520 ####### 1.0 1 .0 19,106,423
736 1.2 510 29,969 ####### 1.0 1 .0 19,108,514
800 1.3 573 33,064 ####### 1.0 1 .0 19,110,179
864 1.4 636 36,056 ####### 1.0 1 .0 19,111,729
928 1.5 699 39,957 ####### 1.0 1 .0 19,113,178
992 1.6 718 41,925 ####### 1.0 1 .0 19,114,466
1,056 1.7 718 41,925 ####### 1.0 1 .0 19,115,628
1,120 1.8 781 44,826 ####### 1.0 1 .0 19,116,801
1,184 1.9 844 47,620 ####### 1.0 1 .0 19,117,957
1,248 2.1 870 48,890 ####### 1.0 1 .0 19,119,096
-------------------------------------------------------------
SGA Target Advisory DB/Inst: SAKAI/sakai Snap: 3236
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
752 0.5 287,095 466,247,799
1,128 0.8 239,175 379,846,785
1,504 1.0 235,826 369,392,964
1,880 1.3 235,732 369,134,389
2,256 1.5 235,708 368,986,632
2,632 1.8 235,708 368,986,632
3,008 2.0 235,708 368,986,632
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: SAKAI/sakai Snap: 3236
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: SAKAI/sakai Snap: 3236
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 3,670 1.0 76
32 2.0 2 76 1 1.0 3,670 1.0 76
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 6 0 5
-------------------------------------------------------------
Enqueue Activity DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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)
------------ ------------ ----------- ----------- ------------ --------------
SQ-Sequence Cache
206 206 0 1 0 .00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 .6 4,643 2,141 7 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
07-Oct 13:50 113 900 2,141 6 8,347 0/0 0/0/0/0/0/0
07-Oct 13:40 163 1,174 1,507 7 8,337 0/0 0/0/0/0/0/0
07-Oct 13:30 83 746 906 3 8,329 0/0 0/0/0/0/0/0
07-Oct 13:20 195 1,063 240 7 8,318 0/0 0/0/0/0/0/0
07-Oct 13:10 89 760 684 5 8,311 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> "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 2,382 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 80,362 0.0 N/A 0 0 N/A
Consistent RBA 4,610 0.0 N/A 0 0 N/A
FAL request queue 72 0.0 N/A 0 0 N/A
FAL subheap alocation 72 0.0 N/A 0 0 N/A
FOB s.o list latch 236 0.0 N/A 0 0 N/A
In memory undo latch 36,818 0.0 0.0 0 6,885 0.0
JS mem alloc latch 17 0.0 N/A 0 0 N/A
JS queue access latch 17 0.0 N/A 0 0 N/A
JS queue state obj latch 26,026 0.0 N/A 0 0 N/A
JS slv state obj latch 133 0.0 N/A 0 0 N/A
KMG MMAN ready and start 1,200 0.0 N/A 0 0 N/A
KTF sga latch 7 0.0 N/A 0 959 0.0
KWQMN job cache list lat 8 0.0 N/A 0 0 N/A
MQL Tracking Latch 0 N/A N/A 0 72 0.0
Memory Management Latch 0 N/A N/A 0 1,200 0.0
OS process 636 0.0 N/A 0 0 N/A
OS process allocation 1,629 0.0 N/A 0 0 N/A
OS process: request allo 256 0.0 N/A 0 0 N/A
PL/SQL warning settings 751 0.0 N/A 0 0 N/A
SGA IO buffer pool latch 3 0.0 N/A 0 3 0.0
SQL memory manager latch 1 0.0 N/A 0 1,191 0.0
SQL memory manager worka 1,262,162 0.0 0.0 0 0 N/A
Shared B-Tree 140 0.0 N/A 0 0 N/A
active checkpoint queue 1,759 0.0 N/A 0 0 N/A
active service list 9,125 0.0 N/A 0 1,205 0.0
archive control 370 0.0 N/A 0 0 N/A
archive process latch 1,263 0.0 N/A 0 0 N/A
begin backup scn array 134 0.0 N/A 0 0 N/A
cache buffer handles 637,038 0.0 0.0 0 0 N/A
cache buffers chains 28,541,193 0.0 0.0 0 32,607 0.0
cache buffers lru chain 41,775 0.0 N/A 0 3,594 0.0
cache table scan latch 0 N/A N/A 0 260 0.0
channel handle pool latc 300 0.0 N/A 0 0 N/A
channel operations paren 17,538 0.0 N/A 0 0 N/A
checkpoint queue latch 28,950 0.0 N/A 0 4,627 0.0
client/application info 83 0.0 N/A 0 0 N/A
commit callback allocati 128 0.0 N/A 0 0 N/A
compile environment latc 96,254 0.0 0.0 0 0 N/A
constraint object alloca 104 0.0 N/A 0 0 N/A
dml lock allocation 27,001 0.0 0.0 0 0 N/A
dummy allocation 365 0.0 N/A 0 0 N/A
enqueue hash chains 117,210 0.0 0.1 0 66 0.0
enqueues 173,430 0.0 0.0 0 0 N/A
event group latch 130 0.0 N/A 0 0 N/A
file cache latch 166 0.0 N/A 0 0 N/A
global KZLD latch for me 88 0.0 N/A 0 0 N/A
global tx hash mapping 1,621 0.0 N/A 0 0 N/A
hash table column usage 122 0.0 N/A 0 25,798 0.0
hash table modification 95 0.0 N/A 0 0 N/A
job workq parent latch 0 N/A N/A 0 90 0.0
job_queue_processes para 82 0.0 N/A 0 0 N/A
kks stats 152 0.0 N/A 0 0 N/A
ksuosstats global area 242 0.0 N/A 0 0 N/A
ktm global data 41 0.0 N/A 0 0 N/A
kwqbsn:qsga 140 0.0 N/A 0 0 N/A
lgwr LWN SCN 4,992 0.0 N/A 0 0 N/A
library cache 213,478 0.0 0.1 0 0 N/A
library cache load lock 174 0.0 N/A 0 0 N/A
library cache lock 71,528 0.0 0.0 0 0 N/A
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> "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 lock alloc 2,613 0.0 0.0 0 0 N/A
library cache pin 27,429 0.0 0.5 0 0 N/A
library cache pin alloca 579 0.0 N/A 0 0 N/A
list of block allocation 679 0.0 N/A 0 0 N/A
loader state object free 29,124 0.0 N/A 0 0 N/A
message pool operations 84 0.0 N/A 0 0 N/A
messages 39,452 0.0 N/A 0 0 N/A
mostly latch-free SCN 4,983 0.0 N/A 0 0 N/A
multiblock read objects 670 0.0 N/A 0 0 N/A
ncodef allocation latch 58 0.0 N/A 0 0 N/A
object queue header heap 1,853 0.0 N/A 0 47 0.0
object queue header oper 77,656 0.0 N/A 0 0 N/A
object stats modificatio 69 0.0 N/A 0 0 N/A
parallel query alloc buf 476 0.0 N/A 0 0 N/A
parameter table allocati 286 0.0 N/A 0 0 N/A
post/wait queue 11,146 0.0 N/A 0 4,435 0.0
process allocation 256 0.0 N/A 0 130 0.0
process group creation 256 0.0 N/A 0 0 N/A
qmn task queue latch 512 0.0 N/A 0 0 N/A
redo allocation 52,983 0.0 0.0 0 0 N/A
redo copy 0 N/A N/A 0 29,621 0.0
redo writing 17,988 0.0 N/A 0 0 N/A
row cache objects 3,633,005 0.0 0.1 0 0 N/A
sequence cache 12,774 0.0 N/A 0 0 N/A
session allocation 198,531 0.0 0.3 0 0 N/A
session idle bit 2,468,327 0.0 0.1 0 0 N/A
session state list latch 467 0.0 N/A 0 0 N/A
session switching 67 0.0 N/A 0 0 N/A
session timer 1,205 0.0 N/A 0 0 N/A
shared pool 18,134 0.1 0.0 0 0 N/A
shared pool sim alloc 5 0.0 N/A 0 0 N/A
shared pool simulator 2,880 0.0 N/A 0 0 N/A
simulator hash latch 890,658 0.0 N/A 0 0 N/A
simulator lru latch 886,706 0.1 0.0 0 1,854 0.0
slave class 2 0.0 N/A 0 0 N/A
slave class create 8 12.5 1.0 0 0 N/A
sort extent pool 401 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 2 0.0 N/A 0 0 N/A
temporary table state ob 21 0.0 N/A 0 0 N/A
threshold alerts latch 328 0.0 N/A 0 0 N/A
transaction allocation 261 0.0 N/A 0 0 N/A
transaction branch alloc 266 0.0 N/A 0 0 N/A
undo global data 31,158 0.0 0.0 0 0 N/A
user lock 450 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
28,541,193 628 16 612 0 0 0
simulator lru latch
886,706 560 10 550 0 0 0
row cache objects
3,633,005 109 6 103 0 0 0
library cache
213,478 52 5 47 0 0 0
session idle bit
2,468,327 46 3 43 0 0 0
library cache lock
71,528 31 1 30 0 0 0
cache buffer handles
637,038 30 1 29 0 0 0
enqueue hash chains
117,210 16 1 15 0 0 0
session allocation
198,531 4 1 3 0 0 0
library cache pin
27,429 2 1 1 0 0 0
slave class create
8 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
SQL memory manager worka qesmmIUnRegisterWorkArea 0 1 0
cache buffer handles kcbzgs 0 1 1
cache buffers chains kcbgtcr: fast path 0 10 6
cache buffers chains kcbgtcr: kslbegin excl 0 5 8
cache buffers chains kcbrls: kslbegin 0 4 4
cache buffers chains kcbgcur: kslbegin 0 1 1
enqueue hash chains ksqgtl3 0 1 1
library cache kglLockCursor 0 1 0
library cache kglScanDependency 0 1 0
library cache kglhdgn: child: 0 1 2
library cache kglic 0 1 0
library cache kglpin 0 1 0
library cache lock kgllkal: child: multiinsta 0 1 1
library cache pin kglpnal: child: alloc spac 0 1 1
row cache objects kqreqd: reget 0 4 0
row cache objects kqreqd 0 1 0
row cache objects kqrpre: find obj 0 1 6
session allocation ksucri 0 1 0
session idle bit ksupuc: clear busy 0 2 1
session idle bit ksupuc: set busy 0 1 2
simulator lru latch kcbs_simulate: simulate se 0 10 10
slave class create ksvcreate 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total Logical Reads: 16,189,850
-> Captured Segments account for 94.1% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SAKAI_SESSION TABLE 5,001,616 30.89
SAKAI DATA_TS AK_SAKAI_REALM_ID INDEX 1,383,408 8.54
SAKAI DATA_TS SYS_C004181 INDEX 1,244,656 7.69
SAKAI DATA_TS SAKAI_REALM_RL_GR_RA INDEX 899,872 5.56
SAKAI DATA_TS SYS_C004177 INDEX 666,880 4.12
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> Total Physical Reads: 62,101
-> Captured Segments account for 54.8% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SYS_LOB0000046053C00 LOB 26,646 42.91
SAKAI DATA_TS SYS_C004181 INDEX 1,242 2.00
SAKAI DATA_TS ASSIGNMENT_SUBMISSIO TABLE 713 1.15
SAKAI DATA_TS CONTENT_RESOURCE TABLE 631 1.02
SAKAI DATA_TS SAKAI_SITE_TOOL TABLE 569 .92
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> % 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 19 39.58
SAKAI DATA_TS IE_SAKAI_SITE_FLAGS INDEX 18 37.50
SAKAI DATA_TS SYS_C004111 INDEX 3 6.25
SAKAI DATA_TS SYS_C004212 INDEX 3 6.25
SAKAI DATA_TS SYS_C004290 INDEX 3 6.25
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> % 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 JOB$ TABLE 2 33.33
SYS SYSTEM SUM$ TABLE 2 33.33
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 1 16.67
SYS SYSTEM SNAP_REFTIME$ TABLE 1 16.67
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> "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 65 0.0 0 N/A 2 1
dc_database_links 546 0.0 0 N/A 0 6
dc_global_oids 17 0.0 0 N/A 0 157
dc_histogram_data 985 0.0 0 N/A 0 9,129
dc_histogram_defs 1,594 0.1 0 N/A 0 6,440
dc_object_ids 3,927 0.0 0 N/A 0 2,495
dc_objects 1,835 0.3 0 N/A 5 3,178
dc_profiles 144 0.0 0 N/A 0 1
dc_rollback_segments 14,359 0.0 0 N/A 0 392
dc_segments 1,090 0.0 0 N/A 5 2,458
dc_sequences 205 0.0 0 N/A 205 50
dc_tablespace_quotas 1 0.0 0 N/A 1 6
dc_tablespaces 591,889 0.0 0 N/A 0 9
dc_usernames 586 0.0 0 N/A 0 34
dc_users 596,558 0.0 0 N/A 0 85
global database name 104 0.0 0 N/A 0 1
outstanding_alerts 130 0.0 0 N/A 0 17
-------------------------------------------------------------
Library Cache Activity DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,298 0.0 1,427 0.0 0 0
CLUSTER 11 0.0 16 0.0 0 0
SQL AREA 85 61.2 417,828 0.1 123 0
TABLE/PROCEDURE 460 0.9 7,806 1.1 1 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 747.8 N/A .7 2.3 63 63 1,041 1,041
Freeable 116.3 .0 .5 .3 1 N/A 249 249
SQL 68.2 20.6 .1 .1 1 106 1,030 1,026
PL/SQL 2.4 .3 .0 .0 0 0 1,039 1,039
E Other 751.6 N/A .7 2.3 63 63 1,045 1,045
Freeable 117.7 .0 .5 .3 1 N/A 250 250
SQL 68.4 20.6 .1 .1 1 106 1,034 1,030
PL/SQL 2.5 .4 .0 .0 0 0 1,043 1,043
-------------------------------------------------------------
SGA Memory Summary DB/Inst: SAKAI/sakai Snaps: 3235-3236
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 889,192,448
Fixed Size 1,262,764
Redo Buffers 15,511,552
Variable Size 1,191,185,236
-------------------
sum 2,097,152,000
-------------------------------------------------------------
SGA breakdown difference DB/Inst: SAKAI/sakai Snaps: 3235-3236
-> 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 41.9 42.4 1.04
shared Heap0: KGL 10.2 10.2 0.05
shared KGH: NO ACCESS 69.3 69.3 0.00
shared KGLS heap 10.4 10.4 0.00
shared KTI-UNDO 14.7 14.7 0.00
shared PCursor 17.8 17.8 0.19
shared PL/SQL MPCODE 7.8 7.8 0.00
shared event statistics per sess 15.7 15.7 0.00
shared free memory 82.7 77.9 -5.79
shared library cache 29.7 29.8 0.33
shared private strands 14.2 14.2 0.00
shared sessions 9.4 9.4 0.00
shared sql area 235.9 240.0 1.75
shared trace buffer 16.5 16.5 0.00
buffer_cache 848.0 848.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: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: SAKAI/sakai Snaps: 3235-3236
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: SAKAI/sakai Snap: 3236
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: SAKAI/sakai Snaps: 3235-3236
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