Jan 14, 2020 7:15:00 AM by Jeff Surretsky
Did you know that Toad® for Oracle can allow you to track Tablespace Usage historically and even forecast how much space you’ll need going forward? Knowing this information is critical for planning purposes, identifying anomalies and much more.
Most of us know that Toad for Oracle allows us to view current space usage and administer all our tablespaces. You are probably using this today. You simply access your tablespaces tab within either the Schema Browser or Database Browser.
This is a very useful feature allowing you to see how much space is currently being used. If you need to add more space, you can simply double-click on any tablespace and an Alter Tablespace dialog will open.
Now comes the fun part!!
There is another Tablespaces window you can open by simply selecting Database>Administer>Tablespaces from the pull-down menu.
Alternatively, you can type “Tablespaces” in our Jump Search Bar located on the upper right corner of your Toad for Oracle desktop. If you're not sure where your Jump Search is, Ctrl-J will place your cursor directly there.
By using either method, you’ll open the Tablespaces Window where you’ll see the Space (default tab), Files, Objects, Space History and IO History tabs.
The Space and File tabs not only allow you to view the space usage of all your tablespaces and Datafiles respectively but, you can also alter them too by double-clicking.
Now let’s see how we can view our historical space usage and forecast our tablespace usage.
Before you can see information in the Space and IO History tabs, you’ll need to first set it up. If you haven’t created the Toad Space Manager tables, you can create them by clicking on the Create/Recreate Toad Space Manager Tables icon with the Space History tab. It is highlighted in Yellow.
Once done, you can edit the time and frequency of when the DBMS_JOB runs as well as the history retention.
Once you’ve started collecting metrics, you can tailor your view based upon which tablespaces you want to see with “All” being a choice. For full transparency, you can even see the actual SQL statement being run to collect these metrics (Show SQL). Knowing where this information is stored allows you access to the data for exporting, customizing reports or whatever you can imagine.
You can even zoom in on the graph using your mouse. Simply drag a rectangle from left to right on the area you to zoom in on to view a specific time range.
In order to forecast your tablespace usage, you can click on the Forecast button.
On this screen, you can specify how many days in the future you want to project space usage for. There is an option to print out this graph.
It is as simple as that!
If you are licensed for using the AWR Browser, there is even a button to explore specific object growth.
This is just one of the many simple, yet powerful features in Toad for Oracle that I hope you take can take advantage of.
Note: This feature requires the DB Admin Module and DBA privileges.
Have you heard about the new Toad utPLSQL unit test creation module?
Most developers and DBAs use Toad for Oracle to reduce time and effort to develop and manage Oracle databases. But did you know that the newly released Toad for Oracle 13.2 includes a new utPLSQL unit test creation module—and it’s available in all Toad editions.
With this new utPLSQL feature, developers can create unit tests easily using an industry standard approach without leaving their database development tool of choice. Read more about utPLSQL in the two blogs below:
Try Toad for free for 30 days:
Already in a trial? Talk to sales or buy now online.
Already a loyal fan of Toad for Oracle? Renew now.
Technical brief: Top Five Reasons to Choose Toad Over SQL Developer
Have questions, comments, or an idea for a new feature? Interact with experts on the Toad for Oracle forum on Toad World®.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Written by Jeff Surretsky
Jeffrey Surretsky has been working at Quest since 2000 as a Sales Engineer focusing on a wide variety of solutions including Foglight, SharePlex and the TOAD Family of Products. Before working at Quest, he was a DBA for various organizations spanning a diverse range of industries including but not limited to Insurance and Telephony . With almost 35 years of experience in the Information Technology industry, Jeffrey has a Bachelor’s Degree in Computer Science and a Masters Degree in Management of Information Systems.