Portable DBA Oracle

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780072229806 | 0072229802
Cover: Paperback
Copyright: 11/22/2004

Buy New

This is a hard-to-find title. We are making every effort to obtain this item, but do not guarantee stock.

$51.43

This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command.

Acknowledgments

xix

Introduction

xxi

DBA Cheat Sheet

(28)

Database Creation and-Management

(28)

Introduction to Oracle Database Creation

(17)

Creating a Database: Prerequisites

(1)

Creating a Database: The create database Command

(2)

Creating a Database: Security Issues

(1)

Creating a Database: Recommended Practices

(1)

The create database Command: Examples

(1)

Creating a Database Manually: A Checklist

(8)

Creating a Database: Error Resolution Table

(2)

Other Typical Errors Associated with the create database Command

(1)

The alter database Command

(8)

Functions of the alter database Command

(1)

Common Tasks Accomplished with alter database

(5)

Error Messages Associated with the alter database Command

(2)

Removing Your Oracle Database

(2)

Rollback/Undo Segments, Control Files, and Redo Logs

(28)

Oracle Undo

(13)

Automated Undo Management

(4)

Manual Rollback Segment Administration

(4)

Monitoring Rollback Segments and Automated Undo

(2)

Oracle Errors Associated with Rollback Segments and Automated Undo

(3)

Control File Administration

(7)

Control File Backups

(1)

Moving the Control File

(1)

Restoring the Control File

(1)

Renaming the Database

(2)

Oracle Errors Associated with Control Files

(2)

Online Redo Log Administration

(7)

The Basics of Online Redo Logs

(1)

Creating New Redo Log Groups

(1)

Creating New Redo Log Members

(1)

Dropping an Online Redo Log Group

(1)

Dropping an Online Redo Log Group Member

(1)

Resizing Online Redo Logs

(1)

Clearing an Online Redo Log

(1)

Monitoring Online Redo Logs

(1)

Archived Redo Logs

(1)

Oracle Errors Associated with Online Redo Logs

(3)

Tablespaces

(18)

About Oracle Tablespaces

(4)

The Oracle Tablespace

(3)

Temporary Tablespaces

(1)

Undo Tablespaces

(1)

Creating Tablespaces

(5)

extent_management_clause

(1)

segment_management_clause

(1)

Security Requirements

(1)

About OMF

(1)

create tablespace Examples

(1)

Altering Tablespaces

(2)

Security Requirements

(1)

alter tablespace Examples

(1)

Dropping Tablespaces

(1)

Security Requirements

(1)

drop tablespace Examples

(1)

Tablespace Data Dictionary Information

(1)

Tablespace-Related Errors

(1)

Tablespace Naming Standards

100

(1)

Datafile Naming Standards

101

(2)

Tables

103

(38)

Oracle Data Types

104

(8)

Notes on Various Data Types

107

(5)

Table Types

112

(2)

Relational Tables

113

(1)

Temporary Tables

113

(1)

External Tables

113

(1)

Index-Organized Tables

113

(1)

Constraints

114

(1)

Table Attributes

114

(1)

Parallel Processing

115

(1)

Partitioning

116

(1)

Other Table-Related Features

116

(1)

Creating Tables

117

(11)

Security Requirements

117

(4)

Sizing Tables Assigned to a Locally Managed Tablespace

121

(1)

Examples of Using the create table Command

121

(7)

Altering Tables

128

(8)

Security Requirements

128

(1)

Altering Nonpartitioned Table Examples

129

(5)

Altering Partitioned Tables

134

(2)

Dropping Tables

136

(1)

Security Requirements

136

(1)

Examples

136

(1)

Table-Related Data Dictionary Information

137

(1)

Table-Related Errors

138

(1)

Table-Related Recommended Standards

139

(2)

Indexes

141

(24)

Indexing Overview

142

(11)

Oracle Index Types

142

(4)

Miscellaneous Index Features

146

(7)

Creating Indexes

153

(4)

Security Requirements

153

(1)

Examples Using the create index Command

153

(4)

Altering Indexes

157

(4)

Security Requirements

158

(1)

Nonpartitioned alter index Examples

158

(2)

Examples Using the Partitioned alter index Commands

160

(1)

Dropping Indexes

161

(1)

Security Requirements

161

(1)

Drop Index Example

162

(1)

Index-Related Data Dictionary Information

162

(1)

Index-Related Errors

162

(1)

Recommended Standards

163

(2)

Index Location Standards

164

(1)

Index Naming Standards

164

(1)

Views

165

(10)

Updateable Views

166

(2)

Other View Considerations

168

(1)

Security Benefits of Views

168

(1)

View Triggers

168

(1)

Creating Views

169

(2)

Security Requirements

169

(1)

Examples of Using the create view Command

169

(2)

Altering Views

171

(1)

Security Requirements

171

(1)

alter view Examples

171

(1)

Dropping Views

172

(1)

Security Requirements

172

(1)

drop view Examples

172

(1)

View-Related Data Dictionary Information

172

(1)

View-Related Errors

173

(1)

View-Related Recommended Standards

173

(2)

Clusters

175

(8)

Cluster Performance

176

(1)

Creating Clusters

177

(1)

Security Requirements

177

(1)

create cluster Examples

177

(1)

Altering Clusters

178

(1)

Security Requirements

179

(1)

Examples of Using the alter cluster Command

179

(1)

Dropping Clusters

179

(1)

Security Requirements

179

(1)

drop cluster Example

179

(1)

Cluster-Related Data Dictionary Information

180

(1)

Cluster-Related Errors

180

(3)

Sequences and Synonyms

183

(12)

Sequences

184

(5)

All About Sequences

184

(1)

Creating Sequences

184

(2)

Altering Sequences

186

(2)

Dropping Sequences

188

(1)

Sequence-Related Data Dictionary Information

188

(1)

Sequence-Related Errors

188

(1)

Sequence-Related Recommended Standards

189

(1)

Synonyms

189

(6)

Creating Synonyms

189

(3)

Altering Synonyms

192

(1)

Dropping Synonyms

192

(1)

Synonym-Related Data Dictionary Information

193

(1)

Synonym-Related Errors

193

(1)

Synonym-Related Recommended Standards

193

(2)

Users, Profiles, Roles, and Grants

195

(24)

Administration of Users

196

(4)

Creating Users

197

(1)

Altering Users

197

(1)

Dropping Users

198

(1)

User-Related Data Dictionary Information

199

(1)

User-Related Errors

199

(1)

User-Related Recommended Standards

200

(1)

Administration of Profiles

200

(5)

Creating Profiles

202

(1)

Altering Profiles

203

(1)

Dropping Profiles

204

(1)

Profile-Related Data Dictionary Information

204

(1)

Profile-Related Errors

205

(1)

Administration of System and Object Privileges

205

(10)

Object Grants

205

(1)

System Grants

206

(4)

Using the with admin option Clause

210

(1)

Using the with grant option Clause

211

(1)

Public Grants

211

(1)

Granting Privileges

211

(2)

Revoking Privileges

213

(1)

System and Object Privileges Data Dictionary Information

213

(1)

System and Object Privileges-Related Errors

214

(1)

System and Object Privileges-Related Recommended Standards

215

(1)

Administration of Roles

215

(4)

Common Oracle-Provided Roles

216

(1)

Creating Roles

216

(1)

Altering Roles

217

(1)

Dropping Roles

217

(1)

Role-Related Data Dictionary Information

218

(1)

Role-Related Errors

218

(1)

Miscellaneous Administrative Features

219

(34)

Oracle Export Utility

220

(4)

The exp Utility Command Line

220

(2)

exp Utility Examples

222

(2)

Oracle Import Utility

224

(4)

The imp Utility Command Line

224

(2)

imp Utility Examples

226

(2)

Oracle Data Pump (Oracle Database 10g)

228

(11)

Oracle Data Pump Export

228

(5)

Oracle Data Pump Import

233

(4)

Oracle Data Pump Interactive Mode

237

(1)

Data Pump Export: Interactive Mode Parameters

238

(1)

Oracle Backups

239

(5)

Oracle Database Cold Backups

240

(1)

Oracle Database Hot Backups

241

(2)

Other Oracle Backups

243

(1)

Database Recovery

244

(9)

Recovering from a Manual Cold Backup (In NOARCHIVELOG Mode)

244

(1)

Recovering from a Manual Cold Backup (In ARCHIVELOG Mode)

245

(1)

Recovering from an RMAN Cold Backup (NOARCHIVELOG Mode)

245

(1)

Recovering from an RMAN Cold Backup (In ARCHIVELOG Mode)

245

(1)

Recovering from a Manual Hot Backup

245

(2)

Recovering from an RMAN Hot Backup

247

(1)

Incomplete Database Recovery

248

(1)

Database Control File Recovery

249

(4)

The Optimizer

253

(28)

Optimizer Modes

254

(1)

Rule Based Optimizer (RBO)

254

(1)

Cost Based Optimizer (CBO)

254

(1)

SQL Tuning

255

(1)

Reduce the Work

255

(1)

Balance the Work

255

(1)

Fine-Tune the Work

255

(1)

Identifying Poor SQL

256

(2)

V$SQL View

256

(1)

SQL Trace

256

(1)

Statspack

257

(1)

Automatic Database Diagnostic Monitor

257

(1)

Tuning Advisors

258

(1)

Optimizer Statistics

258

(9)

analyze Command

258

(1)

dbms_stats Package

259

(8)

Automatic Statistics Gathering

267

(1)

Execution Plans

267

(2)

Access Paths

267

(1)

Joins

268

(1)

Optimizer Hints

269

(5)

Specifying Hints

269

(1)

Optimizer Mode Hints

270

(1)

Access Path Hints

270

(2)

Join Hints

272

(1)

Parallel Hints

272

(1)

Miscellaneous Hints

273

(1)

explain plan Command

274

(3)

Running explain plan

274

(1)

Displaying explain plan Output

275

(1)

Interpreting explain plan Output

275

(1)

dbms_xplan Package

276

(1)

Plan Stability

277

(4)

Creating Outlines

278

(1)

Using Outlines

278

(1)

Moving Outlines

279

(1)

Managing Outlines

279

(2)

Miscellaneous Commands

281

(26)

The alter system Command

282

(6)

Security Requirements

282

(1)

alter system Examples

282

(4)

alter system-Related Data Dictionary Information

286

(1)

alter system-Related Errors

286

(2)

The alter session Command

288

(5)

Security Requirements

288

(1)

Examples of Using the alter session Command

288

(4)

alter session-Related Data Dictionary Information

292

(1)

alter session-Related Errors

292

(1)

The create directory/drop directory Commands

293

(2)

Security Requirements

293

(1)

create directory Examples

293

(1)

drop directory Example

293

(1)

create directory-- /drop directory-Related Data Dictionary Information

294

(1)

create directory-- /drop directory-Related Errors

294

(1)

The comment Command

295

(1)

Security Requirements

295

(1)

comment Examples

295

(1)

comment-Related Data Dictionary Information

296

(1)

comment-Related Errors

296

(1)

The lock table Command

296

(2)

Security Requirements

296

(1)

lock table Examples

297

(1)

lock table-Related Data Dictionary Information

297

(1)

lock table-Related Errors

298

(1)

The purge Command

298

(2)

Security Requirements

298

(1)

purge Examples

298

(1)

purge-Related Data Dictionary Information

299

(1)

purge-Related Errors

300

(1)

The rename Command

300

(1)

Security Requirements

300

(1)

rename Examples

300

(1)

rename-Related Data Dictionary Information

301

(1)

rename-Related Errors

301

(1)

The set constraints Command

301

(1)

Security Requirements

301

(1)

set constraints Examples

301

(1)

set constraints-Related Data Dictionary Information

302

(1)

set constraints-Related Errors

302

(1)

The set transaction Command

302

(2)

Security Requirements

303

(1)

set transaction Examples

303

(1)

set transaction-Related Errors

303

(1)

The create database link/drop database link Commands

304

(3)

Security Requirements

304

(1)

create database link/drop database link Examples

304

(1)

create database link-/drop database link-Related Data Dictionary Information

305

(1)

create database link-Related Errors

306

(1)

Built-in Functions

307

(28)

Introducing Oracle Built-in Functions

308

(27)

Single-Row Functions

308

(7)

Aggregate Functions

315

(1)

Analytic Functions

316

(2)

Object Reference Functions

318

(1)

Model Functions

318

(1)

Examples of Commonly Used Functions

318

(17)

DML Commands

335

(38)

The select Command

336

(20)

Security Requirements

336

(1)

Common Elements in a select Command

336

(5)

Other Elements in a select Command

341

(14)

select Command-Related Error Messages

355

(1)

The insert Command

356

(5)

Security Requirements

356

(1)

Specifics of the insert Command

356

(4)

insert Command-Related Error Messages

360

(1)

The update Command

361

(3)

Security Requirements

361

(1)

Specifics of the update Command

361

(1)

update Command Examples

362

(1)

update Command-Related Error Messages

363

(1)

The delete Command

364

(2)

Security Requirements

364

(1)

Specifics of the delete Command

364

(1)

delete Command Examples

365

(1)

delete Command-Related Error Messages

365

(1)

The merge Command

366

(2)

Security Requirements

366

(1)

Specifics of the merge Command

366

(1)

merge Command Examples

366

(1)

merge Command-Related Error Messages

367

(1)

The commit Command

368

(1)

Security Requirements

368

(1)

commit Command Examples

368

(1)

The savepoint Command

368

(1)

The rollback Command

368

(1)

Security Requirements

368

(1)

rollback Command Examples

369

(1)

The truncate Command

369

(1)

Security Requirements

369

(1)

Specifics of the truncate Command

369

(1)

truncate Command Examples

370

(1)

truncate Command-Related Error Messages

370

(1)

Writing Readable DML Statements

370

(3)

A Initialization Parameters

373

(38)

Parameter Files

374

(1)

Initialization Parameter File

374

(1)

Server Parameter Files

374

(1)

Displaying Parameter Values

375

(2)

show parameter

375

(1)

V$System_PARAMETER

376

(1)

V$PARAMETER

376

(1)

V$PARAMETER2

376

(1)

V$SPPARAMETER

376

(1)

The Parameters

377

(34)

B Data Dictionary Views

411

(24)

USER_, ALL_, and DBA_

412

(1)

DBA_ View

412

(12)

Miscellaneous Views

424

(1)

V$ Views

425

(10)

C Oracle SQL Syntax

435

(144)

Index

579

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Portable DBA Oracle

Summary

Author Biography

Table of Contents

Supplemental Materials