Author Topic: Oracle DBA Question 44  (Read 54 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 44
« on: April 19, 2009, 12:55:11 PM »
Question:
You decided to use multiple buffer pools in the database buffer cache of your database . You set the sizes of the buffer pools with the DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE parameters and restarted your instance.
What else must you do to enable the use of the buffer?

A. Re-create the schema objects and assign them to the appropriate buffer pool.
B. list each object with the appropriate buffer pool initialization parameter.
C. Shut down the database to change the buffer pool assignments for each schema object.
D. Issue the ALTER statement and specify the buffer pool in the BUFFER_POOL clause for the schema objects you want to assign to each buffer pool.

Answer: D

Techronnati | where technology never sleeps

Oracle DBA Question 44
« on: April 19, 2009, 12:55:11 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
54 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.