Re: Monitoring Memory

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 Dec 1998 23:49:26 +0100
Message-ID: <3676E776.E9E6B007@sybrandb.demon.nl>

Oracle is maintaining information about the pga (program global area) and uga (user global area) in v$sesstat. Plunder $ORACLE_HOME/rdbms/admin/utlestat for statements selecting from v$sysstat, the system wide view. Add the columns serial and sid to query for a specific session

hth,

Sybrand Bakker, Oracle DBA

tyan_at_clienttechnologies.com wrote:

> I need to get a statistics on how much memory will be needed based on a sample
> of transaction on Oracle. For example, I want to know how much memory will be
> needed if I want to have 100 users performing a transaction which insert one
> record into 20 of my tables. Is there a way with Oracle where I can monitor
> the memory usage? Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Tue Dec 15 1998 - 16:49:26 CST