![]() Garbage collection of In- Execution area is done as soon the output of the above queries is received. This area is used to keep user session information whenever the user does DML operations like SELECT, INSERT, DELETE or UPDATE. Every user creates its own session on Oracle server which has its own SQL area. ![]() The area is allocated to SQL variables bind information and runtime memory structure. The PGA memory structure can be classified as below: PGA has one to one relations with processes. Furthermore, PGA helps to localize the memory location to the dedicated User the SQL statements executed by the user use this memory space. ![]() In shared server architecture the sort area is in SGA while in dedicated server the area is in PGA. The configuration of the PGA changes with the dedicated server and shared server architecture. To elaborate further, it's the memory allocated to every server process or the background process running in the memory. PGA: This area is always controlled by main process for which it's spun. In continuation of my previous article, here we will go through the second part of the memory structure of the Oracle architecture which is known as PGA (Program Global Area)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |