oracle and databse storage
Posted on 2013-02-07
Excuse my ignorance on this issue (not a DBA tech), but when you manage oracle databases, do you specify a specific allocation of storage for the database, and if so where can you see what storage you allocated and how close to capacity you are? Is this configured in the database or on the host operating system?
Is monitoring free space a common DBA task?
Are there any other day-to-day capacity monitoring tasks you do, to see where you are approaching worrying thresholds?
Do Oracle recommend any day-to-day management and monitoring tasks such as this?
I am trying to go with a list to the DBA’s to see what they should be doing and align it with procedures and what they actually are doing. So issues that lack of monitoring can miss and the subsequent risks would be very useful. Storage was just one idea i.e. if you’ve run out of space what happens when the database is still being populated with data.