:bncore  :=           ;
                         *
ошибка в строке 76:
ORA-06550: Строка 76, столбец 26:
PLS-00103: Встретился символ ";" в то время как ожидалось одно из следующих:
( - + case mod new not null <идентификатор>
<идентификатор с двойными кавычками-разделителями>
<переменная привязки> continue avg count current exists max
min prior sql stddev sum variance execute forall merge time
timestamp interval date
<строковый литерал со спецификацией кодовой таблицы> <число>
<строка SQL в одинарных кавычках> pipe
<строковый литерал, заключенный в другие кавычки, со спецификацией код


STATSPACK report for

Database    DB Id    Instance     Inst Num  Startup Time   Release     RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
          3762199905 testb                1 01-Май-12 11:47 11.1.0.6.0  NO

Host Name             Platform                CPUs Cores Sockets   Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ------- ------------
     PK               Microsoft Windows IA (

Snapshot       Snap Id     Snap Time      Sessions Curs/Sess Comment
~~~~~~~~    ---------- ------------------ -------- --------- -------------------
Begin Snap:          1 01-Май-12 15:02:15
  End Snap:          2 01-Май-12 15:12:05
   Elapsed:           9.83 (mins)
   DB time:                (mins)     DB CPU:             (mins)

Cache Sizes            Begin        End
~~~~~~~~~~~       ---------- ----------
    Buffer Cache:          M              Std Block Size:          K
     Shared Pool:          M                  Log Buffer:          K

Load Profile              Per Second    Per Transaction    Per Exec    Per Call
~~~~~~~~~~~~      ------------------  ----------------- ----------- -----------
      DB time(s):
       DB CPU(s):
       Redo size:
   Logical reads:
   Block changes:
  Physical reads:
 Physical writes:
      User calls:
          Parses:
     Hard parses:
W/A MB processed:
          Logons:
        Executes:
       Rollbacks:
    Transactions:

Instance Efficiency Indicators
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:               Redo NoWait %:
            Buffer  Hit   %:          Optimal W/A Exec %:
            Library Hit   %:                Soft Parse %:
         Execute to Parse %:                 Latch Hit %:
Parse CPU to Parse Elapsd %:             % Non-Parse CPU:

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:
    % SQL with executions>1:   68.28   73.35
  % Memory for SQL w/exec>1:   75.68   82.64

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
db file sequential read                         61,383       1,211     20
wait for stopper event to be increased           5,522         583    106
db file parallel write                           8,023          57      7
log file parallel write                            609          42     69
control file sequential read                       947          26     28
          -------------------------------------------------------------

Time Model System Stats  DB/Inst: testb/testb  Snaps: 1-2
-> Ordered by % of DB time desc, Statistic name

Statistic                                       Time (s) % DB time
----------------------------------- -------------------- ---------
sql execute elapsed time                           605.4      50.5
DB CPU                                             560.6      46.7
PL/SQL execution elapsed time                        9.6        .8
repeated bind elapsed time                           1.8        .1
parse time elapsed                                   0.7        .1
hard parse elapsed time                              0.4        .0
connection management call elapsed                   0.2        .0
DB time                                          1,199.6
background elapsed time                            728.9
background cpu time                                  0.9
          -------------------------------------------------------------
Wait Event Histogram  DB/Inst: testb/testb  Snaps: 1-2
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

                           Total ----------------- % of Waits ------------------
Event                      Waits  <1ms  <2ms  <4ms  <8ms <16ms <32ms  <=1s   >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
buffer busy waits             3   66.7                    33.3
control file parallel writ  359   10.9   3.9   4.2  12.5  14.8  32.9  20.9
control file sequential re  947    9.4    .5   1.3   7.3  11.0  42.0  28.5
db file parallel write     8023   62.2   3.7   3.4   8.6   9.5   7.3   5.3
db file scattered read        6                           50.0  50.0
db file sequential read      61K  18.4    .1   1.0  14.7  16.7  37.4  11.8
direct path read             35   80.0               8.6   2.9   5.7   2.9
direct path write            35   77.1                     5.7  11.4   5.7
enq: CF - contention          1                                100.0
enq: PS - contention          6   33.3                    33.3        33.3
latch: cache buffers chain    6  100.0
latch: cache buffers lru c    1  100.0
latch free                    6  100.0
latch: messages               1  100.0
latch: session allocation     1  100.0
latch: shared pool            5  100.0
LGWR wait for redo copy       8  100.0
log file parallel write     609     .7         1.0   6.9  13.8  23.6  54.0
log file sequential read     12   16.7              25.0   8.3  25.0  25.0
log file single write        12   33.3              16.7  41.7   8.3
log file switch completion   29   17.2                                82.8
log file sync               163                2.5   8.0  11.7  24.5  53.4
os thread startup            10              100.0
PX Deq: Join ACK             10  100.0
PX Deq: Txn Recovery Start  297   18.5   1.7   1.7  15.5  16.8  32.3  13.5
SQL*Net break/reset to cli   44  100.0
wait for a undo record       15  100.0
wait for stopper event to  5523     .1    .0    .1    .2    .6    .9  98.1
DIAG idle wait             1164                                      100.0
dispatcher timer              9                                            100.0
fbar timer                    2                                            100.0
jobq slave wait             105                                            100.0
pmon timer                  210    6.7                                      93.3
PX Idle Wait               2071     .5                      .0    .0    .4  99.0
rdbms ipc message          3266    9.6    .6    .3    .3   1.5   1.4  39.1  47.2
Space Manager: slave idle   118                                            100.0
SQL*Net message from clien 1581   87.7    .2    .1                .1    .2  11.7
SQL*Net message to client  1580  100.0
SQL*Net more data from cli   13  100.0
Streams AQ: qmn coordinato   40   47.5                                      52.5
Streams AQ: qmn slave idle   21                                            100.0
Streams AQ: waiting for me  118                             .8              99.2
virtual circuit status       20                                            100.0
wait for unread message on  591                                   .8  99.0    .2
          -------------------------------------------------------------

truncate table STATS$TEMP_SQLSTATS
               *
ошибка в строке 1:
ORA-00942: таблица или представление пользователя не существует


Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
active txn count during cleanout               1,498            2.5
application wait time                              1            0.0
background checkpoints completed                   7            0.0
background checkpoints started                     6            0.0
background timeouts                            2,063            3.5
Batched IO block miss count                        0            0.0
Batched IO (bound) vector count                    0            0.0
Batched IO buffer defrag count                     0            0.0
Batched IO double miss count                       0            0.0
Batched IO (full) vector count                     0            0.0
Batched IO same unit count                         0            0.0
Batched IO single block count                      0            0.0
Batched IO slow jump count                         0            0.0
Batched IO vector block count                      0            0.0
Batched IO vector read count                       0            0.0
buffer is not pinned count                29,550,705       50,085.9
buffer is pinned count                 2,750,598,932    4,662,032.1
bytes received via SQL*Net from c            271,077          459.5
bytes sent via SQL*Net to client             157,649          267.2
calls to get snapshot scn: kcmgss            654,388        1,109.1
calls to kcmgas                               37,525           63.6
calls to kcmgcs                                  589            1.0
calls to kcmgrs                              544,816          923.4
CCursor + sql area evicted                         4            0.0
change write time                                229            0.4
cleanout - number of ktugct calls              1,510            2.6
cleanouts and rollbacks - consist                961            1.6
cleanouts only - consistent read                   0            0.0
cluster key scan block gets                        3            0.0
cluster key scans                                  3            0.0
commit batch performed                             0            0.0
commit batch requested                             0            0.0
commit batch/immediate performed                   2            0.0
commit batch/immediate requested                   2            0.0
commit cleanout failures: block l                  2            0.0
commit cleanout failures: buffer                   0            0.0
commit cleanout failures: callbac                  6            0.0
commit cleanout failures: cannot                   0            0.0
commit cleanouts                               1,305            2.2
commit cleanouts successfully com              1,297            2.2
commit immediate performed                         2            0.0
commit immediate requested                         2            0.0
commit txn count during cleanout                  71            0.1
concurrency wait time                              5            0.0
consistent changes                            45,299           76.8
consistent gets                           62,421,066      105,798.4
consistent gets - examination                878,377        1,488.8
consistent gets from cache                62,421,066      105,798.4
consistent gets from cache (fastp         61,172,711      103,682.6
CPU used by this session                      56,214           95.3
CPU used when call started                       809            1.4
CR blocks created                              1,006            1.7
cursor authentications                            23            0.0
data blocks consistent reads - un             12,097           20.5
db block changes                           2,981,461        5,053.3
db block gets                              3,307,286        5,605.6
Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
db block gets direct                               0            0.0
db block gets from cache                   3,307,286        5,605.6
db block gets from cache (fastpat            207,929          352.4
DB time                                      209,805          355.6
DBWR checkpoint buffers written               58,536           99.2
DBWR checkpoints                                   6            0.0
DBWR object drop buffers written                   0            0.0
DBWR thread checkpoint buffers wr             58,536           99.2
DBWR transaction table writes                     30            0.1
DBWR undo block writes                        30,569           51.8
deferred (CURRENT) block cleanout                600            1.0
dirty buffers inspected                           14            0.0
enqueue conversions                              165            0.3
enqueue releases                               7,831           13.3
enqueue requests                               7,945           13.5
enqueue timeouts                                 115            0.2
enqueue waits                                      7            0.0
execute count                                446,771          757.2
frame signature mismatch                           0            0.0
free buffer inspected                         64,300          109.0
free buffer requested                         65,394          110.8
heap block compress                            1,220            2.1
Heap Segment Array Inserts                        98            0.2
Heap Segment Array Updates                        17            0.0
hot buffers moved to head of LRU               1,460            2.5
HSC Heap Segment Block Changes                45,144           76.5
immediate (CR) block cleanout app                961            1.6
immediate (CURRENT) block cleanou                412            0.7
IMU commits                                      217            0.4
IMU contention                                    13            0.0
IMU CR rollbacks                                  33            0.1
IMU- failed to get a private stra                 30            0.1
IMU Flushes                                      178            0.3
IMU ktichg flush                                   2            0.0
IMU pool not allocated                            30            0.1
IMU Redo allocation size                      92,172          156.2
IMU undo allocation size                     381,248          646.2
index crx upgrade (found)                          0            0.0
index crx upgrade (positioned)                   914            1.6
index crx upgrade (prefetch)                       0            0.0
index fast full scans (full)                      12            0.0
index fetch by key                           384,015          650.9
index scans kdiixs1                          108,378          183.7
leaf node splits                                  56            0.1
leaf node 90-10 splits                            40            0.1
lob reads                                          0            0.0
lob writes                                         0            0.0
lob writes unaligned                               0            0.0
logons cumulative                                 41            0.1
messages received                              9,092           15.4
messages sent                                  9,092           15.4
no work - consistent read gets            61,112,207      103,580.0
opened cursors cumulative                    446,257          756.4
parse count (failures)                             0            0.0
parse count (hard)                                89            0.2
parse count (total)                           17,012           28.8
Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
parse time cpu                                    30            0.1
parse time elapsed                                34            0.1
physical read bytes                      503,570,432      853,509.2
physical read IO requests                     61,456          104.2
physical read total bytes                519,092,224      879,817.3
physical read total IO requests               62,415          105.8
physical read total multi block r                  0            0.0
physical reads                                61,471          104.2
physical reads cache                          61,436          104.1
physical reads cache prefetch                     15            0.0
physical reads direct                             35            0.1
physical reads direct temporary t                  0            0.0
physical reads prefetch warmup                     0            0.0
physical write bytes                     480,337,920      814,132.1
physical write IO requests                    12,832           21.8
physical write total bytes               820,881,920    1,391,325.3
physical write total IO requests              15,989           27.1
physical write total multi block               1,087            1.8
physical writes                               58,635           99.4
physical writes direct                            35            0.1
physical writes direct temporary                   0            0.0
physical writes from cache                    58,600           99.3
physical writes non checkpoint                31,209           52.9
pinned buffers inspected                           2            0.0
prefetch warmup blocks aged out b                  0            0.0
prefetched blocks aged out before                  0            0.0
process last non-idle time                       480            0.8
PX local messages recv'd                         851            1.4
PX local messages sent                           574            1.0
recovery blocks read                               0            0.0
recursive calls                              555,215          941.0
recursive cpu usage                           55,032           93.3
redo blocks checksummed by FG (ex              3,106            5.3
redo blocks read for recovery                      0            0.0
redo blocks read total                             0            0.0
redo blocks written                          596,185        1,010.5
redo blocks written for direct wr                  0            0.0
redo buffer allocation retries                    75            0.1
redo entries                               2,748,076        4,657.8
redo log space requests                           85            0.1
redo log space wait time                         577            1.0
redo ordering marks                            2,692            4.6
redo size                                292,482,708      495,733.4
redo subscn max counts                        31,205           52.9
redo synch time                                1,208            2.1
redo synch writes                                163            0.3
redo wastage                                 199,684          338.5
redo write time                                4,110            7.0
redo writes                                      609            1.0
rollback changes - undo records a                  4            0.0
rollbacks only - consistent read                  45            0.1
RowCR - row contention                           355            0.6
RowCR attempts                               293,556          497.6
RowCR hits                                   293,201          497.0
rows fetched via callback                    368,189          624.1
session connect time                               0            0.0
Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
session cursor cache hits                    430,295          729.3
session logical reads                     65,728,353      111,404.0
session pga memory                        56,305,052       95,432.3
session pga memory max                    67,782,160      114,885.0
session uga memory                    47,284,122,148   80,142,579.9
session uga memory max                    81,786,844      138,621.8
shared hash latch upgrades - no w            402,660          682.5
shared hash latch upgrades - wait                  0            0.0
SMON posted for undo segment reco                  2            0.0
sorts (memory)                                15,268           25.9
sorts (rows)                                   7,521           12.8
sql area evicted                                  46            0.1
sql area purged                                    0            0.0
SQL*Net roundtrips to/from client              1,574            2.7
summed dirty queue length                        157            0.3
switch current to new buffer                      35            0.1
table fetch by rowid                   1,388,551,518    2,353,477.2
table fetch continued row                          0            0.0
table scan blocks gotten                     147,402          249.8
table scan rows gotten                       151,290          256.4
table scans (long tables)                          0            0.0
table scans (short tables)                    29,660           50.3
TBS Extension: files extended                      0            0.0
TBS Extension: tasks created                       0            0.0
TBS Extension: tasks executed                      0            0.0
total number of times SMON posted                  2            0.0
transaction rollbacks                              2            0.0
transaction tables consistent rea             33,194           56.3
undo change vector size                   21,057,520       35,690.7
user calls                                     2,184            3.7
user commits                                     248            0.4
user I/O wait time                           121,144          205.3
user rollbacks                                     2            0.0
workarea executions - optimal                    277            0.5
write clones created in backgroun                  0            0.0
write clones created in foregroun                 35            0.1
          -------------------------------------------------------------

Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2
-> Statistics with absolute values (should not be diffed)

Statistic                             Begin Value       End Value
--------------------------------- --------------- ---------------
logons current                                 39              39
opened cursors current                        127             124
session cursor cache count                  9,210          10,106
          -------------------------------------------------------------

Instance Activity Stats  DB/Inst: testb/testb  Snaps: 1-2
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                      Total  per Hour
--------------------------------- ------------------ ---------
log switches (derived)                             6     36.61
          -------------------------------------------------------------
IO Stat by Function - summary  DB/Inst: testb/testb  Snaps: 1-2
->Data Volume values suffixed with   M,G,T,P are in multiples of 1024,
  other values suffixed with       K,M,G,T,P are in multiples of 1000
->ordered by Data Volume (Read+Write) desc

               ---------- Read --------- --------- Write -------- --- Wait ----
                 Data  Requests    Data   Data  Requests    Data          Avg
Function        Volume     /sec  Vol/sec Volume     /sec  Vol/sec  Count Tm(ms)
--------------- ------ -------- -------- ------ -------- -------- ------ ------
Buffer Cache Re   479M   103.9       .8M                             61K    0.0
LGWR                1M      .2       .0M   296M     2.3       .5M   120     0.0
Others             13M     1.4       .0M    27M     3.0       .0M   833     0.0
Direct Reads                .1                                              0.0
          -------------------------------------------------------------

IO Stat by Function - detail  DB/Inst: testb/testb  Snaps: 1-2
->ordered by Data Volume (Read+Write) desc

                   ----------- Read ---------- ----------- Write ---------
                    Small  Large  Small  Large  Small  Large  Small  Large
                     Read   Read   Data   Data  Write  Write   Data   Data
Function             Reqs   Reqs   Read   Read   Reqs   Reqs  Writn  Writn
------------------ ------ ------ ------ ------ ------ ------ ------ ------
Buffer Cache Reads    61K          479M
LGWR                 108             1M          784    572     18M   278M
Others               833            13M         1764            27M
Direct Reads          30
          -------------------------------------------------------------
Tablespace IO Stats  DB/Inst: testb/testb  Snaps: 1-2
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
UNDOTBS1
        60,310     102   19.4     1.0        7,853       13          3    0.0
SYSAUX
           839       1   41.1     1.0        4,732        8          0    0.0
USERS
           157       0   35.7     1.1          143        0          0    0.0
SYSTEM
            40       0   40.5     1.0           60        0          0    0.0
EXAMPLE
             6       0   83.3     1.0            6        0          0    0.0
          -------------------------------------------------------------
File IO Stats  DB/Inst: testb/testb  Snaps: 1-2
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                        Av   Mx                                             Av
                 Av     Rd   Rd    Av                    Av        Buffer BufWt
         Reads Reads/s (ms)  Bkt Blks/Rd       Writes Writes/s      Waits  (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
EXAMPLE                  G:\ORACLE\ORADATA\testb\EXAMPLE01.DBF
             6       0  83.3         1.0            6        0          0

SYSAUX                   G:\ORACLE\ORADATA\testb\SYSAUX01.DBF
           839       1  41.1 ###     1.0        4,732        8          0

SYSTEM                   G:\ORACLE\ORADATA\testb\SYSTEM01.DBF
            40       0  40.5 ###     1.0           60        0          0

UNDOTBS1                 G:\ORACLE\ORADATA\testb\UNDOTBS01.DBF
        60,310     102  19.4 ###     1.0        7,853       13          3    0.0

USERS                    G:\ORACLE\ORADATA\testb\USERS01.DBF
           157       0  35.7 ###     1.1          143        0          0

          -------------------------------------------------------------
File Read Histogram Stats  DB/Inst: testb/testb  Snaps: 1-2
->Number of single block reads in each time range
->Tempfiles are not included
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
    0 - 2 ms     2 - 4 ms    4 - 8 ms     8 - 16 ms   16 - 32 ms       32+ ms
------------ ------------ ------------ ------------ ------------ ------------
SYSTEM                   G:\ORACLE\ORADATA\testb\SYSTEM01.DBF
           0            0            1            1           20           10

UNDOTBS1                 G:\ORACLE\ORADATA\testb\UNDOTBS01.DBF
      11,348          595        8,986       10,066       22,446        6,847

USERS                    G:\ORACLE\ORADATA\testb\USERS01.DBF
           0            0            5           14           61           68

SYSAUX                   G:\ORACLE\ORADATA\testb\SYSAUX01.DBF
           1            1           13          125          372          323

          -------------------------------------------------------------
Instance Recovery Stats  DB/Inst: testb/testb  Snaps: 1-2
-> B: Begin snapshot,  E: End snapshot

  Targt Estd                                  Log File  Log Ckpt    Log Ckpt
  MTTR  MTTR   Recovery   Actual    Target      Size     Timeout    Interval
   (s)   (s)   Estd IOs  Redo Blks Redo Blks Redo Blks  Redo Blks  Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B     0   260      16149    185876    184320     184320    516764
E     0   260      15101    186975    184320     184320    485138
          -------------------------------------------------------------
Memory Target Advice  DB/Inst: testb/testb  Snaps: 1-2
-> Advice Reset: if this is null, the data shown has been diffed between
   the Begin and End snapshots.  If this is 'Y', the advisor has been
   reset during this interval due to memory resize operations, and
   the data shown is since the reset operation.

                Memory Size     Est.     Advice
Memory Size (M)      Factor DB time (s)  Reset
--------------- ----------- ------------ ------
            410          .3        1,200
            820          .5        1,200
          1,230          .8        1,200
          1,640         1.0        1,200
          2,050         1.3        1,200
          2,460         1.5        1,200
          2,870         1.8        1,200
          3,280         2.0        1,200
          -------------------------------------------------------------

Memory Dynamic Components  DB/Inst: testb/testb  Snaps: 1-2
->  Op - memory resize Operation
->  Cache:    D: Default,  K: Keep,  R:  Recycle
->   Mode:  DEF: DEFerred mode,  IMM: IMMediate mode

                       Begin Snap End Snap   Op    Last Op
Cache                    Size (M) Size (M)  Count  Type/Mode   Last Op Time
---------------------- ---------- -------- ------- ---------- ---------------
D:buffer cache                832                0 SHRINK/IMM 01-Май 14:01:00
java pool                      16                0 GROW/IMM   01-Май 14:01:00
large pool                      8                0 STATIC
PGA Target                    616                0 STATIC
SGA Target                  1,024                0 STATIC
shared pool                   160                0 STATIC
          -------------------------------------------------------------

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

                                   Est
                                  Phys      Estimated                   Est
    Size for  Size      Buffers   Read     Phys Reads     Est Phys % dbtime
P    Est (M) Factr  (thousands)  Factr    (thousands)    Read Time  for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
8D        80    .1           10    1.7          1,653      107,959    152.6
8D       160    .2           20    1.4          1,351       87,967    124.3
8D       240    .3           30    1.3          1,236       80,363    113.6
8D       320    .4           40    1.2          1,180       76,645    108.3
8D       400    .5           50    1.2          1,132       73,479    103.8
8D       480    .6           60    1.2          1,092       70,839    100.1
8D       560    .7           70    1.1          1,054       68,361     96.6
8D       640    .8           80    1.1          1,019       66,020     93.3
8D       720    .9           90    1.0            989       64,021     90.5
8D       800   1.0          100    1.0            961       62,166     87.9
8D       840   1.0          105    1.0            947       61,278     86.6
8D       880   1.0          110    1.0            934       60,409     85.4
8D       960   1.1          120    1.0            912       58,953     83.3
8D     1,040   1.2          130    0.9            892       57,594     81.4
8D     1,120   1.3          140    0.9            873       56,339     79.6
8D     1,200   1.4          150    0.9            856       55,261     78.1
8D     1,280   1.5          160    0.9            842       54,314     76.8
8D     1,360   1.6          169    0.9            830       53,503     75.6
8D     1,440   1.7          179    0.9            818       52,729     74.5
8D     1,520   1.8          189    0.8            805       51,866     73.3
8D     1,600   1.9          199    0.8            790       50,867     71.9
          -------------------------------------------------------------

Buffer Pool Statistics  DB/Inst: testb/testb  Snaps: 1-2
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
-> Buffers: the number of buffers.  Units of K, M, G are divided by 1000

                                                            Free Writ     Buffer
            Pool         Buffer     Physical    Physical  Buffer Comp       Busy
P   Buffers Hit%           Gets        Reads      Writes   Waits Wait      Waits
--- ------- ---- -------------- ------------ ----------- ------- ---- ----------
8D     103K  100     65,722,272       61,369      58,352       0    0          3
          -------------------------------------------------------------

Buffer wait Statistics  DB/Inst: testb/testb  Snaps: 1-2
-> ordered by wait time desc, waits desc

Class                        Waits Total Wait Time (s) Avg Time (ms)
---------------------- ----------- ------------------- -------------
undo header                      3                   0             0
          -------------------------------------------------------------
PGA Aggr Target Stats  DB/Inst: testb/testb  Snaps: 1-2
-> B: Begin snap   E: End snap (rows identified 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               37                         0

PGA Aggr Target Histogram  DB/Inst: testb/testb  Snaps: 1-2
-> Optimal Executions are purely in-memory operations

    Low    High
Optimal Optimal    Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
     2K      4K            225           225            0            0
    64K    128K              6             6            0            0
   128K    256K              1             1            0            0
   256K    512K              2             2            0            0
   512K   1024K             38            38            0            0
     1M      2M              2             2            0            0
          -------------------------------------------------------------

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

                                   Estd Extra                Estd
  PGA Aggr                           W/A MB      Estd Time    PGA   Estd PGA
    Target   Size         W/A MB  Read/Written  to Process  Cache  Overalloc
  Est (MB)  Factr      Processed    to Disk      Bytes (s)  Hit %      Count
---------- ------ -------------- -------------- ---------- ------ ----------
        77    0.1            486             75        3.0   87.0         21
       154    0.3            486              8        2.6   98.0         11
       308    0.5            486              0        2.6  100.0          0
       462    0.8            486              0        2.6  100.0          0
       616    1.0            486              0        2.6  100.0          0
       739    1.2            486              0        2.6  100.0          0
       862    1.4            486              0        2.6  100.0          0
       986    1.6            486              0        2.6  100.0          0
     1,109    1.8            486              0        2.6  100.0          0
     1,232    2.0            486              0        2.6  100.0          0
     1,848    3.0            486              0        2.6  100.0          0
     2,464    4.0            486              0        2.6  100.0          0
     3,696    6.0            486              0        2.6  100.0          0
     4,928    8.0            486              0        2.6  100.0          0
          -------------------------------------------------------------
Process Memory Summary Stats  DB/Inst: testb/testb  Snaps: 1-2
-> B: Begin snap   E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
   Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> Num Procs or Allocs:  For Begin/End snapshot lines, it is the number of
   processes. For Category lines, it is the number of allocations
-> ordered by Begin/End snapshot, Alloc (MB) desc

                                                                  Hist   Num
                                          Avg    Std Dev   Max    Max   Procs
             Alloc     Used    Freeabl   Alloc    Alloc   Alloc  Alloc    or
  Category   (MB)      (MB)      (MB)     (MB)    (MB)    (MB)    (MB)  Allocs
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B --------     269.5     240.9       .0      5.6    28.7     200    200     48
  SQL          197.0     167.1               6.0    33.9     195    195     26
  Other         71.0                         1.5     1.5       9     22     48
  PL/SQL         1.4        .4                .0      .0       0      7     46
E --------     302.2     276.0       .0      6.4    34.4     237    237     47
  SQL          233.9     198.7               7.3    40.9     232    232     24
  Other         67.0                         1.4     1.5       9     22     47
  PL/SQL         1.3        .4                .0      .0       0      7     45
          -------------------------------------------------------------

Top Process Memory (by component)  DB/Inst: testb/testb  Snaps: 1-2
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B     42 SHAD --------   199.7   199.2       .0      199.7      199.7
         SQL             194.5   166.1               194.5      194.6
         Other             5.1                         5.1        5.1
         PL/SQL             .1      .0                  .1         .1
      11 LGWR --------     9.2     4.4       .0        9.2        9.9
         Other             9.2                         9.2        9.9
         PL/SQL             .0      .0                  .0         .0
      36 SHAD --------     3.7     2.5       .0        3.7        4.1
         Other             3.5                         3.5        3.5
         SQL                .2      .1                  .2        1.3
         PL/SQL             .1      .0                  .1         .1
      10 DBW0 --------     3.6     2.2       .0        3.6        3.6
         Other             3.6                         3.6        3.6
         PL/SQL             .0      .0                  .0         .0
      47 SHAD --------     3.4     1.5       .0        3.4        5.7
         Other             3.3                         3.3        3.3
         SQL                .1      .0                  .1        2.5
         PL/SQL             .0      .0                  .0        1.1
      15 MMON --------     3.2     1.7       .0        3.2        3.4
         Other             3.1                         3.1        3.1
         SQL                .1      .0                  .1         .6
         PL/SQL             .0      .0                  .0         .1
      38 SHAD --------     2.2     2.0       .0        2.2       30.6
         Other             2.1                         2.1       22.3
         SQL                .1      .0                  .1        8.3
         PL/SQL             .0      .0                  .0         .1
      39 SHAD --------     2.2     1.8       .0        2.2        4.3
         Other             2.1                         2.1        3.0
         SQL                .1      .1                  .1        1.2
         PL/SQL             .0      .0                  .0         .0
      41 SHAD --------     2.2     1.9       .0        2.2        4.3
         Other             2.0                         2.0        2.6
         SQL                .2      .1                  .2        1.6
         PL/SQL             .0      .0                  .0         .1
      13 SMON --------     2.0      .9       .0        2.0        3.2
         Other             1.8                         1.8        1.8
         SQL                .2      .1                  .2        2.0
         PL/SQL             .0      .0                  .0         .0
      26 FBDA --------     2.0     1.2       .0        2.0        2.4
         Other             1.8                         1.8        1.8
         SQL                .2      .1                  .2         .6
         PL/SQL             .0      .0                  .0         .0
      30 SHAD --------     1.9     1.2       .0        1.9        2.2
         Other             1.7                         1.7        1.7
         SQL                .1      .1                  .1         .7
         PL/SQL             .0      .0                  .0         .0
      48 SHAD --------     1.9     1.4       .0        1.9       26.9
         Other             1.7                         1.7       19.3
         SQL                .1      .0                  .1        1.0
         PL/SQL             .0      .0                  .0        6.5
      12 CKPT --------     1.8      .5       .0        1.8        1.8
         Other             1.8                         1.8        1.8
         PL/SQL             .0      .0                  .0         .0

Top Process Memory (by component)  DB/Inst: testb/testb  Snaps: 1-2
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B     40 SHAD --------     1.8     1.6       .0        1.8        2.7
         Other             1.6                         1.6        1.8
         SQL                .2      .1                  .2         .9
         PL/SQL             .0      .0                  .0         .0
      33 SHAD --------     1.7     1.1       .0        1.7        4.4
         Other             1.5                         1.5        1.9
         SQL                .1      .1                  .1        2.4
         PL/SQL             .0      .0                  .0         .1
      43 SHAD --------     1.6     1.3       .0        1.6        3.5
         Other             1.5                         1.5        1.7
         SQL                .1      .1                  .1        1.7
         PL/SQL             .0      .0                  .0         .1
      44 SHAD --------     1.6     1.1       .0        1.6        4.4
         Other             1.4                         1.4        2.3
         SQL                .1      .0                  .1        2.0
         PL/SQL             .0      .0                  .0         .1
      31 SHAD --------     1.5     1.1       .0        1.5        2.2
         Other             1.3                         1.3        1.3
         SQL                .1      .1                  .1         .9
         PL/SQL             .0      .0                  .0         .0
      50 CJQ0 --------     1.4      .9       .0        1.4        4.9
         Other             1.4                         1.4        3.3
         SQL                .1      .0                  .1        1.7
         PL/SQL             .0      .0                  .0         .0
E     42 SHAD --------   237.4   236.9       .0      237.4      237.4
         SQL             231.6   197.7               231.6      231.7
         Other             5.7                         5.7        5.7
         PL/SQL             .1      .0                  .1         .1
      11 LGWR --------     9.2     4.4       .0        9.2        9.9
         Other             9.2                         9.2        9.9
         PL/SQL             .0      .0                  .0         .0
      10 DBW0 --------     3.6     2.2       .0        3.6        3.6
         Other             3.6                         3.6        3.6
         PL/SQL             .0      .0                  .0         .0
      15 MMON --------     3.2     1.7       .0        3.2        3.4
         Other             3.1                         3.1        3.1
         SQL                .1      .0                  .1         .6
         PL/SQL             .0      .0                  .0         .1
      41 SHAD --------     2.4     1.9       .0        2.4        4.3
         Other             2.2                         2.2        2.6
         SQL                .2      .1                  .2        1.6
         PL/SQL             .0      .0                  .0         .1
      38 SHAD --------     2.2     2.0       .0        2.2       30.6
         Other             2.1                         2.1       22.3
         SQL                .1      .0                  .1        8.3
         PL/SQL             .0      .0                  .0         .1
      39 SHAD --------     2.2     1.8       .0        2.2        4.3
         Other             2.1                         2.1        3.0
         SQL                .1      .1                  .1        1.2
         PL/SQL             .0      .0                  .0         .0
      47 SHAD --------     2.0     1.4       .0        2.0        5.7
         Other             1.9                         1.9        2.1
         SQL                .1      .1                  .1        2.5

Top Process Memory (by component)  DB/Inst: testb/testb  Snaps: 1-2
-> ordered by Begin/End snapshot, Alloc (MB) desc

                        Alloc   Used   Freeabl     Max      Hist Max
     PId Category       (MB)    (MB)     (MB)   Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E     47 PL/SQL             .0      .0                  .0        1.1
      13 SMON --------     2.0      .9       .0        2.0        3.2
         Other             1.8                         1.8        1.8
         SQL                .2      .1                  .2        2.0
         PL/SQL             .0      .0                  .0         .0
      26 FBDA --------     2.0     1.2       .0        2.0        2.4
         Other             1.8                         1.8        1.8
         SQL                .2      .1                  .2         .6
         PL/SQL             .0      .0                  .0         .0
      30 SHAD --------     1.9     1.2       .0        1.9        2.2
         Other             1.7                         1.7        1.7
         SQL                .1      .1                  .1         .7
         PL/SQL             .0      .0                  .0         .0
      48 SHAD --------     1.9     1.4       .0        1.9       26.9
         Other             1.7                         1.7       19.3
         SQL                .1      .0                  .1        1.0
         PL/SQL             .0      .0                  .0        6.5
      12 CKPT --------     1.8      .5       .0        1.8        1.8
         Other             1.8                         1.8        1.8
         PL/SQL             .0      .0                  .0         .0
      40 SHAD --------     1.8     1.6       .0        1.8        2.7
         Other             1.6                         1.6        1.8
         SQL                .2      .1                  .2         .9
         PL/SQL             .0      .0                  .0         .0
      33 SHAD --------     1.7     1.1       .0        1.7        4.4
         Other             1.5                         1.5        1.9
         SQL                .1      .1                  .1        2.4
         PL/SQL             .0      .0                  .0         .1
      43 SHAD --------     1.6     1.3       .0        1.6        3.5
         Other             1.5                         1.5        1.7
         SQL                .1      .1                  .1        1.7
         PL/SQL             .0      .0                  .0         .1
      44 SHAD --------     1.6     1.1       .0        1.6        4.4
         Other             1.4                         1.4        2.3
         SQL                .1      .0                  .1        2.0
         PL/SQL             .0      .0                  .0         .1
      31 SHAD --------     1.5     1.1       .0        1.5        2.2
         Other             1.3                         1.3        1.3
         SQL                .1      .1                  .1         .9
         PL/SQL             .0      .0                  .0         .0
      50 CJQ0 --------     1.4      .9       .0        1.4        4.9
         Other             1.4                         1.4        3.3
         SQL                .1      .0                  .1        1.7
         PL/SQL             .0      .0                  .0         .0
      34 SHAD --------     1.4     1.1       .0        1.4        1.8
         Other             1.3                         1.3        1.4
         SQL                .1      .0                  .1         .3
         PL/SQL             .0      .0                  .0         .0
          -------------------------------------------------------------
Enqueue activity  DB/Inst: testb/testb  Snaps: 1-2
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)
------------------------------------------------------------------------------
    Requests    Succ Gets Failed Gets       Waits Wt Time (s)  Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
PS-PX Process Reservation
          72           72           0           6            0          25.83
CF-Controlfile Transaction
         310          310           0           1            0          31.00
          -------------------------------------------------------------

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

Undo   Num Undo       Number of  Max Qry     Max Tx Min/Max   STO/  uS/uR/uU/
 TS# Blocks (K)    Transactions  Len (s)      Concy TR (mins) OOS   eS/eR/eU
---- ---------- --------------- -------- ---------- --------- ----- -----------
   2        3.0             409      632          4 24,6/24,6 0/0   0/0/0/0/0/0
          -------------------------------------------------------------


Undo Segment Stats  DB/Inst: testb/testb  Snaps: 1-2
-> Most recent 35 Undostat rows, ordered by End Time desc

                Num Undo    Number of Max Qry  Max Tx Tun Ret STO/  uS/uR/uU/
End Time          Blocks Transactions Len (s)   Concy  (mins) OOS   eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- -----------
01-Май 15:07       2,977          409     632       4      25 0/0   0/0/0/0/0/0
          -------------------------------------------------------------
Latch Activity  DB/Inst: testb/testb  Snaps: 1-2
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
active checkpoint queue           8,637    0.0             0            0
active service list               1,404    0.4    0.0      0          210    0.0
archive control                       9    0.0             0            0
ASM db client latch                 384    0.0             0            0
ASM map operation hash t              1    0.0             0            0
buffer pool                           1    0.0             0            0
business card                         1    0.0             0            0
cache buffer handles                 74    0.0             0            0
cache buffers chains         76,234,499    0.0    0.0      0       65,072    0.0
cache buffers lru chain         117,204    0.0    0.0      0       66,511    0.1
cache table scan latch                6    0.0             0            6    0.0
cas latch                             1    0.0             0            0
change notification clie              1    0.0             0            0
channel handle pool latc             26    0.0             0            0
channel operations paren          2,742    0.0             0            0
checkpoint queue latch          150,133    0.0    0.0      0       57,482    0.0
client/application info             542    1.5    0.0      0            0
commit callback allocati             25    0.0             0            0
compile environment latc             41    2.4    0.0      0            0
Consistent RBA                      614    0.0             0            0
corrupted undo seg lock          11,066    0.0             0            0
cp cmon/server latch                  1    0.0             0            0
cp pool latch                         1    0.0             0            0
cp server hash latch                  1    0.0             0            0
cp sga latch                         14    0.0             0            0
cv apply list lock                    1    0.0             0            0
cv free list lock                     1    0.0             0            0
deferred cleanup latch               14    0.0             0            0
DML lock allocation             120,040    0.0             0            0
dml lock allocation                  14    0.0             0            0
done queue latch                      1    0.0             0            0
dummy allocation                     83    1.2    0.0      0            0
enqueue hash chains              15,863    0.0             0            0
enqueues                         10,718    0.0    0.0      0            0
error message lists                  12    0.0             0            0
Event Group Locks                    13    0.0             0            0
fifth spare latch                     1    0.0             0            0
file cache latch                      2    0.0             0            0
File State Object Pool P              1    0.0             0            0
flashback archiver latch              2    0.0             0            0
flashback copy                        1    0.0             0            0
FOB s.o list latch                    6    0.0             0            0
gc element                            1    0.0             0            0
gcs commit scn state                  1    0.0             0            0
gcs partitioned table ha              1    0.0             0            0
gcs pcm hashed value buc              1    0.0             0            0
gcs resource freelist                 1    0.0             0            0
gcs resource hash                     1    0.0             0            0
gcs resource scan list                1    0.0             0            0
gcs shadows freelist                  1    0.0             0            0
Latch Activity  DB/Inst: testb/testb  Snaps: 1-2
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
ges domain table                      1    0.0             0            0
ges enqueue table freeli              1    0.0             0            0
ges group table                       1    0.0             0            0
ges process hash list                 1    0.0             0            0
ges process parent latch              1    0.0             0            0
ges resource hash list                1    0.0             0            0
ges resource scan list                1    0.0             0            0
ges resource table freel              1    0.0             0            0
ges value block free lis              1    0.0             0            0
global KZLD latch for me              2    0.0             0            0
global tx hash mapping                1    0.0             0            0
granule operation                     1    0.0             0            0
hash table column usage             295    0.0             0        5,199    0.0
hash table modification              23    0.0             0            0
In memory undo latch              3,929    0.0             0          793    0.0
intra txn parallel recov            154    0.0             0            0
io pool granule metadata              1    0.0             0            0
IPC stats buffer allocat              1    0.0             0            0
job workq parent latch                1    0.0             0           22    0.0
job_queue_processes para             20    0.0             0            0
JS queue access latch                 1    0.0             0            0
JS queue state obj latch          4,176    0.0             0            0
JS Sh mem access                      1    0.0             0            0
JS slv state obj latch               29    0.0             0            0
kdlx hb parent latch                  1    0.0             0            0
KFC FX Hash Latch                     1    0.0             0            0
KFC Hash Latch                        1    0.0             0            0
KFCL LE Freelist                      1    0.0             0            0
KFR redo allocation latc              1    0.0             0            0
kgb parent                            1    0.0             0            0
KGNFS-NFS:SHM structure               1    0.0             0            0
KGNFS-NFS:SVR LIST                    1    0.0             0            0
KJC message pool free li              1    0.0             0            0
KJCT flow control latch               1    0.0             0            0
kks stats                           336    0.0             0            0
KMG MMAN ready and start            196    0.0             0            0
kokc descriptor allocati             66    0.0             0            0
ksfv messages                         1    0.0             0            0
kss move lock                         1    0.0             0            0
ksuosstats global area               42    0.0             0            0
ksv allocation latch                 14    0.0             0            0
ksv class latch                       1    0.0             0            0
ksv msg queue latch                   1    0.0             0            0
ksz_so allocation latch              24    0.0             0            0
KTF sga latch                         1    0.0             0          172    0.0
ktm global data                       5    0.0             0            0
kwqbsn:qsga                          26    0.0             0            0
KWQP Prop Status                      1    0.0             0            0
KWQS pqueue ctx latch                10    0.0             0            0
k2q lock allocation                   1    0.0             0            0
Latch Activity  DB/Inst: testb/testb  Snaps: 1-2
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
lgwr LWN SCN                        612    0.0             0            0
library cache load lock             260    0.0             0            0
list of block allocation             42    0.0             0            0
loader state object free             84    0.0             0            0
lob segment dispenser la              1    0.0             0            0
lob segment hash table l              1    0.0             0            0
lob segment query latch               1    0.0             0            0
Locator state objects po              1    0.0             0            0
lock DBA buffer during m              1    0.0             0            0
logical standby cache                 1    0.0             0            0
logminer context allocat              1    0.0             0            0
logminer work area                    1    0.0             0            0
longop free list parent               1    0.0             0            0
mapped buffers lru chain              1    0.0             0            0
Memory Management Latch               1    0.0             0          196    0.0
Memory Queue                          1    0.0             0            0
Memory Queue Message Sub              1    0.0             0            0
Memory Queue Message Sub              1    0.0             0            0
Memory Queue Message Sub              1    0.0             0            0
Memory Queue Message Sub              1    0.0             0            0
Memory Queue Subscriber               1    0.0             0            0
message pool operations              21    0.0             0            0
messages                         23,774    0.0    0.1      0            0
MinActiveScn Latch                2,478    0.0             0            0
mostly latch-free SCN               619    1.1    0.0      0            0
MQL Tracking Latch                    0                    0           12    0.0
msg queue latch                       1    0.0             0            0
multiblock read objects              12    0.0             0            0
Mutex                                 1    0.0             0            0
Mutex Stats                           1    0.0             0            0
name-service namespace b              1    0.0             0            0
ncodef allocation latch              14    0.0             0            0
object queue header heap         17,361    0.0             0          143    0.0
object queue header oper        257,410    0.0    0.0      0            0
object stats modificatio             51    0.0             0            0
OS process                           97    0.0             0            0
OS process allocation               260    0.0             0            0
OS process: request allo             24    0.0             0            0
parallel query alloc buf            185    0.0             0            0
parallel query stats                 23    0.0             0            0
parallel txn reco latch       2,572,885    0.0    0.0      0            0
parameter list                        1    0.0             0            0
parameter table manageme             82    0.0             0            0
peshm                                 1    0.0             0            0
pesom_free_list                       1    0.0             0            0
pesom_hash_node                       1    0.0             0            0
pesom_heap_alloc                      1    0.0             0            0
PL/SQL warning settings             361    1.1    0.0      0            0
post/wait queue                     324    0.0             0          193    0.0
process allocation                   34    0.0             0           12    0.0
Latch Activity  DB/Inst: testb/testb  Snaps: 1-2
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
process group creation               24    0.0             0            0
process queue                        81    0.0             0            0
process queue reference         128,122    0.0             0       61,507    0.0
qmn task queue latch                 84    2.4    1.0      0            0
QMT                                   1    0.0             0            0
query server freelists               84    1.2    0.0      0            0
queued dump request                   2    0.0             0            0
recovery domain hash lis              1    0.0             0            0
redo allocation                   4,342    0.5    0.0      0    2,749,321    0.0
redo copy                             1    0.0             0    2,749,360    0.0
redo writing                     11,216    0.0    0.0      0            0
resmgr group change latc            107    3.7    0.0      0            0
resmgr:active threads                82    0.0             0            0
resmgr:actses change gro             32    0.0             0            0
resmgr:actses change sta              1    0.0             0            0
resmgr:free threads list             82    4.9    0.3      0            0
resmgr:plan CPU method                1    0.0             0            0
resmgr:resource group CP              1    0.0             0            0
resmgr:session queuing                1    0.0             0            0
rm cas latch                          1    0.0             0            0
row cache objects            10,557,102    0.0    0.0      0          114    0.0
rules engine rule set st            100    0.0             0            0
second spare latch                    1    0.0             0            0
sequence cache                       48    0.0             0            0
session allocation               27,979    0.0    0.3      0            0
session idle bit                  5,313    0.0    0.0      0            0
session queue latch                   1    0.0             0            0
session state list latch             83    2.4    0.0      0            0
session switching                    15    0.0             0            0
session timer                       210    0.0             0            0
SGA blob parent                       1    0.0             0            0
SGA bucket locks                      1    0.0             0            0
SGA heap locks                        1    0.0             0            0
SGA pool locks                        1    0.0             0            0
Shared B-Tree                        37    0.0             0            0
shared pool                      91,426    0.0    0.3      0            0
shared pool sim alloc                 4    0.0             0            0
shared pool simulator           231,581    0.0             0            0
sim partition latch                   1    0.0             0            0
simulator hash latch          4,186,808    0.0    0.0      0            0
simulator lru latch           4,178,814    0.0    0.0      0        3,992    0.0
sort extent pool                  1,717    0.0             0            0
space background task la            432    0.0             0          392    0.0
SQL memory manager latch              1    0.0             0          188    0.0
SQL memory manager worka         71,722    0.0             0            0
Streams Generic                       1    0.0             0            0
tablespace key chain                  1    0.0             0            0
test excl. parent l0                  1    0.0             0            0
test excl. parent2 l0                 1    0.0             0            0
Testing                               1    0.0             0            0
Latch Activity  DB/Inst: testb/testb  Snaps: 1-2
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
third spare latch                     1    0.0             0            0
threshold alerts latch                2    0.0             0            0
Token Manager                         1    0.0             0            0
transaction allocation           26,298    0.0             0            0
transaction branch alloc            210    0.0             0            0
undo global data                127,188    0.0             0            0
user lock                            32    0.0             0            0
virtual circuit buffers               1    0.0             0            0
virtual circuit holder                1    0.0             0            0
virtual circuit queues                1    0.0             0            0
Write State Object Pool               1    0.0             0            0
XDB NFS Security Latch                1    0.0             0            0
XDB unused session pool               1    0.0             0            0
XDB used session pool                 1    0.0             0            0
          -------------------------------------------------------------
Latch Sleep breakdown  DB/Inst: testb/testb  Snaps: 1-2
-> ordered by misses desc

                                       Get                                 Spin
Latch Name                        Requests       Misses      Sleeps        Gets
-------------------------- --------------- ------------ ----------- -----------
simulator lru latch              4,178,814          311           2         309
cache buffers chains            76,234,499          120           5         115
parallel txn reco latch          2,572,885           35           1          34
cache buffers lru chain            117,204           29           1          28
shared pool                         91,426           24           6          19
messages                            23,774           10           1           9
session allocation                  27,979            4           1           3
resmgr:free threads list                82            4           1           3
qmn task queue latch                    84            2           2           0
          -------------------------------------------------------------
Latch Miss Sources  DB/Inst: testb/testb  Snaps: 1-2
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains     kcbgcur_6                        0          6        0
cache buffers chains     kcbzib: finish free bufs         0          1        0
cache buffers chains     kcbchg1: kslbegin: bufs no       0          1        1
cache buffers chains     kcbgtcr: fast path (cr pin       0          1        6
cache buffers chains     kcbgtcr_1                        0          1        0
cache buffers lru chain  kcbzgws                          0          1        0
messages                 ksarcv: after wait               0          1        1
parallel txn reco latch  ktprxrtf                         0          1        1
qmn task queue latch     kwqmnmvtsks: delay to read       0          2        0
resmgr:free threads list kskthrcreate                     0          1        1
session allocation       ksuxds: KSUSFCLC not set         0          1        0
shared pool              kghalo                           0          6        6
simulator lru latch      kcbs_simulate: simulate se       0          2        2
          -------------------------------------------------------------
Dictionary Cache Stats  DB/Inst: testb/testb  Snaps: 1-2
->"Pct Misses"  should be very low (< 2% in most cases)
->"Final Usage" is the number of cache entries being used in End Snapshot

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_database_links                    4    0.0       0              0          1
dc_global_oids                   1,095    0.0       0              0         49
dc_histogram_defs                1,456   47.3       0              0      3,299
dc_object_grants                   110    0.0       0              0        139
dc_objects                   2,499,608    0.0       0              0      2,032
dc_profiles                         15    0.0       0              0          2
dc_rollback_segments           116,004    0.0       0              0         22
dc_segments                        186    0.0       0              0        680
dc_tablespaces               2,528,699    0.0       0              0          7
dc_users                        33,445    0.0       0              0        210
global database name                13    0.0       0              0          1
          -------------------------------------------------------------


Library Cache Activity  DB/Inst: testb/testb  Snaps: 1-2
->"Pct Misses"  should be very low

                         Get  Pct        Pin        Pct               Invali-
Namespace           Requests  Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
SQL AREA                 740    0.5        448,461    0.1         64        0
TABLE/PROCEDURE        2,142    0.0         93,624    0.2        148        0
BODY                     201    0.0         75,358    0.0          0        0
TRIGGER                  142    0.0         88,080    0.0          0        0
          -------------------------------------------------------------
Rule Sets  DB/Inst: testb/testb  Snaps: 1-2
-> * indicates Rule Set activity (re)started between Begin/End snaps
-> Top 25 ordered by Evaluations desc

                                                               No-SQL  SQL
Rule                                *     Eval/sec Reloads/sec Eval % Eval %
----------------------------------- - ------------ ----------- ------ ------
SYS.ALERT_QUE_R                                  0           0      0      0
          -------------------------------------------------------------
Shared Pool Advisory  DB/Inst: testb/testb  End Snap: 2
-> SP: Shared Pool     Est LC: Estimated Library Cache   Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
   in the Library Cache, and the physical number of memory objects associated
   with it.  Therefore comparing the number of Lib Cache objects (e.g. in
   v$librarycache), with the number of Lib Cache Memory Objects is invalid

                                        Est LC Est LC  Est LC Est LC
    Shared    SP   Est LC                 Time   Time    Load   Load      Est LC
      Pool  Size     Size       Est LC   Saved  Saved    Time   Time         Mem
  Size (M) Factr      (M)      Mem Obj     (s)  Factr     (s)  Factr    Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
       144    .9       11        1,513  97,548    1.0     608    1.7   1,149,924
       160   1.0       27        3,348  97,806    1.0     350    1.0   1,670,666
       176   1.1       43        4,888  97,971    1.0     185     .5   1,672,003
       192   1.2       59        6,338  98,032    1.0     124     .4   1,672,463
       208   1.3       75        7,831  98,051    1.0     105     .3   1,672,629
       224   1.4       85        9,305  98,052    1.0     104     .3   1,672,652
       240   1.5       88        9,756  98,052    1.0     104     .3   1,672,652
       256   1.6       88        9,756  98,052    1.0     104     .3   1,672,652
       272   1.7       88        9,756  98,052    1.0     104     .3   1,672,652
       288   1.8       88        9,756  98,052    1.0     104     .3   1,672,652
       304   1.9       88        9,756  98,052    1.0     104     .3   1,672,652
       320   2.0       88        9,756  98,052    1.0     104     .3   1,672,652
          -------------------------------------------------------------


Java Pool Advisory  DB/Inst: testb/testb  End Snap: 2

                                        Est LC Est LC  Est LC Est LC
      Java    JP   Est LC                 Time   Time    Load   Load      Est LC
      Pool  Size     Size       Est LC   Saved  Saved    Time   Time         Mem
   Size(M) Factr      (M)      Mem Obj     (s)  Factr     (s)  Factr    Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
        16   1.0        0          133      38    1.0     350    1.0          71
        24   1.5        0          141      38    1.0     350    1.0          75
        32   2.0        0          141      38    1.0     350    1.0          75
          -------------------------------------------------------------
SGA Target Advisory  DB/Inst: testb/testb  End Snap: 2

SGA Target SGA Size   Est DB      Est DB   Est Physical
  Size (M)   Factor Time (s) Time Factor          Reads
---------- -------- -------- ----------- --------------
       256       .3  106,962         1.5      1,238,807
       512       .5   88,480         1.3      1,000,722
       768       .8   79,394         1.1        882,485
     1,024      1.0   70,761         1.0        766,778
     1,280      1.3   66,020          .9        706,586
     1,536      1.5   62,786          .9        665,027
     1,792      1.8   59,913          .8        627,378
     2,048      2.0   59,913          .8        627,378
          -------------------------------------------------------------
SGA Memory Summary  DB/Inst: testb/testb  Snaps: 1-2

                                                        End Size (Bytes)
SGA regions                      Begin Size (Bytes)       (if different)
------------------------------ -------------------- --------------------
Database Buffers                        872,415,232
Fixed Size                                1,334,380
Redo Buffers                              4,644,864
Variable Size                           192,938,900
                               -------------------- --------------------
sum                                   1,071,333,376
          -------------------------------------------------------------


SGA breakdown difference  DB/Inst: testb/testb  Snaps: 1-2
-> Top 35 rows by size, ordered by Pool, Name (note rows with null values for
   Pool column, or Names showing free memory are always shown)
-> Null value for Begin MB or End MB indicates the size of that Pool/Name was
   insignificant, or zero in that snapshot

Pool   Name                                 Begin MB         End MB  % Diff
------ ------------------------------ -------------- -------------- --------
java p free memory                               7.3            7.3     0.00
java p joxlod exec hp                            8.4            8.4     0.00
java p joxs heap                                  .3             .3     0.00
large  free memory                               7.0            7.0     0.00
large  PX msg pool                               1.0            1.0     0.00
shared ASH buffers                               8.0            8.0     0.00
shared CCursor                                   5.6            5.7     1.47
shared db_block_hash_buckets                     3.0            3.0     0.00
shared dbwriter coalesce buffer                  4.0            4.0     0.00
shared event statistics per sess                 1.7            1.7     0.00
shared free memory                              21.1           20.8    -1.04
shared Heap0: KGL                                4.5            4.5    -0.49
shared KCB Table Scan Buffer                     4.0            4.0     0.00
shared KGL buckets                               3.0            3.0     0.00
shared KGL handle                                6.5            6.5     0.12
shared KGLS heap                                 4.1            4.2     3.97
shared kglsim hash table bkts                    2.0            2.0     0.00
shared KQR M PO                                  2.4            2.6    11.66
shared KSFD SGA I/O b                            4.0            4.0     0.00
shared obj stats allocation chun                 2.1            2.1     0.00
shared PCursor                                   2.7            2.7    -1.47
shared PL/SQL DIANA                             14.0           13.5    -3.73
shared PL/SQL MPCODE                            12.4           12.3    -0.66
shared row cache                                 3.6            3.6     0.00
shared sessions                                  1.7            1.7     0.00
shared sql area                                 17.9           18.3     2.52
shared type object de                            2.4            2.4     0.00
       buffer_cache                            832.0          832.0     0.00
       fixed_sga                                 1.3            1.3     0.00
       log_buffer                                4.4            4.4     0.00
          -------------------------------------------------------------
SQL Memory Statistics  DB/Inst: testb/testb  Snaps: 1-2

                                   Begin            End         % Diff
                          -------------- -------------- --------------
   Avg Cursor Size (KB):           19.92          20.00            .42
 Cursor to Parent ratio:            1.08           1.08           -.03
          Total Cursors:           1,027          1,031            .39
          Total Parents:             949            953            .42
          -------------------------------------------------------------
init.ora Parameters  DB/Inst: testb/testb  Snaps: 1-2

                                                                  End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
audit_file_dest               G:\ORACLE\ADMIN\testb\ADUMP
audit_trail                   DB
compatible                    11.1.0.0.0
control_files                 G:\ORACLE\ORADATA\testb\CONTROL01.
                              CTL, G:\ORACLE\ORADATA\testb\CONTR
                              OL02.CTL, G:\ORACLE\ORADATA\testb\
                              CONTROL03.CTL
db_block_size                 8192
db_domain
db_name                       testb
db_recovery_file_dest         G:\oracle\flash_recovery_area
db_recovery_file_dest_size    2147483648
diagnostic_dest               G:\ORACLE
dispatchers                   (PROTOCOL=TCP) (SERVICE=testbXDB)
memory_target                 1719664640
open_cursors                  300
processes                     150
remote_login_passwordfile     EXCLUSIVE
smtp_out_server               192.168.123.14
undo_tablespace               UNDOTBS1
          -------------------------------------------------------------

End of Report ( sp_1_2.lst )