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;