Toad 14.0.75.662 x32 - Administer tablespaces performance issue

Toad for Oracle
1

Toad 14.0.75.662 x32 - Administer tablespaces performance issue - taking 15 mins to display tablespace details while connecting to DB 12.1.0.2.

2

When it does come up, is "Use DBA_LMT_FREE_SPACE" checked?

If not, check it and try again.

It loads much faster with that box checked, but counts objects in the recycle bin as "used" space.

3

Great advice John... checking the box to use DBA_LMT_FREE_SPACE certainly loaded space info faster in my Toad, thanks for sharing.

BTW, if you continue to have issues, there's a way to identify what SQL behind the scenes Toad is spending the most time on. Before you bring up the tablespace info, try this:

  • Select Database->Spool SQL to toggle on SQL Spooling (e.g. To the Screen)
    You will see the Spool SQL tab in the Output Panel
  • Make sure to check "Elapsed Time" via the Spool Options icon
  • Select Administration->Tablespaces
  • Check the Spool SQL tab to see which SQL might be the problem query

image
image1218×836 103 KB

1 Like
4

Thanks a lot, John. Its working faster now.

5

Thanks, Gary. I will follow your suggestion if it happens next time.

6

in such a cases (when some ordinary sys call takes to long) i would always check dictionary stats as well as fixed objects stats.
i am almost certain either you do not have or it is obsolete.