Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help!!!!
Hi
Is it paging ?, try looking with vmstat 1 10 and see if there is any real paging going on. Check /etc/system and see if the parameter priority_paging is set. It should be set to 1. If its not set then the kernel grabs all free memory up to the low water mark. This then causes the SGA to start paging out to disk, and slows Oracle.
There is a parameter in the init.ora LOCK_SGA but this does not work on solaris( at least we couldnt get it to ). There is another way tho. write a simple C program that locks shared memory into core. look in the man pages, its very simple, i dont have access at thge moment to any C books or solaris. Then get the shared mem segments with ipcs -m at the unix prompt and lock the oracle ones.
I have had great success with this in the past
cheers
Pete Finnigan
www.pentest-limited.com
In article <9m2i23$n62_at_nntpa.cb.lucent.com>, Al <Al_at_yahoo.com> writes
>Hi,
> We have a SunUltra5 workstation with solaris2.6. It has 256MB of RAM and
>1GB of swap has been allocated to the system.
>Recently we loaded oracle server version 7.3.4.
>With all the cost cutting around although we are using a licensed version,
>we cannot go for support. I'd be glad to have any of you help to let me know
>a few answers.
>
>The oracle seems to have occupied more memory. Cuz with no process running ,
>top command shows only 10MB free. Is there a way to tune it and make it
>perform better.
>The system is dead slow. Any ideas why?
>Please let me know of useful URLs which provide some info, if any.
>
>regards
>-Al
>
>
-- Pete Finnigan IT Security Consultant PenTest Limited Office 01565 830 990 Fax 01565 830 889 Mobile 07974 087 885 pete.finnigan_at_pentest-limited.com www.pentest-limited.comReceived on Fri Aug 24 2001 - 10:30:54 CDT