compaction ratio limit
garbage collection frequency
garbage collection times
fragmentation heap size
第1题:
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
第2题:
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()
第3题:
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.You have set the DB_SMART_FLASH_FILE parameter:DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’How should the DB_FLASH_CACHE_SIZE be configured to use both devices?()
A. Set DB_FLASH_CACHE_SIZE=64G
B. Set D3_FLASH_CACHE_SIZE=64G, 64G
C. Set D3_FLASK_CACKE_SI2E=128G
D. db_flash_cache_SI2E is automatically configured by the instance at startup
第4题:
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?() The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn’t set
第5题:
Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ?()
第6题:
Which statement is true about XpauseTarget in Oracle JRockit JVM ? ()
第7题:
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
第8题:
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()
第9题:
When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?()
第10题:
What two statements are true about Oracle Enterprise Manager’s Java Diagnostic tool, which makes the tool suitable for production server diagnostics ?()