NEW QUESTION NO: 10
As a DBA configuring a new instance, you want to run a representative workload on the instance and examine the relevant statistics to see whether the cache is underconfigured or overconfigured.Given below is a list of the initialization parameters that would affect the statistics collection and advisories.
1. STATISTICS_LEVEL set to BASIC
2. STATISTICS_LEVEL set to TYPICAL
3. DB_CACHE_ADVICE set to ON
4. TIMED_STATISTICS set to TRUE
Which of the above initialization parameters' values must be set explicitly to get the relevant statistics with minimal impact on the overall database performance?
A. 2 and 3
B. 1, 3, and 4
C. only 2
D. 2, 3, and 4
Answer: C

NEW QUESTION NO: 11
Examine the output of the query given below:
SQL> SELECT mutex_type, location, sum(gets), sum(sleeps) FROM v$mutex_sleep_history GROUP BY mutex_type, location;
MUTEX_TYPE LOCATION SUM(GETS) SUM(SLEEPS)
-------------- ------------------------------------- ---------- ----------- Library Cache kglhdgn1 62 8669586 4538
Library Cache kglget2 2 2016618 24
Cursor Stat kkocsStoreBindAwareStats [KKSSTALOC8] 2975 1
Cursor Pin kkslce [KKSCHLPIN2] 666831 678
Library Cache kgllkdl1 85 3369224 110
Library Cache kglpnal1 90 224199 13
Library Cache kglic1 49 42068 10
Library Cache kglpin1 4 9620087 374
Library Cache kglpndl1 95 2065089 79
9 rows selected.
Which statement is true?
A. Each row in the output represents a SQL statement that had to wait for mutexes.
B. The sum of numbers in the GETS and SLEEPS columns indicates the number of times a mutex/ location was requested by the requesting session while being held by the blocking session.
C. The Cursor Stat and Cursor Pin SLEEPS indicate that the CURSOR_SHARING parameter is set to EXACT.
D. The GETS column shows the number of times a mutex/location was requested by the requesting session while being held by the blocking session.
Answer: D

NEW QUESTION NO: 12
You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and analyze the output of the query that you executed to find the problem.Which is the primary concern?

A. the number of full table scans
B. the number of chained and migrated rows
C. the number of disk sorts
D. the number of rows fetched based on rowid
Answer: B

NEW QUESTION NO: 13
You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the performance SQL on the upgraded database. You want to build the before-change performance data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?
A. the TEST EXECUTE method
B. the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE
C. the COMPARE PERFORMANCE method
D. the EXPLAIN PLAN method
Answer: D

NEW QUESTION NO: 14
View the Exhibit and examine the output for the WRC command-line utility that you executed to estimate the number of replay clients.Identify three prerequisites for completing the replay. (Choose three.)

A. The replay database should be in the RESTRICTED mode.
B. The replay options for think_time_scale and connect_time_scale must be set to 100 each.
C. You need to start at least 21 replay clients on six CPUs to start the replay.
D. The user should be able to use the workload replay package and should have the DBA role.
E. The replay directory must have all the replay files that have been preprocessed.
Answer: C,D,E

NEW QUESTION NO: 15
You observe that suboptimal execution plans for the queries are being generated on a table that previously used less resources. You have collected statistics on these tables two days ago. The optimizer statistics retention period is set to 31 days. You are able to find the timestamp information about statistics update from the DBA_TAB_STATS_HISTORY view. Because it is a frequently queried table, you would like the optimizer to generate better plans.
Which action would enable you to use the previous set of statistics on the objects that may lead to better execution plans?
A. restoring statistics from statistics history up to the desired time
B. deleting all AWR snapshots collected after the time of desired statistics collection
C. setting the OPTIMIZER_PENDING_STATISTICS parameter to TRUE to use the previous version of statistics
D. applying the flashback table technique until the time of desired statistics collection
Answer: A

NEW QUESTION NO: 16
After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit. What is the significance of the Benefit(%) column in the Exhibit?

A. It gives the maximum reduction in the number of input/output (I/O) operations.
B. It produces better query plans if the recommendation is implemented.
C. It gives the maximum reduction in resource usage if the recommendation is implemented.
D. It gives the maximum reduction in database elapsed time if the recommendation is implemented.
Answer: D

NEW QUESTION NO: 17
What indicates that the rate of writing data blocks to the disk is very slow?
A. increasing number of buffer busy waits
B. waits on latch: cache buffers chains event
C. very high cache-hit ratio
D. increasing number of free buffer waits
Answer: D

NEW QUESTION NO: 18
Which two statements are true about the database buffer cache? (Choose two.)
A. A buffer containing a block that is identical to the block on disk is called free buffer.
B. A buffer containing a block that is being accessed by a process is called dirty buffer.
C. A buffer can be written to by many processes at the same time.
D. A buffer available to be overwritten with a different database block at any time is called a dirty buffer.
E. A buffer can contain a different version of a block that is available in a different buffer of the same cache.
Answer: A,E

NEW QUESTION NO: 19
The OS administrator in your company informed you about the upgrade of storage to new disk controllers and hard disks. You want to test if the new I/O devices are capable of handling the I/O load. The database is using Automatic Storage Management(ASM) for storage. To test the throughput and other I/O metrics, you performed IO calibration from the Enterprise Manager but you notice that the IO calibration job failed.
To see the details of the error, view the Exhibit.

How you can resolve the error?
A. Set FILESYSTEMIO_OPTIONS to DIRECTIO and DISK_ASYNCH_IO
B. Set FILESYSTEMIO_OPTIONS to SYNCH and DISK_ASYNCH_IO to FALSE.
C. Set FILESYSTEMIO_OPTIONS to NONE and DISK_ASYNCH_IO to FALSE.
D. Set FILESYSTEMIO_OPTIONS to ASYNCH and DISK_ASYNCH_IO to TRUE.
Answer: D

NEW QUESTION NO: 20
Your database has the ACCTG service configured for an accounting application that runs on a middle tier.
The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled tracing at the service level by executing the following command:
SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('ACCTG');
Which statement is true?
A. A trace file is created for each session that uses the service, regardless of the module and action.
B. The trace file would not be created because the module name is not specified.
C. A single trace file would be created for all the sessions for the service.
D. Three trace files would be created for the three modules in the application.
Answer: A