That's mean I/o for every nextval.
>
> Yechiel Adar
> Mehish
> - Original Message -
> From: Tim Gorman
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, October 10, 2002 7:43 PM
> Subject: Re: sequence numbers
>
> CACHE 20 is the default,
002 7:43
PM
Subject: Re: sequence numbers
CACHE 20 is the default, so if you remove the clause, it
will have absolutely no impact on performance or anything else...
...of course, I get the feeling that that wasn't the
gist of your question, was it?
- Origin
CACHE 20 is the default, so if you remove the clause, it
will have absolutely no impact on performance or anything else...
...of course, I get the feeling that that wasn't the gist
of your question, was it?
- Original Message -
From:
April Wells
To: Multiple recipients
PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/09/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: sequence numbers
This was more of a defense question than anything
I rea
Wells
@csedge.com> cc:
Sent by: rootSubject: RE: sequence
Increasing sequence_cache_entries will minimize the demand for SQ enqueue
that Oracle uses to internally bump the seq numbers.
- Kirti
-Original Message-
Sent: Wednesday, October 09, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
This was more of a defense question than anythi
esday, October 09, 2002 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: sequence numbers
>
>
>
> If the sequence is not cached then Oracle has to generate a
> new sequence
> number for every record inserted (CPU cycles). NOORDER is
> the defaul
This was more of a defense question than anything
I read the docs, but without knowing what volume we will be expecting, I
don't want stuff being aged out either. I don't guess making the
sequence_cache_entries double what I figure we will need will cause anything
horrible... but It was put
If the sequence is not cached then Oracle has to generate a new sequence
number for every record inserted (CPU cycles). NOORDER is the default so
that won't slow you up. If you're doing bulk loads why not cache the
sequence numbers? Is it important that there be no gaps? Even with
NOCACHE you
