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

Hi Mladen,

Maybe you want to define an
alias descx=SELECT name, type, object_id

FROM v$fixed_table
WHERE lower(name) like 'b1:%';

hth,
 Martin
^∆x

Mladen Gogala <gogala.mladen_at_gmail.com> schrieb am Sa., 30. März 2024, 05:18:

> 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