*Evolving SQL Plan Baselines

Description of Figure 23-4 follows * 2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description. 1.Set the evolve task parameters. SET_EVOLVE_TASK_PARAMETER This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT. 4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function. 3:IMPLEMENT_EVOLVE_TASK This function implements all recommendations for an evolve task. Essentially, this function
is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input
parameters include task name, plan name, owner name, and execution name.
5.Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include
the task name and section of the report to include.
Reference: OracleDatabase SQL Tuning Guide12c,Managing SQL Plan Baselines

A:In certain situations, you may want to exclude selected columns or tables
from
scanning or conversion steps of the migration process.
D:Exceed column limit
The cell data will not fit into a column after conversion.
E:Need conversion
The cell data needs to be converted, because its binary representation in the
target character set is different than the representation in the current character
set, but neither length limit issues nor invalid representation issues have been
found.
*Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation
migration tool providing an end-to-end solution for migrating your databases from legacy
encodings to Unicode.
Incorrect:
Not C:The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or
later.

The REPORT_SQL_MONITOR function is used to return a SQL monitoring report
for a specific SQL statement.
Incorrect:
Not A: Not interested in session statistics, only in statistics for the particular SQL query.
Not B: We are interested in statistics, not tracing.
Not D: SET_SESSION_LONGOPS Procedure
This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to
indicate the on-going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup.
Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.

Note:
* Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Incorrect:
Not B: For one database at a time.
Not C, Not E: Enterprise Manager Database Express features can be used against non-CDBs or
Oracle RAC database instances.
Not D: After the installation, your instance is started and your database is open. In the future, there
will be times, perhaps for doing database maintenance or because of a power or media failure,
that you shut down your database instance and later restart it.

B:A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it. *
Incorrect: Not A:High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.
Not C, Not F:Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.