Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.

ELEMENT 

PERFORMANCE CRITERIA 

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

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

Skill 

Performance Criteria 

Description 

Reading

1.1, 1.3, 2.2

• Analyses and interprets textual information in order to establish performance issues and their corresponding solution(s)

Writing

1.3

• Uses technically appropriate language and format, when recording data

Oral Communication

1.1

• Uses effective listening, questioning and summarising skills to ensure that the correct information is gathered

Get the work done

All

• Uses a formal, logical planning processes, together with an increasingly intuitive understanding of context, to identify relevant information and risks, and to identify and evaluate alternative strategies and resources
• Uses systematic, analytical processes in complex, non-routine situations, setting goals, gathering relevant information, and identifying, and evaluating options against the agreed criteria
• Uses analytical processes to decide on a course of action, establishing criteria for deciding between options
• Uses familiar digital technologies and systems to access information, search and enter data, code, present information and communicate with others, while maintaining data security and safety at all times

Code and title 

current version 

Code and title 

previous version 

Comments 

Equivalence status 

ICTDBS404 Identify and resolve common database performance problems

ICADBS404A Identify and resolve common database performance problems

Updated to meet Standards for Training Packages

Equivalent unit

Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.