hi
1)
After I find the size of a table/schema using dba_segments, how do I determine if the size is bloated?
2)
Is there a way to to reduce the schema size or table size while client is using them? i.e. Table/Schema have to remain as they are while client is using them, no recreating because client is using them
3)
Is there a way to check in advanced how much space will be saved before I start the process.
4)
Is there a recommendation to do this while the client is still using the schema or table?
there doesn't seem to be any clear material on this. Like how will impact the database when client is using that schema or table I want to reduce in size? Any references out there?
11.2.0.4 RAC database
Linux 6.7
thanks guys