+612 9045 4394
Oracle Database Administration - The Essential Reference : Essential Reference - David C Kreines

Oracle Database Administration - The Essential Reference

Essential Reference

Paperback Published: 12th May 1999
ISBN: 9781565925168
Number Of Pages: 584

Share This Book:


RRP $63.95
Ships in 15 business days

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis.

This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions.

Oracle Database Administration provides two types of material:

  • DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities
  • DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax

The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.

'If you want a good, solid, practical reference guide covering both Oracle 7 and 8, look no further.' Dave Rutlidge, Cvu, February 2001

Prefacep. xi
DBA Tasksp. 1
Introductionp. 3
Oracle Database Administrationp. 3
Oracle Architecturep. 6
Software Optionsp. 9
Configuration Planningp. 15
Installationp. 20
Media Selectionp. 21
The Oracle Installerp. 22
Installable Componentsp. 23
Dependenciesp. 24
Pre-Installation Checklistp. 24
Critical Decisionsp. 24
Post-Installation Tasksp. 27
Maximizing Oracle Performancep. 37
Configuration and Tuning--What's the Difference?p. 38
Achieving Maximum Performancep. 40
Configuring the Operating Systemp. 40
Configuring Oraclep. 41
Sizing and Configuring Database Objectsp. 46
Tuning Oraclep. 51
Preventing Data Lossp. 61
Types of Backupsp. 61
Database Backupp. 64
Database Recoveryp. 69
Automated Utilitiesp. 73
Practice Scenariosp. 73
Oracle Networkingp. 77
Oracle Network Architecturep. 77
Oracle Namesp. 83
MultiProtocol Interchangep. 84
Connecting to Non-Oracle Databasesp. 85
Oracle Network Managerp. 87
Oracle Net8 Assistantp. 89
Manual Network Configurationp. 90
Sample SQL*Net Filesp. 90
SQL*Net Troubleshootingp. 92
Security and Monitoringp. 97
Securityp. 97
Monitoringp. 108
Auditingp. 116
About Auditingp. 116
Forms of the AUDIT Statementp. 118
Audit Trail Views and Lockup Tablesp. 124
Establishing an Audit Policyp. 126
Maintaining the Audit Trailp. 127
Row-Level Auditingp. 129
Query Optimizationp. 131
Types of Queriesp. 131
Types of Join Access Pathsp. 133
Determining the Access Planp. 134
Cost-Based Optimizerp. 139
Rule-Based Optimizerp. 157
Oracle Toolsp. 163
About the Toolsp. 163
SQL*Plusp. 164
Oracle Server Managerp. 168
SQLDBAp. 169
Oracle Network Managerp. 170
SQL*Loaderp. 171
Oracle Enterprise Managerp. 172
Third-Party Toolsp. 175
DBA Referencep. 177
The Oracle Instancep. 179
Elements of the Instancep. 179
About Processesp. 181
About Memory Structuresp. 187
The Oracle Databasep. 193
Types of Database Filesp. 193
Oracle Tablespacesp. 200
Disk Allocationp. 208
Initialization Parametersp. 212
Dynamically Modifiable Parametersp. 213
Platform-Specific Parametersp. 216
Summary of Initialization Parametersp. 217
Parameters Used Only in Oracle7p. 276
Parameters New in Oracle8p. 277
SQL Statements for the DBAp. 279
SQL Commands by Taskp. 279
SQL Command Syntaxp. 283
The Oracle Data Dictionaryp. 416
Static Data Dictionary Viewsp. 417
Dynamic Performance Data Dictionary Viewsp. 431
System Privileges and Initial Rolesp. 449
Actions, Privileges, and Rolesp. 449
System Privilegesp. 450
Initial Rolesp. 460
Initial Usersp. 465
Tools and Utilitiesp. 471
SQL*Plusp. 471
Exportp. 501
Importp. 506
SQL*Loaderp. 512
Appendix: Resources for the DBAp. 523
Indexp. 527
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781565925168
ISBN-10: 1565925165
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 584
Published: 12th May 1999
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 23.5 x 18.42  x 3.18
Weight (kg): 0.88

This product is categorised by