1

We experienced a problem recently where the disc space ran low and some queries started giving unpredictable results. The root cause was that we'd take too many restore points and filled up the disc.

I'd like to be able to monitor this. My context is a big corporate, highly separated functional roles, so I only have access to the SQL query on the box.

My question is: Is there a way to get disc space remaining using an SQL query on an Oracle database?

3
  • 1
    Is the more fundamental issue that you have restore points sitting on a production server that have not been removed somewhere safe that would allow you to restore the db in the case of a failure?
    – armitage
    Feb 21, 2015 at 19:35
  • How does one remove restore points to 'somewhere else' ?
    – Raj
    Feb 24, 2015 at 14:25
  • OP, see gavinsoorma.com/2009/06/monitor-the-flashback-area-space-usage on how to monitor flashback space usage (where flashback files are stored). You do want to check them and raise alerts else you will experience problems. By wrong/unpredictable results is NOT one of them.
    – Raj
    Feb 24, 2015 at 14:27

1 Answer 1

1

You should look here at Managed Tablespace Alerts, notably this bit where you can monitor by two criteria with warning and critical thresholds.

    By percent full

For both warning and critical thresholds, when space used becomes greater than or equal to a percent of total space, an alert is issued.

    By free space remaining (in kilobytes (KB))

For both warning and critical thresholds, when remaining space falls below an amount in KB, an alert is issued. Free-space-remaining thresholds are more useful for very large tablespaces.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.