Title: RE: Long-running PL/SQL function (long)
Cherie,
Bulk inserts/selects are available since 8i ...
Not being sarcastic but sorry to disappoint you, but your developers haven't used anything new that wasn't in 8i ... you can give them the bad news .. (if you want.)
I
: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>cc:
Sent by: Subject: Re: Long-running PL/SQL function
(long)
Title: RE: Long-running PL/SQL function (long)
Hi Cherie,
Using pl/sql tables and bulk binding will increase the speed dramatically with both insert and cursor fetching. I've done it myself many times with runaway success.
Also, lookup tables can be cached in the procedure to avoid
"Jamadagni,
Rajendra" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Long-running PL/SQL
function (long)
AIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Long-running PL/SQL function
(long)
Title: RE: Long-running PL/SQL function (long)
Cherie,
I'd run this function with 2 events separately ...
first 10938 this will give you pl/sql profiling or simply use dbms_profiler package. This will tell you where (and at which line) you are spending most of your time. Metalink has
cc:
Subject: Long-running PL/SQL function
I think that you can try 2 things:
1) Run the function in the source db. Selects across links does funny stuff.
2) Write CSV file on the source system and sql loader on the target using
direct.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTE
ent by: cc:
[EMAIL PROTECTED]Subject: Long-running PL/SQL function
(long)
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
10 matches
Mail list logo
