Course details
; Architecture & Configuration 1: Overview of Oracle DBA tasks 2: Instance Architecture 3: Oracle Instance Internals 4: Using SQL*Plus for DBA management 5: Control file, UNDO and REDO management 6: User and privilege management2 –Oracle database management 1: Overview of instance management 2: Initialization file management
3: Oracle*Net configuration 4: Data buffer configuration & sizing 5: Shared pool and PGA configuration & Sizing 6: Troubleshooting network connectivity 3 – Oracle object management 1: Oracle tables, views and materialized views 2: Oracle indexes 3: Oracle constraints 4: Schema, File & table space management 5: Database Maintenance
6: Oracle DBA Utilities
4 – Monitoring Oracle this section explores the methods used for monitoring all active components of the Oracle database. 1: Dictionary and v$ views 2: Table & index monitoring 3: workload & trend monitoring 4: Instance monitoring 5: Oracle environment monitoring 6: STATSPACK and AWR performance management 5 – Performance Management This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck. 1: Bottleneck performance analysis
2: Instance Tuning 3: SQL and CBO behavior 4: Tracing SQL Execution 5: SQL Execution Internals 6: SQL Tuning
6- Backup
1: Oracle High Availability tools 2: Backup & Recovery Updated on 28 July, 2020
Course Location
About Rolla Computer and Management Training
In this day and age, When information and technology is progressing day by day, importance of well-trained professionals has been two folds. Rolla Computer & Management training was established to produce Skilled professionals who not only meet the requirements of today but, in future as well. After taking enormous potential of information technology into consideration Rolla Computer and Management has designed its programs in the light of latest information.Rolla computers and management is known as the center of the IT training for executives and students.
We are one of the pioneer institute which offer Internationally Recognized Certifications in United Arab Emirates. It is great credit for Rolla Computer and Management that have successfully trained Thousands of professionals and students through introducing most advance programs like " MCSE, MCP, **OCP, CIW, A++ and **CCNA". Our achievement, growth and development are proof our popularity and reputation for our high standard of education.
Oracle Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Oracle 12c OCP 120-061: SQL Fundamentals Study 365AED 180Duration: Upto 16 Hours
- Oracle APEX (Video-Based) UplatzAED 46Duration: Upto 5 Hours