單項(xiàng)選擇題

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）

A. 20% SGA 80% PGA
B. 25% SGA 75% PGA
C. 50% SGA 50% PGA
D. 75% SGA 25% PGA
E. 80% SGA 20% PGA

你可能感興趣的試題

In a Database Replay workload capture， what client request information is gathered？（）

A. SQL text
B. Shared server requests （Oracle MTS）
C. Bind variable values
D. Information about transactions
E. Remote DESCRIBE and COMMIT operations

單項(xiàng)選擇題

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）

A. Initiate an incomplete recovery operation using RMAN.
B. Copy the table from a development database.
C. Advise the user to rekey the data.
D. Perform a Flashback Drop operation.
E. Perform a Flashback Recovery operation.

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）

你可能感興趣的試題

In a Database Replay workload capture， what client request information is gathered？（）

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）

In a Database Replay workload capture， what client request information is gathered？（）

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）