En savoir plus
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.
Table des matières
Background, Data Modeling, and UNIX/Linux.- The Oracle DBA's World.- Relational Database Modeling and Database Design.- Essential UNIX (and Linux) for the Oracle DBA.- Oracle Database 10g Architecture, Schema, and Transaction Management.- to the Oracle Database 10g Architecture.- Schema Management.- Oracle Transaction Management.- Installing Oracle Database 10g, and Creating and Upgrading Databases.- Installing the Oracle Database 10g RDBMS.- Upgrading to Oracle Database 10g.- Creating an Oracle Database.- Connectivity and User Management.- Connectivity and Networking.- User Management and Database Security.- Using SQL*Plus and iSQL*Plus.- Data Loading, Backup, and Recovery.- Loading and Transforming Data.- Using Data Pump Export and Import.- Backing Up Databases.- Database Recovery.- Managing the Operational Oracle Database.- Automatic Management and Online Capabilities.- Managing and Monitoring the Operational Database.- Using Oracle Enterprise Manager.- Managing Oracle Databases on Windows and Linux Systems.- Performance Tuning.- Improving Database Performance: SQL Query Optimization.- Performance Tuning: Tuning the Instance.- The Data Dictionary, Dynamic Views, and the Oracle-Supplied Packages.- The Oracle Data Dictionary and the Dynamic Performance Views.- Using Oracle PL/SQL Packages.
A propos de l'auteur
Sam Alapati is an Oracle DBA for the Boy Scouts of America, working at their national office in Los Colinas, Texas. Prior to this, Sam worked at Sabre, NBC as well as Oracle Corporation as a Senior Principal Consultant in New York City. Sam has previously published Expert Oracle9i Database Administration, Expert Oracle Database 10g Administration, Oracle Database 11g RMAN Recipes(with Darl Kuhn and Arup Nanda) and Oracle Database 11g New Features(with Charles Kim), all for Apress, as well as two Oracle Certified Professional (OCP) certification books for Oracle Press. Sam has been working with relational databases since 1985, starting with the Ingres database. Sam holds the OCP certification for Oracle DBAs as well as the HP-UX System Administrator certification.
Résumé
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.
