Advertisement

02.27.2008 at 04:22AM PST, ID: 23196646
[x]
Attachment Details

Sequence with nocache - caches sequence numbers

Asked by twoboats in Oracle 10.x, Databases Miscellaneous, Oracle Database

Tags: Oracle, Oracle, 10, Sequence cache

Hi.

I have an Oracle database backend to Sage, that has some sequences defined. As the caching of the sequence numbers has caused some problems, they were altered to have NOCACHE.

Yet it appears that Oracle is turning caching back on for them.

Has anyone else experienced this, and have you fixed it?

ThanksStart Free Trial
 
Keywords: Sequence with nocache - caches se…
Title
1 Oracle sequence
2 Oracle and sequences
3 Creating Sequences in Oracle 9i
4 Oracle Sequences Datatype
5 ORACLE Replacing a PK in a table
6 what is a SEQUENCE?
 
Loading Advertisement...
 
[+][-]02.27.2008 at 12:14PM PST, ID: 20997869

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.27.2008 at 02:13PM PST, ID: 20999029

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.27.2008 at 02:14PM PST, ID: 20999035

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.28.2008 at 06:12AM PST, ID: 21003815

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.28.2008 at 06:13AM PST, ID: 21003827

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.28.2008 at 06:35AM PST, ID: 21004073

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Databases Miscellaneous, Oracle Database
Tags: Oracle, Oracle, 10, Sequence cache
Sign Up Now!
Solution Provided By: sdstuber
Participating Experts: 2
Solution Grade: B
 
 
[+][-]02.28.2008 at 08:09AM PST, ID: 21005148

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628