santhoshreddy podduturi, November 10, 2016 - 6:32 am UTC
The SGA,PGA and UGA Takes space on primary area or secondary area?
November 11, 2016 - 8:22 am UTC
primary ? secondary ?
santhoshreddy podduturi, November 16, 2016 - 7:27 am UTC
Primay =RAM
Secondary=Where Data Stored Permanently(Hard Disk)
November 17, 2016 - 2:19 am UTC
All the areas (PGA, SGA etc) are memory based. If you *exceed* an allowable threshold, then they will spill to disk.
Who *does* that depends on the area, eg
PGA - *we* (the database) decides when you spill to temp tablespace
SGA - the OS will decide if it needs to swap it out to disk.
But the SGA is predominantly fixed in size, and you should set it so that it *never* gets swapped out.