Oracle DBA Made Simple Oracle Database Administration Techniques

Team DDU......Page 1
Notice......Page 4
Publication Information ......Page 5
Table Of Contents......Page 6
System Planning ......Page 11
Resource Specification for Oracle ......Page 12
Optimal Flexible Architecture (OFA) ......Page 17
Minimum OFA Configuration ......Page 18
Oracle Structures and How They Affect Installation ......Page 20
Data Files ......Page 21
Control Files......Page 22
Archive Logs......Page 23
Disk Striping, Shadowing, RAID, and Other Topics ......Page 24
Disk Striping ......Page 25
Disk Shadowing or Mirroring......Page 26
RAID-Redundant Arrays of Inexpensive Disks......Page 27
Optical Disk Systems......Page 28
RAM Drives (Random Access Memory) ......Page 29
Backup & recovery ......Page 30
Cold Backups......Page 31
Hot Backups......Page 33
Example Documentation Procedure for NT Online Backup and Recovery Scripts ......Page 58
Exports ......Page 61
IMPORT ......Page 63
Archive Logs ......Page 64
NT or UNIX System Backup......Page 66
Recovery Types ......Page 67
Oracle7 Enterprise Backup Utility......Page 69
Oracle8 RECOVERY MANAGER FACILITY......Page 73
Installing the RMAN Catalog ......Page 76
Incomplete restore scenario ......Page 79
DB_VERIFY UTILITY......Page 81
The following example shows how to get on-line help: ......Page 82
The DBMS_REPAIR Utility ......Page 83
DBMS_REPAIR Exceptions ......Page 84
DBMS_REPAIR Procedures ......Page 85
ADMIN_TABLES......Page 86
CHECK_OBJECT ......Page 91
DUMP_ORPHAN_KEYS......Page 94
FIX_CORRUPT_BLOCKS......Page 95
REBUILD_FREELISTS......Page 96
SKIP_CORRUPT_BLOCKS......Page 98
Oracle RDBMS Architecture......Page 99
Background Processes ......Page 100
Datafiles ......Page 104
Datafile Sizing ......Page 106
Rollback Segments......Page 112
Redo log files ......Page 114
Initialization File......Page 115
The Undocumented Initialization Parameters ("_") ......Page 136
The Initialization File Event Settings ......Page 155
SGA......Page 167
Modifying the INITORA ......Page 168
Use of the Default Pool......Page 169
Use of the RECYCLE Pool......Page 170
Tuning the Three Pools......Page 171
Shared Pool ......Page 172
Putting it All In Perspective......Page 190
What to Pin ......Page 195
The Shared Pool and MTS......Page 200
Large Pool Sizing......Page 201
A Matter Of Hashing ......Page 204
Disk IO and the Shared Pool......Page 208
Monitoring Library and Data Dictionary Caches ......Page 211
In Summary......Page 214
Find USER locking others/Kill problem USER ......Page 219
Killing From the Oracle Side......Page 223
Creating and starting the database ......Page 225
Database Creation......Page 226
Re-creation of a Database......Page 229
Database Startup and Shutdown ......Page 239
Startup......Page 240
Shutdown ......Page 242
Step 2: Tune the Data Design ......Page 244
Step 5: Tune Database Operations......Page 245
Step 7: Tune Memory Allocation ......Page 246
Step 8: Tune I/O and Physical Structure......Page 247
Tuning Summary ......Page 248
Layout & Fragmentation......Page 249
Tablespace Segments & Free Space ......Page 251
Tables & Indexes/Partitioning ......Page 252
The V$ views......Page 253
How are they used?......Page 254
The Optimizers & the Analyze Command ......Page 258
RULE Based Optimizer ......Page 259
COST Based Optimizer ......Page 260
Parallel query settings ......Page 263
Users ......Page 268
Altering Users ......Page 274
Dropping Users ......Page 275
Grants......Page 276
System Privileges......Page 277
Object Privileges......Page 286
Column Privileges......Page 291
Revoking Grants ......Page 293
Use Of Roles......Page 295
Creating Roles......Page 296
Grants To Roles ......Page 297
Setting Roles......Page 299
Special Roles ......Page 300
OSOPER And OSDBA......Page 302
CONNECT, RESOURCE, And DBA Roles ......Page 303
Export/Import Roles......Page 304
Using PROFILES......Page 305
Profiles and Resource Limits......Page 307
Altering Profiles......Page 310
Profiles and Passwords ......Page 311
Managing CPU Utilization for in Oracle8i......Page 313
Creating a Resource Plan ......Page 314
Restricting Access by Rows in Oracle8i ......Page 339
Policy Usage ......Page 345
DBMS_RLS Package......Page 347
Summary......Page 350