Newly updated for Oracle 9i, this compact easy to read technical guide is a must for every Oracle DBA's library. It includes information on creating an Oracle Database, backup recovery, tuning and new SQL features. It then moves onto several more advanced features. Included are several new and updated UNIX and SQL scripts that are easy to use and simple to understand. With over 45 mini lessons it is great starting point for a new DBA and a must have for all DBAs.
Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracle10g database can be ready to use.
Get Up to Speed for Oracle9i Administration Training Courses--Fast! Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL*Plus and iSQL*Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL*Plus reporting techniques * Creating and maintaining database objects
This guide to leveraging RAM-SAN technology shows Oracle DBAs how to create fast Oracle9i RAC databases. Techniques for leveraging RAM disk in an Oracle RAC and Grid environment are demonstrated including changes to initialization parameters and the selective use of SSD in large database environments (UNDO, REDO, and TEMP tablespaces on solid-state disk).
Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.
Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database.
An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.
A guide for Oracle DBAs who are too busy to build a clustered server environment to learn about Oracle's Real Application Cluster technology, this book allows DBAs to build and configure a Real Application Cluster quickly and inexpensively. Covers how to find the right hardware to build an at-home RAC, where to get Linux and how to set it up, how to install the Oracle Cluster Manager, and how to create the RAC database.