preview

The Performance Of Database Management

Decent Essays

Performance measurement is the process of collecting, analyzing and/or reporting of key defined metrics regarding the performance of database management components and the overall database management system.
As a process, performance measurement is not just collecting data associated with a predefined performance goal or standard. Performance measurement is an overall management system involving prevention and detection aimed at achieving conformance of the database management process to an established target. Additionally, it is concerned with process optimization through increased efficiency and effectiveness of the product, solution or service. These actions occur in a continuous cycle, allowing options for expansion and improvement of the process as better techniques are discovered and implemented.
If an activity cannot be measured, it most certainly cannot be controlled. If it cannot be controlled, then it cannot be managed. Without dependable measurements, intelligent decisions cannot be made. There are a number of tools available that can assist with testing performance and scalability of Oracle Databases and their platforms including Swingbench, HammerDB, Benchmark Factory for Databases, Apache JMeter, HP Load Runner (with SiteScope) and others.
Database Replay introduced as an option since Oracle 11g allows the recording of a production database workload and replay that workload against a development or test instance of the database. With 12c Oracle has enhanced the

Get Access