Which two statements are true about disabling Automatic Shared Memory Management (ASMM)? (Choose two.)
Which procedure gathers statistics that are always used in the generation of any execution plan?
Examine these commands, which execute successfully:SQL> ALTER SYSTEM SET AWR_PDB_AUTOFLUSH_ENABLED=TRUE;SQL> EXEC dbms_workload_repository.modify_snapshot_settings(interval=>60);Which statement is true?
During which application lifecycle phase do you take baselines?
The application provider has given full indications regarding the procedure to collect statistics.To reduce the space used in the SYSAUX tablespace, you want to prevent the Optimizer Statistics Advisor from running.Which method will allow you to do this?
Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resourceWhich file has additional information about this error?
