oracle 10g database administration

ahana systems and solutions pvt ltd
bangalore, india

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: chidananda murthy

Course Description:

'' oracle 10g database administration

* oracle 10g database administration - i
* oracle 10g database administration - ii

oracle 10g database administration - i

course contents:

basic database administration
* overview of administering an oracle database
* types of oracle database users
* tasks of a database administration

creating an oracle database
* deciding how to create an oracle database
* manually creating an oracle database
* understanding the create database statement
* understanding initialization parameters
* troubleshooting database creation
* dropping a database
* managing initialization parameters using a server parameter file

starting up and shutting down
* starting up a database
* altering database availability
* shutting down a database
* quiescing a database
* suspending and resuming a database

managing oracle database processes
* about dedicated and shared server processes
* configuring oracle database for shared server
* about oracle database background processes

managing control files
* guidelines for control files
* creating control files
* troubleshooting after creating control files
* backing up control files
* recovering a control file using a current copy
* dropping control files

managing the redo log
* basic working of redo log
* planning the redo log
* creating redo log groups and members
* relocating and renaming redo log members
* dropping redo log groups and members

managing archived redo logs
* what is the archived redo log?
* choosing between noarchivelog and archivelog mode
* controlling archiving
* specifying the archive destination
* specifying the mode of log transmission
* managing archive destination failure

managing5?spaces
* guidelines for managing5?spaces
* creating5?spaces
* altering5?space availability
* using read-only5?spaces
* renaming5?spaces
* dropping5?spaces
* managing the sysaux5?space
* viewing5?space information

managing datafiles and tempfiles
* guidelines for managing datafiles
* creating datafiles and adding datafiles to a5?space
* changing datafile size
* altering datafile availability
* renaming and relocating datafiles
* dropping datafiles
* copying files using the database server

managing the undo5?space
* what is undo?
* introduction to automatic undo management
* setting the undo retention period
* sizing the undo5?space
* managing undo5?spaces

using oracle-managed files
* what are oracle-managed files?
* enabling the creation and use of oracle-managed files
* creating oracle-managed files
* using automatic storage management



oracle 10g database administration - ii

course contents:

using automatic storage management
* what is automatic storage management?
* overview of the components of automatic storage management
* administering an automatic storage management instance
* administering automatic storage management disk groups
* using automatic storage management in the database

managing schema objects
* creating multiple5?s and views in a single operation
* analyzing5?s, indexes and clusters
* truncating5?s and clusters
* renaming schema objects

managing space for schema objects
* managing space in data blocks
* managing storage parameters
* managing resumable space allocation

managing5?s
* about5?s
* guidelines for managing5?s
* creating5?s
* loading5?s
* automatically collecting statistics on5?s
* altering5?s
* redefining5?s online
* using flashback drop and managing the recycle bin
* managing index-organized5?s
* managing external5?s

managing indexes
* about indexes
* gidelines for managing indexes
* creating indexes
* altering indexes
* monitoring space usage of indexes
* dropping indexes

managing partitioned5?s and indexes
* about partitioned5?s and indexes
* partitioning methods
* creating partitioned5?s
* maintaining partitioned5?s
* dropping partitioned5?s

managing clusters
* about clusters
* guidelines for managing clusters
* creating clusters
* altering clusters
* dropping clusters

loading and unloading data
* introduction to the data pump architecture
* benefits of data pump technology
* using data pump export and import
* monitoring a data pump job
* creating external5?s for data population
* defining external5? properties

manageability infrastructure
* the automatic workload repository (awr)
* active session history (ash)
* server-generated alerts
* the automated tasks feature
* the management advisory framework

the oracle scheduler and the database resource manager
* simplifying management tasks using the scheduler
* managing the basic scheduler components
* managing advanced scheduler components
* managing scheduler attributes

backup and recovery enhancements
* using the flash recovery area
* using incremental backups
* enhanced rman commands
* miscellaneous backup and recovery enhancements

flashback technology enhancements
* general flashback technology considerations
* flashback drop
* flashback5?
* row level flashback features
...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

ahana systems & solutions (p) ltd.

105/22, ist floor, 50 feet road
hanumanth nagar, near nirmala store bus stop
banashankari, bangalore ï¿?560050

Jobs & Resumes: bangalore
Houses & Roommates: bangalore
Travel Agencies: bangalore

Search other schools for oracle 10g database administration training resources.

oracle database administration
oracle 10g rac
sybase database administration
fast track to adaptive server enterprise
sybase t-sql
sybase configuring adaptive server
mysql database administration
Perl Script
Shell Script
ClearCase Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.