Unit of competency Outline

Date retreived
23/07/2026 6:52 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Identify and resolve common database performance problems

Identify and resolve common database performance problems

Unit of competency
National Code
ICTDBS404
State Code
AUT44
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
25
Description
This unit describes the skills and knowledge required to diagnose database problems, as well as to configure and tune the database in order to maintain consistent performance.It applies to individuals who are experienced technical support personnel, such as help-desk supervisors, database support technicians, information and communications technology (ICT) support technicians, and user-support specialists, who are responsible for maintaining the performance of a database.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Diagnose problems
  • 1.1 Determine an appropriate database performance diagnostic tool to use, based on organisational database requirements, and vendor recommendations
  • 1.2 Run a diagnostic tool to identify the issues causing degradation of the database’s performance
  • 1.3 Determine and record where the inappropriate use/s of database and temporary table spaces occur
  • 1.4 Carry out appropriate fixes, based on diagnostic results
2. Configure the database
  • 2.1 Adopt a distributed files architecture to minimise input and output (I/O) contention
  • 2.2 Ensure that database backup procedures are appropriate for the method of data storage
  • 2.3 Reconfigure rollback segments
  • 2.4 Configure the database and test its performance
3. Tune the database
  • 3.1 Track module performance according to its specifications
  • 3.2 Monitor and tune the efficiency of structured query language (SQL), as required
  • 3.3 Monitor and measure the performance of shared pool, blocks and buffers
  • 3.4 Detect, identify and resolve any contentions that may arise in the real-time operation of the database
  • 3.5 Reconfigure the database according to specifications
No information
No information
Replaces
State Code National Code Title Type
D7770 ICADBS404A Identify and resolve common database performance problems Unit of competency
Replaced By
State Code National Code Title Type
OBU91 ICTDBS417 Identify and resolve common database performance problems Unit of competency
State Code National Code Title Type
AVY7 ICT40215 Certificate IV in Information Technology Support Qualification