Oracle Database Administration Online Training

Video ready, click here to close ×


Feel free to contact

Call : +91-8870903864
Or E-mail
contactexpertsonline@gmail.com

Oracle Database Adminstration
INTRODUCTION TO ORACLE DBA

What is DBA ?
• Why a Company needs a DBA?
• Roles & Responsibilities of DBA
• Oracle Architecture
• Physical and Logical Phase of Database
• Types of files(Control file, Redolog file and Datafile)
• Different types of Datafiles
• Instance
• SGA(System Global Area) and Background Process
• DATABASE CREATION

• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation
• TABLESPACE MANAGEMENT

Introduction to Table space
• Types of Table space(BIG & SMALL)
• Temporary Table space
• Altering/Renaming a Table space
• Renaming a data file
• Temporary Groups
• Table space Encryption(11g)
• STORAGE PARAMETERS

• What are segments?
• What are extents?
• What is Blocks?
• Oracle Blocks
• Estimation of Extents
• Dictionary Managed Table space
• Locally Managed Table space
• Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)
• USER MANAGEMENT

• Who are Database Users?
• Why to create a User?
• Creation of Users
• Assigning Privileges
• Creating and granting Roles
• Allocating table space Quotas to Users
• Assigning default table space for the Users
• Setting Profiles for the Users
• Levels of Authentication
• Schema Management(11g)
• Security(11g)
• UNDO MANAGEMENT

• What is Undo?
• Why Undo required?
• Pending offline status
• Brief idea about Rollback segments
• Flashback Features
• Flashback Table
• Flashback query
• Flashback Version query
• What is spfile?

• Difference between spfile and pfile
• Advantages of spfile
• What is OMF?
• Advantages of OMF
• Files conventions of OMF
• NETWORKING IN ORACLE

• Introduction to Oracle Networking
• Network default location
• Editing Network file
• Tnsnames.ora

Introduction to Database…

source

Leave a Reply

Your email address will not be published. Required fields are marked *