Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sequences

Status
Not open for further replies.
engdict

engdict

Programmer
Joined
Jan 8, 2003
Messages
10
Location
US
Hi,

The default size of the block of sequences held in the cache is 20. Does any anyone know if this is 20 *bytes*?
Or 20 *integers*? (Or is it the same thing?

TIA
 
Sort by date Sort by votes
One of the reasons sequence numbers are efficient is that the numbers are cached in ORACLE shared memory area: the SGA. By default, 20 sequence numbers are cached. Once the 20 numbers are allocated, ORACLE must fetch a further 20 from the database. If sequence numbers are being allocated at a very high rate, you can improve the performance by increasing the cache size when you create the sequence:

Lindsay
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top