Re: What is the real SGA size?

  • From: David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 26 Apr 2012 08:17:44 +0100

While I don't use show SGA myself, I'd expect it to be accurate.
In terms of data dictionary views, I beleive that you should be using
V$MEMORY_DYNAMIC_COMPONENTS and
V$SGA_DYNAMIC_COMPONENTS.

My understanding is that the older views do not reflect the dynamic changes
that are made to the component sizes these days.

Dave


--
//www.freelists.org/webpage/oracle-l


Other related posts: