Oracle DBA Checklists Pocket ReferenceIn a series of easy-to-use checklists, the Oracle DBA Checklists Pocket Reference summarizes the enormous number of tasks an Oracle DBA must perform. Each section takes the stress out of DBA problem solving with a step-by-step "cookbook" approach to presenting DBA quick-reference material, making it easy to find the information you need--and find it fast. ...
Oracle RMAN Pocket ReferenceOracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital. ...
Learning Oracle PL/SQLPL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control - all closely integrated with the Oracle database server.
Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. ...
Professional Oracle 8i Application Programming with Java, PL/SQL and XMLThis book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier applications. Knowledge of the essentials of PL/SQL programming is required, and familiarity with Java would be useful. What does this book cover? The Oracle 8i platform and architecture, covering Net8 and the Oracle JVM; PL/SQL development using the Web Toolkit, PSP and Designer 6i; Java application development, including a Java primer; Oracle 8i and Java Stored Procedures, EJB, BC4J, JDBC, SQLJ; XML development with an XML primer; Oracle XDK, XSQL, XSLT, Transviewer JavaBeans; Case studies using Designer 6i, interMedia, Portal-to-Go, ASP and SOAP. ...
Oracle Built-in PackagesOracle's built-in packages dramatically extend the power of the PL/SQL language, but few developers know how to use them effectively. This book is a complete reference to all of the built-ins, including those new to Oracle8. the enclosed diskette includes an online tool that provides easy access to the many files of source code and documentation developed by the authors. ...
Oracle Performance Tuning, 2nd EditionThe first edition of this book became a classic for developers and DBAs. This edition offers 400 pages of updated material on Oracle features, including parallel server, parallel query, Oracle Performance Pack, disk striping and mirroring, RAID, MPPs, SMPs, distributed databases, backup and recovery, and much more. ...