SQL Area vs. Library Cache
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL Area vs. Library Cache

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    When I query v$sgastat, I have the following,

    POOL NAME BYTES
    ----------- -------------------------- ----------
    ...
    shared pool library cache 758752
    shared pool sql area 1197660
    ...

    I thought sql area is part of library cache but its size is larger than library cache. Am I wrong on this?

    Thanks


  2. #2
    Join Date
    Oct 2000
    Posts
    467
    bioth library cache and sqlarea are part of shared pool.
    The value only shows the break up of bytes used.
    free memory will tell you the available space for shared pool using this query :-

    select * from v$sgastat where pool = 'shared pool'
    and name like 'free%'

    Vinit

  3. #3
    Join Date
    Apr 2001
    Posts
    257
    >> bioth library cache and sqlarea are part of shared pool.

    But is SQLArea part of Library Cache? Or they are completely separated from each other?

    Thanks

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by a128
    >> bioth library cache and sqlarea are part of shared pool.

    But is SQLArea part of Library Cache? Or they are completely separated from each other?

    Thanks
    Both the Llibrary cache and the SQL area are allocated from the Shared Pool.


  5. #5
    Join Date
    Mar 2002
    Posts
    171
    Julian, I am afraid whether your answer is convincing for a128. a128 specifically asked whether the two are seperate logical memory buffers in the Shared Pool. a128 didn't mean to ask whether they were a part of the Shared Pool. I am eager to know the answer too.

    I my knowledge, they are two independent buffer allocations inside the Shared Pool. While SQL Area deals with the SQLs, library cache deals with the load of the data dictionary, parsed packages and triggers etc. Pls correct me anyone if my understanding is wrong.

    [Edited by dbafreak on 03-09-2002 at 12:27 AM]

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You are right, they are two independent buffer allocations inside the Shared Pool.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width