Home » RDBMS Server » Server Administration » Private SQL Area
Private SQL Area [message #246790] Fri, 22 June 2007 00:33 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Hi,

What is the difference between Private SQL Area in Library cahce & Private SQL Area in PGA?

Why Private SQL Area exists in two memory regions?

Thanks..
Re: Private SQL Area [message #246796 is a reply to message #246790] Fri, 22 June 2007 00:51 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Concepts, Chapter 8 "Memory Architecture",
- section "Overview of the System Global Area", subsection "Shared Pool"
- section "Overview of the Program Global Areas", subsection "Content of the PGA"

Regards
Michel
Previous Topic: thread# in v$log
Next Topic: Granting Privileges........
Goto Forum:
  


Current Time: Sat Nov 30 06:47:47 CST 2024