Oracle DBMS_UTILITY package- How to use – learn with example

Oracle dbms_utility is a powerful built-in package that can be used to perform several tasks from pl/sql programs. Learn here with loads of example.

How to find Oracle database object dependency using dbms_utility package

Learn how to use dbms_utility to find out how to get database object dependency in Oracle

How to get CPU time using Oracle dbms_utility package

This function returns CPU time in 100th’s of a second. See example

How to find Oracle Database Server cluster mode using dbms_utility package

Use Oracle dbms_utility package to find the cluster mode of your Oracle database server – example

How to find Oracle RAC Instance number using dbms_utility package

Oracle dbms_utility package can be used to find the instance number of an Oracle RAC instance – see example

How to use dbms_utility package to analyze Oracle partitions

Using ORacle dbms_utility package it is possible to analyze Oracle Table and Index partitions – see how

How to get database version info using Oracle dbms_utility package

dbms_utility.db_version: returns as OUT parameter the current database version and the version of the database with which this current version is compatible with. This is a procedure in Oracle built-in DBMS_UTILITY package.

How to get operating system version and port of the operating system using Oracle dbms_utility package

dbms_utility.port_string: returns the operating system version and port of the operating system (i.e ALPHA/VMS-8.0.0-64). This is a function in Oracle built-in DBMS_UTILITY package.

How to get parameter value and parameter type of a given parameter using dbms_utility

Learn how to use Oracle built-in DBMS_UTILITY package to get ini.ora parameter type and value

How to get current time using dbms_utility package

Find out how current time can be used using dbms_utility package



Similar Posts