1 Reply Latest reply: May 25, 2010 9:55 PM by 775212 RSS

    use of private sql area

    773338
      what is the purpose of having private sql area in library cache
        • 1. Re: use of private sql area
          775212
          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.

          Regards
          GZ