Shared pool
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Shared pool

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Shared pool

    Hi,
    How is the data written into Library cache and Dictionary cache ?
    Is it the server process ???

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Re: Shared pool

    Originally posted by bang_dba
    Hi,
    How is the data written into Library cache and Dictionary cache ?
    Is it the server process ???
    It's not the data that is written to Library Cache, it's the parsed SQL, procs, etc. Data are written to Buffer Cache.

  3. #3
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    Yes, server processes does that.
    Thanks and Regards,
    Satheesh Babu.S
    Bangalore

  4. #4
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    Dict cache contains Data dictionary information cached from the Data dictionary tables. Which is loaded when the details required to parse/execute the query from Disk(Dict tables) to Memory(Dict cache)
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

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