Home » RDBMS Server » Performance Tuning » Questions
Questions [message #220747] Wed, 21 February 2007 21:05 Go to next message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Hello All,

May be i did not clear myself in my earlier question. Here what i should have asked:

I have a process running against the database which does update,delete and select in one batch. I was wondering, how could i monitor the memory consumption on this process? I.E, buffer cache used, SGA used and java memory used if any. Is there a way to get these statistics?

Also how do i determine free buffer cache, java memory and shared pool on a oracle database?

Apprecaited if someone please take a moment to answer this.

Thanks,
California.
Re: Questions [message #220765 is a reply to message #220747] Wed, 21 February 2007 23:47 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Depending on your version you can. You can also see some things as an O/S user.
Previous Topic: Memory question
Next Topic: performance tuning
Goto Forum:
  


Current Time: Wed Nov 27 03:06:31 CST 2024