ORACLE Database running slow on AIX ( nmon / topas ) Post: 302444447

Sponsored Content

Operating Systems AIX ORACLE Database running slow on AIX ( nmon / topas ) Post 302444447 by zxmaus on Thursday 12th of August 2010 12:46:38 AM

08-12-2010

Moderator

Hi,

to correct zaxxon (sorry !) turn on EITHER cio (jfs2), dio (jfs) OR set in Oracle filesystemio_options=setall - never do both. If you have an older oracle version installed, it might not be able to handle the setall option - in that case choose async_io and go with cio or dio for the filesystems. You might want to consider smaller blocksizes for the redo logs too.

I would like to see the

Code:

vmstat -Iwt 2 30 ; vmstat -v ; vmstat -s

outputs from a busy time too - and I would like to know if you have jfs or jfs2 filesystems and if you have applied at least some basic tuning ?

Interesting would be what your database is doing - trading, reporting, both ... how many connections, these things. Keep in mind every connection to oracle takes memory - in certain cases dozens of MB ...

Kind regards
zxmaus

zxmaus

View Public Profile for zxmaus

Find all posts by zxmaus

8 More Discussions You Might Find Interesting

1. AIX

Memory usage statistic? (topas, nmon)

hi, how can i diplay: - the ammount RAM used /free - ammount of ram used from a pid or prozess we have the problem, that malloc is returing a NULL pointer errno = 12 ( not enough space). but i think there is still ram free. nmon : shows all memory used ? Memory Use Physical Virtual...

2. Filesystems, Disks and Memory

skgpspawn failed running oracle db 9.2.0.5.0 on aix 5.3

Hi, I am running an oracle db 9.2.0.5.0 on ibm p5 550 aix 5.3 with 10g ram, 10G swap space 3 database instances each SGA about 500Meg. I am getting the following error in my alert log file from time to time: skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3 ...

3. AIX

nmon vs topas

good morning what is the better solution to examen a P570 ? because i use topas and nmon, and the results are totally different !!! with nmon, i have 80% free cpu, and with nmon, i have 90% of used cpu !!!!!! i take a shot with an intervall of 10s during 10 mn. thank you

4. AIX

Top command in AIX 4.2 (no topas, no nmon, no top)?

Is there a 'top' command equivalent in AIX 4.2 ? I already checked and I do not see the following ones anywhere: top nmon topas

5. Solaris

what is the command to see which database ie..oracle in running on solaris 10

6. Shell Programming and Scripting

Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys, Need you help in one point! I am working on one shell script which takes following steps : 1. Taking one query result from oracle database 2. Exporting that result to Xls file 3. Mailing that file to my own mail ID Now, I want to give a threshold limit to one of the column...

7. AIX

Need to check long running processes on the database server and the os is AIX

Hello, Please help me with a script with which I can check long running processes on the database server and the os is AIX. Best regards, Vishal

8. AIX

AIX server running very slow

Hello, All the commands on AIX are running very slow. Below is few stats but I didn't find any issue in cpu or memory reosurces vmstat System configuration: lcpu=4 mem=6144MB ent=1.00 kthr memory page faults cpu ----- -----------...

LEARN ABOUT LINUX

virtual-filesystems

virtual-filesystems(7)					 Miscellaneous Information Manual				    virtual-filesystems(7)

NAME

       virtual-filesystems - event signalling that virtual filesystems have been mounted

SYNOPSIS

       virtual-filesystems [ENV]...

DESCRIPTION

       The  virtual-filesystems  event	is  generated  by  the mountall(8) daemon after it has mounted all virtual filesystems listed in fstab(5).
       mountall(8) emits this event as an informational signal, services and tasks started or stopped by this event will do so	in  parallel  with
       other activity.

       This event is typically used by services that must be started in order to mount other filesystems.  When this event occurs, common filesys-
       tems such as /usr may not be mounted.  For most normal services the filesystem(7) event is sufficient.

EXAMPLE

       A service that wishes to be running once virtual filesystems are mounted might use:

	      start on virtual-filesystems

SEE ALSO

       mounting(7) mounted(7) local-filesystems(7) remote-filesystems(7) all-swaps(7) filesystem(7)

mountall							    2009-12-21						    virtual-filesystems(7)