OCP: Oracle9i Performance Tuning Study Guide

OCP: Oracle9i Performance Tuning Study Guide

Author: Joseph C. Johnson

Publisher: John Wiley & Sons

Published: 2006-07-14

Total Pages: 613

ISBN-13: 9780782152746

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning. This Study Guide provides: In-depth coverage of official exam objectives Practical information on optimizing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Using Diagnostic and Tuning Tools Monitoring and Managing the Buffer Cache Optimizing Sort Operations Detecting and Resolving Lock Contention Diagnosing Shared Server Performance Issues Using Oracle Blocks Efficiently Tuning SQL Statements Configuring Resource Manager Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.


OCA / OCP: Introduction to Oracle9i SQL Study Guide

OCA / OCP: Introduction to Oracle9i SQL Study Guide

Author: Chip Dawes

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 611

ISBN-13: 0782152503

DOWNLOAD EBOOK

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 * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access


OCP: Oracle9i DBA Fundamentals II Study Guide

OCP: Oracle9i DBA Fundamentals II Study Guide

Author: Matthew Weishan

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 532

ISBN-13: 078215249X

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II. In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Identifying solutions included with Oracle9i for managing complex networks Using Oracle Net Services and client server connections Establishing web client connections through Oracle networking products Troubleshooting database connections Using and configuring the Oracle Shared Server Backing up, restoring, and recovering databases Configuring the database archiving mode Using Recovery Manager (RMAN) Loading data into, and transporting data between databases Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.


OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

Author: Biju Thomas

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 461

ISBN-13: 9780782152456

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managing Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.


Oracle9i DBA JumpStart

Oracle9i DBA JumpStart

Author: Bob Bryla

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 367

ISBN-13: 0782151612

DOWNLOAD EBOOK

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 * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting


OCP Oracle9i Database: Performance Tuning Exam Guide

OCP Oracle9i Database: Performance Tuning Exam Guide

Author: Charles Pack

Publisher: McGraw Hill Professional

Published: 2002-03-27

Total Pages: 12

ISBN-13: 9780072195279

DOWNLOAD EBOOK

The performance tuning exam is one of the exams that must be passed to become OCP-certified as a DBA. This book contains over 300 practice questions.


OCP: Oracle Database 12c Administrator Certified Professional Study Guide

OCP: Oracle Database 12c Administrator Certified Professional Study Guide

Author: Robert G. Freeman

Publisher: John Wiley & Sons

Published: 2014-08-08

Total Pages: 784

ISBN-13: 1118931912

DOWNLOAD EBOOK

An updated guide for an updated certification exam! As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud. You'll sharpen your skills to prepare for the three levels of certification: Oracle Certified Associate, Oracle Certified Professional, and Oracle Certified Master. Workbook exercise appendix, test engine, chapter review questions, electronic flashcards, searchable PDF glossary, and two bonus practice exams all help to enhance your preparation to take the Oracle 12c exam. Addresses such topics as: database architecture, configuring and recoverability, configuring backup specifications, and performing user-managed backup and recovery Reviews how to use RMAN to create backups, perform recovery, and duplicate a database Looks at performing tablespace point-in-time recovery and using flashback technology Covers diagnosing the database, managing memory, managing resources, and automating tasks Focusing 100 percent on the exam objectives, OCP: Oracle Database 12c Administrator Certified Professional Study Guide is designed for those who feel they are ready to attempt this challenging exam.


OCP: Oracle Database 11g Administrator Certified Professional Study Guide

OCP: Oracle Database 11g Administrator Certified Professional Study Guide

Author: Robert G. Freeman

Publisher: John Wiley & Sons

Published: 2009-05-18

Total Pages: 895

ISBN-13: 9780470496893

DOWNLOAD EBOOK

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.


Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

Author: Richmond Shee

Publisher: McGraw Hill Professional

Published: 2004-07-16

Total Pages: 386

ISBN-13: 0071483756

DOWNLOAD EBOOK

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.