A database instance is suffering poor I/O performance on two frequently accessed large tables.No Big Table caching occurs in the database.Examine these parameter settings:Which are two actions either one of which will allow Big Table caching to occur?
What is the right time to stop tuning an Oracle database?
You use SQL Tuning Advisor to tune a given SQL statement.The analysis eventually results in the implementation of a SQL Profile.You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.Which two statements are true? (Choose two.)
You must configure and enable Database Smart Flash Cache for a database.You configure these flash devices:/dev/sdj with size 128G/dev/sdk with size 64GExamine these parameter settings:What must be configured so that the database uses these devices for the Database Smart Flash Cache?
This error occurred more than four hours ago in the database:ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMITYou want to know which process and query were at fault.Which two views should you use for this purpose? (Choose two.)
Database performance degraded between 23:15 and 23:30 for the last three nights. The AWR snapshot interval is one hour. The ADDM report contains nothing about this performance problem.With which tool can you further analyze this problem?
