问答题

Inyourproductiondatabase，youhaveobservedthatthedatabaseserverperformancedegradeswheneverthereisaswitchbetweentheloggroups.Onfurtherinvestigation，youfindthatthedatabaseisrunninginARCHIVELOGmodeandthearchivedlogfilesarebeingwrittentothesamediskthatisusedtostoretheredologmembers.Whichtwoactionswouldyoutaketoimprovetheperformanceofthedatabaseserver？（）
A.increasethesizeoftheredologbuffer
B.increasethenumberofredologgroups
C.increasethenumberoflogwriterprocesses
D.increasethenumberofARCnprocesses
E.changetheappropriateLOG_ARCHIVE_DEST_nparametertoplacethearchivedlogfilesinaseparatelocation

A.Onfurtherinvestigation，youfindthatthedatabaseisrunninginARCHIVELOGmodeandthearchivedlogfilesarebeingwrittentothesamediskthatisusedtostoretheredologmembers.Whichtwoactionswouldyoutaketoimprovetheperformanceofthedatabaseserver？（）
A.increasethesizeoftheredologbuffer
B.increasethenumberofredologgroups
C.increasethenumberoflogwriterprocesses
D.increasethenumberofARCnprocesses
E.changetheappropriateLOG_ARCHIVE_DEST_nparametertoplacethearchivedlogfilesinaseparatelocation

你可能感兴趣的试题

问答题

Usersnotifyyouthattheirapplicationisfailingeverytimetheytrytoaddnewrecords.Becauseofpoorapplicationdesign，theactualORAerrormessageisunavailable.Whatmightbetheproblem？（）

A.Theapplicationuserhasexceededtheirundoquota.
B.TheFLASHBACKGUARANTEEoptionissetontheundotablespace.
C.ThetableiscurrentlybeingqueriedbyaFlashbackTransactionQueryoperation.
D.ThetableiscurrentlybeingqueriedbyaFlashbackVersionsQueryoperation.
E.TheRETENTIONGUARANTEEoptionissetontheundotablespace.

问答题

Lastnight，amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase？（）

A.Thedatabaseopensnormally.
B.Thedatabasepromptsforadatabaserecovery.
C.Thedatabasewriterwritestoatracefile，indicatingthatthetemporaryfileisnotfound.
D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.