單項選擇題

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）

A.the value of the UNDO_RETENTION initialization parameter
B.the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
C.the online redo log files size
D.the number of redo log members in a group

你可能感興趣的試題

單項選擇題

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）

A. Oracle Enterprise Manager
B. The V$LOG view
C. The V$LOGFILE view
D. The V$FLASHBACK_DATABASE_LOGS view

單項選擇題

In which scenario will you create a sorted hash cluster？（）

A. if the application uses queries joining tables only occasionally
B. if the full table scan is executed often on only one table of the clustered tables
C. if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
D. when you want the data to be returned automatically in the chronological order

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）

你可能感興趣的試題

In which scenario will you create a sorted hash cluster？ （）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）

In which scenario will you create a sorted hash cluster？（）