awr-2007-10-08_22-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:      3268 08-Oct-07 22:00:26     1,040      35.2
  End Snap:      3269 08-Oct-07 22:47:26     1,038      35.5
   Elapsed:               47.00 (mins)
   DB Time:               49.53 (mins)

Cache Sizes
~~~~~~~~~~~                       Begin        End
                             ---------- ----------
               Buffer Cache:       752M       720M  Std Block Size:         8K
           Shared Pool Size:       704M       736M      Log Buffer:    15,148K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:             30,382.37             10,079.58
              Logical reads:             19,158.10              6,355.84
              Block changes:                199.82                 66.29
             Physical reads:                481.44                159.72
            Physical writes:                 12.48                  4.14
                 User calls:                717.10                237.90
                     Parses:                 21.13                  7.01
                Hard parses:                  0.95                  0.31
                      Sorts:                 16.71                  5.54
                     Logons:                  0.05                  0.02
                   Executes:                253.23                 84.01
               Transactions:                  3.01

  % Blocks changed per Read:    1.04    Recursive Call %:    34.90
 Rollback per transaction %:    1.04       Rows per Sort:  1000.80

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.92       Redo NoWait %:  100.00
            Buffer  Hit   %:   97.73    In-memory Sort %:  100.00
            Library Hit   %:   99.00        Soft Parse %:   95.51
         Execute to Parse %:   91.66         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   25.98     % Non-Parse CPU:   99.32

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   87.75   89.11
    % SQL with executions>1:   94.72   81.84
  % Memory for SQL w/exec>1:   93.33   84.89

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time                                            820          27.6
db file scattered read               92,856         540      6   18.2   User I/O
read by other session                43,785         315      7   10.6   User I/O
db file sequential read             224,842         254      1    8.5   User I/O
log file parallel write               8,632         210     24    7.1 System I/O
          -------------------------------------------------------------
Time Model Statistics                  DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total time in database user-calls (DB Time): 2972.1s
-> Statistics including the word "background" measure background process
   time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name

Statistic Name                                       Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time                              2,803.5         94.3
PL/SQL execution elapsed time                           892.4         30.0
DB CPU                                                  820.2         27.6
parse time elapsed                                       33.0          1.1
hard parse elapsed time                                  28.5          1.0
failed parse elapsed time                                11.1           .4
repeated bind elapsed time                                4.5           .2
hard parse (sharing criteria) elapsed time                1.0           .0
connection management call elapsed time                   0.3           .0
hard parse (bind mismatch) elapsed time                   0.3           .0
sequence load elapsed time                                0.2           .0
PL/SQL compilation elapsed time                           0.0           .0
DB time                                               2,972.1          N/A
background elapsed time                                 398.0          N/A
background cpu time                                      12.4          N/A
          -------------------------------------------------------------

Wait Class                              DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
-------------------- ---------------- ------ ---------------- ------- ---------
User I/O                      427,945     .0            1,110       3      50.3
System I/O                     13,780     .0              242      18       1.6
Commit                          6,370     .0              160      25       0.7
Network                     2,992,425     .0               52       0     352.1
Concurrency                       563     .5                6      11       0.1
Other                             552     .0                0       1       0.1
Application                       209     .0                0       1       0.0
          -------------------------------------------------------------

Wait Events                            DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
---------------------------- -------------- ------ ----------- ------- ---------
db file scattered read               92,856     .0         540       6      10.9
read by other session                43,785     .0         315       7       5.2
db file sequential read             224,842     .0         254       1      26.5
log file parallel write               8,632     .0         210      24       1.0
log file sync                         6,370     .0         160      25       0.7
SQL*Net more data from clien        255,288     .0          34       0      30.0
control file parallel write             929     .0          32      34       0.1
SQL*Net more data to client         738,725     .0          10       0      86.9
SQL*Net message to client         1,997,377     .0           8       0     235.0
os thread startup                        33    3.0           4     129       0.0
library cache load lock                   6     .0           2     251       0.0
direct path read                     63,197     .0           0       0       7.4
SQL*Net break/reset to clien            207     .0           0       1       0.0
latch free                              238     .0           0       1       0.0
latch: cache buffers chains             470     .0           0       1       0.1
control file sequential read          4,219     .0           0       0       0.5
db file parallel read                   983     .0           0       0       0.1
latch: library cache                     34     .0           0       2       0.0
buffer busy waits                        11     .0           0       6       0.0
cursor: pin S wait on X                   2  100.0           0      28       0.0
latch: cache buffers lru cha            132     .0           0       0       0.0
cursor: pin S                             1     .0           0      33       0.0
LGWR wait for redo copy                 172     .0           0       0       0.0
enq: TX - row lock contentio              2     .0           0      12       0.0
direct path write temp                2,042     .0           0       0       0.2
latch: shared pool                        3     .0           0       4       0.0
SQL*Net more data from dblin             78     .0           0       0       0.0
SQL*Net message to dblink               906     .0           0       0       0.1
latch: redo allocation                    3     .0           0       0       0.0
direct path write                       127     .0           0       0       0.0
SQL*Net more data to dblink              51     .0           0       0       0.0
direct path read temp                   113     .0           0       0       0.0
latch: row cache objects                  4     .0           0       0       0.0
latch: session allocation                 5     .0           0       0       0.0
latch: object queue header o              1     .0           0       0       0.0
SQL*Net message from client       1,997,376     .0   2,640,624    1322     235.0
jobq slave wait                       1,192   96.6       3,453    2897       0.1
Streams AQ: qmn slave idle w            101     .0       2,766   27384       0.0
Streams AQ: qmn coordinator             204   50.5       2,766   13558       0.0
Streams AQ: waiting for mess            564  100.0       2,754    4883       0.1
virtual circuit status                   94  100.0       2,754   29294       0.0
SQL*Net message from dblink             906     .0         730     806       0.1
single-task message                      41     .0           4     108       0.0
PL/SQL lock timer                         1  100.0           1     978       0.0
SGA: MMAN sleep for componen             65   95.4           1      11       0.0
          -------------------------------------------------------------

Background Wait Events                 DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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               8,631     .0         210      24       1.0
control file parallel write             929     .0          32      34       0.1
os thread startup                        33    3.0           4     129       0.0
db file scattered read                  110     .0           0       1       0.0
db file sequential read               1,335     .0           0       0       0.2
events in waitclass Other               175     .0           0       0       0.0
control file sequential read            315     .0           0       0       0.0
rdbms ipc message                    17,376   51.3      29,337    1688       2.0
Streams AQ: qmn slave idle w            101     .0       2,766   27384       0.0
Streams AQ: qmn coordinator             204   50.5       2,766   13558       0.0
pmon timer                              946  100.0       2,755    2912       0.1
smon timer                               93    2.2       2,503   26912       0.0
SGA: MMAN sleep for componen             65   95.4           1      11       0.0
          -------------------------------------------------------------

Operating System Statistics             DB/Inst: SAKAI/sakai  Snaps: 3268-3269

Statistic                                       Total
-------------------------------- --------------------
BUSY_TIME                                      97,144
IDLE_TIME                                     466,837
IOWAIT_TIME                                    84,800
NICE_TIME                                           0
SYS_TIME                                       30,805
USER_TIME                                      63,637
LOAD                                                2
RSRC_MGR_CPU_WAIT_TIME                              0
PHYSICAL_MEMORY_BYTES                          24,072
NUM_CPUS                                            2
          -------------------------------------------------------------

Service Statistics                     DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> ordered by DB Time

                                                             Physical    Logical
Service Name                      DB Time (s)   DB CPU (s)      Reads      Reads
-------------------------------- ------------ ------------ ---------- ----------
SYS$USERS                             2,972.1        820.3  1,354,623 ##########
SYS$BACKGROUND                            0.0          0.0      3,278     18,687
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: 3268-3269
-> 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
   425706    110865       530       197         0         0   2992335      5218
SYS$BACKGROUND
     2242        96        33       424         0         0         0         0
          -------------------------------------------------------------

SQL ordered by Elapsed Time            DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
---------- ---------- ------------ ---------- ------- -------------
       482         45            1      481.5    16.2 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )

       464        127            1      464.5    15.6 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )

       432         33          229        1.9    14.5 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

       431         19          923        0.5    14.5 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))

        86         86       83,331        0.0     2.9 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

        47         44            1       47.2     1.6 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc

        28         28            2       14.2     1.0 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
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

        24         23          923        0.0     0.8 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS

        20          1          602        0.0     0.7 0ybwd63u2any5
insert into sys.wri$_optstat_histgrm_history (obj#,intcol#,savtime,bucket, endpo
int,epvalue) select hg.obj#,hg.intcol#,:3,hg.bucket,hg.endpoint, hg.epvalue from
 sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2

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

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

SQL ordered by CPU Time                DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
---------- ---------- ------------ ----------- ------- -------------
       127        464            1      126.78    15.6 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )

        86         86       83,331        0.00     2.9 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

        45        482            1       44.95    16.2 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )

        44         47            1       44.39     1.6 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc

        33        432          229        0.14    14.5 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

        28         28            2       14.08     1.0 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
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

        23         24          923        0.02     0.8 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS

        19        431          923        0.02    14.5 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))

        13         13       11,936        0.00     0.4 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_

        12         12       11,601        0.00     0.4 cmjt3rksyabf3
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4,:5,:6)) and FUNCTION_KE
Y in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :7) an
SQL ordered by CPU Time                DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
---------- ---------- ------------ ----------- ------- -------------
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: 3268-3269
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:      54,024,654
-> Captured SQL account for      97.1% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
    14,010,298            1 ############   25.9    44.39     47.24 gqnudu05hjfxc
Module: SQL*Plus
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, SUM(BLOCKS) NUM_
BLOCKS, COUNT(*) NUM_EXTENTS FROM DBA_EXTENTS where owner not like
('OPS%') GROUP BY OWNER, SEGMENT_NAME, SEGMENT_TYPE HAVING COU
NT(*) > 50 order by num_extents desc

    12,840,072            2  6,420,036.0   23.8    28.15     28.33 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
SELECT sectioncmi0_.eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, secti
oncmi0_.title AS title248_, sectioncmi0_.description AS descript4_248_, sectionc
mi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_248_, sec
tioncmi0_.lastmodifiedby AS lastmodi7_248_, sectioncmi0_.lastmodifieddate AS las

     4,620,375          751      6,152.3    8.6    10.65     10.93 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_

     3,016,904          229     13,174.3    5.6    33.07    432.14 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

     2,725,245       83,331         32.7    5.0    85.87     85.97 aby75s01s29un
Module: JDBC Thin Client
select count(1) from SAKAI_REALM_RL_FN where REALM_KEY in (select REALM_KEY from
 SAKAI_REALM where SAKAI_REALM.REALM_ID IN (:1,:2,:3,:4)) and FUNCTION_KEY in (
select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = :5) and (ROL
E_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID

     1,883,778            2    941,889.0    3.5     4.00      4.80 7usr9gxxt325w
Module: TOAD 8.5.3.2
/* Formatted on 2007/10/08 22:22 (Formatter Plus v4.8.6) */ SELECT sectioncmi0_.
eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, sectioncmi0_.title
 AS title248_, sectioncmi0_.description AS descript4_248_, section
cmi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_2

     1,750,701            1  1,750,701.0    3.2    44.95    481.51 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )

     1,706,849            1  1,706,849.0    3.2   126.78    464.48 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )

       861,956          923        933.9    1.6    19.16    430.57 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))

       801,748          923        868.6    1.5    22.76     24.09 cfxfxjk00tq0m
Module: DBMS_SCHEDULER
SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OW
NER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, S
UBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FR
SQL ordered by Gets                    DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Resources reported for PL/SQL code includes the resources used by all SQL
   statements called by the code.
-> Total Buffer Gets:      54,024,654
-> Captured SQL account for      97.1% of Total

                                Gets              CPU     Elapsed
  Buffer Gets   Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
OM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS

       765,603          418      1,831.6    1.4     7.62      9.42 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

       703,671        2,792        252.0    1.3     9.94     10.08 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

       653,042           28     23,322.9    1.2     3.48      3.58 gsytpx8b8g7kg
Module: JDBC Thin Client
select topicimpl0_.ID as ID31_0_, messagesse1_.ID as ID32_1_, topicimpl0_.VERSIO
N as VERSION31_0_, topicimpl0_.UUID as UUID31_0_, topicimpl0_.CREATED as CREATED
31_0_, topicimpl0_.CREATED_BY as CREATED6_31_0_, topicimpl0_.MODIFIED as MODIFIE
D31_0_, topicimpl0_.MODIFIED_BY as MODIFIED8_31_0_, topicimpl0_.DEFAULTASSIGNNAM

       601,727       66,858          9.0    1.1     4.40      4.42 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'

       600,669        6,525         92.1    1.1     6.31      6.31 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

       560,327       11,936         46.9    1.0    12.79     12.90 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_

       540,824          536      1,009.0    1.0     4.74      5.20 6p68587y4yccm
Module: JDBC Thin Client
select personinfo0_.EID as EID253_, personinfo0_.KERBEROS_NAME as KERBEROS2_253_
, personinfo0_.PERSON_NAME as PERSON3_253_, personinfo0_.FIRST_NAME as FIRST4_25
3_, personinfo0_.LAST_NAME as LAST5_253_, personinfo0_.EMAIL_ADDRESS as EMAIL6_2
53_, personinfo0_.PERSON_TYPE as PERSON7_253_ from UCDSAKAI_PERSON_INFO personin

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

SQL ordered by Reads                   DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Disk Reads:       1,357,629
-> Captured SQL account for    122.5% of Total

                               Reads              CPU     Elapsed
Physical Reads  Executions    per Exec   %Total Time (s)  Time (s)    SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
       552,947           1     552,947.0   40.7   126.78    464.48 b6usrg82hwsa3
Module: DBMS_SCHEDULER
call dbms_stats.gather_database_stats_job_proc ( )

       437,588           1     437,588.0   32.2    44.95    481.51 6mcpb06rctk0x
Module: DBMS_SCHEDULER
call dbms_space.auto_space_advisor_job_proc ( )

       436,427         923         472.8   32.1    19.16    430.57 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))

        54,212           2      27,106.0    4.0     4.00      4.80 7usr9gxxt325w
Module: TOAD 8.5.3.2
/* Formatted on 2007/10/08 22:22 (Formatter Plus v4.8.6) */ SELECT sectioncmi0_.
eid AS eid248_, sectioncmi0_.CATEGORY AS category248_, sectioncmi0_.title
 AS title248_, sectioncmi0_.description AS descript4_248_, section
cmi0_.createdby AS createdby248_, sectioncmi0_.createddate AS createdd6_2

        53,564           2      26,782.0    3.9    28.15     28.33 77ufam1zg8m27
Module: sqlplus@caje (TNS V1-V3)
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

        52,208         229         228.0    3.8    33.07    432.14 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

        36,005           1      36,005.0    2.7     0.67      6.63 6hun1u5a30088
Module: DBMS_SCHEDULER
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact u
se_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*),count("RESOURCE_
UUID"),count("FILE_PATH") from "SAKAI"."CONTENT_RESOURCE" t

         6,524           2       3,262.0    0.5     0.37      5.77 fh44j45a5k7p5
Module: JDBC Thin Client
select SESSION_ID,SESSION_SERVER,SESSION_USER,SESSION_IP,SESSION_USER_AGENT,SESS
ION_START,SESSION_END from SAKAI_SESSION where SESSION_START = SESSION_END ORDER
 BY SESSION_SERVER ASC, SESSION_START ASC

         6,201           1       6,201.0    0.5     0.37      5.54 bxbuuskdn20bh
Module: DBMS_SCHEDULER
select /*+ no_parallel_index(t,"SYS_C004181") dbms_stats cursor_sharing_exact us
e_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t,"SYS_C0
04181") */ count(*) as nrw,count(distinct sys_op_lbid(46575,'L',t.rowid)) as nlb
,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SAKAI"."SAKAI

         4,843           1       4,843.0    0.4     0.94      5.63 6y660ngt2q7sq
Module: DBMS_SCHEDULER
select /*+ no_parallel_index(t,"FK_SAKAI_REALM_RL_FN_FUNC") dbms_stats cursor_sh
aring_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index
_ffs(t,"FK_SAKAI_REALM_RL_FN_FUNC") */ count(*) as nrw,count(distinct sys_op_lbi
d(46572,'L',t.rowid)) as nlb,count(distinct "FUNCTION_KEY") as ndk,sys_op_countc

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

SQL ordered by Executions              DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Executions:         714,094
-> Captured SQL account for     42.3% of Total

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
      83,331          83,331            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

      66,858          66,858            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'

      49,376          49,256            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

      11,936          11,936            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_

      11,601          11,601            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

       9,353          36,798            3.9       0.00        0.00 8a1pvy4cy8hgv
insert into histgrm$(obj#,intcol#,row#,bucket,endpoint,col#,epvalue) values(:1,:
2,:3,:4,:5,:6,:7)

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

       7,340           7,340            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 = :

       6,525         951,756          145.9       0.00        0.00 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

       4,981           4,981            1.0       0.00        0.00 6nrr3a3qqtnsk
SQL ordered by Executions              DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Executions:         714,094
-> Captured SQL account for     42.3% of Total

                                              CPU per    Elap per
 Executions   Rows Processed  Rows per Exec   Exec (s)   Exec (s)     SQL Id
------------ --------------- -------------- ---------- ----------- -------------
Module: JDBC Thin Client
select 1 from DUAL

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

SQL ordered by Parse Calls             DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Parse Calls:          59,573
-> Captured SQL account for      44.1% of Total

                            % Total
 Parse Calls  Executions     Parses    SQL Id
------------ ------------ --------- -------------
       4,981        4,981      8.36 6nrr3a3qqtnsk
Module: JDBC Thin Client
select 1 from DUAL

       4,730        4,730      7.94 2ym6hhaq30r73
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis
ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro
m seg$ where ts#=:1 and file#=:2 and block#=:3

       1,328        1,328      2.23 fkw8xn3uyux0h
select null from partobj$ where obj#=:1

         923          923      1.55 3vycvc6n3uhbn
Module: DBMS_SCHEDULER
select chain_pcent from wri$_adv_objspace_chrow_data

         923          923      1.55 bxrry8kxks9hz
Module: DBMS_SCHEDULER
select sn.startup_time timepoint, s.space_used_delta delta_space_usage, s.space_
allocated_delta delta_space_alloc, NULL total_space_usage, NULL total_space_allo
c, s.instance_number instance_number, s.dataobj# objn from sys.wrh$_seg_stat s,
sys.wrh$_seg_stat_obj so, sys.wrm$_snapshot sn , sys.obj$ obj where sn.snap_id

         923          923      1.55 ggpw9s044z93d
Module: DBMS_SCHEDULER
select timepoint, space_usage, space_alloc from wri$_adv_objspace_trend_data or
der by timepoint

         922          923      1.55 8szmwam7fysa3
Module: DBMS_SCHEDULER
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_a
lloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, N
ULL, NULL, 'FALSE', :5, 'FALSE'))

         922          922      1.55 c435jg0kk315y
Module: DBMS_SCHEDULER
delete from wri$_adv_objspace_trend_data

         922          922      1.55 gnux0zb3sxduk
Module: DBMS_SCHEDULER
SELECT TIMEPOINT, DELTA_SPACE_USAGE, DELTA_SPACE_ALLOC, TOTAL_SPACE_USAGE, TOTAL
_SPACE_ALLOC, INSTANCE_NUMBER, OBJN FROM TABLE(DBMS_SPACE.OBJECT_GROWTH_TREND_SW
RF(:B1 , :B2 , :B3 , :B4 )) ORDER BY TIMEPOINT

         887          887      1.49 0wymay7v2c2z6
select ts#,file#,block#, pctfree$, initrans, type# from ind$ where obj#=:1

         823          823      1.38 8hd36umbhpgsz
select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, de
finitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextp
ct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(t
runc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpar

         643          643      1.08 27xdav1rg5g14
select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property,1024),0,0,
1) from ind$ i,obj$ o,user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.us
er#

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

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

Sharable Mem (b)  Executions   % Total    SQL Id
---------------- ------------ -------- -------------
      34,947,496          N/A     4.53 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'

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

       4,787,237          270     0.62 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 =

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

       1,579,206           22     0.20 6ma5vzd75tgv3
Module: TOAD 8.5.3.2
INSERT INTO "TOAD_PLAN_TABLE" ("STATEMENT_ID","TIMESTAMP","OPERATION","OPTIONS"
,"OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_INSTANCE","OBJECT_TYPE","SEA
RCH_COLUMNS","ID","PARENT_ID","POSITION","OTHER","OPTIMIZER","COST","CARDINALITY
","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","DISTRIB

       1,571,909       11,936     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 (
ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_

       1,282,056          552     0.17 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

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

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

 Version
  Count   Executions     SQL Id
-------- ------------ -------------
     664          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'

     489       11,936 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_

     212            1 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

     211        7,340 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 = :

     208           35 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 )

     138          270 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 =

      76           22 6ma5vzd75tgv3
Module: TOAD 8.5.3.2
INSERT INTO "TOAD_PLAN_TABLE" ("STATEMENT_ID","TIMESTAMP","OPERATION","OPTIONS"
,"OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_INSTANCE","OBJECT_TYPE","SEA
RCH_COLUMNS","ID","PARENT_ID","POSITION","OTHER","OPTIMIZER","COST","CARDINALITY
","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","DISTRIB

      60          552 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

      60          552 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: 3268-3269
-> 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

      46           14 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

      38           35 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)

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

      36        7,345 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

      33            2 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

      30           28 f1nzkyqwq6sq3
Module: JDBC Thin Client
update MFR_TOPIC_T set VERSION=:1, UUID=:2, CREATED=:3, CREATED_BY=:4, MODIFIED=
:5, MODIFIED_BY=:6, DEFAULTASSIGNNAME=:7, TITLE=:8, SHORT_DESCRIPTION=:9, EXTEND
ED_DESCRIPTION=:10, MODERATED=:11, MUTABLE=:12, SORT_INDEX=:13, TYPE_UUID=:14, o
f_surrogateKey=:15, pf_surrogateKey=:16, LOCKED=:17, DRAFT=:18, CONFIDENTIAL_RES

      24          898 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: 3268-3269

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session                     65,148           23.1           7.7
CPU used when call started                   47,444           16.8           5.6
CR blocks created                             2,830            1.0           0.3
Cached Commit SCN referenced                134,300           47.6          15.8
Commit SCN cached                             1,019            0.4           0.1
DB time                                     920,881          326.6         108.3
DBWR checkpoint buffers written               1,222            0.4           0.1
DBWR checkpoints                                  0            0.0           0.0
DBWR object drop buffers written                  0            0.0           0.0
DBWR revisited being-written buf                  0            0.0           0.0
DBWR tablespace checkpoint buffe                  0            0.0           0.0
DBWR thread checkpoint buffers w              1,222            0.4           0.1
DBWR transaction table writes                    31            0.0           0.0
DBWR undo block writes                        4,868            1.7           0.6
IMU CR rollbacks                                120            0.0           0.0
IMU Flushes                                   3,906            1.4           0.5
IMU Redo allocation size                  4,278,828        1,517.4         503.4
IMU commits                                   5,036            1.8           0.6
IMU contention                                   34            0.0           0.0
IMU ktichg flush                                514            0.2           0.1
IMU pool not allocated                            0            0.0           0.0
IMU recursive-transaction flush                  25            0.0           0.0
IMU undo allocation size                 13,847,772        4,910.7       1,629.2
IMU- failed to get a private str                  0            0.0           0.0
SMON posted for dropping temp se                  0            0.0           0.0
SMON posted for undo segment rec                  0            0.0           0.0
SMON posted for undo segment shr                  0            0.0           0.0
SQL*Net roundtrips to/from clien          1,996,699          708.1         234.9
SQL*Net roundtrips to/from dblin                906            0.3           0.1
active txn count during cleanout                867            0.3           0.1
application wait time                            31            0.0           0.0
background checkpoints completed                  0            0.0           0.0
background checkpoints started                    0            0.0           0.0
background timeouts                           9,023            3.2           1.1
branch node splits                                3            0.0           0.0
buffer is not pinned count               23,525,263        8,342.5       2,767.7
buffer is pinned count                   29,792,933       10,565.1       3,505.1
bytes received via SQL*Net from       1,016,492,017      360,466.1     119,587.3
bytes received via SQL*Net from             370,264          131.3          43.6
bytes sent via SQL*Net to client      2,272,412,393      805,837.7     267,342.6
bytes sent via SQL*Net to dblink            381,215          135.2          44.9
calls to get snapshot scn: kcmgs          2,614,733          927.2         307.6
calls to kcmgas                              37,357           13.3           4.4
calls to kcmgcs                               1,808            0.6           0.2
change write time                             1,274            0.5           0.2
cleanout - number of ktugct call              6,274            2.2           0.7
cleanouts and rollbacks - consis                 25            0.0           0.0
cleanouts only - consistent read              5,151            1.8           0.6
cluster key scan block gets                 194,465           69.0          22.9
cluster key scans                            72,006           25.5           8.5
commit batch performed                           41            0.0           0.0
commit batch requested                           41            0.0           0.0
commit batch/immediate performed                 69            0.0           0.0
commit batch/immediate requested                 69            0.0           0.0
commit cleanout failures: block               1,776            0.6           0.2
commit cleanout failures: buffer                  1            0.0           0.0
commit cleanout failures: callba                180            0.1           0.0
commit cleanout failures: cannot                  8            0.0           0.0
commit cleanouts                             38,160           13.5           4.5
commit cleanouts successfully co             36,195           12.8           4.3
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3268-3269

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
commit immediate performed                       28            0.0           0.0
commit immediate requested                       28            0.0           0.0
commit txn count during cleanout              6,785            2.4           0.8
concurrency wait time                           620            0.2           0.1
consistent changes                           52,321           18.6           6.2
consistent gets                          53,377,406       18,928.6       6,279.7
consistent gets - examination            10,509,539        3,726.9       1,236.4
consistent gets direct                       63,544           22.5           7.5
consistent gets from cache               53,313,863       18,906.0       6,272.2
current blocks converted for CR                   0            0.0           0.0
cursor authentications                          697            0.3           0.1
data blocks consistent reads - u              3,889            1.4           0.5
db block changes                            563,477          199.8          66.3
db block gets                               647,259          229.5          76.2
db block gets direct                         14,298            5.1           1.7
db block gets from cache                    632,961          224.5          74.5
deferred (CURRENT) block cleanou             16,577            5.9           2.0
dirty buffers inspected                      14,452            5.1           1.7
enqueue conversions                           3,807            1.4           0.5
enqueue releases                             77,323           27.4           9.1
enqueue requests                             77,351           27.4           9.1
enqueue timeouts                                 32            0.0           0.0
enqueue waits                                     2            0.0           0.0
exchange deadlocks                                0            0.0           0.0
execute count                               714,094          253.2          84.0
failed probes on index block rec                 12            0.0           0.0
frame signature mismatch                          0            0.0           0.0
free buffer inspected                     1,489,604          528.2         175.3
free buffer requested                     1,308,099          463.9         153.9
heap block compress                           1,103            0.4           0.1
hot buffers moved to head of LRU            162,612           57.7          19.1
immediate (CR) block cleanout ap              5,176            1.8           0.6
immediate (CURRENT) block cleano              7,761            2.8           0.9
index crx upgrade (found)                        10            0.0           0.0
index crx upgrade (positioned)              541,480          192.0          63.7
index fast full scans (full)                  2,078            0.7           0.2
index fetch by key                        3,720,925        1,319.5         437.8
index scans kdiixs1                       5,390,023        1,911.4         634.1
leaf node 90-10 splits                          134            0.1           0.0
leaf node splits                                558            0.2           0.1
lob reads                                    36,851           13.1           4.3
lob writes                                   40,636           14.4           4.8
lob writes unaligned                         40,441           14.3           4.8
logons cumulative                               143            0.1           0.0
messages received                             9,776            3.5           1.2
messages sent                                 9,776            3.5           1.2
no buffer to keep pinned count                    0            0.0           0.0
no work - consistent read gets           41,659,821       14,773.3       4,901.2
opened cursors cumulative                    72,689           25.8           8.6
parse count (failures)                        1,294            0.5           0.2
parse count (hard)                            2,675            1.0           0.3
parse count (total)                          59,573           21.1           7.0
parse time cpu                                  554            0.2           0.1
parse time elapsed                            2,132            0.8           0.3
physical read IO requests                   386,175          136.9          45.4
physical read bytes                  11,121,688,576    3,943,947.9   1,308,434.0
physical read total IO requests             390,451          138.5          45.9
physical read total bytes            11,191,237,632    3,968,611.2   1,316,616.2
physical read total multi block              93,205           33.1          11.0
physical reads                            1,357,629          481.4         159.7
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3268-3269

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
physical reads cache                      1,292,422          458.3         152.1
physical reads cache prefetch               974,110          345.4         114.6
physical reads direct                        65,206           23.1           7.7
physical reads direct (lob)                  63,446           22.5           7.5
physical reads direct temporary               1,695            0.6           0.2
physical reads prefetch warmup                    0            0.0           0.0
physical write IO requests                   14,575            5.2           1.7
physical write bytes                    288,268,288      102,225.0      33,913.9
physical write total IO requests             33,153           11.8           3.9
physical write total bytes              515,702,784      182,877.4      60,670.9
physical write total multi block             20,107            7.1           2.4
physical writes                              35,189           12.5           4.1
physical writes direct                       15,993            5.7           1.9
physical writes direct (lob)                    140            0.1           0.0
physical writes direct temporary             15,847            5.6           1.9
physical writes from cache                   19,196            6.8           2.3
physical writes non checkpoint               33,968           12.1           4.0
pinned buffers inspected                        170            0.1           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            388,295          137.7          45.7
process last non-idle time                    1,921            0.7           0.2
recovery blocks read                              0            0.0           0.0
recursive calls                           1,084,204          384.5         127.6
recursive cpu usage                          19,286            6.8           2.3
redo blocks read for recovery                     0            0.0           0.0
redo blocks written                         177,498           62.9          20.9
redo buffer allocation retries                    0            0.0           0.0
redo entries                                249,909           88.6          29.4
redo log space requests                           0            0.0           0.0
redo log space wait time                          0            0.0           0.0
redo ordering marks                               1            0.0           0.0
redo size                                85,676,396       30,382.4      10,079.6
redo synch time                              16,385            5.8           1.9
redo synch writes                           274,616           97.4          32.3
redo wastage                              2,206,848          782.6         259.6
redo write time                              21,535            7.6           2.5
redo writer latching time                         5            0.0           0.0
redo writes                                   8,627            3.1           1.0
rollback changes - undo records                   0            0.0           0.0
rollbacks only - consistent read              2,806            1.0           0.3
rows fetched via callback                 3,349,418        1,187.8         394.1
session connect time                              0            0.0           0.0
session cursor cache hits                    66,174           23.5           7.8
session logical reads                    54,024,654       19,158.1       6,355.8
session pga memory                       69,523,268       24,654.2       8,179.2
session pga memory max                   79,567,304       28,216.0       9,360.9
session uga memory                  188,984,507,364   67,017,256.2  22,233,471.5
session uga memory max                   80,916,464       28,694.4       9,519.6
shared hash latch upgrades - no             582,222          206.5          68.5
shared hash latch upgrades - wai                 10            0.0           0.0
sorts (disk)                                      0            0.0           0.0
sorts (memory)                               47,116           16.7           5.5
sorts (rows)                             47,153,796       16,721.6       5,547.5
sql area evicted                                231            0.1           0.0
sql area purged                               1,398            0.5           0.2
summed dirty queue length                    19,140            6.8           2.3
switch current to new buffer                  1,697            0.6           0.2
table fetch by rowid                     20,150,691        7,145.8       2,370.7
table fetch continued row                    88,586           31.4          10.4
Instance Activity Stats                DB/Inst: SAKAI/sakai  Snaps: 3268-3269

Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
table scan blocks gotten                 22,255,933        7,892.4       2,618.4
table scan rows gotten                  533,315,251      189,123.0      62,743.0
table scans (long tables)                        39            0.0           0.0
table scans (short tables)                   74,498           26.4           8.8
total number of times SMON poste                 91            0.0           0.0
transaction rollbacks                            69            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                  32,375,276       11,480.9       3,808.9
user I/O wait time                          110,921           39.3          13.1
user calls                                2,022,185          717.1         237.9
user commits                                  8,412            3.0           1.0
user rollbacks                                   88            0.0           0.0
workarea executions - onepass                     6            0.0           0.0
workarea executions - optimal                39,263           13.9           4.6
write clones created in backgrou                  0            0.0           0.0
write clones created in foregrou                 69            0.0           0.0
          -------------------------------------------------------------

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

Statistic                            Begin Value       End Value
-------------------------------- --------------- ---------------
session cursor cache count               391,290         393,756
opened cursors current                    36,655          36,893
workarea memory allocated                  1,433           1,433
logons current                             1,040           1,038
          -------------------------------------------------------------

Instance Activity Stats - Thread ActivityDB/Inst: SAKAI/sakai  Snaps: 3268-326
-> 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: 3268-3269
-> 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
       365,253     130    1.9     3.5        6,691        2     43,781    7.4
SYSAUX
         9,752       3    7.8     3.1        2,681        1          0    0.0
SYSTEM
         5,712       2    3.6     1.6        1,440        1         14    8.6
ARCH_TS
         4,466       2    5.9     9.2            0        0          0    0.0
TEMP
           749       0    2.5    14.9        2,518        1          0    0.0
UNDOTBS1
           486       0    2.5     1.0        1,227        0          1    0.0
INDEX_TS
            58       0    2.2     1.3           18        0          0    0.0
TEMP2
             1       0   40.0     1.0            0        0          0    0.0
          -------------------------------------------------------------

File IO Stats                          DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
         4,466       2    5.9     9.2            0        0          0    0.0
DATA_TS                  /local/d02/oracle/sakai/data01.dbf
       322,751     114    2.0     3.6        5,408        2     39,523    7.0
DATA_TS                  /local/d02/oracle/sakai/data02.dbf
        42,502      15    1.1     2.2        1,283        0      4,258   11.0
INDEX_TS                 /local/d02/oracle/sakai/index01.dbf
            58       0    2.2     1.3           18        0          0    0.0
SYSAUX                   /local/d02/oracle/sakai/sysaux01.dbf
         9,752       3    7.8     3.1        2,681        1          0    0.0
SYSTEM                   /local/d02/oracle/sakai/system01.dbf
         5,712       2    3.6     1.6        1,440        1         14    8.6
TEMP                     /local/d02/oracle/sakai/temp01.dbf
             7       0    8.6     1.0            7        0          0    N/A
TEMP                     /local/d02/oracle/sakai/temp02.dbf
           742       0    2.4    15.0        2,511        1          0    N/A
TEMP2                    /local/d03/oracle/sakai/temp03.dbf
             1       0   40.0     1.0            0        0          0    N/A
UNDOTBS1                 /local/d02/oracle/sakai/undotbs01.dbf
           486       0    2.5     1.0        1,227        0          1    0.0
          -------------------------------------------------------------

Buffer Pool Statistics                 DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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       88,589   98     53,944,455    1,292,515      19,196    0    0     43,796
          -------------------------------------------------------------

Instance Recovery Stats                 DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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       1182     26744     25969     737280     25969          N/A
E     0     0       2011     35349     35373     737280     35373          N/A
          -------------------------------------------------------------

Buffer Pool Advisory                          DB/Inst: SAKAI/sakai  Snap: 3269
-> 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        595,506,772
D        128     .2           15,992    1.4        515,898,522
D        192     .3           23,988    1.2        458,956,633
D        256     .4           31,984    1.1        425,210,203
D        320     .4           39,980    1.1        402,429,389
D        384     .5           47,976    1.0        388,936,925
D        448     .6           55,972    1.0        380,942,255
D        512     .7           63,968    1.0        376,943,710
D        576     .8           71,964    1.0        375,407,251
D        640     .9           79,960    1.0        374,766,293
D        704    1.0           87,956    1.0        374,534,782
D        720    1.0           89,955    1.0        374,495,224
D        768    1.1           95,952    1.0        374,376,857
D        832    1.2          103,948    1.0        374,258,367
D        896    1.2          111,944    1.0        374,169,937
D        960    1.3          119,940    1.0        374,101,184
D      1,024    1.4          127,936    1.0        374,043,842
D      1,088    1.5          135,932    1.0        373,992,572
D      1,152    1.6          143,928    1.0        373,950,819
D      1,216    1.7          151,924    1.0        373,891,758
D      1,280    1.8          159,920    1.0        373,851,744
          -------------------------------------------------------------

PGA Aggr Summary                       DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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
--------------- ------------------ --------------------------
           98.3              2,669                         45
          -------------------------------------------------------------

PGA Aggr Target Stats                   DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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        152    1,008.9        1.4     .1  100.0     .0    102,400
E        800        151      961.6        1.4     .1  100.0     .0    102,400
          -------------------------------------------------------------

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

  Low     High
Optimal Optimal    Total Execs  Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
     2K      4K         36,604         36,604            0            0
    64K    128K            374            374            0            0
   128K    256K            509            509            0            0
   256K    512K            189            189            0            0
   512K   1024K          1,227          1,227            0            0
     1M      2M            281            281            0            0
     2M      4M             26             26            0            0
     4M      8M             23             19            4            0
     8M     16M             13             11            2            0
    32M     64M             23             23            0            0
          -------------------------------------------------------------

PGA Memory Advisory                           DB/Inst: SAKAI/sakai  Snap: 3269
-> 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        406,587.1         54,975.7     88.0      2,422
       200     0.3        406,587.1         54,937.8     88.0      2,422
       400     0.5        406,587.1         51,801.1     89.0      2,313
       600     0.8        406,587.1         36,730.8     92.0      1,247
       800     1.0        406,587.1          3,476.5     99.0          0
       960     1.2        406,587.1          3,337.4     99.0          0
     1,120     1.4        406,587.1          3,337.4     99.0          0
     1,280     1.6        406,587.1          3,337.4     99.0          0
     1,440     1.8        406,587.1          3,337.4     99.0          0
     1,600     2.0        406,587.1          3,337.4     99.0          0
     2,400     3.0        406,587.1          3,337.4     99.0          0
     3,200     4.0        406,587.1          3,337.4     99.0          0
     4,800     6.0        406,587.1          3,337.4     99.0          0
     6,400     8.0        406,587.1          3,337.4     99.0          0
          -------------------------------------------------------------

Shared Pool Advisory                         DB/Inst: SAKAI/sakai  Snap: 3269
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       256    .3       88        9,177 #######    1.0 #######   52.3  27,736,785
       336    .5      164       11,466 #######    1.0 #######   35.8  27,761,117
       416    .6      243       14,706 #######    1.0  92,660   22.3  27,781,215
       496    .7      322       17,504 #######    1.0  58,911   14.2  27,793,576
       576    .8      401       22,075 #######    1.0  35,911    8.6  27,801,900
       656    .9      480       26,029 #######    1.0  18,325    4.4  27,806,522
       736   1.0      559       29,669 #######    1.0   4,158    1.0  27,809,336
       816   1.1      638       35,537 #######    1.0       1     .0  27,811,500
       896   1.2      717       39,510 #######    1.0       1     .0  27,813,358
       976   1.3      796       43,073 #######    1.0       1     .0  27,815,011
     1,056   1.4      865       48,375 #######    1.0       1     .0  27,816,514
     1,136   1.5      865       48,375 #######    1.0       1     .0  27,818,027
     1,216   1.7      865       48,375 #######    1.0       1     .0  27,819,464
     1,296   1.8      944       51,988 #######    1.0       1     .0  27,820,897
     1,376   1.9    1,017       55,329 #######    1.0       1     .0  27,822,323
     1,456   2.0    1,017       55,329 #######    1.0       1     .0  27,823,746
     1,536   2.1    1,017       55,329 #######    1.0       1     .0  27,825,170
          -------------------------------------------------------------

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

SGA Target   SGA Size       Est DB     Est Physical
  Size (M)     Factor     Time (s)            Reads
---------- ---------- ------------ ----------------
       752        0.5      340,778      515,529,696
     1,128        0.8      269,291      402,132,637
     1,504        1.0      255,494      374,494,912
     1,880        1.3      255,239      373,783,372
     2,256        1.5      255,187      373,596,124
     2,632        1.8      255,187      373,596,124
     3,008        2.0      255,187      373,596,124
          -------------------------------------------------------------

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

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

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

                                        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,158    1.0          76
        32   2.0        2           76       1    1.0   4,158    1.0          76
          -------------------------------------------------------------

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

Class                    Waits Total Wait Time (s)  Avg Time (ms)
------------------ ----------- ------------------- --------------
data block              43,791                 324              7
segment header               4                   0             10
undo header                  1                   0              0
          -------------------------------------------------------------

Enqueue Activity                       DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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          15.00
          -------------------------------------------------------------

Undo Segment Summary                   DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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        4.4          10,670    1,459       11 5760/5760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

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

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/    uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS     eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- ------------
08-Oct 22:40         256        1,458     222       9   5,760 0/0   0/0/0/0/0/0
08-Oct 22:30         292        1,679     913       4   5,760 0/0   0/0/0/0/0/0
08-Oct 22:20         174        1,346   1,459       9   5,760 0/0   0/0/0/0/0/0
08-Oct 22:10       3,642        6,187     858      11   5,760 0/0   0/0/0/0/0/0
          -------------------------------------------------------------

Latch Activity                         DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> "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               1,858    0.0    N/A      0            0    N/A
AWR Alerted Metric Eleme         62,847    0.0    N/A      0            0    N/A
Consistent RBA                    8,630    0.0    N/A      0            0    N/A
FAL request queue                    57    0.0    N/A      0            0    N/A
FAL subheap alocation                57    0.0    N/A      0            0    N/A
FIB s.o chain latch                   4    0.0    N/A      0            0    N/A
FOB s.o list latch                  308    0.0    N/A      0            0    N/A
In memory undo latch             59,228    0.0    N/A      0       10,890    0.0
JS mem alloc latch                   10    0.0    N/A      0            0    N/A
JS queue access latch                10    0.0    N/A      0            0    N/A
JS queue state obj latch         20,320    0.0    N/A      0            0    N/A
JS slv state obj latch              200    0.0    N/A      0            0    N/A
KMG MMAN ready and start          1,004    0.0    N/A      0            0    N/A
KMG resize request state              2    0.0    N/A      0            0    N/A
KTF sga latch                         5    0.0    N/A      0          831    0.0
MQL Tracking Latch                    0    N/A    N/A      0           56    0.0
Memory Management Latch             100    1.0    1.0      0        1,004    0.0
OS process                          495    0.0    N/A      0            0    N/A
OS process allocation             1,267    0.0    N/A      0            0    N/A
OS process: request allo            199    0.0    N/A      0            0    N/A
PL/SQL warning settings             784    0.0    N/A      0            0    N/A
SGA IO buffer pool latch            401    0.0    N/A      0          401    0.0
SQL memory manager latch              1    0.0    N/A      0          929    0.0
SQL memory manager worka      1,104,406    0.0    0.0      0            0    N/A
Shared B-Tree                       111    0.0    N/A      0            0    N/A
active checkpoint queue           1,505    0.0    N/A      0            0    N/A
active service list               7,104    0.0    N/A      0          946    0.0
archive control                     342    0.0    N/A      0            0    N/A
archive process latch               986    0.0    N/A      0            0    N/A
begin backup scn array              141    0.0    N/A      0            0    N/A
buffer pool                           3    0.0    N/A      0            0    N/A
cache buffer handles            577,079    0.0    0.0      0            0    N/A
cache buffers chains        100,040,284    0.0    0.1      0    3,082,692    0.0
cache buffers lru chain       1,374,048    0.2    0.0      0    1,245,057    0.3
cache table scan latch                0    N/A    N/A      0       92,788    0.1
channel handle pool latc            371    0.0    N/A      0            0    N/A
channel operations paren         14,282    0.0    0.0      0            0    N/A
checkpoint queue latch           38,740    0.0    N/A      0       22,059    0.0
client/application info              63    0.0    N/A      0            0    N/A
commit callback allocati            100    0.0    N/A      0            0    N/A
compile environment latc        289,520    0.0    N/A      0            0    N/A
constraint object alloca             82    0.0    N/A      0            0    N/A
dictionary lookup                    61    0.0    N/A      0            0    N/A
dml lock allocation              43,381    0.0    N/A      0            0    N/A
dummy allocation                    288    0.0    N/A      0            0    N/A
enqueue hash chains             158,506    0.0    0.0      0          221    0.0
enqueues                        376,735    0.0    0.0      0            0    N/A
event group latch                    98    0.0    N/A      0            0    N/A
file cache latch                    139    0.0    N/A      0            0    N/A
global KZLD latch for me             64    0.0    N/A      0            0    N/A
global tx hash mapping            5,890    0.0    N/A      0            0    N/A
hash table column usage             153    0.0    N/A      0       71,889    0.0
hash table modification             125    0.0    N/A      0            0    N/A
job workq parent latch                0    N/A    N/A      0           69    0.0
job_queue_processes para             63    0.0    N/A      0            0    N/A
kks stats                         4,593    0.0    N/A      0            0    N/A
ksuosstats global area              190    0.0    N/A      0            0    N/A
ktm global data                      93    0.0    N/A      0            0    N/A
kwqbsn:qsga                         111    0.0    N/A      0            0    N/A
lgwr LWN SCN                      9,104    0.0    N/A      0            0    N/A
Latch Activity                         DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> "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                   671,051    0.0    0.2      0          780    0.0
library cache load lock           2,038    0.0    N/A      0            2    0.0
library cache lock              199,682    0.0    0.0      0            0    N/A
library cache lock alloc          3,026    0.2    0.8      0            0    N/A
library cache pin                74,024    0.0    0.0      0            0    N/A
library cache pin alloca          2,607    0.0    N/A      0            0    N/A
list of block allocation          1,081    0.0    N/A      0            0    N/A
loader state object free         64,756    0.0    N/A      0            0    N/A
longop free list parent             262    0.0    N/A      0          271    0.0
message pool operations             196    0.0    N/A      0            0    N/A
messages                         47,586    0.0    N/A      0            0    N/A
mostly latch-free SCN             9,102    0.0    N/A      0            0    N/A
multiblock read objects         226,426    0.0    0.5      0            0    N/A
ncodef allocation latch              45    0.0    N/A      0            0    N/A
object queue header heap          7,091    0.0    N/A      0        5,728    0.0
object queue header oper      2,677,263    0.0    0.0      0        3,968    0.0
object stats modificatio            175    0.0    N/A      0            0    N/A
parallel query alloc buf            372    0.0    N/A      0            0    N/A
parameter table allocati            230    0.0    N/A      0            0    N/A
post/wait queue                  16,533    0.0    N/A      0        6,369    0.0
process allocation                  199    0.0    N/A      0           98    0.0
process group creation              199    0.0    N/A      0            0    N/A
qmn task queue latch                404    0.0    N/A      0            0    N/A
redo allocation                 289,409    0.0    0.1      0            0    N/A
redo copy                             0    N/A    N/A      0      249,899    0.1
redo writing                     29,261    0.0    N/A      0            0    N/A
row cache objects             3,430,761    0.0    0.0      0            0    N/A
sequence cache                   19,694    0.0    N/A      0            0    N/A
session allocation              862,955    0.0    0.0      0            0    N/A
session idle bit              4,334,554    0.0    0.1      0            0    N/A
session state list latch            375    0.0    N/A      0            0    N/A
session switching                    56    0.0    N/A      0            0    N/A
session timer                       946    0.0    N/A      0            0    N/A
shared pool                     169,459    0.0    0.2      0            0    N/A
shared pool sim alloc                47    0.0    N/A      0            0    N/A
shared pool simulator            19,676    0.0    N/A      0            0    N/A
simulator hash latch          2,300,374    0.0    0.0      0            0    N/A
simulator lru latch           2,086,781    0.1    0.1      0       97,222    0.1
slave class                           2    0.0    N/A      0            0    N/A
slave class create                    7    0.0    N/A      0            0    N/A
sort extent pool                    863    0.0    N/A      0            0    N/A
state object free list                2    0.0    N/A      0            0    N/A
statistics aggregation              140    0.0    N/A      0            0    N/A
temp lob duration state               4    0.0    N/A      0            0    N/A
temporary table state ob             13    0.0    N/A      0            0    N/A
threshold alerts latch              227    0.0    N/A      0            0    N/A
transaction allocation              556    0.0    N/A      0            0    N/A
transaction branch alloc          4,664    0.0    N/A      0            0    N/A
undo global data                 70,258    0.0    0.0      0            0    N/A
user lock                           524    0.0    N/A      0            0    N/A
          -------------------------------------------------------------

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

Latch Name
----------------------------------------
  Get Requests      Misses      Sleeps  Spin Gets   Sleep1   Sleep2   Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
cache buffers chains
   100,040,284       3,750         470      3,430        0        0        0
cache buffers lru chain
     1,374,048       2,991         132      2,866        0        0        0
simulator lru latch
     2,086,781       2,367         204      2,198        0        0        0
session idle bit
     4,334,554         168          25        144        0        0        0
session allocation
       862,955         166           5        161        0        0        0
library cache
       671,051         143          34        109        0        0        0
row cache objects
     3,430,761         141           4        137        0        0        0
object queue header operation
     2,677,263          45           1         44        0        0        0
redo allocation
       289,409          36           3         33        0        0        0
shared pool
       169,459          20           3         17        0        0        0
multiblock read objects
       226,426           8           4          5        0        0        0
library cache lock allocation
         3,026           5           4          1        0        0        0
Memory Management Latch
           100           1           1          0        0        0        0
          -------------------------------------------------------------

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

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
Memory Management Latch  kmgs_perform_parameter_upd       0          1        1
cache buffers chains     kcbgtcr: kslbegin excl           0        443      482
cache buffers chains     kcbrls: kslbegin                 0         58       41
cache buffers chains     kcbgtcr: fast path               0         32       10
cache buffers chains     kcbzwb                           0         21       21
cache buffers chains     kcbchg: kslbegin: bufs not       0          6        1
cache buffers chains     kcbgcur: kslbegin                0          2        0
cache buffers chains     kcbzib: finish free bufs         0          1        7
cache buffers lru chain  kcbzgws_1                        0        120      125
cache buffers lru chain  kcbzar: KSLNBEGIN                0         10        0
cache buffers lru chain  kcbzgm                           0          2        0
library cache            kglic                            0         17        0
library cache            kglLockCursor                    0          6        7
library cache            kgldti: 2child                   0          2        0
library cache            kgldte: child 0                  0          1       19
library cache            kglhdgc: child:                  0          1        0
library cache            kglhdiv: child                   0          1        0
library cache            kglobpn: child:                  0          1        3
library cache            kglpin                           0          1        1
library cache            kglpndl: child: before pro       0          1        1
library cache            kglpur: child                    0          1        2
library cache lock       kgllkdl: child: no lock ha       0          2        1
library cache lock alloc kgllkget                         0          4        4
multiblock read objects  kcbzib: normal mbr free          0          4        2
object queue header oper kcbw_unlink_q                    0          1        0
redo allocation          kcrfw_redo_gen                   0          3        3
row cache objects        kqreqd                           0          2        0
row cache objects        kqreqd: reget                    0          2        0
session allocation       ksudlc                           0          3        1
session allocation       ksuprc                           0          2        1
session idle bit         ksupuc: clear busy               0         14        8
session idle bit         ksupuc: set busy                 0         12       15
session idle bit         ksuxds                           0          1        4
shared pool              kgh_next_free                    0          3        0
simulator lru latch      kcbs_simulate: simulate se       0        200      203
simulator lru latch      kcbs_lookup_setid                0          3        0
simulator lru latch      kcbs_free_granule_sim_buff       0          1        0
          -------------------------------------------------------------

Parent Latch Statistics                DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Child Latch Statistics                  DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Segments by Logical Reads              DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Logical Reads:      54,024,654
-> Captured Segments account for   91.4% of Total

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI_EXTE DATA_TS    COURSEMANAGEMENT_INS            TABLE   10,982,288   20.33
SAKAI_EXTE DATA_TS    CM_INST_TA_PERSON_ID            INDEX    3,658,144    6.77
SYS        SYSTEM     IND$                            TABLE    3,491,856    6.46
SYS        SYSTEM     TAB$                            TABLE    3,476,544    6.44
SYS        SYSTEM     CLU$                            TABLE    3,466,080    6.42
          -------------------------------------------------------------

Segments by Physical Reads              DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> Total Physical Reads:       1,357,629
-> Captured Segments account for    45.9% of Total

           Tablespace                      Subobject  Obj.      Physical
Owner         Name    Object Name            Name     Type         Reads  %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SAKAI      DATA_TS    CONTENT_RESOURCE                TABLE      174,818   12.88
SAKAI_EXTE DATA_TS    COURSEMANAGEMENT_SEC            TABLE      154,680   11.39
SAKAI      DATA_TS    SAKAI_SESSION                   TABLE       58,931    4.34
SAKAI      DATA_TS    SYS_LOB0000046053C00            LOB         42,598    3.14
SAKAI      DATA_TS    CONTENT_COLLECTION              TABLE       36,669    2.70
          -------------------------------------------------------------

Segments by Row Lock Waits             DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> % 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           32   41.03
SAKAI      DATA_TS    IE_SAKAI_SITE_FLAGS             INDEX           31   39.74
SYS        SYSTEM     DBMS_LOCK_ALLOCATED             TABLE            4    5.13
SYS        SYSAUX     I_WRI$_OPTSTAT_H_OBJ            INDEX            4    5.13
SAKAI      DATA_TS    SYS_C003787                     INDEX            2    2.56
          -------------------------------------------------------------

Segments by ITL Waits                   DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

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

                                                                  Buffer
           Tablespace                      Subobject  Obj.          Busy    % of
Owner         Name    Object Name            Name     Type         Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS        SYSTEM     SUM$                            TABLE            6   60.00
SYS        SYSTEM     I_JOB_NEXT                      INDEX            2   20.00
SYS        SYSTEM     DBMS_LOCK_ALLOCATED             TABLE            1   10.00
SAKAI      DATA_TS    SAKAI_SESSION                   TABLE            1   10.00
          -------------------------------------------------------------

Dictionary Cache Stats                 DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> "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                      51    0.0       0   N/A        2          1
dc_constraints                     312   33.3       0   N/A      312          1
dc_database_links                  491    0.0       0   N/A        0          6
dc_global_oids                      78    0.0       0   N/A        0        151
dc_histogram_data                9,853   23.1       0   N/A    4,421     12,264
dc_histogram_defs               14,976   22.8       0   N/A    2,505      5,713
dc_object_ids                   17,524    0.4       0   N/A       51      2,539
dc_objects                       9,034    3.2       0   N/A      145      3,238
dc_profiles                        110    0.0       0   N/A        0          1
dc_rollback_segments            12,316    0.0       0   N/A        0        392
dc_segments                     13,166    0.1       0   N/A        5      2,465
dc_sequences                       355    0.0       0   N/A      355         55
dc_table_scns                       35  100.0       0   N/A        0          0
dc_tablespace_quotas                 2    0.0       0   N/A        1          6
dc_tablespaces                 526,368    0.0       0   N/A        0          9
dc_usernames                     2,624    0.0       0   N/A        0         36
dc_users                       536,412    0.0       0   N/A        0         88
global database name                82    0.0       0   N/A        0          1
outstanding_alerts                  88    0.0       0   N/A        0         17
          -------------------------------------------------------------

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

                         Get    Pct            Pin    Pct             Invali-
Namespace           Requests   Miss       Requests   Miss    Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                   1,031    0.0          1,263    0.0          0        0
CLUSTER                   34    0.0             79    0.0          0        0
INDEX                    922   14.4          3,263    9.0          0        0
SQL AREA               1,066  100.0        744,672    0.9      1,487      266
TABLE/PROCEDURE        5,325    1.0         30,196    2.6        340        0
TRIGGER                  558    0.0            652    0.0          0        0
          -------------------------------------------------------------

Process Memory Summary                 DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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        772.9       N/A       .7      2.3      64      64  1,042  1,042
  Freeable     162.9        .0       .7      2.8      45     N/A    245    245
  SQL           71.3      22.8       .1       .1       1     106  1,031  1,023
  PL/SQL         2.7        .6       .0       .0       0       0  1,040  1,040
E Other        767.0       N/A       .7      2.3      64      64  1,039  1,039
  Freeable     121.3        .0       .5       .3       1     N/A    241    241
  SQL           71.6      22.8       .1       .1       1     106  1,028  1,022
  PL/SQL         2.6        .4       .0       .0       0       0  1,037  1,037
          -------------------------------------------------------------

SGA Memory Summary                      DB/Inst: SAKAI/sakai  Snaps: 3268-3269

                                                      End Size (Bytes)
SGA regions                     Begin Size (Bytes)      (if different)
------------------------------ ------------------- -------------------
Database Buffers                       788,529,152         754,974,720
Fixed Size                               1,262,764
Redo Buffers                            15,511,552
Variable Size                        1,291,848,532       1,325,402,964
                               -------------------
sum                                  2,097,152,000
          -------------------------------------------------------------

SGA breakdown difference                DB/Inst: SAKAI/sakai  Snaps: 3268-3269
-> 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                                  54.9           58.6    6.68
shared Heap0: KGL                               10.5           11.0    4.65
shared KGH: NO ACCESS                           69.3           69.3    0.00
shared KGLS heap                                10.5            9.2  -12.17
shared KTI-UNDO                                 14.7           14.7    0.00
shared PCursor                                  20.1           20.9    4.00
shared event statistics per sess                15.7           15.7    0.00
shared free memory                              86.2           80.1   -7.06
shared library cache                            32.6           33.9    3.85
shared private strands                          14.2           14.2    0.00
shared sessions                                  9.4            9.4    0.00
shared sql area                                307.9          339.8   10.36
shared trace buffer                             16.5           16.5    0.00
       buffer_cache                            752.0          720.0   -4.26
       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: 3268-3269

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

Streams Capture                         DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Streams Apply                           DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Buffered Queues                         DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Buffered Subscribers                    DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

Rule Set                                DB/Inst: SAKAI/sakai  Snaps: 3268-3269

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

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

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

init.ora Parameters                    DB/Inst: SAKAI/sakai  Snaps: 3268-3269

                                                                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