Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
An application accesses a small lookup table frequently. You notice that the required data blocks are
getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)
