Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration?

You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file systems would be shared using Oracle Cluster File System.

After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC database. Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration? (Choose six.)

You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file systems would be shared using Oracle Cluster File System.

After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC database. Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration? (Choose six.)

A.
Interconnect latency

B.
Instance recovery time

C.
Services with applications that use external tables

D.
Services with applications that truncate large tables

E.
Services with applications using local context variables

F.
Services with query-intensive applications relying on full table scans

G.
Services with insert-intensive applications that use Oracle sequences for index keys

H.
Services with applications that have occasional queries, using index access on modestly sized tables

I.
Services with insert-intensive applications that generate their own keys without Oracle sequences



Leave a Reply 0

Your email address will not be published. Required fields are marked *