Re: v$kcbcbhx

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Nov 2006 09:43:06 +0100

Must have been before that - I've got an here, and it doesn't have
the v$ nor the x$ you mentioned.

Reason I ask is that we've got a database (AIX) where we still got
the v_$ view, and the according public synonym for v$kcbcbhx.

On any access, the database throws ora-600 (16206) - of which metalink says
it can happen when accessing v$ objects where the underlying x$ are missing.
Which is the case here. Now I'm trying to find some evidence of the last
release these objects where part of - google returns 1 hit, which is an
oracle 7 statspack kind of script. Customer is hesitant to drop it (I
would), because it's inside SYS schema.

Story's just gotten funnier... Opened an SR about this - and Oracle says
this "object" was never part of any Release, from 7.x up to 10.2 - even the
symbol kcbcbhx didn't return any match inside the Oracle code. Shrug.

Wonder where this came from....


On 11/16/06, Jared Still <jkstill@xxxxxxxxx> wrote:

do you mean x$kcbrbh and,  x$kcbcbh?

Last seen in IIRC.

replaced by v$db_cache_advice in 9i.



On 11/16/06, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:
> Hello List
> in what release was v$kcbcbhx removed ?
> Stefan

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: