Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

OCP Instructors Guide for Oracle DBA Certification

Chapter 3 - Review Meetings

Initial Overview of Proposed System

  • Development tools used to build front-end application screens
     

  • Third-party tools used to provide Ad-Hoc query access
     

  • Procedural language used to build business logic (Java, PL/SQL)
     

  • Application development methodology to be used (JAD, RAD)
     

  • Number of concurrent users
     

  • Disk storage and data growth estimates
     

  • Highly available architecture discussion (RAC, Oracle Fail Safe, Data Guard, hardware vendor clustering and failover)
     

  • Performance expectations
     

  • Criteria used to judge performance
     

  • Security and auditing requirements
     

  • Hardware platform, O/S preferences/selection and sizing discussion
     

  • Hardware platform, O/S installation, operation and administration
     

  • Division of duties between the DBA, application development and business units

Logical Data Model Review

This meeting is convened as soon as the logical data model is complete. The major emphasis of this meeting is to determine if the logical data model is complete and correct. The application’s process model (if one is available) can also be verified at this time. Volume statistics, object growth rates, purge criteria, referential integrity needs and application-naming conventions are also discussed. Knowing your data before hand is essential to designing processes to manipulate that data. The following topics are covered in this meeting:

  • Determine if the data model is fully documented (entities, attributes, relationships)
     

  • Attributes have correct datatype, length, NULL status, default values
     

  • General discussion of business rules that are to be enforced by database level constraints
     

    • Not null constraints
       


The above text is an excerpt from:


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

ISBN 0-9744355-3-8

by Christopher T. Foot
 

http://www.rampant-books.com/book_2003_2_OCP_print.htm


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

   
  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.