Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

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
     

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA