先試後買

A. Real Application Testing

B. Oracle Migration Pack for Databases

C. Oracle Migration Performance Advisor

D. Oracle Diagnostic Pack for Database

E. SQL Performance Testing Suite

A. ability to use parallel server processes

B. network I/O

C. use of SGA memory and ability to allocate PGA

D. concurrent sessions

E. CPU

F. SGA

A. Database Replay

B. Dynamic Baseline Advisor

C. Automatic Workload Repository Baselines

D. SQL Tuning Sets

E. Optimizer Statistics Comparator

A. applying a workload from one database release to another database release

B. to find the least-used SQL statement

C. moving a workload from a single database instance and applying it to an Oracle Real Application Cluster(RAC)

D. applying workload to an application after an operating system patch

E. to check and compare if a specific set of SQL statements have regressed between two different databasereleases

A. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.

B. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.

C. An HR Team claims that it can hire staff fast enough to meet business demands.

D. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.

E. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.

A. Oracle Diagnostics Pack for Oracle Database

B. SQL Tuning Pack for Oracle Database

C. Oracle Performance Pack for Oracle Database

D. Oracle Tuning Pack for Oracle Database

E. Oracle SQL Developer

F. Oracle Real Application Testing

G. STATSPACK

A. It is applicable for Oracle Database 12c and later versions.

B. It is available for Oracle Database Standard and Enterprise Editions.

C. It is recommended for Production environments, but not for Development or QA.

D. It builds on capabilities built into Oracle databases.

E. It is delivered with Oracle Engineered Systems.

A. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.

B. ASH data is available 24 hoursbecause AWR snapshots refresh every night.

C. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.

D. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.

A. gather system statistics for several hours during normal workload periods

B. gather system statistics for several hours when there is no workload

C. shut down any running applications prior to collection

D. lock out user sessions and gather system statistics overnight

E. gather system statistics after a performance issue has been reported