Hi,
i've a 11.2 database and i've performed an impdp.
During import, impdp, i've noticed that the tablespace growth in allocation but not in usage, so I thought it was table initial and next extents.
But, when impdp starts to create indexes the space usage starts to increase, not the allocated.
At the end of the import i've a tablespace with allocated 20gb and used 8Gb. So i've perform a shrink of the datafile setting to 9Gb.
After some minute a process like w000 starts to consume cpu and i/o and the tablespace return to 20gb of space allocated and
and 8 used.
Why?
Regards