Q154. Automatic Shared Memory Management is disabled for one of your database instances
Q154. Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the shared pool.
C. Run the SQL Tunning Advisor.
D. Run the Memory Advisor for the Program Global Area.
E. Run the Memory Advisor for the System Global Area.
Xem thêm:
- Q7. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?
- Q136 Which two statements are true about Database Instances and Real Application Clusters (RAC)
- Rman Demo Recovery Table Point in time Oracle database 19c
- Tên miền (domain) là gì?
- Q18. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
Bài viết cùng chủ đề:
-
Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?
-
Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?
-
Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB
-
Q169. Examine the command for creating pluggable database PDB2 in container database CDB2
-
Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in
-
Q167. Which two are true about automatic block repair?
-
Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?
-
Q165. Which two are true about server-generated alerts?
-
Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
-
Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?
-
Q162. Which three methods can be used for heap table data migration after upgrading a database?
-
Q161. Which three are true about opatchauto?
-
Q160. Which three are true about Automatic Workload Repository (AWR)?
-
Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
-
Q158. Which three are true in Oracle 19c and later releases?
-
Q157. Which two are true about RMAN duplexed backup sets?
