Results 1 to 4 of 4

Thread: Memory Layers In Shared Pool

  1. #1
    Junior Member
    Join Date
    May 2006

    Memory Layers In Shared Pool

    In Oracle's shared pool, how many memory layers are there? What are they?

  2. #2
    Expert Member
    Join Date
    Sep 2005

    Re: Memory Layers In Shared Pool

    Quote Originally Posted by Allan Paul
    In Oracle's shared pool, how many memory layers are there? What are they?

    Shared pool consist of 2 memory layers-

    1. Library cache :Library cache contains parsed sql statements, cursor information, execution plans

    2. Data dictionary cache: Data dictionary cache contains user account information, priveleges information,datafile,segment and extent information stored into the data dictionary cache.

    This is very basic question.. if you learning Oracle .. you should konow these kind of things... get a book , download free oracle software and practice....

    Hope this helps..

  3. #3
    Junior Member
    Join Date
    Oct 2006

    Re: Memory Layers In Shared Pool

    Actually there are three layers in the shared pool, these are
    Library cache, Data dictionary cache, and control structures
    as you are well aware with Library & data dictionary cache,
    the control structures consists of locks and latches with the concerned process.

  4. #4
    Junior Member
    Join Date
    Sep 2006

    Re: Memory Layers In Shared Pool

    It was a very nice question placed here which helped me to know the three different layers in the shared pool. I actually was aware of only two layers. This discussion gave me a insight on the third layer also.

  5.  Sponsored Ads


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.