The Oracle Underground FAQ site will undoubtedly help you one day.

Many support issues, such as performance problems, can be avoided by following a few simple rules. These include:

- the use of bind variables;
- the use of bulk operations;
- avoiding too many concurrent sessions;
- the use of standard Oracle makefiles.

Please see the Tutorials for more details.

In addition, the Oracle Technology Network (OTN) web site: http://otn.oracle.com/ contains extensive documentation, FAQs, tips and hints.

Most pages on OTN are only available to registered users: registration to OTN is for free and highly recommended!