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%)