Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICTDBS404 Mapping and Delivery Guide
Identify and resolve common database performance problems

Version 1.0
Issue Date: March 2024


Qualification -
Unit of Competency ICTDBS404 - Identify and resolve common database performance problems
Description
Employability Skills
Learning Outcomes and Application 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.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to:

special purpose materials

industry software packages

diagnostic tools

database operating on a network.

Assessors must satisfy NVR/AQTF assessor requirements.

Prerequisites/co-requisites
Competency Field
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities
Slides
PPT
Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: 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
       
Element: 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
       
Element: 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
       


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

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

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.

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.


Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)


Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

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

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
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 
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 
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 

Forms

Assessment Cover Sheet

ICTDBS404 - Identify and resolve common database performance problems
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:


Assessment Record Sheet

ICTDBS404 - Identify and resolve common database performance problems

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: