+612 9045 4394
 
CHECKOUT
Oracle9I Dba Handbook : Oracle Press - Kevin Loney

Oracle9I Dba Handbook

Oracle Press

Paperback

Published: 19th December 2001
Ships: 7 to 10 business days
7 to 10 business days
RRP $127.95
$95.50
25%
OFF
or 4 easy payments of $23.88 with Learn more

This authorized guide from Oracle Press explains how implement all the new features of Oracle9"i" and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9"i" Application Server, external tables, flashback queries, and much more.

Acknowledgmentsp. xxi
Introductionp. xxiii
Database Architecture
Getting Started with the Oracle Architecturep. 3
Overview of Databases and Instancesp. 4
About Software Installationp. 10
Creating a Databasep. 13
Background Processesp. 33
Internal Database Structuresp. 37
Hardware Configurations and Considerationsp. 61
Architecture Overviewp. 62
Stand-Alone Hostsp. 63
Networked Hostsp. 71
Planning and Managing Tablespacesp. 87
The End Productp. 88
The Optimal Flexible Architecture (OFA)p. 88
Commonsense Logical Layoutsp. 101
Solutionsp. 103
Physical Database Layoutsp. 105
Database File Layoutp. 106
Verification of I/O Estimatesp. 118
Solutionsp. 120
File Locationp. 124
Database Space Usage Overviewp. 125
Resizing Datafilesp. 134
How to Move Database Filesp. 135
How to Deallocate Space from Segmentsp. 146
Using Oracle Managed Files (OMFs)p. 150
Physically Fitp. 153
Database Management
Managing the Development Processp. 157
Three Critical Elements of Successp. 158
Cultural Processesp. 159
Management Processesp. 160
Technologyp. 202
Managing Package Developmentp. 203
The Managed Environmentp. 207
Monitoring Space Usagep. 209
Common Problem Areasp. 210
Target Selectionp. 214
The End Productp. 214
Creating the Command Center Databasep. 218
Monitoring Memory Objectsp. 237
Additional Alerts and Warningsp. 238
The Well-Managed Databasep. 246
Managing Transactionsp. 247
Rollback Segments Overviewp. 248
Space Usage Within Rollback Segmentsp. 254
Monitoring Rollback Segment Usagep. 260
Using Oracle Enterprise Manager to Manage Rollback Segmentsp. 267
Choosing the Number and Sizep. 272
Solutionsp. 277
Using Undo Tablespacesp. 279
Database Tuningp. 283
Tuning Application Designp. 284
Tuning SQLp. 289
Tuning Memory Usagep. 297
Tuning Data Storagep. 305
Tuning Data Manipulationp. 317
Tuning Physical Storagep. 324
Tuning Logical Storagep. 325
Reducing Network Trafficp. 325
Using OEM and the Performance Tuning Packsp. 334
Tuning Solutionsp. 341
Using STATSPACKp. 345
Installing STATSPACKp. 346
Database Security and Auditingp. 357
Security Capabilitiesp. 358
Implementing Securityp. 359
Limiting Available Commands: Product User Profilesp. 395
Password Security During Loginsp. 397
Password Encryption and Trickeryp. 397
Virtual Private Databasesp. 403
Auditingp. 412
Security in a Distributed Environmentp. 417
Solutionsp. 418
Backup and Recovery Optionsp. 419
Capabilitiesp. 420
Logical Backupsp. 420
Physical Backupsp. 421
Implementationsp. 423
Integration of Backup Proceduresp. 469
Using Recovery Manager (RMAN)p. 473
About Recovery Managerp. 474
Some RMAN Recommendationsp. 509
Networked Oracle
Oracle Netp. 515
Overview of Oracle Netp. 516
Using the Oracle Net Configuration Assistantp. 526
Using the Oracle Net Managerp. 535
Starting the Listener Server Processp. 548
Controlling the Listener Server Processp. 549
Usage Example: Client/Server Applicationsp. 552
Usage Example: Database Linksp. 553
Usage Example: The copy Commandp. 554
Oracle Names Server Versus Client Configurations or Directory Serversp. 556
Tuning Oracle Netp. 557
UNIX and Oracle Netp. 559
Tuning 9iASp. 563
Starting, Stopping, and Restarting iAS (Apache)p. 565
Tuning Apache and TCPp. 567
Tuning the Oracle HTTP Server Configurationp. 568
Using the Oracle Caching Servicesp. 570
Oracle Web Cachep. 570
Oracle9iAS Database Cachep. 590
Managing Large Databasesp. 593
Setting Up the Environmentp. 594
Managing Transactionsp. 616
Backupsp. 624
Tuningp. 627
Using Transportable Tablespacesp. 629
Locally Managed Tablespacesp. 632
Managing Distributed Databasesp. 635
Remote Queriesp. 637
Remote Data Manipulation: Two-Phase Commitp. 638
Dynamic Data Replicationp. 640
Managing Distributed Datap. 641
Managing Distributed Transactionsp. 673
Monitoring Distributed Databasesp. 675
Tuning Distributed Databasesp. 676
Using the Job Queuesp. 679
SQL Reference for DBA Commandsp. 683
Indexp. 955
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9780072193749
ISBN-10: 0072193743
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 1008
Published: 19th December 2001
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.2 x 18.8  x 5.2
Weight (kg): 1.66
Edition Number: 1