GET_DB_INFO - Perceptive Content Database IN_DB_UTIL Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database IN_DB_UTIL Package for Oracle Server

Platform
Perceptive Content
Product
Perceptive Content Database IN_DB_UTIL Package for Oracle Server
Release
Foundation 24.1
License

The GET_DB_INFO stored procedure is used to display details about the database.

Gathered information includes the following:

  • Instance Name
  • Database Name
  • Database Edition and Version
  • Optimizer Related Parameters
  • NLS_DATABASE_PARAMETERS
  • NLS_INSTANCE_PARAMETERS
  • NLS_SESSION_PARAMETERS

Exception

Example

SET SERVEROUTPUT ON; 
EXEC IN_DB_UTIL.GET_DB_INFO;