| tablespace reaches 70% [message #60433] |
Sat, 07 February 2004 17:55  |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
|
when tablespace reaches 70% of space then i have to message .how can i do it.is there any special packages to implement this.
|
|
|
|
| Re: tablespace reaches 70% [message #60435 is a reply to message #60433] |
Sun, 08 February 2004 18:18  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi Ashok
You Can write Small procedure to check the tablespace using dba_extents,dba_data_files,v$tempfile and dba_free_Space and use the UTL_SMTP package to send a mail to the admins and schedule this procedure to run as job daily or whatever the requirement you have.
or
You can schedule event to monitor this.
IF you want to alert a user the moment it reaches 70%, try creating matrealized view using the above mentioned dictionary views and fire trigger for free space less then 30%. This method I am not sure let me check tommorow and confirm it.
Regards
Prasad
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
