The Café Database Blog
Let's talk about physical backups and how to get a report based on your own "safety criteria" about the successfull backups needed to ensure a safe recovery scenario. In many places, they get reports when backups end successfully, or sometimes only when backup fails,...
What’s the growth trend of an entire tablespace? or an entire schema? Well, it depens on the segments behaviour upon time. Tables, indexes,… yes, they behave different, but Oracle provides some tools you may use to launch a “growth estimation” and surprise your boss or managers with your predictions.
It happens. Sometimes segments grow up and fill the entire tablespace. Maybe you want to shrink the tablespace and there is something stored at the end of the file.
Yes, this is what you may do: move all segments to a new empty tablespace and “defrag it all”