=============================================================================== 
      Sybase Adaptive Server Enterprise System Performance Report
=============================================================================== 
 
Server Version:        Adaptive Server Enterprise/15.5/EBF 20633 SMP ESD#5.2/P/ 
                       RS6000/AIX 5.3/asear155/2602/64-bit/FBO/Sun Dec  9 11:59 
                       :29 2012                                                 
Run Date:              Dec 17, 2013                                             
Sampling Started at:   Dec 17, 2013 17:05:01                                    
Sampling Ended at:     Dec 17, 2013 17:10:01                                    
Sample Interval:       00:05:00                                                 
Sample Mode:           No Clear                                                 
Counters Last Cleared: Dec 10, 2013 02:10:18                                    
Server Name:           XXXXXXX                                                   
=============================================================================== 
 
Kernel Utilization
------------------
 
  Your Runnable Process Search Count is set to 2000                             
  and I/O Polling Process Count is set to 10                                    
 
  Engine Busy Utilization        CPU Busy   I/O Busy       Idle                 
  ------------------------       --------   --------   --------    
    Engine 0                       27.9 %     64.0 %      8.0 %              
    Engine 1                       31.8 %     60.1 %      8.1 %              
    Engine 2                       27.6 %     65.3 %      7.1 %              
    Engine 3                       23.8 %     54.9 %     21.3 %              
    Engine 4                       27.3 %     67.8 %      5.0 %              
  ------------------------       --------   --------   --------    
  Summary           Total         138.4 %    312.1 %    149.4 %              
                  Average          23.1 %     52.0 %     24.9 %              
 
  CPU Yields by Engine            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total CPU Yields                    0.0           0.0           0       n/a   
 
  Network Checks
    Non-Blocking                  40977.5          99.8    12293262     100.0 %
    Blocking                          0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
  Total Network I/O Checks        40977.5          99.8    12293262             
  Avg Net I/Os per Check              n/a           n/a     0.08183       n/a   
 
  Disk I/O Checks
    Total Disk I/O Checks         47243.8         115.0    14173151       n/a   
    Checks Returning I/O          40817.0          99.4    12245093      86.4 %
    Avg Disk I/Os Returned            n/a           n/a     0.08596       n/a   
 
 
=============================================================================== 
 
Worker Process Management
-------------------------
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ---------- 
 Worker Process Requests
   Total Requests                     0.0           0.0           0       n/a   
 
 Worker Process Usage
   Total Used                         0.0           0.0           0       n/a   
   Max Ever Used During Sample        0.0           0.0           0       n/a   
 
 Memory Requests for Worker Processes
   Total Requests                     0.0           0.0           0       n/a   
 
 Tuning Recommendations for Worker Processes                                    
 -------------------------------------------                                    
  - Consider decreasing the 'number of worker processes'
    configuration parameter.
 
 
=============================================================================== 
 
Parallel Query Management
-------------------------
 
  Parallel Query Usage            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Parallel Queries              0.0           0.0           0       n/a   
 
  Merge Lock Requests             per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total # of Requests                 0.0           0.0           0       n/a   
 
  Sort Buffer Waits               per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total # of Waits                    0.0           0.0           0       n/a   
 
=============================================================================== 
 
Task Management                   per sec      per xact       count  % of total
---------------------------  ------------  ------------  ----------  ---------- 
 
  Connections Opened                  0.4           0.0         122       n/a   
 
  Task Context Switches by Engine
    Engine 0                       1455.8           3.5      436727      17.8 %
    Engine 1                       1467.0           3.6      440104      17.9 %
    Engine 2                       1447.4           3.5      434234      17.7 %
    Engine 3                       2342.4           5.7      702719      28.6 %
    Engine 4                       1482.3           3.6      444704      18.1 %
  -------------------------  ------------  ------------  ----------
    Total Task Switches:           8195.0          19.9     2458488             
 
  Task Context Switches Due To:
    Voluntary Yields                240.4           0.6       72131       2.9 %
    Cache Search Misses             681.2           1.7      204368       8.3 %
    Exceeding I/O batch size          2.1           0.0         625       0.0 %
    System Disk Writes              136.2           0.3       40872       1.7 %
    Logical Lock Contention           6.9           0.0        2056       0.1 %
    Address Lock Contention           0.3           0.0          88       0.0 %
    Latch Contention                 11.3           0.0        3381       0.1 %
    Physical Lock Transition          0.0           0.0           0       0.0 %
    Logical Lock Transition           0.0           0.0           0       0.0 %
    Object Lock Transition            0.0           0.0           0       0.0 %
    Log Semaphore Contention         94.8           0.2       28429       1.2 %
    PLC Lock Contention              15.1           0.0        4517       0.2 %
    Group Commit Sleeps             216.8           0.5       65035       2.6 %
    Last Log Page Writes            216.5           0.5       64953       2.6 %
    Modify Conflicts                105.6           0.3       31669       1.3 %
    I/O Device Contention             0.0           0.0           0       0.0 %
    Network Packet Received        1665.0           4.1      499512      20.3 %
    Network Packet Sent             933.8           2.3      280127      11.4 %
    Interconnect Message Sleeps       0.0           0.0           0       0.0 %
    Network services               2370.5           5.8      711158      28.9 %
    Other Causes                   1498.6           3.6      449567      18.3 %
 
 
=============================================================================== 
 
Application Management
----------------------
 
  Application Statistics Summary (All Applications)
  -------------------------------------------------
  Priority Changes                per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    To High Priority                113.6           0.3       34089      49.4 %
    To Medium Priority              115.2           0.3       34569      50.1 %
    To Low Priority                   1.2           0.0         358       0.5 %
  -------------------------  ------------  ------------  ----------
  Total Priority Changes            230.1           0.6       69016             
 
  Allotted Slices Exhausted       per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    High Priority                     0.0           0.0           0       0.0 %
    Medium Priority                   1.3           0.0         399      98.3 %
    Low Priority                      0.0           0.0           7       1.7 %
  -------------------------  ------------  ------------  ----------
  Total Slices Exhausted              1.4           0.0         406             
 
  Skipped Tasks By Engine         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Engine Skips                  0.0           0.0           0       n/a   
 
  Engine Scope Changes                0.0           0.0           0       n/a   
 
=============================================================================== 
 
ESP Management                    per sec      per xact       count  % of total
---------------------------  ------------  ------------  ----------  ---------- 
  ESP Requests                        0.0           0.0           0       n/a   
=============================================================================== 
 
Housekeeper Task Activity
-------------------------
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------             
Buffer Cache Washes                                                             
  Clean                            218.4           0.5       65532      99.4 % 
  Dirty                              1.4           0.0         415       0.6 % 
                             ------------  ------------  ----------             
Total Washes                       219.8           0.5       65947              
 
Garbage Collections                  4.8           0.0        1425       n/a    
Pages Processed in GC                0.3           0.0          81       n/a    
 
Statistics Updates                   1.2           0.0         345       n/a    
 
=============================================================================== 
 
Monitor Access to Executing SQL
-------------------------------
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ---------- 
 Waits on Execution Plans            0.0           0.0           0       n/a    
 Number of SQL Text Overflows        0.0           0.0           0       n/a    
 Maximum SQL Text Requested          n/a           n/a     2139896       n/a    
  (since beginning of sample)                                                   
 
 
 Tuning Recommendations for Monitor Access to Executing SQL                     
 ----------------------------------------------------------                     
 - Consider increasing the 'max SQL text monitored' parameter 
   to at least 1209948 (i.e., half way from its current value 
   to Maximum SQL Text Requested).
 
=============================================================================== 
 
Transaction Profile
-------------------
 
  Transaction Summary             per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Committed Xacts                 410.8           n/a      123238     n/a     
 
  Transaction Detail              per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Inserts
    Fully Logged
      APL Heap Table               2140.6           5.2      642166      90.0 %
      APL Clustered Table             0.0           0.0           0       0.0 %
      Data Only Lock Table          236.9           0.6       71056      10.0 %
      Fast Bulk Insert                0.0           0.0           0       0.0 %
    Minimally Logged
      APL Heap Table                  0.0           0.0           0       0.0 %
      APL Clustered Table             0.0           0.0           0       0.0 %
      Data Only Lock Table            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Rows Inserted              2377.4           5.8      713222      69.6 %
 
  Updates
    Fully Logged
      APL Deferred                   11.3           0.0        3380       1.3 %
      APL Direct In-place            44.1           0.1       13234       5.1 %
      APL Direct Cheap              306.8           0.7       92027      35.3 %
      APL Direct Expensive            0.0           0.0           0       0.0 %
      DOL Deferred                    0.1           0.0          28       0.0 %
      DOL Direct                    506.7           1.2      152013      58.3 %
    Minimally Logged
      APL Direct In-place             0.0           0.0           0       0.0 %
      APL Direct Cheap                0.0           0.0           0       0.0 %
      APL Direct Expensive            0.0           0.0           0       0.0 %
      DOL Direct                      0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Rows Updated                868.9           2.1      260682      25.4 %
 
  Data Only Locked Updates
    Fully Logged
      DOL Replace                   211.0           0.5       63306      44.4 %
      DOL Shrink                     18.3           0.0        5500       3.9 %
      DOL Cheap Expand                9.2           0.0        2751       1.9 %
      DOL Expensive Expand           12.8           0.0        3845       2.7 %
      DOL Expand & Forward            0.7           0.0         196       0.1 %
      DOL Fwd Row Returned            0.0           0.0           8       0.0 %
    Minimally Logged
      DOL Replace                   254.8           0.6       76435      53.6 %
      DOL Shrink                      0.0           0.0           0       0.0 %
      DOL Cheap Expand                0.0           0.0           0       0.0 %
      DOL Expensive Expand            0.0           0.0           0       0.0 %
      DOL Expand & Forward            0.0           0.0           0       0.0 %
      DOL Fwd Row Returned            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total DOL Rows Updated            475.4           1.2      142610      13.9 %
 
  Deletes
    Fully Logged
      APL Deferred                    0.8           0.0         240       0.5 %
      APL Direct                    140.5           0.3       42135      82.6 %
      DOL                            28.7           0.1        8622      16.9 %
    Minimally Logged
      APL Direct                      0.0           0.0           0       0.0 %
      DOL                             0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Rows Deleted                170.0           0.4       50997       5.0 %
 
  =========================  ============  ============  ==========
  Total Rows Affected              3416.3           8.3     1024901             
  =========================  ============  ============  ==========
 
=============================================================================== 
 
Transaction Management
----------------------
 
  ULC Flushes to Xact Log         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Any Logging Mode DMLs
    by End Transaction              345.5           0.8      103662      46.9 %
    by Change of Database             0.1           0.0          36       0.0 %
    by Unpin                         53.6           0.1       16082       7.3 %
    by Log markers                  262.7           0.6       78801      35.7 %
 
  Fully Logged DMLs
    by Full ULC                      59.0           0.1       17693       8.0 %
    by Single Log Record             15.3           0.0        4589       2.1 %
 
  Minimally Logged DMLs
    by Full ULC                       0.0           0.0           0       0.0 %
    by Single Log Record              0.0           0.0           0       0.0 %
    by Start of Sub-Command           0.0           0.0           0       0.0 %
    by End of Sub-Command             0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
  Total ULC Flushes                 736.2           1.8      220863             
 
  ULC Flushes Skipped             per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Fully Logged DMLs
    by ULC Discards                  70.6           0.2       21173     100.0 %
  Minimally Logged DMLs
    by ULC Discards                   0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
  Total ULC Flushes Skips            70.6           0.2       21173             
 
  ULC Log Records                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Fully Logged DMLs                5377.1          13.1     1613118       100.0 
  Minimally Logged DMLs               0.0           0.0           0         0.0 
  -------------------------  ------------  ------------  ----------
  Total ULC Log Records            5377.1          13.1     1613118             
 
  Max ULC Size During Sample
  --------------------------
  Fully Logged DMLs                   n/a           n/a           0       n/a   
  Minimally Logged DMLs               n/a           n/a           0       n/a   
 
  ML-DMLs Sub-Command Scans       per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Sub-Command Scans             0.0           0.0           0       n/a   
 
  ML-DMLs ULC Efficiency          per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total ML-DML Sub-Commands           0.0           0.0           0       n/a   
 
  ULC Semaphore Requests
    Granted                       11384.2          27.7     3415264      99.9 %
    Waited                           15.1           0.0        4517       0.1 %
  -------------------------  ------------  ------------  ----------
  Total ULC Semaphore Req         11399.3          27.7     3419781             
 
  Log Semaphore Requests
    Granted                         679.9           1.7      203973      87.8 %
    Local Waited                     94.8           0.2       28429      12.2 %
    Global Waited                     0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
  Total Log Semaphore Req           774.7           1.9      232402             
 
  Transaction Log Writes            345.2           0.8      103573       n/a   
  Transaction Log Alloc             445.1           1.1      133541       n/a   
  Avg # Writes per Log Page           n/a           n/a     0.77559       n/a   
 
=============================================================================== 
 
Index Management
----------------
 
  Nonclustered Maintenance        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Ins/Upd Requiring Maint           0.0           0.0           0       n/a   
      # of NC Ndx Maint               0.0           0.0           0       n/a   
 
    Deletes Requiring Maint           0.0           0.0           0       n/a   
      # of NC Ndx Maint               0.0           0.0           0       n/a   
 
    RID Upd from Clust Split          0.0           0.0           0       n/a   
      # of NC Ndx Maint               0.0           0.0           0       n/a   
 
    Upd/Del DOL Req Maint           535.5           1.3      160663       n/a   
      # of DOL Ndx Maint            293.2           0.7       87973       n/a   
      Avg DOL Ndx Maint / Op          n/a           n/a     0.54756       n/a   
 
  Page Splits                        13.1           0.0        3944       n/a   
    Retries                           0.0           0.0           0       0.0 %
    Deadlocks                         0.0           0.0           0       0.0 %
    Add Index Level                   0.0           0.0           0       0.0 %
 
  Page Shrinks                        0.1           0.0          43       n/a   
    Deadlocks                          %                                       
    Deadlock Retries Exceeded         0.0           0.0           0       0.0 %
 
  Index Scans                     per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Ascending Scans                4360.2          10.6     1308050      16.6 %
    DOL Ascending Scans           21872.4          53.2     6561713      83.4 %
    Descending Scans                  3.4           0.0        1026       0.0 %
    DOL Descending Scans              0.2           0.0          61       0.0 %
                             ------------  ------------  ----------             
    Total Scans                   26236.2          63.9     7870850             
 
=============================================================================== 
 
Metadata Cache Management
-------------------------
 
  Metadata Cache Summary         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
 
  Open Object Usage                                                             
    Active                            n/a           n/a        7091       n/a   
    Max Ever Used Since Boot          n/a           n/a        7812       n/a   
    Free                              n/a           n/a        7909       n/a   
    Reuse Requests                                                              
      Succeeded                       n/a           n/a           0       n/a   
      Failed                          n/a           n/a           0       n/a   
 
  Open Index Usage                                                              
    Active                            n/a           n/a        2781       n/a   
    Max Ever Used Since Boot          n/a           n/a        2786       n/a   
    Free                              n/a           n/a        4219       n/a   
    Reuse Requests                                                              
      Succeeded                       n/a           n/a           0       n/a   
      Failed                          n/a           n/a           0       n/a   
 
  Open Partition Usage                                                          
    Active                            n/a           n/a        2781       n/a   
    Max Ever Used Since Boot          n/a           n/a        2786       n/a   
    Free                              n/a           n/a        6219       n/a   
    Reuse Requests                                                              
      Succeeded                       n/a           n/a           0       n/a   
      Failed                          n/a           n/a           0       n/a   
 
  Open Database Usage                                                           
    Active                            n/a           n/a          13       n/a   
    Max Ever Used Since Boot          n/a           n/a          13       n/a   
    Free                              n/a           n/a          17       n/a   
    Reuse Requests                                                              
      Succeeded                       n/a           n/a           0       n/a   
      Failed                          n/a           n/a           0       n/a   
 
  Object Manager Spinlock Contention  n/a           n/a         n/a       0.0 %
 
  Object Spinlock Contention          n/a           n/a         n/a       0.0 %
 
  Index Spinlock Contention           n/a           n/a         n/a       0.0 %
 
  Index Hash Spinlock Contention      n/a           n/a         n/a       0.0 %
 
  Partition Spinlock Contention       n/a           n/a         n/a       0.0 %
 
  Partition Hash Spinlock Contention  n/a           n/a         n/a       0.0 %
 
=============================================================================== 
 
Lock Management
---------------
 
  Lock Summary                    per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Lock Requests             22926.4          55.8     6877905       n/a   
  Avg Lock Contention                 7.1           0.0        2144       0.0 %
  Cluster Locks Retained              0.0           0.0           0       0.0 %
  Deadlock Percentage                 0.0           0.0           0       0.0 %
 
  Lock Detail                     per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
 
  Table Lock Hashtable
    Lookups                        4875.6          11.9     1462690       n/a   
    Avg Chain Length                  n/a           n/a     0.07870       n/a   
    Spinlock Contention               n/a           n/a         n/a       0.0 %
 
  Exclusive Table
    Granted                          53.6           0.1       16093     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total EX-Table Requests            53.6           0.1       16093       0.2 %
 
  Shared Table
    Granted                           0.2           0.0          55     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total SH-Table Requests             0.2           0.0          55       0.0 %
 
  Exclusive Intent
    Granted                         538.4           1.3      161527     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total EX-Intent Requests          538.4           1.3      161527       2.3 %
 
  Shared Intent
    Granted                        3794.9           9.2     1138470     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total SH-Intent Requests         3794.9           9.2     1138470      16.6 %
 
  Page & Row Lock HashTable
    Lookups                       12424.9          30.2     3727483       n/a   
    Avg Chain Length                  n/a           n/a     0.00675       n/a   
    Spinlock Contention               n/a           n/a         n/a       0.0 %
 
  Exclusive Page
    Granted                           3.4           0.0        1025     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total EX-Page Requests              3.4           0.0        1025       0.0 %
 
  Update Page
    Total UP-Page Requests            0.0           0.0           0       n/a   
 
  Shared Page
    Granted                        4052.7           9.9     1215809     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total SH-Page Requests           4052.7           9.9     1215809      17.7 %
 
 
  Exclusive Row
    Granted                         850.7           2.1      255213      99.4 %
    Waited                            5.1           0.0        1543       0.6 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total EX-Row Requests             855.9           2.1      256756       3.7 %
 
  Update Row
    Granted                         501.3           1.2      150375     100.0 %
    Waited                            0.2           0.0          59       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total UP-Row Requests             501.4           1.2      150434       2.2 %
 
  Shared Row
    Granted                        5968.7          14.5     1790612     100.0 %
    Waited                            1.5           0.0         446       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total SH-Row Requests            5970.2          14.5     1791058      26.0 %
 
 
  Next-Key
    Granted                           0.0           0.0           0       0.0 %
    Waited                            0.0           0.0           8     100.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Next-Key Requests             0.0           0.0           8       0.0 %
 
 
  Address Lock Hashtable
    Lookups                        7155.8          17.4     2146753       n/a   
    Avg Chain Length                  n/a           n/a     0.00021       n/a   
    Spinlock Contention               n/a           n/a         n/a       0.0 %
 
  Exclusive Address
    Granted                         103.2           0.3       30950     100.0 %
    Waited                            0.0           0.0           4       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total EX-Address Requests         103.2           0.3       30954       0.5 %
 
  Shared Address
    Granted                        7052.1          17.2     2115632     100.0 %
    Waited                            0.3           0.0          84       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total SH-Address Requests        7052.4          17.2     2115716      30.8 %
 
 
  Last Page Locks on Heaps
    Granted                        2140.6           5.2      642166     100.0 %
    Waited                            0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Last Pg Locks              2140.6           5.2      642166     100.0 %
 
 
  Deadlocks by Lock Type          per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Deadlocks                     0.0           0.0           0       n/a   
 
 
 
  Deadlock Detection
    Deadlock Searches                 0.0           0.0           0       n/a   
 
 
  Lock Promotions
    Ex-Page to Ex-Table               0.0           0.0           0       0.0 %
    Sh-Page to Sh-Table               0.0           0.0           0       0.0 %
    Ex-Row to Ex-Table                0.0           0.0           0       0.0 %
    Sh-Row to Sh-Table                0.0           0.0          14     100.0 %
    Sh-Next-Key to Sh-Table           0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
  Total Lock Promotions               0.0           0.0          14             
 
 
  Lock Timeouts by Lock Type      per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total Timeouts                      0.0           0.0           0       n/a   
 
  Cluster Lock Summary            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
 
  Physical Locks Summary          per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
No physical locks are acquired
 
 
  Logical Locks Summary          per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
 
  Object Locks Summary            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
 
 
=============================================================================== 
 
Data Cache Management
---------------------
 
  Cache Statistics Summary (All Caches)
  -------------------------------------
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ----------
 
    Cache Search Summary
      Total Cache Hits           165229.7         402.2    49568915      99.4 %
      Total Cache Misses            961.9           2.3      288560       0.6 %
  -------------------------  ------------  ------------  ----------
    Total Cache Searches         166191.6         404.6    49857475             
 
    Cache Turnover
      Buffers Grabbed              7024.7          17.1     2107411       n/a   
      Buffers Grabbed Dirty           0.0           0.0           0       0.0 %
 
    Cache Strategy Summary
      Cached (LRU) Buffers       162315.0         395.1    48694509      99.2 %
      Discarded (MRU) Buffers      1314.4           3.2      394310       0.8 %
 
    Large I/O Usage
      Large I/Os Performed         3320.0           8.1      995986      98.2 %
 
      Large I/Os Denied due to                                                  
        Pool < Prefetch Size         50.5           0.1       15140       1.5 %
        Pages Requested                                                         
        Reside in Another                                                       
        Buffer Pool                  12.0           0.0        3604       0.4 %
  -------------------------  ------------  ------------  ----------
    Total Large I/O Requests       3382.4           8.2     1014730             
 
    Large I/O Effectiveness
      Pages by Lrg I/O Cached     25229.5          61.4     7568852       n/a   
      Pages by Lrg I/O Used        3872.6           9.4     1161772      15.3 %
 
    Asynchronous Prefetch Activity
      APFs Issued                  2185.2           5.3      655548       7.3 %
      APFs Denied Due To                                                        
        APF I/O Overloads             0.0           0.0           0       0.0 %
        APF Limit Overloads           0.0           0.0           0       0.0 %
        APF Reused Overloads         13.7           0.0        4114       0.0 %
      APF Buffers Found in Cache                                                
        With Spinlock Held            1.7           0.0         512       0.0 %
        W/o Spinlock Held         27727.7          67.5     8318297      92.6 %
  -------------------------  ------------  ------------  ----------
    Total APFs Requested          29928.2          72.9     8978471             
 
    Other Asynchronous Prefetch Statistics
      APFs Used                    2171.6           5.3      651465       n/a   
      APF Waits for I/O             282.8           0.7       84835       n/a   
      APF Discards                    0.0           0.0           0       n/a   
 
    Dirty Read Behavior
      Page Requests                  12.9           0.0        3870       n/a   
 
------------------------------------------------------------------------------- 
  Cache: default data cache
                                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Spinlock Contention               n/a           n/a         n/a       3.3 %
 
    Utilization                       n/a           n/a         n/a     100.0 %
 
    Cache Searches
      Cache Hits                 165229.7         402.2    49568915      99.4 %
         Found in Wash               35.7           0.1       10703       0.0 %
      Cache Misses                  961.9           2.3      288560       0.6 %
  -------------------------  ------------  ------------  ----------
    Total Cache Searches         166191.6         404.6    49857475
 
    Pool Turnover
      2  Kb Pool
          LRU Buffer Grab          3704.8           9.0     1111425      52.7 %
            Grabbed Locked Buffer     0.0           0.0           0       0.0 %
            Grabbed Dirty             0.0           0.0           0       0.0 %
      4  Kb Pool
          LRU Buffer Grab           221.7           0.5       66506       3.2 %
            Grabbed Locked Buffer     0.0           0.0           0       0.0 %
            Grabbed Dirty             0.0           0.0           0       0.0 %
      16 Kb Pool
          LRU Buffer Grab          3098.3           7.5      929480      44.1 %
            Grabbed Locked Buffer     0.0           0.0           0       0.0 %
            Grabbed Dirty             0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
    Total Cache Turnover           7024.7          17.1     2107411
 
    Cluster Cache Behavior
      No physical locks are acquired on buffers in this cache
 
    Buffer Wash Behavior
      Buffers Passed Clean         2828.9           6.9      848673      99.3 %
      Buffers Already in I/O          0.0           0.0           5       0.0 %
      Buffers Washed Dirty           19.2           0.0        5758       0.7 %
 
    Cache Strategy
      Cached (LRU) Buffers       162315.0         395.1    48694509      99.2 %
      Discarded (MRU) Buffers      1314.4           3.2      394310       0.8 %
 
    Large I/O Usage
      Large I/Os Performed         3320.0           8.1      995986      98.2 %
 
      Large I/Os Denied due to
        Pool < Prefetch Size         50.5           0.1       15140       1.5 %
        Pages Requested
        Reside in Another
        Buffer Pool                  12.0           0.0        3604       0.4 %
  -------------------------  ------------  ------------  ----------
    Total Large I/O Requests       3382.4           8.2     1014730
 
    Large I/O Detail
     4   Kb Pool
        Pages Cached                443.4           1.1      133012       n/a
        Pages Used                  443.4           1.1      133013     100.0 %
     16  Kb Pool
        Pages Cached              24786.1          60.3     7435840       n/a
        Pages Used                 3429.2           8.3     1028759      13.8 %
 
    Dirty Read Behavior
	  Page Requests              12.9           0.0        3870       n/a
 
    Tuning Recommendations for Data cache : default data cache
    -------------------------------------                                       
    - Consider using 'relaxed LRU replacement policy'
      for this cache.
 
=============================================================================== 
 
Procedure Cache Management        per sec      per xact       count  % of total
---------------------------  ------------  ------------  ----------  ---------- 
  Procedure Requests               1342.5           3.3      402745       n/a   
  Procedure Reads from Disk           0.1           0.0          29       0.0 %
  Procedure Writes to Disk            0.0           0.0           0       0.0 %
  Procedure Removals                  4.2           0.0        1270       n/a   
  Procedure Recompilations            1.1           0.0         333       n/a   
 
  Recompilations Requests:
    Execution Phase                   1.1           0.0         333     100.0 %
    Compilation Phase                 0.0           0.0           0       0.0 %
    Execute Cursor Execution          0.0           0.0           0       0.0 %
    Redefinition Phase                0.0           0.0           0       0.0 %
 
  Recompilation Reasons:
    Table Missing                     1.1           0.0         332       n/a   
    Temporary Table Missing           1.1           0.0         332       n/a   
    Schema Change                     0.0           0.0           1       n/a   
    Index Change                      0.0           0.0           0       n/a   
    Isolation Level Change            0.0           0.0           0       n/a   
    Permissions Change                0.0           0.0           0       n/a   
    Cursor Permissions Change         0.0           0.0           0       n/a   
 
  SQL Statement Cache:
    Statements Cached                 2.0           0.0         604       n/a   
    Statements Found in Cache        25.6           0.1        7671       n/a   
    Statements Not Found              2.0           0.0         604       n/a   
    Statements Dropped                2.0           0.0         614       n/a   
    Statements Restored               1.0           0.0         304       n/a   
    Statements Not Cached             0.0           0.0           0       n/a   
 
 
=============================================================================== 
 
Memory Management                 per sec      per xact       count  % of total
---------------------------  ------------  ------------  ----------  ---------- 
  Pages Allocated                    51.0           0.1       15294       n/a   
  Pages Released                     51.0           0.1       15294       n/a   
 
=============================================================================== 
 
Recovery Management
-------------------
 
  Checkpoints                     per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    # of Normal Checkpoints           0.1           0.0          16     100.0 %
    # of Free Checkpoints             0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------             
  Total Checkpoints                   0.1           0.0          16             
 
  Avg Time per Normal Chkpt       0.75000 seconds                               
 
=============================================================================== 
 
Disk I/O Management
-------------------
 
  Max Outstanding I/Os            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Server                            n/a           n/a           0       n/a   
    Engine 0                          n/a           n/a         603       n/a   
    Engine 1                          n/a           n/a         532       n/a   
    Engine 2                          n/a           n/a         683       n/a   
    Engine 3                          n/a           n/a         721       n/a   
    Engine 4                          n/a           n/a         676       n/a   
 
 
  I/Os Delayed by
    Disk I/O Structures               n/a           n/a           0       n/a   
    Server Config Limit               n/a           n/a           0       n/a   
    Engine Config Limit               n/a           n/a           0       n/a   
    Operating System Limit            n/a           n/a           0       n/a   
 
 
  Total Requested Disk I/Os        3508.6           8.5     1052583             
 
  Completed Disk I/O's
    Asynchronous I/O's
      Engine 0                      818.4           2.0      245532      23.3 %
      Engine 1                      639.5           1.6      191864      18.2 %
      Engine 2                      764.0           1.9      229189      21.8 %
      Engine 3                      499.7           1.2      149916      14.2 %
      Engine 4                      787.0           1.9      236107      22.4 %
    Synchronous I/O's
      Total Completed I/Os            0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------             
  Total Completed I/Os             3508.7           8.5     1052608             
 
 
  Device Activity Detail
  ----------------------
 
  Device:                                                                       
    /dev/raudit_dev1                                                            
    audit_dev1                    per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.0           0.0           0       0.0 %
      Non-APF                         0.0           0.0           0       0.0 %
    Writes                            2.6           0.0         782     100.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          2.6           0.0         782       0.1 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/raudit_dev2                                                            
    audit_dev2                    per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/raudit_dev3                                                            
    audit_dev3                    per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata01                                                                
    data01                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                            52.1           0.1       15621      36.3 %
      Non-APF                        40.4           0.1       12110      28.1 %
    Writes                           51.1           0.1       15317      35.6 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        143.5           0.3       43048       4.1 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata02                                                                
    data02                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                            16.2           0.0        4856      33.7 %
      Non-APF                        15.5           0.0        4636      32.2 %
    Writes                           16.4           0.0        4915      34.1 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                         48.0           0.1       14407       1.4 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata03                                                                
    data03                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                            67.4           0.2       20215      54.9 %
      Non-APF                        35.2           0.1       10546      28.6 %
    Writes                           20.2           0.0        6056      16.4 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        122.7           0.3       36817       3.5 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata04                                                                
    data04                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                           279.3           0.7       83775      61.5 %
      Non-APF                       140.5           0.3       42159      31.0 %
    Writes                           34.3           0.1       10276       7.5 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        454.0           1.1      136210      12.9 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata05                                                                
    data05                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                           324.6           0.8       97391      68.4 %
      Non-APF                       133.4           0.3       40015      28.1 %
    Writes                           16.4           0.0        4923       3.5 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        474.4           1.2      142329      13.5 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata06                                                                
    data06                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                           430.7           1.0      129214      78.0 %
      Non-APF                       113.0           0.3       33896      20.5 %
    Writes                            8.6           0.0        2574       1.6 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        552.3           1.3      165684      15.7 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata07                                                                
    data07                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                           435.2           1.1      130571      83.1 %
      Non-APF                        74.1           0.2       22231      14.2 %
    Writes                           14.2           0.0        4267       2.7 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        523.6           1.3      157069      14.9 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata08                                                                
    data08                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                           577.9           1.4      173383      70.7 %
      Non-APF                       128.9           0.3       38664      15.8 %
    Writes                          111.1           0.3       33336      13.6 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        817.9           2.0      245383      23.3 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdata09                                                                
    data09                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdbccdev                                                               
    dbccdev                       per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rdbcclog                                                               
    dbcclog                       per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rlogg01                                                                
    log01                         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.0           0.0           0       0.0 %
      Non-APF                         0.0           0.0           0       0.0 %
    Writes                            4.1           0.0        1237     100.0 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          4.1           0.0        1237       0.1 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rlogg02                                                                
    log02                         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rlogg03                                                                
    log03                         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rlogg04                                                                
    log04                         per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rmaster                                                                
    master                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.2           0.0          71      22.0 %
      Non-APF                         0.0           0.0           8       2.5 %
    Writes                            0.8           0.0         244      75.5 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          1.1           0.0         323       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rrecov_data01                                                          
    recov_data01                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rrecov_data02                                                          
    recov_data02                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rrecov_log01                                                           
    recov_log01                   per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rsysprocsdev                                                           
    sysprocsdev                   per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rsystemdbdev                                                           
    systemdbdev                   per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp01                                                                
    tempdbdev                     per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.0           0.0           0       0.0 %
      Non-APF                         0.0           0.0          14       5.3 %
    Writes                            0.8           0.0         249      94.7 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.9           0.0         263       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp02                                                                
    tempdbdev2                    per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp03                                                                
    temp03                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.6           0.0         170       4.6 %
      Non-APF                         0.2           0.0          55       1.5 %
    Writes                           11.5           0.0        3464      93.9 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                         12.3           0.0        3689       0.4 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp04                                                                
    temp04                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp05                                                                
    temp05                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.0           0.0           0       0.0 %
      Non-APF                         0.0           0.0          12       0.5 %
    Writes                            8.0           0.0        2385      99.5 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          8.0           0.0        2397       0.2 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/rtemp06                                                                
    temp06                        per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data01                                                         
    unmirr_data01                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data02                                                         
    unmirr_data02                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data03                                                         
    unmirr_data03                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data04                                                         
    unmirr_data04                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data05                                                         
    unmirr_data05                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data06                                                         
    unmirr_data06                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_data07                                                         
    unmirr_data07                 per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_log01                                                          
    unmirr_log01                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_log02                                                          
    unmirr_log02                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_log03                                                          
    unmirr_log03                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       n/a   
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                          0.0           0.0           0       0.0 %
 
 
  ----------------------------------------------------------------------------- 
 
  Device:                                                                       
    /dev/runmirr_log04                                                          
    unmirr_log04                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Reads                                                                       
      APF                             0.9           0.0         282       0.3 %
      Non-APF                         0.1           0.0          21       0.0 %
    Writes                          342.1           0.8      102636      99.7 %
  -------------------------  ------------  ------------  ----------  ---------- 
  Total I/Os                        343.1           0.8      102939       9.8 %
 
 
  ----------------------------------------------------------------------------- 
 
 
 
=============================================================================== 
 
Network I/O Management
----------------------
 
  Total Network I/O Requests       2598.8           6.3      779639       n/a   
    Network I/Os Delayed              0.0           0.0           0       0.0 %
 
 
  Total TDS Packets Received      per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Engine 0                        331.4           0.8       99419      19.9 %
    Engine 1                        382.7           0.9      114797      23.0 %
    Engine 2                        315.6           0.8       94665      19.0 %
    Engine 3                        321.7           0.8       96502      19.3 %
    Engine 4                        313.8           0.8       94129      18.8 %
  -------------------------  ------------  ------------  ----------             
  Total TDS Packets Rec'd          1665.0           4.1      499512             
 
 
  Total Bytes Received            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Engine 0                      54883.6         133.6    16465085      19.1 %
    Engine 1                      70933.4         172.7    21280018      24.6 %
    Engine 2                      54675.8         133.1    16402729      19.0 %
    Engine 3                      54293.1         132.2    16287931      18.8 %
    Engine 4                      53312.3         129.8    15993686      18.5 %
  -------------------------  ------------  ------------  ----------             
  Total Bytes Rec'd              288098.2         701.3    86429449             
 
 
   Avg Bytes Rec'd per Packet          n/a           n/a         173       n/a  
 
  ----------------------------------------------------------------------------- 
 
  Total TDS Packets Sent          per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Engine 0                        334.7           0.8      100419      19.8 %
    Engine 1                        415.8           1.0      124736      24.6 %
    Engine 2                        307.5           0.7       92238      18.2 %
    Engine 3                        304.8           0.7       91426      18.1 %
    Engine 4                        325.6           0.8       97685      19.3 %
  -------------------------  ------------  ------------  ----------             
  Total TDS Packets Sent           1688.3           4.1      506504             
 
 
  Total Bytes Sent                per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ---------- 
    Engine 0                      45607.5         111.0    13682263      11.3 %
    Engine 1                     156776.1         381.6    47032841      38.9 %
    Engine 2                      61190.3         149.0    18357096      15.2 %
    Engine 3                      40027.3          97.4    12008187       9.9 %
    Engine 4                      99572.4         242.4    29871724      24.7 %
  -------------------------  ------------  ------------  ----------             
  Total Bytes Sent               403173.7         981.5   120952111             
 
 
  Avg Bytes Sent per Packet           n/a           n/a         238       n/a   
 
===============================================================================
 
Replication Agent
-----------------
 
Replication Agent:  micose
Replication Server: MICOS_RS
 
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ----------
Log Scan Summary
    Log Records Scanned               n/a           n/a     1067314       n/a
    Log Records Processed             n/a           n/a      348720       n/a
    Number of Log Scans               n/a           n/a       58886       n/a
    Amount of Time for Log Scans (ms) n/a           n/a         771       n/a
    Longest Time for Log Scan (ms)    n/a           n/a           0       n/a
    Average Time per Log Scan (ms)    n/a           n/a         0.0       n/a
 
Log Scan Activity
    Updates                           n/a           n/a       83466       n/a
    Inserts                           n/a           n/a       58830       n/a
    Deletes                           n/a           n/a           0       n/a
    Store Procedures                  n/a           n/a           1       n/a
    DDL Log Records                   n/a           n/a           0       n/a
    Writetext Log Records             n/a           n/a           0       n/a
    Text/Image Log Records            n/a           n/a        9746       n/a
    CLRs                              n/a           n/a           0       n/a
    Checkpoints Processed             n/a           n/a           5       n/a
    SQL Statements Processed          n/a           n/a           0       n/a
 
Transaction Activity
    Opened                            n/a           n/a       99959       n/a
    Commited                          n/a           n/a       99956       n/a
    Aborted                           n/a           n/a           2       n/a
    Prepared                          n/a           n/a           2       n/a
    Delayed Commit                    n/a           n/a           0       n/a
    Maintenance User                  n/a           n/a           0       n/a
 
Log Extension Wait
    Count                             n/a           n/a       37157       n/a
    Amount of time (ms)               n/a           n/a      158139       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         4.3       n/a
 
Schema Cache
 Usage
    Max Ever Used                     n/a           n/a          13       n/a
    Schemas reused                    n/a           n/a       13843       n/a
 Forward Schema Lookups
    Count                             n/a           n/a           0       n/a
    Total Wait (ms)                   n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         0.0       n/a
 Backward Schema Lookups
    Count                             n/a           n/a           0       n/a
    Total Wait (ms)                   n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         0.0       n/a
 
Truncation Point Movement
    Moved                             n/a           n/a          70       n/a
    Gotten from RS                    n/a           n/a          70       n/a
 
Connections to Replication Server
    Success                           n/a           n/a           0       n/a
    Failed                            n/a           n/a           0       n/a
 
Network Packet Information
    Packets Sent                      n/a           n/a      151840       n/a
    Full Packets Sent                 n/a           n/a       95308       n/a
    Largest Packet                    n/a           n/a           0       n/a
    Amount of Bytes Sent              n/a           n/a   233827563       n/a
    Average Packet                    n/a           n/a      1540.0       n/a
 
I/O Wait from RS
    Count                             n/a           n/a      265218       n/a
    Amount of Time (ms)               n/a           n/a      113315       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Wait (ms)                 n/a           n/a         0.4       n/a
 
--------------------------------------------------------------------------------
Replication Agent:  micose_for_Recovery
Replication Server: MICOS_RS
 
                                  per sec      per xact       count  % of total
                             ------------  ------------  ----------  ----------
Log Scan Summary
    Log Records Scanned               n/a           n/a           0       n/a
    Log Records Processed             n/a           n/a           0       n/a
    Number of Log Scans               n/a           n/a           0       n/a
    Amount of Time for Log Scans (ms) n/a           n/a           0       n/a
    Longest Time for Log Scan (ms)    n/a           n/a           0       n/a
    Average Time per Log Scan (ms)    n/a           n/a         0.0       n/a
 
Log Scan Activity
    Updates                           n/a           n/a           0       n/a
    Inserts                           n/a           n/a           0       n/a
    Deletes                           n/a           n/a           0       n/a
    Store Procedures                  n/a           n/a           0       n/a
    DDL Log Records                   n/a           n/a           0       n/a
    Writetext Log Records             n/a           n/a           0       n/a
    Text/Image Log Records            n/a           n/a           0       n/a
    CLRs                              n/a           n/a           0       n/a
    Checkpoints Processed             n/a           n/a           0       n/a
    SQL Statements Processed          n/a           n/a           0       n/a
 
Transaction Activity
    Opened                            n/a           n/a           0       n/a
    Commited                          n/a           n/a           0       n/a
    Aborted                           n/a           n/a           0       n/a
    Prepared                          n/a           n/a           0       n/a
    Delayed Commit                    n/a           n/a           0       n/a
    Maintenance User                  n/a           n/a           0       n/a
 
Log Extension Wait
    Count                             n/a           n/a           0       n/a
    Amount of time (ms)               n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         0.0       n/a
 
Schema Cache
 Usage
    Max Ever Used                     n/a           n/a           0       n/a
    Schemas reused                    n/a           n/a           0       n/a
 Forward Schema Lookups
    Count                             n/a           n/a           0       n/a
    Total Wait (ms)                   n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         0.0       n/a
 Backward Schema Lookups
    Count                             n/a           n/a           0       n/a
    Total Wait (ms)                   n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Time (ms)                 n/a           n/a         0.0       n/a
 
Truncation Point Movement
    Moved                             n/a           n/a           0       n/a
    Gotten from RS                    n/a           n/a           0       n/a
 
Connections to Replication Server
    Success                           n/a           n/a           0       n/a
    Failed                            n/a           n/a           0       n/a
 
Network Packet Information
    Packets Sent                      n/a           n/a           0       n/a
    Full Packets Sent                 n/a           n/a           0       n/a
    Largest Packet                    n/a           n/a           0       n/a
    Amount of Bytes Sent              n/a           n/a           0       n/a
    Average Packet                    n/a           n/a         0.0       n/a
 
I/O Wait from RS
    Count                             n/a           n/a           0       n/a
    Amount of Time (ms)               n/a           n/a           0       n/a
    Longest Wait (ms)                 n/a           n/a           0       n/a
    Average Wait (ms)                 n/a           n/a         0.0       n/a
 
--------------------------------------------------------------------------------
=============================== End of Report =================================
===============================================================================