How to determine memory usage for oracle db changes?

[Gino Castoldi_2]

Hi,

HPUX 11.11 OVOU Oracle 8.1.7.4 4GB memory

We are having Oracle resource issues on our server. We are going to update some tuning parameters to help resolve this problem.
How can we tell what impact these changes will have? Can we tell how much memory is now being used after a change is made? We want to make sure that the Oracle changes will not use up too much memory.

10 points to any good answer.
Thank you
Gino

[Steven E. Protter · Accepted solution]

Shalom Gino,

Several good ways.

1) Configure glance gpm to collect information and run a series of database read/write/access tests. make the changes, run the same test and compare the data.

2) Same concept without glance, use sar scripting. http://www.hpux.ws/system.perf.sh

SEP

[Arturo Galbiati]

Hi Gino,
Oracle provides you a lot of tools to monitor this:
http://www.stanford.edu/dept/itss/docs/oracle/9i/em.920/a86647/toc.htm
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96533/toc.htm
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96532/toc.htm

HTH,
Art