Managing X$ views for Oracle DB Instances on AWS RDS

Accessing the SYS.X$ fixed tables on AWS is achived by using the AWS rdsadmin.rdsadmin_util package.

The package will create custom views on these underlying oracle X$ views. For example, using the package to gain access to X$BH creates a custom RDS view that points to the Oracle view

X$BH -- > RDS_X$BH

The master user of the RDS database is automatically granted the privilege SELECT … WITH GRANT OPTION on the RDS_X$ view created.

Only the following X$ views are currently supported

• X$BH

• X$K2GTE

• X$KCBWBPD

• X$KCBWDS

• X$KGLLK

• X$KGLOB

• X$KGLPN

• X$KSLHOT

• X$KSMSP

• X$KSPPCV

• X$KSPPI

• X$KSPPSV

• X$KSQEQ

• X$KSQRS

• X$KTUXE

• X$KQRFP

The list of views supported in the future may change. You can see what views are currently supported using the following command

SQL> SELECT * FROM TABLE(rdsadmin.rdsadmin_util.list_allowed_sys_x$_views);

Notes

The rdsadmin.rdsadmin_util procedures are available in the following database engine versions:

• 21.0.0.0.ru-2023-10.rur-2023-10.r1 and higher Oracle Database 21c versions

• 19.0.0.0.ru-2023-10.rur-2023-10.r1 and higher Oracle Database 19c versions

Published on 

30 July 2024 at 11:45:10