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()
第1题:
显示第一个字符为“A”的内存变量的命令是()
第2题:
Which statement is true about the Manageability Monitor (MMON) background proces()
第3题:
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()
第4题:
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()
第5题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第6题:
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()
第7题:
PMON
SMON
MMNL
MMAN
MMON
第8题:
Setting a nonzero value for SGA_TARGET
Configuring Automatic Shared Memory Management
Configuring Automatic Memory Management
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
None of the above
第9题:
MMAN
PMON
MMON
MMNL
第10题:
Run the SQL Access Advisor
Run the Memory Advisor for the sga.
Run the Memory Advisor for the pga.
Run the Memory Advisor for the shared pool.
Run the Memory Advisor for the buffer cache
第11题:
It transfers statistics from memory to disk at regular intervals.
It coordinates the rebalance activity for disk groups when ASM is used.
It communicates with the Automatic Storage Management (ASM) instance on behalf of the database Instance.
It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
第12题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第13题:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()
第14题:
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
第15题:
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?()
第16题:
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently, a lot of insert activity is taking place in the database, and the memory structures are allocated according to the database workload. As the workload reduces, you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged?()
第17题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()
第18题:
In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()
第19题:
Run the SQL Access Advisor.
Run the Memory Advisor for the sga.
Run the Memory Advisor for the pga.
Run the Memory Advisor for the shared pool.
Run the Memory Advisor for the buffer cache.
第20题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第21题:
set SHARED_POOL_SIZE to zero
set STATISTICS_LEVEL to BASIC
set SGA_TARGET to a non-zero value
set DB_CACHE_SIZE to a non-zero value
set STATISTICS_LEVEL to TYPICAL or ALL
第22题:
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
第23题:
The User Global Area (UGA) is not configured.
The sessions were started using the login name SYS.
The sessions are running in the Automatic Shared Memory Management mode.
The sessions are running in the automatic Program Global Area (PGA) memory management mode.
第24题:
log buffer
Java pool
Large pool
Fixed SGA
Shared pool
Streams pool
Keep buffer cache
Database buffer cache