Tag Archives: performance

A user complains about poor database performance. You suspect that the user's session is waiting for

A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete.You want to verify this.Which two views may reveal for what the user’s session is currently waiting? (Choose two.) A. V$SYSTEM_EVENT B. V$SESSION C. V$SESSION_WAIT D. V$SESSION_EVENT E. V$SESSION_WAIT_CLASS Correct Answer: C,D

What is true about non-equijoin statement performance? (Choose two.)

What is true about non-equijoin statement performance? (Choose two.) A. Table aliases can improve performance B. The join syntax used makes no difference to performance C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax D. The BETWEEN condition always performs less well than using the >= and <= conditions E. The BETWEEN condition… Read More »

After reviewing the overall performance metrics of their workforce, a company identified that their technicians

After reviewing the overall performance metrics of their workforce, a company identified that their technicians are frequently arriving at jobs late.They want to use reoptimization to reduce the amount of lateness and improve their technicians’ on-time arrival.Which setting is required to do this? A. Enable Reoptimization within the routing plan, then select “Reduce overdue.” B. Enable Reoptimization within… Read More »

Which option provides the best performance for running OTLP workloads in Oracle Cloud Infrastructure

Which option provides the best performance for running OTLP workloads in Oracle Cloud Infrastructure (OCI)? A. OCI Autonomous Data Warehouse B. OCI Virtual Machine Instance C. OCI Dedicated Virtual Host D. OCI Autonomous Transaction Processing Correct Answer: D https://docs.oracle.com/en/cloud/paas/atp-cloud/index.html

You can scale up the computer resources for your Oracle WLS for OCI domain to increase performance, or

You can scale up the computer resources for your Oracle WLS for OCI domain to increase performance, or you can scale down the computer resources to reduce costs. When you do scale up or scale down, which three properties of the compute instance will change?Response: A. instance’s private IP addresses B. instance’s public IP addresses C. volume attachments… Read More »

You want to collect and analyze performance characteristics of your Java application. Which action correctly

You want to collect and analyze performance characteristics of your Java application. Which action correctly accomplishes this?Response: A. Use REST API to collect JFR data for the last 1 minute. B. Collect JFR data for the last 1 hour using the UI. C. ssh Into the application VM to collect JVM heap dump. D. Use the PSM CLI… Read More »

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean? A. The SQL statement completed its execution. B. The SQL statement is executing. C. The SQL statement is queued. D. The SQL statement did not complete either due to an error. Correct Answer: C https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm