Sample output
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
--------------------- ------------ ------------ ---------- ----------
Any Logging Mode DMLs
by End Transaction 1.6 1.1 189 1.0 %
by Change of Database 0.0 0.0 4 0.0 %
by Unpin 0.0 0.0 2 0.0 %
by Log markers 0.0 0.0 0 0.0 %
Fully Logged DMLs
by Full ULC 145.5 98.6 17458 95.9 %
by Single Log Record 4.5 3.1 544 3.0 %
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 151.6 102.8 18197
ULC Flushes Skipped per sec per xact count % of total
--------------------- ------------ ------------ ---------- ----------
Fully Logged DMLs
by ULC Discards 0.2 0.1 21 100 %
Minimally Logged DMLs
by ULC Discards 0.0 0.0 0 0.0 %
--------------------- ------------ ------------ ----------
Total ULC Flushes Skips 0.2 0.1 21
ULC Log Records per sec per xact count % of total
--------------------- ------------ ------------ ---------- ----------
Fully Logged DMLs 6662.3 4516.8 799476 100.0
Minimally Logged DMLs 0.0 0.0 0 0.0
--------------------- ------------ ------------ ----------
Total ULC Log Records 6662.3 4516.8 799476
Max ULC Size During Sample
--------------------------
Fully Logged DMLs n/a n/a 16384 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 13727.0 9306.4 1647239 100.0 %
Waited 0.0 0.0 0 0.0 %
--------------------- ------------ ------------ ----------
Total ULC Semaphore Req 13727.0 9306.4 1647239
Log Semaphore Requests
Granted 184.0 124.7 22076 100.0 %
Local Waited 0.0 0.0 0 0.0 %
Global Waited 0.0 0.0 0 0.0 %
--------------------- ------------ ------------ ----------
Total Log Semaphore Req 184.0 124.7 22076
Transaction Log Writes 167.5 113.6 20102 n/a
Transaction Log Alloc 167.4 113.5 20092 n/a
Avg # Writes per Log Page n/a n/a 1.00050 n/a
Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider increasing the 'user log cache size'
configuration parameter.