Enter your keyword


Oracle® Database 11g Administration


About Instructor

Introduction to Oracle Database 11g Administration
Your responsibilities as an Oracle 11g DBA
• Configuring the instance and database
• Balancing user requirements and resources
• Ensuring database availability

The Oracle 11g architecture
• Processing transactions with the server
• Identifying types of processes and memory structures
• Determining database file structure
• Sizing the Result Cache for optimizing repeated queries

Building an Oracle 11g Database Creating the database
• Simplifying memory allocation with memory targets
• Establishing network connectivity
• Converting from text-based to server parameter files
• Configuring control files and redo log files Starting and stopping the database
• Mounting and opening the database with SQL*Plus
• Authenticating connections having SYSDBA privilege
• Closing the database and shutting down the instance

Automating Database Management The Oracle Enterprise Manager architecture
• Navigating the graphical interface
• Comparing command-line and graphical techniques Administering with Database Control
• Equipping Database Control to manage additional databases
• Setting thresholds and generating alerts
• Verifying changes in the data dictionary
• Performing privilege management Performing Flashback Operations Managing space for rollback and read
• Configuring UNDO tablespaces
• Monitoring expansion of rollback segments
• Swapping to an alternative UNDO tablespace

Resetting data to recent points in time with Flashback
• Tracking changes to data values with row history
• Obtaining transaction history with Flashback Transaction
• Performing recovery of data with Flashback Table
• Retrieving dropped tables and dependent objects from the recycle bin Securing the Database Establishing user accounts
• Authenticating users with password checking
• Allocating space quotas for user schemas
• Limiting resource usage through profiles Enforcing security
• Granting and revoking system and object privileges
• Simplifying privilege management with roles
• Preventing changes to read-only tables

Controlling Database Storage Defining logical and physical structures
• Creating, altering and dropping tablespaces

• Handling sort data with temporary tablespaces

Configuring storage patterns for database objects
• Structuring data and index segments
• Eliminating rowmigration with PCTFREE and Data Pump
• Compressing table data to conserve storage
• Shrinking tables and indexes online to regain space

Partitioning for Administration and Availability
Creating table partitions and subpartitions

• Selecting partitioning methods: range, list, hash, interval
• Referencing the partitioning method in child tables
• Administering partitions with merge, split, add and drop Maintaining index partitions
• Maximizing performance with local and global indexes

You Will Learn How To

• Create, maintain and support Oracle 11g databases and instances
• Automate database administration tasks with Oracle Enterprise Manager 11g Database Control
• Provide transaction support and flashback capability
• Control access and database security through privileges and roles
• Partition large tables and indexes to improve performance

Who Should Attend
Database administrators, developers with data management responsibilities and others involved in the
management or deployment of Oracle 11g databases who have experience with Oracle 11g, “Oracle
Database 11g Introduction.”

Hands-On Experience
• Building an Oracle 11g database
• Implementing the graphical DBA tools
• Maintaining UNDO tablespaces and retention periods in order to enable and perform flashback operations
• Securing data by controlling user access with privileges
• Monitoring and optimizing space usage

Reviews Statistic

2 out of 2
2 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 2
1 Start 0

2 reviews for Oracle® Database 11g Administration

  1. 2 out of 5


    I would like to pursue this course

  2. 2 out of 5


    I like your breakdown

Add a review

Start On 2017-06-24
Duration 5 days
Level Master
Prerequisites Basic understanding of databases
Delivery Method Lectures & Hands-On Practice
Price 1,300.00

Location map

Share our course