| System "Trigger" that fires when a tablespace becomes X% full. [message #60517] |
Wed, 11 February 2004 23:00  |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Hi,
Is there a kind of system trigger or/and stored procedure that we can configure for our user's tablespaces and that fires when a tablespace is getting X% full? Where X is configured and set up by the DBA?
Can we find or download such SQL triggers/procedures that we can customized (for exemple, send a mail to the DBA, write in a DBA custom log...)?
Many thanks in advance for your tips!
Regards,
Patrick Tahiri.
|
|
|
|
| Re: System "Trigger" that fires when a tablespace becomes X% full. [message #60518 is a reply to message #60517] |
Wed, 11 February 2004 23:36  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
You could create a logon trigger (after logon on database) that calculates the free space and if it goes beyond a certain limit you could, indeed, send a message to the DBA. There are several possibilities of how the DBA is being warned, but the easiest is to write in a file (via UTL_FILE) or in a DBA log table.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
