Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Next Extent?
HI,
I have this situation, i created a table with theses parameters:
INITIAL : 252k NEXT : 28k PCTINCREASE : 0%
We do a lot of insert and delete on that table. SO the problem(?), is that i was selecting the information from the table sys.dba_extents for that specific table, to see how many extents it did consume until now, and the result of the select is :
extent_id file_id block_id size in bytes --------- ------- -------- ------------- 0 8 62 266240 1 8 127 40960 2 8 137 40960
The question
Any help would be appreciated ?
Hanna
--
Received on Mon Jul 28 1997 - 00:00:00 CDT