-
Hi
How do u find if an Index is low on space/extents?
Thanks.
With regards.
-
first you can look at the ratio extents/maxextents to see if there will be a problem with the number of extents.
most important thing to do is to look if your index can allocate a next extent, that is to say that there should be enough space in the tablespace and in the datafile(s). like that, and if your objects have been correctly built (acording to the number of rows they should have), you should be quite cool since your indexes won't take many extents at a time, just one, so you can easily anticipate the problems
-
Thanks for the reply.
The ratio of extent/maxextents is ...
select max_extents from dba_indexes where index_name like 'FND_COLUMNS_U2' and TABLESPACE_NAME LIKE 'APPLSYSX';
MAX_EXTENTS
-----------
50
select bytes, blocks from dba_extents where segment_name like 'FND_COLUMNS_U2' and tablespace_name like 'APPLSYSX';
BYTES BLOCKS
---------- ----------
16384 2
2129920 260
2129920 260
So, 3 extents.
extents 3
------------- => ------------ = .06
maxextents 50
Total Space in tablespace APPLSYSX is 115 MB with 13 MB free.
Is this ok?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|