ORACLE DATABASE ADMIN COURSE CONTENT
By
www.learninghub.co.in
+91-93257-93756
gmail: learninghub01@gmail.com
skype:learning.hub01
This is class room based training by conducted by Senior Oracle database Administrator
1: Creating the Database2: Starting Up and Shutting DownViewing the Quiesce State of an InstanceSuspending and Resuming a Database 3: Managing Oracle Database ProcessesTerminating SessionsIdentifying Which Session to TerminateTerminating an Active SessionTerminating an Inactive Session 4: Monitoring the Operation of Your Database Server-Generated AlertsMonitoring the Database Using Trace Files and the Alert LogMonitoring LocksMonitoring Wait Events Process and Session Views 5: Oracle Database Structure and StorageManaging Control FilesManaging the Redo LogManaging Archived Redo Logs6: Managing Table spacesTransportable Table spaces 7: Managing Data files and Temp files8: Managing the Undo Table spaceundo retention, switching undo table space9: User managementcreation of users and roles, assign privileges10:Automatic Storage Managementcreate ASM instance, create disk groups11:Managing Schema ObjectsTables, indexes, views, synonyms and sequence generatorSpace managementManaging resumable space allocation, reclaiming wasted spaceManaging Tablesadding, renaming and dropping of table columnsManaging IndexesB*tree, bitmapManaging Partitioned Tables and IndexesRange, hash,list and composit partitioningManaging Clusterscreation and altering of clustersManaging Views, Sequences, and SynonymsOracle Network Listener and tnsnamesDistributed Database ConceptsUtilitiesData pump , SQL*LoaderBackup and RecoveryRmanPerformance TuningData Guardconfiguring physical standby database Miscellaneous
