awr-2007-10-09_10-00

WORKLOAD REPOSITORY report for

DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
SAKAI          530514751 sakai               1 10.2.0.3.0  NO  caje

              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:      3283 09-Oct-07 10:00:44     1,036       9.5
  End Snap:      3287 09-Oct-07 14:00:50     1,029      12.7
   Elapsed:              240.10 (mins)
   DB Time:               41.49 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:       688M       688M  Std Block Size:         8K
           Shared Pool Size:       768M       768M      Log Buffer:    15,148K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:              9,352.09              4,825.98
              Logical reads:              7,660.87              3,953.25
              Block changes:                 43.50                 22.45
             Physical reads:                 28.44                 14.68
            Physical writes:                  3.36                  1.73
                 User calls:                624.71                322.37
                     Parses:                  8.26                  4.26
                Hard parses:                  0.06                  0.03
                      Sorts:                 10.13                  5.23
                     Logons:                  0.05                  0.02
                   Executes:                228.29                117.81
               Transactions:                  1.94

  % Blocks changed per Read:    0.57    Recursive Call %:    11.92
 Rollback per transaction %:    0.97       Rows per Sort:     9.54

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   99.85    In-memory Sort %:  100.00
            Library Hit   %:   99.93        Soft Parse %:   99.31
         Execute to Parse %:   96.38         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   15.09     % Non-Parse CPU:   99.65

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   87.56   89.94
    % SQL with executions>1:   97.04   97.40
  % Memory for SQL w/exec>1:   94.40   95.13

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time                                          2,112          84.9
log file sync                        27,695         342     12   13.7     Commit
log file parallel write              28,318         336     12   13.5 System I/O
SQL*Net more data from client     1,202,059         129      0    5.2    Network
control file parallel write           4,770         104     22    4.2 System I/O
          -------------------------------------------------------------
Time Model Statistics                  DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total time in database user-calls (DB Time): 2489.4s
-> Statistics including the word "background" measure background process
   time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name

Statistic Name                                       Time (s) % of DB Time
------------------------------------------ ------------------ ------------
DB CPU                                                2,112.4         84.9
sql execute elapsed time                              2,018.2         81.1
parse time elapsed                                       42.5          1.7
hard parse elapsed time                                  35.7          1.4
failed parse elapsed time                                26.4          1.1
PL/SQL execution elapsed time                            24.0          1.0
repeated bind elapsed time                               17.1           .7
hard parse (sharing criteria) elapsed time                1.9           .1
connection management call elapsed time                   0.9           .0
hard parse (bind mismatch) elapsed time                   0.9           .0
sequence load elapsed time                                0.7           .0
PL/SQL compilation elapsed time                           0.0           .0
DB time                                               2,489.4          N/A
background elapsed time                                 640.8          N/A
background cpu time                                      46.8          N/A
          -------------------------------------------------------------

Wait Class                              DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc

                                                                  Avg
                                       %Time       Total Wait    wait     Waits
Wait Class                      Waits  -outs         Time (s)    (ms)      /txn
-------------------- ---------------- ------ ---------------- ------- ---------
System I/O                     49,216     .0              441       9       1.8
Commit                         27,695     .0              342      12       1.0
Network                    13,395,137     .0              213       0     479.8
User I/O                      374,002     .0               52       0      13.4
Concurrency                     1,042    1.4               11      10       0.0
Other                             462     .0                1       1       0.0
Application                        18     .0                0       6       0.0
          -------------------------------------------------------------

Wait Events                            DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
log file sync                        27,695     .0         342      12       1.0
log file parallel write              28,318     .0         336      12       1.0
SQL*Net more data from clien      1,202,059     .0         129       0      43.1
control file parallel write           4,770     .0         104      22       0.2
SQL*Net more data to client       3,018,424     .0          39       0     108.1
db file sequential read             246,249     .0          37       0       8.8
SQL*Net message to client         8,907,624     .0          35       0     319.1
db file parallel read                 4,938     .0          14       3       0.2
SQL*Net more data from dblin          3,901     .0           8       2       0.1
os thread startup                       173     .0           6      36       0.0
library cache load lock                  24     .0           3     137       0.0
SQL*Net message to dblink           262,873     .0           1       0       9.4
direct path read                    119,963     .0           1       0       4.3
db file scattered read                1,847     .0           1       0       0.1
latch free                              232     .0           0       2       0.0
latch: library cache                     92     .0           0       3       0.0
control file sequential read         16,128     .0           0       0       0.6
latch: cache buffers chains             485     .0           0       0       0.0
cursor: pin S wait on X                  15  100.0           0      13       0.0
latch: row cache objects                231     .0           0       1       0.0
SQL*Net break/reset to clien             16     .0           0       6       0.0
buffer busy waits                        10     .0           0       6       0.0
latch: library cache pin                  5     .0           0       9       0.0
latch: cache buffers lru cha             19     .0           0       2       0.0
latch: enqueue hash chains                4     .0           0       5       0.0
cursor: pin S                           113     .0           0       0       0.0
LGWR wait for redo copy                  43     .0           0       0       0.0
latch: library cache lock                 2     .0           0       6       0.0
latch: session allocation                25     .0           0       0       0.0
latch: object queue header o              5     .0           0       2       0.0
latch: cache buffer handles              20     .0           0       0       0.0
direct path write                       775     .0           0       0       0.0
SQL*Net more data to dblink             256     .0           0       0       0.0
latch: shared pool                        2     .0           0       2       0.0
direct path write temp                  114     .0           0       0       0.0
direct path read temp                   114     .0           0       0       0.0
enq: TX - row lock contentio              2     .0           0       0       0.0
read by other session                     2     .0           0       0       0.0
latch: In memory undo latch               3     .0           0       0       0.0
latch: undo global data                   1     .0           0       0       0.0
SQL*Net message from client       8,907,625     .0  13,056,516    1466     319.1
jobq slave wait                       5,236   97.2      15,174    2898       0.2
Streams AQ: waiting for mess          2,881  100.0      14,059    4880       0.1
virtual circuit status                  480  100.0      14,013   29193       0.0
Streams AQ: qmn slave idle w            512     .0      13,980   27304       0.0
Streams AQ: qmn coordinator           1,056   51.5      13,979   13238       0.0
Streams AQ: waiting for time             56   92.9      13,435  239911       0.0
SQL*Net message from dblink         262,873     .0         403       2       9.4
single-task message                     208     .0          26     125       0.0
class slave wait                          2     .0           0       0       0.0
          -------------------------------------------------------------

Background Wait Events                 DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------
log file parallel write              28,318     .0         336      12       1.0
control file parallel write           4,770     .0         104      22       0.2
os thread startup                       173     .0           6      36       0.0
db file scattered read                  280     .0           0       0       0.0
control file sequential read          4,904     .0           0       0       0.2
db file sequential read                 507     .0           0       0       0.0
events in waitclass Other                50     .0           0       1       0.0
log file sync                             1     .0           0      11       0.0
latch: library cache                      6     .0           0       0       0.0
buffer busy waits                         1     .0           0       0       0.0
direct path read                          7     .0           0       0       0.0
direct path write                         7     .0           0       0       0.0
rdbms ipc message                    76,501   60.3     151,444    1980       2.7
pmon timer                            4,824  100.0      14,051    2913       0.2
Streams AQ: qmn slave idle w            512     .0      13,980   27304       0.0
Streams AQ: qmn coordinator           1,056   51.5      13,979   13238       0.0
smon timer                              111   13.5      13,441  121093       0.0
Streams AQ: waiting for time             56   92.9      13,435  239911       0.0
class slave wait                          1     .0           0       0       0.0
          -------------------------------------------------------------

Operating System Statistics             DB/Inst: SAKAI/sakai  Snaps: 3283-3287

Statistic                                       Total
-------------------------------- --------------------
BUSY_TIME                                     302,266
IDLE_TIME                                   2,579,032
IOWAIT_TIME                                    94,012
NICE_TIME                                           0
SYS_TIME                                       89,821
USER_TIME                                     208,721
LOAD                                                0
RSRC_MGR_CPU_WAIT_TIME                              0
PHYSICAL_MEMORY_BYTES                          32,088
NUM_CPUS                                            2
          -------------------------------------------------------------

Service Statistics                     DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by DB Time

                                                             Physical    Logical
Service Name                      DB Time (s)   DB CPU (s)      Reads      Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS                             2,489.4      2,112.4    402,987 ##########
SYS$BACKGROUND                            0.0          0.0      6,752     84,088
sakai.ucdavis.edu                         0.0          0.0          0          0
sakaiXDB                                  0.0          0.0          0          0
          -------------------------------------------------------------

Service Wait Class Stats                DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Wait Class info for services in the Service Statistics section.
-> Total Waits and Time Waited displayed for the following wait
   classes:  User I/O, Concurrency, Administrative, Network
-> Time Waited (Wt Time) in centisecond (100th of a second)

Service Name
----------------------------------------------------------------
 User I/O  User I/O  Concurcy  Concurcy     Admin     Admin   Network   Network
Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time Total Wts   Wt Time
--------- --------- --------- --------- --------- --------- --------- ---------
SYS$USERS
   370115      5117       861       429         0         0  13394586     21249
SYS$BACKGROUND
     3886        74       180       630         0         0         0         0
          -------------------------------------------------------------

SQL ordered by Elapsed Time            DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------
       675        674      706,190        0.0    27.1 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

       149        147        1,196        0.1     6.0 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null

       131        129        1,626        0.1     5.3 22331rjyzgm79
Module: JDBC Thin Client
select coursesete0_.COURSEOFFERING_EID as COURSEOF1_0_, coursesete0_.COURSESET_E
ID as COURSESET2_0_ from BANNER_OFFERING_COURSESETS coursesete0_ where courseset
e0_.COURSEOFFERING_EID=:1

        62         62       60,092        0.0     2.5 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

        54         54       58,361        0.0     2.2 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

        54         53       16,635        0.0     2.2 20ux4jqcvrgps
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
 unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0

        53         53       59,171        0.0     2.1 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US

        49         49       53,068        0.0     2.0 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
 and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and

        43         43       43,259        0.0     1.7 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :
SQL ordered by Elapsed Time            DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

  Elapsed      CPU                  Elap per  % Total
  Time (s)   Time (s)  Executions   Exec (s)  DB Time    SQL Id
---------- ---------- ------------ ---------- ------- -------------

        28         20            1       28.4     1.1 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

        28         27        3,334        0.0     1.1 6p68587y4yccm
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin

        28         20            1       28.2     1.1 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|

        27         27        2,011        0.0     1.1 f9f27aadm1pr0
Module: JDBC Thin Client
select dbmembersh0_.ID as ID37_0_, openforumi1_.ID as ID34_1_, areaimpl2_.ID as
ID30_2_, permission3_.ID as ID38_3_, dbmembersh0_.VERSION as VERSION37_0_, dbmem
bersh0_.UUID as UUID37_0_, dbmembersh0_.CREATED as CREATED37_0_, dbmembersh0_.CR
EATED_BY as CREATED5_37_0_, dbmembersh0_.MODIFIED as MODIFIED37_0_, dbmembersh0_

          -------------------------------------------------------------

SQL ordered by CPU Time                DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------
       674        675      706,190        0.00    27.1 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

       147        149        1,196        0.12     6.0 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null

       129        131        1,626        0.08     5.3 22331rjyzgm79
Module: JDBC Thin Client
select coursesete0_.COURSEOFFERING_EID as COURSEOF1_0_, coursesete0_.COURSESET_E
ID as COURSESET2_0_ from BANNER_OFFERING_COURSESETS coursesete0_ where courseset
e0_.COURSEOFFERING_EID=:1

        62         62       60,092        0.00     2.5 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

        54         54       58,361        0.00     2.2 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

        53         54       16,635        0.00     2.2 20ux4jqcvrgps
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
 unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0

        53         53       59,171        0.00     2.1 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US

        49         49       53,068        0.00     2.0 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
 and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and

        43         43       43,259        0.00     1.7 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :
SQL ordered by CPU Time                DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
   into the Total Database Time multiplied by 100

    CPU      Elapsed                  CPU per  % Total
  Time (s)   Time (s)  Executions     Exec (s) DB Time    SQL Id
---------- ---------- ------------ ----------- ------- -------------

        27         28        3,334        0.01     1.1 6p68587y4yccm
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin

        27         27        2,011        0.01     1.1 f9f27aadm1pr0
Module: JDBC Thin Client
select dbmembersh0_.ID as ID37_0_, openforumi1_.ID as ID34_1_, areaimpl2_.ID as
ID30_2_, permission3_.ID as ID38_3_, dbmembersh0_.VERSION as VERSION37_0_, dbmem
bersh0_.UUID as UUID37_0_, dbmembersh0_.CREATED as CREATED37_0_, dbmembersh0_.CR
EATED_BY as CREATED5_37_0_, dbmembersh0_.MODIFIED as MODIFIED37_0_, dbmembersh0_

        20         28            1       19.64     1.1 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

        20         28            1       19.63     1.1 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|

          -------------------------------------------------------------

SQL ordered by Gets                    DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:     110,362,993
-> Captured SQL account for      87.0% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
    23,192,087      706,190         32.8   21.0   674.23    675.07 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

    15,756,145        1,196     13,174.0   14.3   146.85    149.06 03hnv0pt1nggn
Module: JDBC Thin Client
select SS.SESSION_ID from SAKAI_SESSION SS left join SAKAI_CLUSTER SC on SS.SESS
ION_SERVER = SC.SERVER_ID where SS.SESSION_START = SS.SESSION_END and SC.SERVER_
ID is null

    12,417,883        2,011      6,175.0   11.3    26.71     27.09 f9f27aadm1pr0
Module: JDBC Thin Client
select dbmembersh0_.ID as ID37_0_, openforumi1_.ID as ID34_1_, areaimpl2_.ID as
ID30_2_, permission3_.ID as ID38_3_, dbmembersh0_.VERSION as VERSION37_0_, dbmem
bersh0_.UUID as UUID37_0_, dbmembersh0_.CREATED as CREATED37_0_, dbmembersh0_.CR
EATED_BY as CREATED5_37_0_, dbmembersh0_.MODIFIED as MODIFIED37_0_, dbmembersh0_

     8,030,814        1,626      4,939.0    7.3   129.22    131.06 22331rjyzgm79
Module: JDBC Thin Client
select coursesete0_.COURSEOFFERING_EID as COURSEOF1_0_, coursesete0_.COURSESET_E
ID as COURSESET2_0_ from BANNER_OFFERING_COURSESETS coursesete0_ where courseset
e0_.COURSEOFFERING_EID=:1

     4,102,130       16,635        246.6    3.7    53.02     53.58 20ux4jqcvrgps
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
 unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0

     3,364,006        3,334      1,009.0    3.0    27.15     28.31 6p68587y4yccm
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin

     3,118,706       60,092         51.9    2.8    62.43     62.48 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

     2,789,121       58,361         47.8    2.5    53.69     53.79 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

     2,487,366       59,171         42.0    2.3    52.91     52.95 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US
SQL ordered by Gets                    DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:     110,362,993
-> Captured SQL account for      87.0% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------

     2,405,427       53,068         45.3    2.2    48.54     48.55 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
 and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and

     2,154,855       24,012         89.7    2.0    17.11     17.13 c6x6a16zphs25
Module: JDBC Thin Client
SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_FUNCTION.FUNCTION_NAME FROM SAKAI
_REALM_RL_FN INNER JOIN SAKAI_REALM ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_FN
.REALM_KEY AND SAKAI_REALM.REALM_ID = :1 INNER JOIN SAKAI_REALM_ROLE ON SAKAI_RE
ALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_FN.ROLE_KEY INNER JOIN SAKAI_REALM_FUNCTION O

     1,777,632       43,259         41.1    1.6    42.75     42.81 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :

     1,633,324        6,496        251.4    1.5    17.49     17.54 c3j0mtm1put5u
Module: JDBC Thin Client
select areaimpl0_.ID as ID30_0_, membership1_.ID as ID37_1_, areaimpl0_.VERSION
as VERSION30_0_, areaimpl0_.UUID as UUID30_0_, areaimpl0_.CREATED as CREATED30_0
_, areaimpl0_.CREATED_BY as CREATED5_30_0_, areaimpl0_.MODIFIED as MODIFIED30_0_
, areaimpl0_.MODIFIED_BY as MODIFIED7_30_0_, areaimpl0_.CONTEXT_ID as CONTEXT8_3

     1,486,827       45,811         32.5    1.3    10.20     10.20 c55kf9dj75jy4
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL
_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND
MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REAL
M_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where ( ROLES.ROLE_NAME in(

     1,421,670       18,463         77.0    1.3     5.62      5.62 6n5nww1af3q5h
Module: JDBC Thin Client
SELECT SAKAI_REALM_ROLE.ROLE_NAME, SAKAI_REALM_RL_GR.USER_ID, SAKAI_REALM_RL_GR.
ACTIVE, SAKAI_REALM_RL_GR.PROVIDED FROM SAKAI_REALM_RL_GR INNER JOIN SAKAI_REALM
 ON SAKAI_REALM.REALM_KEY = SAKAI_REALM_RL_GR.REALM_KEY AND SAKAI_REALM.REALM_ID
 = :1 INNER JOIN SAKAI_REALM_ROLE ON SAKAI_REALM_ROLE.ROLE_KEY = SAKAI_REALM_RL_

     1,361,646           18     75,647.0    1.2     5.97      5.98 gks5ryymzw06b
Module: JDBC Thin Client
SELECT OBJECT_NAME, OWNER, 'T' MYTYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABL
E' AND OBJECT_NAME NOT LIKE 'BIN$%' AND UPPER(OWNER) = 'SYS' UNION SELECT VIEW_N
AME, OWNER, 'V' MYTYPE FROM ALL_VIEWS WHERE UPPER(OWNER) = 'SYS'

     1,170,317      130,035          9.0    1.1     6.47      6.48 5r6vhfx4563bb
Module: JDBC Thin Client
select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SR
RG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = S
RR.ROLE_KEY where SR.REALM_ID = :1 and SRRG.USER_ID = :2 and SRRG.ACTIVE = '1'

          -------------------------------------------------------------

SQL ordered by Reads                   DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Disk Reads:         409,767
-> Captured SQL account for     40.3% of Total

                               Reads              CPU     Elapsed
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
        67,487       3,230          20.9   16.5     8.37     20.05 bkybw545h5vaj
Module: JDBC Thin Client
select sectioncmi0_.EID as EID248_, sectioncmi0_.CATEGORY as CATEGORY248_, secti
oncmi0_.TITLE as TITLE248_, sectioncmi0_.DESCRIPTION as DESCRIPT4_248_, sectionc
mi0_.CREATEDBY as CREATEDBY248_, sectioncmi0_.CREATEDDATE as CREATEDD6_248_, sec
tioncmi0_.LASTMODIFIEDBY as LASTMODI7_248_, sectioncmi0_.LASTMODIFIEDDATE as LAS

        56,959      53,683           1.1   13.9     9.17     10.99 5nrt9j3990q58
Module: JDBC Thin Client
select enrollment0_.EID as EID244_, enrollment0_.PERSON_EID as PERSON2_244_, enr
ollment0_.LASTMODIFIEDBY as LASTMODI3_244_, enrollment0_.LASTMODIFIEDDATE as LAS
TMODI4_244_, enrollment0_.CREATEDBY as CREATEDBY244_, enrollment0_.CREATEDDATE a
s CREATEDD6_244_, enrollment0_.ENROLLMENTSTATUS as ENROLLME7_244_, enrollment0_.

        10,812       3,230           3.3    2.6     2.56      8.32 6jqzv0wqt7xnn
Module: JDBC Thin Client
select sectioncmi0_.EID as EID248_, sectioncmi0_.CATEGORY as CATEGORY248_, secti
oncmi0_.TITLE as TITLE248_, sectioncmi0_.DESCRIPTION as DESCRIPT4_248_, sectionc
mi0_.CREATEDBY as CREATEDBY248_, sectioncmi0_.CREATEDDATE as CREATEDD6_248_, sec
tioncmi0_.LASTMODIFIEDBY as LASTMODI7_248_, sectioncmi0_.LASTMODIFIEDDATE as LAS

         3,665       7,185           0.5    0.9     7.23      7.23 dub7v8sr436fw
Module: JDBC Thin Client
select XML from ASSIGNMENT_SUBMISSION where CONTEXT = :1

         3,292     194,466           0.0    0.8    10.41     10.47 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )

         2,422           1       2,422.0    0.6    19.63     28.17 02knrk9hsp73t
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "SAKAI_EXTERNAL"."BANNER_MEETING" sele
ct distinct 'http://ucdavis.edu/course/section/meeting/'||bm.SSRMEET_TERM_CODE|
|'/'||bm.SSRMEET_CRN||'/'||bm.SSRMEET_BLDG_CODE||'/'||bm.SSRMEET_ROOM_CODE||'/'|
|bm.SSRMEET_BEGIN_TIME||'/'||bm.SSRMEET_END_TIME||'/'||bm.SSRMEET_CATAGORY||'/'|

         2,422           1       2,422.0    0.6    19.64     28.43 8k1vbt676gssy
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_MEETING"'); :mydat
e := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         2,220          24          92.5    0.5     8.36     10.98 fju4kkaxxx1nf
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN dbms_refresh.refresh('"SAKAI_EXTERNAL"."BANNER_INSTRUCTORS"'); :m
ydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

         2,052      58,361           0.0    0.5    53.69     53.79 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

         1,959     129,876           0.0    0.5     8.24      8.28 29gxrqhdg4yd6
Module: JDBC Thin Client
select XML from CONTENT_RESOURCE where ( RESOURCE_ID = :1 )

          -------------------------------------------------------------

SQL ordered by Executions              DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Executions:       3,288,782
-> Captured SQL account for     61.3% of Total

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
     706,190         706,188            1.0       0.00        0.00 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

     260,723         260,273            1.0       0.00        0.00 g15u20xaysjyr
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin

     194,466         170,819            0.9       0.00        0.00 786j30w6fn07f
Module: JDBC Thin Client
select XML from CONTENT_COLLECTION where ( COLLECTION_ID = :1 )

     130,035         130,035            1.0       0.00        0.00 5r6vhfx4563bb
Module: JDBC Thin Client
select SRR.ROLE_NAME from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR on SR
RG.REALM_KEY = SR.REALM_KEY inner join SAKAI_REALM_ROLE SRR on SRRG.ROLE_KEY = S
RR.ROLE_KEY where SR.REALM_ID = :1 and SRRG.USER_ID = :2 and SRRG.ACTIVE = '1'

     129,876         100,186            0.8       0.00        0.00 29gxrqhdg4yd6
Module: JDBC Thin Client
select XML from CONTENT_RESOURCE where ( RESOURCE_ID = :1 )

      60,092          60,092            1.0       0.00        0.00 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

      59,171          59,171            1.0       0.00        0.00 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
d (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and US

      58,361          58,361            1.0       0.00        0.00 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

      53,683          53,683            1.0       0.00        0.00 5nrt9j3990q58
Module: JDBC Thin Client
select enrollment0_.EID as EID244_, enrollment0_.PERSON_EID as PERSON2_244_, enr
ollment0_.LASTMODIFIEDBY as LASTMODI3_244_, enrollment0_.LASTMODIFIEDDATE as LAS
TMODI4_244_, enrollment0_.CREATEDBY as CREATEDBY244_, enrollment0_.CREATEDDATE a
s CREATEDD6_244_, enrollment0_.ENROLLMENTSTATUS as ENROLLME7_244_, enrollment0_.

      53,068          53,068            1.0       0.00        0.00 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
SQL ordered by Executions              DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Executions:       3,288,782
-> Captured SQL account for     61.3% of Total

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
 and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and

      45,811          45,811            1.0       0.00        0.00 c55kf9dj75jy4
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN MAINTABLE LEFT JOIN SAKAI_REALM_RL
_GR GRANTED_ROLES ON (MAINTABLE.REALM_KEY = GRANTED_ROLES.REALM_KEY AND
MAINTABLE.ROLE_KEY = GRANTED_ROLES.ROLE_KEY), SAKAI_REALM REALMS, SAKAI_REAL
M_ROLE ROLES, SAKAI_REALM_FUNCTION FUNCTIONS where ( ROLES.ROLE_NAME in(

      43,259          43,259            1.0       0.00        0.00 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :

          -------------------------------------------------------------

SQL ordered by Parse Calls             DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Parse Calls:         118,984
-> Captured SQL account for      40.3% of Total

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
      23,974       23,974     20.15 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL

       1,564        1,564      1.31 4m7m0t6fjcs5x
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache=
:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1

       1,171        1,171      0.98 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait

       1,171        1,171      0.98 g00cj285jmgsw
update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del
etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags
 + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob
j# = :objn

         915          915      0.77 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0

         626          626      0.53 2uunxrv2wj57b
update sum$ set containerobj#=:2,containertype=:3,containernam=:4,fullrefreshtim
=:5,increfreshtim=:6,lastrefreshscn=:7,lastrefreshdate=:8,refreshmode=:9,pflags=
:10,mflags=:11,numdetailtab=:12,numaggregates=:13,numkeycolumns=:14,numjoins=:15
,numinlines=:16,sumtextlen=:17,sumtext=:18,fromoffset=:19,fromlen=:20,objcount=:

         539        1,865      0.45 9ar2vv44swxvr
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

         535        2,033      0.45 5q1r2z4czhzh1
Module: JDBC Thin Client
update SAKAI_SESSION set SESSION_END = :1 where SESSION_ID = :2

         533        1,196      0.45 az3hmnt1dny3j
Module: JDBC Thin Client
select SERVER_ID from SAKAI_CLUSTER where SERVER_ID != :1 and UPDATE_TIME < (CUR
RENT_TIMESTAMP - 0.0069444445 )

         528          528      0.44 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0

          -------------------------------------------------------------

SQL ordered by Sharable Memory         DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)  Executions   % Total    SQL Id
---------------- ------------ -------- -------------
      39,905,796          N/A     4.96 0nmzn7vrra627
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8)) and FUNCT
ION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME =
:9) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1'

       7,833,724           41     0.97 dc6dj7p1ybyjh
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

       5,283,329       60,092     0.66 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

       4,502,596          124     0.56 camts4vh6qv7r
Module: JDBC Thin Client
update SAKAI_SITE set TITLE = :1,TYPE = :2,SHORT_DESC = :3,DESCRIPTION = :4,ICON
_URL = :5,INFO_URL = :6,SKIN = :7,PUBLISHED = :8,JOINABLE = :9,PUBVIEW = :10,JOI
N_ROLE = :11,IS_SPECIAL = :12,IS_USER = :13,CREATEDBY = :14,MODIFIEDBY = :15,CRE
ATEDON = :16,MODIFIEDON = :17,CUSTOM_PAGE_ORDERED = :18 where ( SITE_ID = :19 )

       2,321,014           29     0.29 b4db60sxry09y
Module: JDBC Thin Client
select gradingeve0_.ID as ID275_, gradingeve0_.GRADABLE_OBJECT_ID as GRADABLE2_2
75_, gradingeve0_.GRADER_ID as GRADER3_275_, gradingeve0_.STUDENT_ID as STUDENT4
_275_, gradingeve0_.DATE_GRADED as DATE5_275_, gradingeve0_.GRADE as GRADE275_ f
rom GB_GRADING_EVENT_T gradingeve0_ where gradingeve0_.GRADABLE_OBJECT_ID=:1 and

       2,274,676        1,637     0.28 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join

       2,207,852           25     0.27 7c5hgrz01137b
Module: JDBC Thin Client
select comment0_.ID as ID283_, comment0_.VERSION as VERSION283_, comment0_.GRADE
R_ID as GRADER3_283_, comment0_.STUDENT_ID as STUDENT4_283_, comment0_.COMMENT_T
EXT as COMMENT5_283_, comment0_.DATE_RECORDED as DATE6_283_, comment0_.GRADABLE_
OBJECT_ID as GRADABLE7_283_ from GB_COMMENT_T comment0_ where comment0_.GRADABLE

       1,731,901            7     0.22 dyw9r78qz1842
Module: JDBC Thin Client
update SAKAI_PERSON_T set VERSION=:1, UUID=:2, LAST_MODIFIED_BY=:3, LAST_MODIFIE
D_DATE=:4, CREATED_BY=:5, CREATED_DATE=:6, AGENT_UUID=:7, TYPE_UUID=:8, COMMON_N
AME=:9, DESCRIPTION=:10, SEE_ALSO=:11, STREET=:12, SURNAME=:13, TELEPHONE_NUMBER
=:14, FAX_NUMBER=:15, LOCALITY_NAME=:16, OU=:17, PHYSICAL_DELIVERY_OFFICE_NAME=:

       1,622,253       58,361     0.20 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
SQL ordered by Sharable Memory         DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)  Executions   % Total    SQL Id
---------------- ------------ -------- -------------
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

          -------------------------------------------------------------

SQL ordered by Version Count           DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
     755          N/A 0nmzn7vrra627
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8)) and FUNCT
ION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME =
:9) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1'

     490       58,361 9xmw3p1px195k
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5)) and FUNCTION_KEY i
n (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :6) and (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

     241           41 dc6dj7p1ybyjh
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

     229          124 camts4vh6qv7r
Module: JDBC Thin Client
update SAKAI_SITE set TITLE = :1,TYPE = :2,SHORT_DESC = :3,DESCRIPTION = :4,ICON
_URL = :5,INFO_URL = :6,SKIN = :7,PUBLISHED = :8,JOINABLE = :9,PUBVIEW = :10,JOI
N_ROLE = :11,IS_SPECIAL = :12,IS_USER = :13,CREATEDBY = :14,MODIFIEDBY = :15,CRE
ATEDON = :16,MODIFIEDON = :17,CUSTOM_PAGE_ORDERED = :18 where ( SITE_ID = :19 )

     212       43,259 0jf0d1wyx5vkb
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3)) and FUNCTION_KEY in (sel
ect FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :4) and (ROLE_K
EY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = :

     146       60,092 g0cahhj5pw9uf
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7,:8,:9)) and FU
NCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME
 = :10) and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE =

      83           29 b4db60sxry09y
Module: JDBC Thin Client
select gradingeve0_.ID as ID275_, gradingeve0_.GRADABLE_OBJECT_ID as GRADABLE2_2
75_, gradingeve0_.GRADER_ID as GRADER3_275_, gradingeve0_.STUDENT_ID as STUDENT4
_275_, gradingeve0_.DATE_GRADED as DATE5_275_, gradingeve0_.GRADE as GRADE275_ f
rom GB_GRADING_EVENT_T gradingeve0_ where gradingeve0_.GRADABLE_OBJECT_ID=:1 and

      83        1,637 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join

      83        1,637 f8066cv54zqb7
Module: JDBC Thin Client
select SRRG.USER_ID from SAKAI_REALM_RL_GR SRRG inner join SAKAI_REALM SR ON SRR
G.REALM_KEY = SR.REALM_KEY where SR.REALM_ID IN (:1,:2,:3) and SRRG.ACTIVE = '1
' and SRRG.ROLE_KEY in (select SRRF.ROLE_KEY from SAKAI_REALM_RL_FN SRRF inner j
SQL ordered by Version Count           DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
oin SAKAI_REALM_FUNCTION SRF ON SRRF.FUNCTION_KEY = SRF.FUNCTION_KEY inner join

      74          120 3hrf4q4yrr6ka
Module: JDBC Thin Client
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = :1 WHERE JOB_NAME = :2 AND JOB_GROUP =
:3 AND TRIGGER_STATE = :4

      69           25 7c5hgrz01137b
Module: JDBC Thin Client
select comment0_.ID as ID283_, comment0_.VERSION as VERSION283_, comment0_.GRADE
R_ID as GRADER3_283_, comment0_.STUDENT_ID as STUDENT4_283_, comment0_.COMMENT_T
EXT as COMMENT5_283_, comment0_.DATE_RECORDED as DATE6_283_, comment0_.GRADABLE_
OBJECT_ID as GRADABLE7_283_ from GB_COMMENT_T comment0_ where comment0_.GRADABLE

      57          227 bwht4rhzyb6nh
Module: JDBC Thin Client
update SAKAI_REALM set PROVIDER_ID = :1,MAINTAIN_ROLE = (select MAX(ROLE_KEY) fr
om SAKAI_REALM_ROLE where ROLE_NAME = :2),CREATEDBY = :3,MODIFIEDBY = :4,CREATED
ON = :5,MODIFIEDON = :6 where ( REALM_ID = :7 )

      52           23 9z4r824szyb5f
Module: JDBC Thin Client
insert into MFR_MESSAGE_T (VERSION, UUID, CREATED, CREATED_BY, MODIFIED, MODIFIE
D_BY, TITLE, BODY, AUTHOR, HAS_ATTACHMENTS, GRADECOMMENT, GRADEASSIGNMENTNAME, L
ABEL, IN_REPLY_TO, GRADEBOOK, GRADEBOOK_ASSIGNMENT, TYPE_UUID, APPROVED, DRAFT,
DELETED, surrogateKey, MESSAGE_DTYPE, ID) values (:1, :2, :3, :4, :5, :6, :7, :8

      43            2 2g69rythn19tc
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_ENROLLMENT enr where enr.PERSON_EID = '000000' and se
c.ENROLLMENTSET_EID = enr.ENROLLMENTSET_EID and enr.dropped=0

      43            2 5s8ka1shknpdr
Module: SQL*Plus
explain plan set statement_id='test1' for select sec.* from COURSEMANAGEMENT_SEC
TION sec, COURSEMANAGEMENT_INSTRUCTORS ins where ins.SECTION_EID = sec.EID and i
ns.PERSON_EID = '00166200'

      42            7 dyw9r78qz1842
Module: JDBC Thin Client
update SAKAI_PERSON_T set VERSION=:1, UUID=:2, LAST_MODIFIED_BY=:3, LAST_MODIFIE
D_DATE=:4, CREATED_BY=:5, CREATED_DATE=:6, AGENT_UUID=:7, TYPE_UUID=:8, COMMON_N
AME=:9, DESCRIPTION=:10, SEE_ALSO=:11, STREET=:12, SURNAME=:13, TELEPHONE_NUMBER
=:14, FAX_NUMBER=:15, LOCALITY_NAME=:16, OU=:17, PHYSICAL_DELIVERY_OFFICE_NAME=:

      39          127 fdja9g0p9m49n
Module: JDBC Thin Client
INSERT INTO SAKAI_REALM_RL_GR (REALM_KEY, USER_ID, ROLE_KEY, ACTIVE, PROVIDED) V
ALUES ( (SELECT REALM_KEY FROM SAKAI_REALM WHERE REALM_ID = :1), :2, (SELECT RO
LE_KEY FROM SAKAI_REALM_ROLE WHERE ROLE_NAME = :3), :4, :5)

      38           29 1szjknxf56j5c
Module: JDBC Thin Client
update MFR_OPEN_FORUM_T set VERSION=:1, UUID=:2, CREATED=:3, CREATED_BY=:4, MODI
FIED=:5, MODIFIED_BY=:6, DEFAULTASSIGNNAME=:7, TITLE=:8, SHORT_DESCRIPTION=:9, E
XTENDED_DESCRIPTION=:10, TYPE_UUID=:11, SORT_INDEX=:12, LOCKED=:13, DRAFT=:14, s
urrogateKey=:15, MODERATED=:16 where ID=:17 and VERSION=:18

      37      706,190 aby75s01s29un
SQL ordered by Version Count           DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Only Statements with Version Count greater than 20 are displayed

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

      37       53,068 crg92pss5xq3a
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6,:7)) and FUNCTION
_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :8)
 and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and

      29        2,758 8cmaff91xudg4
Module: JDBC Thin Client
select DISTINCT FUNCTION_NAME from SAKAI_REALM_FUNCTION SRF inner join SAKAI_REA
LM_RL_FN SRRF on SRF.FUNCTION_KEY = SRRF.FUNCTION_KEY inner join SAKAI_REALM_ROL
E SRR on SRRF.ROLE_KEY = SRR.ROLE_KEY inner join SAKAI_REALM SR on SRRF.REALM_KE
Y = SR.REALM_KEY where SRR.ROLE_NAME = :1 and SR.REALM_ID IN (:2,:3)

      27           56 g5zb5g33d48m1
Module: JDBC Thin Client
update SAKAI_PREFERENCES set XML = :1 where ( PREFERENCES_ID = :2 )

      26           48 b6gqns0qyhkj3
Module: JDBC Thin Client
update rwikiobject set version=:1, name=:2, realm=:3, referenced=:4, userid=:5,
owner=:6, ownerRead=:7, ownerWrite=:8, ownerAdmin=:9, groupRead=:10, groupWrite=
:11, groupAdmin=:12, publicRead=:13, publicWrite=:14, sha1=:15, revision=:16 whe
re id=:17 and version=:18

      25            4 8qsfufqdcygru
Module: JDBC Thin Client
DELETE FROM SAKAI_REALM_RL_GR WHERE REALM_KEY IN (SELECT REALM_KEY FROM SAKAI_RE
ALM WHERE REALM_ID = :1) AND ROLE_KEY IN (SELECT ROLE_KEY FROM SAKAI_REALM_ROLE
WHERE ROLE_NAME = :2) AND USER_ID = :3 AND ACTIVE = :4 AND PROVIDED = :5

      24        2,593 9vfd0br7guzvm
Module: JDBC Thin Client
select count(*) as col_0_0_ from MFR_MESSAGE_T messageimp0_, MFR_UNREAD_STATUS_T
 unreadstat1_ where messageimp0_.surrogateKey=:1 and unreadstat1_.USER_C=:2 and
messageimp0_.ID=unreadstat1_.MESSAGE_C and unreadstat1_.READ_C=1 and messageimp0
_.DRAFT=0 and messageimp0_.DELETED=0 and (messageimp0_.APPROVED=1 or messageimp0

          -------------------------------------------------------------

Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session                    208,050           14.4           7.5
CPU used when call started                  203,258           14.1           7.3
CR blocks created                               155            0.0           0.0
Cached Commit SCN referenced                    485            0.0           0.0
Commit SCN cached                                14            0.0           0.0
DB time                                   3,310,858          229.8         118.6
DBWR checkpoint buffers written               7,807            0.5           0.3
DBWR checkpoints                                  0            0.0           0.0
DBWR object drop buffers written                  0            0.0           0.0
DBWR revisited being-written buf                  0            0.0           0.0
DBWR tablespace checkpoint buffe                  0            0.0           0.0
DBWR thread checkpoint buffers w              7,807            0.5           0.3
DBWR transaction table writes                   128            0.0           0.0
DBWR undo block writes                        9,989            0.7           0.4
IMU CR rollbacks                                 69            0.0           0.0
IMU Flushes                                   8,369            0.6           0.3
IMU Redo allocation size                 14,351,872          996.2         514.1
IMU commits                                  22,173            1.5           0.8
IMU contention                                   26            0.0           0.0
IMU ktichg flush                                 69            0.0           0.0
IMU pool not allocated                            0            0.0           0.0
IMU recursive-transaction flush                  82            0.0           0.0
IMU undo allocation size                 53,790,748        3,733.9       1,926.8
IMU- failed to get a private str                  0            0.0           0.0
SMON posted for dropping temp se                  0            0.0           0.0
SMON posted for undo segment rec                  0            0.0           0.0
SMON posted for undo segment shr                  0            0.0           0.0
SQL*Net roundtrips to/from clien          8,907,357          618.3         319.1
SQL*Net roundtrips to/from dblin            262,590           18.2           9.4
active txn count during cleanout              2,738            0.2           0.1
application wait time                            10            0.0           0.0
background checkpoints completed                  1            0.0           0.0
background checkpoints started                    0            0.0           0.0
background timeouts                          46,278            3.2           1.7
branch node splits                                6            0.0           0.0
buffer is not pinned count               45,926,069        3,188.0       1,645.1
buffer is pinned count                   49,443,194        3,432.1       1,771.1
bytes received via SQL*Net from       5,110,818,931      354,768.8     183,071.9
bytes received via SQL*Net from          29,912,085        2,076.4       1,071.5
bytes sent via SQL*Net to client      9,687,192,945      672,438.9     346,999.8
bytes sent via SQL*Net to dblink         16,683,871        1,158.1         597.6
calls to get snapshot scn: kcmgs          7,444,590          516.8         266.7
calls to kcmgas                              36,149            2.5           1.3
calls to kcmgcs                               4,148            0.3           0.2
change write time                               342            0.0           0.0
cleanout - number of ktugct call              3,228            0.2           0.1
cleanouts and rollbacks - consis                 41            0.0           0.0
cleanouts only - consistent read                174            0.0           0.0
cluster key scan block gets                  20,556            1.4           0.7
cluster key scans                             1,762            0.1           0.1
commit batch performed                          208            0.0           0.0
commit batch requested                          208            0.0           0.0
commit batch/immediate performed                221            0.0           0.0
commit batch/immediate requested                221            0.0           0.0
commit cleanout failures: block                  68            0.0           0.0
commit cleanout failures: buffer                  0            0.0           0.0
commit cleanout failures: callba                106            0.0           0.0
commit cleanout failures: cannot                  7            0.0           0.0
commit cleanouts                            102,904            7.1           3.7
commit cleanouts successfully co            102,723            7.1           3.7
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed                       13            0.0           0.0
commit immediate requested                       13            0.0           0.0
commit txn count during cleanout              4,397            0.3           0.2
concurrency wait time                         1,059            0.1           0.0
consistent changes                            2,088            0.1           0.1
consistent gets                         109,490,148        7,600.3       3,922.0
consistent gets - examination            33,566,616        2,330.0       1,202.4
consistent gets direct                      122,110            8.5           4.4
consistent gets from cache              109,368,038        7,591.8       3,917.6
current blocks converted for CR                   0            0.0           0.0
cursor authentications                          712            0.1           0.0
data blocks consistent reads - u                220            0.0           0.0
db block changes                            626,677           43.5          22.5
db block gets                               872,845           60.6          31.3
db block gets direct                            816            0.1           0.0
db block gets from cache                    872,029           60.5          31.2
deferred (CURRENT) block cleanou             44,363            3.1           1.6
dirty buffers inspected                      29,888            2.1           1.1
enqueue conversions                           6,915            0.5           0.3
enqueue releases                            258,868           18.0           9.3
enqueue requests                            258,956           18.0           9.3
enqueue timeouts                                 94            0.0           0.0
enqueue waits                                     2            0.0           0.0
exchange deadlocks                                0            0.0           0.0
execute count                             3,288,782          228.3         117.8
failed probes on index block rec                  0            0.0           0.0
frame signature mismatch                          0            0.0           0.0
free buffer inspected                       464,540           32.3          16.6
free buffer requested                       296,089           20.6          10.6
heap block compress                           3,402            0.2           0.1
hot buffers moved to head of LRU            817,719           56.8          29.3
immediate (CR) block cleanout ap                215            0.0           0.0
immediate (CURRENT) block cleano             11,298            0.8           0.4
index crx upgrade (found)                       237            0.0           0.0
index crx upgrade (positioned)            4,154,120          288.4         148.8
index fast full scans (full)                     17            0.0           0.0
index fetch by key                       12,618,328          875.9         452.0
index scans kdiixs1                      22,809,248        1,583.3         817.0
leaf node 90-10 splits                          164            0.0           0.0
leaf node splits                                538            0.0           0.0
lob reads                                    74,511            5.2           2.7
lob writes                                    5,374            0.4           0.2
lob writes unaligned                          4,637            0.3           0.2
logons cumulative                               694            0.1           0.0
messages received                            33,703            2.3           1.2
messages sent                                33,703            2.3           1.2
no buffer to keep pinned count                    0            0.0           0.0
no work - consistent read gets           71,296,436        4,949.1       2,553.9
opened cursors cumulative                   120,193            8.3           4.3
parse count (failures)                          261            0.0           0.0
parse count (hard)                              826            0.1           0.0
parse count (total)                         118,984            8.3           4.3
parse time cpu                                  734            0.1           0.0
parse time elapsed                            4,864            0.3           0.2
physical read IO requests                   393,219           27.3          14.1
physical read bytes                   3,356,811,264      233,013.9     120,242.6
physical read total IO requests             409,599           28.4          14.7
physical read total bytes             3,623,116,800      251,499.6     129,781.7
physical read total multi block               3,127            0.2           0.1
physical reads                              409,767           28.4          14.7
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache                        286,263           19.9          10.3
physical reads cache prefetch                34,067            2.4           1.2
physical reads direct                       123,504            8.6           4.4
physical reads direct (lob)                 121,183            8.4           4.3
physical reads direct temporary               1,710            0.1           0.1
physical reads prefetch warmup                    0            0.0           0.0
physical write IO requests                   29,981            2.1           1.1
physical write bytes                    395,952,128       27,485.1      14,183.2
physical write total IO requests             97,820            6.8           3.5
physical write total bytes              924,112,896       64,147.5      33,102.2
physical write total multi block             59,536            4.1           2.1
physical writes                              48,334            3.4           1.7
physical writes direct                        2,533            0.2           0.1
physical writes direct (lob)                    816            0.1           0.0
physical writes direct temporary              1,710            0.1           0.1
physical writes from cache                   45,801            3.2           1.6
physical writes non checkpoint               42,472            3.0           1.5
pinned buffers inspected                         20            0.0           0.0
prefetch clients - default                        0            0.0           0.0
prefetch warmup blocks aged out                   0            0.0           0.0
prefetched blocks aged out befor              1,720            0.1           0.1
process last non-idle time                   12,263            0.9           0.4
recovery blocks read                              0            0.0           0.0
recursive calls                           1,217,450           84.5          43.6
recursive cpu usage                           5,690            0.4           0.2
redo blocks read for recovery                     0            0.0           0.0
redo blocks written                         286,870           19.9          10.3
redo buffer allocation retries                    0            0.0           0.0
redo entries                                230,696           16.0           8.3
redo log space requests                           0            0.0           0.0
redo log space wait time                          0            0.0           0.0
redo ordering marks                               0            0.0           0.0
redo size                               134,726,776        9,352.1       4,826.0
redo synch time                              35,224            2.5           1.3
redo synch writes                           787,266           54.7          28.2
redo wastage                              7,505,524          521.0         268.9
redo write time                              34,511            2.4           1.2
redo writer latching time                         2            0.0           0.0
redo writes                                  28,318            2.0           1.0
rollback changes - undo records                  95            0.0           0.0
rollbacks only - consistent read                104            0.0           0.0
rows fetched via callback                10,388,551          721.1         372.1
session connect time                              0            0.0           0.0
session cursor cache hits                    45,301            3.1           1.6
session logical reads                   110,362,993        7,660.9       3,953.3
session pga memory                      309,049,692       21,452.8      11,070.3
session pga memory max                  464,974,288       32,276.3      16,655.6
session uga memory                  932,036,019,064   64,697,514.7  33,385,966.2
session uga memory max                  462,370,552       32,095.6      16,562.3
shared hash latch upgrades - no           4,272,972          296.6         153.1
shared hash latch upgrades - wai                237            0.0           0.0
sorts (disk)                                      0            0.0           0.0
sorts (memory)                              145,970           10.1           5.2
sorts (rows)                              1,393,063           96.7          49.9
sql area evicted                                 12            0.0           0.0
sql area purged                                 261            0.0           0.0
summed dirty queue length                    31,102            2.2           1.1
switch current to new buffer                  1,829            0.1           0.1
table fetch by rowid                     30,856,453        2,141.9       1,105.3
table fetch continued row                   234,997           16.3           8.4
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
table scan blocks gotten                 30,186,941        2,095.4       1,081.3
table scan rows gotten                1,884,066,173      130,782.9      67,488.1
table scans (long tables)                        20            0.0           0.0
table scans (short tables)                   89,507            6.2           3.2
total number of times SMON poste                 96            0.0           0.0
transaction rollbacks                           221            0.0           0.0
transaction tables consistent re                  0            0.0           0.0
transaction tables consistent re                  0            0.0           0.0
undo change vector size                  41,463,176        2,878.2       1,485.2
user I/O wait time                            5,194            0.4           0.2
user calls                                8,999,556          624.7         322.4
user commits                                 27,646            1.9           1.0
user rollbacks                                  271            0.0           0.0
workarea executions - onepass                     2            0.0           0.0
workarea executions - optimal               124,755            8.7           4.5
write clones created in backgrou                  0            0.0           0.0
write clones created in foregrou                 18            0.0           0.0
          -------------------------------------------------------------

Instance Activity Stats - Absolute ValuesDB/Inst: SAKAI/sakai  Snaps: 3283-32
-> Statistics with absolute values (should not be diffed)

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
session cursor cache count               435,603         447,723
opened cursors current                     9,825          13,083
logons current                             1,036           1,029
          -------------------------------------------------------------

Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai  Snaps: 3283-328
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                            0       .00
          -------------------------------------------------------------

Tablespace IO Stats                    DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                       Av     Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DATA_TS
       387,376      27    0.1     1.0       26,592        2          3    0.0
SYSAUX
         3,288       0    0.2     1.6          869        0          0    0.0
SYSTEM
         2,383       0    0.1     2.6          454        0          8    6.3
UNDOTBS1
            21       0    0.0     1.0        1,947        0          1    0.0
TEMP2
           114       0   16.7    15.0          114        0          0    0.0
TEMP
             0       0    0.0     N/A            3        0          0    0.0
ARCH_TS
             1       0    0.0     1.0            1        0          0    0.0
INDEX_TS
             1       0    0.0     1.0            1        0          0    0.0
          -------------------------------------------------------------

File IO Stats                          DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                       Av     Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ARCH_TS                  /local/d02/oracle/sakai/arch01.dbf
             1       0    0.0     1.0            1        0          0    0.0
DATA_TS                  /local/d02/oracle/sakai/data01.dbf
       235,556      16    0.1     1.0       22,769        2          2    0.0
DATA_TS                  /local/d02/oracle/sakai/data02.dbf
       151,820      11    0.2     1.0        3,823        0          1    0.0
INDEX_TS                 /local/d02/oracle/sakai/index01.dbf
             1       0    0.0     1.0            1        0          0    0.0
SYSAUX                   /local/d02/oracle/sakai/sysaux01.dbf
         3,288       0    0.2     1.6          869        0          0    0.0
SYSTEM                   /local/d02/oracle/sakai/system01.dbf
         2,383       0    0.1     2.6          454        0          8    6.3
TEMP                     /local/d02/oracle/sakai/temp01.dbf
             0       0    N/A     N/A            1        0          0    N/A
TEMP                     /local/d02/oracle/sakai/temp02.dbf
             0       0    N/A     N/A            2        0          0    N/A
TEMP2                    /local/d03/oracle/sakai/temp03.dbf
           114       0   16.7    15.0          114        0          0    N/A
UNDOTBS1                 /local/d02/oracle/sakai/undotbs01.dbf
            21       0    0.0     1.0        1,947        0          1    0.0
          -------------------------------------------------------------

Buffer Pool Statistics                 DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                            Free Writ     Buffer
     Number of Pool         Buffer     Physical    Physical Buff Comp       Busy
P      Buffers Hit%           Gets        Reads      Writes Wait Wait      Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D       84,600  100    110,237,488      286,260      45,801    0    0         12
          -------------------------------------------------------------

Instance Recovery Stats                 DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> B: Begin snapshot,  E: End snapshot

  Targt  Estd                                  Log File Log Ckpt     Log Ckpt
  MTTR   MTTR   Recovery  Actual    Target       Size    Timeout     Interval
   (s)    (s)   Estd IOs Redo Blks Redo Blks  Redo Blks Redo Blks   Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B     0     0       9167    122171    121890     737280    121890          N/A
E     0     0       2053     28754     28486     737280     28486          N/A
          -------------------------------------------------------------

Buffer Pool Advisory                          DB/Inst: SAKAI/sakai  Snap: 3287
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate

                                        Est
                                       Phys
    Size for   Size      Buffers for   Read          Estimated
P    Est (M) Factor         Estimate Factor     Physical Reads
--- -------- ------ ---------------- ------ ------------------
D         64     .1            7,996    1.6        609,514,845
D        128     .2           15,992    1.4        524,031,588
D        192     .3           23,988    1.2        462,695,989
D        256     .4           31,984    1.1        427,635,259
D        320     .5           39,980    1.1        404,495,339
D        384     .6           47,976    1.0        390,850,898
D        448     .7           55,972    1.0        382,769,502
D        512     .7           63,968    1.0        378,692,216
D        576     .8           71,964    1.0        377,082,278
D        640     .9           79,960    1.0        376,393,877
D        688    1.0           85,957    1.0        376,205,959
D        704    1.0           87,956    1.0        376,144,068
D        768    1.1           95,952    1.0        375,971,067
D        832    1.2          103,948    1.0        375,841,762
D        896    1.3          111,944    1.0        375,745,604
D        960    1.4          119,940    1.0        375,669,232
D      1,024    1.5          127,936    1.0        375,605,841
D      1,088    1.6          135,932    1.0        375,550,992
D      1,152    1.7          143,928    1.0        375,505,588
D      1,216    1.8          151,924    1.0        375,436,228
D      1,280    1.9          159,920    1.0        375,393,722
          -------------------------------------------------------------

PGA Aggr Summary                       DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %   W/A MB Processed  Extra W/A MB Read/Written
--------------- ------------------ --------------------------
           99.6              7,968                         35
          -------------------------------------------------------------

PGA Aggr Target Stats                   DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> B: Begin snap   E: End snap (rows dentified with B or E contain data
   which is absolute i.e. not diffed over the interval)
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used    - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem    - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem   - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem    - percentage of workarea memory under manual control

                                                %PGA  %Auto   %Man
    PGA Aggr   Auto PGA   PGA Mem    W/A PGA     W/A    W/A    W/A Global Mem
   Target(M)  Target(M)  Alloc(M)    Used(M)     Mem    Mem    Mem   Bound(K)
- ---------- ---------- ---------- ---------- ------ ------ ------ ----------
B        800        340      709.4        0.0     .0     .0     .0    102,400
E        800        331      727.8        0.0     .0     .0     .0    102,400
          -------------------------------------------------------------

PGA Aggr Target Histogram               DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Optimal Executions are purely in-memory operations

  Low     High
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K        113,419        113,419            0            0
    64K    128K          1,107          1,107            0            0
   128K    256K            586            586            0            0
   256K    512K            692            692            0            0
   512K   1024K          7,034          7,034            0            0
     1M      2M          1,908          1,908            0            0
     2M      4M              4              4            0            0
     8M     16M              4              4            0            0
    16M     32M              2              0            2            0
          -------------------------------------------------------------

PGA Memory Advisory                           DB/Inst: SAKAI/sakai  Snap: 3287
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
   where Estd PGA Overalloc Count is 0

                                       Estd Extra    Estd PGA   Estd PGA
PGA Target    Size           W/A MB   W/A MB Read/      Cache  Overalloc
  Est (MB)   Factr        Processed Written to Disk     Hit %      Count
---------- ------- ---------------- ---------------- -------- ----------
       100     0.1        422,885.6         59,916.5     88.0      2,640
       200     0.3        422,885.6         59,878.6     88.0      2,640
       400     0.5        422,885.6         53,367.5     89.0      2,502
       600     0.8        422,885.6         37,945.5     92.0      1,350
       800     1.0        422,885.6          3,940.8     99.0          0
       960     1.2        422,885.6          3,784.4     99.0          0
     1,120     1.4        422,885.6          3,784.4     99.0          0
     1,280     1.6        422,885.6          3,784.4     99.0          0
     1,440     1.8        422,885.6          3,784.4     99.0          0
     1,600     2.0        422,885.6          3,784.4     99.0          0
     2,400     3.0        422,885.6          3,784.4     99.0          0
     3,200     4.0        422,885.6          3,784.4     99.0          0
     4,800     6.0        422,885.6          3,784.4     99.0          0
     6,400     8.0        422,885.6          3,784.4     99.0          0
          -------------------------------------------------------------

Shared Pool Advisory                         DB/Inst: SAKAI/sakai  Snap: 3287
-> SP: Shared Pool     Est LC: Estimated Library Cache   Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
   in the Library Cache, and the physical number of memory objects associated
   with it.  Therefore comparing the number of Lib Cache objects (e.g. in
   v$librarycache), with the number of Lib Cache Memory Objects is invalid.

                                        Est LC Est LC  Est LC Est LC
    Shared    SP   Est LC                 Time   Time    Load   Load      Est LC
      Pool  Size     Size       Est LC   Saved  Saved    Time   Time         Mem
   Size(M) Factr      (M)      Mem Obj     (s)  Factr     (s)  Factr    Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       288    .4       89        8,432 #######    1.0 #######   48.6  30,714,337
       368    .5      165       11,433 #######    1.0 #######   31.9  30,739,090
       448    .6      244       14,991 #######    1.0  90,011   20.6  30,756,575
       528    .7      322       17,808 #######    1.0  55,560   12.7  30,768,548
       608    .8      401       20,662 #######    1.0  34,724    8.0  30,775,540
       688    .9      480       25,196 #######    1.0  17,205    3.9  30,779,939
       768   1.0      559       29,081 #######    1.0   4,367    1.0  30,782,522
       848   1.1      638       32,775 #######    1.0       1     .0  30,784,613
       928   1.2      717       38,592 #######    1.0       1     .0  30,786,430
     1,008   1.3      796       42,554 #######    1.0       1     .0  30,788,076
     1,088   1.4      875       46,215 #######    1.0       1     .0  30,789,632
     1,168   1.5      939       51,208 #######    1.0       1     .0  30,791,131
     1,248   1.6      939       51,208 #######    1.0       1     .0  30,792,567
     1,328   1.7    1,017       54,765 #######    1.0       1     .0  30,794,035
     1,408   1.8    1,089       58,100 #######    1.0       1     .0  30,795,460
     1,488   1.9    1,089       58,100 #######    1.0       1     .0  30,796,883
     1,568   2.0    1,089       58,100 #######    1.0       1     .0  30,798,307
          -------------------------------------------------------------

SGA Target Advisory                           DB/Inst: SAKAI/sakai  Snap: 3287

SGA Target   SGA Size       Est DB     Est Physical
  Size (M)     Factor     Time (s)            Reads
---------- ---------- ------------ ----------------
       752        0.5      369,053      522,812,707
     1,128        0.8      275,827      403,555,581
     1,504        1.0      261,944      376,205,445
     1,880        1.3      261,446      374,738,244
     2,256        1.5      261,368      374,512,520
     2,632        1.8      261,368      374,512,520
     3,008        2.0      261,368      374,512,520
          -------------------------------------------------------------

Streams Pool Advisory                         DB/Inst: SAKAI/sakai  Snap: 3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Java Pool Advisory                            DB/Inst: SAKAI/sakai  Snap: 3287

                                        Est LC Est LC  Est LC Est LC
      Java    JP   Est LC                 Time   Time    Load   Load      Est LC
      Pool  Size     Size       Est LC   Saved  Saved    Time   Time         Mem
   Size(M) Factr      (M)      Mem Obj     (s)  Factr     (s)  Factr    Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
        16   1.0        2           76       1    1.0   4,367    1.0          76
        32   2.0        2           76       1    1.0   4,367    1.0          76
          -------------------------------------------------------------

Buffer Wait Statistics                  DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by wait time desc, waits desc

Class                    Waits Total Wait Time (s)  Avg Time (ms)
------------------ ----------- ------------------- --------------
data block                  11                   0              5
undo header                  1                   0              0
          -------------------------------------------------------------

Enqueue Activity                       DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)
------------------------------------------------------------------------------
    Requests    Succ Gets Failed Gets       Waits  Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
TX-Transaction (row lock contention)
           2            2           0           2            0            .00
          -------------------------------------------------------------

Undo Segment Summary                   DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count,  OOS - Out of Space count
-> Undo segment block stats:
-> uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
-> eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo   Num Undo       Number of  Max Qry   Max Tx Min/Max   STO/     uS/uR/uU/
 TS# Blocks (K)    Transactions  Len (s) Concurcy TR (mins) OOS      eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
   1        5.7          32,371    1,994        8 5760/5760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Undo Segment Stats                      DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Most recent 35 Undostat rows, ordered by Time desc

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/    uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS     eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
09-Oct 14:00         293        1,749      67       3   5,760 0/0   0/0/0/0/0/0
09-Oct 13:50         194        1,174   1,994       4   5,760 0/0   0/0/0/0/0/0
09-Oct 13:40         126        1,030   1,393       8   5,760 0/0   0/0/0/0/0/0
09-Oct 13:30         132        1,128     791       2   5,760 0/0   0/0/0/0/0/0
09-Oct 13:20         186        1,644   1,151       7   5,760 0/0   0/0/0/0/0/0
09-Oct 13:10         207        1,397     372       6   5,760 0/0   0/0/0/0/0/0
09-Oct 13:00         152        1,259     312       3   5,760 0/0   0/0/0/0/0/0
09-Oct 12:50         231        1,534      62       5   5,760 0/0   0/0/0/0/0/0
09-Oct 12:40         185        1,287     657       8   5,760 0/0   0/0/0/0/0/0
09-Oct 12:30         114          953     113       3   5,760 0/0   0/0/0/0/0/0
09-Oct 12:20         140        1,273     454       4   5,760 0/0   0/0/0/0/0/0
09-Oct 12:10         195        1,150   1,399       8   5,760 0/0   0/0/0/0/0/0
09-Oct 12:00         195        1,227     798       3   5,760 0/0   0/0/0/0/0/0
09-Oct 11:50         240        1,376     195       4   5,760 0/0   0/0/0/0/0/0
09-Oct 11:40         200        1,240       0       8   5,760 0/0   0/0/0/0/0/0
09-Oct 11:30         113          946     869       2   5,760 0/0   0/0/0/0/0/0
09-Oct 11:20         161        1,302     357       5   5,760 0/0   0/0/0/0/0/0
09-Oct 11:10         188        1,536     164       8   5,760 0/0   0/0/0/0/0/0
09-Oct 11:00         288        1,994     263       3   5,760 0/0   0/0/0/0/0/0
09-Oct 10:50         190        1,403       0       5   5,760 0/0   0/0/0/0/0/0
09-Oct 10:40         252        1,505     247       7   5,760 0/0   0/0/0/0/0/0
09-Oct 10:30         113        1,091     298       2   5,760 0/0   0/0/0/0/0/0
09-Oct 10:20         130        1,248     141       7   5,760 0/0   0/0/0/0/0/0
09-Oct 10:10       1,461        1,925     598       8   5,760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Latch Activity                         DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch               9,529    0.0    N/A      0            0    N/A
AWR Alerted Metric Eleme        318,696    0.0    N/A      0            0    N/A
Consistent RBA                   28,318    0.0    N/A      0            0    N/A
FAL request queue                   288    0.0    N/A      0            0    N/A
FAL subheap alocation               288    0.0    N/A      0            0    N/A
FOB s.o list latch                1,352    0.0    N/A      0            0    N/A
In memory undo latch            217,226    0.0    0.6      0       39,171    0.0
JS mem alloc latch                   19    0.0    N/A      0            0    N/A
JS queue access latch                19    0.0    N/A      0            0    N/A
JS queue state obj latch        104,068    0.0    N/A      0            0    N/A
JS slv state obj latch              547    0.0    N/A      0            0    N/A
KMG MMAN ready and start          4,801    0.0    N/A      0            0    N/A
KTF sga latch                        27    0.0    N/A      0        4,144    0.0
KWQMN job cache list lat             64    0.0    N/A      0            0    N/A
MQL Tracking Latch                    0    N/A    N/A      0          288    0.0
Memory Management Latch               0    N/A    N/A      0        4,801    0.0
OS process                        2,490    0.0    N/A      0            0    N/A
OS process allocation             6,454    0.0    N/A      0            0    N/A
OS process: request allo            961    0.0    N/A      0            0    N/A
PL/SQL warning settings           2,832    0.0    N/A      0            0    N/A
SGA IO buffer pool latch            177    0.0    N/A      0          209    0.0
SQL memory manager latch              4    0.0    N/A      0        4,764    0.0
SQL memory manager worka      8,596,595    0.0    0.1      0            0    N/A
Shared B-Tree                       560    0.0    N/A      0            0    N/A
active checkpoint queue           7,667    0.0    N/A      0            0    N/A
active service list              36,265    0.0    N/A      0        4,824    0.0
archive control                   1,480    0.0    N/A      0            0    N/A
archive process latch             5,052    0.0    N/A      0            0    N/A
begin backup scn array              813    0.0    N/A      0            0    N/A
cache buffer handles          4,515,950    0.0    0.0      0            0    N/A
cache buffers chains        189,126,618    0.0    0.0      0      424,554    0.0
cache buffers lru chain         392,874    0.0    0.2      0       90,868    0.0
cache table scan latch                0    N/A    N/A      0        1,847    0.0
channel handle pool latc          1,099    0.0    N/A      0            0    N/A
channel operations paren         69,627    0.0    N/A      0            0    N/A
checkpoint queue latch          140,177    0.0    N/A      0       32,644    0.0
client/application info             298    0.0    N/A      0            0    N/A
commit callback allocati            513    0.0    N/A      0            0    N/A
compile environment latc      1,008,728    0.0    0.0      0            0    N/A
constraint object alloca            417    0.0    N/A      0            0    N/A
dml lock allocation             136,519    0.0    0.0      0            0    N/A
dummy allocation                  1,395    0.0    N/A      0            0    N/A
enqueue hash chains             524,729    0.0    0.1      0          345    0.0
enqueues                      1,320,994    0.0    0.2      0            0    N/A
event group latch                   477    0.0    N/A      0            0    N/A
file cache latch                    681    0.0    N/A      0            0    N/A
global KZLD latch for me            304    0.0    N/A      0            0    N/A
global tx hash mapping            7,880    0.0    N/A      0            0    N/A
hash table column usage             500    0.0    N/A      0       46,301    0.0
hash table modification             386    0.0    N/A      0            0    N/A
job workq parent latch                0    N/A    N/A      0          360    0.0
job_queue_processes para            328    0.0    N/A      0            0    N/A
kks stats                           743    0.0    N/A      0            0    N/A
kmcptab latch                         1    0.0    N/A      0            0    N/A
kmcpvec latch                         0    N/A    N/A      0            1    0.0
ksuosstats global area              968    0.0    N/A      0            0    N/A
ktm global data                     111    0.0    N/A      0            0    N/A
kwqbsn:qsga                         560    0.0    N/A      0            0    N/A
lgwr LWN SCN                     30,878    0.0    0.0      0            0    N/A
library cache                 1,779,518    0.0    0.2      0            0    N/A
Latch Activity                         DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
   willing-to-wait latch get requests
-> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
-> "Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                                    Get    Get   Slps   Time       NoWait NoWait
Latch Name                     Requests   Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
library cache load lock             750    0.0    N/A      0            4    0.0
library cache lock              371,851    0.0    0.0      0            0    N/A
library cache lock alloc         10,923    0.0    0.0      0            0    N/A
library cache pin               134,510    0.0    0.5      0            0    N/A
library cache pin alloca          2,283    0.0    0.0      0            0    N/A
list of block allocation          3,335    0.0    N/A      0            0    N/A
loader state object free        137,808    0.0    N/A      0            0    N/A
message pool operations             218    0.0    N/A      0            0    N/A
messages                        193,801    0.0    0.0      0            0    N/A
mostly latch-free SCN            30,823    0.0    N/A      0            0    N/A
multiblock read objects          27,984    0.0    N/A      0            0    N/A
ncodef allocation latch             230    0.0    N/A      0            0    N/A
object queue header heap          9,016    0.0    N/A      0        1,370    0.0
object queue header oper        733,068    0.0    0.2      0            0    N/A
object stats modificatio            179    0.0    N/A      0            0    N/A
parallel query alloc buf          1,904    0.0    N/A      0            0    N/A
parameter table allocati          1,126    0.0    N/A      0            0    N/A
post/wait queue                  69,495    0.0    N/A      0       27,688    0.0
process allocation                  961    0.0    N/A      0          477    0.0
process group creation              961    0.0    N/A      0            0    N/A
qmn task queue latch              2,048    0.0    N/A      0            0    N/A
redo allocation                 368,156    0.0    0.0      0            0    N/A
redo copy                             0    N/A    N/A      0      230,679    0.0
redo writing                    102,200    0.0    N/A      0            0    N/A
row cache objects            25,794,299    0.0    0.1      0            0    N/A
sequence cache                   97,151    0.0    N/A      0            0    N/A
session allocation            2,057,669    0.0    0.2      0            0    N/A
session idle bit             19,006,692    0.0    0.1      0            0    N/A
session state list latch          1,801    0.6    0.8      0            0    N/A
session switching                   230    0.0    N/A      0            0    N/A
session timer                     4,824    0.0    N/A      0            0    N/A
shared pool                      83,593    0.1    0.0      0            0    N/A
shared pool sim alloc                10    0.0    N/A      0            0    N/A
shared pool simulator            14,821    0.0    N/A      0            0    N/A
simulator hash latch          5,046,089    0.0    1.0      0            0    N/A
simulator lru latch           5,016,335    0.1    0.1      0       21,112    0.0
slave class                           8    0.0    N/A      0            0    N/A
slave class create                   32   12.5    1.0      0            0    N/A
sort extent pool                  1,142    0.0    N/A      0            0    N/A
state object free list                8    0.0    N/A      0            0    N/A
statistics aggregation              560    0.0    N/A      0            0    N/A
temp lob duration state               3    0.0    N/A      0            0    N/A
temporary table state ob             40    0.0    N/A      0            0    N/A
threshold alerts latch            1,316    0.0    N/A      0            0    N/A
transaction allocation            1,043    0.0    N/A      0            0    N/A
transaction branch alloc          1,063    0.0    N/A      0            0    N/A
undo global data                239,490    0.0    0.5      0            0    N/A
user lock                         1,651    0.1    0.0      0            0    N/A
          -------------------------------------------------------------

Latch Sleep Breakdown                  DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by misses desc

Latch Name
----------------------------------------
  Get Requests      Misses      Sleeps  Spin Gets   Sleep1   Sleep2   Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
   189,126,618      15,105         485     14,631        0        0        0
row cache objects
    25,794,299       3,319         231      3,100        0        0        0
simulator lru latch
     5,016,335       2,981         167      2,818        0        0        0
session idle bit
    19,006,692         688          41        647        0        0        0
cache buffer handles
     4,515,950         434          20        414        0        0        0
library cache
     1,779,518         415          92        326        0        0        0
session allocation
     2,057,669         140          25        115        0        0        0
cache buffers lru chain
       392,874         123          19        104        0        0        0
library cache lock
       371,851          93           2         91        0        0        0
SQL memory manager workarea list latch
     8,596,595          72           7         65        0        0        0
shared pool
        83,593          51           2         49        0        0        0
enqueue hash chains
       524,729          28           4         25        0        0        0
object queue header operation
       733,068          23           5         18        0        0        0
enqueues
     1,320,994          15           3         12        0        0        0
session state list latch
         1,801          11           9          2        0        0        0
library cache pin
       134,510          10           5          5        0        0        0
In memory undo latch
       217,226           5           3          2        0        0        0
slave class create
            32           4           4          0        0        0        0
undo global data
       239,490           2           1          1        0        0        0
simulator hash latch
     5,046,089           1           1          0        0        0        0
          -------------------------------------------------------------

Latch Miss Sources                     DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch     kticmt: child                    0          2        0
In memory undo latch     ktiFlush: child                  0          1        1
SQL memory manager worka qesmmIRegisterWorkArea           0          3        5
SQL memory manager worka qesmmIUnRegisterWorkArea         0          3        2
SQL memory manager worka qesmmIRefreshBound               0          1        0
cache buffer handles     kcbzgs                           0         11       19
cache buffer handles     kcbzfs                           0          9        1
cache buffers chains     kcbgtcr: fast path               0        306      203
cache buffers chains     kcbgtcr: kslbegin excl           0        157      257
cache buffers chains     kcbrls: kslbegin                 0        119      122
cache buffers chains     kcbgcur: kslbegin                0          2        0
cache buffers lru chain  kcbzgws_1                        0         15       17
cache buffers lru chain  kcbbwlru                         0          3        2
cache buffers lru chain  kcbbxsv: move to being wri       0          1        0
enqueue hash chains      ksqgtl3                          0          4        1
enqueues                 ksqgel: create enqueue           0          2        0
enqueues                 ksqdel                           0          1        0
library cache            kglic                            0         63        0
library cache            kglLockCursor                    0         13        2
library cache            kgldte: child 0                  0          5       66
library cache            kglobpn: child:                  0          3        6
library cache            kglpin                           0          3        1
library cache            kglhdgn: child:                  0          2       16
library cache            kglScanDependency                0          1        0
library cache            kglpndl: child: after proc       0          1        0
library cache            kglukp: child                    0          1        0
library cache lock       kgllkal: child: multiinsta       0          2        1
library cache pin        kglpnal: child: alloc spac       0          5        5
object queue header oper kcbw_unlink_q                    0          3        1
object queue header oper kcbw_link_q                      0          2        0
object queue header oper kcbo_switch_cq                   0          1        3
row cache objects        kqreqd: reget                    0        142        0
row cache objects        kqrpre: find obj                 0         53      231
row cache objects        kqreqd                           0         36        0
session allocation       ksufap: active sessions          0         18        0
session allocation       ksuxds: not user session         0          3        2
session allocation       ksucri                           0          1       22
session allocation       ksudlp                           0          1        0
session allocation       ksuprc                           0          1        0
session allocation       ksuxds: KSUSFCLC not set         0          1        1
session idle bit         ksupuc: set busy                 0         21       30
session idle bit         ksupuc: clear busy               0         19       10
session idle bit         ksuxds                           0          1        1
session state list latch kpseqd                           0          7        0
session state list latch kpscad                           0          1        0
session state list latch kpseqa                           0          1       35
shared pool              kghfrh                           0          2        0
simulator hash latch     kcbsacc: lookup dba              0          1        0
simulator lru latch      kcbs_simulate: simulate se       0        166      166
simulator lru latch      kcbs_simbufseq                   0          1        1
slave class create       ksvcreate                        0          4        0
undo global data         ktucof: at start                 0          1        0
          -------------------------------------------------------------

Parent Latch Statistics                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Child Latch Statistics                  DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Segments by Logical Reads              DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Logical Reads:     110,362,993
-> Captured Segments account for   93.7% of Total

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI      DATA_TS    SAKAI_SESSION                   TABLE   16,087,952   14.58
SAKAI      DATA_TS    AK_SAKAI_REALM_ID               INDEX   10,342,752    9.37
SAKAI      DATA_TS    SYS_C004181                     INDEX    9,376,448    8.50
SAKAI_EXTE DATA_TS    BANNER_OFFER_COURSES            INDEX    8,027,376    7.27
SAKAI      DATA_TS    SAKAI_REALM_RL_GR_RA            INDEX    6,201,008    5.62
          -------------------------------------------------------------

Segments by Physical Reads              DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> Total Physical Reads:         409,767
-> Captured Segments account for    38.2% of Total

           Tablespace                      Subobject  Obj.      Physical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI      DATA_TS    SYS_LOB0000046053C00            LOB         56,729   13.84
SAKAI      DATA_TS    SYS_LOB0000046147C00            LOB         16,141    3.94
SAKAI      DATA_TS    SYS_C004181                     INDEX        8,621    2.10
SAKAI      DATA_TS    CONTENT_RESOURCE                TABLE        7,522    1.84
SAKAI      DATA_TS    ASSIGNMENT_SUBMISSIO            TABLE        7,119    1.74
          -------------------------------------------------------------

Segments by Row Lock Waits             DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot

                                                                     Row
           Tablespace                      Subobject  Obj.          Lock    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI      DATA_TS    SYS_C004168                     INDEX           97   39.43
SAKAI      DATA_TS    IE_SAKAI_SITE_FLAGS             INDEX           95   38.62
SAKAI      DATA_TS    SYS_C003787                     INDEX           21    8.54
SAKAI      DATA_TS    SYS_C004290                     INDEX            9    3.66
SAKAI      DATA_TS    SYS_C004212                     INDEX            5    2.03
          -------------------------------------------------------------

Segments by ITL Waits                   DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Segments by Buffer Busy Waits           DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> % of Capture shows % of Buffer Busy Waits for each top segment compared
-> with total Buffer Busy Waits for all segments captured by the Snapshot

                                                                  Buffer
           Tablespace                      Subobject  Obj.          Busy    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS        SYSTEM     DBMS_LOCK_ALLOCATED             TABLE            4   44.44
SYS        SYSTEM     JOB$                            TABLE            2   22.22
SYS        SYSTEM     I_JOB_NEXT                      INDEX            1   11.11
SAKAI      DATA_TS    SAKAI_REALM                     TABLE            1   11.11
SYS        SYSTEM     SUM$                            TABLE            1   11.11
          -------------------------------------------------------------

Dictionary Cache Stats                 DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> "Pct Misses"  should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control                     260    0.0       0   N/A        8          1
dc_database_links              199,599    0.0       0   N/A        0          6
dc_global_oids                      51    0.0       0   N/A        0        153
dc_histogram_data                7,080    1.5       0   N/A        0     13,491
dc_histogram_defs                7,373    1.7       0   N/A        0      6,478
dc_object_ids                   19,597    0.0       0   N/A        0      2,574
dc_objects                       4,669    0.1       0   N/A       20      3,329
dc_profiles                        528    0.0       0   N/A        0          1
dc_rollback_segments            57,436    0.0       0   N/A        0        392
dc_segments                      8,141    0.0       0   N/A       29      2,473
dc_sequences                     1,564    0.0       0   N/A    1,564         59
dc_tablespace_quotas                10    0.0       0   N/A       10          6
dc_tablespaces               4,141,555    0.0       0   N/A        0          9
dc_usernames                     1,947    0.0       0   N/A        0         37
dc_users                     4,161,046    0.0       0   N/A        0         88
global database name               416    0.0       0   N/A        0          1
outstanding_alerts                 512    0.0       0   N/A        0         17
          -------------------------------------------------------------

Library Cache Activity                  DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> "Pct Misses"  should be very low

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   5,086    0.0          5,582    0.0          0        0
CLUSTER                   11    0.0             17    0.0          0        0
SQL AREA                 210   81.0      3,310,798    0.1        350        1
TABLE/PROCEDURE        1,731    0.3         47,232    0.8         10        0
          -------------------------------------------------------------

Process Memory Summary                 DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> B: Begin snap   E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
-> Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> ordered by Begin/End snapshot, Alloc (MB) desc

                                                            Hist
                                    Avg  Std Dev     Max     Max
               Alloc      Used    Alloc    Alloc   Alloc   Alloc    Num    Num
  Category      (MB)      (MB)     (MB)     (MB)    (MB)    (MB)   Proc  Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other        616.6       N/A       .6      2.3      64      64  1,038  1,038
  Freeable      72.8        .0       .9       .3       1     N/A     84     84
  SQL           18.3       5.3       .0       .1       0     106  1,026  1,021
  PL/SQL         2.6        .4       .0       .0       0       0  1,036  1,036
E Other        617.4       N/A       .6      2.3      64      64  1,031  1,031
  Freeable      85.7        .0       .9       .2       1     N/A    100    100
  SQL           23.4       6.8       .0       .1       0     106  1,020  1,019
  PL/SQL         2.3        .3       .0       .0       0       0  1,029  1,029
          -------------------------------------------------------------

SGA Memory Summary                      DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                                                      End Size (Bytes)
SGA regions                     Begin Size (Bytes)      (if different)
------------------------------ ------------------- -------------------
Database Buffers                       721,420,288
Fixed Size                               1,262,764
Redo Buffers                            15,511,552
Variable Size                        1,358,957,396
                               -------------------
sum                                  2,097,152,000
          -------------------------------------------------------------

SGA breakdown difference                DB/Inst: SAKAI/sakai  Snaps: 3283-3287
-> ordered by Pool, Name
-> N/A value for Begin MB or End MB indicates the size of that Pool/Name was
   insignificant, or zero in that snapshot

Pool   Name                                 Begin MB         End MB  % Diff
------ ------------------------------ -------------- -------------- -------
java   free memory                              11.8           11.8    0.00
java   joxlod exec hp                            4.1            4.1    0.00
large  free memory                              15.9           15.9    0.00
shared CCursor                                  59.5           62.1    4.38
shared Heap0: KGL                               10.4           10.4    0.25
shared KGH: NO ACCESS                           53.4           53.4    0.00
shared KGLS heap                                10.4           10.6    1.57
shared KTI-UNDO                                 14.7           14.7    0.00
shared PCursor                                  21.5           21.9    1.65
shared event statistics per sess                15.7           15.7    0.00
shared free memory                              95.5           77.3  -19.14
shared library cache                            34.8           35.2    0.98
shared private strands                          14.2           14.2    0.00
shared sessions                                  9.4            9.4    0.00
shared sql area                                351.7          366.4    4.17
shared trace buffer                             16.5           16.5    0.00
       buffer_cache                            688.0          688.0    0.00
       fixed_sga                                 1.2            1.2    0.00
       log_buffer                               14.8           14.8    0.00
          -------------------------------------------------------------

Streams CPU/IO Usage                   DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Streams Capture                         DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Streams Apply                           DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffered Queues                         DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Buffered Subscribers                    DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Rule Set                                DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

Resource Limit Stats                         DB/Inst: SAKAI/sakai  Snap: 3287

                  No data exists for this section of the report.
          -------------------------------------------------------------

init.ora Parameters                    DB/Inst: SAKAI/sakai  Snaps: 3283-3287

                                                                End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
audit_file_dest               /opt/pkg/oracle/product/10.2.0/ad
background_dump_dest          /opt/pkg/oracle/product/10.2.0/ad
compatible                    10.2.0.1.0
control_files                 /opt/pkg/oracle/data/sakai/contro
core_dump_dest                /opt/pkg/oracle/product/10.2.0/ad
db_block_size                 8192
db_domain                     ucdavis.edu
db_file_multiblock_read_count 16
db_name                       sakai
dispatchers                   (PROTOCOL=TCP) (SERVICE=sakaiXDB)
job_queue_processes           10
log_archive_dest              /opt/pkg/oracle/data/sakai/archiv
open_cursors                  300
optimizer_mode                FIRST_ROWS
pga_aggregate_target          838860800
processes                     1850
remote_login_passwordfile     EXCLUSIVE
sga_max_size                  2097152000
sga_target                    1577058304
undo_management               AUTO
undo_tablespace               UNDOTBS1
user_dump_dest                /opt/pkg/oracle/product/10.2.0/ad
          -------------------------------------------------------------

End of Report