Sponsored Content
Full Discussion: CPU performance
Operating Systems AIX CPU performance Post 302989415 by zaxxon on Thursday 12th of January 2017 07:15:24 AM
Old 01-12-2017
CIO also includes the benefits DIO - afaik with jfs2 you usually use CIO anyway, no DIO.

If I recall it correct, it is just mounting the relevant filesystems with the cio option and have the setting in the init.ora that agent.kgb described. Though take care that not all Oracle FS maybe used with CIO!

Taken from: Managing Oracle disk I/O in AIX
Quote:
The IBM documentation ?Configuring IBM System Storage DS4000 Series For Oracle Database Applications? (October 2015) notes special considerations for AIX blocksizes:


?When CIO is used, the POSIX standard filesystem level I/O serialization mechanisms are disabled, which avoids inode contention issues.

If planning to use JFS2 CIO, be sure to isolate online redo logs and control files in a separate file system that was created with agblksize=512.

File systems which contain Oracle data (.dbf) files should be created with agblksize=4096 if db_block_size >= 4K or agblksize=2048 if db_block_size=2K.

On CIO-mounted filesystems that contain datafiles, the database block size needs to be multiple of agblksize.

This is not something that customers need to worry about except if the database block size is 2KB, in which case you need to make sure agblksize is 2KB, 1KB or 512 bytes.?

As mentioned by the other guys, you might have a check applicationwise, maybe some queries cost a lot of resources, that an index is not optimal or table scans are done etc.

Check this one, page 3:
IBM Systems Mag: In tune with Oracle
 

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)						      General Commands Manual							 vmstat(1)

NAME
vmstat - report virtual memory statistics SYNOPSIS
[interval [count]] | | DESCRIPTION
The command reports certain statistics kept about process, virtual memory, trap, and CPU activity. It also can clear the accumulators in the kernel structure. Options recognizes the following options: Report disk transfer information as a separate section, in the form of transfers per second. Provide an output format that is more easily viewed on an 80-column display device. This format separates the default output into two groups: vir- tual memory information and CPU data. Each group is displayed as a separate line of output. On multiprocessor systems, this display format also provides CPU utilization on a per CPU basis for the active processors. Report the number of processes swapped in and out and instead of page reclaims and address translation faults and interval Display successive lines which are summaries over the last interval seconds. The first line reported is for the time since a reboot and each subsequent line is for the last interval only. If interval is zero, the output is displayed once only. If the option is specified, the column headers are repeated. If is omitted, the column headers are not repeated. The command prints 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. count Repeat the summary statistics count times. If count is omitted or zero, the output is repeated until an interrupt or quit signal is received. From the terminal, these are commonly and respectively (see stty(1)). Report on the number of forks and the number of pages of virtual memory involved since boot-up. Print the total number of several kinds of paging-related events from the kernel structure that have occurred since boot-up or since was last executed with the option. Clear all accumulators in the kernel structure. This option is restricted to the super user. If none of these options is given, displays a one-line summary of the virtual memory activity since boot-up or since the option was last executed. Column Descriptions The column headings and the meaning of each column are: Information about numbers of processes in various states. In run queue Blocked for resources (I/O, paging, etc.) Runnable or short sleeper (< 20 secs) but swapped Information about the usage of virtual and real memory. Virtual pages are considered active if they belong to processes that are running or have run in the last 20 seconds. Active virtual pages Size of the free list Information about page faults and paging activity. These are averaged each five seconds, and given in units per second. Page reclaims (without Address translation faults (without Processes swapped in (with Processes swapped out (with Pages paged in Pages paged out Pages freed per second Anticipated short term memory shortfall Pages scanned by clock algorithm, per second Trap/interrupt rate averages per second over last 5 seconds. Device interrupts per second (nonclock) System calls per second CPU context switch rate (switches/sec) Breakdown of percentage usage of CPU time for the active processors User time for normal and low priority processes System time CPU idle EXAMPLES
The following examples show the output for various command options. For formatting purposes, some leading blanks have been deleted. 1. Display the default output. 2. Add the disk tranfer information to the default output. 3. Display the default output in 80-column format. 4. Replace the page reclaims and address translation faults with process swapping in the default output. 5. Display the default output twice at five-second intervals. Note that the headers are repeated. 6. Display the default output twice in 80-column format at five-second intervals. Note that the headers are repeated. 7. Display the default output and disk transfers twice in 80-column format at five-second intervals. Note that the headers repeated. 8. Display the number of forks and pages of virtual memory since boot-up. 9. Display the counts of paging-related events. WARNINGS
Users of must not rely on the exact field widths and spacing of its output, as these will vary depending on the system, the release of HP- UX, and the data to be displayed. AUTHOR
was developed by the University of California, Berkeley and HP. SEE ALSO
iostat(1). vmstat(1)
All times are GMT -4. The time now is 12:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy