Hi,
I am trying to use the Space Manager, but when I try to invoke it I get the message that the Quest Space Manager is not found.
I am connected to the database as sysdba, so should not be missing any privileges.
I have a TOAD schema, but it only contains a single table - TOAD_PLAN_TABLE.
The server side objects wizard does not appear to exist anymore, and on-demand object creation does not appear to be doing anything.
I am using Oracle 10.2.0.5 and TOAD 12.0.0.61
Let me start with my usual harping - there is no reason to connect as sysdba when using Toad. There are like 3 or 4 minor areas where this is required - e.g. running the instance manager where you want to start/stop databases. Sysdba should only be used when you know for a fact from reading Oracle docs that task X such as start/stop database requires me to connect as sysdba. It’s not a silver bullet fix all my problems tool.
That said, let me try to answer your question. Quest Space Manager is a separate product which requires a license - it is not a toad feature. Toad does have a limited feature to show the history of tablespace data file space usage and IO statistics. You go to main menu -> database -> administer -> tablesapces. There will be two tabs near the end for the space usage history and IO stats. If you navigate to either of these tabs, toad will sense that the tables to support this feature are missing and ask if it’s OK to create them. That’s it.
Toad no longer offers either scripts or a database object creation wizard. Instead it now checks when you use a feature that requires an object, and if it’s missing it asks you. That makes it far easier for most people.
There was a bug in a recent version (it may have been 12.0, I don’t remember for sure) where it was difficult to get those objects to install. I just tried it and it worked OK for me, but if you can’t get them set up, send me an email (john.dorlon at software dot dell dot com) and I will send you the script to create them.
Using toad for Oracle RAC, 13.1.1.5 many of the tools the user server side objects don't work. I got some objects to load into a TOAD SCHEMA for the table space manager. it installed a few tables and a package . All have public synonyms. I try as sys and TOAD user neither will get it going.
Try this:
If it doesn't seem to work, post a screen shot and the spool SQL contents.
If there is just nothing in the charts and you just recently set up the server side objects, maybe the problem is that the data collection job just hasn't had a chance to run enough times yet to get enough data to report on.
This process works and is available to me - i can select a table space but however the icon to launch quest space manager does nothing. is there a tool there ?
here is the spool...
-- Session: SYS@DWREBUILD
-- Timestamp: 14:29:05.106
select 1 from dba_tablespaces where tablespace_name = 'SYSTEM' and extent_management = 'LOCAL';
-- Session: SYS@DWREBUILD
-- Timestamp: 14:29:05.362
-- if this query is slow, see Oracle Doc ID 1292253.1
select a.tablespace_name,
round(a.bytes_alloc / 1024 / 1024) megs_alloc,
round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,
round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,
round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_Free,
100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,
round(maxbytes/1048576) Max,
c.status, c.contents
from ( select f.tablespace_name,
sum(f.bytes) bytes_alloc,
sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO', f.bytes)) maxbytes
from dba_data_files f
group by tablespace_name) a,
(
select ts.name tablespace_name, sum(fs.blocks) * ts.blocksize bytes_free
from DBA_LMT_FREE_SPACE fs, sys.ts$ ts
where ts.ts# = fs.tablespace_id
group by ts.name, ts.blocksize
) b,
dba_tablespaces c
where a.tablespace_name = b.tablespace_name (+)
and a.tablespace_name = c.tablespace_name
union all
select h.tablespace_name,
round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,
round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / 1048576) megs_free,
round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,
round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,
100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,
round(sum(decode(f.autoextensible, 'YES', f.maxbytes, 'NO', f.bytes) / 1048576)) max,
c.status, c.contents
from sys.v_$TEMP_SPACE_HEADER h,
sys.v_$Temp_extent_pool p,
dba_temp_files f,
dba_tablespaces c
where p.file_id(+) = h.file_id
and p.tablespace_name(+) = h.tablespace_name
and f.file_id = h.file_id
and f.tablespace_name = h.tablespace_name
and f.tablespace_name = c.tablespace_name
group by h.tablespace_name, c.status, c.contents
ORDER BY 1;
Oh, Quest Space Manager is a separate product. If it's not installed on your computer, that's why you are getting the message. Although, I would think in that case that the icon to launch it wouldn't be enabled at all.
Do you have that installed on your computer? If so, which version? Maybe you have incompatible versions of Toad and Space Manager.
13.1.1.5 - I paid for the RAC version of TOAD for Oracle