Re: V_$.... or V$.... ???? What is the difference?

I seem to recall that v_$ is the actual view name, and that v$ is the synonym used to reference those views. You could do worse than browse through sql.bsq (which creates all these things when the database is created) to see what the heck is going on!

Regards
HJR "Martijn Spronk" <spronk_at_columbusgroup.com> wrote in message news:3AC4CF6D.23E0A5EF_at_columbusgroup.com...
> I've been wondering this for a while, and maybe someone can
> enlighten me on the how or why:
>
> What is the difference between V$.... views names and V_$.... viewnames??
>
> In books the dynamic performance views are always referred to as V$...,
 however
> when browsing the tables and views owned by SYS it appears as V_$....
> At the same time, when querying these views from SQL Plus I always use
 V_$... ,
> but then using TOAD, I can only query them if I refer to them as V$...
>
> What is the deal here???
>
> Martijn
>
Received on Sat Mar 31 2001 - 00:09:48 CST