Sponsored Content
Full Discussion: CPU performance
Operating Systems AIX CPU performance Post 302989592 by powerAIX on Monday 16th of January 2017 04:26:16 AM
Old 01-16-2017
The db server is of 16 cores that was a typo mistake. Its has only one db instance running which finabrodb and nothing else is running on this system. The other Db psentry was also my mistake from UAT system sorry for that.

Code:
root@ABRO-DB/#lsattr -El mem0
ent_mem_cap           I/O memory entitlement in Kbytes           False
goodsize       204800 Amount of usable physical memory in Mbytes False
mem_exp_factor        Memory expansion factor                    False
size           204800 Total amount of physical memory in Mbytes  False
var_mem_weight        Variable memory capacity weight            False
root@ABRO-DB/#

For so many archive processes this need to check with dba.
the FILESYSTEMIO_OPTIONS=SETALL is not enabled. The SGA is 40Gb
I have already raise request to increase the SGA to 80Gb as memory is of 200Gb.


Moderator's Comments:
Mod Comment Please use CODE tags correctly as required by forum rules!

Last edited by RudiC; 01-16-2017 at 05:43 AM.. Reason: Changed ICODE to CODE tags.
 

9 More Discussions You Might Find Interesting

1. AIX

Performance Problem - High CPU utilization

Hello everybody. I have a problem with my AIX 5.3. Recently my unix shows a high cpu utilization with sar or topas. I need to find what I have to do to solve this problem, in fact, I don't know what is my problem. I had the same problem with another AIX 5.3 running the same... (2 Replies)
Discussion started by: wilder.mellotto
2 Replies

2. News, Links, Events and Announcements

Announcing collectl - new performance linux performance monitor

About 4 years ago I wrote this tool inspired by Rob Urban's collect tool for DEC's Tru64 Unix. What makes this tool as different as collect was in its day is its ability to run at a low overhead and collect tons of stuff. I've expanded the general concept and even include data not available in... (0 Replies)
Discussion started by: MarkSeger
0 Replies

3. Solaris

Multi CPU Solaris system shows 100% CPU usage.

Hello Friends, On one of my Solaris 10 box, CPU usage shows 100% using "sar", "vmstat". However, it has 4 CPUs and prstat and glance are not showing enough processes to justify high CPU utilization. ========================================================================= $ prstat -a ... (4 Replies)
Discussion started by: mahive
4 Replies

4. Solaris

In Solaris Zones Dedicated-Cpu Performance?

Hi All, While creating zone we will mention min and max cpu cores, like add dedicated-cpu set ncpus=NUM_CPUS_MIN-NUM_CPUS_MAX end Ques1: Suppose thing that non global zone uses only minimum cores at particular time What the other cores will do, Will it shared to global zone? Ques:2... (1 Reply)
Discussion started by: vijaysachin
1 Replies

5. HP-UX

Bad performance but Low CPU loading?

There might be some problem with my server, because every morning at 7, it's performance become bad with no DB extra deadlock. But I just couldn't figure it out. Please give me some advise, thanks a lot... According to the CPU performace chart, Daily CPU loading Maximum: 42 %, Average:36%. ... (8 Replies)
Discussion started by: GreenShery
8 Replies

6. SCO

CPU Performance Problems on VMWARE

hi We have migrated SCO 5.0.6 into ESX4, but the VM eats 100% of the virtual CPU. Here is top print from the SCO VM: last pid: 16773; load averages: 1.68, 1.25, 0.98 02:08:41 79 processes: 75 sleeping, 2 running, 1 zombie, 1 onproc CPU states: 0.0% idle, 17.0% user,... (7 Replies)
Discussion started by: ccc
7 Replies

7. HP-UX

Performance - CPU spiking

We have a DB server which is constantly utilised above 95% above. This is becoming nuisance when the monitoring team frequently calls to check on it. Frankly I do not know what to tweak or even interpret the outputs. I noticed constant 30 to 60% in wio column of the cpu utilisation. There... (1 Reply)
Discussion started by: sundar63
1 Replies

8. Shell Programming and Scripting

AIX CPU performance script ?

I want to write a shell script which will print AIX CPU utilization memory utilization every 5 mins redirect to file. How do i do it? Please advise. Which commands I should use? (3 Replies)
Discussion started by: vegasluxor
3 Replies

9. Solaris

Understanding & Monitoring CPU performance (Load vs SAR)

Hi all, Been reading a lot of the cpu load and its "analogy of it to car traffic path of expressway" From wiki Most UNIX systems count only processes in the running (on CPU) or runnable (waiting for CPU) states. However, Linux also includes processes in uninterruptible sleep states... (13 Replies)
Discussion started by: javanoob
13 Replies
VMSTAT(1)						    BSD General Commands Manual 						 VMSTAT(1)

NAME
vmstat -- report virtual memory statistics SYNOPSIS
vmstat [-CefHiLlmstUvW] [-c count] [-h hashname] [-M core] [-N system] [-u histname] [-w wait] [disks] DESCRIPTION
vmstat reports certain kernel statistics kept about process, virtual memory, disk, trap, and CPU activity. The options are as follows: -C Report on kernel memory caches. Combine with the -m option to see information about memory pools that back the caches. -c count Repeat the display count times. The first display is for the time since a reboot and each subsequent report is for the time period since the last display. If no wait interval is specified, the default is 1 second. -e Report the values of system event counters. -f Report fork statistics. -H Report all hash table statistics. -h hashname Report hash table statistics for hashname. -i Report the values of system interrupt counters. -L List all the hashes supported for -h and -H. -l List the UVM histories being maintained by the kernel. -M core Extract values associated with the name list from the specified core instead of the default /dev/mem. -m Report on the usage of kernel dynamic memory listed first by size of allocation and then by type of usage, followed by a list of the kernel memory pools and their usage. -N system Extract the name list from the specified system instead of the default /netbsd. -s Display the contents of the uvmexp structure. This contains various paging event and memory status counters. -t Display the contents of the vmtotal structure. This includes information about processes and virtual memory. The process part shows the number of processes in the following states: ru on the run queue dw in disk I/O wait pw waiting for paging sl sleeping The virtual memory section shows: total-v Total virtual memory active-v Active virtual memory in use active-r Active real memory in use vm-sh Shared virtual memory avm-sh Active shared virtual memory rm-sh Shared real memory arm-sh Active shared real memory free Free memory All memory values are shown in number of pages. -U Dump all UVM histories. -u histname Dump the specified UVM history. -v Print more verbose information. When used with the -i, -e, or -m options prints out all counters, not just those with non-zero values. -W Print more verbose information about kernel memory pools. -w wait Pause wait seconds between each display. If no repeat count is specified, the default is infinity. By default, vmstat displays the following information: procs Information about the numbers of processes in various states. r in run queue b blocked for resources (i/o, paging, etc.) memory Information about the usage of virtual and real memory. Virtual pages (reported in units of 1024 bytes) are considered active if they belong to processes which are running or have run in the last 20 seconds. avm active virtual pages fre size of the free list page Information about page faults and paging activity. These are averaged every five seconds, and given in units per second. flt total page faults re page reclaims (simulating reference bits) pi pages paged in po pages paged out fr pages freed per second sr pages scanned by clock algorithm, per-second disks Disk transfers per second. Typically paging will be split across the available drives. The header of the field is the first charac- ter of the disk name and the unit number. If more than four disk drives are configured in the system, vmstat displays only the first four drives. To force vmstat to display specific drives, their names may be supplied on the command line. faults Trap/interrupt rate averages per second over last 5 seconds. in device interrupts per interval (including clock interrupts) sy system calls per interval cs CPU context switch rate (switches/interval) cpu Breakdown of percentage usage of CPU time. us user time for normal and low priority processes sy system time id CPU idle FILES
/netbsd default kernel namelist /dev/mem default memory file EXAMPLES
The command ``vmstat -w 5'' will print what the system is doing every five seconds; this is a good choice of printing interval since this is how often some of the statistics are sampled in the system. Others vary every second and running the output for a while will make it appar- ent which are recomputed every second. SEE ALSO
fstat(1), netstat(1), nfsstat(1), ps(1), systat(1), iostat(8), pstat(8) The sections starting with ``Interpreting system activity'' in Installing and Operating 4.3BSD. BUGS
The -c and -w options are only available with the default output. The -l, -U, and -u options are useful only if the system was compiled with support for UVM history. BSD
October 22, 2009 BSD
All times are GMT -4. The time now is 02:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy