单项选择题
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.
What action would you take to achieve this task（）
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
相关考题
-
单项选择题
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）
A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management （ASM） as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer （OUI）.
D.You are using General Purpose template and not the Custom Database template to create the database -
多项选择题
WhichstatementsaretrueregardingtheOracleDataPumpexportandimportoperations（）
A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported -
多项选择题
Whichstatementsaretrueaboutcheckpointing（）
A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
