Tablespace map takes an unreasonable long time to show up and the Space Manager client GUI just hangs.
A /*+ rule */ hint in the view quest_spc_seg$ is causing the slow execution.
RESOLUTION 1:
1. Remove the the /*+ rule */ hint from the view quest_spc_seg$
2. Reconnect to the database with Space Manager
RESOLUTION 2:
1. Sign on to the database as the owner of the Space Manager objects
2. Re-create a view using the statement included below:
create or replace view quest_spc_seg$
(ts#, file#, block#, blocks, extents, initial_extent_blocks,
next_extent_blocks, type#, min_extents, max_extents, pct_increase, lists,
freelists, groups, freelist_groups, cachehint, buffer_pool, scanhint,
hwmincr, spare1, spare2, table_compression, table_compress_for
)
as
select
ts#, file#, block#, blocks, extents,
iniexts as initial_extent_blocks,
extsize as next_extent_blocks,
type#,
minexts as min_extents,
maxexts as max_extents,
extpct as pct_increase,
lists,
decode (lists, 0, 1, lists) as freelists,
groups,
decode (groups, 0, 1, groups) as freelist_groups,
cachehint,
decode (cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', null) as buffer_pool,
scanhint, hwmincr, spare1, spare2,
decode (type#,
5, decode (bitand (spare1, 2048), 2048, 'ENABLED', 'DISABLED'),
null) as table_compression,
null as table_compress_for
from sys.seg$ ;
3. Reconnect to the database with Space Manager
Status: This fix is scheduled for version 6.8.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy