The size of the shared pool is too small.
Cursors are not being shared.
A large number COMMITS are being performed.
There are frequent logons and logoffs.
The buffers are being read into the buffer cache, but some other session is changing the buffers.
第1题:
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement:SQL>SELECTname,value,isdefault2FROMv$parameter3WHEREnameLIKE’%size%’;TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply?()
A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1G
B.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1G
C.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGA
D.ThevaluesoftheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.
E.NominimumlimitsareimposedontheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameters.
F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.
第2题:
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.()
A. Missing or stale histogram statistics
B. Undersized shared pool
C. High clustering factor for the indexes
D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E. Oversized buffer cache
第3题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
A. The collection level for the AWR should be set to BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
第4题:
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
第5题:
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()
第6题:
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.Which three findings would you get from the report?()
A. It detects any configuration change that caused a performance difference in both time periods.
B. It identifies any workload change that caused a performance difference in both time periods.
C. It detects the top wait events causing performance degradation.
D. It shows the resource usage for CPU, memory, and I/O in both time periods.
E. It shows the difference in the size of memory pools in both time periods.
F. It gives information about statistics collection in both time periods.
第7题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
第8题:
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
第9题:
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()
第10题:
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.()