Alapati, Sam R. creator text cau Berkeley, CA New York Apress Distributed to the book trade worldwide by Springer-Verlag c2005 [reprinted 2010] 2010 monographic eng

print

xxvii, 1276 p. : ill. ; 24 cm. 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. Sam R. Alapati. Includes index. Relational databases 005.7585 9788181283733 1590594517 9781590594513 2006295069 JRZ 110123 14242212