Re: [Q] What is that table?

Kevin Purcell <purcell_at_iag.net> wonders:

>
> I have come across a table I can not find any information about.
>
> The table is x$kzsro.
>
> The table is used in the view SESSION_ROLES.
>
> I can not do a desc x$kszro or sys.x$kszro in sqlplus at all
> regardless of what user I am logged in as.
>
> I would like to get more documentation on the x$ tables. I have looked
> at RevealNet. If any one knows of any other sources of information on
> these table please E-Mail or Post.

Joe Trezzo gave an excellent talk about the X$ tables at one of the MOUG conferences. It can be found at:

http://www.tusc.com/pages/download.html

If you want to do a describe of an X$ table, do this:

sqlplus
connect sys/{sys password}
create view v_$ksro as select * from x$ksro; grant select on v_$ksro to system with grant option; create public synonym v$ksro for v_$ksro; connect system/{system password}
desc v$ksro

-- 
Bob Poortinga (mailto:bobp_at_tsc.com)
Senior Database Consultant
Technology Service Corp.
Bloomington, Indiana USA