Re: How can I check the current memory used by my Oracle database?

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Mon, 26 Nov 2001 07:59:51 GMT
Message-ID: <pan.2001.11.26.02.59.39.718.935@earthlink.net>

In article <3c01b20d$1_1_at_aeinews.>, "Huy Vu" <huyv_at_usa.net> wrote:

> Hi all,
>
> I have an Oracle database 8.1.7 (64bits) on HP-UX 11.0 (64bits).
>
> The server sometime run out of memory.
>
> I would like to verify how much memory occupied by Oracle database
> currently.
>
> Thanks in advance for any advise.
>
> DH

Databases do not occupy memory. Processes do. You can use ps, top or glance. On HP, glance is the best alternative. Of course you must supplement it with commands like iostat and sar. Get yourself a marlin book from O'Reilly (Mike Loukides: Tuning Unix) and learn the black art of tuning.

-- 
Mladen Gogala

Received on Mon Nov 26 2001 - 01:59:51 CST