Contacts     ->      ICQ:    699 512 265,         E-Mail:

  • YouTube Social  Icon


Recommendations for optimizing the size of the database objects generated using dbms_space.asa_recommendations package (Built-in package in Oracle)

The window is not designed to execute commands is a Viewers for package

The request to execute programs for the construction of the window:

       Round(allocated_space/1024/1024,2) "allocated_space" ,
       round(used_space/1024/1024,2) "used_space",
       Round(reclaimable_space/1024/1024,2) "reclaimable_space",
order by reclaimable_space desc

When "List object" Clicking on an entry in the list:

  • in the "Details" box displays additional information

  • in the "Recommendation" field is a list of commands to optimize the disk space occupied by the object

Building a list of commands for the Query Editor

  1. In the "List object" put down checks against the objects for which to create a list of commands

  2. In the "Executing" install check "update statistics" to add statistics for team renewal

  3. In the "Executing" select from a list of recommendations which flows number (1..3)

  4. Switch to the "SQL" tab to see a list of commands