单项选择题
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）
A. recycle buffer cache
B. large pool
C. streams pool
D. keep buffer cache
E. redo log buffer
点击查看答案&解析
相关考题
-
单项选择题
FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelong-runningqueriesthatconsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）
A. set the CPU time per call in the users profile
B. set the CPU time per session in the users profiles
C. set the TIMED_STATISTICS parameter to TRUE in the parameter file
D. set the CPU levels for the users’ group using Resource Manager -
多项选择题
Youlosttheindextablespaceinyourdatabase.Youdecidedtore-createtheindextablespaceandtheindexesinthetablespace.Whatmethodscanyouusetore-createtheindexes？（）
A. SQL scripts
B. Recovery Manager （RMAN） script
C. Data Pump
D. SQL*Loader
E. Flashback database -
单项选择题
You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）
A. LARGE_POOL_SIZE
B. DB_CREATE_FILE_DEST
C. LOG_ARCHIVE_DEST
D. CONTROL_FILES
E. LOG_ARCHIVE_FORMAT
F. DB_BLOCK_SIZE
