Oracle-L: RE: Paging problem

From: Kurth, Michael J. <MJKurth_at_covhealth.org>
Date: Tue, 27 May 2003 06:29:42 -0800
Message-ID: <F001.005A3314.20030527062942@fatcity.com>

You may also want to limit the amount of memory for the Unix buffer cache. I forget the parameter, but typically you would set this to around 25 - 30 %.
If you leave it to its default value, unix will hog much memory for the ubc. It also depends on if you are using raw devices or not.

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

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

Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter.

The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance.

If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail.

Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Kurth, Michael J.
INET: MJKurth_at_covhealth.org

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 - 09:29:42 CDT