单项选择题
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
A.recovery catalog
B.Oracle Enterprise Manager Repository
C.Automatic Workload Repository （AWR）
D.Oracle 10g Enterprise Manager Grid Control
E.Automatic Database Diagnostic Monitor （ADDM）
相关考题
-
单项选择题
Thewarningandcriticalthresholdvalueshavebeensetto85%and97%，respectively，foroneofthetablespaces.Thecurrenttablespacespaceusageis54%.Youmodifythewarningthresholdtobe50%andcriticalthresholdtobe53%inDatabaseControl.Whichstatementistrue？（）
A.The new setting would be applied but no alerts would be raised immediately.
B.The new setting would be applied and an alert would be raised immediately.
C.The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
D.The new setting would cause an error because the tablespace space usage is more than the specified threshold value. -
多项选择题
Intheparameterfileofyourproductiondatabase，theFAST_START_MTTR_TARGETparameteris setto300tooptimizeinstancerecovery.Whileobservingtheperformanceofthedatabaseduringinstancerecovery，youfindthattheredologfilesarenotsizedproperlytosupportthisactivity.Whichtwosourcescouldyouusetodeterminetheoptimalsizeoftheredologfiles？（）
A.the V$LOG view
B.the V$DBFILE view
C.the V$LOGFILE view
D.the V$INSTANCE_RECOVERY view
E.Oracle Enterprise Manager Database Control -
多项选择题
YourproductiondatabaseisrunningintheARCHIVELOGmodeandtheARCnprocessisfunctional.Youhavetwoonlineredologgroups.Whichthreebackgroundprocesseswouldbeinvolvedwhenalogswitchhappens？（）
A.archival
B.log writer
C.database writer
D.system monitor
E.process monitor
F.change tracking writer
