Dynamic Performance Tables

Dynamic Performance Tables
- a set o f virtual tables
- SYS owns ows the ~; their names all begin with V_$
- Views are created on these tables
- Public synonyms are created for the views; the synonym names begin with V$

Notes:

The actual dynamic performance views are identified by the prefix V_$. Public synonyms for these views have the prefix V$. Database administrators and other users should access only the V$ objects, not the V_$ objects.


Note:

SYSTEM can access V$ view; however, in the triggers that owned by SYSTEM, access V$view is not allowed. privilledge obtained through roles

Notes: The problem is that you have access to v$session through a role and therefore cannot create any objects such as triggers, views or procedures which access it. Try logging on as SYS and giving a direct grant select to the user.

9i database reference
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96536/ch3.htm#1109139