Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Diagnose problems
   • Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations
   • Run a diagnostic tool to identify the issues causing degradation of the database’s performance
   • Determine and record where the inappropriate use/s of database and temporary table spaces occur
   • Carry out appropriate fixes, based on diagnostic results
2. Configure the database
   • Adopt a distributed files architecture to minimise input and output (I/O) contention
   • Ensure that database backup procedures are appropriate for the method of data storage
   • Reconfigure rollback segments
   • Configure the database and test its performance
3. Tune the database
   • Track module performance according to its specifications
   • Monitor and tune the efficiency of structured query language (SQL), as required
   • Monitor and measure the performance of shared pool, blocks and buffers
   • Detect, identify and resolve any contentions that may arise in the real-time operation of the database
   • Reconfigure the database according to specifications

Performance Evidence

Evidence of the ability to:

correctly identify common database problems

select appropriate solutions to solve the problem

implement solutions to improve database performance.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

---

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

outline the principles of database design and structured query language (SQL)

describe the principles of database administration

describe diagnostic tools and database tuning methodologies.

---