PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.
Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap.
Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide explains in easy-to-follow detail how to administer an Oracle database using this state-of-the-art tool. Inside, you'll learn to eliminate, simplify, and automate administrative tasks and use Oracle Enterprise Manager (EM) as a management framework for your entire Oracle environment.
The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).
Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case.
"This book is an excellent source of pragmatic guidance on how users can realize real benefits from adopting Grid Computing today while addressing their pressing business needs and leveraging their current IT investments." --Thomas Kurian, Senior Vice President, Oracle Server Technologies
What every system administrator needs to know for effective and efficient database management.
From the official Oracle Press comes a comprehensive guide to implementing a sound security plan in your Oracle environment. This expert resource explains how to secure the operating system, the database, and the network and how to use Oracle's built-in security features. The book also explains how to hacker-proof, audit, and troubleshoot your entire system.
Oracle DBA 101 offers a friendly place for budding Oracle professionals to learn critical database management skills. Refreshingly, the book's entertaining style doesn't preclude the authors from discussing advanced concepts.
The text opens with a discussion of everything an Oracle DBA is expected to do. It moves quickly into the particulars of the Oracle architecture, all the while maintaining a comfortable writing style that makes easy reading of material that is, because of its technical nature, very dry.
SQL*Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQL*Loader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format. Almost every Oracle user has to use SQL*Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization.