Signup as a Tutor

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

Oracle DBA Training

No Reviews Yet

Velacheri, Chennai

Course ID: 21390

Velacheri, Chennai

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

About Arun Prasad

trainer created through tv 360
No reviews currently Be the First to Review

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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

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

Enquire

Submit your enquiry for Oracle DBA Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Tarun Tarun

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer