Expert Oracle database 10g administration /
Alapati, Sam R.
Expert Oracle database 10g administration / Sam R. Alapati. - Berkeley, CA : New York : Apress ; Distributed to the book trade worldwide by Springer-Verlag, c2005 [reprinted 2010]. - xxvii, 1276 p. : ill. ; 24 cm.
Includes index.
Pt. 1. 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 -- Pt. 2. Oracle database 10g architecture, schema, and transaction management. Introduction to the Oracle database 10g architecture -- Schema management -- Oracle transaction management -- Pt. 3. Installing Oracle database 10g, and creating and upgrading databases. Installing the Oracle database 10g RDBMS -- Upgrading to Oracle database 10g -- Creating an Oracle database -- Pt. 4. Connectivity and user management. Connectivity and networking -- User management and database security -- Using SQL *Plus and iSQL *Plus -- Pt. 5. Data loading, backup, and recovery. Loading and transforming data -- Using data pump export and import -- Backing up databases -- Database recovery -- Pt. 6. 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 -- Pt. 7. Performance tuning. Improving database performance : SQL query optimization -- Performance tuning : tuning the instance -- Pt. 8. The data dictionary, dynamic views, and the Oracle-supplied packages. The Oracle data dictionary and the dynamic performance views -- Using Oracle PL/SQL packages -- Appendix A. Oracle database 10g SQL and PL/SQL: a brief primer.
9788181283733 1590594517 9781590594513
2006295069
005.7585
Expert Oracle database 10g administration / Sam R. Alapati. - Berkeley, CA : New York : Apress ; Distributed to the book trade worldwide by Springer-Verlag, c2005 [reprinted 2010]. - xxvii, 1276 p. : ill. ; 24 cm.
Includes index.
Pt. 1. 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 -- Pt. 2. Oracle database 10g architecture, schema, and transaction management. Introduction to the Oracle database 10g architecture -- Schema management -- Oracle transaction management -- Pt. 3. Installing Oracle database 10g, and creating and upgrading databases. Installing the Oracle database 10g RDBMS -- Upgrading to Oracle database 10g -- Creating an Oracle database -- Pt. 4. Connectivity and user management. Connectivity and networking -- User management and database security -- Using SQL *Plus and iSQL *Plus -- Pt. 5. Data loading, backup, and recovery. Loading and transforming data -- Using data pump export and import -- Backing up databases -- Database recovery -- Pt. 6. 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 -- Pt. 7. Performance tuning. Improving database performance : SQL query optimization -- Performance tuning : tuning the instance -- Pt. 8. The data dictionary, dynamic views, and the Oracle-supplied packages. The Oracle data dictionary and the dynamic performance views -- Using Oracle PL/SQL packages -- Appendix A. Oracle database 10g SQL and PL/SQL: a brief primer.
9788181283733 1590594517 9781590594513
2006295069
005.7585