top of page

Courses
Contact
Members
More

Use tab to navigate through the menu items.

To see this working, head to your live site.

Categories
All Posts
My Posts

alert full tablespaces

in Oracle Database Administration

I want code to show alert when user tablespace is full. and send notification for us

1 answer0 replies

Like

1 Comment

Piyush Ranjan

Mar 17, 2022

•

Take a glance at the link for the Tablespace Monitoring script.

Tablespace monitoring shell script in oracle database

Below shell script for tablespace monitoring can be configured in crontab to send notification to DBAs upon reaching threshold.

Review the following Oracle doc link for additional information on Managing Tablespce Alert:

docs.oracle.com

Database Administrator’s Guide

Managing space for schema objects involves tasks such as managing tablespace alerts and space allocation, reclaiming unused space, dropping unused object storage, monitoring space usage, and capacity planning.

1

1 comments

Similar Posts

Check default tablespace and temporary tablespace of each user
SYSTEM TABLESPACE 98% full
In my Oracle Database TEMP tablespace becomes 100% full?

support@dbagenesis.com

© 2023 Biggest Database Forum by DBA Genesis

bottom of page