A.提高数据访问速度
B.增加程序可用内存的大小
C.在可不丢失数据的内存中存储数据
D.为操作系统内核增加可用的内存容量
第1题:
A.Thread memory is pre-allocated up to thread_cache_size for performance
B.Each connection may have its own per-thread memory allocations
C.Global memory resources are allocated at server startup
D.Each thread allocates memory from a global pool
第2题:
Which of the following is a function of the XceL4 Cache?()
第3题:
Upgrading which of the following components in a server has the GREATEST affect on virtualization?()
第4题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()
第5题:
计算机内的存储器呈现出一种层次结构的形式,即()三层结构。
第6题:
The distribution of data written across all the memory DIMMs and the L1 cache
The distribution of data written across all the memory DIMMs in one bank
The distribution of data written across all the memory DIMMs and the processor
The distribution of data written across all the memory DIMMs and the L2 cache
第7题:
Library cache
Row cache
Session UGA
Buffer cache
第8题:
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.
第9题:
提高数据访问速度
增加程序可用内存的大小
在可不丢失数据的内存中存储数据
为操作系统内核增加可用的内存容量
第10题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
第11题:
Cache-Memory-disk
Memory-Cache-disk
CPU-Cache-disk
CPU-Cache-Memory
第12题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第13题:
Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SZIE
F. DB_KEEP_CACHE_SIZE
第14题:
Which of the following defines memory interleaving?()
第15题:
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()
第16题:
Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY, what is its effect? ()
第17题:
Cache memory的作用是()。
第18题:
It places frequently accessed data close to the processor to help deliver faster performance.
It replaces L3 cache memory.
It speeds up processor performance by purging the current set of instructions and freeing them up to work on the next set of instructions.
It allows the system to address more than 16GB of memory.
第19题:
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
第20题:
Library cache
Row cache
Dictionary cache
Large area
Buffer cache
第21题:
only the auto-tuned memory components
only the memory components that are not auto-tuned
both the auto-tuned memory components and the non-auto-tuned memory components
neither the auto-tuned memory components nor the non-auto-tuned memory components
第22题:
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
第23题:
The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.
The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.
The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.
The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.
第24题:
log buffer
Java pool
Large pool
Fixed SGA
Shared pool
Streams pool
Keep buffer cache
Database buffer cache