Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Paging problem

RE: Paging problem

From: Arvind Kumar <arvindk_at_sqlstarintl.com>
Date: Mon, 26 May 2003 21:21:39 -0800
Message-ID: <F001.005A2DE5.20030526212139@fatcity.com>


i swap space is of 4gb , if i run lsps -a it shows 30% of 4gb is being used.it is exactaly as same as total amount of physical memory consumed that time, say 30% of 2gb RAM in TOP command output.

Thanks

Arvind

-----Original Message-----
Sent: Monday, May 26, 2003 10:57 PM
To: Multiple recipients of list ORACLE-L

What does 'lsps -a' show? (man lsps for details).

Are you sure, that performance is slow because of paging?

You may want to visit : http://www-1.ibm.com/servers/aix/library/index.html and read about 'vmtune' and how AIX uses memory.

-----Original Message-----
Sent: Monday, May 26, 2003 3:37 AM
To: Multiple recipients of list ORACLE-L

Let's be simplistic about this. First, type ps -el|grep -v oracle. That will

give you list of all processes except those ran by user oracle. Look at the column
SZ and see which one is the largest. Do you have JDK,X11, GNOME, CDE, X terminals, Domino
server or any other hog on the system? Do you have top? Run top and press capital M.
That will sort processes by their resident memory. See which one doesn't belong to
oracle and see if it is paging, and if it is, what is it doing and do you really,
really want it? If no processes other then oracle ones are devouring memory, do
you have dedicated server connections or MTS? May be you should consider MTS? If not,
look at the sort area size, hash area size, OPEN_CURSORS (I've always been suspicious
when it comes to the applications that open a gazillion of cursors). How about kernel configuration? How many buffers do you have? (NBUFF and NINODE
parameters, now obsolete in most Unixes, but 4.3 is a rather old version). How
about STREAMS? Do you have a gazillion of unnecessary streams buffers? Do you have OpenGL
installed? Any processes named something like Doom, Xtetris, Invaders, Pacman
(well, Pacman and Snake are rather old ones, but who knows. I used to play them
on a big VAX 6440. Boy did they perform well, especially if given real-time priorities.) or alike? Are you running Samba, Apache, WebSphere or anything of
that nature? Do you have 25,000 processes named "httpd"?

On 2003.05.26 03:11 Arvind Kumar wrote:
> Hi All,
>
> am facing the paging/swaping problem on AIX 4.3 running the oracle
> 8.1.5.i have 2GB of physical Memory and the total SGA is
> as below -
> buffer cache-350M
> Shared pool - 200M
> Log buffer -10 M
> Sort area size - 2M
> Sort area reatined size - 1M
>
> Database cache Hit Ratio is - 94 to 96%
> Library cache Hit Ratio is - 96%
>
> the most waited event is db_file_scattered_read , due to this i increased
> the value of db_file_multiblock_read_count from 16 to 64.
>
> maximum concurrent users connected is 80, at pick time.if i run the vmstat
> command the PI and PO column is always 2 and 1.
> in TOP command it shows that total memory usages is same as the total
> virtual memory usgaes means if my total memory use is
> 800M then the virtual is also of 800M.
>
> i am not able to find out why the paging is ocurring resulting the slow
> response.is there anything needs to be done on OS level
> like setting the shared memory and semaphores as we do in case of SCO
Unix.
>
> Thanks
>
>
> Arvind Kumar

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arvind Kumar
  INET: arvindk_at_sqlstarintl.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue May 27 2003 - 00:21:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US