/
awr-2007-10-08_06-00
awr-2007-10-08_06-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: 3252 08-Oct-07 06:00:58 1,037 34.9
End Snap: 3253 08-Oct-07 07:01:00 1,034 34.9
Elapsed: 60.02 (mins)
DB Time: 2.12 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 784M 784M Std Block Size: 8K
Shared Pool Size: 672M 672M Log Buffer: 15,148K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 1,021.75 2,666.48
Logical reads: 1,591.03 4,152.14
Block changes: 5.76 15.04
Physical reads: 6.74 17.59
Physical writes: 0.42 1.11
User calls: 39.95 104.27
Parses: 3.64 9.50
Hard parses: 0.03 0.07
Sorts: 1.74 4.53
Logons: 0.05 0.13
Executes: 15.95 41.61
Transactions: 0.38
% Blocks changed per Read: 0.36 Recursive Call %: 28.64
Rollback per transaction %: 0.29 Rows per Sort: 13.20
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.60 In-memory Sort %: 100.00
Library Hit %: 99.50 Soft Parse %: 99.30
Execute to Parse %: 77.18 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 6.67 % Non-Parse CPU: 98.15
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 80.93 81.13
% SQL with executions>1: 95.03 97.68
% Memory for SQL w/exec>1: 93.95 96.65
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 70 54.6
log file sync 1,300 35 27 27.7 Commit
log file parallel write 1,485 33 22 25.8 System I/O
control file parallel write 1,190 28 24 22.2 System I/O
db file sequential read 10,069 6 1 4.5 User I/O
-------------------------------------------------------------
Time Model Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total time in database user-calls (DB Time): 127.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
------------------------------------------ ------------------ ------------
sql execute elapsed time 113.1 88.7
DB CPU 69.6 54.6
parse time elapsed 25.0 19.6
hard parse elapsed time 24.0 18.8
failed parse elapsed time 23.7 18.6
PL/SQL execution elapsed time 11.7 9.2
connection management call elapsed time 0.3 .2
hard parse (sharing criteria) elapsed time 0.2 .2
repeated bind elapsed time 0.2 .2
hard parse (bind mismatch) elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
DB time 127.4 N/A
background elapsed time 78.8 N/A
background cpu time 9.2 N/A
-------------------------------------------------------------
Wait Class DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 6,705 .0 61 9 4.9
Commit 1,300 .2 35 27 0.9
User I/O 11,744 .0 8 1 8.5
Concurrency 65 1.5 6 85 0.0
Network 165,205 .0 1 0 119.7
Other 18 .0 0 1 0.0
Application 2 .0 0 0 0.0
-------------------------------------------------------------
Wait Events DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 1,300 .2 35 27 0.9
log file parallel write 1,485 .0 33 22 1.1
control file parallel write 1,190 .0 28 24 0.9
db file sequential read 10,069 .0 6 1 7.3
library cache load lock 6 16.7 4 630 0.0
os thread startup 43 .0 2 35 0.0
db file parallel read 119 .0 1 11 0.1
SQL*Net more data from clien 7,554 .0 1 0 5.5
db file scattered read 884 .0 1 1 0.6
SQL*Net message to client 135,985 .0 1 0 98.5
SQL*Net more data to client 20,525 .0 0 0 14.9
latch: library cache lock 7 .0 0 26 0.0
control file sequential read 4,030 .0 0 0 2.9
buffer busy waits 4 .0 0 6 0.0
latch free 4 .0 0 5 0.0
SQL*Net message to dblink 1,024 .0 0 0 0.7
direct path read 668 .0 0 0 0.5
latch: library cache 3 .0 0 1 0.0
SQL*Net more data from dblin 53 .0 0 0 0.0
SQL*Net more data to dblink 64 .0 0 0 0.0
latch: cache buffers chains 2 .0 0 1 0.0
enq: TX - row lock contentio 2 .0 0 0 0.0
LGWR wait for redo copy 8 .0 0 0 0.0
cursor: pin S 5 .0 0 0 0.0
direct path write 4 .0 0 0 0.0
latch: session allocation 1 .0 0 0 0.0
SQL*Net message from client 135,987 .0 3,391,092 24937 98.5
jobq slave wait 1,338 96.9 3,865 2889 1.0
Streams AQ: waiting for mess 720 100.0 3,515 4882 0.5
virtual circuit status 120 100.0 3,506 29219 0.1
Streams AQ: qmn slave idle w 128 .0 3,506 27391 0.1
Streams AQ: qmn coordinator 264 51.5 3,506 13280 0.2
Streams AQ: waiting for time 5 60.0 3,364 672722 0.0
SQL*Net message from dblink 1,024 .0 364 355 0.7
single-task message 52 .0 5 101 0.0
class slave wait 2 .0 0 0 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 1,484 .0 33 22 1.1
control file parallel write 1,190 .0 28 24 0.9
os thread startup 43 .0 2 35 0.0
db file scattered read 58 .0 0 1 0.0
control file sequential read 1,224 .0 0 0 0.9
events in waitclass Other 8 .0 0 0 0.0
rdbms ipc message 13,010 88.9 38,276 2942 9.4
pmon timer 1,205 100.0 3,512 2914 0.9
Streams AQ: qmn slave idle w 128 .0 3,506 27391 0.1
Streams AQ: qmn coordinator 264 51.5 3,506 13280 0.2
smon timer 40 2.5 3,484 87105 0.0
Streams AQ: waiting for time 5 60.0 3,364 672722 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
Statistic Total
-------------------------------- --------------------
BUSY_TIME 16,725
IDLE_TIME 703,568
IOWAIT_TIME 18,681
NICE_TIME 0
SYS_TIME 6,112
USER_TIME 10,314
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 36,536
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS 127.4 69.6 22,946 5,708,973
SYS$BACKGROUND 0.0 0.0 1,454 21,010
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: 3252-3253
-> 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
10990 740 21 399 0 0 165042 140
SYS$BACKGROUND
759 22 44 151 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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
---------- ---------- ------------ ---------- ------- -------------
35 35 297 0.1 27.4 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
7 7 63 0.1 5.6 fh44j45a5k7p5
Module: JDBC Thin Client
select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_USER_AGENT,SESS
ION_START,SESSION_END from SAKAI_SESSION where SESSION_START = SESSION_END ORDER
BY SESSION_SERVER ASC, SESSION_START ASC
6 0 6 1.0 4.9 fzjhhd21u7atw
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_ENROLLMENT"'); :my
date := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
4 0 4 1.1 3.3 354pj1kr4x9dy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"UCDSOM"."SOM_BANNER_ROSTER"'); :mydate :=
next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3 2 6 0.5 2.3 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 0 39 0.1 1.9 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
2 2 6 0.3 1.5 9m226fjr0b4tz
/* MV_REFRESH (DEL) */ DELETE FROM "SAKAI_EXTERNAL"."BANNER_INSTRUCTORS" SNA$ WH
ERE "SSBSECT_ROW" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROW
ID("MAS$"."M_ROW$$") RID$ FROM "SATURN"."MLOG$_SSBSECT"@BANNER.UCDAVIS.EDU "
MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
2 0 4 0.5 1.5 8ka9gtqdyzapq
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"UCDSOM"."SOM_BANNER_TERM"'); :mydate := ne
xt_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2 0 4 0.4 1.2 aqac2wg0x1gg5
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_LEVEL"'); :mydate
:= next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2 2 1,807 0.0 1.2 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
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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
---------- ---------- ------------ ----------- ------- -------------
35 35 297 0.12 27.4 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
7 7 63 0.11 5.6 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
2 3 6 0.34 2.3 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 2 6 0.30 1.5 9m226fjr0b4tz
/* MV_REFRESH (DEL) */ DELETE FROM "SAKAI_EXTERNAL"."BANNER_INSTRUCTORS" SNA$ WH
ERE "SSBSECT_ROW" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROW
ID("MAS$"."M_ROW$$") RID$ FROM "SATURN"."MLOG$_SSBSECT"@BANNER.UCDAVIS.EDU "
MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
2 2 1,807 0.00 1.2 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 1 1,109 0.00 0.8 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
1 1 1,015 0.00 0.7 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
1 1 981 0.00 0.7 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 1 747 0.00 0.7 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
1 1 29 0.02 0.5 22331rjyzgm79
Module: JDBC Thin Client
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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
---------- ---------- ------------ ----------- ------- -------------
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
0 6 6 0.06 4.9 fzjhhd21u7atw
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_ENROLLMENT"'); :my
date := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0 4 4 0.05 3.3 354pj1kr4x9dy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"UCDSOM"."SOM_BANNER_ROSTER"'); :mydate :=
next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0 2 39 0.00 1.9 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
0 2 4 0.03 1.5 8ka9gtqdyzapq
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"UCDSOM"."SOM_BANNER_TERM"'); :mydate := ne
xt_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0 2 4 0.03 1.2 aqac2wg0x1gg5
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_LEVEL"'); :mydate
:= next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 5,729,953
-> Captured SQL account for 93.2% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
3,912,678 297 13,174.0 68.3 34.74 34.88 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
829,836 63 13,172.0 14.5 7.09 7.09 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
79,545 6 13,257.5 1.4 2.02 2.88 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;
78,215 6 13,035.8 1.4 1.81 1.97 9m226fjr0b4tz
/* MV_REFRESH (DEL) */ DELETE FROM "SAKAI_EXTERNAL"."BANNER_INSTRUCTORS" SNA$ WH
ERE "SSBSECT_ROW" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROW
ID("MAS$"."M_ROW$$") RID$ FROM "SATURN"."MLOG$_SSBSECT"@BANNER.UCDAVIS.EDU "
MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
62,176 29 2,144.0 1.1 0.58 0.58 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
58,862 1,807 32.6 1.0 1.55 1.57 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
52,155 1,109 47.0 0.9 1.04 1.04 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
49,419 527 93.8 0.9 0.41 0.42 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
47,879 747 64.1 0.8 0.71 0.83 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
45,865 981 46.8 0.8 0.90 0.95 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 5,729,953
-> Captured SQL account for 93.2% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Disk Reads: 24,269
-> Captured SQL account for 68.0% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
10,646 6 1,774.3 43.9 1.81 1.97 9m226fjr0b4tz
/* MV_REFRESH (DEL) */ DELETE FROM "SAKAI_EXTERNAL"."BANNER_INSTRUCTORS" SNA$ WH
ERE "SSBSECT_ROW" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROW
ID("MAS$"."M_ROW$$") RID$ FROM "SATURN"."MLOG$_SSBSECT"@BANNER.UCDAVIS.EDU "
MAS$" WHERE "MAS$".SNAPTIME$$ > :1 )MAS$)
10,646 6 1,774.3 43.9 2.02 2.88 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,230 862 2.6 9.2 0.39 0.57 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_.
2,137 39 54.8 8.8 0.18 2.44 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
755 747 1.0 3.1 0.71 0.83 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
262 39 6.7 1.1 0.08 0.43 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
113 981 0.1 0.5 0.90 0.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_
79 93 0.8 0.3 0.04 0.04 gdp2h8cjfxgjw
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_.
74 6 12.3 0.3 0.35 6.28 fzjhhd21u7atw
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_ENROLLMENT"'); :my
date := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
65 407 0.2 0.3 0.39 0.41 0jf0d1wyx5vkb
Module: JDBC Thin Client
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Disk Reads: 24,269
-> Captured SQL account for 68.0% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
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 Executions DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Executions: 57,427
-> Captured SQL account for 41.1% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
6,000 6,000 1.0 0.00 0.00 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
3,599 3,338 0.9 0.00 0.00 4k1cbhzyvvzsh
Module: JDBC Thin Client
select /*+ FIRST_ROWS */ EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EV
ENT_CODE,SESSION_SERVER from SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSIO
N_ID = SAKAI_SESSION.SESSION_ID(+)) and (EVENT_ID > :1)
1,807 1,807 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
1,567 1,564 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
1,109 1,109 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
1,015 1,015 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
981 981 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_
862 862 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_.
747 747 1.0 0.00 0.00 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
681 681 1.0 0.00 0.00 b9m69qfu4hs2m
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Executions: 57,427
-> Captured SQL account for 41.1% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
Module: JDBC Thin Client
SELECT MIN(NEXT_FIRE_TIME) AS ALIAS_NXT_FR_TM FROM QRTZ_TRIGGERS WHERE TRIGGER_S
TATE = :1 AND NEXT_FIRE_TIME >= 0
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Parse Calls: 13,107
-> Captured SQL account for 66.1% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
6,000 6,000 45.78 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
239 239 1.82 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
190 190 1.45 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
190 190 1.45 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
156 156 1.19 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=:
140 140 1.07 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
136 136 1.04 459f3z9u4fb3u
select value$ from props$ where name = 'GLOBAL_DB_NAME'
84 84 0.64 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')
84 84 0.64 5ur69atw3vfhj
select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE
', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT',
4, 1), failover_retries, failover_delay, flags from service$ where name = :1
74 74 0.56 3m8smr0v7v1m6
INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p
1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
17,125,892 N/A 2.43 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'
2,688,769 28 0.38 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,391,364 2 0.34 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,517,489 981 0.22 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
488 981 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_
337 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 407 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 2 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 )
100 28 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 =
36 1,807 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
36 1,109 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
-------------------------------------------------------------
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 7,084 2.0 5.1
CPU used when call started 6,441 1.8 4.7
CR blocks created 17 0.0 0.0
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 0 0.0 0.0
DB time 807,056 224.1 584.8
DBWR checkpoint buffers written 1,381 0.4 1.0
DBWR checkpoints 0 0.0 0.0
DBWR object drop buffers written 0 0.0 0.0
DBWR revisited being-written buf 0 0.0 0.0
DBWR tablespace checkpoint buffe 0 0.0 0.0
DBWR thread checkpoint buffers w 1,381 0.4 1.0
DBWR transaction table writes 31 0.0 0.0
DBWR undo block writes 247 0.1 0.2
IMU CR rollbacks 3 0.0 0.0
IMU Flushes 898 0.3 0.7
IMU Redo allocation size 280,904 78.0 203.6
IMU commits 1,200 0.3 0.9
IMU contention 2 0.0 0.0
IMU ktichg flush 22 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 2 0.0 0.0
IMU undo allocation size 2,428,360 674.3 1,759.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 135,854 37.7 98.4
SQL*Net roundtrips to/from dblin 1,024 0.3 0.7
active txn count during cleanout 45 0.0 0.0
application wait time 0 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 11,577 3.2 8.4
branch node splits 0 0.0 0.0
buffer is not pinned count 415,040 115.2 300.8
buffer is pinned count 572,633 159.0 415.0
bytes received via SQL*Net from 47,044,096 13,062.7 34,089.9
bytes received via SQL*Net from 321,922 89.4 233.3
bytes sent via SQL*Net to client 89,466,681 24,842.1 64,830.9
bytes sent via SQL*Net to dblink 438,239 121.7 317.6
calls to get snapshot scn: kcmgs 125,100 34.7 90.7
calls to kcmgas 2,448 0.7 1.8
calls to kcmgcs 115 0.0 0.1
change write time 23 0.0 0.0
cleanout - number of ktugct call 84 0.0 0.1
cleanouts and rollbacks - consis 8 0.0 0.0
cleanouts only - consistent read 29 0.0 0.0
cluster key scan block gets 6,028 1.7 4.4
cluster key scans 388 0.1 0.3
commit batch performed 52 0.0 0.0
commit batch requested 52 0.0 0.0
commit batch/immediate performed 53 0.0 0.0
commit batch/immediate requested 53 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 8 0.0 0.0
commit cleanout failures: cannot 1 0.0 0.0
commit cleanouts 4,246 1.2 3.1
commit cleanouts successfully co 4,215 1.2 3.1
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed 1 0.0 0.0
commit immediate requested 1 0.0 0.0
commit txn count during cleanout 200 0.1 0.1
concurrency wait time 551 0.2 0.4
consistent changes 409 0.1 0.3
consistent gets 5,705,033 1,584.1 4,134.1
consistent gets - examination 302,647 84.0 219.3
consistent gets direct 679 0.2 0.5
consistent gets from cache 5,704,354 1,583.9 4,133.6
current blocks converted for CR 0 0.0 0.0
cursor authentications 72 0.0 0.1
data blocks consistent reads - u 23 0.0 0.0
db block changes 20,758 5.8 15.0
db block gets 24,920 6.9 18.1
db block gets direct 4 0.0 0.0
db block gets from cache 24,916 6.9 18.1
deferred (CURRENT) block cleanou 1,724 0.5 1.3
dirty buffers inspected 132 0.0 0.1
enqueue conversions 1,446 0.4 1.1
enqueue releases 49,002 13.6 35.5
enqueue requests 49,030 13.6 35.5
enqueue timeouts 30 0.0 0.0
enqueue waits 2 0.0 0.0
execute count 57,427 16.0 41.6
failed probes on index block rec 0 0.0 0.0
frame signature mismatch 0 0.0 0.0
free buffer inspected 38,180 10.6 27.7
free buffer requested 24,128 6.7 17.5
heap block compress 65 0.0 0.1
hot buffers moved to head of LRU 23,990 6.7 17.4
immediate (CR) block cleanout ap 37 0.0 0.0
immediate (CURRENT) block cleano 521 0.1 0.4
index crx upgrade (found) 0 0.0 0.0
index crx upgrade (positioned) 28,798 8.0 20.9
index fast full scans (full) 0 0.0 0.0
index fetch by key 112,332 31.2 81.4
index scans kdiixs1 228,663 63.5 165.7
leaf node 90-10 splits 10 0.0 0.0
leaf node splits 18 0.0 0.0
lob reads 685 0.2 0.5
lob writes 109 0.0 0.1
lob writes unaligned 107 0.0 0.1
logons cumulative 178 0.1 0.1
messages received 1,657 0.5 1.2
messages sent 1,657 0.5 1.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 5,359,466 1,488.2 3,883.7
opened cursors cumulative 13,162 3.7 9.5
parse count (failures) 64 0.0 0.1
parse count (hard) 92 0.0 0.1
parse count (total) 13,107 3.6 9.5
parse time cpu 129 0.0 0.1
parse time elapsed 1,935 0.5 1.4
physical read IO requests 12,284 3.4 8.9
physical read bytes 198,811,648 55,203.7 144,066.4
physical read total IO requests 16,377 4.6 11.9
physical read total bytes 265,355,264 73,680.8 192,286.4
physical read total multi block 891 0.3 0.7
physical reads 24,269 6.7 17.6
physical reads cache 23,592 6.6 17.1
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache prefetch 12,702 3.5 9.2
physical reads direct 677 0.2 0.5
physical reads direct (lob) 675 0.2 0.5
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 1,057 0.3 0.8
physical write bytes 12,500,992 3,471.1 9,058.7
physical write total IO requests 7,596 2.1 5.5
physical write total bytes 79,554,560 22,089.8 57,648.2
physical write total multi block 2,856 0.8 2.1
physical writes 1,526 0.4 1.1
physical writes direct 4 0.0 0.0
physical writes direct (lob) 4 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 1,522 0.4 1.1
physical writes non checkpoint 1,201 0.3 0.9
pinned buffers inspected 0 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 664 0.2 0.5
process last non-idle time 0 0.0 0.0
recovery blocks read 0 0.0 0.0
recursive calls 57,763 16.0 41.9
recursive cpu usage 700 0.2 0.5
redo blocks read for recovery 0 0.0 0.0
redo blocks written 8,362 2.3 6.1
redo buffer allocation retries 0 0.0 0.0
redo entries 7,136 2.0 5.2
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 3,679,740 1,021.8 2,666.5
redo synch time 3,613 1.0 2.6
redo synch writes 14,106 3.9 10.2
redo wastage 448,280 124.5 324.8
redo write time 3,381 0.9 2.5
redo writer latching time 0 0.0 0.0
redo writes 1,484 0.4 1.1
rollback changes - undo records 12 0.0 0.0
rollbacks only - consistent read 9 0.0 0.0
rows fetched via callback 94,271 26.2 68.3
session connect time 0 0.0 0.0
session cursor cache hits 7,282 2.0 5.3
session logical reads 5,729,953 1,591.0 4,152.1
session pga memory 61,749,304 17,145.8 44,745.9
session pga memory max 65,550,392 18,201.3 47,500.3
session uga memory 231,929,289,188 64,399,454.2 #############
session uga memory max 79,699,164 22,130.0 57,753.0
shared hash latch upgrades - no 31,237 8.7 22.6
shared hash latch upgrades - wai 0 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 6,254 1.7 4.5
sorts (rows) 82,533 22.9 59.8
sql area evicted 0 0.0 0.0
sql area purged 64 0.0 0.1
summed dirty queue length 132 0.0 0.1
switch current to new buffer 199 0.1 0.1
table fetch by rowid 336,581 93.5 243.9
table fetch continued row 1,031 0.3 0.8
table scan blocks gotten 5,063,759 1,406.1 3,669.4
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
table scan rows gotten 185,691,764 51,560.8 134,559.3
table scans (long tables) 11 0.0 0.0
table scans (short tables) 4,149 1.2 3.0
total number of times SMON poste 39 0.0 0.0
transaction rollbacks 53 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 1,262,148 350.5 914.6
user I/O wait time 761 0.2 0.6
user calls 143,894 40.0 104.3
user commits 1,376 0.4 1.0
user rollbacks 4 0.0 0.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 4,194 1.2 3.0
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: 3252-32
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 342,604 345,636
opened cursors current 36,144 36,111
workarea memory allocated 1,009 1,009
logons current 1,037 1,034
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai Snaps: 3252-325
-> 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: 3252-3253
-> 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
11,648 3 0.6 2.0 679 0 0 0.0
SYSAUX
686 0 0.1 1.1 240 0 0 0.0
SYSTEM
94 0 1.2 7.9 65 0 4 5.0
UNDOTBS1
3 0 3.3 1.0 73 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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
10,964 3 0.6 2.0 503 0 0 0.0
DATA_TS /local/d02/oracle/sakai/data02.dbf
684 0 1.1 2.2 176 0 0 0.0
SYSAUX /local/d02/oracle/sakai/sysaux01.dbf
686 0 0.1 1.1 240 0 0 0.0
SYSTEM /local/d02/oracle/sakai/system01.dbf
94 0 1.2 7.9 65 0 4 5.0
UNDOTBS1 /local/d02/oracle/sakai/undotbs01.dbf
3 0 3.3 1.0 73 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 96,585 100 5,728,878 23,652 1,522 0 0 4
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 518 3834 3349 737280 3349 N/A
E 0 0 687 3614 3427 737280 3427 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: SAKAI/sakai Snap: 3253
-> 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 578,775,790
D 128 .2 15,992 1.4 506,537,678
D 192 .2 23,988 1.2 453,663,300
D 256 .3 31,984 1.1 421,319,657
D 320 .4 39,980 1.1 399,018,580
D 384 .5 47,976 1.0 385,777,623
D 448 .6 55,972 1.0 377,935,143
D 512 .7 63,968 1.0 374,078,914
D 576 .7 71,964 1.0 372,690,115
D 640 .8 79,960 1.0 372,131,147
D 704 .9 87,956 1.0 371,941,086
D 768 1.0 95,952 1.0 371,806,876
D 784 1.0 97,951 1.0 371,778,529
D 832 1.1 103,948 1.0 371,711,598
D 896 1.1 111,944 1.0 371,640,787
D 960 1.2 119,940 1.0 371,587,295
D 1,024 1.3 127,936 1.0 371,544,302
D 1,088 1.4 135,932 1.0 371,506,295
D 1,152 1.5 143,928 1.0 371,473,708
D 1,216 1.6 151,924 1.0 371,435,934
D 1,280 1.6 159,920 1.0 371,409,206
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 141 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 163 942.3 1.0 .1 100.0 .0 102,400
E 800 169 931.7 1.0 .1 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 3,976 3,976 0 0
64K 128K 47 47 0 0
128K 256K 7 7 0 0
512K 1024K 156 156 0 0
1M 2M 8 8 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: SAKAI/sakai Snap: 3253
-> 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 377,213.2 42,583.8 90.0 1,909
200 0.3 377,213.2 42,545.8 90.0 1,909
400 0.5 377,213.2 39,409.1 91.0 1,800
600 0.8 377,213.2 24,338.8 94.0 734
800 1.0 377,213.2 2,507.6 99.0 0
960 1.2 377,213.2 2,443.8 99.0 0
1,120 1.4 377,213.2 2,443.8 99.0 0
1,280 1.6 377,213.2 2,443.8 99.0 0
1,440 1.8 377,213.2 2,443.8 99.0 0
1,600 2.0 377,213.2 2,443.8 99.0 0
2,400 3.0 377,213.2 2,443.8 99.0 0
3,200 4.0 377,213.2 2,443.8 99.0 0
4,800 6.0 377,213.2 2,443.8 99.0 0
6,400 8.0 377,213.2 2,443.8 99.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: SAKAI/sakai Snap: 3253
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
272 .4 83 7,861 ####### 1.0 ####### 49.9 22,257,386
352 .5 159 9,725 ####### 1.0 ####### 29.9 22,283,104
432 .6 238 12,848 ####### 1.0 69,950 18.0 22,300,030
512 .8 317 18,784 ####### 1.0 41,088 10.6 22,310,306
592 .9 394 22,045 ####### 1.0 20,313 5.2 22,316,589
672 1.0 473 26,012 ####### 1.0 3,876 1.0 22,320,244
752 1.1 552 31,499 ####### 1.0 1 .0 22,322,577
832 1.2 631 35,516 ####### 1.0 1 .0 22,324,556
912 1.4 710 39,294 ####### 1.0 1 .0 22,326,348
992 1.5 721 40,379 ####### 1.0 1 .0 22,327,930
1,072 1.6 721 40,379 ####### 1.0 1 .0 22,329,387
1,152 1.7 769 43,898 ####### 1.0 1 .0 22,330,836
1,232 1.8 769 43,898 ####### 1.0 1 .0 22,332,264
1,312 2.0 848 47,521 ####### 1.0 1 .0 22,333,689
1,392 2.1 921 50,862 ####### 1.0 1 .0 22,335,112
-------------------------------------------------------------
SGA Target Advisory DB/Inst: SAKAI/sakai Snap: 3253
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
752 0.5 311,496 453,458,249
1,128 0.8 251,285 385,608,671
1,504 1.0 242,787 371,778,510
1,880 1.3 242,641 371,332,376
2,256 1.5 242,617 371,258,020
2,632 1.8 242,617 371,258,020
3,008 2.0 242,617 371,258,020
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: SAKAI/sakai Snap: 3253
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: SAKAI/sakai Snap: 3253
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,876 1.0 76
32 2.0 2 76 1 1.0 3,876 1.0 76
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 4 0 5
-------------------------------------------------------------
Enqueue Activity DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 5.00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 .3 2,349 0 9 5760/5760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Most recent 35 Undostat rows, ordered by Time desc
Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
08-Oct 07:10 67 443 0 8 5,760 0/0 0/0/0/0/0/0
08-Oct 07:00 14 217 0 2 5,760 0/0 0/0/0/0/0/0
08-Oct 06:50 37 410 0 4 5,760 0/0 0/0/0/0/0/0
08-Oct 06:40 28 280 0 8 5,760 0/0 0/0/0/0/0/0
08-Oct 06:30 11 233 0 3 5,760 0/0 0/0/0/0/0/0
08-Oct 06:20 44 423 0 6 5,760 0/0 0/0/0/0/0/0
08-Oct 06:10 79 343 0 9 5,760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> "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,380 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 80,040 0.0 N/A 0 0 N/A
Consistent RBA 1,484 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 217 0.0 N/A 0 0 N/A
In memory undo latch 14,005 0.0 N/A 0 3,639 0.0
JS mem alloc latch 6 0.0 N/A 0 0 N/A
JS queue access latch 6 0.0 N/A 0 0 N/A
JS queue state obj latch 25,990 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 9 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 633 0.0 N/A 0 0 N/A
OS process allocation 1,620 0.0 N/A 0 0 N/A
OS process: request allo 248 0.0 N/A 0 0 N/A
PL/SQL warning settings 728 0.0 N/A 0 0 N/A
SGA IO buffer pool latch 1 0.0 N/A 0 1 0.0
SQL memory manager latch 1 0.0 N/A 0 1,190 0.0
SQL memory manager worka 134,291 0.0 N/A 0 0 N/A
Shared B-Tree 140 0.0 N/A 0 0 N/A
active checkpoint queue 1,360 0.0 N/A 0 0 N/A
active service list 9,083 0.0 N/A 0 1,205 0.0
archive control 370 0.0 N/A 0 0 N/A
archive process latch 1,262 0.0 N/A 0 0 N/A
begin backup scn array 4 0.0 N/A 0 0 N/A
cache buffer handles 30,578 0.0 N/A 0 0 N/A
cache buffers chains 11,242,633 0.0 0.1 0 38,385 0.0
cache buffers lru chain 27,736 0.0 N/A 0 15,256 0.0
cache table scan latch 0 N/A N/A 0 884 0.0
channel handle pool latc 296 0.0 N/A 0 0 N/A
channel operations paren 17,536 0.0 N/A 0 0 N/A
checkpoint queue latch 23,481 0.0 N/A 0 1,342 0.0
client/application info 80 0.0 N/A 0 0 N/A
commit callback allocati 128 0.0 N/A 0 0 N/A
compile environment latc 13,690 0.0 N/A 0 0 N/A
constraint object alloca 104 0.0 N/A 0 0 N/A
dml lock allocation 17,591 0.0 N/A 0 0 N/A
dummy allocation 359 0.0 N/A 0 0 N/A
enqueue hash chains 99,470 0.0 0.0 0 28 0.0
enqueues 90,002 0.0 N/A 0 0 N/A
event group latch 123 0.0 N/A 0 0 N/A
file cache latch 162 0.0 N/A 0 0 N/A
global KZLD latch for me 81 0.0 N/A 0 0 N/A
global tx hash mapping 1,412 0.0 N/A 0 0 N/A
hash table column usage 54 0.0 N/A 0 2,858 0.0
hash table modification 101 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 130 0.0 N/A 0 0 N/A
ksuosstats global area 242 0.0 N/A 0 0 N/A
ktm global data 40 0.0 N/A 0 0 N/A
kwqbsn:qsga 140 0.0 N/A 0 0 N/A
lgwr LWN SCN 2,085 0.0 0.0 0 0 N/A
library cache 64,942 0.1 0.0 0 0 N/A
library cache load lock 164 0.0 N/A 0 5 0.0
library cache lock 39,292 0.1 0.1 0 0 N/A
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> "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,475 0.1 0.0 0 0 N/A
library cache pin 17,654 0.0 0.0 0 0 N/A
library cache pin alloca 512 0.4 1.0 0 0 N/A
list of block allocation 283 0.0 N/A 0 0 N/A
loader state object free 1,010 0.0 N/A 0 0 N/A
message pool operations 94 0.0 N/A 0 0 N/A
messages 28,166 0.0 N/A 0 0 N/A
mostly latch-free SCN 2,084 0.0 N/A 0 0 N/A
multiblock read objects 2,082 0.0 N/A 0 0 N/A
ncodef allocation latch 57 0.0 N/A 0 0 N/A
object queue header heap 1,544 0.0 N/A 0 35 0.0
object queue header oper 55,163 0.0 N/A 0 0 N/A
object stats modificatio 74 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 3,252 0.0 N/A 0 1,293 0.0
process allocation 248 0.0 N/A 0 123 0.0
process group creation 248 0.0 N/A 0 0 N/A
qmn task queue latch 512 0.0 N/A 0 0 N/A
redo allocation 17,974 0.0 0.0 0 0 N/A
redo copy 0 N/A N/A 0 7,122 0.2
redo writing 8,205 0.0 N/A 0 0 N/A
row cache objects 227,715 0.0 0.0 0 0 N/A
sequence cache 2,700 0.0 N/A 0 0 N/A
session allocation 33,185 0.0 0.3 0 0 N/A
session idle bit 301,257 0.0 0.0 0 0 N/A
session state list latch 447 0.0 N/A 0 0 N/A
session switching 57 0.0 N/A 0 0 N/A
session timer 1,205 0.0 N/A 0 0 N/A
shared pool 11,811 0.0 0.0 0 0 N/A
shared pool simulator 2,008 0.0 N/A 0 0 N/A
simulator hash latch 352,805 0.0 N/A 0 0 N/A
simulator lru latch 346,806 0.1 0.0 0 1,499 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 393 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 3 0.0 N/A 0 0 N/A
temporary table state ob 21 0.0 N/A 0 0 N/A
threshold alerts latch 329 0.0 N/A 0 0 N/A
transaction allocation 250 0.0 N/A 0 0 N/A
transaction branch alloc 265 0.0 N/A 0 0 N/A
undo global data 13,875 0.0 N/A 0 0 N/A
user lock 434 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
simulator lru latch
346,806 457 1 456 0 0 0
library cache
64,942 70 3 67 0 0 0
library cache lock
39,292 48 7 41 0 0 0
cache buffers chains
11,242,633 29 2 27 0 0 0
session allocation
33,185 3 1 2 0 0 0
library cache pin allocation
512 2 2 0 0 0 0
slave class create
8 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains kcbchg: kslbegin: bufs not 0 1 0
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kcbrls: kslbegin 0 1 2
library cache kglpndl: child: after proc 0 2 0
library cache lock kgllkal: child: multiinsta 0 7 7
library cache lock kgllkdl: child: no lock ha 0 1 0
library cache pin alloca kglpnget 0 2 2
session allocation ksuxds: KSUSFCLC not set 0 1 0
simulator lru latch kcbs_simulate: simulate se 0 1 1
slave class create ksvcreate 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Logical Reads: 5,729,953
-> Captured Segments account for 97.7% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SAKAI_SESSION TABLE 4,742,240 82.76
SAKAI DATA_TS SYS_C004181 INDEX 88,480 1.54
SAKAI DATA_TS AK_SAKAI_REALM_ID INDEX 78,832 1.38
SAKAI_EXTE DATA_TS BANNER_INSTRUCTORS TABLE 78,112 1.36
SAKAI_EXTE DATA_TS BANNER_OFFERING_COUR TABLE 62,016 1.08
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> Total Physical Reads: 24,269
-> Captured Segments account for 62.8% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI_EXTE DATA_TS BANNER_INSTRUCTORS TABLE 10,576 43.58
SAKAI_EXTE DATA_TS CM_ENROLL_TB_ES_IDX INDEX 1,107 4.56
SAKAI DATA_TS MFR_UNREAD_STATUS_T TABLE 755 3.11
SAKAI DATA_TS CONTENT_RESOURCE TABLE 318 1.31
SAKAI DATA_TS SYS_C004181 INDEX 276 1.14
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> % 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
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 4 44.44
SAKAI DATA_TS IE_SAKAI_SITE_FLAGS INDEX 2 22.22
SAKAI DATA_TS SYS_C004168 INDEX 2 22.22
SAKAI DATA_TS SYS_C004290 INDEX 1 11.11
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> % 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 3 75.00
SYS SYSTEM SUM$ TABLE 1 25.00
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> "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 544 0.0 0 N/A 0 6
dc_global_oids 8 0.0 0 N/A 0 151
dc_histogram_data 409 0.0 0 N/A 0 9,605
dc_histogram_defs 455 0.0 0 N/A 0 6,363
dc_object_ids 1,421 0.0 0 N/A 0 2,520
dc_objects 884 0.0 0 N/A 5 3,125
dc_profiles 137 0.0 0 N/A 0 1
dc_rollback_segments 14,359 0.0 0 N/A 0 392
dc_segments 337 0.0 0 N/A 2 2,456
dc_sequences 45 0.0 0 N/A 45 53
dc_tablespaces 27,823 0.0 0 N/A 0 9
dc_usernames 502 0.0 0 N/A 0 34
dc_users 31,416 0.0 0 N/A 0 86
global database name 104 0.0 0 N/A 0 1
outstanding_alerts 128 0.0 0 N/A 0 17
-------------------------------------------------------------
Library Cache Activity DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,266 0.0 1,379 0.0 0 0
INDEX 3 0.0 12 0.0 0 0
SQL AREA 23 13.0 60,686 0.4 82 0
TABLE/PROCEDURE 200 0.0 3,470 2.4 0 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 754.3 N/A .7 2.3 63 63 1,038 1,038
Freeable 117.8 .0 .5 .3 1 N/A 252 252
SQL 68.7 21.0 .1 .1 1 106 1,027 1,021
PL/SQL 2.4 .3 .0 .0 0 0 1,036 1,036
E Other 745.2 N/A .7 2.3 63 63 1,036 1,036
Freeable 116.4 .0 .5 .3 1 N/A 251 251
SQL 68.8 21.1 .1 .1 1 106 1,025 1,019
PL/SQL 2.2 .3 .0 .0 0 0 1,034 1,034
-------------------------------------------------------------
SGA Memory Summary DB/Inst: SAKAI/sakai Snaps: 3252-3253
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 822,083,584
Fixed Size 1,262,764
Redo Buffers 15,511,552
Variable Size 1,258,294,100
-------------------
sum 2,097,152,000
-------------------------------------------------------------
SGA breakdown difference DB/Inst: SAKAI/sakai Snaps: 3252-3253
-> 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 46.1 46.2 0.16
shared Heap0: KGL 10.3 10.3 0.04
shared KGH: NO ACCESS 69.3 69.3 0.00
shared KGLS heap 10.5 10.5 0.00
shared KTI-UNDO 14.7 14.7 0.00
shared PCursor 18.5 18.5 0.01
shared PL/SQL MPCODE 7.8 7.8 0.00
shared event statistics per sess 15.7 15.7 0.00
shared free memory 128.1 126.8 -1.03
shared library cache 31.0 31.0 0.01
shared private strands 14.2 14.2 0.00
shared sessions 9.4 9.4 0.00
shared sql area 247.5 248.7 0.51
shared trace buffer 16.5 16.5 0.00
buffer_cache 784.0 784.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: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: SAKAI/sakai Snaps: 3252-3253
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: SAKAI/sakai Snap: 3253
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: SAKAI/sakai Snaps: 3252-3253
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