Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 28 October 2014

Tablespace Management using Toad

You can view all of your tablespace information using toad tablespace screen from Database –> Administer –> Tablespaces
Here each table describes different detailed information across all the tablespaces in database. If you open this screen from the toad DBA module then you are also able to see the “space history” and “IO history” tab along with Files, Free space, object, Fragmentation.
With these tab you are able to able perform space monitoring and planning steps. These tab permits you check graphically space and IO usage over time. Through this way DBA are also able to estimate ‘Object size’ based on this estimation.
From the below “alter tablespace” tab you can
§         Modify the tablespace and datafile size.
§         Add new datafile to the tablespace.
§         Drop the existing tablespace.
§         Change the status of tablespace ‘online’ or ‘Read only’
§         Review schema object extent allocation.
§         Checking tablespace fragmentation.
For Example to edit the datafile click on datafile tab on the above screen

6 comments:

  1. Great article, please check out www.dbahowto.com, it has some great tips on Oracle database setup and administration.

    ReplyDelete
  2. Great post.
    It really helped me to learn something new. So thanks.
    Web development company in bangalore

    ReplyDelete