Date: Tue, 5 Feb 2008 12:59:00 -0800 (PST)
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
> @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