Re: A PL/SQL performance question

Thanks, But I am just a beginner in Oracle, can you give more details on your explain? What's the restrictions and what is the added network traffic?

jusungyang_at_yahoo.com (Jusung Yang) wrote in message news:<42ffa8fa.0208061230.6ae2656d_at_posting.google.com>...
> 2nd aproach is better. There are restrictions on what kind of data can
> be pulled over a db link. Not to mention the added network traffic.
>
>
> jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0208052054.478d2e22_at_posting.google.com>...
> > Database A can access B via database link db_link_B
> >
> > I want to access table table_B in B by using some PL/SQL Procedure_example.
> >
> > (1) first approach, compile Procedure_example in A using
> >
> > BEGIN
> > select .......from table_B_at_db_link_B;
> > END
> >
> > and then execute Procedure_example in A;
> >
> > (2) second approach, compile Procedure_example in B using
> >
> > BEGIN
> > select .........from table_B;
> > END
> >
> > and then execute Procedure_example_at_db_link_B in A;
> >
> >
> > Can anyone compare this two approach in term of system performance?
Received on Wed Aug 07 2002 - 06:22:48 CEST