If you are not happy with the response times, you may try gathering dictionary statistics, it helped me a lot that response times decreased from minutes to seconds.
exec DBMS_STATS.GATHER_DICTIONARY_STATS;
If you had exhausted of space, and tried to find a quick way of resizing the tablespaces. You may want to use TOAD feature:
From Administer ->Tablespaces-> Select one tablespace and press F4. In the opened window click datafiles tab and double click the datafile which you want to resize. In this window there is a button "Minimum Size?", click it.
After some time of processing, it will find the minimum size of datafile it could be, it could be better than trial-error method for exact sizes.
[caption id="attachment_299" align="aligncenter" width="300" caption="Tablespace Menu Selection"]
[/caption][caption id="" align="aligncenter" width="300" caption="Datafile Definition Window"]
[/caption]
2 comments:
which version of TOAD has this resize feature?
Hi Thuhong,
As far as I know it is existing nearly in all versions. At least from TOAD 6.
You may not see this feature because, your TOAD license does not cover Admin Module license.
I will also add the picture of the feature.
Derya.
Post a Comment