|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#33. You executed the following SQL command in your production database. The results of this command are displayed in the Exhibit: SQL> SELECT shared_pool_size_for_estimate AS pool_size, estd_lc_size, estd_lc_time_saved FROM v$shared_pool_Advice;
View the Exhibit.
Which statements are true regarding the result? (Choose all that apply.)
Show comments for this question (0)
Add comments
Link to this question
|
|
#39. In your production environment
• the database is running in ARCHIVELOG mode
• there are three online redo log groups
• there are two members in each group that are placed on different disks
• the archived redo log files are placed on disks other than the disks where the members of online redo log groups are placed
While performing transactions, users complain that transactions take a long time to complete. On investigation, you find that the STATUS column of the V$LOG data dictionary view shows the value ACTIVE, for two of the online redo log groups, thus causing the performance to be degraded.
Which action would you perform to increase the performance?
Show comments for this question (0)
Add comments
Link to this question
|
|
#40. View the Exhibit and compare the baseline and current data dictionary cache statistics in statspack reports.
The DBA had collected baseline statistics by using statspack six months ago. For the purpose of performance tuning, the DBA collects the current statistics. The database system does not have a heavy insert load. What recommendation would you make on the basis of the statistics provided in the Exhibit?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.071
|
Server date 06:26 02-12-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump