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
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: 25042
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.

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: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use UPDATE it is faster.

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


Current Time: Wed Dec 07 06:41:54 CST 2016

Total time taken to generate the page: 0.11608 seconds