Exam4Training

What should a technical specialist request to provide latency analysis for an Oracle DB system predict performance impact of IBM Flash Systems?

What should a technical specialist request to provide latency analysis for an Oracle DB system predict performance impact of IBM Flash Systems?
A . DB Trace report
B . nmon analyzer report
C . AWR report
D . Perfrep report

Answer: C

Explanation:

IBM FlashSystem offers customers the ability to speed up databases to rates that may not be possible even by over provisioning the fastest spinning disk arrays.

You can use native Oracle Database tools to determine the effects that flash storage can have on Oracle Database environments.

Oracle utilities―Statspack and now Automatic Workload Repository (AWR) reports ―provide database administrators with detailed information concerning a

snapshot of database execution time. This snapshot provides statistics on wait events, latches, storage input and output volumes, and timings as well as various

views of memory and SQL activities.

References: https://www-01.ibm.com/common/ssi/cgi-bin/ssialias?htmlfid=ORW03038USEN

Exit mobile version