Blog
The Café Database Blog
Get a daily backup report.
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,...
How to calculate the growth estimation of all schema objects.
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.
How to defrag the entire contents in a tablespace
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”