OraFAQ Forum: Performance Tuning » sequences shared pool

Home » RDBMS Server » Performance Tuning » sequences shared pool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sequences shared pool [message #144293]

Tue, 25 October 2005 16:48

vadimk
Messages: 1
Registered: October 2005
Location: Montreal, Canada

Junior Member

hi all,
question:
is it possible to preserve sequences without gaps?
is it reasonable to use dbms_shared_pool.keep function in order to prevent sequences from aging and being dumped?
thank you,

Report message to a moderator

Re: sequences shared pool [message #144345 is a reply to message #144293]

Wed, 26 October 2005 03:15

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Hi
1. No. You cannot guarantee that a sequence will have no gaps.
2. For faster access to sequence values use the cache setting to cache multiple values for the sequence.

Here is a link to some documentation on sequences.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_615a.htm#2080641
You may also want to serch these forums for many varied discussions on the topic of sequences.

HTH
Jim

Report message to a moderator

Previous Topic:	What are the pluses of autostats
Next Topic:	Book for tuning (I'm not a DBA, though)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:31:57 CST 2024