My Oracle Support Banner

How to Determine if XDB is Being Used in the Database? (Doc ID 733667.1)

Last updated on AUGUST 03, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database - Personal Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Goal

 

This script will provide output to show which features of XML Database (XDB) are currently being utilized in the database.

There are times where this script may not run due to XDB repository  items being invalid or corrupt . if you encounter exceptions running this script you can try the script form note: 790812.1 instead.  Even though it is a 10g note it will still give support a base idea of which items are being used as they offer repair/recovery recommendations.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Requirements 
 Configuring 
 Instructions 
 Script
 Sample Output 
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.