Oracle DBA 101: A Beginner's Guide

by Rao R. Uppaluri

Overview

There is a dearth of Oracle Database Administrators inspite of having a large number of Oracle Programmers/Analysts. It is not difficult to rationalise the reason for this. Oracle Database Administration (DBA) is relatively harder to grasp and the concepts are subtle. There are a handful of books, all exhaustive treatises, on this topic, in addition to those by Oracle Corporation. There are no elementary books to smoothly introduce this fascinating topic. The present book, "Oracle DBA 101: A Beginner's Guide" is expected to fill this vital gap. At the beginner's level, it deals with all important aspects of Oracle DBA in a simplified manner. This is a Teacher's as well as Student's tool for an introductory course on the topic.

Product Details

ISBN-13:	9781581127645
Publisher:	Universal Publishers
Publication date:	01/20/2000
Pages:	132
Product dimensions:	5.50(w) x 8.50(h) x 0.31(d)

Table of Contents

	Preface	3
	List of Illustrations	9
Chapter 1	Oracle Database	11
1.1	Memory Structures	13
1.2	Shared SQL Pool	15
1.3	Dictionary Cache	15
1.4	Redolog Buffers	16
1.5	SMON, PMON, DBWR, LGWR	16
1.6	Redolog Files	19
1.7	Control File	20
1.8	Restaurant Example	20
1.9	Standard_Meal.Ora	21
1.10	Family_Meal.Ora	23
1.11	Instance	25
1.12	Database Creation	29
1.13	Database Startup	29
1.14	Database Shutdown	30
1.15	Alert Logs	30
Chapter 2	Tables	31
2.1	Table Size: VSIZE parameter	32
2.2	Index	39
2.3	Primary/Foreign Key	41
2.4	Sizing Indexes (Non-clustered Tables)	43
2.5	Sizing Indexes (Clustered Tables)	44
Chapter 3	DBA Routine Monitoring	48
3.1	Resource Utilisation	48
3.1.1	Tablespace: Allocated and Used	49
3.1.2	View Creation	49
3.1.3	Synonym Creation	50
3.1.4	Freespace	51
3.2	Fragmentation	53
3.2.1	Contig_Space	54
3.2.2	Dba_Free_Space	55
3.3	Other Useful Views	58
3.3.1	Dba_Tables	59
3.3.2	Sys.dba_Extents	62
Chapter 4	Preventive Measures	64
4.1	Library Cache	67
4.2	Data_Dictionary_Cache	69
4.3	Threaded Server Session Memory	70
4.4	Overall Statistics	70
4.5	Disk I/O Traffic	72
4.6	Latch Statistics	74
4.7	RBS Contention	74
4.8	Redolog Buffer Contention	75
4.9	Sort Memory Contention	75
4.10	Problematic SQL Statements	77
Chapter 5	Security in Oracle	78
5.1	User Account	78
5.2	Roles	81
5.2.1	Role Creation	82
5.3	Admin	83
5.4	Profile	83
5.5	Grant	84
5.6	Some Views of Privileges	86
5.6.1	Dba_Sys_Privs	86
5.6.2	Dba_Role_Privs	87
5.6.3	Dba_Tab_Privs	87
Chapter 6	Rollback Segments	88
6.1	RBS Creation	91
6.2	Rollback Entries	92
6.3	Details of RBS	94
6.4	Estimation of RBS Size	95
6.4.1	RBS Tablespace Creation	99
6.4.2	RBS with Optimal	99
6.5	Entry Size in RBS	99
6.6	Utlbstat and Utlestat	100
6.7	Data vs RBS	100
Chapter 7	Backup And Recovery	102
7.1	OS Backup	102
7.2	Cold Backup	103
7.3	Warm Backup	103
7.4	Export/Import Utility	106
7.5	RBS for Import	109
7.6	Pitfalls in Export/Import	110
7.7	Commands For Export/Import	111
7.8	Comparison of Different Backup Methods	112
7.9	Warm Backup Commands	112
7.9.1	Warm Backup Begin/End	113
7.10	Recovery	114
7.11	Standby Database	115
7.12	Instance Failure	115
7.13	Role of DBA	116
Chapter 8	Audit	117
8.1	Session Audit	117
8.2	Object Action Audit	119
Chapter 9	Application Tuning	122
9.1	Introduction	122
9.2	Interest Calculation	123
9.2.1	Sort	123
9.2.2	Interchange of columns of Primary Key in Select Statement	124
9.2.3	Function	125
9.2.4	Commit	125
	Index	126