The Space Manager Repository collects and stores statistics. The statistics stored in the Repository are used by Space Manager to calculate reorg need and wasted space. Reorg need and wasted space are displayed in the Explorer, used in generated reports, and used by the Reorganization Wizards.
In addition, statistics from the Repository are displayed in the Explorer and in Object Properties.
There is one repository for each database where Space Manager is installed. An unlimited number of collections can be accumulated in the repository for each object. When multiple collections are made in one day, only the last collection is kept.
Statistics are collected by the Repository Update job that is scheduled to run daily, by default. You can modify the frequency at which this job runs, if necessary. See Change Repository Update Schedule for more information.
This job collects statistics from the Oracle data dictionary and from running Oracle procedures (like those in the DBMS_SPACE package). These statistics are then used by Space Manager to display the list of objects in the Explorer, to estimate table sizes, to generate trend reports, to calculate reorg need and wasted space, and to provide a variety of storage and space use information throughout the Space Manager interface.
Accumulated statistics provide the historic information needed to track growth rates over time and project future space needs. If statistics have never been collected for an object, zero growth is assumed for that object.
See the following topics for more information about Repository-related tasks:
You can use the DML Profiler to profile SQL going against a table you want to reorganize so that you can plan when to start and switch a table reorg. This Smart Start provides an overview of all the major steps involved in profiling DML activity.
To create a DML Profile
The Create DML Activity Collection dialog opens to the Parameters tab.
If you want to add objects, select the Select Objects tab. Select additional objects to include and click Add to List.
In the Parameters tab, specify collection parameters. Review the following for additional information:
|Duration||Enter then number of days, hours, minutes, and seconds that you want to collect activity.|
(Advanced) Enter the number of seconds that elapse between two queries on the collection table.
|Cycles per Collection||(Advanced) Enter the number of cycles between two updates on the collection statistics table.|
|Long Running Transaction Cycles||(Advanced) Enter the number of cycles that can elapse before a transaction is considered long running.|
|Schedule||Select whether to run activity collection instantly, save the script to run at a later time, or schedule the collection script to run on a specific date and time.|
To stop a currently-running DML Profile script
To modify the script's collection duration
To reschedule a script
To unschedule a scheduled script
To generate a DML Profile report