AUDIENCE:   This course is for support staff who need to be able to provide the day to day administration of an Oracle 9i based system. The course is also relevant to Oracle 8i installations. PREREQUISITES:   The participant should have a strong understanding of using an Oracle based system, good knowledge of SQL*Plus and (preferably) PL/SQL, or previous attendance of the Oracle SQL and PL/SQL courses, or their equivalents from other training providers. DURATION:   5 days. Hands on. OBJECTIVES:   This course provides students with the skills to describe the architecture of an Oracle system and the creation, maintenance and configuration of databases. Students will also gain the ability to administer users, perform backups, recover a database, use the data and design distributed databases. It is highly interactive and consists of theory coupled with plenty of hands on practical sessions. On completion the delegate will understand the responsibilities of a DBA and be able to perform the tasks associated with this role. Delegates will be provided with the skills to describe the architecture of an Oracle system and the creation, maintenance and configuration of databases. They will also gain the practical experience to administer users, roles and privileges, perform both cold and online backups and fully recover a damaged database. COURSE CONTENT:   Overview Of Oracle Database Creation, Startup and Shutdown Initialisation file Database creation Database startup Database shutdown Alert log Exercise and quiz SGA and Background Processes Introduction Buffer cache Redo log buffer Shared pool Program global area Background processes Transaction processing Tablespaces Design considerations Tablespace creation Locally managed tablespaces Table creation Constraints Internal and External Files Datafiles, segments Rollback segments Control files Redo logs Checkpoint processing Archiving REDO logs Performance Issues Rollback segments Lock & users Sorts Redo log buffer Buffer cache Shared pool Disk I/O UTLBSTAT & UTLESTAT Users, Roles and Profiles User creation Profiles System privileges Object privileges Roles Auditing Backup and Recovery Cause of data loss Structures used Offline backups Archiving redo logs Online backups Complete recovery Incomplete recovery Networking and NET*8 Client/Server architecure Net* TNSNAMES.ORA / LISTENER.ORA Oracle Utilities Export Import SQL Loader PPJ07/01