Re: Memory Usage in Oracle

At any time you may monitor each Oracle process PGA memory (the one not pre-allocated at startup time) usage by:

select pga_alloc_mem, addr from v$process;

and identifie each process' session by:

select * from v$session where paddr = <the above addr value>;

or
select pga_alloc_mem, s.*
from v$process p , v$session
where p.addr = s.addr;

Other memory usage related columns of interest in v$process. See documentation.

As stated in another post, DIO mounting is recommended for your /oradata fs.

<jeffchirco_at_gmail.com> a écrit dans le message de news: 1168532774.745246.36100_at_p59g2000hsd.googlegroups.com...
> Hi, I am the DBA of dawaves who started this thread. Our SGA and PGA
> are fixed at 1.4gigs and 400M respectively. And we are running 10g.
>
> Jeff
>
> Jerome Vitalis wrote:
>> dawaves wrote:
>> > Hello,
>> >
>> > I'm an AIX Systems Administrator who is kind of confused w/ Oracle's
>> > use of memory and I wanted to see if maybe some Oracle DBA's out there
>> > can help me out.
>> >
>> > Here is our situation:
>> >
>> > We have a 16GB Oracle Production Database running on AIX 5.3 ML04. We
>> > have a total of 16GB of RAM.
>> >
>> > It seems every time we had more physical RAM, the Oracle DB wants to
>> > use all the available RAM. Now when I mount the /oradata directory w/
>> > the 'cio' option, the Oracle Processes tend to use less which make
>> > sense since it is eliminating the file buffer portion in memory.
>> >
>> > Now is this normal for Oracle to use as much RAM as it can?
>> >
>> > What kind of systems are other DBA's running their Oracle Servers on
>> > and with how much RAM? How do you deal w/ Paging?
>> >
>> > If we cap the use of memory for our Oracle DB from the OS, can that
>> > lead to ramifications for our Oracle DB?
>> >
>> > Thanks for reading this and hopefully some Oracle DBA's out there can
>> > respond to some of my questions.
>> >
>> > thanks!
>> >
>>
>> Which Oracle version?
>>
>> And what are your instance parameters related to the SGA and PGA?
>
Received on Sat Jan 13 2007 - 14:05:54 CST