| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 think bulk operations will be useful, but you'll have to watch for the memory usage as well, I'd probably process data in chunks of couple of thousands. In or around 8i, pl/sql tables used to leak (I mean really leak) memory after the row length reached a specific length. Also modeling a pl/sql table but using table%rowtype used lot more memory than if it was based on a record etc.
Try it, you'll probably like the results ... I seem to remember of some issue with bulk operations on a remote database, but you can always populate a local table and import/export. I it will be faster than all the operations across db link.
Keep us posted though ...
Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Jan 07 2003 - 14:19:49 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
- text/plain attachment: ESPN_Disclaimer.txt
 |
 |