BC remote Oracle DBA - Call (800) 766-1884
Free Oracle Tips

Oracle Consulting Oracle Training Development

Remote DBA

 

Remote DBA Plans
Remote DBA Service

 
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 
 

Putting Methods to Work in Oracle8

Oracle Tips by Mike Ault

Designing a Method Network (Hierarchy)

As you progress from one level of detail to the next, you should find the sub-processes required to perform the overall tasks for which they are assigned. At each level of analysis, you should perform an evaluation to identify duplicate process behaviors under different higher-level processes.

At this stage of analysis, duplicated processes are not eliminated or consolidated because further analysis at greater granularity might reveal subtle differences in the processes after all. What is done is that the two (or more) processes are labeled to identify their system duplicity and the analysis proceeds. Ultimately, you'll want to proceed until decomposition is no longer possible. At that point, the effort turns to organizing the defined processes. In which case, you start by grouping the processes into the three categories named earlier: independent, base level, and aggregate.

The next step is to revisit the duplicated processes and consolidate them. This is not to say that you will create one big package and put redundant sub-processes together. Instead, the effort is focused on organization. Later, redundant processes will be grouped categorically by function. These steps have proven to be a most effective means of code organization in terms of maintenance and deployment.

SEE CODE DEPOT FOR FULL SCRIPTS


If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.
 


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

Free Oracle dictionary reference poster

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

North Carolina Oracle Users Group

 

 Arabian horse breeder

Seeing eye horses

 

 

Burleson is the American Team

American Flag

 

 

BC Remote Oracle Support
P.O. Box 511 • Kittrell, NC, 27544

Remote DBA

Remote DBA Services

 

Copyright © 1996 -  2011 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.



Hit Counter