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



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

Download your Oracle scripts now:

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.