Getting Started with Database Administration: Types of Oracle Data base users – Database Administrators – Task of a Database administrators – Database administrator Security and Privileges – Database Administrator Authentication.
Starting up a Database – Altering Database availability – Shutting down a Database – Quiescing a Database – Suspending and Resuming a Database. Managing Processes: Dedicated Server Process - shared Server Process – Configuring Database resident Connection pooling
Monitoring Database operations: Monitoring Errors and alerts – Monitoring performance. Managing control files: Guidelines for control files – Creating control files – Backing up control files - Dropping control files. ManagingTablespaces:CreatingTablespaces–AlteringTablespaceavailability–Altering and managing Tablespaces – Dropping Tablespaces
Managing Data files and Temp files: Changing Data file size – Dropping Data files – Altering data file availability. Managing undo: Automatic Undo Management – Managing undo Tablespaces. ManagingTables:CreatingTables–LoadingTables–AlteringTables–RedefiningTables online – Dropping Tables – Managing Externaltables.
Managing Indexes: Creating Indexes – Altering Indexes – Monitoring space use of Indexes – DroppingIndexes. Managing Distributed Databases: Creating Database Links – Using shared Database Links – Managing Database Links – Viewing information about Database Links – creating Location Transparency
Reference Book:
1. “HowtobecomeanExceptionalDBA”,BradMMcGehee,Simple-TalkPublishing,Second Edition, 2009.ISBN:978-1-906434-22-9. 2. “DatabaseAdministration”,CraigS.Mullins,Addison-WesleyPublications,2018 ISBN : 978-0-321-82294-9 Text Book:
Text Book:
1. “Oracle Database – Administrator’s Guide”, Oracle, 2015