单选题Which component of the SGA stores parsed SQL statements is used for process sharing?（）ABuffer cache BRedo log buffer CPrivate SQL area DLibrary cache ERow cache
单选题
Which component of the SGA stores parsed SQL statements is used for process sharing?（）
A
Buffer cache
B
Redo log buffer
C
Private SQL area
D
Library cache
E
Row cache
参考解析
解析：
暂无解析
相关考题：
下面哪些等待事件表示空闲等待？（）A、SQL*Netmessage to clientB、SQL*Netmessage from clientC、library cache lockD、log file sync
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available SQL Tuning Set (STS) only D、SQL statements that are available in the cursor cache and executed by a user other than SYS
Which is the correct description of a pinned buffer in the database buffer cache（）A、The buffer is currently being accessed.B、The buffer is empty and has not been used.C、The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D、The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
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？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
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（）A、The minimum memory size for the database buffer cache is set to 100 mb.B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the available SQL Tuning Set （STS） onlyD、 SQL statements that are available in the cursor cache and executed by a user other than SYS
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A、ARCH B、SMON C、LGWRD、SERVER
Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache
Which component of the SGA stores parsed SQL statements is used for process sharing?（）A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）A、because 4194304 is the granule sizeB、because 4194304 is the standard block sizeC、because 4194304 is the largest nonstandard block size defined in the databaseD、because 4194304 is the total size of data already available in the database buffer cache
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）Abecause 4194304 is the granule sizeBbecause 4194304 is the standard block sizeCbecause 4194304 is the largest nonstandard block size defined in the databaseDbecause 4194304 is the total size of data already available in the database buffer cache
单选题The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.Alarge poolBshared poolCdata buffer cacheDredo log bufferEdata dictionary cache
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）ALibrary cache BRow cacheCDictionary cache DLarge area EBuffer cache
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）ABecause 4194304 is the granule sizeBBecause 4194304 is the standard block sizeCBecause 4194304 is the largest nonstandard block size defined in the databaseDBecause 4194304 is the total size of data already available in the database buffer cache
单选题You observe that a 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 that required size of the database buffer cache？ （）A Memory AdvisorB Segment AdvisorC SQL Tuning AdvisorD SQL Access AdvisorE Automatic Database Diagnostic Monitor （ADDM）
单选题You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A streams poolB shared poolC log bufferD keep buffer cacheE recycle buffer cache
单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）AARCH BSMON CLGWRDSERVER
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A SQL statements that are part of the AWR baseline onlyB SQL statements based on the AWR top SQL identificationC SQL statements that are part of the available SQL Tuning Set （STS） onlyD SQL statements that are available in the cursor cache and executed by a user other than SYS
单选题Which is the correct description of a pinned buffer in the database buffer cache（）AThe buffer is currently being accessed.BThe buffer is empty and has not been used.CThe contents of the buffer have changed and must be flushed to the disk by the DBWn process. DThe buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
单选题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（）AThe minimum memory size for the database buffer cache is set to 100 mb.BThe maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbCThe minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.DThe maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
单选题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？（）AMemory AdvisorBSegment AdvisorCSQL Tuning AdvisorDSQL Access AdvisorEAutomatic Database Diagnostic Monitor （ADDM）