Home » RDBMS Server » Server Administration » maximum records can be held in a cursor
maximum records can be held in a cursor [message #51889] Wed, 19 June 2002 22:42 Go to next message
sugathan
Messages: 4
Registered: March 2002
Junior Member
Hi,

I would like to know is there any limitation in declaring a cursor when the number of records are concerned.

Like I want to declare a cursor which may select 500000 records. What are the performance issue related with that.

Thanks in advance,
Su

Report message to a moderator

Re: maximum records can be held in a cursor [message #51893 is a reply to message #51889] Thu, 20 June 2002 06:38 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
known issues have arised only if you dont close the cursor properly.
commit the changed every 5000 records or so

Report message to a moderator

Previous Topic: Re: Oracle problems
Next Topic: Sending message before Shutdown
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 21:54:50 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.