Viewing/Setting DC_SEQUENCES
HugeBobDec 19 2006 — edited Dec 21 2006I'm working on a Cold Fusion application that's receiving 08001 errors from Oracle. I've read the following and have questions:
Cause: An operation requested a resource that was unavailable.
The maximum number of user sequences per session is specified by the
initialization parameter DC_SEQUENCES.
When this maximum is reached, no more requests are processed.
Action: Try the operation again in a few minutes.
If this error occurs often, shut down Oracle, increase the
DC_SEQUENCES parameter in the initialization parameter file, and
restart Oracle.
How do you query the value of DC_SEQUENCES?
What are suitable values?
Where is the initialization parameter file