|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle sequence is causing high cpu usage? [message #284088 is a reply to message #277726] |
Wed, 28 November 2007 16:23  |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
I have seen two situations where sequences have cause increased resource consumption and delays in processing. for what it is worth:
1) as was indicated, nocache, or low cache value. Consider that a cache size of zero means that for each value selected from the sequence, an recursive update must be made to the underlying sequence table. You can see this update as sql in v$sqlarea. If you do lots of sequence number gets, you will have lots of updating. this is in fact one of the four problems of a current system I am working on that is having CPU issues and spikes.
2) .NET or 3GL or front end tool doing sequence number gets across the network. Not necessarily a CPU cost, but can really slow down an app because each sequence number get may be coded in that app as a network round trip.
good luck. Kevin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
