Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance. What would be your next step to improve performance? ()
第1题:
术语翻译:Weight memo()
第2题:
显示第一个字符为“A”的内存变量的命令是()
第3题:
A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
第4题:
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()
第5题:
Which statement is true about the Manageability Monitor (MMON) background proces()
第6题:
下面对Memo组件Memo1操作正确的语句是()
第7题:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()
第8题:
You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components?()
第9题:
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
第10题:
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page?()