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
Old 08-12-2010
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
 

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... (7 Replies)
Discussion started by: Lazzar
7 Replies

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 ... (0 Replies)
Discussion started by: hawkerpacific
0 Replies

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 (0 Replies)
Discussion started by: pascalbout
0 Replies

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 (1 Reply)
Discussion started by: Browser_ice
1 Replies

5. Solaris

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

what is the command to see which database ie..oracle in running on solaris 10 (2 Replies)
Discussion started by: tv.praveenkumar
2 Replies

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... (0 Replies)
Discussion started by: Agupte
0 Replies

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 (5 Replies)
Discussion started by: Vishal_dba
5 Replies

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 ----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
Sys::Filesystem::Aix(3pm)				User Contributed Perl Documentation				 Sys::Filesystem::Aix(3pm)

NAME
Sys::Filesystem::Aix - Return AIX filesystem information to Sys::Filesystem SYNOPSIS
See Sys::Filesystem. INHERITANCE
Sys::Filesystem::Aix ISA UNIVERSAL METHODS
version () Return the version of the (sub)module. ATTRIBUTES
The following is a list of filesystem properties which may be queried as methods through the parent Sys::Filesystem object. account Used by the dodisk command to determine the filesystems to be processed by the accounting system. boot Used by the mkfs command to initialize the boot block of a new filesystem. check Used by the fsck command to determine the default filesystems to be checked. dev Identifies, for local mounts, either the block special file where the filesystem resides or the file or directory to be mounted. free This value can be either true or false. (Obsolete and ignored). mount Used by the mount command to determine whether this file system should be mounted by default. nodename Used by the mount command to determine which node contains the remote filesystem. size Used by the mkfs command for reference and to build the file system. type Used to group related mounts. vfs Specifies the type of mount. For example, vfs=nfs specifies the virtual filesystem being mounted is an NFS filesystem. vol Used by the mkfs command when initializing the label on a new filesystem. The value is a volume or pack label using a maximum of 6 characters. log The LVName must be the full path name of the filesystem logging logical volume name to which log data is written as this file system is modified. This is only valid for journaled filesystems. SEE ALSO
Sys::Filesystem Example /etc/filesystems * @(#)filesystems @(#)29 1.22 src/bos/etc/filesystems/filesystems, cmdfs, bos530 9/8/00 13:57:45 * IBM_PROLOG_BEGIN_TAG * This is an automatically generated prolog. * * <snip> * * This version of /etc/filesystems assumes that only the root file system * is created and ready. As new file systems are added, change the check, * mount, free, log, vol and vfs entries for the appropriate stanza. /: dev = /dev/hd4 vol = "root" mount = automatic check = false free = true vfs = jfs2 log = /dev/hd8 type = bootfs /proc: dev = /proc vol = "/proc" mount = true check = false free = false vfs = procfs /scratch: dev = /dev/fslv02 vfs = jfs2 log = INLINE mount = true account = false Example /usr/sbin/mount output node mounted mounted over vfs date options -------- --------------- --------------- ------ ------------ --------------- /dev/hd4 / jfs2 Mar 24 12:14 rw,log=/dev/hd8 /proc /proc procfs Mar 24 12:15 rw /dev/fslv02 /scratch jfs2 Mar 24 12:15 rw,log=INLINE filesystems(4) Manpage includes all known options, describes the format and comment char's. VERSION
$Id: Aix.pm 128 2010-05-12 13:16:44Z trevor $ AUTHOR
Nicola Worthington <nicolaw@cpan.org> - <http://perlgirl.org.uk> Jens Rehsack <rehsack@cpan.org> - <http://www.rehsack.de/> COPYRIGHT
Copyright 2004,2005,2006 Nicola Worthington. Copyright 2008-2010 Jens Rehsack. This software is licensed under The Apache Software License, Version 2.0. <http://www.apache.org/licenses/LICENSE-2.0> perl v5.10.1 2010-05-18 Sys::Filesystem::Aix(3pm)
All times are GMT -4. The time now is 02:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy