This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such...

 448 p dnulib 01/11/2012 294 1 Download

Contents ACKNOWLEDGMENTS INTRODUCTION 1 Database Fundamentals 2 Installing Oracle 3 Connecting to Oracle 4 SQL: Structured Query Language 5 PL/SQL 6 The Database Administrator 7 Backup and Recovery 8 High Availability: RAC, ASM, and Data Guard 9 Large Database Features A Mastery Check Answers Chapter 1: Database Fundamentals Chapter 2: Installing Oracle Chapter 3: Connecting to Oracle Chapter 4: SQL: Structured Query Language Chapter 5: …..

 448 p dnulib 01/11/2012 296 1 Download

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, Advanced SQL Functions in Oracle 10g covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to...

 417 p dnulib 01/11/2012 299 1 Download

Table of Contents Using the Data Recovery Advisor Using Flashback and LogMiner Online Application Maintenance Using RMAN Enhancements Using RMAN and Data Guard Enhancements Using Data Guard Enhancements Using Data Guard Fast-Start Failover Enhancements 9944 – Xếp hạng Ebook – Thanks! An error occurred! ….

 671 p dnulib 01/11/2012 137 1 Download

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple...

 744 p dnulib 01/11/2012 307 1 Download

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple...

 332 p dnulib 01/11/2012 294 1 Download

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof...

 374 p dnulib 01/11/2012 281 1 Download

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative...

 48 p dnulib 01/11/2012 254 1 Download

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables

 444 p dnulib 01/11/2012 160 1 Download

Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter,...

 769 p dnulib 01/11/2012 312 1 Download

The question, "Why isn’t Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You’ve picked exactly the right columns, you’ve got them in the ideal order, you’ve computed statistics, you’ve checked for null columns—and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

 537 p dnulib 01/11/2012 293 1 Download

To realize the full potential of this Sybex electronic book, you must have Adobe Acrobat Reader with Search installed on your computer. To find out if you have the correct version of Acrobat Reader, click on the Edit menu—Search should be an option within this menu file. If Search is not an option in the Edit menu, please exit this application and install Adobe Acrobat Reader with Search from this CD (doubleclick rp500enu.exe in the Adobe...

 611 p dnulib 01/11/2012 401 1 Download