Transcription
Call: 415 685 5249b1onlinetrainings@gmail.comOracle 11g DBA Course Content:35-40hoursCourse OutlineINTRODUCTION TO ORACLE DBA What is DBA?Why a Company needs a DBA?Roles & Responsibilities of DBAOracle ArchitecturePhysical and Logical Phase of DatabaseTypes of files(Control file, Redo log file and Data file)Different types of Data filesInstanceSGA(System Global Area) and Background ProcessDATABASE CREATION Different Startup ModesDifferent Shutdown ModesTypes of Database CreationManual Method of CreationTABLESPACE MANAGEMENTIntroduction to Table spaceTypes of Table space(BIG & SMALL)Temporary Table spaceAltering/Renaming a Table spaceRenaming a data fileTemporary GroupsTable space Encryption(11g)STORAGE PARAMETERS What are segments?What are extents?What is Blocks?www.b1onlinetrainings.com
Call: 415 685 5249b1onlinetrainings@gmail.com Oracle BlocksEstimation of ExtentsDictionary Managed Table spaceLocally Managed Table spaceStorage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)USER MANAGEMENT Who are Database Users?Why to create a User?Creation of UsersAssigning PrivilegesCreating and granting RolesAllocating table space Quotas to UsersAssigning default table space for the UsersSetting Profiles for the UsersLevels of AuthenticationSchema Management(11g)Security(11g)UNDO MANAGEMENT What is Undo?Why Undo required?Pending offline statusBrief idea about Rollback segmentsFlashback FeaturesFlashback TableFlashback queryFlashback Version querySPFILE & OMF What is spfile?Difference between spfile and pfileAdvantages of spfileWhat is OMF?Advantages of OMFFiles conventions of OMFNETWORKING IN ORACLE Introduction to Oracle Networkingwww.b1onlinetrainings.com
Call: 415 685 5249b1onlinetrainings@gmail.com Network default locationEditing Network fileListener.oraTnsnames.oraIntroduction to Database LinksTypes of Database LinksIntroduction to Materialized viewsAdvantages of Materialized viewRefresh ModesREDO-LOG & CONTROLFILE MANAGEMENT Introduction to Redo logStatus of Redo logsMultiplexing the Redo log filesRe-creation of Control fileRenaming the DatabaseMultiplexing the Control fileLOGICAL BACKUP What is a logical backupWhy it is requiredExport/import UtilityData PumpDifference between Data Pump and Traditional Export/importImpdp/expdpTransportable Table spacesPHYSICAL BACKUP Introduction to Physical backupTypes of Physical backupCold & Hot backupRecovery scenariosRMAN backupRMAN Point in time recoveryRMAN 11g new featuresPEFORMANCE TUNING What is Performance Tuning?Why Tuning required?www.b1onlinetrainings.com
b1onlinetrainings@gmail.com Call: 415 685 5249Types of TuningDatabase TuningApplication TuningSQL TuningMemory TuningNetwork TuningPartitioning and IndexesPartitioning EnhancementsAWR/ASH/ASMM/ADDMRAT(Real Application Testing)(11g)SQL Performance Analyses (11g)Row chaining and Row migrationResemble Table spacesAVAILABILITY Introduction to Data GuardTypes of Standby databases11g New features in Data GuardTypes of Protection modesActive standby/snapshot standby(11g)Log MinerRMAN Point in time RecoveryIntroduction to Database CloningRMAN CloningAutomatic Storage Management(ASM)SQL-LOADER Introduction to SQL LoaderTypes of filesControl fileIn fileBad fileDiscard fileData fileAUDITING What is auditing?Why auditing performed?Types of AuditingLevels of Auditingwww.b1onlinetrainings.com
Call: 415 685 5249b1onlinetrainings@gmail.comFLASHBACK FEATURES Flashback DatabaseFlashback Archive(11g)MISCELLANEOUS Oracle 11g InstallationsComparison between Oracle 10g and Oracle 11gNew features Introduced in Oracle 10gUp gradation from Oracle 10g to Oracle11gwww.b1onlinetrainings.com
What is Performance Tuning? Why Tuning required? b1onlinetrainings@gmail.com Call: 415 685 5249 www.b1onlinetrainings.com Types of Tuning . Comparison between Oracle 10g and Oracle 11g New features Introduced in Oracle 10g Up gradation from Oracle 10g to Oracle11g .
