單項選擇題

You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA

你可能感興趣的試題

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes

單項選擇題

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache