Unformatted text preview: SOURCE_MANAGER_PLAN parameter
in init.ora file.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1149.
Chapter 18: Oracle8i New Features Topics
Why do these steps eliminate row migration?
Step 1: Run ANALYSE TABLE . . . . . LIST CHAINED ROWS command
Step 2: Copy the rows to another table
Step 3: Delete the rows from the original table
Step 4: Insert the rows from step 2 back into the original table.
A. Migration only occurs during an UPDATE operation.
B. The migrated rows are removed with
the DELETE command.
C. Migration is automatically removed with the ANALYZE command.
These steps will eliminate row migration because it happens only during an UPDATE operation.
B: The migrated rows will be inserted again after deleting into the original table, but they will fit
database blocks, because migration happens only after an UPDATE operation, not after
C: ANALYZE command will not fix migration problem automatically.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 915-916.
Chapter 19: Tuning Disk Utilization
After running a query using V$DISPATCHER, you increase the number of dispatchers.
What would cause you to take this action?
A. Users are waiting on a listener process.
B. Users are waiting on dispatch processes.
C. Users are waiting on shared server processes.
Actualtests.com - The Power of Knowing 1Z0-024
D. Users are waiting on their dedicated connection process.
If V$DISPATCHER view shows you that users are waiting on dispatch process, you need to
increase the number of dispatchers running for Oracle instance.
A: V$DISPATCHER view have nothing to do with a listener process.
C: Users do not work with shared server processes directly, users use dispatchers in MTS
environment to connect to database.
D: Users do not wait for dedicated connection process, because Oracle will launch the new
dedicated process if there is no more idle dedicated process for user and number of dedicated
processes did not exce...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09