Examine the following output: [oracle@gr5153 ~]$ srvctl add service -d RACDB -s ERP -g POOL1 -c UNIFORM -y manual [oracle@gr5153 ~]$ srvctl start service -d RACDB -s ERP [oracle@gr5153 ~]$ crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE…
You need to set up a three-instance RAC database. The data files and fast recovery area will be stored in ASM diskgroups called +DATA and +FRA, respectively. The ASM disk groups will be mounted on all ASM instances. Which are…
You notice that there is a very high percentage of wait time for the enq: HW:contention event in your RAC database that has frequent insert operations. Which two recommendations may reduce this problem? A. shorter transactions B. increasing sequence cache…
Which three statements are true about services and transparent application failover (TAF)? A. If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs. B. The TAF setting on…
Which two statements are true regarding undo management in the RAC environment? A. You can use Automatic Undo Management (AUM) in some of the instances and manual undo management in the rest of the instances in a RAC database. B.…
What does a high gc current block busy event value indicate? A. Access to cached data blocks was delayed because they were busy either in the remote or the local cache. B. A large number of requested blocks were not…
You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations. Which recommendation would you make to reduce this problem? A. shorter transactions B.…
You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What are two possible reasons for these wait events? A. The wait events…
When creating an Oracle Cluster database using DBCA, the "Memory size [SGA and PGA]" field is supplied a value of 2000 MB. Identify the default Block Size used for the database. A. 2 KB B. 4 KB C. 8 KB…
Examine the following details from the AWR report for your three-instance RAC database: Which two inferences are correct? A. There are a large number of requests for cr blocks or current blocks currently in progress. B. Global cache access is…