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

Name
       vmstat - report virtual memory statistics

Syntax
       vmstat [ interval [ count ] ]
       vmstat -v [ interval [ count ] ]
       vmstat -fKSsz
       vmstat -Kks namelist [ corefile ]

Description
       The command reports statistics on processes, virtual memory, disk, trap, and cpu activity.

       If  is  specified without arguments, this command summarizes the virtual memory activity since the system was last booted.  If the interval
       argument is specified, then successive lines are summaries of activity over the last interval seconds.  Because many statistics are sampled
       in  the system every five seconds, five is a good specification for interval; other statistics vary every second.  If the count argument is
       provided, the statistics are repeated count times.

       When you run the format fields are as follows:

       Procs: information about numbers of processes in various states.

	    r	 in run queue

	    b	 blocked for resources (i/o, paging, and so on.)

	    w	 runnable or short sleeper (< 20 seconds) but swapped

       faults:	trap/interrupt rate averages per second over the last 5 seconds.

	    in	 (non clock) device interrupts per second

	    sy	 system calls per second

	    cs	 cpu context switch rate (switches/second)

       cpu:  breakdown of percentage usage of cpu time

	    us	 user time for normal and low priority processes

	    sy	 system time

	    id	 cpu idle time

       Memory:	information about the use of virtual and real memory.  Virtual pages 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

       Pages are reported in units of 1024 bytes.

       If  the number of pages exceeds 9999, it is shown in a scaled representation.  The suffix k indicates multiplication by 1000 and the suffix
       m indicates multiplication by 1000000.  For example, the value 12345 appears as 12k.

       page: information about page faults and paging activity.  These are averaged every five seconds, and given in units per second.	 The  size
       of a unit is always 1024 bytes and is independent of the actual page size on a machine.

	    re	 page reclaims (simulating reference bits)

	    at	 pages attached (found in free list not swapdev or filesystem)

	    pi	 pages paged in

	    po	 pages paged out

	    fr	 pages freed per second

	    de	 anticipated short term memory shortfall

	    sr	 pages scanned by clock algorithm, per-second

       disk:   s0,  s1 ...sn: Paging/swapping disk sector transfers per second (this field is system dependent).  Typically paging is split across
       several of the available drives.  This will print for each paging/swapping device configured into the kernel.

Options
       -f     Provides reports on the number of forks and vforks since system startup and the number of pages of virtual memory involved  in  each
	      kind of fork.

       -K     Displays usage statistics of the kernel memory allocator.

       -k     Allows  a  dump  to be interrogated to print the contents of the sum structure when specified with a namelist and corefile.  This is
	      the default.

       -S     Replaces the page reclaim (re) and pages attached (at) fields with processes swapped in (si) and processes swapped out (so).

       -s     Prints the contents of the sum structure, giving the total number of several kinds of paging related events that have occurred since
	      boot.

       -v     Prints an expanded form of the virtual memory statistics.

       -z     Zeroes out the sum structure if the UID indicates root privilege.

Examples
       The following command prints what the system is doing every five seconds:
       vmstat 5
       To find the status after a core dump use the following:
       cd /usr/adm/crash
       vmstat -k vmunix.? vmcore.?

Files
       Kernel memory

       System namelist

																	 vmstat(1)
All times are GMT -4. The time now is 08:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy