Oracle Tips and Techniques

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

Filed under: Oracle FAQ by admin
No Comments »

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

Filed under: Oracle FAQ by admin
No Comments »

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

Filed under: Oracle FAQ by admin
No Comments »

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

Filed under: Oracle FAQ by admin
No Comments »

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

Filed under: Oracle FAQ by admin
No Comments »

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.

Filed under: Oracle FAQ by admin
No Comments »

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.

Filed under: Oracle FAQ by admin
No Comments »

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

Filed under: Oracle FAQ by admin
No Comments »

Find out how current time can be used using dbms_utility package

Filed under: Oracle FAQ by admin
No Comments »

This package can be used to find out whether the Oracle database server is running in Parallel server mode or not

Filed under: Oracle FAQ by admin
No Comments »