Home > tips > Find Minimum size of datafiles for resize operations in TOAD

Find Minimum size of datafiles for resize operations in TOAD


Last minute addition!

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.

Tablespace Menu Selection

Datafile Definition Window

Advertisements
  1. Thu
    November 21, 2011 at 5:46 am

    which version of TOAD has this resize feature?

    • deryaoktay
      November 21, 2011 at 6:41 am

      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.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: