Oracle Database Administration, Performance Tuning, Backup Recovery
DBMS_SHARED_POOL Package
DBMS_SHARED_POOL provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects are stored.
 
DBMS_SESSION Package
DBMS_SESSION package provides access to SQL ALTER SESSION and SET ROLE statements, and other session information, from PL/SQL.
 
DBMS_REDEFINITION Package
DBMS_REDEFINITION package is used to redefine table columns and column names. The dbms_redefinition package allows you to copy a table, create a snapshot on the table, enqueue changes during the redefinition, and then re-synchronize the restructured table with the changes that have accumulated during reorganization.
 
DBMS_PIPE Package
DBMS_PIPE package lets two or more sessions communicate in the same instance. Oracle pipes are similar in concept to the pipes used in UNIX, but Oracle pipes are not implemented using the operating system pipe mechanisms.
 
DBMS_OUTPUT Package
DBMS_OUTPUT oracle package enables you to send output messages from various other PL/SQL program units like stored procedures, packages, triggers etc.DBMS_OUTPUT is primarily used for displaying messages or debug information from a PL/SQL Program. The procedures contained in this package are DISABLE, ENABLE, PUT, PUT_LINE, GET_LINE, GET_LINES and NEW_LINE.
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Results 11 - 15 of 69