awr-2007-10-08_04-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: 3250 08-Oct-07 04:00:55 1,043 34.7
End Snap: 3251 08-Oct-07 05:00:57 1,039 34.9
Elapsed: 60.03 (mins)
DB Time: 9.34 (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: 996.40 2,737.32
Logical reads: 3,037.58 8,344.88
Block changes: 5.80 15.93
Physical reads: 150.73 414.08
Physical writes: 0.33 0.92
User calls: 867.33 2,382.74
Parses: 19.03 52.29
Hard parses: 0.04 0.10
Sorts: 3.87 10.62
Logons: 0.05 0.15
Executes: 26.81 73.65
Transactions: 0.36
% Blocks changed per Read: 0.19 Recursive Call %: 1.82
Rollback per transaction %: 0.00 Rows per Sort: 12.08
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.18 In-memory Sort %: 100.00
Library Hit %: 99.87 Soft Parse %: 99.81
Execute to Parse %: 29.00 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 12.20 % Non-Parse CPU: 99.30
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 85.21 85.46
% SQL with executions>1: 97.38 91.28
% Memory for SQL w/exec>1: 96.70 95.35
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
RMAN backup & recovery I/O 73,280 2,529 35 451.5 System I/O
CPU time 258 46.1
SQL*Net more data to client 2,425,897 108 0 19.2 Network
db file parallel read 967 48 49 8.5 User I/O
control file parallel write 1,381 38 27 6.7 System I/O
-------------------------------------------------------------
Time Model Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total time in database user-calls (DB Time): 560.2s
-> 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 277.5 49.5
DB CPU 258.3 46.1
RMAN cpu time (backup/restore) 87.5 15.6
parse time elapsed 14.5 2.6
PL/SQL execution elapsed time 13.6 2.4
hard parse elapsed time 12.6 2.3
failed parse elapsed time 11.9 2.1
hard parse (sharing criteria) elapsed time 0.7 .1
connection management call elapsed time 0.3 .1
Java execution elapsed time 0.3 .0
repeated bind elapsed time 0.1 .0
inbound PL/SQL rpc elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
PL/SQL compilation elapsed time 0.0 .0
DB time 560.2 N/A
background elapsed time 2,652.9 N/A
background cpu time 96.9 N/A
-------------------------------------------------------------
Wait Class DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 84,961 .0 2,600 31 64.8
Network 6,224,191 .0 130 0 4,747.7
User I/O 268,992 .0 98 0 205.2
Commit 1,227 .2 33 27 0.9
Concurrency 96 .0 4 44 0.1
Administrative 3 .0 0 96 0.0
Other 22 .0 0 3 0.0
Application 2 .0 0 6 0.0
-------------------------------------------------------------
Wait Events DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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
---------------------------- -------------- ------ ----------- ------- ---------
RMAN backup & recovery I/O 73,280 .0 2,529 35 55.9
SQL*Net more data to client 2,425,897 .0 108 0 1,850.4
db file parallel read 967 .0 48 49 0.7
control file parallel write 1,381 .0 38 27 1.1
log file sync 1,227 .2 33 27 0.9
db file sequential read 24,626 .0 32 1 18.8
log file parallel write 1,351 .0 32 24 1.0
db file scattered read 19,424 .0 17 1 14.8
SQL*Net message to client 3,159,892 .0 12 0 2,410.3
SQL*Net more data from clien 637,418 .0 11 0 486.2
os thread startup 44 .0 3 57 0.0
library cache load lock 6 .0 1 202 0.0
direct path read 223,973 .0 1 0 170.8
control file sequential read 8,719 .0 0 0 6.7
log file sequential read 104 .0 0 4 0.1
buffer busy waits 27 .0 0 12 0.0
Log archive I/O 102 .0 0 3 0.1
switch logfile command 3 .0 0 96 0.0
latch: library cache lock 3 .0 0 29 0.0
control file single write 20 .0 0 3 0.0
log file single write 4 .0 0 9 0.0
latch free 8 .0 0 4 0.0
latch: In memory undo latch 6 .0 0 4 0.0
latch: cache buffers chains 2 .0 0 10 0.0
enq: CF - contention 1 .0 0 20 0.0
SQL*Net break/reset to clien 2 .0 0 6 0.0
latch: shared pool 2 .0 0 5 0.0
SQL*Net message to dblink 880 .0 0 0 0.7
latch: enqueue hash chains 1 .0 0 4 0.0
latch: session allocation 3 .0 0 1 0.0
latch: library cache 6 .0 0 1 0.0
SQL*Net more data from dblin 52 .0 0 0 0.0
SQL*Net more data to dblink 52 .0 0 0 0.0
LGWR wait for redo copy 5 .0 0 0 0.0
latch: cache buffers lru cha 4 .0 0 0 0.0
direct path write 2 .0 0 0 0.0
SQL*Net message from client 3,159,896 .0 3,023,169 957 2,410.3
Streams AQ: waiting for time 17 47.1 4,812 283042 0.0
jobq slave wait 1,419 96.8 4,103 2892 1.1
virtual circuit status 121 100.0 3,524 29127 0.1
Streams AQ: waiting for mess 722 99.7 3,517 4871 0.6
Streams AQ: qmn slave idle w 128 .0 3,495 27306 0.1
Streams AQ: qmn coordinator 263 51.3 3,495 13289 0.2
SQL*Net message from dblink 880 .0 110 125 0.7
single-task message 52 .0 6 112 0.0
class slave wait 1 100.0 5 4884 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> ordered by wait time desc, waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
control file parallel write 1,198 .0 35 29 0.9
log file parallel write 1,352 .0 32 24 1.0
os thread startup 44 .0 3 57 0.0
control file sequential read 1,286 .0 0 0 1.0
log file single write 4 .0 0 9 0.0
events in waitclass Other 6 .0 0 3 0.0
log file sequential read 8 .0 0 1 0.0
db file sequential read 94 .0 0 0 0.1
direct path write 2 .0 0 0 0.0
rdbms ipc message 12,915 89.6 38,001 2942 9.9
Streams AQ: waiting for time 17 47.1 4,812 283042 0.0
pmon timer 1,206 100.0 3,514 2914 0.9
Streams AQ: qmn slave idle w 128 .0 3,495 27306 0.1
Streams AQ: qmn coordinator 263 51.3 3,495 13289 0.2
smon timer 40 12.5 3,385 84635 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
Statistic Total
-------------------------------- --------------------
BUSY_TIME 104,010
IDLE_TIME 616,375
IOWAIT_TIME 251,620
NICE_TIME 0
SYS_TIME 37,127
USER_TIME 64,873
LOAD 3
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 22,176
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS 560.1 258.3 542,530 ##########
SYS$BACKGROUND 0.0 0.0 159 17,990
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: 3250-3251
-> 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
268813 9773 52 169 3 29 6223948 13009
SYS$BACKGROUND
174 2 44 252 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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
---------- ---------- ------------ ---------- ------- -------------
60 1 0 N/A 10.7 4tvrqgtyc06v3
Module: SQL*Plus
INSERT INTO coursemanagement_enrollment_tb SELECT * FROM coursemanagement_enroll
ment_v
37 36 300 0.1 6.6 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
15 1 1 14.9 2.7 2c7swcc7hzvyj
select students_pkey, students_term_code, students_clientid, students_major_code
_1, students_degree_code_1, students_coll_code_1, students_level_code_1, student
s_major_code_2, students_degree_code_2, students_coll_code_2, students_level_cod
e_2, students_class_level, a.person_pkey, person_clientid, person_last_name, per
13 7 1 13.1 2.3 5t7sakctnju7u
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "UCDSOM"."SOM_BANNER_ROSTER".* FROM "UCDSOM".
"SOM_BANNER_ROSTER"
11 10 1 10.6 1.9 fcu3ck0gc56jr
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_EVENT".* FROM "SAKAI"."SAKAI_E
VENT"
8 8 238 0.0 1.5 0ruc21jdus88a
SELECT roster_pkey, roster_pidm, roster_level_code, roster_enroll_status, roster
_grade_mode, roster_unit from courses_roster where roster_term_code = :1 and ros
ter_crn = :2
7 7 60 0.1 1.3 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 1 1 6.3 1.1 2ap4yjn3wwyq2
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_REALM_RL_FN".* FROM "SAKAI"."S
AKAI_REALM_RL_FN"
6 6 344 0.0 1.1 bnxaabvumwxjw
Module: exp@caje (TNS V1-V3)
SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME,
IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = :1 AND TYP
E IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
5 5 1 5.5 1.0 24xrfkghy1put
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE".* FROM "SAKAI"."CO
NTENT_RESOURCE"
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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
---------- ---------- ------------ ----------- ------- -------------
36 37 300 0.12 6.6 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
10 11 1 10.02 1.9 fcu3ck0gc56jr
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_EVENT".* FROM "SAKAI"."SAKAI_E
VENT"
8 8 238 0.03 1.5 0ruc21jdus88a
SELECT roster_pkey, roster_pidm, roster_level_code, roster_enroll_status, roster
_grade_mode, roster_unit from courses_roster where roster_term_code = :1 and ros
ter_crn = :2
7 7 60 0.12 1.3 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
7 13 1 6.57 2.3 5t7sakctnju7u
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "UCDSOM"."SOM_BANNER_ROSTER".* FROM "UCDSOM".
"SOM_BANNER_ROSTER"
6 6 344 0.02 1.1 bnxaabvumwxjw
Module: exp@caje (TNS V1-V3)
SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME,
IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = :1 AND TYP
E IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
5 5 1 4.82 1.0 24xrfkghy1put
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE".* FROM "SAKAI"."CO
NTENT_RESOURCE"
4 4 1 4.43 0.8 3jn2vnpfrrkj0
Module: exp@caje (TNS V1-V3)
SELECT NLSLENSEM, OPTLEVEL, CODETYPE, WARNINGS, CCFLAGS FROM SYS.EXU10R2D
EFPSWITCHES
4 4 1 3.70 0.7 gj8765bfkuzu6
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE_DELETE".* FROM "SAK
AI"."CONTENT_RESOURCE_DELETE"
3 3 1 3.37 0.6 1ycq3fpj2y6qb
Module: exp@caje (TNS V1-V3)
SELECT nlslensem FROM SYS.EXU10ADEFPSWITCHES
1 6 1 1.35 1.1 2ap4yjn3wwyq2
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_REALM_RL_FN".* FROM "SAKAI"."S
AKAI_REALM_RL_FN"
1 15 1 1.06 2.7 2c7swcc7hzvyj
select students_pkey, students_term_code, students_clientid, students_major_code
_1, students_degree_code_1, students_coll_code_1, students_level_code_1, student
SQL ordered by CPU Time DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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
---------- ---------- ------------ ----------- ------- -------------
s_major_code_2, students_degree_code_2, students_coll_code_2, students_level_cod
e_2, students_class_level, a.person_pkey, person_clientid, person_last_name, per
1 60 0 N/A 10.7 4tvrqgtyc06v3
Module: SQL*Plus
INSERT INTO coursemanagement_enrollment_tb SELECT * FROM coursemanagement_enroll
ment_v
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 10,940,144
-> Captured SQL account for 87.6% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
3,952,200 300 13,174.0 36.1 36.44 37.08 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,249,023 344 9,444.8 29.7 6.28 6.33 bnxaabvumwxjw
Module: exp@caje (TNS V1-V3)
SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME,
IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = :1 AND TYP
E IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
790,320 60 13,172.0 7.2 7.06 7.08 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
458,374 1 458,374.0 4.2 1.06 14.88 2c7swcc7hzvyj
select students_pkey, students_term_code, students_clientid, students_major_code
_1, students_degree_code_1, students_coll_code_1, students_level_code_1, student
s_major_code_2, students_degree_code_2, students_coll_code_2, students_level_cod
e_2, students_class_level, a.person_pkey, person_clientid, person_last_name, per
215,284 238 904.6 2.0 7.75 8.27 0ruc21jdus88a
SELECT roster_pkey, roster_pidm, roster_level_code, roster_enroll_status, roster
_grade_mode, roster_unit from courses_roster where roster_term_code = :1 and ros
ter_crn = :2
97,272 742 131.1 0.9 1.30 1.30 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
96,353 1 96,353.0 0.9 4.82 5.48 24xrfkghy1put
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE".* FROM "SAKAI"."CO
NTENT_RESOURCE"
94,147 1 94,147.0 0.9 3.00 3.13 81yyxhp5jac4d
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_COLLECTION".* FROM "SAKAI"."
CONTENT_COLLECTION"
69,439 1 69,439.0 0.6 3.70 4.00 gj8765bfkuzu6
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE_DELETE".* FROM "SAK
AI"."CONTENT_RESOURCE_DELETE"
67,867 1 67,867.0 0.6 1.17 1.17 0g0xzry4ss386
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_SITE_TOOL_PROPERTY".* FROM "SA
KAI"."SAKAI_SITE_TOOL_PROPERTY"
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Disk Reads: 542,853
-> Captured SQL account for 49.4% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
62,412 1 62,412.0 11.5 10.02 10.58 fcu3ck0gc56jr
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_EVENT".* FROM "SAKAI"."SAKAI_E
VENT"
38,353 1 38,353.0 7.1 4.82 5.48 24xrfkghy1put
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE".* FROM "SAKAI"."CO
NTENT_RESOURCE"
33,348 1 33,348.0 6.1 6.57 13.10 5t7sakctnju7u
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "UCDSOM"."SOM_BANNER_ROSTER".* FROM "UCDSOM".
"SOM_BANNER_ROSTER"
28,463 1 28,463.0 5.2 3.70 4.00 gj8765bfkuzu6
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_RESOURCE_DELETE".* FROM "SAK
AI"."CONTENT_RESOURCE_DELETE"
25,962 1 25,962.0 4.8 3.00 3.13 81yyxhp5jac4d
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CONTENT_COLLECTION".* FROM "SAKAI"."
CONTENT_COLLECTION"
16,988 0 N/A 3.1 0.96 60.18 4tvrqgtyc06v3
Module: SQL*Plus
INSERT INTO coursemanagement_enrollment_tb SELECT * FROM coursemanagement_enroll
ment_v
11,926 1 11,926.0 2.2 3.09 5.21 01pg2fm545vvh
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "UCDSOM"."SOM_BANNER_LEVEL".* FROM "UCDSOM"."
SOM_BANNER_LEVEL"
11,379 1 11,379.0 2.1 3.03 4.02 baf2wpdm696nd
select distinct catalog_subj_code, catalog_crse_numb from courses_catalog, cours
es_baseinfo where baseinfo_coll_code = 'MD' and catalog_term_code = :1 and basei
nfo_pkey = catalog_pkey order by catalog_subj_code, catalog_crse_numb
11,037 1 11,037.0 2.0 1.35 6.34 2ap4yjn3wwyq2
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_REALM_RL_FN".* FROM "SAKAI"."S
AKAI_REALM_RL_FN"
9,509 1 9,509.0 1.8 2.63 3.19 7fm7qy30yh9pa
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "UCDSOM"."SOM_BANNER_SECTION".* FROM "UCDSOM"
."SOM_BANNER_SECTION"
6,369 1 6,369.0 1.2 1.60 2.62 4nsd5ayfybzp8
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."ASSIGNMENT_SUBMISSION".* FROM "SAKAI
"."ASSIGNMENT_SUBMISSION"
5,851 1 5,851.0 1.1 1.00 1.21 7kd2409p1haun
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAKAI_SITE_TOOL".* FROM "SAKAI"."SAK
AI_SITE_TOOL"
SQL ordered by Reads DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Disk Reads: 542,853
-> Captured SQL account for 49.4% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
5,669 1 5,669.0 1.0 0.96 1.00 dcyvy7r0d6qu6
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."CHAT_MESSAGE".* FROM "SAKAI"."CHAT_M
ESSAGE"
5,653 1 5,653.0 1.0 1.15 1.21 33n5u6jsacfu1
Module: exp@caje (TNS V1-V3)
SELECT /*+NESTED_TABLE_GET_REFS+*/ "SAKAI"."SAM_ITEMGRADING_T".* FROM "SAKAI"."S
AM_ITEMGRADING_T"
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Executions: 96,552
-> Captured SQL account for 67.8% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
14,509 14,509 1.0 0.00 0.00 5knb2aknamtys
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".audit_exp(:2,:3,:4); END;
14,509 14,509 1.0 0.00 0.00 cx5gb2f1kndxa
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".create_exp(:2,:3,:4); END;
14,509 14,509 1.0 0.00 0.00 dz3sy1a0dx9dp
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".grant_exp(:2,:3,:4,:5,:6); END;
6,000 6,000 1.0 0.00 0.00 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
2,718 2,472 0.9 0.00 0.00 gx3w246gvh9df
SELECT poa_pkey, poa_pidm, poa_role FROM courses_poa WHERE poa_term_code = :1AND
poa_crn = :2
2,546 26,120 10.3 0.00 0.00 68fbr7gjyvakv
Module: exp@caje (TNS V1-V3)
SELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_RAW(ENDPTVAL) EN
DPTVAL_RAW FROM SYS.EXU8HST WHERE POBJID = :1 AND INTCO
L = :2 ORDER BY BUCKET
1,202 1,202 1.0 0.00 0.00 2s6amyv4qz2h2
Module: exp@caje (TNS V1-V3)
SELECT INIEXT, SEXT, MINEXT, MAXEXT, PCTINC, BLOCKS, LISTS, GROUPS,
EXTENTS, PCACHE, TS_TYPE, TSNAME, ISONLINE, BLOCKSIZE, HSCOMPRESS FROM SY
S.EXU9STO WHERE FILENO = :1 AND BLOCKNO = :2 AND T
SNO = :3
742 742 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
458 166 0.4 0.00 0.00 8p40k9bcw0274
Module: exp@caje (TNS V1-V3)
SELECT GRANTOR, GRANTORID, GRANTEE, PRIV, WHO, WGO, ISDIR, TYPE FROM SYS.
EXU8GRN WHERE OBJID = :1 ORDER BY WGO DESC, SEQUENCE
456 0 0.0 0.00 0.00 7fprcxd5040cz
Module: exp@caje (TNS V1-V3)
SELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED,
SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM
= :2
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Parse Calls: 68,549
-> Captured SQL account for 89.5% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
14,509 14,509 21.17 5knb2aknamtys
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".audit_exp(:2,:3,:4); END;
14,509 14,509 21.17 cx5gb2f1kndxa
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".create_exp(:2,:3,:4); END;
14,509 14,509 21.17 dz3sy1a0dx9dp
Module: exp@caje (TNS V1-V3)
BEGIN :1 := "SYS"."DBMS_JVM_EXP_PERMS".grant_exp(:2,:3,:4,:5,:6); END;
6,000 6,000 8.75 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL
2,718 2,718 3.97 gx3w246gvh9df
SELECT poa_pkey, poa_pidm, poa_role FROM courses_poa WHERE poa_term_code = :1AND
poa_crn = :2
1,202 1,202 1.75 2s6amyv4qz2h2
Module: exp@caje (TNS V1-V3)
SELECT INIEXT, SEXT, MINEXT, MAXEXT, PCTINC, BLOCKS, LISTS, GROUPS,
EXTENTS, PCACHE, TS_TYPE, TSNAME, ISONLINE, BLOCKSIZE, HSCOMPRESS FROM SY
S.EXU9STO WHERE FILENO = :1 AND BLOCKNO = :2 AND T
SNO = :3
458 458 0.67 8p40k9bcw0274
Module: exp@caje (TNS V1-V3)
SELECT GRANTOR, GRANTORID, GRANTEE, PRIV, WHO, WGO, ISDIR, TYPE FROM SYS.
EXU8GRN WHERE OBJID = :1 ORDER BY WGO DESC, SEQUENCE
456 456 0.67 7fprcxd5040cz
Module: exp@caje (TNS V1-V3)
SELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED,
SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM
= :2
345 345 0.50 4hjkbgj0815p4
Module: exp@caje (TNS V1-V3)
SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB),
TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SY
S.EXU9PTS WHERE SYNOBJNO IN ( SELECT SYNOBJNO FROM SYS.E
XU9TYPT WHERE TABOBJNO = :1 ) ORDER BY SYNTIME
345 345 0.50 6x2cz59yrxz3a
Module: exp@caje (TNS V1-V3)
SELECT NAME, OBJID, OWNER, PROPERTY, PACKAGE, PKG_SCHEMA, NAMESPACE,
TYPE#, CLASS FROM SYS.EXU9ACTIONOBJ WHERE OBJID = :1 ORDER B
Y LEVEL#
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
17,017,612 N/A 2.42 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,918,840 4 0.70 dc6dj7p1ybyjh
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID
4,014,690 2 0.57 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
4,014,671 2 0.57 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'
3,569,937 2 0.51 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'
3,488,862 2 0.50 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'
3,138,326 2 0.45 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'
2,391,364 3 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 319 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: 3250-3251
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
488 319 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_
335 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 329 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 = :
178 4 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
166 3 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 )
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'
43 2 2g69rythn19tc
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_ENROLLMENT enr where enr.PERSON_EID = '000000' and se
c.ENROLLMENTSET_EID = enr.ENROLLMENTSET_EID and enr.dropped=0
43 2 5s8ka1shknpdr
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_INSTRUCTORS ins where ins.SECTION_EID = sec.EID and i
ns.PERSON_EID = '00166200'
43 2 870bapc3b0kcx
Module: SQL*Plus
SQL ordered by Version Count DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Only Statements with Version Count greater than 20 are displayed
Version
Count Executions SQL Id
-------- ------------ -------------
explain plan set statement_id='test1' for select * from COURSEMANAGEMENT_INSTRUC
TORS where ENROLLMENTSET_EID = 'http://ucdavis.edu/course/enrollmentset/58553/20
0703'
36 38 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: 3250-3251
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 22,423 6.2 17.1
CPU used when call started 21,927 6.1 16.7
CR blocks created 67 0.0 0.1
Cached Commit SCN referenced 173,114 48.1 132.1
Commit SCN cached 10 0.0 0.0
DB time 845,502 234.8 644.9
DBWR checkpoint buffers written 756 0.2 0.6
DBWR checkpoints 5 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 756 0.2 0.6
DBWR transaction table writes 15 0.0 0.0
DBWR undo block writes 214 0.1 0.2
IMU CR rollbacks 11 0.0 0.0
IMU Flushes 897 0.3 0.7
IMU Redo allocation size 300,228 83.4 229.0
IMU commits 1,137 0.3 0.9
IMU contention 1 0.0 0.0
IMU ktichg flush 22 0.0 0.0
IMU pool not allocated 2 0.0 0.0
IMU recursive-transaction flush 1 0.0 0.0
IMU undo allocation size 2,306,708 640.5 1,759.5
IMU- failed to get a private str 2 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 3,159,710 877.3 2,410.2
SQL*Net roundtrips to/from dblin 880 0.2 0.7
active txn count during cleanout 46 0.0 0.0
application wait time 1 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 1 0.0 0.0
background timeouts 11,576 3.2 8.8
branch node splits 0 0.0 0.0
buffer is not pinned count 4,844,417 1,345.1 3,695.2
buffer is pinned count 5,594,923 1,553.5 4,267.7
bytes received via SQL*Net from 2,564,118,990 711,940.2 1,955,849.7
bytes received via SQL*Net from 265,700 73.8 202.7
bytes sent via SQL*Net to client 6,850,539,102 1,902,085.9 5,225,430.3
bytes sent via SQL*Net to dblink 378,018 105.0 288.3
calls to get snapshot scn: kcmgs 4,128,820 1,146.4 3,149.4
calls to kcmgas 2,491 0.7 1.9
calls to kcmgcs 153 0.0 0.1
change write time 20 0.0 0.0
cleanout - number of ktugct call 125 0.0 0.1
cleanouts and rollbacks - consis 10 0.0 0.0
cleanouts only - consistent read 65 0.0 0.1
cluster key scan block gets 48,567 13.5 37.1
cluster key scans 25,154 7.0 19.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 10 0.0 0.0
commit cleanout failures: cannot 5 0.0 0.0
commit cleanouts 3,981 1.1 3.0
commit cleanouts successfully co 3,944 1.1 3.0
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
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 179 0.1 0.1
concurrency wait time 421 0.1 0.3
consistent changes 1,417 0.4 1.1
consistent gets 10,912,637 3,030.0 8,323.9
consistent gets - examination 2,363,809 656.3 1,803.1
consistent gets direct 226,693 62.9 172.9
consistent gets from cache 10,685,944 2,967.0 8,151.0
current blocks converted for CR 0 0.0 0.0
cursor authentications 109 0.0 0.1
data blocks consistent reads - u 75 0.0 0.1
db block changes 20,879 5.8 15.9
db block gets 27,507 7.6 21.0
db block gets direct 9 0.0 0.0
db block gets from cache 27,498 7.6 21.0
deferred (CURRENT) block cleanou 1,638 0.5 1.3
dirty buffers inspected 361 0.1 0.3
enqueue conversions 1,317 0.4 1.0
enqueue releases 49,356 13.7 37.7
enqueue requests 49,374 13.7 37.7
enqueue timeouts 32 0.0 0.0
enqueue waits 1 0.0 0.0
execute count 96,552 26.8 73.7
failed probes on index block rec 0 0.0 0.0
frame signature mismatch 0 0.0 0.0
free buffer inspected 322,802 89.6 246.2
free buffer requested 317,033 88.0 241.8
heap block compress 59 0.0 0.1
hot buffers moved to head of LRU 56,869 15.8 43.4
immediate (CR) block cleanout ap 75 0.0 0.1
immediate (CURRENT) block cleano 483 0.1 0.4
index crx upgrade (found) 0 0.0 0.0
index crx upgrade (positioned) 10,451 2.9 8.0
index fast full scans (full) 9 0.0 0.0
index fetch by key 1,947,022 540.6 1,485.1
index scans kdiixs1 193,770 53.8 147.8
leaf node 90-10 splits 8 0.0 0.0
leaf node splits 17 0.0 0.0
lob reads 49,753 13.8 38.0
lob writes 380 0.1 0.3
lob writes unaligned 379 0.1 0.3
logons cumulative 191 0.1 0.2
messages received 1,505 0.4 1.2
messages sent 1,505 0.4 1.2
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 8,289,994 2,301.8 6,323.4
opened cursors cumulative 68,429 19.0 52.2
parse count (failures) 65 0.0 0.1
parse count (hard) 130 0.0 0.1
parse count (total) 68,549 19.0 52.3
parse time cpu 181 0.1 0.1
parse time elapsed 1,484 0.4 1.1
physical read IO requests 282,396 78.4 215.4
physical read bytes 4,447,051,776 1,234,745.8 3,392,106.6
physical read total IO requests 331,349 92.0 252.8
physical read total bytes 25,687,178,752 7,132,171.5 19,593,576.5
physical read total multi block 61,156 17.0 46.7
physical reads 542,853 150.7 414.1
physical reads cache 316,160 87.8 241.2
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache prefetch 271,147 75.3 206.8
physical reads direct 226,693 62.9 172.9
physical reads direct (lob) 226,693 62.9 172.9
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 730 0.2 0.6
physical write bytes 9,846,784 2,734.0 7,510.9
physical write total IO requests 26,292 7.3 20.1
physical write total bytes 19,713,069,568 5,473,430.7 15,036,666.3
physical write total multi block 21,355 5.9 16.3
physical writes 1,202 0.3 0.9
physical writes direct 9 0.0 0.0
physical writes direct (lob) 0 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 1,193 0.3 0.9
physical writes non checkpoint 560 0.2 0.4
pinned buffers inspected 0 0.0 0.0
prefetch clients - default 1 0.0 0.0
prefetch warmup blocks aged out 0 0.0 0.0
prefetched blocks aged out befor 239 0.1 0.2
process last non-idle time 14,352 4.0 11.0
recovery blocks read 0 0.0 0.0
recursive calls 57,947 16.1 44.2
recursive cpu usage 543 0.2 0.4
redo blocks read for recovery 0 0.0 0.0
redo blocks written 8,209 2.3 6.3
redo buffer allocation retries 0 0.0 0.0
redo entries 7,187 2.0 5.5
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,588,620 996.4 2,737.3
redo synch time 3,351 0.9 2.6
redo synch writes 7,332 2.0 5.6
redo wastage 419,204 116.4 319.8
redo write time 3,258 0.9 2.5
redo writer latching time 0 0.0 0.0
redo writes 1,352 0.4 1.0
rollback changes - undo records 0 0.0 0.0
rollbacks only - consistent read 57 0.0 0.0
rows fetched via callback 203,896 56.6 155.5
session connect time 0 0.0 0.0
session cursor cache hits 57,725 16.0 44.0
session logical reads 10,940,144 3,037.6 8,344.9
session pga memory 61,853,420 17,173.9 47,180.3
session uga memory 231,943,779,240 64,400,330.4 #############
session uga memory max 196,836,728 54,652.7 150,142.4
shared hash latch upgrades - no 15,935 4.4 12.2
shared hash latch upgrades - wai 0 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 13,928 3.9 10.6
sorts (rows) 168,267 46.7 128.4
sql area evicted 17 0.0 0.0
sql area purged 70 0.0 0.1
summed dirty queue length 370 0.1 0.3
switch current to new buffer 180 0.1 0.1
table fetch by rowid 3,814,399 1,059.1 2,909.5
table fetch continued row 2,694 0.8 2.1
table scan blocks gotten 5,864,429 1,628.3 4,473.3
table scan rows gotten 205,393,353 57,028.5 156,669.2
Instance Activity Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
table scans (long tables) 26 0.0 0.0
table scans (short tables) 7,417 2.1 5.7
total number of times SMON poste 35 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 1,218,804 338.4 929.7
user I/O wait time 9,815 2.7 7.5
user calls 3,123,766 867.3 2,382.7
user commits 1,311 0.4 1.0
user rollbacks 0 0.0 0.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 10,903 3.0 8.3
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: 3250-32
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 336,390 339,561
opened cursors current 36,179 36,216
workarea memory allocated 1,009 8,609
logons current 1,043 1,039
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai Snaps: 3250-325
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
-------------------------------- ------------------ ---------
log switches (derived) 1 1.00
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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
280,698 78 1.5 1.9 454 0 0 0.0
SYSTEM
1,410 0 15.7 1.1 42 0 27 12.6
SYSAUX
205 0 74.9 1.2 179 0 0 0.0
UNDOTBS1
4 0 ###### 1.0 54 0 0 0.0
ARCH_TS
1 0 ###### 1.0 0 0 0 0.0
INDEX_TS
1 0 ###### 1.0 0 0 0 0.0
TEMP
0 0 0.0 N/A 1 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ARCH_TS /local/d02/oracle/sakai/arch01.dbf
1 0 ###### 1.0 0 0 0 0.0
DATA_TS /local/d02/oracle/sakai/data01.dbf
278,117 77 1.4 1.9 323 0 0 0.0
DATA_TS /local/d02/oracle/sakai/data02.dbf
2,581 1 9.9 3.8 131 0 0 0.0
INDEX_TS /local/d02/oracle/sakai/index01.dbf
1 0 ###### 1.0 0 0 0 0.0
SYSAUX /local/d02/oracle/sakai/sysaux01.dbf
205 0 74.9 1.2 179 0 0 0.0
SYSTEM /local/d02/oracle/sakai/system01.dbf
1,410 0 15.7 1.1 42 0 27 12.6
TEMP /local/d02/oracle/sakai/temp01.dbf
0 0 N/A N/A 1 0 0 N/A
UNDOTBS1 /local/d02/oracle/sakai/undotbs01.dbf
4 0 ###### 1.0 54 0 0 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 97 10,713,126 316,128 1,193 0 0 27
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 222 297 2300 737280 2300 N/A
E 0 0 562 3951 3422 737280 3422 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: SAKAI/sakai Snap: 3251
-> 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 576,189,746
D 128 .2 15,992 1.4 505,310,610
D 192 .2 23,988 1.2 452,646,632
D 256 .3 31,984 1.1 420,420,624
D 320 .4 39,980 1.1 398,196,685
D 384 .5 47,976 1.0 384,998,176
D 448 .6 55,972 1.0 377,176,326
D 512 .7 63,968 1.0 373,328,917
D 576 .7 71,964 1.0 371,944,044
D 640 .8 79,960 1.0 371,389,499
D 704 .9 87,956 1.0 371,199,893
D 768 1.0 95,952 1.0 371,068,738
D 784 1.0 97,951 1.0 371,040,819
D 832 1.1 103,948 1.0 370,975,533
D 896 1.1 111,944 1.0 370,906,472
D 960 1.2 119,940 1.0 370,854,038
D 1,024 1.3 127,936 1.0 370,811,332
D 1,088 1.4 135,932 1.0 370,773,441
D 1,152 1.5 143,928 1.0 370,740,971
D 1,216 1.6 151,924 1.0 370,711,803
D 1,280 1.6 159,920 1.0 370,686,498
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 464 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 145 986.0 1.0 .1 100.0 .0 102,400
E 800 158 959.5 8.4 .9 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 10,338 10,338 0 0
64K 128K 65 65 0 0
128K 256K 3 3 0 0
256K 512K 92 92 0 0
512K 1024K 393 393 0 0
1M 2M 9 9 0 0
2M 4M 1 1 0 0
32M 64M 2 2 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: SAKAI/sakai Snap: 3251
-> 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 374,886.9 38,234.3 91.0 1,884
200 0.3 374,886.9 38,196.3 91.0 1,884
400 0.5 374,886.9 35,059.7 91.0 1,775
600 0.8 374,886.9 19,989.4 95.0 709
800 1.0 374,886.9 2,060.9 99.0 0
960 1.2 374,886.9 1,997.1 99.0 0
1,120 1.4 374,886.9 1,997.1 99.0 0
1,280 1.6 374,886.9 1,997.1 99.0 0
1,440 1.8 374,886.9 1,997.1 99.0 0
1,600 2.0 374,886.9 1,997.1 99.0 0
2,400 3.0 374,886.9 1,997.1 99.0 0
3,200 4.0 374,886.9 1,997.1 99.0 0
4,800 6.0 374,886.9 1,997.1 99.0 0
6,400 8.0 374,886.9 1,997.1 99.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: SAKAI/sakai Snap: 3251
-> 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 85 7,546 ####### 1.0 ####### 49.3 22,131,516
352 .5 161 9,991 ####### 1.0 ####### 30.2 22,156,746
432 .6 238 12,707 ####### 1.0 69,913 18.2 22,173,607
512 .8 317 18,863 ####### 1.0 41,052 10.7 22,183,844
592 .9 396 21,988 ####### 1.0 20,277 5.3 22,190,122
672 1.0 475 25,940 ####### 1.0 3,840 1.0 22,193,773
752 1.1 554 31,581 ####### 1.0 1 .0 22,196,106
832 1.2 633 35,555 ####### 1.0 1 .0 22,198,085
912 1.4 712 39,544 ####### 1.0 1 .0 22,199,874
992 1.5 718 40,156 ####### 1.0 1 .0 22,201,456
1,072 1.6 718 40,156 ####### 1.0 1 .0 22,202,913
1,152 1.7 766 43,675 ####### 1.0 1 .0 22,204,362
1,232 1.8 766 43,675 ####### 1.0 1 .0 22,205,790
1,312 2.0 845 47,298 ####### 1.0 1 .0 22,207,215
1,392 2.1 918 50,639 ####### 1.0 1 .0 22,208,638
-------------------------------------------------------------
SGA Target Advisory DB/Inst: SAKAI/sakai Snap: 3251
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
752 0.5 309,590 452,444,264
1,128 0.8 249,943 384,841,062
1,504 1.0 241,584 371,038,432
1,880 1.3 241,439 370,630,290
2,256 1.5 241,416 370,518,978
2,632 1.8 241,416 370,518,978
3,008 2.0 241,416 370,518,978
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: SAKAI/sakai Snap: 3251
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: SAKAI/sakai Snap: 3251
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,840 1.0 76
32 2.0 2 76 1 1.0 3,840 1.0 76
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
data block 27 0 13
-------------------------------------------------------------
Enqueue Activity DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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)
------------ ------------ ----------- ----------- ------------ --------------
CF-Controlfile Transaction
1,973 1,973 0 1 0 20.00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 2.3 3,455 1,503 11 5760/5760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 05:10 2,090 1,636 1,197 11 5,760 0/0 0/0/0/0/0/0
08-Oct 05:00 11 199 597 4 5,760 0/0 0/0/0/0/0/0
08-Oct 04:50 46 358 0 9 5,760 0/0 0/0/0/0/0/0
08-Oct 04:40 24 276 0 10 5,760 0/0 0/0/0/0/0/0
08-Oct 04:30 16 271 1,503 3 5,760 0/0 0/0/0/0/0/0
08-Oct 04:20 38 306 902 9 5,760 0/0 0/0/0/0/0/0
08-Oct 04:10 69 409 302 10 5,760 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> "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,384 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 81,773 0.0 N/A 0 0 N/A
Consistent RBA 1,353 0.0 N/A 0 0 N/A
FAL request queue 74 0.0 N/A 0 0 N/A
FAL subheap alocation 74 0.0 N/A 0 0 N/A
FIB s.o chain latch 192 0.0 N/A 0 0 N/A
FOB s.o list latch 397 0.0 N/A 0 0 N/A
In memory undo latch 13,511 0.1 0.9 0 3,588 0.0
JOX SGA heap latch 12 0.0 N/A 0 0 N/A
JS mem alloc latch 4 0.0 N/A 0 0 N/A
JS queue access latch 4 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 136 0.0 N/A 0 0 N/A
KMG MMAN ready and start 1,201 0.0 N/A 0 0 N/A
KTF sga latch 7 0.0 N/A 0 949 0.0
KWQMN job cache list lat 35 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,201 0.0
OS process 687 0.0 N/A 0 0 N/A
OS process allocation 1,654 0.0 N/A 0 0 N/A
OS process: request allo 278 0.0 N/A 0 0 N/A
PL/SQL warning settings 45,081 0.0 N/A 0 0 N/A
SGA IO buffer pool latch 12 0.0 N/A 0 12 0.0
SQL memory manager latch 1 0.0 N/A 0 1,188 0.0
SQL memory manager worka 101,646 0.0 N/A 0 0 N/A
Shared B-Tree 140 0.0 N/A 0 0 N/A
X$KSFQP 58 0.0 N/A 0 0 N/A
active checkpoint queue 1,341 0.0 N/A 0 0 N/A
active service list 9,176 0.0 N/A 0 1,206 0.0
archive control 477 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 2 0.0 N/A 0 0 N/A
cache buffer handles 13,498 0.0 N/A 0 0 N/A
cache buffers chains 19,443,936 0.0 0.1 0 651,123 0.0
cache buffers lru chain 320,308 0.0 0.2 0 218,211 0.0
cache table scan latch 0 N/A N/A 0 19,427 0.0
channel handle pool latc 323 0.0 N/A 0 0 N/A
channel operations paren 17,599 0.0 N/A 0 0 N/A
checkpoint queue latch 23,482 0.0 N/A 0 1,277 0.0
client/application info 359 0.0 N/A 0 0 N/A
commit callback allocati 140 0.0 N/A 0 0 N/A
compile environment latc 6,972 0.0 N/A 0 0 N/A
constraint object alloca 104 0.0 N/A 0 0 N/A
dictionary lookup 1 0.0 N/A 0 0 N/A
dml lock allocation 17,484 0.0 N/A 0 0 N/A
dummy allocation 386 0.0 N/A 0 0 N/A
enqueue hash chains 100,110 0.0 0.1 0 42 0.0
enqueues 84,287 0.0 0.0 0 0 N/A
event group latch 137 0.0 N/A 0 0 N/A
file cache latch 197 0.0 N/A 0 0 N/A
global KZLD latch for me 91 0.0 N/A 0 0 N/A
global tx hash mapping 1,282 0.0 N/A 0 0 N/A
hash table column usage 27 0.0 N/A 0 20,612 0.0
hash table modification 96 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 96 0.0 N/A 0 0 N/A
krbmrosl 123 0.0 N/A 0 0 N/A
ksuosstats global area 243 0.0 N/A 0 0 N/A
ktm global data 40 0.0 N/A 0 0 N/A
Latch Activity DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
kwqbsn:qsga 140 0.0 N/A 0 0 N/A
lgwr LWN SCN 2,025 0.0 N/A 0 0 N/A
library cache 377,454 0.0 0.1 0 2 0.0
library cache load lock 238 0.0 N/A 0 3 0.0
library cache lock 61,495 0.1 0.1 0 0 N/A
library cache lock alloc 2,632 0.0 0.0 0 0 N/A
library cache pin 214,915 0.0 0.0 0 0 N/A
library cache pin alloca 568 0.0 N/A 0 0 N/A
list of block allocation 300 0.0 N/A 0 0 N/A
loader state object free 96,564 0.0 N/A 0 0 N/A
longop free list parent 1,560 0.0 N/A 0 13 0.0
message pool operations 96 0.0 N/A 0 0 N/A
messages 27,796 0.0 N/A 0 0 N/A
mostly latch-free SCN 2,022 0.0 N/A 0 0 N/A
multiblock read objects 43,671 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,779 0.0 N/A 0 544 0.0
object queue header oper 639,911 0.0 0.0 0 0 N/A
object stats modificatio 72 0.0 N/A 0 0 N/A
parallel query alloc buf 476 0.0 N/A 0 0 N/A
parameter table allocati 304 0.0 N/A 0 0 N/A
post/wait queue 3,037 0.0 N/A 0 1,218 0.0
process allocation 278 0.0 N/A 0 137 0.0
process group creation 278 0.0 N/A 0 0 N/A
qmn task queue latch 512 0.0 N/A 0 0 N/A
redo allocation 18,691 0.0 0.0 0 0 N/A
redo copy 0 N/A N/A 0 7,228 0.2
redo writing 7,768 0.0 N/A 0 0 N/A
row cache objects 194,448 0.0 0.0 0 0 N/A
rules engine aggregate s 2 0.0 N/A 0 0 N/A
rules engine rule set st 4 0.0 N/A 0 0 N/A
sequence cache 1,903 0.0 N/A 0 0 N/A
session allocation 20,012 0.0 0.6 0 0 N/A
session idle bit 6,254,307 0.0 0.3 0 0 N/A
session state list latch 488 0.0 N/A 0 0 N/A
session switching 57 0.0 N/A 0 0 N/A
session timer 1,206 0.0 N/A 0 0 N/A
shared pool 16,744 0.0 0.3 0 0 N/A
shared pool simulator 5,459 0.0 N/A 0 0 N/A
simulator hash latch 854,863 0.0 N/A 0 0 N/A
simulator lru latch 795,934 0.0 0.0 0 19,748 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 383 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 1 0.0 N/A 0 0 N/A
temporary table state ob 20 0.0 N/A 0 0 N/A
threshold alerts latch 331 0.0 N/A 0 0 N/A
transaction allocation 256 0.0 N/A 0 0 N/A
transaction branch alloc 265 0.0 N/A 0 0 N/A
undo global data 13,491 0.0 N/A 0 0 N/A
user lock 479 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
simulator lru latch
795,934 302 1 301 0 0 0
library cache
377,454 81 6 77 0 0 0
library cache lock
61,495 42 3 39 0 0 0
cache buffers chains
19,443,936 23 2 21 0 0 0
cache buffers lru chain
320,308 21 4 18 0 0 0
session idle bit
6,254,307 19 6 13 0 0 0
In memory undo latch
13,511 7 6 2 0 0 0
enqueue hash chains
100,110 7 1 6 0 0 0
shared pool
16,744 7 2 5 0 0 0
session allocation
20,012 5 3 2 0 0 0
slave class create
8 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch kticmt: child 0 2 1
In memory undo latch kturbk 0 2 5
In memory undo latch ktiFlush: child 0 1 0
In memory undo latch ktiTxnPoolFree 0 1 0
cache buffers chains kcbgtcr: fast path 0 4 0
cache buffers chains kcbrls: kslbegin 0 3 3
cache buffers chains kcbzwb 0 2 0
cache buffers chains kcbgtcr: kslbegin excl 0 1 3
cache buffers lru chain kcbzgws_1 0 3 4
cache buffers lru chain kcbzgb: posted for free bu 0 1 0
enqueue hash chains ksqgtl3 0 1 1
library cache kglScanDependency 0 3 0
library cache kglLockCursor 0 1 2
library cache kglic 0 1 0
library cache kglpndl: child: before pro 0 1 1
library cache lock kgllkal: child: multiinsta 0 3 3
session allocation ksudlc 0 1 1
session allocation ksufap: active sessions 0 1 0
session allocation ksusroll 0 1 0
session idle bit ksupuc: clear busy 0 3 2
session idle bit ksupuc: set busy 0 3 4
shared pool kghalo 0 2 2
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: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Logical Reads: 10,940,144
-> Captured Segments account for 94.2% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SAKAI_SESSION TABLE 4,757,104 43.48
SYS SYSTEM I_CDEF1 INDEX 1,630,016 14.90
SYS SYSTEM CDEF$ TABLE 1,591,680 14.55
SAKAI_EXTE DATA_TS PERSON_MOTHRAID_INDE INDEX 261,184 2.39
UCDSOM DATA_TS PK_SFRSTCR INDEX 212,960 1.95
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> Total Physical Reads: 542,853
-> Captured Segments account for 82.4% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI DATA_TS SYS_LOB0000046205C00 LOB 154,761 28.51
SAKAI DATA_TS SAKAI_EVENT TABLE 62,419 11.50
SAKAI DATA_TS CONTENT_RESOURCE TABLE 38,419 7.08
UCDSOM DATA_TS SOM_BANNER_ROSTER TABLE 33,804 6.23
SAKAI DATA_TS CONTENT_RESOURCE_DEL TABLE 28,475 5.25
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> % 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 IE_SAKAI_SITE_FLAGS INDEX 3 37.50
SAKAI DATA_TS SYS_C004168 INDEX 3 37.50
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 2 25.00
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot
Buffer
Tablespace Subobject Obj. Busy % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM SUM$ TABLE 23 85.19
SYS SYSTEM DBMS_LOCK_ALLOCATED TABLE 2 7.41
SYS SYSTEM JOB$ TABLE 2 7.41
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> "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 66 0.0 0 N/A 2 1
dc_database_links 308 0.0 0 N/A 0 6
dc_files 6 0.0 0 N/A 0 7
dc_global_oids 19 0.0 0 N/A 0 151
dc_histogram_data 2,358 0.1 0 N/A 0 9,602
dc_histogram_defs 1,439 0.8 0 N/A 0 6,332
dc_object_grants 96 0.0 0 N/A 0 794
dc_object_ids 12,463 0.1 0 N/A 1 2,517
dc_objects 1,211 1.4 0 N/A 21 3,091
dc_profiles 149 0.0 0 N/A 0 1
dc_rollback_segments 14,359 0.0 0 N/A 0 392
dc_segments 322 0.3 0 N/A 40 2,457
dc_sequences 35 0.0 0 N/A 35 53
dc_tablespace_quotas 122 0.0 0 N/A 0 6
dc_tablespaces 13,627 0.0 0 N/A 0 9
dc_usernames 553 0.0 0 N/A 0 34
dc_users 22,185 0.0 0 N/A 0 86
global database name 130 0.0 0 N/A 0 1
outstanding_alerts 130 0.8 0 N/A 2 17
-------------------------------------------------------------
Library Cache Activity DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 1,345 0.0 50,568 0.0 0 0
CLUSTER 31 0.0 55 0.0 0 0
INDEX 7 42.9 33 18.2 0 0
JAVA DATA 1 0.0 0 N/A 0 0
SQL AREA 28 28.6 195,210 0.1 75 19
TABLE/PROCEDURE 319 0.6 52,982 0.2 33 0
TRIGGER 18 0.0 30 0.0 0 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: SAKAI/sakai Snaps: 3250-3251
-> 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 797.4 N/A .8 2.6 63 63 1,044 1,044
Freeable 117.4 .0 .5 .3 1 N/A 256 256
SQL 69.5 21.4 .1 .1 1 106 1,033 1,027
PL/SQL 2.6 .4 .0 .0 0 0 1,042 1,042
E Other 761.3 N/A .7 2.3 63 63 1,040 1,040
Freeable 119.1 .0 .5 .3 1 N/A 256 256
SQL 76.5 28.7 .1 .3 8 106 1,029 1,023
PL/SQL 2.5 .4 .0 .0 0 0 1,038 1,038
JAVA 1.0 1.0 1.0 .0 1 1 1 1
-------------------------------------------------------------
SGA Memory Summary DB/Inst: SAKAI/sakai Snaps: 3250-3251
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: 3250-3251
-> 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.9 47.0 0.17
shared Heap0: KGL 10.3 10.3 -0.01
shared KGH: NO ACCESS 69.3 69.3 0.00
shared KGLS heap 10.4 10.5 0.77
shared KTI-UNDO 14.7 14.7 0.00
shared PCursor 18.5 18.5 0.02
shared PL/SQL MPCODE 7.8 7.8 0.00
shared event statistics per sess 15.7 15.7 0.00
shared free memory 99.4 97.7 -1.72
shared library cache 30.9 30.9 0.06
shared private strands 14.2 14.2 0.00
shared sessions 9.4 9.4 0.00
shared sql area 275.6 277.1 0.55
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: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: SAKAI/sakai Snaps: 3250-3251
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: SAKAI/sakai Snap: 3251
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: SAKAI/sakai Snaps: 3250-3251
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