01-17-2017
Quote:
Originally Posted by
powerAIX
T
I have already raise request to increase the SGA to 80Gb as memory is of 200Gb.
OK, but prepare to either shrink the LPARs memory or increase the SGA further to about 90% of the available RAM.
The most imminent thing to do, though, is to set the "FILESYSTEMIO_OPTIONS=SETALL" option or to mount the filesystems accordingly. I suggest doing it in the DB configuration: without this you will always have the OS trying to (double-) buffer the DB I/O, which will always be detrimental to performance.
Mounting an FS in CIO-mode (concurrent-I/O) will make all the I/O on that FS be via concurrent I/O, which is a good idea for DB files opened by the DB but a bad idea otherwise. You would need to create separate FSes (not to be mounted with the CIO-option) for i.e. dumps, exports, etc.. Setting the option in the Oracle-config will make the database open the individual files with the CIO-option but the FS itself is not changed. Thiw will have the same effect as above but without the need to create separated FSes.
I hope this helps.
bakunin
9 More Discussions You Might Find Interesting
1. AIX
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
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
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
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
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
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
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
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
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
LEARN ABOUT OPENDARWIN
quotaon
QUOTAON(8) BSD System Manager's Manual QUOTAON(8)
NAME
quotaon, quotaoff -- turn filesystem quotas on and off
SYNOPSIS
quotaon [-g] [-u] [-v] filesystem ...
quotaon [-g] [-u] [-v] -a
quotaoff [-g] [-u] [-v] filesystem ...
quotaoff [-g] [-u] [-v] -a
DESCRIPTION
Quotaon announces to the system that disk quotas should be enabled on one or more filesystems. Quotaoff announces to the system that the
specified filesystems should have disk quotas turned off. The filesystem must be mounted and it must have the appropriate mount option file
located at its root, the .quota.ops.user file for user quota configuration, and the .quota.ops.group file for group quota configuration.
Quotaon also expects each filesystem to have the appropriate quota data files located at its root, the .quota.user file for user data, and
the .quota.group file for group data. These filenames and their root location cannot be overridden. By default, quotaon will attempt to
enable both user and group quotas. By default, quotaoff will disable both user and group quotas.
Available options:
-a If the -a flag is supplied in place of any filesystem names, quotaon/quotaoff will enable/disable any filesystems with an existing
mount option file at its root. The mount option file specifies the types of quotas that are to be configured.
-g Only group quotas will be enabled/disabled. The mount option file, .quota.ops.group, must exist at the root of the filesystem.
-u Only user quotas will be enabled/disabled. The mount option file, .quota.ops.user, must exist at the root of the filesystem.
-v Causes quotaon and quotaoff to print a message for each filesystem where quotas are turned on or off.
Specifying both -g and -u is equivalent to the default.
Quotas for both users and groups will automatically be turned on at filesystem mount if the appropriate mount option file and binary data
file is in place at its root.
FILES
Each of the following quota files is located at the root of the mounted filesystem. The mount option files are empty files whose existence
indicates that quotas are to be enabled for that filesystem.
.quota.user data file containing user quotas
.quota.group data file containing group quotas
.quota.ops.user mount option file used to enable user quotas
.quota.ops.group mount option file used to enable group quotas
SEE ALSO
quota(1), quotactl(2), edquota(8), quotacheck(8), repquota(8)
HISTORY
The quotaon command appeared in 4.2BSD.
4.2 Berkeley Distribution October 17, 2002 4.2 Berkeley Distribution