x$ktuxe

#1 (**permalink**) 02-24-2008, 09:09 AM

Hi,

I try to find some statistics for undo segment
I haven't the table (view, syn.) named X$KTUXE
on my 9i and 8i ..
Is there some script to run to get it ???

Thanks in advance

#2 (**permalink**) 02-24-2008, 09:10 AM

"zeb" <spam@nowhere.com> wrote in
news:41a39e05$0$21351$636a15ce@news.free.fr:

> Hi,
>
> I try to find some statistics for undo segment
> I haven't the table (view, syn.) named X$KTUXE
> on my 9i and 8i ..

Are you sure about this?

Were you logged like
connect / as sysdba
when you tried your query?

EXACTLY what was the query & Oracle's actual response?

#3 (**permalink**) 02-24-2008, 09:10 AM

It's an internal dynamic table and varies from release to release.
Make sure you connect as sysdba
sql> connect / as sysdba
connected.
sql> desc x$ktuxe

#4 (**permalink**) 02-24-2008, 09:11 AM

Me culpa, I wasn't sysdba ....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode