多项选择题 In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）

单项选择题 Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）

单项选择题 View the Exhibit and examine the characteristics of the USERS tablespace.  You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.  Which advisory component would you refer to， in order to find information about table fragmentation？（）