Re: Describing X$ tables in Oracle 21c and 23c

You could always write a little script to join x$kqfta to x$kqfco (or create a view that does it for you) if you want a way of describing the x$tables.
This will only give you the "real" tables, not the the "derived tables" or the x$ "views", though.

I thought I'd published a script about this years ago, but the only one on my blog is on a recent posting
Excavating x$ | Oracle Scratchpad (wordpress.com) <https://jonathanlewis.wordpress.com/2022/03/16/excavating-x/>

Regards
Jonathan Lewis

On Sat, 30 Mar 2024 at 04:17, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On Sat, 2024-03-30 at 03:01 +0000, Sayan Malakshinov wrote:
>
> Hi Mladen,
>
> I've just checked it on my 23.2:
> SQL> select banner_full from v$version;
>
> BANNER_FULL
>
> --------------------------------------------------------------------------------
> Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
> Version 23.2.0.0.0
>
>
> SQL> desc x$ksppi
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> ADDR RAW(8)
> INDX NUMBER
> INST_ID NUMBER
> CON_ID NUMBER
> KSPPINM VARCHAR2(80)
> KSPPITY NUMBER
> KSPPDESC VARCHAR2(255)
> KSPPIFLG NUMBER
> KSPPILRMFLG NUMBER
> KSPPIHASH NUMBER
>
>
> Hi Sayan,
> The mystery is resolved. The problem is SQLcl, my favorite Oracle client.
> Look at this:
>
> mgogala_at_umajor:~$ docker start ora23c
>
> ora23c
>
>
> *mgogala_at_umajor <mgogala_at_umajor>:~$ sql sys/qwerty_at_l23c <sys/qwerty_at_l23c> as sysdba*
>
>
>
> SQLcl: Release 23.4 Production on Sat Mar 30 00:08:18 2024
>
>
> Copyright (c) 1982, 2024, Oracle. All rights reserved.
>
>
> Connected to:
>
> Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
>
> Version 23.2.0.0.0
>
>
> SQL> desc x$ksppi
>
>
> ERROR:
>
> ORA-04043: object x$ksppi does not exist
>
> SQL>
>
> *mgogala_at_umajor <mgogala_at_umajor>:~$ sqlplus sys/qwerty_at_l23c <sys/qwerty_at_l23c> as sysdba*
>
>
> SQL*Plus: Release 21.0.0.0.0 - Production on Sat Mar 30 00:10:21 2024
>
> Version 21.13.0.0.0
>
>
> Copyright (c) 1982, 2022, Oracle. All rights reserved.
>
>
>
> Connected to:
>
> Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
>
> Version 23.2.0.0.0
>
>
> SQL> desc x$ksppi
>
> Name Null? Type
>
> ----------------------------------------- -------- ----------------------------
>
> ADDR RAW(8)
>
> INDX NUMBER
>
> INST_ID NUMBER
>
> CON_ID NUMBER
>
> KSPPINM VARCHAR2(80)
>
> KSPPITY NUMBER
>
> KSPPDESC VARCHAR2(255)
>
> KSPPIFLG NUMBER
>
> KSPPILRMFLG NUMBER
>
> KSPPIHASH NUMBER
>
>
> SQL>
>
>
> So, I will have to blame *that* Jeff Smith. Bummer, I grew used to this
> tool. Too much of the good thing.
>
> --
>
> Mladen Gogala
> Database SME
> https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l