Contacts     ->      ICQ:    699 512 265,         E-Mail: CerebroSQL@gmail.com

  • YouTube Social  Icon

Reclaimable

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:

select TABLESPACE_NAME,
       segment_name,
       segment_owner,
       segment_type,
       partition_name,
       Round(allocated_space/1024/1024,2) "allocated_space" ,
       round(used_space/1024/1024,2) "used_space",
       Round(reclaimable_space/1024/1024,2) "reclaimable_space",
       recommendations,
       c1,c2,c3
from
table(dbms_space.asa_recommendations('FALSE','FALSE','FALSE'))
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