AUDIENCE:   This course is for support staff who need to be able to provide the day-to-day administration of an Oracle 10G based system. The class is based on the Oracle Enterprise Edition – most concepts are also applicable to Standard Edition and Standard Edition One versions of Oracle 10G. PREREQUISITES:   An understanding of using an Oracle based system is required. Delegates will need knowledge of SQL and attending both of our Oracle SQL courses, or their equivalent from other training providers is highly recommended. Some understanding of Internet concepts is advised to fully benefit from this course. DURATION:   5 days. Hands on. OBJECTIVES:   This course is highly interactive and consists of theory reinforced by extensive hands on practical sessions. On completion of the class, the delegate will understand the responsibilities of a DBA and be able to perform the tasks associated with the role. Delegates will be provided with the skills to describe the architecture of an Oracle system and configure, create and manage efficient Oracle 10g databases. They will also gain the practical experience to administer users, roles and privileges. COURSE CONTENT:   Overview Of Oracle Oracle history Grid architecture Application architecture – Client/Server v Multi-tier; Memory and Processes Physical and logical structures – Files, Tablespaces; Segments, Extents and Blocks The Oracle Instance - Database startup and shutdown Management tools – Oracle Enterprise Manager, SQL*Plus Exercise and quiz Database Creation, Startup and Shutdown DBA Privileges Levels – DBA, Security Officer, Network Administrator Initialisation files Database creation Database startup, quiescing, 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 and Tables Design considerations – required tablespaces Tablespace creation and management Automated storage management Table creation and management – constraints, triggers Internal and External Files Datafiles, segments and extents Control files Redo logs Checkpoint processing Archiving REDO logs Performance and Tuning Overview Self monitoring architecture Disk tuning - Temporary storage, undo segments Memory tuning – Buffer cache, shared pool, redo log buffer; locks Statistics management Oracle Advisors Users, Roles and Profiles User creation and management Profiles System privileges Object privileges Roles Security and Auditing Backup and Recovery Cause of data loss Structures used Offline backups Archiving redo logs Online backups Complete recovery principles Incomplete recovery principles Oracle Flashback overview Oracle Net Services Client/Server architecture – Connection and Naming methods (Easy, Local, Directory, External) Local Networking and Internet-Working Files - TNSNAMES.ORA / LISTENER.ORA / SQLNET.ORA / CMAN.ORA / OID (LDAP) Advanced Features – Load Balancing and Failover Oracle Utilities Data Pump – Export and Import SQL*Loader Log Miner Advanced Topics Overview Performance - Table compression, indexing choices OLAP processing – Materialized views, ETL solutions Programming options – PL/SQL v Java Content Management – XML, LOBs, Ultra Search Globalisation – time zone, language, date and number formats