Which two statements are true about cursor sharing?
You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?
SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARG£T is not set.
Which two statements are true?
A)
B)
C)
D)
E)
F)
G)
Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on sales improve?
Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:
Now, examine these attributes displayed by querying dba_tables:
Finally, examine these parameter settings:
Which two must both be used to reduce these excessive waits?
You need to transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?
