Re: Oracle 10g Express Connection Limitations?

From: gazzag <>
Date: Wed, 7 May 2008 02:58:12 -0700 (PDT)
Message-ID: <>

On 6 May, 19:00, "Jason D." <> wrote:
> V$SESSION the same as V_$SESSION ? I found the latter
> when logging on as "sys" under Views in the Object Browser but
> couldn't find one without the underscore.

select object_name, object_type
from dba_objects
where object_name in ('V$SESSION','V_$SESSION');

OBJECT_NAME                    OBJECT_TYPE
------------------------------ ----------------
V_$SESSION                     VIEW
V$SESSION                      SYNONYM

Just as an aside, why is your usage of Oracle XE a summer-based affair? ;)

HTH -g Received on Wed May 07 2008 - 04:58:12 CDT

Original text of this message