Home » RDBMS Server » Performance Tuning » Performance Issue with FORALL BULK COLLECT
Performance Issue with FORALL BULK COLLECT [message #381525] Sat, 17 January 2009 11:29 Go to next message
srihari1974
Messages: 12
Registered: November 2008
Location: atlanta
Junior Member
I got 65 Millions in TRANSACTIONS Table and 2 millions records in ACH_TRANS
I have to update two table when i find the match
and i got the cursor which gets the matches from both the table
Should i declare record Type to acheive this or just the table is enough
and its taking for ever to update
just for 20 rows

Report message to a moderator

Re: Performance Issue with FORALL BULK COLLECT [message #381527 is a reply to message #381525] Sat, 17 January 2009 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have table & provided us no DDL for it.
You have data & provided us no DML for test data.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

You have not shown us via CUT & PASTE what you actually did or how Oracle responded.

Report message to a moderator

Re: Performance Issue with FORALL BULK COLLECT [message #381528 is a reply to message #381525] Sat, 17 January 2009 13:00 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use UPDATE it is faster.

Regards
Michel

Report message to a moderator

Previous Topic: Working slowley after 6 to 7hrs
Next Topic: Who is faster Cursor or Recored
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 01:05:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.