Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: April 18, 2017 - 10:36 am UTC

Last updated: April 21, 2017 - 1:22 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi Team,

In which case Oracle uses Swap memory.

If we set Memory_target=10G parameter Oracle allocates SGA + PGA which that 10G only.


Thanks & Regards
Krishna.

and Connor said...

Like *any* program, swap will be used when demand for memory exceeds available memory.

Dont forget that each foreground process (connection) also consumes memory, and memory_target is not a *fixed* limit on memory consumption by Oracle. From the docs:

"Total memory usage can grow beyond the value of MEMORY_TARGET. For example, memory is allocated to PL/SQL tables and varrays regardless of the value of MEMORY_TARGET as long as memory is available at the operating system level."


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, April 20, 2017 - 12:00 pm UTC


In some cases, if memory goes beyond memory_target and uses OS memory then what is the use of setting memory_target & memory_max_target parameters in parameter file.
Connor McDonald
April 21, 2017 - 1:22 am UTC

Because we'll control stuff that we *can* control, eg, how many blocks of data we cache in the buffer cache, how many structures and sql statements we'll hold in the sga etc.


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.