Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Oracle DBA Training" is no longer available

No Reviews Yet

Velacheri, Chennai

Course ID: 21390

Velacheri, Chennai

Arun Prasad picture
Arun Prasad
No Reviews Yet

About the Course

ORACLE DBA 11g & 10G with LINUX SERVER and Windows XP & Software

Topics Covered

ARCHITECTURE

? SGA

? Explain SGA and PGA

? SGA Architecture and It?s Components

? Explain use of PFILE & SPFILE

? Step for creation of PASSWORD FILE

? Oracle Instance Creation

? Explain SGA & PGA & PFILE & SPFILE in VIEWS

? MEMORY STRUCTURE

? Explain Table space Memory Structure and It?s usage

? Benefits of Segment and It?s different types

? Extent Management and use of Creation

? Block Management and explain about PCTFREE PCTUSED through Diagram

? Explain through VIEWS

? PHYSICAL FILES

? Creation of Control File & Redo Log File & Data file

? Creating and Maintaining Redo Log Files Group

? Restructuring Redo Log File Group

? Create and Managing Table Space and Data Files

? Add and Remove Data files in single Table Space

? Estimate Data file and Table space Size

? Explain Undo Table space and It?s usage and Configure it in Parameter

? Explain through VIEWS

? USER MANAGEMENT

? Explain about Schema and Users

? Create New User with Password and Resources

? Create Profile to admin Session and Password Resources

? Assign appropriate Privileges and Roles

? Assign appropriate Views as per Industry

? Assign Limited User in Database

? Kill active user and find impact in Database as per Industry

? Delete User C who authorize by User B from User A then get experience

drawback

? Monitor user activities as SYSDBA

PARAMETER MANAGEMENT

? SGA & PGA Configuration

? Shared Pool & Large Pool Configuration

? Log Buffer Configuration

? Cursor Sharing Configuration

? Dynamic Sampling Configuration

? License Max User Configuration

? FRA Configuration

? Parameter in VIEWS

FLASHBACK

? Check Flashback is ON or OFF

? Activate Flashback in Database

? Activate Recycle bin in Database

? Retrieve Deleted Table using Flashback

? Flashback Table to Before Drop

? Flashback to SCN and AS OF SCN

? Flashback to Timestamp and AS OF TIMESTAMP

? Flashback Database to Timestamp and SCN

? Flashback details from VIEWS

? Purge Recycle Bin

BACKUP & RECOVERY

? RMAN Configuration

? RMAN Maintenance Commands

? Explain Backup Dynamic Views

? RMAN Hot and Cold Backup

? Data file Recovery in RMAN

? Control file Recovery in RMAN and Configuration in Parameters

? Clone Database in RMAN

? Complete and Incomplete Recovery

? Schema Recovery

? Point In Time Recovery ( PITR )

? Instance and Media Recovery Structures

? Configuration of the Archive Mode and No Archive Mode

? User Managed Hot & Cold Backups

? Various Scenario of UMB ( HOT )

? DBPITR of Table space from previous Backup

? RMAN Catalog Creation and Usage

LOGICAL BACKUP

? Basic Parameter for Export / Import ( 9i )

? Key Parameter for Data pump ( 10g )

? Export Table & Table space from Database to external File System

? Export Schema & Database to external File System

? Export Database and Import to another Database

DIAGNOSTIC REPORT

? Generate Reports ? AWR & ADDM & STATSPACK

? Change AWR Report default Timing using

DBMS_WORKLOAD_REPORSITORY

? Analyze AWR Report

? Gather Statistics of Wait Event and find exact cause of problem

? List up Wait Class for matching with Wait Events

INDEX MANAGEMENT

? Explain Index and Create as per Industry

? Create different types of Index on Table

? Apply different Partition on Table and Index

? Check size of Table and Index

? Gather Statistics of Table and Index using Analyze Command

? Validate Index Structure in order to improve performance

? Rebuild Index as Per Industry Rule

? Monitor Index and It?s usage through VIEWS

PERFORMANCE TUNING

? When Hit Ratio is go less than 80% then increase it to improve Database

Performance

? Identify cause of Session Slow and take appropriate action

? Troubleshoot if User complaint about System is very Slow

? Flush Buffer Cache and Shared Pool once get clear picture of heavy memory load

in Shared Pool

? Check reason for Wait Events

? Explain process of EXPLAIN PLAN

? Gather Statistics of System Database Schema & Table using DBMS_STATS

? Database Tuning and Query Tuning

TOOL

? Oracle Enterprise Manager ( OEM )

OPERATING SYSTENM

? Oracle Installation on Windows and Linux

? Server Administration on Linux Box and Admin Multiple Oracle Database

? Create Database Manually and Wizard

Who should attend

Anyone

Pre-requisites

Nothing

What you need to bring

Nothing

Key Takeaways

Knowledge

Date and Time

Not decided yet.

About the Trainer

Arun Prasad picture

Avg Rating

Reviews

Students

Courses

Arun Prasad

BE

trainer created through tv 360

Reviews

No reviews currently

Discussions

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more