Re: Oracle Form: Master-Detail Relationship

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Oct 2005 10:56:57 -0700
Message-ID: <1128560530.33888_at_yasure>


Pat wrote:
> Hi All,
>
> I have a question on Oracle Forms (version 6i) for your comment.
>
> When I build a master and a detail block, link it up with a relation,
> some triggers will be generated by oracle forms, e.g. on-populate-details,
> which query the detail block automatically when the master block is queried.
> However, it used "go_block", "execute_query" to populate the data which
> I found it has performance problem in forms processing. Imagine I have
> a master block with 5 detail blocks, that might impose quite some network
> traffic which makes the forms "run" very slowly.
>
> Are there any alternatives for such processing?
>
> Thx.

Take Yuri's advice but also look at:
Query array size
Number of records buffered
Optimizer hint (based on SQL*Plus and Explain Plan testing) Maximum records fetched

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 05 2005 - 19:56:57 CEST

Original text of this message