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

From: Martijn Spronk <spronk_at_columbusgroup.com>
Date: Fri, 30 Mar 2001 10:24:45 -0800
Message-ID: <3AC4CF6D.23E0A5EF@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 Fri Mar 30 2001 - 12:24:45 CST