Re: v$session view

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 22 Sep 1998 21:42:31 GMT
Message-ID: <360816e9.4506025@news.siol.net>

On Tue, 22 Sep 1998 16:05:27 -0700, Susan Eck <seck_at_webzone.net> wrote:

>Can anyone tell me the underlying tables that the v$session view is
>based on?

It is based on a "virtual" (or "fixed") table called X$KSUSE. You can find the view's deffinition with the following:

SELECT view_definition
FROM v$fixed_view_definition
WHERE view_name = 'V$SESSION';

>Thanks,
>Susan

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Sep 22 1998 - 16:42:31 CDT