Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-043). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions. This text is the perfect compliment to the Oracle 10g: Database Administrator: Implementation and Administration (DBA1) text and the 1Z0-042.
This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and concise instructions assist in the complete installation of Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information. Until now, setting up a Tru64 UNIX cluster running Oracle9i would involve referencing information from an entire shelf of books. Organizing this information into one source, Tru64 UNIX-Oracle9i Cluster Quick Reference simplifies the task of installation and makes a quick start possible with clear instructions and graphic illustrations. Command summary guides in each chapter serve as keys for fast information retrieval. Knowledge from over thirty references is distilled into this single book, seamlessly linking subject to subject for greatly simplified, quick installations. - Hardware Configuration Tips - StorageWorks HSG80 Setup Steps - UNIX Installation and Cluster Configuration - LSM/AdvFS Examples - Oracle9i RAC Installation, Database Configuration - Performance Tuning Tools, Backup, and Recovery
Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.
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.
Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms--plus a CD-ROM with a testing engine that simulates the actual exam--this is the best study tool available.
Install and configure Oracle Database 10g on a Linux enterprise platform. This book explains how to set up, administer, monitor, and tune Oracle Database 10g on Linux. You will also learn how to implement High Availability solutions as well as handle backup, recovery, and replication. This exclusive Oracle Press guide is the ideal resource for all Oracle DBAs working in a Linux environment.
The Most Authoritative OCA/OCP Exam Guide Available Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you’ll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Management and Resource Manager Automate administrative tasks Included on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book
This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification. OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, and a score report performance assessment tool Ideal as both exam guide and on-the-job reference The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams
This is the only authorized Oracle certification exam preparation for Database Administration, Backup/Recovery, and Network Administration, developed in conjunction with Oracle University. Contains a step-by-step methodology.
Author: Michael Abbey,Michael J. Corey,Ian Abramson
Publisher: McGraw Hill Professional
The demand for Oracle professionals is high. This book serves as an introduction to the Oracle9i technology. It is beginner focused - the price, page count and content level have been adjusted to be more in line with what you would expect from a Beginner's Guide. It starts from Ground Zero and provides an introduction to the Oracle corporation and its product strategy. It then moves on to beginner-level topics and overviews of the RDBMS and the roll of a DBA, and then progresses to slightly more advanced topics. This guide covers the 9i features focused on eBusiness platform development, including availability, security, scalability and manageability. It also discusses the Internet and eBusiness products and strategies that are shaping Oracle's technology. Each chapter includes: bulleted overview of topics and goals of the chapter; definitions of words and terms discussed; hands-on exercises or step-by-step instructions; and chapter questions and answers.
An updated handbook for new database administrators offers thorough coverage of the techniques, tools, and other essentials of managing an Oracle database, with discussion of the latest features of Oracle 9i and their applications, as well as a look at such important issues as server performance, security, and availability. Original. (Beginner)
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.
Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.
This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert. *Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning *Contains experienced guidance and real-world examples using large datasets *Emphasizes development as opposed to operating system perspective