A customer asked you about Database Time (DB Time). Which are two correct statements you would include in your description of it?
Answer : B,C
Which two would automatically create an entry inV$SQL_MONITOR?
Answer : C,F
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789
Which four use cases could Database Replay be used to test for database performance changes?
Answer : B,C,D,E
A customer has database performance issues within their Oracle Real Application Cluster.
What is the next step?
Answer : E
Which issue can be avoided by configuring the PCTFREE parameter?
Answer : A
Which are three use cases in which SQL Performance Analyzer can be used?
Answer : B,C,E
DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the
Operations Team. What would you implement to resolve this problem?
Answer : B
You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?
Answer : D
For which use case would you utilize SQL Performance Analyzer and optimizer pending statistics functionality?
Answer : A
To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases?
Answer : C,D
Which option would you use to validate performance when migrating an Oracle Database from HPUX Itanium to Oracle Linux 6 architecture?
Answer : C
Reviewing Automatic Workload Repository (AWR) reports for CPU and I/O exceptions, the time model displays SQL execution elapsed time as a major component of DB Time. Which two are next steps to diagnose the problem further?
Answer : C,D
When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously?
Answer : E
Reference: http://docs.oracle.com/html/E25494_01/dbrm008.htm
Which statement is true about implementation of an Oracle Database Performance and
Tuning solution?
Answer : E
Which one is a type of user session and client request supported by Database Replay?
Answer : C
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41481/dbr_capture.htm#RATUG115