Raj,
Thanks for your reply.
This is a one-time-only load to set up a new datamart from our existing
warehouse. We have a separate process which will be doing periodic
refreshes. However, yes, the inserts are going across the network with
the current design.
Cherie
Rajesh.Rao@jpm
chase.com To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Long-running PL/SQL function
(long)
om
01/07/03 12:04
PM
Please respond
to ORACLE-L
Cherie,
If network bandwidth is the bottleneck, the use of Fast Refreshable
snapshots will be a great help. Whereby you only pull the rows that have
changed since the last refresh across to the primary.
Raj
Cherie_Machler
@gelco.com To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Long-running PL/SQL
function (long)
om
January 07,
2003 12:25 PM
Please respond
to ORACLE-L
Our developers sent me a function which is running quite long to see if I
could give them any advice. It is written in PL/SQL for version 9.2.0.1
of Oracle on Sun Solaris. It is going across a database link. It reads
tables in one database and loads a new table in a datamart table on another
box. It looks like it will currently run for four or five days to load a
140 million-row table, which is longer than our available window.
I am wondering if anyone can look at the big picture and see if there are
any obvious places for improvement of this overall design. I am open to
any suggestions that I can relay back to the developers.
My gratitude to anyone who can wade through this and recommend
improvements.
Cherie Machler
Oracle DBA
Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
