Hi : I am creating a unique index on 65 million rows for a table that is about 3GB. I have allocated about 3.5GB for the index creation. How can I monitor this while this index creation is happening, since when I coming closer to end of datafile or extents, I can add more space..
I tried dba_extents and dba_free_space for this index tablespace and this TS is going to hold only this index..
Well in the future you can always allocate more than you need. Since this is a clean build you can go back and re-size the datafile when the index is built. This way you insure that it gets built the first time. If you have OEM you can refresh the tablespace view and monitor from there.
Monitoring growth of dba_extents and dba_free_space
could be enough if extents size is small .
if u have a very large initial extent then may physically checking the average approximate size of the indexed row with rowid may help u in monitoring the growth of the index.