| oracle9i perf. tuning questions ?? [message #171017] |
Sun, 07 May 2006 21:36  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
what are the answers ??
367. You have used the ALTER command to set the DB_CACHE_ADVICE parameter to READY. What is now happening in the instance?
A. Memory has been allocated in the shared pool for cache advice buffers.
B. CPU utilization will significantly increase because Oracle is collecting more detailed statistics about the buffer cache.
C. The buffer cache hit ratio will now increase.
D. The V$DB_CACHE_ADVICE view is now populated.
184. Which two statements are true regarding the use of DB_CACHE_ADVICE init.ora parameter? (Choose two)
A. Setting the parameter to READY reserves space in the buffer cache to store information about different buffer cache sizes, but no CPU overhead is incurred.
B. Setting the parameter to READY reserves space in the shared pool to store information about different buffer cache sizes, but no CPU overhead is incurred.
C. Setting the parameter to ON reserves space in the buffer cache to store information about different buffer cache sizes, and CPU overhead is incurred as statistics are collected.
D. The V$DB_CACHE_ADVICE view contains information that predicts the estimated number of physical reads for different cache sizes for each buffer cache setup in the SGA.
185. Which three statements are true with respect to has clusters? (Choose three)
A. Full table scans are generally faster on cluster tables than on non-clustered tables.
B. Hash clusters may be desirable when the number of key values is predictable and key values are evenly distributes.
C. If tables in a hash cluster require more space than the initial allocation for the cluster, performance degradation can be substantial because overflow blocks are required.
D. Storing a single table in a hash cluster can be useful regardless of whether the table is joined frequently with other tables or not, provided other criteria for choosing a hash cluster are met.
346. You have been seeing poor performance for inserts into a new table.
You queried V$WAITSTAT and V$SYSTEM_EVENT and determined that there is free list
contention in your database.
Next, you identified the segments by joining the DBA_SEGMENTS table and V$SESSION_WAIT
view to identify the file and block where waits are occurring.
What is the next step you should take?
A. If the file and block identify a data block within a table, consider increasing the number of free lists on the table using the ALTER TABLE command and specifying the FREELISTS clause.
B. If the file and block identify a data block within a table, consider increasing the number of free lists on the table using the ALTER TABLESPACE command and specifying the FREELISTS clause in the default storage clause.
C. If the file and block identify a segment header for a table, consider increasing the number of free lists on the table using the ALTER TABLE command and specifying the FREELISTS keyboard in the storage clause.
D. If the file and block identify a segment header for a table, consider increasing the number of free lists on the table using the ALTER TABLESPACE command and specifying the FREELIST clause in the default storage clause.
235. To provide more free lists for a number of your database segments, what is one of your options?
A. Modify them with the INSERT_ _FREELIST command.
B. Drop and re-create them with the required FREELIST value.
C. Change the default storage parameter of the tablespace(s) where they are stored.
D. Modify the FREELIST_LIMIT parameter in your installation file and restart the instance.
337. How to set the OPTIMIZER_MODE for minimizing total response time?
A. RULE
B. ALL_ROWS
C. FIRST_ROWS_n
D. FIRST_ROWS
347. You want to enhance performance of the Database Optimizer to minimize total response time, thereby increasing overall throughput of batch process.
Which choice identifies the best optimizer mode setting for meeting this requirement?
A. RULE
B. ALL_ROWS
C. FIRST_ROWS
D. FIRST_ROWS_n
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
