Skip to Content
0
Former Member
Mar 20, 2009 at 11:51 AM

Help understanding Analyzer output

94 Views

Can anyone help on understanding the db analyzer output attached ?

The MaxCPUs message is clear 😊 I'd like to understand there are some issues that can be fixed.

Thank you !!

===== #0          at 2009-03-20 11:53:42
*  I  Database Analyzer configuration file dbanalyzer77.cfg, version 7.7.06 Build 009-123-202-944
*  I  Number of logical CPUs: 8, physical CPUs: 2, processor type: x86_64
*  I  Configuration: number of CPUs (MAXCPU): 6, max user tasks: 1020
*  I  'MaxCPUs' (6) exceeds number of physical CPUs (2)!
*  I  Physical memory 16088 MB, virtual memory 16386 MB, memory allocated from instance: 5292 MB
*  I  Operating system: Linux 2.6.23.1-42.fc8 #1 SMP Tue Oct 30 13:18:33 EDT 2007
*  I  Kernel version: Kernel    7.7.06   Build 009-123-202-944
*  I  Instance ECF3 (fatboy) is up since  23:59:58
*  I  Number of data volumes: 2
*  I  SQL commands executed: 174857156
* W1  Number of tables where update statistics is required: 1
* W1  Owner: DBA, table: SYSUPGRADEHISTORY
* W1  Lock list escalations: 12
*  I  Size of data cache 4094.43 MB, used data size in instance 1364.88 MB
* W3  Log automatic overwrite is set to 'on' !

===== #1          at 2009-03-20 11:54:42
*  I  SQL commands executed: 2148, avg. 39.31 per second
*  I  Active User tasks found in state 'Enter ExclLock': 2
*  I  Active User tasks found in state 'Running': 2
*  I  Active User tasks found in state 'Connect close': 1
*  I  Runnable User tasks found in state 'Enter ExclLock': 2
*  I  UKT11: commands: 25316973, dispatches: 109499812, user task 785 is running, 1 tasks are waiting for CPU
*  I  UKT10: commands: 18359305, dispatches: 107190388, user task 617 is running, 1 tasks are waiting for CPU
*  I  UKT10: user task 620 is waiting for CPU in state 'Enter ExclLock'
*  I  UKT11: user task 788 is waiting for CPU in state 'Enter ExclLock'
* W2  74 primary key range accesses, selectivity 0.33%: 31873 rows read, 106 rows qualified
*  I  CPU utilization: instance ECF3: 101.64% (usr: 101.64%, sys: 0%) host: 104.92% (usr: 103.28%, sys: 1.64%, idle: 691.8%)

===== #2          at 2009-03-20 11:55:43
*  I  SQL commands executed: 2527, avg. 46.28 per second
*  I  Active User tasks found in state 'Running': 1
*  I  Active User tasks found in state 'Connect close': 2
*  I  Active User tasks found in state 'ExclLock Yield': 1
*  I  Runnable User tasks found in state 'ExclLock Yield': 1
*  I  UKT11: commands: 25318126, dispatches: 109644955, user task 784 is running, 1 tasks are waiting for CPU
*  I  UKT11: user task 790 is waiting for CPU in state 'ExclLock Yield'
* W3  27 primary key range accesses, selectivity 0.17%: 16227 rows read, 27 rows qualified
*  I  DATA50: collision rate 3.29%, 436543 collisions, 1 waits (0%), 13256056 accesses on region 54
* W3  User task 1130 blocked in state 'Connect close' since 60s, application pid 1510
*  I  CPU utilization: instance ECF3: 113.33% (usr: 113.33%, sys: 0%) host: 115% (usr: 115%, sys: 0%, idle: 691.67%)

===== #3          at 2009-03-20 11:56:43
*  I  SQL commands executed: 1379, avg. 26.7 per second
* W3  20 primary key range accesses, selectivity 0.20%: 10148 rows read, 20 rows qualified
*  I  CPU utilization: instance ECF3: 47.54% (usr: 47.54%, sys: 0%) host: 50.82% (usr: 49.18%, sys: 1.64%, idle: 742.62%)

===== #4          at 2009-03-20 11:57:44
*  I  SQL commands executed: 6910, avg. 119.33 per second
*  I  Active User tasks found in state 'Connect close': 1
* W2  240 table scans, selectivity 0.64%: 196678 rows read, 1267 rows qualified
* W3  57 primary key range accesses, selectivity 0.28%: 26740 rows read, 76 rows qualified
* W2  330 index accesses, selectivity 1.54%: 36056 rows read, 557 rows qualified
*  I  CPU utilization: instance ECF3: 45% (usr: 45%, sys: 0%) host: 46.67% (usr: 46.67%, sys: 0%, idle: 760%)

===== #5          at 2009-03-20 11:58:44
*  I  SQL commands executed: 1522, avg. 29.05 per second
*  I  Active User tasks found in state 'Running': 1
* W3  56 primary key range accesses, selectivity 0.20%: 27880 rows read, 56 rows qualified
*  I  CPU utilization: instance ECF3: 73.77% (usr: 73.77%, sys: 0%) host: 78.69% (usr: 77.05%, sys: 1.64%, idle: 716.39%)

===== #6          at 2009-03-20 11:59:45
*  I  SQL commands executed: 1557, avg. 30.12 per second
*  I  Active User tasks found in state 'Running': 1
* W3  38 primary key range accesses, selectivity 0.16%: 23366 rows read, 38 rows qualified
*  I  CPU utilization: instance ECF3: 51.67% (usr: 51.67%, sys: 0%) host: 55% (usr: 53.33%, sys: 1.67%, idle: 755%)

===== #7          at 2009-03-20 12:00:45
*  I  SQL commands executed: 5712, avg. 97.74 per second
*  I  Active User tasks found in state 'Running': 1
* W3  47 primary key range accesses, selectivity 0.16%: 28046 rows read, 46 rows qualified
*  I  CPU utilization: instance ECF3: 73.77% (usr: 73.77%, sys: 0%) host: 75.41% (usr: 75.41%, sys: 0%, idle: 718.03%)

===== #8          at 2009-03-20 12:01:46
*  I  SQL commands executed: 1565, avg. 30.25 per second
* W3  42 primary key range accesses, selectivity 0.17%: 24666 rows read, 42 rows qualified
*  I  DATA50: collision rate 4.43%, 444353 collisions, no waits, 10038277 accesses on region 54
*  I  CPU utilization: instance ECF3: 86.67% (usr: 86.67%, sys: 0%) host: 91.67% (usr: 90%, sys: 1.67%, idle: 716.67%)

===== #9          at 2009-03-20 12:02:46
*  I  SQL commands executed: 2111, avg. 38.7 per second
*  I  Active User tasks found in state 'Running': 1
*  I  Active User tasks found in state 'Connect close': 1
* W3  53 primary key range accesses, selectivity 0.16%: 33101 rows read, 53 rows qualified
*  I  CPU utilization: instance ECF3: 86.89% (usr: 85.25%, sys: 1.64%) host: 86.89% (usr: 86.89%, sys: 0%, idle: 706.56%)

===== #10         at 2009-03-20 12:03:47
*  I  SQL commands executed: 1293, avg. 25.72 per second
* W3  43 primary key range accesses, selectivity 0.17%: 24667 rows read, 43 rows qualified
*  I  CPU utilization: instance ECF3: 65% (usr: 65%, sys: 0%) host: 70% (usr: 68.33%, sys: 1.67%, idle: 736.67%)