Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Understanding swaping in respect to Instance

user8983130Aug 29 2020 — edited Sep 3 2020

Dear All,

I am having some confusion regarding OS(Redhat 7) swaping in respect to oracle database instance:

  1. db buffer cache is the biggest chunk of memory region in SGA,which used for data block read from disk. When, buffer cache is full and  for allocation of new data block,when old buffer getting aged out,Will this consider as swapping??

Or

2.In PGA, we allocate small memory region in compare to SGA.However, each Oracle process(which is also OS process) has their own PGA,when there is some interchange of data between PGA and temporary TBS,that will consider as swapping??? 

Or

3,Swapping is consider when OS related memory age out from memory and  write in OS swap space??

Regards,

Comments
Post Details
Added on Aug 29 2020
20 comments
2,151 views