LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > AIX
User Name
Password
AIX This forum is for the discussion of IBM AIX.
eserver and other IBM related questions are also on topic.

Notices



Reply
 
Search this Thread
Old 05-07-2008, 07:14 AM   #1
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 447

Rep: Reputation: 30
Oracle 10g takes 99% memory utilization of the Linux/AIX server , always!


Dear Friends ,

I am running Oracle 10g in AIX-5.3 server . I have another server RHEL5
which has also running Oracle 10g .

When oracle instance is started then some of memroy are used .This is natural, I know . But when I am running 'export' and 'import' script more that 11 times ,then I see the memory of the server is going to 99% utilized . After completing export/import process , then the Memory utilization remains same , it holds 99% memory . The server does not free the memory . But If I restart the database then memory goes to its initial stage or in normal position .And it is not possible to restart the database daily .

Here I mention that , I need to run export/import script daily .

Now plz tell me , why it is happened and how can I reduce my memory utilization ? Is this scenario make any problem in my server ?


Waiting for ur kind reply .. ..

Last edited by shipon_97; 05-07-2008 at 07:36 AM.
 
Old 05-08-2008, 10:05 PM   #2
born4linux
Senior Member
 
Registered: Sep 2002
Location: Philippines
Distribution: Slackware, RHEL&variants, AIX, SuSE
Posts: 1,127

Rep: Reputation: 49
1. is it swapping a lot?

use vmstat 1

or

topas

or

nmon


to monitor

2. AIX and most other OSes are designed that way - to utilize resources.
if you see 99% memory utilized but no paging is happening, memory is just cached. so no worries for that.
IF the system starts to page alot and a lot of users complain about "slowness", then you need to recheck your setup and add RAM when needed.

hth.
 
Old 05-09-2008, 07:49 AM   #3
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 447

Original Poster
Rep: Reputation: 30
Smile Oracle takes 99% memory utilization of the Linux/AIX server , always!

Thx born4linux for ur kind reply ..

First time During installation my oracle in my AIX 5.3 unix server my paging space utilization 0% of memory .
But Today record of my server usage is :
Memory (RAM) : 99.3 % (I use 4 GB RAM , my swap space = 2 x RAM)
And , Paging = 31.6% (Last few days it increase 5% more , initially it was 0%)

Here I mention that I always use NMON as memory monitoring tool and the above data are recorded from NMON today (08'May'2008)

Is u guess any problem my server ?

Plz give me some suggestion ...
 
Old 05-16-2008, 04:48 AM   #4
born4linux
Senior Member
 
Registered: Sep 2002
Location: Philippines
Distribution: Slackware, RHEL&variants, AIX, SuSE
Posts: 1,127

Rep: Reputation: 49
post some details on your system when you are having this situation. to
check:

1. use ps to list the top memory users:

ps gv | head -n 1; ps gv | egrep -v "RSS" | sort +6b -7 -n -r


2. use vmstat to check bottleneck:

vmstat 1 10

# this will give 10 iterations with 1 sec interval

3. from the ps output in #1, you can check the processes what they are really
utilizing using svmon:

svmon -P | grep -p PID

# the output here will show if the process is utilizing paging space

4. runt "topas" to take a glimpse of what's going on in your system.

using the tools above, you can arrive at a conclusion and verify what's
eeating up your resources.

also check your oracle settings and sql queries - in most cases, memory hogging
is due to very poor sql codes.
 
  


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 10g Installation on Redhat Enterprize Linux 4 Advance server sachinkhot Linux - Enterprise 6 05-07-2013 10:39 AM
Installation Oracle 10g Application Server on RHEL 4 ES (AMD 64bit) - Help me please! sk84ru Linux - Enterprise 14 11-13-2009 02:47 AM
RHEL 5 supports Oracle 10g r 2 on Itanium Server yagnesh Linux - Server 1 11-10-2007 10:31 AM
Oracle 10g with AIX 5.3 shipon_97 AIX 5 08-02-2007 04:27 AM
Oracle Application Server (OAS 10G) on Fedora kheldar Linux - Software 0 01-11-2005 02:55 AM


All times are GMT -5. The time now is 06:12 PM.

Main Menu
Advertisement
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