Examine the partial TKPROF output for an SQL statement:Which two inferences can definitely be made from this output? (Choose two.)
In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert.What is the outcome? (Choose the best answer.)
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.How would you achieve this? (Choose the best answer.)
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.You execute the command to enable tracing of the ORCL1 service:Which two statements are true? (Choose two.)
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.Which three objectives can be achieved by the Resource Manager? (Choose three.)
