未分类题

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

【参考答案】

B, E