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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 30 Mar 2024 00:16:32 -0400
Message-ID: <865ce32875810474119361afea01a40f9a914de6.camel_at_gmail.com>

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:~$ sql 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:~$ sqlplus 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

Received on Sat Mar 30 2024 - 05:16:32 CET