A.It improves resync operations when the disk comes online after being taken offline for maintenance purposes. B.It improves performance in the extended cluster configuration by reading from a local copy of an extent. C.Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool. D.This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
A. a job B. a program C. a schedule D. a PL/SQL procedure
A. It does not allow you to change the moving window size. B. Adaptive threshold functionalities use it by default to compute statistics. C. It is created by default with the window size being equal to the AWR retention time. D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
A. selection of SQL plan baselines B. partitioning of tables and indexes C. creation of index-organized tables D. creation of bitmap, function-based, and B-tree indexes E. optimization of materialized views for maximum query usage and fast refresh
A.Every SQL statement in the STS is considered only once for execution B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics C.The execution plan and execution statistics are computed for each SQL statement in the STS D.The effects of DDL and DML are considered to produce the execution plan and execution statistics
微信掃一掃關(guān)注公眾號后聯(lián)系客服
微信掃碼免費(fèi)搜題
