Guidelines for application developers

1. Try to group your database predicates and use the view level interface to generate efficient SQL queries.
2. Avoid cuts over cursors since they leave cursors open and can cause a leak of cursors.
3. Whenever you send a query get all the results sent by the Oracle by backtracking to avoid cursor leaks. This interface automatically closes a cursor only after you retrieve the last row from the active set.
4. Try to use tabled database predicates for cashing database tables.