My Oracle Support Banner

Oracle Sequence Caching (Doc ID 492752.1)

Last updated on APRIL 18, 2025

Applies to:

Siebel System Software - Version 7.0.4.305 SIS [14190] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.0.4.305 [14190] Com/Med/Engy

Database: Oracle 8.1.7.4

Application Server OS: Microsoft Windows 2000 Server

Database Server OS: Sun Solaris 8



This document was previously published as Siebel SR 38-1195478031.

Symptoms

We want to recreate Oracle sequence with NOCACHE option.   Siebel has 6 sequences with caching option enabled. Is there any problem disabling CACHE option?


List of Sequence
---------------------------------------
S_ESCL_ACTN_REQ_S
S_EAI_BATCH_S
S_DCK_TXN_LOG_S
S_ESCL_REQ_S
S_SRM_REQUEST_S
S_SEQUENCE_S


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.