Re: v$rowcache outstanding_alerts

From: Jonathan Lewis <>
Date: Fri, 16 Nov 2012 11:24:37 -0000
Message-ID: <6105B9B1E54048DE96E069E4218AC2B0_at_Primary>

Somewhere I have some notes about this that I wrote a couple of years ago when I came across a system with an idgen2$.

It's an unusual object because it's generated dynamically in the executable when database creation takes place, and its presence is recorded in table idgens$. I don't recall whether the table holds one row per idgenX$ or whether it just holds the highest value for X.

Changes of 10,000 per minute is not necessarily a big issue - if you check the "increment by" value for the sequence it's 50, so the rate of calls is one fiftieth of the rate of change.

I have a VERY VAGUE memory that the sequence was something to do with abstract data types (i.e. objects) and generated object type IDs.


Jonathan Lewis

Author: Oracle Core (Apress 2011)

  • Original Message ----- From: "Walker, Jed S" <> To: <> Sent: Thursday, November 15, 2012 7:44 PM Subject: RE: v$rowcache outstanding_alerts

| Thanks Joe, I'm not sure why I didn't find that one.
| So, it would appear that I'll have to leave it and accept that
dc_sequences will have a high miss ratio. I checked another system (non-RAC) and the sequence has never been used.
| " it is an internal sequence created at database creation that we use
internally for various things." It'd sure be nice to have more info than that.
| -----Original Message-----
| From: Sweetser, Joe []
| Sent: Thursday, November 15, 2012 12:35 PM
| To: Walker, Jed S;
| Subject: RE: v$rowcache outstanding_alerts
| This has some info on it:
| hth,
| -joe
| -----Original Message-----
| From:
[] On Behalf Of Walker, Jed S
| Sent: Thursday, November 15, 2012 12:31 PM
| To:
| Subject: RE: v$rowcache outstanding_alerts
| Thanks Tanel.
| I've modified the application sequences and noticed the overall miss
ratio not improving. I discovered this sequence:
| It has a cache_size of 1000; however, the last_number is updating by
10,000 values per minute. I also posted this on MOC, but was hoping someone here might know about this sequence -

Received on Fri Nov 16 2012 - 12:24:37 CET

Original text of this message