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 sizes
C.
using reverse key indexes
D.
uniform and large extent sizes
E.
automatic segment space management
F.
smaller extent sizes
You are managing RAC database with policy managed services. The database is started by using an SPFILE.
Which two statements are true regarding initialization parameters In a RAC environment?
G.
All initialization parameters must have identical settings on all instances.
H.
All instances In the cluster database use the same spfile.
I.
To change values for initialization parameters for an instance, you must log In to that instance.
J.
All initialization parameters for all instances can be changed from any instance In a RAC database.
There are two questions. The answer on the first one is correct. The second one should be G & I
http://isu.ifmo.ru/docs/doc112/rac.112/e10718/admin.htm#BCEFICEE
H & J are correct
H & J are absolutely correct