LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
Search this Thread
Old 06-03-2005, 06:26 AM   #1
dippelw
LQ Newbie
 
Registered: May 2003
Posts: 2

Rep: Reputation: 0
Oracle on RHEL AS3 Cluster


I am a sysadmin for an Oracle DB instance running on an active/passive RHEL AS3 cluster. I have 16GB of RAM in each node and 4 procs. My concern is memory utilization. Oracle seems to soak up all but 20 or so MB of RAM consistantly. I have verified with the DBA that all is well from his view and I have not seen any OS or application related problems as of yet. Can anyone tell me if this is normal? Thanks!
 
Old 06-03-2005, 07:32 AM   #2
sadun
Member
 
Registered: Mar 2005
Posts: 48

Rep: Reputation: 15
Hi,

Your problem is very complicated and need detailed informations.

1- What is your kernel version? Check it with uname?
2- What is your kernel parameters for oracle? (see Oracle installation documentation)

If these two parameters satisfy then we need to work on the dba side.

3- How many users are there in the system?
4- Is the system shared or dedicated
5- Are you using rac?
6- what is the result for ps - ef | grep oracle
7- check shared memory with pmap, vmstat or other commands.
8- Is your system hanging or crashing for that reason?
9- Are users getting any oracle error messages?
10- Can you post 'show parameters' output from the sqlplus.

I cant be sure at that point but it is most likely a performance tuning problem if it is not releated to redhat kernel (I think Redhat is the least reliable among other linux systems).

Last edited by sadun; 06-06-2005 at 02:17 AM.
 
Old 06-05-2005, 09:38 AM   #3
duliano
Member
 
Registered: Oct 2004
Location: Clayton, NY
Distribution: SuSE Prof 9.1, 9.2, 9.3Pro X86_64 SLES 8 & 9
Posts: 82

Rep: Reputation: 15
This sounds like your oracle parameters are a bit oversized. I don't know what version of oracle you are running but if it is pre 9 then I would first look at DB_BLOCK_BUFFERS multiplied by DB_BLOCK_SIZE. This will tell you how large the SGA is. If your db version is 9 or higher then you can use the parameter DB_CACHE_SIZE and that will tell you the size of your sga. There are other parameters as well to look at, so if you post your init.ora parameters here I can tell you if your parameters are causing the high memory usage. I work with very large oracle systems (solaris active passive) that run SAP and I know that you can control the amount memory oracle uses.

Hope this helps
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle 8i on RHEL 3, possible? jadefox Linux - Enterprise 3 11-29-2005 08:37 AM
Oracle 10g on RHEL 4 notcrazy Red Hat 0 06-22-2005 08:46 PM
O/S partitioning scheme for Oracle 10g on RHEL Linux AS3 lugnut Linux - Enterprise 0 01-03-2005 02:46 AM
How to Startup Oracle Listener In the Linux Cluster Environment research2004 Linux - Enterprise 1 05-02-2004 12:30 AM
Trouble installing Oracle 9.0.2 on RHEL 3.0 GAVollink Red Hat 5 01-06-2004 11:30 AM


All times are GMT -5. The time now is 03:55 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration