TUNING

From: E. Nunns <en201_at_cus.cam.ac.uk>
Date: 11 Dec 1998 13:24:27 GMT
Message-ID: <74r6eb$pv4$1_at_pegasus.csx.cam.ac.uk>


[Quoted] We have the following situation:-

Forms 4.5 block based on a view.

This view is based on a view of a view of a view of some base tables. We also have functions embedded within these views. All of this is running on an oracle 7.3 db under VMS using the cost based optimiser.

Performance is poor. Does anyone else have similar problems or can make any broad suggestions regarding where to start tuning?

Elaine Received on Fri Dec 11 1998 - 14:24:27 CET

Original text of this message