Unit of competency Outline

Date retreived
22/07/2026 10:27 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
ICTDBS417
State Code
OBU91
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020303 - Database Management
Original Release Date
15/01/2021
Nominal Hours
25
Description
This unit describes the skills and knowledge required to diagnose database problems and to configure and tune the database in order to maintain consistent and optimised performance.It applies to individuals who are experienced technical support personnel, including 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 and resolve database problems
  • 1.1 Determine database performance diagnostic tool, according to organisational database requirements and vendor recommendations
  • 1.2 Run diagnostic test and identify database performance degradation issues
  • 1.3 Determine and record misuse of database and temporary table spaces
  • 1.4 Carry out required fixes according to diagnostic results
  • 1.5 Record issues and actions taken and escalate unresolved issues to required personnel
2. Configure database
  • 2.1 Utilise database (DBMS) tools and design structures to minimise i/o contention according to task requirements
  • 2.2 Apply database backup procedures according to method of data storage
  • 2.3 Reconfigure rollback segments according to task requirements
  • 2.4 Configure database and test performance according to task requirements
3. Optimise the database
  • 3.1 Track module performance according to specifications
  • 3.2 Monitor and tune efficiency of structured query language (SQL) according to task requirements
  • 3.3 Monitor and measure performance of shared pool, blocks and buffers
  • 3.4 Detect, identify and resolve contentions that arise in real-time operation of database
  • 3.5 Reconfigure database according to specifications
No information
No information
Replaces
State Code National Code Title Type
AUT44 ICTDBS404 Identify and resolve common database performance problems Unit of competency