Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: Oracle vs O...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 7 Topic 16533 of 17418
Post > Topic >>

Re: Oracle vs OS Memory Utilization

by hpuxrac <johnbhurley@[EMAIL PROTECTED] > May 9, 2008 at 03:46 PM

On May 8, 6:05=A0pm, ROAL <ralbert...@[EMAIL PROTECTED]
> wrote:
> I have a Solaris server V445 running:
> 5.10 Generic_120011-14 sun4u sparc SUNW,Sun-Fire-V445
>
> The server has 8G of memory. However TOP only is showing 700M
> available.
>
> The DB instance is only taking up approx 1G in shared memory segment,
> i.e. SGA
>
> GROUP =A0CREATOR =A0 CGROUP NATTCH =A0 =A0 =A0SEGSZ =A0CPID =A0LPID =A0
AT=
IME
> DTIME =A0 =A0CTIME
> Shared Memory:
> m =A0 =A0 =A0 =A0 =A01 =A0 0x76125b4 =A0--rw-r----- =A0 oracle =A0 =A0
=A0=
dba =A0 oracle
> dba =A0 =A0 36 =A0943734784
>
> BY THE WAY ORACLE 10G:
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> select * from v$SGA;
>
> NAME =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0VALUE
> -------------------- ----------
> Fixed Size =A0 =A0 =A0 =A0 =A0 =A0 =A02034632
> Variable Size =A0 =A0 =A0 =A0 486544440
> Database Buffers =A0 =A0 =A0419430400
> Redo Buffers =A0 =A0 =A0 =A0 =A0 35708928
>
> Why is the server only showing 700M free. I actually brought the
> instance down due to perf issues today then viewed memory. When
> instance was down it was showing 7+G of available memory. As soon as I
> started the instance with no connections the memory immediately
> dropped to 800M available.
>
> Also before bringing instance down swap utilization was at 50% of
> available, i.e. 4G out of 8G.
>
> Curent TOP
> Memory: 8192M phys mem, 762M free mem, 8193M total swap, 8193M free
> swap
>
> At least swap is not being used now.
>
> What is eating up all the OS memory?
>
> NOTE: There is another server running 2 9i instances with 8G of mem
> and 3G in share memory for the 2 instances and this server show 3G
> free mem.
>
> Thanks.

Are you familiar with Big Admin?  It is a sun site and forum that
allows you to ask and search for solaris related admin questions.
 




 7 Posts in Topic:
Oracle vs OS Memory Utilization
ROAL <ralbertson@[EMAI  2008-05-08 15:05:04 
Re: Oracle vs OS Memory Utilization
"Ana C. Dent" &  2008-05-09 01:26:45 
Re: Oracle vs OS Memory Utilization
ROAL <ralbertson@[EMAI  2008-05-08 19:40:26 
Re: Oracle vs OS Memory Utilization
"Ana C. Dent" &  2008-05-09 03:11:28 
Re: Oracle vs OS Memory Utilization
Mark D Powell <Mark.Po  2008-05-09 06:40:22 
Re: Oracle vs OS Memory Utilization
"unixoracle" &l  2008-05-09 17:25:42 
Re: Oracle vs OS Memory Utilization
hpuxrac <johnbhurley@[  2008-05-09 15:46:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:14:00 CST 2008.