Publisher's Synopsis
If Oracle8I can do it, you can do it too
Oracle8I is packed with new features, including an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. This comprehensive guide shows you step–by–step how to make the most of this improved functionality — and master the day–to–day tools and challenges of Oracle database administration. From SQL∗Plus basics and performance–tuning options to recovery tips and WebDB strategies, Oracle8I DBA Bible is all you need to optimize a database and keep it running smoothly.
Inside, you′ll find complete coverage of Oracle8I database administration
- Install Oracle8I and configure Net8 and the password file
- Use SQL∗Plus, Import, SQL∗Loader, and other DBA tools, including the new wizards
- Create and manage users as well as tables, materialized views, and other database objects
- Boost performance using the rules– or cost–based optimizer, SQL statement tuning, and instance tuning
- Master advanced topics, from PL/SQL programming and the enhanced Resource Management tools to auditing and partitioning
- Harness the new Internet functionality of 8I using WebDB, the HTML server, Java, and more
- Get complete syntax references for SQL, PL/SQL built–in functions, and SQL∗Plus
- Scripts to create and populate the sample tables in the book
- Scripts containing code examples from the book
- Oraxel Lite, which enables you to access Oracle data from Excel
Harness the power of PL/SQL and the Oracle8I DBA tools and utilities
Capitalize on the new Internet and e–commerce functionality