Oracle DBA Complete Tutorial_Wealth of Wisdom

 Table of Contents

1.1 #001  What is a Database? 4

1.2 #002  - DBA Role 4

1.3 #003  - OLTP vs OLAP Databases 5

1.4 #004  - What is Oracle 11g 5

1.5 #005  - What is Oracle 12c 6

1.6 #006  Database ABCS 8

1.6.1 DATA BLOCK 9

1.7 #007  Undo vs Redo Data 10

1.8 #008  - Oracle Instance vs Database 11

1.9 #009  Process Architecture 14

1.10 %010  - Database Writer Process 15

1.11 #011  - Log writer Process 16

1.12 #012  - Checkpoint Process (5 Scenarios) 17

1.13 #013  - SMON Process 18

1.14 %014  - PMON Process - Process Monitor 18

1.15 #015  - RECO Process - RECOVERER 19

1.16 #016  - Archiver Process 19

1.17 #017  - Memory Architecture SGA / PGA 20

1.18 #018  - Database Buffer Cache 21

1.19 #019  - Shared Pool 22

1.20 #020  - REDO log buffer 23

1.21 #021  - Large Pool 24

1.22 #022  - Java Pool and Streams Pool 24

1.23 #023  - Keep Buffer Pool 25

1.24 #024  - Recycle Buffer Pool 25

1.25 #025  - nK Buffer Cache 26

1.26 #026  - Program Global Area (PGA) 26

1.27 027  - Dedicated vs Shared Databases 27

1.28 %028  - PGA in a Shared Environment 27

1.29 %029  Architecture Full Picture 27

1.30 #030  - Virtual Machine Installation 28

1.31 #031  - Linux Installation 29

1.32 #032  - Oracle Software Installation 29

1.33 #033  - Oracle Parameter Files 29

1.34 #034  - Database creation Manual Method Demo 31

1.35 #035  - Verify Database creation 32

1.36 #036  - Database creation using DBCA Preferred option 32

1.37 #037  - Oracle Startup Steps 34

1.38 038  - Oracle Shutdown methods 38

1.39 039  - Oracle 12c Upgrade 39

1.40 #040  - How data is stored in a Database 39

1.41 #041  - Tablespace Concepts 39

1.41.1 Tablespace types 39

1.41.2 Default Tablespace - Used by Oracle DB - not for users 40

1.42 #042  - Online and Offline Tablespaces 40

1.43 #043  - Lets create a Tablespace 40

1.43.1 Create Tablespace 40

1.44 #044  - Tablespace Demo 1 41

1.45 #045  - Lets add more space to the Database 41

1.45.1 ALTER TABLESPACE 41

1.45.2 RESIZE DATAFILE 42

1.46 #046  - Tablespace Demo 2 42

1.47 #047  - Tablespaces with different block sizes 42

1.48 #048  - Temporary Tablespace Management. 43

1.49 #049  - Temporary Tablespace Groups 44

1.50 #050  - Extent Management Local vs Dictionary managed 45

1.51 #051  - UNDO Concepts 47

1.52 %052  - Read Consistency 48

1.53 %053  - ORA 01555 snapshot too old error 48

1.54 #054  - Automatic Undo Management 49

1.55 #055  - UNDO Management 49

1.56 #056  - Configuring Undo Retention Period 51

1.57 #057  - Retention Guarantee 53

1.58 #058  - REDO Concepts 54

1.59 #059  - REDO Logfile Management Demo 1 57

1.60 #060  REDO Logfile Management Demo 2 58

1.61 #061  - Archival Concepts 58

1.62 #062  - Archival Log Mode Demo 59

1.63 #063  - User Management Concepts 60

1.64 %064  - User Management Demo 1 63

1.65 #065  User Management Demo 2 64

1.66 #066  - Privileges 64

1.67 #067  - System Privileges Demo 69

1.68 #068  - Object Privileges Demo 69

1.69 #069  - Revoking User Privileges 70

1.70 #070  - Revoking System Privileges 71

1.71 #071  - Revoking Object Privileges 71

1.72 #072  - Creating users and tables 71

1.73 #073  - Role Management Concepts 71

1.74 #074  - Role Management Demo 74

1.75 #075  - User Profiles 74

1.76 #076  - User Profile Demo 77

1.77 #077  - Managing Passwords using Profiles 78

1.78 #078  Networking Concepts 78

1.79 #079  - Listener Configuration Demo 84

1.80 #080  TNSNAMES Configuration Demo 92

1.81 94

1.82 #081  - Database Link Concepts 94

1.82.1 Public DB Links 94

1.82.2 Private DB LInks 94

1.83 #082  - Public Database Link 94

1.84 #083  - Private Database Link 95

1.85 #084  - What is Data Dictionary 95

1.86 #085  - Static Data Dictionary Views 98

1.87 #086  - Dynamic Data Dictionary Views 100

1.88 #087  - Miscellaneous Data Dictionary Views 100

1.89 #088  - Data Dictionary Demo 101

1.90 #089  - What is Diagnostic Data 102

1.91 #090  - Automatic Diagnostic Repository (ADRCI) 103

1.92 %091  - Manually navigating through Diagnostic Data 106

1.93 #092  - ADRCI - utility 107

1.94 #093  - Using ADRCI to navigate through Diagnostic Data 107

1.95 094  - Creating an Incident Package for Oracle Support 108