Untitled Document

Concentrika poppy

	Oracle 9i DBA training is spread across two closely linked 3 day courses Part 2 – data management and networking Having been on part 1 of the Oracle 9i DBA training, you are now ready to deal with advanced issues of data management and networking. Also in part 2 is a detailed session on performance monitoring and optimization of the database. A real-world view of the training is adopted, to take the delegate past the training lab and into the world of business computing. Your contribution to the labs is highly valued in this respect. Feel free to discuss issues relating to your own businesses, especially where the class as a whole would benefit from seeing what problems, and options to solve them, exist outside the lab. Should you require training in more detail in any aspect of Oracle DBA, we are able to provide you with dedicated training in specialist areas such as backup and recovery, database security, performance management, and networking databases. Audience You already have the basics of Oracle DBA and need to advance your DBA skills First and second line support Oracle developers wishing to know more about the underlying RDBMS Storage management specialistsPrequisites Familiarity with the theory and practice of basic Oracle database administration. Attendance on Part 1 of Oracle 9i DBA is strongly recommended if you have any doubts. Duration 3 days
Contents
1. Bulk loading and unloading of data	SQL*LOADER EXPORT/IMPORT
2. Data storage	Tables and indexes Partitioning Clustering Large objects (LOBS) Oracle 9i object orientated technology
3. Backup and Recovery	Backup and recovery strategy Types of failure Types of backup Tuning Instance Recovery Logging strategies Multiple Archival Destinations and Processes Describing User-Managed Backup and Recovery Operations Performing Closed Database Backups Performing Open Database Backups Cleaning Up After a Failed Online Backup Backing Up the Control File Incomplete Recovery Recovering from the Loss of Current Online Redo Logs Cleaning Up After a Failed Online Backup Backing Up the Control File Data guard Log miner Trial recovery Backup and restore techniques Recovery manager
4. Performance and monitoring	Strategies Analyze command UTLBSTAT/UTLESTAT The stages of an SQL statement Query optimisation Explain Plan 9i cached execution plans SQL Trace and TKPROF Statspack DBMS_STATS package
5. Oracle networking	Oracle Net server side configuration Configuring the Listener for IIOP and HTTP Connections Oracle Net client side configuration Simple Connection Troubleshooting Linked databases Distributed transactions Snapshots Advanced queuing Oracle networking add-on solutions