2008-6-20 21:39
sujinlei
数据库cpu引擎一直处于100%附近，求助
以下是sp_sysmon 十分钟的记录
求高手分析，主要原因在那，谢谢
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.3/EBF 13329 ESD#7/P/HP90
Server Name: SXJHWG
Run Date: Jun 20, 2008
Statistics Cleared at: Jun 20, 2008 21:06:45
Statistics Sampled at: Jun 20, 2008 21:17:10
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 1000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 99.9 % 0.0 % 0.1 %
Engine 1 99.8 % 0.0 % 0.2 %
Engine 2 99.9 % 0.0 % 0.1 %
Engine 3 99.9 % 0.0 % 0.1 %
Engine 4 99.9 % 0.0 % 0.1 %
Engine 5 99.7 % 0.0 % 0.3 %
Engine 6 99.9 % 0.0 % 0.1 %
Engine 7 99.6 % 0.0 % 0.4 %
Engine 8 99.9 % 0.0 % 0.1 %
------------------------ -------- -------- --------
Summary Total 898.4 % 0.0 % 1.6 %
Average 99.8 % 0.0 % 0.2 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 15 9.2 %
Engine 1 0.0 0.0 28 17.2 %
Engine 2 0.0 0.0 20 12.3 %
Engine 3 0.0 0.0 1 0.6 %
Engine 4 0.0 0.0 5 3.1 %
Engine 5 0.0 0.0 20 12.3 %
Engine 6 0.0 0.0 10 6.1 %
Engine 7 0.1 0.0 60 36.8 %
Engine 8 0.0 0.0 4 2.5 %
------------------------- ------------ ------------ ----------
Total CPU Yields 0.3 0.0 163
Network Checks
Non-Blocking 924.6 9.7 554763 100.0 %
Blocking 0.3 0.0 163 0.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 924.9 9.7 554926
Avg Net I/Os per Check n/a n/a 0.19234 n/a
Disk I/O Checks
Total Disk I/O Checks 2980.5 31.2 1788299 n/a
Checks Returning I/O 0.0 0.0 0 0.0 %
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider bringing more engines online
===============================================================================
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.2 0.0 140 n/a
Task Context Switches by Engine
Engine 0 395.1 4.1 237045 11.3 %
Engine 1 259.1 2.7 155436 7.4 %
Engine 2 347.4 3.6 208442 9.9 %
Engine 3 360.4 3.8 216259 10.3 %
Engine 4 478.0 5.0 286815 13.6 %
Engine 5 500.4 5.2 300211 14.3 %
Engine 6 472.1 4.9 283237 13.5 %
Engine 7 350.4 3.7 210212 10.0 %
Engine 8 346.3 3.6 207789 9.9 %
------------------------- ------------ ------------ ----------
Total Task Switches: 3509.1 36.7 2105446
Task Context Switches Due To:
Voluntary Yields 114.5 1.2 68693 3.3 %
Cache Search Misses 2271.4 23.8 1362846 64.7 %
System Disk Writes 1.0 0.0 601 0.0 %
I/O Pacing 5.9 0.1 3553 0.2 %
Logical Lock Contention 1.0 0.0 582 0.0 %
Address Lock Contention 0.2 0.0 146 0.0 %
Latch Contention 0.2 0.0 149 0.0 %
Log Semaphore Contention 4.9 0.1 2962 0.1 %
PLC Lock Contention 0.1 0.0 72 0.0 %
Group Commit Sleeps 32.7 0.3 19615 0.9 %
Last Log Page Writes 96.7 1.0 58005 2.8 %
Modify Conflicts 5.2 0.1 3104 0.1 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 85.2 0.9 51128 2.4 %
Network Packet Sent 65.4 0.7 39228 1.9 %
Other Causes 824.6 8.6 494762 23.5 %
Tuning Recommendations for Task Management
------------------------------------------
- Consider tuning your Data Caches.
Look into the Data Cache management section for
more details on this.
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 13.2 0.1 7892 38.3 %
To Medium Priority 17.3 0.2 10368 50.3 %
To Low Priority 3.9 0.0 2334 11.3 %
------------------------- ------------ ------------ ----------
Total Priority Changes 34.3 0.4 20594
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 1.2 0.0 702 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 1.2 0.0 702
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 150.5 1.6 90324 91.3 %
Dirty 14.4 0.2 8656 8.7 %
------------ ------------ ----------
Total Washes 165.0 1.7 98980
Garbage Collections 7.6 0.1 4581 n/a
Pages Processed in GC 0.1 0.0 61 n/a
Statistics Updates 3.1 0.0 1854 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 8.0 0.1 4804 n/a
Maximum SQL Text Requested n/a n/a 1035 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 645 (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 95.6 n/a 57344 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 36.6 0.4 21958 30.3 %
APL Clustered Table 27.3 0.3 16356 22.6 %
Data Only Lock Table 56.8 0.6 34071 47.1 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 120.6 1.3 72385 92.3 %
Updates
APL Deferred 0.0 0.0 1 0.0 %
APL Direct In-place 0.0 0.0 0 0.0 %
APL Direct Cheap 0.4 0.0 237 4.5 %
APL Direct Expensive 0.5 0.0 281 5.3 %
DOL Deferred 0.0 0.0 7 0.1 %
DOL Direct 7.9 0.1 4769 90.1 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 8.8 0.1 5295 6.8 %
Data Only Locked Updates
DOL Replace 6.1 0.1 3676 77.0 %
DOL Shrink 0.5 0.0 310 6.5 %
DOL Cheap Expand 0.4 0.0 213 4.5 %
DOL Expensive Expand 0.9 0.0 519 10.9 %
DOL Expand & Forward 0.0 0.0 29 0.6 %
DOL Fwd Row Returned 0.0 0.0 29 0.6 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 8.0 0.1 4776 6.1 %
Deletes
APL Deferred 0.2 0.0 141 18.9 %
APL Direct 0.5 0.0 302 40.5 %
DOL 0.5 0.0 303 40.6 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 1.2 0.0 746 1.0 %
========================= ============ ============ ==========
Total Rows Affected 130.7 1.4 78426
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.0 0 0.0 %
by End Transaction 127.1 1.3 76233 89.5 %
by Change of Database 1.1 0.0 662 0.8 %
by Single Log Record 3.0 0.0 1814 2.1 %
by Unpin 2.3 0.0 1402 1.6 %
by Other 8.5 0.1 5077 6.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 142.0 1.5 85188
ULC Log Records 507.2 5.3 304310 n/a
Max ULC Size During Sample n/a n/a 8944 n/a
ULC Semaphore Requests
Granted 1170.1 12.2 702038 100.0 %
Waited 0.1 0.0 72 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 1170.2 12.2 702110
Log Semaphore Requests
Granted 167.4 1.8 100456 97.1 %
Waited 4.9 0.1 2962 2.9 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 172.4 1.8 103418
Transaction Log Writes 100.6 1.1 60373 n/a
Transaction Log Alloc 7.8 0.1 4690 n/a
Avg # Writes per Log Page n/a n/a 12.87271 n/a
===============================================================================
2008-6-20 21:40
sujinlei
报告后续输出
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 7 20.0 %
# of Free Checkpoints 0.0 0.0 28 80.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.1 0.0 35
Avg Time per Normal Chkpt 0.00000 seconds
Avg Time per Free Chkpt 0.03571 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 0 n/a
Engine 1 n/a n/a 0 n/a
Engine 2 n/a n/a 0 n/a
Engine 3 n/a n/a 0 n/a
Engine 4 n/a n/a 0 n/a
Engine 5 n/a n/a 0 n/a
Engine 6 n/a n/a 0 n/a
Engine 7 n/a n/a 0 n/a
Engine 8 n/a n/a 0 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 2678.0 28.0 1606821
Completed Disk I/O's
Total Completed I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Completed I/Os 0.0 0.0 0
Device Activity Detail
----------------------
Device:
/dev/vg_mng_data/rdata1
staticdb_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.6 0.0 373 17.7 %
Non-APF 2.9 0.0 1723 81.5 %
Writes 0.0 0.0 17 0.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 3.5 0.0 2113 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata10
imptradb_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 1 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata11
teltradb_dev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 1.6 0.0 951 74.5 %
Writes 0.5 0.0 326 25.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.1 0.0 1277 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata12
teltradb_dev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.6 0.0 382 87.2 %
Writes 0.1 0.0 56 12.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.7 0.0 438 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata13
teltradb_dev3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 2.0 0.0 1210 81.4 %
Writes 0.5 0.0 277 18.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.5 0.0 1487 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata14
teltradb_dev4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.4 0.0 247 89.5 %
Writes 0.0 0.0 29 10.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.5 0.0 276 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata15
teltradb_dev5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.1 0.0 54 0.8 %
Non-APF 5.3 0.1 3150 46.7 %
Writes 5.9 0.1 3543 52.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 11.2 0.1 6747 0.4 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata16
teltradb_dev6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.8 0.0 477 95.8 %
Writes 0.0 0.0 21 4.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.8 0.0 498 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata17
teltradb_dev7 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.8 0.0 482 75.9 %
Writes 0.3 0.0 153 24.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.1 0.0 635 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata18
teltradb_dev8 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.5 0.0 291 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.5 0.0 291 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata19
awsdyndb_dev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 9.5 0.1 5701 6.3 %
Non-APF 141.3 1.5 84798 93.4 %
Writes 0.5 0.0 272 0.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 151.3 1.6 90771 5.6 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata2
workdb_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 1 0.5 %
Non-APF 0.1 0.0 84 44.4 %
Writes 0.2 0.0 104 55.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.0 189 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata20
phsdb01_dev 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/vg_mng_data/rdata21
phsdb02_dev 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/vg_mng_data/rdata22
phsdb03_dev 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/vg_mng_data/rdata23
teltradb_log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 1 0.0 %
Non-APF 0.3 0.0 154 0.8 %
Writes 32.6 0.3 19552 99.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 32.8 0.3 19707 1.2 %
-----------------------------------------------------------------------------
2008-6-20 21:40
sujinlei
报告后续输出
Device:
/dev/vg_mng_data/rdata24
tempdb_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 8 1.9 %
Writes 0.7 0.0 411 98.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.7 0.0 419 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata25
timesynchdb_dev 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/vg_mng_data/rdata26
phsdb04_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.4 0.0 246 0.8 %
Non-APF 52.0 0.5 31228 99.2 %
Writes 0.0 0.0 3 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 52.5 0.5 31477 2.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata27
phsdb05_dev 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 0.0 0.0 8 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 8 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata28
phsdb06_dev 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/vg_mng_data/rdata3
telalmdb_dev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 248.3 2.6 149001 14.0 %
Non-APF 1521.5 15.9 912894 85.9 %
Writes 1.6 0.0 988 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1771.5 18.5 1062883 66.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata4
telalmdb_dev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 7.7 0.1 4624 2.9 %
Non-APF 253.2 2.6 151947 96.8 %
Writes 0.6 0.0 339 0.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 261.5 2.7 156910 9.8 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata5
awsdyndb_dev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 9.8 0.1 5860 5.4 %
Non-APF 169.5 1.8 101687 92.9 %
Writes 3.2 0.0 1928 1.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 182.5 1.9 109475 6.8 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata6
worktradb_dev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.0 143 2.3 %
Writes 10.3 0.1 6184 97.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 10.5 0.1 6327 0.4 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata7
worktradb_dev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 5 0.5 %
Writes 1.6 0.0 950 99.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.6 0.0 955 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata8
worktradb_dev3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 117.4 1.2 70417 97.4 %
Writes 3.2 0.0 1901 2.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 120.5 1.3 72318 4.5 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata9
phsdb07_dev 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/vg_mng_data/rlog1
staticdb_log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.0 39 5.6 %
Writes 1.1 0.0 663 94.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.2 0.0 702 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog2
workdb_log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 2 0.2 %
Non-APF 0.0 0.0 14 1.5 %
Writes 1.5 0.0 902 98.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.5 0.0 918 0.1 %
-----------------------------------------------------------------------------
Device:
&nbs