Skip to main content

2005 | Buch

Expert Oracle Database 10g Administration

insite
SUCHEN

Über dieses Buch

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examplesnot just "showcase" examples.

This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle database administrator needs to build and administer complex Oracle 10g databases.

Inhaltsverzeichnis

Frontmatter

Background, Data Modeling, and UNIX/Linux

Frontmatter
Chapter 1. The Oracle DBA’s World
Chapter 2. Relational Database Modeling and Database Design
Chapter 3. Essential UNIX (and Linux) for the Oracle DBA

Oracle Database 10g Architecture, Schema, and Transaction Management

Frontmatter
Chapter 4. Introduction to the Oracle Database 10g Architecture
Chapter 5. Schema Management
Chapter 6. Oracle Transaction Management

Installing Oracle Database 10g, and Creating and Upgrading Databases

Frontmatter
Chapter 7. Installing the Oracle Database 10g RDBMS
Chapter 8. Upgrading to Oracle Database 10g
Chapter 9. Creating an Oracle Database

Connectivity and User Management

Frontmatter
Chapter 10. Connectivity and Networking
Chapter 11. User Management and Database Security
Chapter 12. Using SQL*Plus and iSQL*Plus

Data Loading, Backup, and Recovery

Frontmatter
Chapter 13. Loading and Transforming Data
Chapter 14. Using Data Pump Export and Import
Chapter 15. Backing Up Databases
Chapter 16. Database Recovery

Managing the Operational Oracle Database

Frontmatter
Chapter 17. Automatic Management and Online Capabilities
Chapter 18. Managing and Monitoring the Operational Database
Chapter 19. Using Oracle Enterprise Manager
Chapter 20. Managing Oracle Databases on Windows and Linux Systems

Performance Tuning

Frontmatter
Chapter 21. Improving Database Performance: SQL Query Optimization
Chapter 22. Performance Tuning: Tuning the Instance

The Data Dictionary, Dynamic Views, and the Oracle-Supplied Packages

Frontmatter
Chapter 23. The Oracle Data Dictionary and the Dynamic Performance Views
Chapter 24. Using Oracle PL/SQL Packages
Backmatter
Metadaten
Titel
Expert Oracle Database 10g Administration
verfasst von
Sam R. Alapati
Copyright-Jahr
2005
Verlag
Apress
Electronic ISBN
978-1-4302-0066-6
Print ISBN
978-1-59059-451-3
DOI
https://doi.org/10.1007/978-1-4302-0066-6