asa_recommendations

SELECT segment_owner||'.'||segment_name||' ('||segment_type||')' as objet, 
           round( allocated_space/1024/1024,1 ) allocation_Mo, 
           round( used_space/1024/1024, 1 ) Utilisation_Mo, 
           round( reclaimable_space/1024/1024) Reclamation_Mo, 
           round( reclaimable_space/allocated_space*100,0 ) Pct_recupere, 
           recommendations Conseil 
      FROM TABLE(dbms_space.asa_recommendations()) 
order by 4 desc;


SELECT (CASE     WHEN segment_type='INDEX'       THEN         'ALTER INDEX '||segment_owner||'.'||segment_name||' shrink space;' 
                  WHEN segment_type='TABLE' THEN  'ALTER TABLE '||segment_owner||'.'||segment_name||' enable row movement;'||chr(10) 
                                               ||'ALTER TABLE '||segment_owner||'.'||segment_name||' shrink space;' END )  
FROM TABLE(dbms_space.asa_recommendations());

20 DBMS_APPLICATION_INFO

Application developers can use the DBMS_APPLICATION_INFO package with Oracle Trace and the SQL trace facility to record names of executing modules or transactions in the database for later use when tracking the performance of various modules and debugging.

 

22 DBMS_AQ

The DBMS_AQ package provides an interface to Oracle Streams Advanced Queuing (AQ).

35 DBMS_COMPARISON

The DBMS_COMPARISON package provides interfaces to compare and converge database objects at different databases.

 

36 DBMS_COMPRESSION

The DBMS_COMPRESSION package provides an interface to facilitate choosing the correct compression level for an application.

39 DBMS_CRYPTO

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications. It provides support for several industry-standard encryption and hashing algorithms, including the Advanced Encryption Standard (AES) encryption algorithm. AES has been approved by the National Institute of Standards and Technology (NIST) to replace the Data Encryption Standard (DES).

46 DBMS_DATAPUMP

The DBMS_DATAPUMP package is used to move all, or part of, a database between databases, including both data and metadata.

51 DBMS_DB_VERSION

The DBMS_DB_VERSION package specifies the Oracle version numbers and other information useful for simple conditional compilation selections based on Oracle versions.

52 DBMS_DEBUG

DBMS_DEBUG is a PL/SQL interface to the PL/SQL debugger layer, Probe, in the Oracle server.

This API is primarily intended to implement server-side debuggers and it provides a way to debug server-side PL/SQL program units.

53 DBMS_DDL

This package provides access to some SQL data definition language (DDL) statements from stored procedures. It also provides special administration operations that are not available as Data Definition Language statements (DDLs).

62 DBMS_EPG

The DBMS_EPG package implements the embedded PL/SQL gateway that enables a Web browser to invoke a PL/SQL stored procedure through an HTTP listener.

63 DBMS_ERRLOG

The DBMS_ERRLOG package provides a procedure that enables you to create an error logging table so that DML operations can continue after encountering errors rather than abort and roll back. This enables you to save time and system resources.

67 DBMS_FILE_TRANSFER

The DBMS_FILE_TRANSFER package provides procedures to copy a binary file within a database or to transfer a binary file between databases.

75 DBMS_IOT

The DBMS_IOT package creates a table into which references to the chained rows for an index-organized table can be placed using the ANALYZE command. DBMS_IOT can also create an exception table into which references to the rows of an index-organized table that violate a constraint can be placed during the enable_constraint operation.

77 DBMS_JOB

The DBMS_JOB package schedules and manages jobs in the job queue.