You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur.Which four statements would be true if you use bind variables for these queries? (Choose four.)
Examine an extract from a PGA Memory Advisory for your database:Which two inferences are correct? (Choose two.)
Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.Examine this list of possible steps:1. Create a fixed baseline.2. Create a baseline template.3. Create a new moving window baseline.4. Increase the retention period default value to 30 days.5. Increase the size of the existing moving window baseline to 30 days.6. Create warning and critical alerts for the relevant metrics.7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.Which option represents the required steps in the correct order? (Choose the best answer.)
You execute this query twice in a session:Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.Which two statements are true? (Choose two.)
Which three statements are true about using Real-Time Database Operations? (Choose three.)
For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)
