Re: A PL/SQL performance question

Well, look up ORACLE DOC on all the tricks about database links and distributed database. You can not do a "select... from.." on a column of CLOB data type over the db link, the way you can locally. Not sure about columns of object type, should be easy to verify though. The bigger problem arise when you try to pull data over db link and process them locally. You want to avoid it if you can help it. You just don't want to pull thousands, or millions of records from the remote server to process them locally and in the process bog down the network. It is self-evident, no?

jshubo_at_yahoo.com (Jambo) wrote in message news:<cd48a5b6.0208062022.673d46fd_at_posting.google.com>...
> 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 - 19:10:32 CEST