Re: v$session

On Feb 5, 2:38 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Feb 5, 11:14 am, Ben <benal..._at_yahoo.com> wrote:
>
> > 10.2.0.2 ent ed
>
> > what underlying table is v_$session built on?
>
> > create or replace public synonym v$session for v_$session;
> > create or replace view v_$session as select * from v$session;
>
> > These are the only ddl statements I can find related to it, they
> > reference each other.
>
> You can figure it out like this:
>
> desc v$fixed_view_definition
>
> select view_name from v$fixed_view_definition
>   where view_name like '%SESS%';
>
> SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV
> $SESSION';
>
> jg
> --
> @home.com is bogus.
> What's in your database?http://www.mailonsunday.co.uk/pages/live/articles/news/news.html?in_a...

Thank you very much.
So have you ever updated x$ksuse or x$ksled ? Received on Tue Feb 05 2008 - 14:59:00 CST