OCP Instructors Guide for Oracle DBA Certification
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer certification > OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques
OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques

OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Table of Contents:
Chapter 1 - Getting Started Why Database Administration? Oracle Database Administration Responsibilities Oracle Classroom Education Oracle9i Curriculum Changes Oracle9i Oracle Certifications Oracle Certified Database Associate (OCA) Oracle Certified Database Professional (OCP) Oracle Certified Master Database Administrator (OCM) Oracle9i DBA OCP Upgrade Path Other Recommend Classes Preparing for the Oracle Certified Professional Exams Taking the Certification Exams Finding Information Quickly -- The Key to Success Reference Manuals Oracle Internal Resources External Resources Book Recommendations Chapter 2 - Oracle Database Architectures Oracle on Microsoft Windows Platforms Oracle on LINUX Platforms Oracle on Unix Platforms Database Architecture Comparison Worksheet Venturing into the Great Unknown -- New Database Architectures Chapter 3 - Oracle Database Design Review Meetings Initial Overview of Proposed System Logical Data Model Review Designing for Performance Setting up a Successful Test System in Oracle Monitoring Performance During Testing Performance Design Reviews Preparation for Production Turnover Post Production Turnover Oracle Database Design Review Meetings - Conclusion Chapter 4 - Oracle Database Administration Oracle Software Installation Migrating to new Oracle releases UNIX and LINUX Semaphores and Shared Memory Relinking Oracle8i and Oracle9i Products Windows Services Oracle Instance Administration Oracle9i Persistent Initialization Parameter Files Remote Startup/Shutdown Multiple Buffer Pools Specifying Default, Keep and Recycle Bufferpools in Oracle8 and Oracle8i Specifying Default, Keep and Recycle Bufferpools in Oracle9i Large Pool Java Pool Redo log Buffer Performance Buffer Performance is critical to Good Oracle Performance DBWR_IO_SLAVES vs DB_WRITER_PROCESSES Chapter 5 -- Oracle Database Objects What Database Are You Working In? GLOGIN.SQL and LOGIN.SQL Choosing a Database Block Size Copying Databases Between Servers Oracle Tablespaces Temporary Tablespaces Create Tablespace Temporary vs. Create Temporary Tablespace Partitioning Oracle 8 - Range Partitioning Index Partitioning Equi-Partitioned Objects Local Indexes Global Indexes Oracle8i -- Hash and Range/Hash Composite Partitioning Oracle9i -- List and Range/List Composite Partitioning Which Partitioning Technique Do I Choose? Oracle9i Tablespace Changes Locally Managed System Tablespaces Rollback Segments When is the System Rollback Segment Used? Why is Oracle Recommending Minextents of 20 for Rollback Segments? Rollback Segments and Transaction Processing Workloads Batch and On-line Processing Rollback Segments and Users -- Who's Using What? Oracle9i - Database Managed Undo Segments Redo Logs Checkpoint Not Complete Resizing Redo Logs Oracle Tables and Indexes Space Utilization for Parallel Table Creates Index-only Tables Single Table Hash Clusters Oracle9i External Tables ALTER TABLE MOVE Statement ALTER COLUMN RENAME Statement On-line Table Reorganizations PCTFREE and PCTUSED Caching Tables Clustering Data in Tables Merging Tables to Increase Query Performance How Many Indexes Can I Build? Parameters that Impact Index Usage Index-Only Access Index Rebuilds Index Coalesce vs Index Rebuild Function-Based Indexes Bitmap Indexes Concurrency and Bitmap Indexes When to Use Bitmap Indexes Optimizer and Bitmap Indexes Bitmap vs B-Tree Indexing Hints Tips and Tricks Index Monitoring Chapter 6 - Oracle Backup and Recovery It's the Little Things That Bite You Keep Your Skills Sharp RELAX and Plan Your Attack Don't Be Afraid to Ask Others Instance Recovery and the Oracle Synchronization Process Uncommitted Data on the Data Files Committed Data Not On the Data Files The Synchronization Process Roll Forward Phase Roll Backward Phase Exports and Recovery V$RECOVERFILE Watch the NOLOGGING Option Striped File Systems Data Files and Redo Logs Redo Log and Control File Multiplexing OCOPY for NT Hot Backup Scripts for NT Hot Backup Scripts for UNIX Oracle9i -- Lazy Checkpointer Recovery Manager Recovery Catalog Recovery Manager Backup Types Parallel Backup and Recovery Multiplexed Backup Sets Backup/Recovery Reports Database Recovery RMAN Examples DB_VERIFY Chapter 7 -- Tuning and Performance Be careful with the ANALYZE command Finding Problem Queries Optimizer Plan Stability Pinning Objects in the Shared Pool PCTFREE and PCTUSED Caching Tables Clustering Data in Tables Merging Tables to Increase Query Performance Hints Parallel Hints Performance Testing Parallel Query Tuning Oracle on Windows Tuning Pack Direct Load Inserts Parallel DML Processing Materialized Views Database Resource Management STATSPACK V$ TABLES vs Oracle BSTAT/ESTAT and STATSPACK Segment-Level Performance Statistics Collection Performance Tuning Intelligent Advisories Optimizer Dynamic Sampling Data Segment Compression Using Explain Pan to Determine Access Paths Explain Plan Output SQL*PLUS AUTOTRACE High Water Mark and Table Scans Chapter 8 -- Miscellaneous Oracle Information The Foot Rule of Thumb Monitor By Day So You Don't Get Called at Night Monitoring Space Utilization and Performance Statistics Historically Latches and Enqueues Deadlock Detection Unindexed Foreign Keys and Locking Problems Using PUPBLD Copying databases between servers Oracle9i - Resumable Space Allocation Oracle9i -- Flashback Query Full Database Exports Large Table Imports Compressing Export Output Files in UNIX Terminating Oracle Processes (Threads) in Windows Systems Truncating vs Deleting Copy Command in SQL*PLUS Displaying Time in Milliseconds !, $ and Host Command Differences Learn Command Line BEFORE Using "Sissy GUI Tools" Don't Write Scripts Don't' Write Iterative SQL Statements -- Generate SQL with SQL Input Truncated to 9 Characters Chapter 9 -- Evaluating Third Party Products Initial Analysis Determine Impact to the Information Technology Support Infrastructure Analysis Evaluation Obtain Business Unit and IT Management Commitment Create Evaluation Team Locate Potential Vendors Initial Elimination Vendor Evaluation Communicate Results Chapter 10 -- Ease of Administration Good Documentation is Essential Follow OFA Naming Conventions Proceduralize Administrative Support for the Application Development Process Proceduralize the Change Request Process Oracle Authorization Request Form Oracle Database Change Request Form Oracle Migration to Production Request Form Create and Standardize Monitoring and Administration Scripts Repeatable Processes Create Service Level Agreements DBA Report Cards and the 360-Degree Review Process Corrective Action Reports Chapter 11 -- Database Security Protecting Data Requires More than just Protecting the Production Database Identifying Granted Privileges Accounts Created During Database Creation Wrapping PL/SQL Programs Using OPS$ Accounts Using Security Profiles SYS and SYSTEM Passwords GRANT ANY OBJECT Privilege Administrative User Auditing Moving the AUD$ Tabl

About the Author :
Christopher T. Foot is an Oracle certified instructor, technical sales specialist, and database architect for Contemporary Technology. He is a regular speaker at the International Oracle Users Group and Oracle Open World conferences. He lives in Silver Springs, Maryland.


Best Sellers


Product Details
  • ISBN-13: 9780974435534
  • Publisher: Rampant Techpress
  • Publisher Imprint: Rampant Techpress
  • Height: 230 mm
  • Returnable: N
  • Sub Title: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques
  • ISBN-10: 0974435538
  • Publisher Date: 01 Apr 2004
  • Binding: Paperback
  • Language: English
  • Spine Width: 18 mm
  • Width: 185 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques
Rampant Techpress -
OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!