STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
 ------------ ----------- ------------ -------- ----------- ------- ------------
 
NGK            1216691867  ngk                  1   9 . 2 . 0 . 1 . 0    NO      rs6h7

            Snap Id     Snap Time      Sessions Curs/Sess Comment
             ------- ------------------ -------- --------- -------------------
 
Begin Snap:        6   07 -Mar- 03   09 : 25 : 19         31        10 . 9 
  End Snap:       10   07 -Mar- 03   10 : 19 : 32         54        10 . 0 
   Elapsed:                54 . 22  (mins)

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
               Buffer Cache:       464M      Std Block Size:        16K
           Shared Pool Size:       304M          Log Buffer:      2 ,048K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                    ---------------       ---------------
 
                  Redo size:              17 , 652 . 34                5 , 640 . 22 
              Logical reads:               8 , 886 . 97                2 , 839 . 54 
              Block changes:                  95 . 44                   30 . 49 
             Physical reads:                  33 . 15                   10 . 59 
            Physical writes:                   6 . 00                    1 . 92 
                 User calls:                  11 . 73                    3 . 75 
                     Parses:                  10 . 32                    3 . 30 
                Hard parses:                   3 . 11                    0 . 99 
                      Sorts:               3 , 368 . 04                1 , 076 . 14 
                     Logons:                   0 . 02                    0 . 01 
                   Executes:               1 , 049 . 44                  335 . 31 
               Transactions:                   3 . 13 

  % Blocks changed per Read:     1 . 07     Recursive Call %:     99 . 53 
 Rollback per transaction %:     0 . 87        Rows per Sort:      1 . 67 

Instance Efficiency Percentages (Target  100 %)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   100 . 00        Redo NoWait %:    99 . 85 
            Buffer  Hit   %:    99 . 65     In-memory Sort %:   100 . 00 
            Library Hit   %:    99 . 38         Soft Parse %:    69 . 88 
         Execute to Parse %:    99 . 02          Latch Hit %:    99 . 96 
Parse CPU to Parse Elapsd %:    56 . 10      % Non-Parse CPU:    99 . 24 

 Shared Pool Statistics        Begin   End
                                ------  ------
 
             Memory Usage %:    64 . 22     64 . 16 
    % SQL with executions> 1 :    51 . 15     11 . 34 
  % Memory for SQL w/exec> 1 :    36 . 45     20 . 31 

Top  5  Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
 -------------------------------------------- ------------ ----------- --------
 
CPU time                                                         6 , 893      89 . 21 
library cache pin                                      154           457       5 . 91 
db file sequential read                             20 , 630           178       2 . 31 
db file scattered read                               4 , 335            88       1 . 14 
latch free                                           5 , 442            40       . 52 
           -------------------------------------------------------------
 
Wait Events for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> 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
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
 ---------------------------- ------------ ---------- ---------- ------ --------
 
library cache pin                      154          152          457     2966        0 . 0 
db file sequential read             20 , 630            0          178        9        2 . 0 
db file scattered read               4 , 335            0           88       20        0 . 4 
latch free                           5 , 442           71           40        7        0 . 5 
SQL*Net message from dblink            134            0           21      154        0 . 0 
log file parallel write             12 , 114       11 , 905           12        1        1 . 2 
log file sync                        6 , 649            0           11        2        0 . 7 
db file parallel write               1 , 608          793            8        5        0 . 2 
SQL*Net break/reset to clien           328            0            6       18        0 . 0 
control file parallel write          2 , 774            0            6        2        0 . 3 
log file switch completion             233            0            2        9        0 . 0 
direct path read                     5 , 652            0            2        0        0 . 6 
log file switch (checkpoint              3            1            1      337        0 . 0 
control file sequential read         5 , 135            0            1        0        0 . 5 
LGWR wait for redo copy                455           27            1        2        0 . 0 
library cache lock                       1            0            0      331        0 . 0 
direct path write                    5 , 622            0            0        0        0 . 6 
SQL*Net more data from dblin             6            0            0       26        0 . 0 
db file parallel read                    4            0            0       25        0 . 0 
SQL*Net more data to client            970            0            0        0        0 . 1 
log file single write                  246            0            0        0        0 . 0 
log file sequential read               246            0            0        0        0 . 0 
SQL*Net message to dblink              134            0            0        0        0 . 0 
buffer busy waits                        1            0            0        0        0 . 0 
SQL*Net message from client         37 , 496            0       40 , 910     1091        3 . 7 
virtual circuit status                 109          109        3 , 187    29235        0 . 0 
wakeup time manager                    102          102        3 , 033    29731        0 . 0 
SQL*Net more data from clien         2 , 642            0          283      107        0 . 3 
jobq slave wait                         20           20           60     3004        0 . 0 
SQL*Net message to client           37 , 519            0            0        0        3 . 7 
           -------------------------------------------------------------
 
Background Wait Events for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
 ---------------------------- ------------ ---------- ---------- ------ --------
 
log file parallel write             12 , 117       11 , 908           12        1        1 . 2 
db file parallel write               1 , 608          793            8        5        0 . 2 
control file parallel write          2 , 774            0            6        2        0 . 3 
db file scattered read                  35            0            2       63        0 . 0 
direct path read                     5 , 612            0            2        0        0 . 6 
latch free                              66           41            2       26        0 . 0 
LGWR wait for redo copy                455           27            1        2        0 . 0 
control file sequential read         3 , 137            0            0        0        0 . 3 
db file sequential read                 37            0            0        7        0 . 0 
direct path write                    5 , 612            0            0        0        0 . 6 
log file single write                  246            0            0        0        0 . 0 
log file switch completion               1            0            0       25        0 . 0 
log file sequential read               246            0            0        0        0 . 0 
rdbms ipc message                   29 , 202       16 , 829       19 , 075      653        2 . 9 
smon timer                              11            9        2 , 903  ######       0 . 0 
           -------------------------------------------------------------
 
SQL ordered by Gets for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Buffer Gets Threshold:    10000 
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed  100 

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 
      13 , 047 , 228      1 , 092 , 597             11 . 9     45 . 1    1602 . 43     1517 . 05    836296464 
select * from structure_dep connect by (id=prior code_subordinat
e) start with id=:b1 order by level

       8 , 068 , 939        537 , 923             15 . 0     27 . 9     261 . 13      248 . 55   3520716750 
select * from table_num where facts_id=:b2 and date_enter<=:b1 a
nd (date_end>:b1 or date_end is null)

       2 , 152 , 120        538 , 028              4 . 0      7 . 4      63 . 90       55 . 34   3266540580 
SELECT table_num from facts where id=:b1

       2 , 151 , 084        537 , 769              4 . 0      7 . 4      69 . 83       69 . 88   2437659183 
SELECT sp_order_types_id,facts_id_old from facts where id=:b1

         944 , 018              1        944 , 018 . 0      3 . 3     300 . 26      297 . 43   4033790661 
select * from rest_while_3  where  date_end is null and  facts_i
d in   (select facts_id from order_items_fact_working_site where
 order_item_id in   ( select id from order_items where sp_order_
types_id= 5158 ))

         144 , 469              1        144 , 469 . 0      0 . 5      46 . 53       52 . 55    866474825 
select fio(persons_id),a.* from rest_while_3 a where  date_end i
s null and facts_id in (select facts_id from order_items_fact_wo
rking_site where order_item_id in ( select id from order_items w
here sp_order_types_id= 5158 ))

          90 , 372          7 , 531             12 . 0      0 . 3       2 . 12        2 . 69   3940642606 
select oi.sp_deps_id,oi.sp_order_types_id,f.sp_deps_id_new,f.fac
ts_previos_id             from orders o,order_items oi,order_ite
ms_fact_working_site oif,facts f             where f.id=:b2 and
o.id=:b1                   and o.id=oi.orders_id
   and oif.order_item_id=oi.id and oif.facts_id = f.id

          82 , 951          7 , 541             11 . 0      0 . 3       2 . 81       15 . 65   3456347471 
select oi.sp_deps_id,oi.sp_order_types_id,f.facts_previos_id
         from order_items oi,order_items_fact_working_site oif,f
acts f             where f.id=:b1 and oif.order_item_id=oi.id an
d oif.facts_id = f.id

          52 , 767             31          1 , 702 . 2      0 . 2      32 . 24       34 . 45   3802451188 
insert into source$(obj#,line,source) values (: 1 ,: 2 ,: 3 )

          48 , 584              3         16 , 194 . 7      0 . 2       5 . 25        6 . 43   3519849434 
  SELECT     SESSION_ID,     DEPT_ID,     НАИМЕНОВАНИЕ,     ДАТА
_ЗАГРУЗКИ,     ВЫГР_ПАКЕТ,     ЗАГР_ПАКЕТ,     ВХОД_ВСЕГО_ПРИК,
    ВХОД_ВСЕГО_СОТР,     ВХОД_ПОДТВ_ПРИК,     ВХОД_ПОДТВ_СОТР,
   ПОДТВ_ПРИК,     ПОДТВ_СОТР,     ПРОВЕДЕНО_ПРИК,     ПРОВЕДЕНО
_СОТР,     ОЖИДАНИЕ_ПП_ПРИК,     ОЖИДАНИЕ_ПП_СОТР,     НЕ_ПРОВЕД

          28 , 584             65            439 . 8      0 . 1      12 . 73       15 . 73   3605072212 
SQL ordered by Gets for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Buffer Gets Threshold:    10000 
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed  100 

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 
delete from source$ where obj#=: 1 

          28 , 120              1         28 , 120 . 0      0 . 1       1 . 53        1 . 56   1944633091 
 /* OracleOEM */  SELECT DISTINCT owner FROM all_objects ORDER BY
owner

          22 , 556              3          7 , 518 . 7      0 . 1       0 . 71        0 . 92   1211872341 
 select table_name     ,nested     ,partitioned     ,IOT_type
from ALL_TABLES where   owner='KADR$'   and NVL(IOT_type,'NORMAL
') != 'IOT_OVERFLOW'   order by table_name

          21 , 711              3          7 , 237 . 0      0 . 1       1 . 15        1 . 68   1854504764 
select LEVEL, NAME, ROWID InternalRowid from structure_dep where
 level= 3  connect by prior id = code_subordinate And date_end Is
Null start with id= 106553  order by name

          18 , 737             13          1 , 441 . 3      0 . 1      13 . 06       27 . 94   2972966773 
select distinct name from kadr$.gni_street where gninmb='2457' o
rder by name

          17 , 315              2          8 , 657 . 5      0 . 1       1 . 64        1 . 62   3498467651 
select p.persons_id ID,kadr$do.FIO(p.persons_id) FIO,KADR$do.DAT
E_BIRTH(p.persons_id) DATE_BIRTH        ,kadr$.dep_all_dat(facts
.sp_deps_id,'07.03.2003') podr        ,prof.full_name        ,sp
_orders_types.name        ,sp_sh_ne.name        ,DATE_APPOINTMEN
T,DATE_REST_END        ,p.ORDER_ITEM_ID,p.ORDER_ITEM_ID_BREAK fr

          15 , 627          7 , 812              2 . 0      0 . 1       0 . 76        0 . 73   2532871594 
SELECT id_first from KADR$.sp_orders_types where id=:b1

          11 , 871          3 , 957              3 . 0      0 . 0       0 . 54        0 . 50   1566816780 
select name as w_name from  personal.structure_dep where id=:b2
and      date_enter <=to_date(:b1,'dd.mm.yyyy') and (date_end is
 null or date_end>to_date(:b1,'dd.mm.yyyy'))

          11 , 871            738             16 . 1      0 . 0       1 . 09        0 . 99   2224843683 
select id,level, name From personal.structure_dep   connect by p
rior code_subordinate=id start with id=:b1

          11 , 871            738             16 . 1      0 . 0       0 . 93        0 . 96   3255056754 
SELECT max(level) From personal.structure_dep connect by prior c
ode_subordinate=id start with id=:b1

          11 , 871            738             16 . 1      0 . 0       1 . 05        0 . 97   3919940877 
select name   From personal.structure_dep  where  level<=:b2- 3 
connect by prior code_subordinate=id start with id=:b1

          11 , 486          3 , 957              2 . 9      0 . 0       0 . 63        0 . 82   2465027087 
select name  from personal.structure_dep_history where id_struct
ure_dep=:b2 and      date_appointment <=to_date(:b1,'dd.mm.yyyy'
SQL ordered by Gets for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Buffer Gets Threshold:    10000 
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed  100 

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 
) and (date_end is null or date_end>to_date(:b1,'dd.mm.yyyy'))

          10 , 480            192             54 . 6      0 . 0       3 . 87        6 . 17   3127902425 
delete from argument$ where obj#=: 1 

           9 , 999            924             10 . 8      0 . 0       0 . 69        1 . 37     13666001 
SELECT id from( select id   from kadr$do.facts   where persons_i
d = :b2 and date_x <= to_date(:b1,'dd.mm.yyyy.hh24.mi.ss')+ 23 / 24 
 order by date_x desc) where rownum <  2 

           9 , 340            132             70 . 8      0 . 0       4 . 31        5 . 50    449029010 
delete from dependency$ where d_obj#=: 1 

           9 , 282          2 , 478              3 . 7      0 . 0       0 . 69        0 . 60   2014290192 
SELECT count(*) from order_log_count where  session_id=:b1 and i

           -------------------------------------------------------------
 
SQL ordered by Reads for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Disk Reads Threshold:     1000 

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 
          18 , 432             13          1 , 417 . 8     17 . 1      13 . 06       27 . 94   2972966773 
select distinct name from kadr$.gni_street where gninmb='2457' o
rder by name

           6 , 500              2          3 , 250 . 0      6 . 0       2 . 85        3 . 46   3352266221 
select  1  as indent, 'a'|| id_address as id_address,'a' || mgr as
 mgr,  sp_address.name as name, sp_address.sp_address_elements_i
d as el_adr,    sp_address.date_begin as date_begin, sp_address.
date_end as date_end from  sp_address where mgr is null

           1 , 653          7 , 541              0 . 2      1 . 5       2 . 81       15 . 65   3456347471 
select oi.sp_deps_id,oi.sp_order_types_id,f.facts_previos_id
         from order_items oi,order_items_fact_working_site oif,f
acts f             where f.id=:b1 and oif.order_item_id=oi.id an
d oif.facts_id = f.id

           1 , 230              6            205 . 0      1 . 1       6 . 01       13 . 64   2734029811 
INSERT into stats$sql_statistics              ( snap_id
     , dbid              , instance_number              , total_
sql              , total_sql_mem              , single_use_sql
            , single_use_sql_mem              )         select :
b3              , :b2              , :b1              , count( 1 )

           1 , 080              1          1 , 080 . 0      1 . 0      46 . 53       52 . 55    866474825 
select fio(persons_id),a.* from rest_while_3 a where  date_end i
s null and facts_id in (select facts_id from order_items_fact_wo
rking_site where order_item_id in ( select id from order_items w
here sp_order_types_id= 5158 ))

             328            432              0 . 8      0 . 3       0 . 56        3 . 97   1669987190 
update idl_ub1$ set piece#=: 1  ,length=: 2  , piece=: 3  where obj#=:
 4  and part=: 5  and piece#=: 6  and version=: 7 

             285        537 , 769              0 . 0      0 . 3      69 . 83       69 . 88   2437659183 
SELECT sp_order_types_id,facts_id_old from facts where id=:b1

             195            316              0 . 6      0 . 2       0 . 18        2 . 79    374166399 
SELECT order_number from orders, order_items        where orders
.id=order_items.orders_id and order_items.id=:b1

             178            429              0 . 4      0 . 2       0 . 29        2 . 77   3111103299 
select  /*+ index(idl_ub1$ i_idl_ub11) +*/  piece#,length,piece fr
om idl_ub1$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

             164            429              0 . 4      0 . 2       0 . 23        2 . 34   1428100621 
select  /*+ index(idl_ub2$ i_idl_ub21) +*/  piece#,length,piece fr
om idl_ub2$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

             154          7 , 531              0 . 0      0 . 1       2 . 12        2 . 69   3940642606 
select oi.sp_deps_id,oi.sp_order_types_id,f.sp_deps_id_new,f.fac
ts_previos_id             from orders o,order_items oi,order_ite
ms_fact_working_site oif,facts f             where f.id=:b2 and
SQL ordered by Reads for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Disk Reads Threshold:     1000 

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 
o.id=:b1                   and o.id=oi.orders_id
   and oif.order_item_id=oi.id and oif.facts_id = f.id

             147              1            147 . 0      0 . 1     300 . 26      297 . 43   4033790661 
select * from rest_while_3  where  date_end is null and  facts_i
d in   (select facts_id from order_items_fact_working_site where
 order_item_id in   ( select id from order_items where sp_order_
types_id= 5158 ))

             130            268              0 . 5      0 . 1       0 . 13        2 . 24   1460958497 
SELECT sp_deps_id from order_items where id=:b1

             120            924              0 . 1      0 . 1       0 . 69        1 . 37     13666001 
SELECT id from( select id   from kadr$do.facts   where persons_i
d = :b2 and date_x <= to_date(:b1,'dd.mm.yyyy.hh24.mi.ss')+ 23 / 24 
 order by date_x desc) where rownum <  2 

             118             65              1 . 8      0 . 1      12 . 73       15 . 73   3605072212 
delete from source$ where obj#=: 1 

             103              3             34 . 3      0 . 1       5 . 25        6 . 43   3519849434 
  SELECT     SESSION_ID,     DEPT_ID,     НАИМЕНОВАНИЕ,     ДАТА
_ЗАГРУЗКИ,     ВЫГР_ПАКЕТ,     ЗАГР_ПАКЕТ,     ВХОД_ВСЕГО_ПРИК,
    ВХОД_ВСЕГО_СОТР,     ВХОД_ПОДТВ_ПРИК,     ВХОД_ПОДТВ_СОТР,
   ПОДТВ_ПРИК,     ПОДТВ_СОТР,     ПРОВЕДЕНО_ПРИК,     ПРОВЕДЕНО
_СОТР,     ОЖИДАНИЕ_ПП_ПРИК,     ОЖИДАНИЕ_ПП_СОТР,     НЕ_ПРОВЕД

              84            319              0 . 3      0 . 1       0 . 39        1 . 87   1819073277 
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_
obj#, d_owner#, nvl(property, 0 ),subname from dependency$,obj$ wh
ere d_obj#=: 1  and p_obj#=obj#(+) order by order#

              66            429              0 . 2      0 . 1       0 . 31        1 . 32   3218356218 
select  /*+ index(idl_sb4$ i_idl_sb41) +*/  piece#,length,piece fr
om idl_sb4$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

              62            192              0 . 3      0 . 1       3 . 87        6 . 17   3127902425 
delete from argument$ where obj#=: 1 

              54            319              0 . 2      0 . 1       0 . 27        0 . 72   4049165760 
select order#,columns,types from access$ where d_obj#=: 1 

              50              2             25 . 0      0 . 0       0 . 23        3 . 10   1040953394 
Module: Spotlight On Oracle
SELECT  --CloseCursor        ROUND(a.size_mb) total_MB,        a.
 
files          database_files,        ROUND(b.size_mb) free_MB,
       ROUND(a.size_mb-b.size_mb)    used_mb,        ROUND((a.si
ze_mb-b.size_mb)* 100 /a.size_mb) pct_used,        a.tss tablespac
e_count   FROM quest_soo_datafile a,  quest_soo_free_space b

              48              9              5 . 3      0 . 0       0 . 04        0 . 13   1714733582 
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t whe
re t.ts#=f.ts# and t.dflextpct!= 0  and t.bitmapped= 0 
SQL ordered by Reads for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Disk Reads Threshold:     1000 

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
 --------------- ------------ -------------- ------ -------- --------- ----------
 

           -------------------------------------------------------------
 
SQL ordered by Executions for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Executions Threshold:      100 

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
 ------------ --------------- ---------------- ----------- ---------- ----------
 
    1 , 092 , 597         4 , 297 , 264                3 . 9         0 . 00          0 . 00    836296464 
select * from structure_dep connect by (id=prior code_subordinat
e) start with id=:b1 order by level

      538 , 028           538 , 028                1 . 0         0 . 00          0 . 00   3266540580 
SELECT table_num from facts where id=:b1

      537 , 923                 1                0 . 0         0 . 00          0 . 00   3520716750 
select * from table_num where facts_id=:b2 and date_enter<=:b1 a
nd (date_end>:b1 or date_end is null)

      537 , 788                 0                0 . 0         0 . 00          0 . 00   2581866120 
select facts_id_old,sp_order_types_id  from facts where id=:b1

      537 , 769           537 , 769                1 . 0         0 . 00          0 . 00   2437659183 
SELECT sp_order_types_id,facts_id_old from facts where id=:b1

        7 , 812             7 , 812                1 . 0         0 . 00          0 . 00   2532871594 
SELECT id_first from KADR$.sp_orders_types where id=:b1

        7 , 541             7 , 541                1 . 0         0 . 00          0 . 00   3456347471 
select oi.sp_deps_id,oi.sp_order_types_id,f.facts_previos_id
         from order_items oi,order_items_fact_working_site oif,f
acts f             where f.id=:b1 and oif.order_item_id=oi.id an
d oif.facts_id = f.id

        7 , 531             7 , 531                1 . 0         0 . 00          0 . 00   3940642606 
select oi.sp_deps_id,oi.sp_order_types_id,f.sp_deps_id_new,f.fac
ts_previos_id             from orders o,order_items oi,order_ite
ms_fact_working_site oif,facts f             where f.id=:b2 and
o.id=:b1                   and o.id=oi.orders_id
   and oif.order_item_id=oi.id and oif.facts_id = f.id

        6 , 671                 0                0 . 0         0 . 00          0 . 00   2688585178 
commit

        3 , 957             3 , 520                0 . 9         0 . 00          0 . 00   1566816780 
select name as w_name from  personal.structure_dep where id=:b2
and      date_enter <=to_date(:b1,'dd.mm.yyyy') and (date_end is
 null or date_end>to_date(:b1,'dd.mm.yyyy'))

        3 , 957             2 , 622                0 . 7         0 . 00          0 . 00   2465027087 
select name  from personal.structure_dep_history where id_struct
ure_dep=:b2 and      date_appointment <=to_date(:b1,'dd.mm.yyyy'
) and (date_end is null or date_end>to_date(:b1,'dd.mm.yyyy'))

        3 , 459                 0                0 . 0         0 . 00          0 . 00   3615375148 
COMMIT

        2 , 478             2 , 478                1 . 0         0 . 00          0 . 00   2014290192 
SELECT count(*) from order_log_count where  session_id=:b1 and i
n_out= 3 

        2 , 130                 0                0 . 0         0 . 05          0 . 05    126953594 
SQL ordered by Executions for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Executions Threshold:      100 

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
 ------------ --------------- ---------------- ----------- ---------- ----------
 
Module: Spotlight On Oracle
INSERT INTO quest_soo_buffer_busy          (timestamp, p1, p2, p
 3 )          SELECT SYSDATE, p1, p2, p3            FROM v$session
_wait           WHERE event = 'buffer busy waits'

        1 , 942             1 , 942                1 . 0         0 . 00          0 . 00   3556927965 
Module: Spotlight On Oracle
SELECT DECODE(:b1,'BL','Buffer hash table instance lock','CF','C
ontrol file schema global enqueue lock','CI','Cross-instance fun
ction invocation instance lock','CS','Control file schema global
 enqueue lock','CU','Cursor bind lock','DF','Data file instance
lock','DL','Direct loader parallel index create','DM','Mount/sta

       1,731           1,731              1.0       0.00        0.00  411033441
insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_times
tamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7)

       1,436           1,343              0.9       0.00        0.00  787810128
select %af_src_comm_4 bucket_cnt, row_cnt, cache_cnt, null_cnt, tim
estamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
density, col#, spare1, spare2, avgcln from hist_head$ where obj#
=:1 and intcol#=:2

       1,416           1,416              1.0       0.00        0.00  702259901
SELECT sum(count_s) from order_log_count         where session_i
d=:b3 and in_out=:b2 and status=:b1

       1,416           1,416              1.0       0.00        0.00 2449474733
SELECT sum(count_h) from order_log_count         where session_i
d=:b3 and in_out=:b2 and status=:b1

       1,204           1,204              1.0       0.00        0.00  584010540
SELECT sum(count_h) from order_log_count                 where s
ession_id=:b2 and in_out=3 and status=:b1

       1,204           1,204              1.0       0.00        0.00 4079341897
SELECT sum(count_s) from order_log_count                 where s
ession_id=:b2 and in_out=3 and status=:b1

       1,200           1,200              1.0       0.00        0.00 2116980823
insert into access$(d_obj#,order#,columns,types) values (:1,:2,:
3,:4)

       1,139           1,361              1.2       0.00        0.00 2085632044
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1

         969             961              1.0       0.00        0.00 3016965513
update sys.col_usage$ set   equality_preds    = equality_preds
  + decode(bitand(:flag,1),0,0,1),   equijoin_preds    = equijoi
n_preds    + decode(bitand(:flag,2),0,0,1),   nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1),   range_pre
ds       = range_preds       + decode(bitand(:flag,8),0,0,1),

         924             924              1.0       0.00        0.00   13666001
SQL ordered by Executions for DB: NGK  Instance: ngk  Snaps: 6 -10
-> End Executions Threshold:     100

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
SELECT id from( select id   from kadr$do.facts   where persons_i
d = :b2 and date_x <= to_date(:b1,'dd.mm.yyyy.hh24.mi.ss')+ 23 / 24 
 order by date_x desc) where rownum <  2 

          738             3 , 957                5 . 4         0 . 00          0 . 00   2224843683 
select id,level, name From personal.structure_dep   connect by p
rior code_subordinate=id start with id=:b1

          738               738                1 . 0         0 . 00          0 . 00   3255056754 
SELECT max(level) From personal.structure_dep connect by prior c
ode_subordinate=id start with id=:b1

           -------------------------------------------------------------
 
SQL ordered by Parse Calls for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Parse Calls Threshold:       1000 

                           % Total
 Parse Calls  Executions   Parses  Hash Value
 ------------ ------------ -------- ----------
 
        6 , 671          6 , 671      19 . 88   2688585178 
commit

          430            430       1 . 28   2644650677 
select o.owner#, u.name,        o.name,            o.namespace,
        o.obj#,   d.d_timestamp, nvl(d.property, 0 ), o.type#, o.s
ubname  from dependency$ d, obj$ o, user$ u  where d.p_obj#=: 1 
and   (d.p_timestamp=: 2  or d.property= 2 )  and   d.d_obj#=o.obj#
 and   o.owner#=u.user#  and decode(: 3 , 0 , 0 ,o.type#)=: 3 

          429            429       1 . 28    957616262 
select  /*+ index(idl_char$ i_idl_char1) +*/  piece#,length,piece
from idl_char$ where obj#=: 1  and part=: 2  and version=: 3  order by
 piece#

          429            429       1 . 28   1428100621 
select  /*+ index(idl_ub2$ i_idl_ub21) +*/  piece#,length,piece fr
om idl_ub2$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

          429            429       1 . 28   3111103299 
select  /*+ index(idl_ub1$ i_idl_ub11) +*/  piece#,length,piece fr
om idl_ub1$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

          429            429       1 . 28   3218356218 
select  /*+ index(idl_sb4$ i_idl_sb41) +*/  piece#,length,piece fr
om idl_sb4$ where obj#=: 1  and part=: 2  and version=: 3  order by pi
ece#

          390            390       1 . 16   1966425544 
select text from view$ where rowid=: 1 

          385            969       1 . 15   3016965513 
update sys.col_usage$ set   equality_preds    = equality_preds
  + decode(bitand(:flag, 1 ), 0 , 0 , 1 ),   equijoin_preds    = equijoi
n_preds    + decode(bitand(:flag, 2 ), 0 , 0 , 1 ),   nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag, 4 ), 0 , 0 , 1 ),   range_pre
ds       = range_preds       + decode(bitand(:flag, 8 ), 0 , 0 , 1 ),

          319            319       0 . 95   1819073277 
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_
obj#, d_owner#, nvl(property, 0 ),subname from dependency$,obj$ wh
ere d_obj#=: 1  and p_obj#=obj#(+) order by order#

          319            319       0 . 95   4049165760 
select order#,columns,types from access$ where d_obj#=: 1 

          315            315       0 . 94   3395484199 
update obj$ set obj#=: 6 ,type#=: 7 ,ctime=: 8 ,mtime=: 9 ,stime=: 10 ,sta
tus=: 11 ,dataobj#=: 13 ,flags=: 14 ,oid$=: 15 ,spare1=: 16 , spare2=: 17  w
here owner#=: 1  and name=: 2  and namespace=: 3  and(remoteowner=: 4  o
r remoteowner is null and : 4  is null)and(linkname=: 5  or linkname
 is null and : 5  is null)and(subname=: 12  or subname is null and :
SQL ordered by Parse Calls for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Parse Calls Threshold:       1000 

                           % Total
 Parse Calls  Executions   Parses  Hash Value
 ------------ ------------ -------- ----------
 

          297            297       0 . 88   4059714361 
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
,iniexts,NVL(lists, 65535 ),NVL(groups, 65535 ),cachehint,hwmincr, N
VL(spare1, 0 ) from seg$ where ts#=: 1  and file#=: 2  and block#=: 3 

          265            433       0 . 79   2385919346 
select name,intcol#,segcol#,type#,length,nvl(precision#, 0 ),decod
e(type#, 2 ,nvl(scale,- 127  /*MAXSB1MINAL*/ ), 178 ,scale, 179 ,scale, 180 
,scale, 181 ,scale, 182 ,scale, 183 ,scale, 231 ,scale, 0 ),null$,fixedsto
rage,nvl(deflength, 0 ),default$,rowid,col#,property, nvl(charseti
d, 0 ),nvl(charsetform, 0 ),spare1,spare2,nvl(spare3, 0 ) from col$ wh

          262            423       0 . 78    931956286 
select grantee#,privilege#,nvl(col#, 0 ),max(mod(nvl(option$, 0 ), 2 )
)from objauth$ where obj#=: 1  group by grantee#,privilege#,nvl(co
l#, 0 ) order by grantee#

          233            413       0 . 69   2591785020 
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$,
spare1, spare2 from obj$ where owner#=: 1  and name=: 2  and namespa
ce=: 3  and(remoteowner=: 4  or remoteowner is null and : 4  is null)a
nd(linkname=: 5  or linkname is null and : 5  is null)and(subname=: 6 
 or subname is null and : 6  is null)

          223            356       0 . 66   1453445442 
select col#, grantee#, privilege#,max(mod(nvl(option$, 0 ), 2 )) fro
m objauth$ where obj#=: 1  and col# is not null group by privilege
#, col#, grantee# order by col#, grantee#

          220            220       0 . 66   3348238861 
select audit$,options from procedure$ where obj#=: 1 

          205            326       0 . 61    114078687 
select con#,obj#,rcon#,enabled,nvl(defer, 0 ) from cdef$ where rob
j#=: 1 

          205            326       0 . 61   1536916657 
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,n
vl(enabled, 0 ),rowid,cols,nvl(defer, 0 ),mtime,nvl(spare1, 0 ) from c
def$ where obj#=: 1 

          197            197       0 . 59    335740561 
delete from idl_ub1$ where obj#=: 1  and part=: 2  and (piece#<: 3  or
 piece#>: 4 ) and version=: 5 

          197            197       0 . 59    612528575 
delete from idl_sb4$ where obj#=: 1  and part=: 2  and (piece#<: 3  or
 piece#>: 4 ) and version=: 5 

          197            323       0 . 59   3844343967 
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,
i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i

SQL ordered by Parse Calls for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> End Parse Calls Threshold:       1000 

                           % Total
 Parse Calls  Executions   Parses  Hash Value
 ------------ ------------ -------- ----------
 
           -------------------------------------------------------------
 
Instance Activity Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 

Statistic                                      Total     per Second    per Trans
 --------------------------------- ------------------ -------------- ------------
 
CPU used by this session                      689 , 281            211 . 9           67 . 7 
CPU used when call started                    689 , 287            211 . 9           67 . 7 
CR blocks created                                 206              0 . 1            0 . 0 
Cached Commit SCN referenced                      204              0 . 1            0 . 0 
Commit SCN cached                                   6              0 . 0            0 . 0 
DBWR buffers scanned                            3 , 172              1 . 0            0 . 3 
DBWR checkpoint buffers written                 9 , 524              2 . 9            0 . 9 
DBWR checkpoints                                  123              0 . 0            0 . 0 
DBWR free buffers found                         3 , 124              1 . 0            0 . 3 
DBWR lru scans                                     48              0 . 0            0 . 0 
DBWR make free requests                            48              0 . 0            0 . 0 
DBWR revisited being-written buff                   0              0 . 0            0 . 0 
DBWR summed scan depth                          3 , 172              1 . 0            0 . 3 
DBWR transaction table writes                     444              0 . 1            0 . 0 
DBWR undo block writes                          1 , 955              0 . 6            0 . 2 
SQL*Net roundtrips to/from client              37 , 450             11 . 5            3 . 7 
SQL*Net roundtrips to/from dblink                 134              0 . 0            0 . 0 
active txn count during cleanout                  349              0 . 1            0 . 0 
background checkpoints completed                  123              0 . 0            0 . 0 
background checkpoints started                    123              0 . 0            0 . 0 
background timeouts                             4 , 879              1 . 5            0 . 5 
buffer is not pinned count                 21 , 717 , 639          6 , 676 . 2        2 , 133 . 2 
buffer is pinned count                      2 , 919 , 012            897 . 3          286 . 7 
bytes received via SQL*Net from c          11 , 927 , 884          3 , 666 . 7        1 , 171 . 6 
bytes received via SQL*Net from d              60 , 983             18 . 8            6 . 0 
bytes sent via SQL*Net to client           10 , 773 , 285          3 , 311 . 8        1 , 058 . 2 
bytes sent via SQL*Net to dblink                8 , 510              2 . 6            0 . 8 
calls to get snapshot scn: kcmgss           4 , 559 , 683          1 , 401 . 7          447 . 9 
calls to kcmgas                                14 , 911              4 . 6            1 . 5 
calls to kcmgcs                                   853              0 . 3            0 . 1 
change write time                               6 , 548              2 . 0            0 . 6 
cleanout - number of ktugct calls                 884              0 . 3            0 . 1 
cluster key scan block gets                    22 , 842              7 . 0            2 . 2 
cluster key scans                              12 , 510              3 . 9            1 . 2 
commit cleanout failures: block l                 850              0 . 3            0 . 1 
commit cleanout failures: buffer                   19              0 . 0            0 . 0 
commit cleanout failures: callbac                   4              0 . 0            0 . 0 
commit cleanout failures: cannot                    0              0 . 0            0 . 0 
commit cleanouts                               23 , 825              7 . 3            2 . 3 
commit cleanouts successfully com              22 , 952              7 . 1            2 . 3 
commit txn count during cleanout                1 , 045              0 . 3            0 . 1 
consistent changes                              1 , 664              0 . 5            0 . 2 
consistent gets                            28 , 642 , 213          8 , 804 . 9        2 , 813 . 3 
consistent gets - examination              14 , 600 , 925          4 , 488 . 5        1 , 434 . 1 
cursor authentications                            424              0 . 1            0 . 0 
data blocks consistent reads - un                 345              0 . 1            0 . 0 
db block changes                              310 , 462             95 . 4           30 . 5 
db block gets                                 267 , 113             82 . 1           26 . 2 
deferred (CURRENT) block cleanout              14 , 759              4 . 5            1 . 5 
dirty buffers inspected                            77              0 . 0            0 . 0 
enqueue conversions                               141              0 . 0            0 . 0 
enqueue releases                               30 , 216              9 . 3            3 . 0 
enqueue requests                               30 , 222              9 . 3            3 . 0 
enqueue timeouts                                   12              0 . 0            0 . 0 
enqueue waits                                       0              0 . 0            0 . 0 
execute count                               3 , 413 , 837          1 , 049 . 4          335 . 3 
Instance Activity Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 

Statistic                                      Total     per Second    per Trans
 --------------------------------- ------------------ -------------- ------------
 
free buffer inspected                              95              0 . 0            0 . 0 
free buffer requested                         105 , 501             32 . 4           10 . 4 
hot buffers moved to head of LRU               27 , 717              8 . 5            2 . 7 
immediate (CR) block cleanout app                 100              0 . 0            0 . 0 
immediate (CURRENT) block cleanou               1 , 617              0 . 5            0 . 2 
index fast full scans (full)                        5              0 . 0            0 . 0 
index fetch by key                          5 , 749 , 050          1 , 767 . 3          564 . 7 
index scans kdiixs1                           844 , 916            259 . 7           83 . 0 
leaf node  90 - 10  splits                             30              0 . 0            0 . 0 
leaf node splits                                   89              0 . 0            0 . 0 
logons cumulative                                  73              0 . 0            0 . 0 
messages received                              13 , 210              4 . 1            1 . 3 
messages sent                                  13 , 210              4 . 1            1 . 3 
no buffer to keep pinned count                  6 , 035              1 . 9            0 . 6 
no work - consistent read gets             12 , 085 , 059          3 , 715 . 1        1 , 187 . 0 
opened cursors cumulative                      12 , 957              4 . 0            1 . 3 
parse count (failures)                            114              0 . 0            0 . 0 
parse count (hard)                             10 , 108              3 . 1            1 . 0 
parse count (total)                            33 , 563             10 . 3            3 . 3 
parse time cpu                                  5 , 216              1 . 6            0 . 5 
parse time elapsed                              9 , 297              2 . 9            0 . 9 
physical reads                                107 , 851             33 . 2           10 . 6 
physical reads direct                           6 , 424              2 . 0            0 . 6 
physical writes                                19 , 521              6 . 0            1 . 9 
physical writes direct                          9 , 871              3 . 0            1 . 0 
physical writes non checkpoint                 13 , 849              4 . 3            1 . 4 
pinned buffers inspected                            5              0 . 0            0 . 0 
prefetched blocks                              76 , 908             23 . 6            7 . 6 
prefetched blocks aged out before                   3              0 . 0            0 . 0 
process last non-idle time             67 , 011 , 355 , 188     20 , 599 , 863 . 3    6 , 582 , 001 . 3 
recursive calls                             8 , 073 , 996          2 , 482 . 0          793 . 1 
recursive cpu usage                           604 , 980            186 . 0           59 . 4 
redo blocks written                           121 , 827             37 . 5           12 . 0 
redo buffer allocation retries                    233              0 . 1            0 . 0 
redo entries                                  157 , 414             48 . 4           15 . 5 
redo log space requests                           236              0 . 1            0 . 0 
redo log space wait time                          313              0 . 1            0 . 0 
redo ordering marks                                48              0 . 0            0 . 0 
redo size                                  57 , 423 , 064         17 , 652 . 3        5 , 640 . 2 
redo synch time                                 1 , 123              0 . 4            0 . 1 
redo synch writes                               6 , 933              2 . 1            0 . 7 
redo wastage                                3 , 548 , 244          1 , 090 . 8          348 . 5 
redo write time                                 1 , 376              0 . 4            0 . 1 
redo writer latching time                          67              0 . 0            0 . 0 
redo writes                                    12 , 189              3 . 8            1 . 2 
rollback changes - undo records a              10 , 574              3 . 3            1 . 0 
rows fetched via callback                   4 , 720 , 146          1 , 451 . 0          463 . 6 
session connect time                   67 , 011 , 355 , 188     20 , 599 , 863 . 3    6 , 582 , 001 . 3 
session cursor cache count                         66              0 . 0            0 . 0 
session cursor cache hits                      13 , 468              4 . 1            1 . 3 
session logical reads                      28 , 909 , 311          8 , 887 . 0        2 , 839 . 5 
session pga memory                         23 , 296 , 328          7 , 161 . 5        2 , 288 . 2 
session pga memory max                     68 , 893 , 904         21 , 178 . 6        6 , 766 . 9 
session uga memory                          8 , 361 , 384          2 , 570 . 4          821 . 3 
session uga memory max                     38 , 746 , 880         11 , 911 . 1        3 , 805 . 8 
shared hash latch upgrades - no w             844 , 383            259 . 6           82 . 9 
Instance Activity Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 

Statistic                                      Total     per Second    per Trans
 --------------------------------- ------------------ -------------- ------------
 
shared hash latch upgrades - wait                  83              0 . 0            0 . 0 
sorts (disk)                                        2              0 . 0            0 . 0 
sorts (memory)                             10 , 956 , 224          3 , 368 . 0        1 , 076 . 1 
sorts (rows)                               18 , 342 , 764          5 , 638 . 7        1 , 801 . 7 
summed dirty queue length                         124              0 . 0            0 . 0 
switch current to new buffer                    1 , 545              0 . 5            0 . 2 
table fetch by rowid                        6 , 814 , 687          2 , 094 . 9          669 . 4 
table fetch continued row                          44              0 . 0            0 . 0 
table scan blocks gotten                    7 , 314 , 582          2 , 248 . 6          718 . 5 
table scan rows gotten                     98 , 350 , 115         30 , 233 . 7        9 , 660 . 2 
table scans (long tables)                          43              0 . 0            0 . 0 
table scans (short tables)                    562 , 455            172 . 9           55 . 3 
transaction rollbacks                               5              0 . 0            0 . 0 
user calls                                     38 , 155             11 . 7            3 . 8 
user commits                                   10 , 092              3 . 1            1 . 0 
user rollbacks                                     89              0 . 0            0 . 0 
workarea executions - multipass                     0              0 . 0            0 . 0 
workarea executions - onepass                       2              0 . 0            0 . 0 
workarea executions - optimal              13 , 702 , 730          4 , 212 . 3        1 , 345 . 9 
write clones created in backgroun                   4              0 . 0            0 . 0 
write clones created in foregroun                 408              0 . 1            0 . 0 
           -------------------------------------------------------------
 
Tablespace IO Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->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)
 -------------- ------- ------ ------- ------------ -------- ---------- ------
 
KADRS_BIG
         11 , 121         3     10 . 7       5 . 3          1 , 243          0            0      0 . 0 
I_KADRS_MED
          4 , 701         1      9 . 6       1 . 0          2 , 151          1            0      0 . 0 
KADRS
          5 , 372         2     15 . 5       6 . 1            940          0            0      0 . 0 
SYSTEM
          2 , 470         1     11 . 2       1 . 1          2 , 989          1            0      0 . 0 
UNDOTBS1
            126         0     18 . 4       1 . 0          2 , 536          1            1      0 . 0 
USERS
          1 , 407         0      9 . 7       2 . 0            908          0            0      0 . 0 
I_KADRS_BIG
            840         0     12 . 0       1 . 0            976          0            0      0 . 0 
I_KADRS
            983         0     16 . 4       1 . 2            773          0            0      0 . 0 
BOOK_BIG
            393         0     15 . 6       1 . 0            366          0            0      0 . 0 
I_TMC
            366         0     18 . 4       1 . 0            366          0            0      0 . 0 
I_BOOK_MED
            244         0     15 . 2       1 . 0            244          0            0      0 . 0 
I_BOOK_BIG
            273         0      9 . 3       1 . 0            122          0            0      0 . 0 
I_WWW_MED
            128         0     14 . 8       1 . 0            125          0            0      0 . 0 
WWW
            130         0     17 . 7       1 . 3            122          0            0      0 . 0 
QUEST
            123         0     16 . 6       1 . 0            128          0            0      0 . 0 
I_BOOK_SM
            128         0     14 . 5       1 . 0            122          0            0      0 . 0 
TMC_SM
            127         0     18 . 7       1 . 0            122          0            0      0 . 0 
WWW_MED
            124         0     14 . 9       1 . 0            123          0            0      0 . 0 
KADRS_WORK
            124         0     16 . 4       1 . 0            122          0            0      0 . 0 
TMC_MED
            123         0     15 . 0       1 . 0            122          0            0      0 . 0 
BOOK_MED
            122         0     14 . 9       1 . 0            122          0            0      0 . 0 
I_QUEST
            122         0     16 . 2       1 . 0            122          0            0      0 . 0 
I_TMC_BIG
            122         0     15 . 9       1 . 0            122          0            0      0 . 0 
I_TMC_MED
            122         0     14 . 8       1 . 0            122          0            0      0 . 0 
I_TMC_SM
            122         0     16 . 1       1 . 0            122          0            0      0 . 0 
KADRS_TMP
            122         0     16 . 5       1 . 0            122          0            0      0 . 0 
Tablespace IO Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->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)
 -------------- ------- ------ ------- ------------ -------- ---------- ------
 
TMC_BIG
            122         0     16 . 0       1 . 0            122          0            0      0 . 0 
TEMP
            102         0      4 . 9       8 . 0             68          0            0      0 . 0 
           -------------------------------------------------------------
 
File IO Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->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)
 -------------- ------- ------ ------- ------------ -------- ---------- ------
 
BOOK_BIG                 /ora/oradata/ngk/BOOK_BIG1.dbf
            122         0     15 . 5       1 . 0            122          0            0 
                         /ora/oradata/ngk/BOOK_BIG2.dbf
            149         0     15 . 9       1 . 0            122          0            0 
                         /ora/oradata/ngk/BOOK_BIG3.dbf
            122         0     15 . 4       1 . 0            122          0            0 

BOOK_MED                 /ora/oradata/ngk/BOOK_MED1.dbf
            122         0     14 . 9       1 . 0            122          0            0 

I_BOOK_BIG               /ora/oradata/ngk/I_BOOK_BIG1.dbf
            273         0      9 . 3       1 . 0            122          0            0 

I_BOOK_MED               /ora/oradata/ngk/I_BOOK_SM.dbf
            122         0     15 . 2       1 . 0            122          0            0 
                         /ora/oradata/ngk/I_BOOK_SM2.dbf
            122         0     15 . 2       1 . 0            122          0            0 

I_BOOK_SM                /ora/oradata/ngk/I_BOOK_SM1.dbf
            128         0     14 . 5       1 . 0            122          0            0 

I_KADRS                  /ora/oradata/ngk/i_kadrs01.dbf
            208         0     16 . 8       1 . 2            166          0            0 
                         /ora/oradata/ngk/i_kadrs02.dbf
            344         0     17 . 0       1 . 2            261          0            0 
                         /ora/oradata/ngk/i_kadrs03.dbf
            196         0     16 . 9       1 . 3            177          0            0 
                         /ora/oradata/ngk/i_kadrs04.dbf
            235         0     14 . 9       1 . 3            169          0            0 

I_KADRS_BIG              /ora/oradata/ngk/I_KADRS_BIG1.dbf
            124         0     15 . 6       1 . 0            124          0            0 
                         /ora/oradata/ngk/I_KADRS_BIG2.dbf
            122         0     15 . 6       1 . 0            122          0            0 
                         /ora/oradata/ngk/I_KADRS_BIG3.dbf
            594         0     10 . 5       1 . 0            730          0            0 

I_KADRS_MED              /ora/oradata/ngk/I_KADRS_MED1.dbf
          3 , 018         1      9 . 4       1 . 0          1 , 848          1            0 
                         /ora/oradata/ngk/I_KADRS_MED2.dbf
          1 , 683         1     10 . 0       1 . 0            303          0            0 

I_QUEST                  /ora/oradata/ngk/I_QUEST.dbf
            122         0     16 . 2       1 . 0            122          0            0 

I_TMC                    /ora/oradata/ngk/i_tmc01.dbf
            122         0     18 . 4       1 . 0            122          0            0 
                         /ora/oradata/ngk/i_tmc02.dbf
            122         0     18 . 4       1 . 0            122          0            0 
                         /ora/oradata/ngk/i_tmc03.dbf
            122         0     18 . 3       1 . 0            122          0            0 

File IO Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->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)
 -------------- ------- ------ ------- ------------ -------- ---------- ------
 
I_TMC_BIG                /ora/oradata/ngk/I_TMC_BIG.dbf
            122         0     15 . 9       1 . 0            122          0            0 

I_TMC_MED                /ora/oradata/ngk/I_TMC_MED1.dbf
            122         0     14 . 8       1 . 0            122          0            0 

I_TMC_SM                 /ora/oradata/ngk/I_TMC_SM.dbf
            122         0     16 . 1       1 . 0            122          0            0 

I_WWW_MED                /ora/oradata/ngk/I_WWW_MED1.dbf
            128         0     14 . 8       1 . 0            125          0            0 

KADRS                    /ora/oradata/ngk/kadrs01.dbf
          1 , 119         0     12 . 0       6 . 2            173          0            0 
                         /ora/oradata/ngk/kadrs02.dbf
          1 , 203         0     12 . 0       6 . 4            382          0            0 
                         /ora/oradata/ngk/kadrs03.dbf
          1 , 690         1     23 . 9       5 . 9            215          0            0 
                         /ora/oradata/ngk/kadrs04.dbf
          1 , 360         0     11 . 0       5 . 8            170          0            0 

KADRS_BIG                /ora/oradata/ngk/KADRS_BIG1.dbf
          3 , 044         1      9 . 0       5 . 9            282          0            0 
                         /ora/oradata/ngk/KADRS_BIG2.dbf
          2 , 022         1     11 . 3       1 . 0            166          0            0 
                         /ora/oradata/ngk/KADRS_BIG3.dbf
          4 , 395         1     12 . 1       8 . 5            422          0            0 
                         /ora/oradata/ngk/KADRS_BIG4.dbf
          1 , 660         1      9 . 7       1 . 0            373          0            0 

KADRS_TMP                /ora/oradata/ngk/kadrst1.dbf
            122         0     16 . 5       1 . 0            122          0            0 

KADRS_WORK               /ora/oradata/ngk/kadrsw1.dbf
            124         0     16 . 4       1 . 0            122          0            0 

QUEST                    /ora/oradata/ngk/QUEST.dbf
            123         0     16 . 6       1 . 0            128          0            0 

SYSTEM                   /ora/oradata/ngk/system01.dbf
          2 , 470         1     11 . 2       1 . 1          2 , 989          1            0 

TEMP                     /ora/oradata/ngk/temp01.dbf
            102         0      4 . 9       8 . 0             68          0            0 

TMC_BIG                  /ora/oradata/ngk/TMC_BIG.dbf
            122         0     16 . 0       1 . 0            122          0            0 

TMC_MED                  /ora/oradata/ngk/TMC_MED1.dbf
            123         0     15 . 0       1 . 0            122          0            0 

TMC_SM                   /ora/oradata/ngk/TMC_SM1.dbf
File IO Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->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)
 -------------- ------- ------ ------- ------------ -------- ---------- ------
 
            127         0     18 . 7       1 . 0            122          0            0 

UNDOTBS1                 /ora/oradata/ngk/undotbs01.dbf
            126         0     18 . 4       1 . 0          2 , 536          1            1      0 . 0 

USERS                    /ora/oradata/ngk/users01.dbf
            591         0     11 . 0       1 . 8            473          0            0 
                         /ora/oradata/ngk/users02.dbf
            444         0      9 . 2       2 . 1            266          0            0 
                         /ora/oradata/ngk/users03.dbf
            372         0      8 . 3       2 . 2            169          0            0 

WWW                      /ora/oradata/ngk/www01.dbf
            130         0     17 . 7       1 . 3            122          0            0 

WWW_MED                  /ora/oradata/ngk/WWW_MED1.dbf
            124         0     14 . 9       1 . 0            123          0            0 

           -------------------------------------------------------------
 
Buffer Pool Statistics for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                           Free    Write  Buffer
     Number of Cache      Buffer    Physical   Physical  Buffer Complete    Busy
P      Buffers Hit %        Gets       Reads     Writes   Waits    Waits   Waits
 --- ---------- ----- ----------- ----------- ---------- ------- --------  ------
 
D        29 , 232    99 . 6    28 , 381 , 887       101 , 403        9 , 628         0          0         1 
           -------------------------------------------------------------
 

Instance Recovery Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> 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    300      12          204          950          900          900                   10000 
E    300      11          144         1377          900          900                   10000 
           -------------------------------------------------------------
 

Buffer Pool Advisory for DB: NGK  Instance: ngk  End Snap:  10 
-> Only rows with estimated physical reads > 0  are displayed
-> ordered by Block Size, Buffers For Estimate

        Size for  Size      Buffers for  Est Physical          Estimated
P   Estimate (M) Factr         Estimate   Read Factor     Physical Reads
 --- ------------ ----- ---------------- ------------- ------------------
 
D              48     . 1              3 , 024            3 . 95            7 , 118 , 326 
D              96     . 2              6 , 048            3 . 33            6 , 000 , 778 
D             144     . 3              9 , 072            2 . 87            5 , 163 , 190 
D             192     . 4             12 , 096            2 . 44            4 , 399 , 207 
D             240     . 5             15 , 120            2 . 02            3 , 630 , 364 
D             288     . 6             18 , 144            1 . 57            2 , 834 , 103 
D             336     . 7             21 , 168            1 . 27            2 , 285 , 085 
D             384     . 8             24 , 192            1 . 10            1 , 987 , 111 
D             432     . 9             27 , 216            1 . 03            1 , 848 , 797 
D             464     1 . 0             29 , 232            1 . 00            1 , 801 , 532 
D             480     1 . 0             30 , 240            0 . 99            1 , 783 , 282 
D             528     1 . 1             33 , 264            0 . 97            1 , 746 , 412 
D             576     1 . 2             36 , 288            0 . 95            1 , 708 , 061 
D             624     1 . 3             39 , 312            0 . 93            1 , 672 , 015 
D             672     1 . 4             42 , 336            0 . 91            1 , 646 , 734 
D             720     1 . 6             45 , 360            0 . 90            1 , 624 , 396 
D             768     1 . 7             48 , 384            0 . 89            1 , 599 , 637 
D             816     1 . 8             51 , 408            0 . 88            1 , 577 , 013 
D             864     1 . 9             54 , 432            0 . 86            1 , 552 , 506 
D             912     2 . 0             57 , 456            0 . 75            1 , 357 , 053 
D             960     2 . 1             60 , 480            0 . 24              429 , 711 
           -------------------------------------------------------------
 


Buffer wait Statistics for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> ordered by wait time desc, waits desc

                                 Tot Wait    Avg
Class                    Waits   Time (s) Time (ms)
 ------------------ ----------- ---------- ---------
 
undo header                   1            0           0 
           -------------------------------------------------------------
 
PGA Aggr Target Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> B: Begin snap   E: End snap (rows dentified with B or E contain data
   which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> 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 Cache Hit % W/A MB Processed Extra W/A MB Read/Written
 --------------- ---------------- -------------------------
 
           100 . 0            254 , 285                           7 

                                             %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         50          26         68 . 4          6 . 0      8 . 8     83 . 0     17 . 0        2 , 560 
E         50          18         96 . 5          5 . 2      5 . 4     90 . 2      9 . 8        2 , 560 
           -------------------------------------------------------------
 

PGA Aggr Target Histogram for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> Optimal Executions are purely in-memory operations

    Low    High
Optimal Optimal    Total Execs Optimal Execs  1 -Pass Execs M-Pass Execs
 ------- ------- -------------- ------------- ------------ ------------
 
    16K     32K      13 , 698 , 556      13 , 698 , 556              0              0 
    32K     64K             176             176              0              0 
    64K    128K              64              64              0              0 
   128K    256K              66              66              0              0 
   256K    512K              40              40              0              0 
   512K   1024K              66              66              0              0 
     1M      2M              10              10              0              0 
     2M      4M               4               2              2              0 
           -------------------------------------------------------------
 

PGA Memory Advisory for DB: NGK  Instance: ngk  End Snap:  10 
-> 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
 ---------- ------- ---------------- ---------------- -------- ----------
 
         13       0 . 3        2 , 725 , 772 . 4              227 . 2      100 . 0          310 
         25       0 . 5        2 , 725 , 772 . 4              196 . 5      100 . 0            1 
         38       0 . 8        2 , 725 , 772 . 4              189 . 8      100 . 0            0 
         50       1 . 0        2 , 725 , 772 . 4              185 . 4      100 . 0            0 
         60       1 . 2        2 , 725 , 772 . 4              185 . 4      100 . 0            0 
         70       1 . 4        2 , 725 , 772 . 4              185 . 4      100 . 0            0 
         80       1 . 6        2 , 725 , 772 . 4              137 . 4      100 . 0            0 
         90       1 . 8        2 , 725 , 772 . 4              137 . 4      100 . 0            0 
        100       2 . 0        2 , 725 , 772 . 4               46 . 3      100 . 0            0 
        150       3 . 0        2 , 725 , 772 . 4               46 . 3      100 . 0            0 
        200       4 . 0        2 , 725 , 772 . 4               46 . 3      100 . 0            0 
        300       6 . 0        2 , 725 , 772 . 4               46 . 3      100 . 0            0 
        400       8 . 0        2 , 725 , 772 . 4               30 . 3      100 . 0            0 
           -------------------------------------------------------------
 
Rollback Segment Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->A high value for  "Pct Waits"  suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
  managment, as RBS may be dynamically created and dropped as needed

        Trans Table       Pct   Undo Bytes
RBS No      Gets        Waits     Written        Wraps  Shrinks  Extends
 ------ -------------- ------- --------------- -------- -------- --------
 
      0             69 . 0      0 . 00                 0          0          0          0 
      1             74 . 0      0 . 00                 0          0          0          0 
      2          2 , 691 . 0      0 . 00         1 , 173 , 934          1          0          1 
      3             81 . 0      0 . 00               356          0          0          0 
      4          2 , 899 . 0      0 . 00         2 , 210 , 808          4          0          2 
      5          2 , 623 . 0      0 . 00         3 , 498 , 868          3          0          3 
      6          4 , 785 . 0      0 . 00         4 , 012 , 464          4          0          4 
      7          2 , 814 . 0      0 . 00         1 , 525 , 994          1          0          1 
      8          5 , 197 . 0      0 . 00         4 , 068 , 226          4          0          3 
      9          3 , 897 . 0      0 . 00         4 , 212 , 898          4          0          3 
     10          3 , 231 . 0      0 . 00           901 , 272          0          0          0 
           -------------------------------------------------------------
 
Rollback Segment Storage for DB: NGK  Instance: ngk  Snaps:  6  - 10 
->Optimal Size should be larger than Avg Active

RBS No    Segment Size      Avg Active    Optimal Size    Maximum Size
 ------ --------------- --------------- --------------- ---------------
 
      0           442 , 368                 0                           442 , 368 
      1         2 , 211 , 840           759 , 889                       176 , 275 , 456 
      2        11 , 649 , 024           208 , 120                        20 , 037 , 632 
      3         1 , 163 , 264            95 , 911                         9 , 551 , 872 
      4         3 , 260 , 416           320 , 035                        13 , 746 , 176 
      5        14 , 794 , 752           739 , 969                        20 , 037 , 632 
      6         8 , 503 , 296           901 , 511                        11 , 649 , 024 
      7         4 , 308 , 992           276 , 916                         4 , 308 , 992 
      8         8 , 503 , 296           592 , 917                         8 , 503 , 296 
      9         7 , 454 , 720           542 , 289                        23 , 183 , 360 
     10       226 , 607 , 104       496 , 724 , 566                       226 , 607 , 104 
           -------------------------------------------------------------
 
Undo Segment Summary for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> Undo segment block stats:
-> uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
-> eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo           Undo        Num  Max Qry     Max Tx Snapshot Out of uS/uR/uU/
 TS#         Blocks      Trans  Len (s)   Concurcy  Too Old  Space eS/eR/eU
 ---- -------------- ---------- -------- ---------- -------- ------ -------------
 
    1            1 , 430      241 , 321      5 , 942            5          0        0   0 / 0 / 0 / 0 / 0 / 0 
           -------------------------------------------------------------
 


Undo Segment Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> ordered by Time desc

                     Undo      Num Max Qry   Max Tx  Snap   Out of uS/uR/uU/
End Time           Blocks    Trans Len (s)    Concy Too Old  Space eS/eR/eU
 ------------ ------------ -------- ------- -------- ------- ------ -------------
 
 07 -Mar  10 : 13            309     52 , 908       542          5         0        0   0 / 0 / 0 / 0 / 0 / 0 
 07 -Mar  10 : 03            110     50 , 453       352          3         0        0   0 / 0 / 0 / 0 / 0 / 0 
 07 -Mar  09 : 53             19     48 , 293       275          4         0        0   0 / 0 / 0 / 0 / 0 / 0 
 07 -Mar  09 : 43            516     47 , 072     5 , 942          3         0        0   0 / 0 / 0 / 0 / 0 / 0 
 07 -Mar  09 : 33            476     42 , 595        15          5         0        0   0 / 0 / 0 / 0 / 0 / 0 
           -------------------------------------------------------------
 
Latch Activity for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> "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                       Requests      Miss  /Miss    (s)     Requests   Miss
 ------------------------ -------------- ------ ------ ------ ------------ ------
 
Consistent RBA                    12 , 319      0 . 0               0              0 
FIB s.o chain latch                  502      0 . 0               0              0 
FOB s.o list latch                   960      0 . 0               0              0 
SQL memory manager latch               7      0 . 0               0          1 , 057      0 . 0 
SQL memory manager worka      10 , 979 , 576      0 . 0      0 . 0        0              0 
active checkpoint queue            3 , 652      0 . 1      0 . 0        0              0 
archive control                      221      0 . 0               0              0 
begin backup scn array               217      0 . 0               0              0 
cache buffer handles               8 , 141      0 . 0               0              0 
cache buffers chains          43 , 924 , 607      0 . 0      0 . 0        0        184 , 903      0 . 0 
cache buffers lru chain           93 , 689      0 . 0      0 . 0        0        106 , 775      0 . 0 
channel handle pool latc             119      0 . 0               0              0 
channel operations paren           2 , 441      0 . 0               0              0 
checkpoint queue latch           178 , 362      0 . 0      0 . 0        0          9 , 367      0 . 0 
child cursor hash table           75 , 188      0 . 0      0 . 0        0              0 
commit callback allocati               4      0 . 0               0              0 
dictionary lookup                     25      0 . 0               0              0 
dml lock allocation               28 , 188      0 . 0      0 . 0        0              0 
dummy allocation                     123      0 . 0               0              0 
enqueue hash chains               60 , 580      0 . 0      0 . 0        0              0 
enqueues                          16 , 881      0 . 0      0 . 0        0              0 
event group latch                     69      0 . 0               0              0 
event range base latch                 1      0 . 0               0              0 
file number translation           26 , 770      0 . 0      0 . 0        0              0 
global tx hash mapping               247      0 . 0               0              0 
hash table column usage              522      0 . 0               0         30 , 178      0 . 0 
job_queue_processes para              53      0 . 0               0              0 
ktm global data                       11      0 . 0               0              0 
kwqit: protect wakeup ti             103      0 . 0               0              0 
lgwr LWN SCN                      12 , 427      0 . 0               0              0 
library cache                  7 , 824 , 007      0 . 2      0 . 1       11         23 , 990      6 . 8 
library cache load lock            4 , 654      0 . 0               0              0 
library cache pin              7 , 115 , 170      0 . 0      0 . 0        0              0 
library cache pin alloca         197 , 362      0 . 0      0 . 0        0              0 
list of block allocation             244      0 . 0               0              0 
loader state object free           1 , 479      0 . 0               0              0 
message pool operations                4      0 . 0               0              0 
messages                          73 , 125      0 . 0      0 . 1        0              0 
mostly latch-free SCN             12 , 473      0 . 3      0 . 0        0              0 
multiblock read objects           11 , 646      0 . 0               0              0 
ncodef allocation latch               53      0 . 0               0              0 
object stats modificatio             203      0 . 0               0              0 
post/wait queue                   24 , 644      0 . 0      0 . 5        0          6 , 949      0 . 0 
process allocation                    69      0 . 0               0             69      0 . 0 
process group creation               115      0 . 0               0              0 
redo allocation                  183 , 121      0 . 0      0 . 0        0              0 
redo copy                              0                      0        157 , 844      0 . 3 
redo writing                      42 , 730      0 . 0               0              0 
row cache enqueue latch          567 , 488      0 . 0      0 . 0        0              0 
row cache objects                610 , 651      0 . 0      0 . 1        0          2 , 937      0 . 0 
Latch Activity for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> "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                       Requests      Miss  /Miss    (s)     Requests   Miss
 ------------------------ -------------- ------ ------ ------ ------------ ------
 
sequence cache                     3 , 369      0 . 0               0              0 
session allocation            15 , 180 , 843      0 . 0      0 . 0        0              0 
session idle bit                  84 , 658      0 . 0               0              0 
session switching                     53      0 . 0               0              0 
session timer                      1 , 092      0 . 0               0              0 
shared pool                    3 , 898 , 955      0 . 3      0 . 3       28              0 
sim partition latch                    0                      0             66      0 . 0 
simulator hash latch           2 , 056 , 710      0 . 0               0              0 
simulator lru latch                8 , 135      0 . 0               0         15 , 412      0 . 1 
sort extent pool                     118      0 . 0               0              0 
temporary table state ob               2      0 . 0               0              0 
trace latch                           20      0 . 0               0              0 
transaction allocation           130 , 913      0 . 0               0              0 
transaction branch alloc             210      0 . 0               0              0 
undo global data                  44 , 062      0 . 0               0              0 
user lock                            279      0 . 0               0              0 
           -------------------------------------------------------------
 
Latch Sleep breakdown for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> ordered by misses desc

                                      Get                            Spin &
Latch Name                       Requests      Misses      Sleeps Sleeps  1 -> 4 
 -------------------------- -------------- ----------- ----------- ------------
 
shared pool                      3 , 898 , 955        12 , 744         3 , 714   9112 / 3559 / 65 
                                                                  / 8 / 0 
library cache                    7 , 824 , 007        12 , 375         1 , 584   10841 / 1487 / 4 
                                                                   4 / 3 / 0 
session allocation              15 , 180 , 843         6 , 136            81   6055 / 81 / 0 / 0 /
                                                                   0 
cache buffers chains            43 , 924 , 607         3 , 352            71   0 / 0 / 0 / 0 / 0 
library cache pin                7 , 115 , 170           647             2   645 / 2 / 0 / 0 / 0 
redo allocation                    183 , 121            59             1   58 / 1 / 0 / 0 / 0 
messages                            73 , 125            27             4   23 / 4 / 0 / 0 / 0 
row cache objects                  610 , 651            15             2   14 / 0 / 1 / 0 / 0 
post/wait queue                     24 , 644             2             1   1 / 1 / 0 / 0 / 0 
           -------------------------------------------------------------
 
Latch Miss Sources for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
 ------------------------ -------------------------- ------- ---------- --------
 
cache buffers chains     kcbgcur: kslbegin                 0           24          6 
cache buffers chains     kcbget: pin buffer                0           21          0 
cache buffers chains     kcbgtcr: fast path                0           20          5 
cache buffers chains     kcbzwb                            0            6          0 
library cache            kglic                             0          141         78 
library cache            kglobpn: child:                   0          113          3 
library cache            kglupc: child                     0           86        574 
library cache            kglpnc: child                     0           43        776 
library cache            kgllkdl: child: cleanup           0           39         10 
library cache            kglpndl: child: before pro        0           28         10 
library cache            kgldti: 2child                    0           19          8 
library cache            kglhdgn: child:                   0           18         56 
library cache            kglpin: child: heap proces        0           14          3 
library cache            kglpndl: child: after proc        0           13          1 
library cache            kglhdgc: child:                   0            9          1 
library cache            kglpndl: parent: purge            0            4          0 
library cache            kglpin                            0            3          6 
library cache            kglrtl                            0            3          0 
library cache            kglalt: parent                    0            2          1 
library cache            kglget: child: KGLDSBRD           0            2          0 
library cache            kglpnp: child                     0            2          2 
library cache            kgldrx: parent                    0            1          0 
library cache            kglobld                           0            1          6 
library cache            kglini: child                     0            1          0 
library cache            kglget: child: KGLDSBYD           0            1          2 
library cache            kgldte: child  0                    0            1          4 
library cache pin        kglpnal: child: alloc spac        0            1          1 
library cache pin        kglupc                            0            1          1 
messages                 ksarcv                            0            3          0 
messages                 ksaamb: after wakeup              0            1          3 
post/wait queue          ksliwat:add:nowait                0            1          0 
redo allocation          kcrfwr                            0            1          0 
row cache objects        kqrpre: find obj                  0            2          2 
session allocation       ksufap: active sessions           0           81          0 
shared pool              kghalo                            0        2 , 315         80 
shared pool              kghfrunp: alloc: wait             0          966         22 
shared pool              kghfrunp: clatch: nowait          0          600          0 
shared pool              kghfrunp: clatch: wait            0          438         41 
shared pool              kghdmp                            0          201          0 
shared pool              kghupr1                           0          183      3 , 606 
shared pool              kghfen: not perm alloc cla        0           24          2 
shared pool              kghalp                            0           16          4 
shared pool              kghfre                            0            9          0 
shared pool              kghfru                            0            1          1 
           -------------------------------------------------------------
 
Dictionary Cache Stats for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> "Pct Misses"   should be very low (<  2 % in most cases)
-> "Cache Usage"  is the number of cache entries being used
-> "Pct SGA"      is the ratio of usage to allocated size for that cache

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
 ------------------------- ------------ ------ ------- ----- -------- ----------
 
dc_constraints                        4     50 . 0         0                3            2 
dc_database_links                   139      0 . 0         0                0            1 
dc_files                             92      0 . 0         0                0           46 
dc_global_oids                       86      1 . 2         0                0           12 
dc_histogram_defs                93 , 328      1 . 5         0                0        2 , 555 
dc_object_ids                    72 , 232      0 . 4         0               21        1 , 430 
dc_objects                       22 , 081      1 . 8         0              351        2 , 365 
dc_profiles                          64      0 . 0         0                0            1 
dc_rollback_segments                506      0 . 0         0                0           24 
dc_segments                      24 , 126      1 . 2         0               26        1 , 111 
dc_sequences                         63     17 . 5         0               63            7 
dc_table_scns                         5     20 . 0         0                1            3 
dc_tablespace_quotas                 14      7 . 1         0               14            9 
dc_tablespaces                   18 , 007      0 . 0         0                0           29 
dc_user_grants                   34 , 196      0 . 0         0                0           38 
dc_usernames                      9 , 395      0 . 1         0                0           34 
dc_users                         44 , 019      0 . 0         0                0           59 
           -------------------------------------------------------------
 


Library Cache Activity for DB: NGK  Instance: ngk  Snaps:  6  - 10 
-> "Pct Misses"   should be very low

                         Get  Pct        Pin        Pct               Invali-
Namespace           Requests  Miss     Requests     Miss     Reloads  dations
 --------------- ------------ ------ -------------- ------ ---------- --------
 
BODY                    1 , 421      5 . 9            1 , 504     11 . 9           13          0 
CLUSTER                   431      0 . 5              490      0 . 8            0          0 
INDEX                     414      0 . 5              414      0 . 7            0          0 
SQL AREA               22 , 723     44 . 9        3 , 499 , 502      0 . 6          277         80 
TABLE/PROCEDURE       186 , 609      0 . 3           93 , 097      2 . 5          762          0 
TRIGGER                   327      3 . 7              327      5 . 8            7          0 
           -------------------------------------------------------------
 
Shared Pool Advisory for DB: NGK  Instance: ngk  End Snap:  10 
-> 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

                                                          Estd
Shared Pool    SP       Estd         Estd     Estd Lib LC Time
   Size for  Size  Lib Cache    Lib Cache   Cache Time   Saved  Estd Lib Cache
  Estim (M) Factr   Size (M)      Mem Obj    Saved (s)   Factr    Mem Obj Hits
 ----------- ----- ---------- ------------ ------------ ------- ---------------
 
         176     . 6          162         23 , 933         12 , 694       1 . 0           383 , 201 
         208     . 7          193         26 , 893         12 , 744       1 . 0           383 , 851 
         240     . 8          224         30 , 111         12 , 749       1 . 0           384 , 255 
         272     . 9          255         31 , 707         12 , 757       1 . 0           384 , 876 
         304     1 . 0          286         34 , 766         12 , 765       1 . 0           385 , 167 
         336     1 . 1          317         38 , 585         12 , 782       1 . 0           385 , 356 
         368     1 . 2          348         39 , 471         12 , 792       1 . 0           385 , 494 
         400     1 . 3          379         44 , 696         12 , 843       1 . 0           386 , 310 
         432     1 . 4          410         47 , 078         12 , 893       1 . 0           386 , 985 
         464     1 . 5          441         49 , 707         12 , 942       1 . 0           387 , 292 
         496     1 . 6          472         51 , 434         12 , 942       1 . 0           387 , 310 
         528     1 . 7          503         54 , 000         12 , 942       1 . 0           387 , 332 
         560     1 . 8          534         56 , 509         12 , 942       1 . 0           387 , 368 
         592     1 . 9          565         59 , 234         12 , 942       1 . 0           387 , 410 
         624     2 . 1          611         62 , 288         12 , 942       1 . 0           387 , 425 
           -------------------------------------------------------------
 
SGA Memory Summary for DB: NGK  Instance: ngk  Snaps:  6  - 10 

SGA regions                       Size in Bytes
 ------------------------------ ----------------
 
Database Buffers                     486 , 539 , 264 
Fixed Size                               740 , 808 
Redo Buffers                           2 , 371 , 584 
Variable Size                        503 , 316 , 480 
                                ----------------
 
sum                                  992 , 968 , 136 
           -------------------------------------------------------------
 


SGA breakdown difference for DB: NGK  Instance: ngk  Snaps:  6  - 10 

Pool   Name                                Begin value        End value  % Diff
 ------ ------------------------------ ---------------- ---------------- -------
 
java   free memory                           33 , 554 , 432         33 , 554 , 432      0 . 00 
large  free memory                           67 , 108 , 864         67 , 108 , 864      0 . 00 
shared DML lock                               1 , 695 , 656          1 , 695 , 656      0 . 00 
shared FileOpenBlock                         10 , 901 , 792         10 , 901 , 792      0 . 00 
shared KGK heap                                   7 , 000              7 , 000      0 . 00 
shared KGLS heap                              5 , 305 , 848          3 , 801 , 656   - 28 . 35 
shared KQR L PO                               4 , 819 , 800          5 , 064 , 704      5 . 08 
shared KQR M PO                               1 , 522 , 344          2 , 017 , 240     32 . 51 
shared KQR M SO                                   8 , 704              8 , 704      0 . 00 
shared KQR S SO                                  14 , 216             14 , 472      1 . 80 
shared KQR X PO                                   2 , 576              2 , 576      0 . 00 
shared MTTR advisory                             89 , 528             89 , 528      0 . 00 
shared PL/SQL DIANA                          11 , 667 , 352          4 , 631 , 200   - 60 . 31 
shared PL/SQL MPCODE                          3 , 780 , 888          2 , 607 , 144   - 31 . 04 
shared PLS non-lib hp                             2 , 088              2 , 088      0 . 00 
shared VIRTUAL CIRCUITS                       4 , 037 , 200          4 , 037 , 200      0 . 00 
shared db_handles                             2 , 088 , 000          2 , 088 , 000      0 . 00 
shared dictionary cache                       3 , 221 , 760          3 , 221 , 760      0 . 00 
shared enqueue                                3 , 269 , 776          3 , 269 , 776      0 . 00 
shared errors                                   154 , 576            165 , 936      7 . 35 
shared event statistics per sess             20 , 183 , 480         20 , 183 , 480      0 . 00 
shared fixed allocation callback                    592                592      0 . 00 
shared free memory                          144 , 087 , 552        144 , 315 , 432      0 . 16 
shared joxs heap init                             4 , 240              4 , 240      0 . 00 
shared kgl simulator                          8 , 208 , 368         12 , 824 , 952     56 . 24 
shared library cache                         29 , 620 , 680         46 , 841 , 440     58 . 14 
shared miscellaneous                         20 , 738 , 816         21 , 714 , 952      4 . 71 
shared parameters                                49 , 888             18 , 608   - 62 . 70 
shared processes                              2 , 289 , 600          2 , 289 , 600      0 . 00 
shared sessions                               5 , 367 , 440          5 , 367 , 440      0 . 00 
shared sim memory hea                           251 , 552            251 , 552      0 . 00 
shared sql area                             115 , 673 , 792        101 , 620 , 528   - 12 . 15 
shared table definiti                             6 , 744              5 , 456   - 19 . 10 
shared transaction                            3 , 575 , 792          3 , 575 , 792      0 . 00 
shared trigger defini                             1 , 336              7 , 752    480 . 24 
shared trigger inform                             3 , 352              1 , 128   - 66 . 35 
shared trigger source                               856                856      0 . 00 
       buffer_cache                         486 , 539 , 264        486 , 539 , 264      0 . 00 
       fixed_sga                                740 , 808            740 , 808      0 . 00 
       log_buffer                             2 , 360 , 320          2 , 360 , 320      0 . 00 
           -------------------------------------------------------------
 
init.ora Parameters for DB: NGK  Instance: ngk  Snaps:  6  - 10 

                                                                  End value
Parameter Name                Begin value                       (if different)
 ----------------------------- --------------------------------- --------------
 
O7_DICTIONARY_ACCESSIBILITY   TRUE
aq_tm_processes                1 
audit_trail                   DB
background_dump_dest          /ora/admin/ngk/bdump
compatible                     9 . 2 . 0 . 0 . 0 
control_files                 /ora/oradata/ngk/control01.ctl, /
core_dump_dest                /ora/admin/ngk/cdump
cpu_count                      4 
db_block_size                  16384 
db_cache_size                  486539264 
db_domain
db_file_multiblock_read_count  64 
db_name                       ngk
db_writer_processes            2 
disk_asynch_io                TRUE
dispatchers                   (PROTOCOL=TCP) (SERVICE=ngkXDB)
fast_start_mttr_target         300 
hash_join_enabled             TRUE
instance_name                 ngk
java_pool_size                 33554432 
job_queue_processes            4 
large_pool_size                67108864 
log_buffer                     2097152 
log_checkpoint_interval        10000 
log_checkpoint_timeout         0 
max_enabled_roles              40 
open_cursors                   1900 
optimizer_index_caching        35 
optimizer_index_cost_adj       15 
os_authent_prefix
pga_aggregate_target           52428800 
processes                      1800 
query_rewrite_enabled         FALSE
remote_login_passwordfile     EXCLUSIVE
service_names                 ngk
session_cached_cursors         50 
shared_pool_reserved_size      141557760 
shared_pool_size               318767104 
sort_area_retained_size        716800 
sort_area_size                 716800 
star_transformation_enabled   FALSE
timed_statistics              TRUE
undo_management               AUTO
undo_retention                 10800 
undo_tablespace               UNDOTBS1
user_dump_dest                /ora/admin/ngk/udump
           -------------------------------------------------------------
 

End of Report