If the switchestimate parameter is false oracle will

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: he SWITCH_ESTIMATE parameter is FALSE, Oracle will start the operation even if Oracle's estimate is greater than the value specified by MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met. The SWITCH_GROUP parameter specifies the group to which the session will be switched. The SWITCH_TIME parameter specifies the amount of time a session can execute before it must be switched to another group. The default for the SWITCH_GROUP parameter is NULL; the default for the SWITCH_TIME parameter is UNLIMITED. Actualtests.com - The Power of Knowing 1Z0-030 Incorrect Answers C: There is no MAX_SESS_POOL resource plan parameter in Oracle. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements QUESTION 19: You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message: CREATE TABLESPACE tbsl; ORA-02199: missing DATAFILE/TEMPFILE clause oerr ora 2199 02199, 00000, "missing DATAFILE/TEMPFILE clause" *Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action: Specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace? A. Issue the CREATE TABLESPACE tbsl DATAFILE SIZE 10M; command. B. Issue the CREATE TABLESPACE tbsl EXTENT MANAGEMENT ORACLE; command. C. Set the db_create_file_dest parameter using the ALTER SESSION command and re-issue the statement. D. An OMF tablespace is not allowed; only control files and/or redo log files can be created by OMF. Answer: C Explanation: You can set the DB_CREATE_FILE_DEST parameter using the ALTER SESSION command and re-issue the statement. You should define directories for OMF datafiles, redo log files and control files. Oracle9i gives you two new initialization parameters, DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create and manage OMFs; n can take a value from 1 to 5. Incorrect Answers A: This command will not fix the problem. B: There is no EXTENT MANAGEMENT ORACLE option in the CREATE TABLESPACE command. D: An OMF tablespace is allowed; datafiles, control files and redo log files can be created by OMF. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 20: Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance? A. Data blocks have to be written more frequently by DBWR. B. Redo blocks have to be written more frequently by LGWR. C. You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D. You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint record...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online