-
Shared SQL/ Private SQL
Which statement about the shared SQL or private SQL area of the library cache is true?
- The shared SQL are is associated with only one private SQL area
-The shared SQL area is stored in the library cache in the shared pool
- The shared SQL area is allocated at instance startup
- Only one private SQL area can be allocated at a time
-
Originally Posted by girl
Which statement about the shared SQL or private SQL area of the library cache is true?
- The shared SQL are is associated with only one private SQL area
- The shared SQL area is stored in the library cache in the shared pool
- The shared SQL area is allocated at instance startup
- Only one private SQL area can be allocated at a time
This one! (points to the right answer with a finger)
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
This one! (points to the right answer with a finger)
That's funny, I was thinking of the same answer...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|