Which component of the SGA stores parsed SQL statements is used for process sharing?()
第1题:
Which is the correct description of a pinned buffer in the database buffer cache()
第2题:
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()
第3题:
下面哪些等待事件表示空闲等待?()
第4题:
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()
第5题:
The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.
第6题:
You observe that database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine the required size of the database buffer cache?()
第7题:
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario()
第8题:
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()
第9题:
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()
第10题:
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()