On May 8, 9:26=A0pm, "Ana C. Dent" <anaced...@[EMAIL PROTECTED]
> wrote:
> ROAL <ralbert...@[EMAIL PROTECTED]
> wrote in news:4cd15746-7510-41d6-8368-
> 20c989386...@[EMAIL PROTECTED]
>
>
>
>
>
> > 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 =
ATIME
> > DTIME =A0 =A0CTIME
> > Shared Memory:
> > m =A0 =A0 =A0 =A0 =A01 =A0 0x76125b4 =A0--rw-r----- =A0 oracle =A0 =A0
=
=A0dba =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.
>
> What you have described is typical *nix behavior.
> More than likely what has been swapped out are idle processes owned by
> root. Use the "ps" command to display the RSS column; where RSS=3D0 is a
> swapped out process.
> sar -W =A0will show actual pagein & pageout activity.
> If they are only 2 digit (<100) don't worry about swap.
>
> What problem are you really trying to solve.
> Visithttp://www.orafaq.com/forum/i/74940/
> & read the STICKY post at the top of the "Performance Tuning"
sub-forum.- =
Hide quoted text -
>
> - Show quoted text -
I am trying to determine by TOP is only showing available memory as
700M when the server has 8G on it. As compared to the other server
this does not make sense. In addition to the fact that the performance
and CPU on the box at this time are horrible. THis is a re****t server
that generates a large amount of data for re****t every evening.
However performance at this time is abismal and nothing has changed.
When investigating this was something that I noticed. I have UNIX
admins looking into the server but not getting rational explanation to
my question. The share memory segment on the server is 900M so there
should be at least 6 to 7G remaining after starting up the instance.
THis is not the case. We cannot even process our normal data at this
time due to condition which I am attributing to my observation related
to what TOP is showing as available memory. I know Oracle does
processing in the share memory segment but this issue is cause for
concern and the only thing I know of that is different on the server.
Could oracle background processes be grabbing other physical memory on
the server. THis was the only thing running after we rebooted the
server.
Appreciate the input.
|
