This content has been marked as final. Show 1 reply
You can lookup the information from the concept guide:
Oracle represents each SQL statement it runs with a shared SQL area and a private SQL area. Oracle recognizes when two users are executing the same SQL statement and reuses the shared SQL area for those users. However, each user must have a separate copy of the statement's private SQL area.
Oracle allocates a private SQL area on behalf of the session. The location of the private SQL area depends on the type of connection established for the session. If a session is connected through a dedicated server, private SQL areas are located in the server process's PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA which means the library cache.