| Napster |
Posted: May 13, 2008 05:09:00 AM |
Total Post: 29
Joined: Apr, 2008
|
Hi All,
I've a Production database 9.2.0.8.0 on Sun Solaris 5.10
I have a tablespace XYZ with autoextend ON on one of it's datafiles and a maxsize set.
there was ample space in it, but yesterday the tablespace was full and it went till the maxsize and hence no data could be added in it.
I want to know if there is an alert available in 9i for such scenarios.
Can i arrange for an alert that i'm about to reach maxsize so that either i can add datafile or resize tablepsace OR is there any other technique to deal with this???
Thanks |
|
|
 GOPU |
| Posted: May 13, 2008 05:18:25 AM |  |
|
Total Post: 334
Joined: Apr, 2008
|
Can you elobrate what you mean by alert ...?
I think whenever the datafile was full, you need to get an alert that you have to add a datafile or resize the tablespace from the Oracle side.... Am i correct ?
|
|
|
|
|
| Napster |
| Posted: May 13, 2008 05:29:49 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
Hi Gopu,
Oracle will give me ORA-1654 if my tablespace is full....
i want to know if we can get an alert before we get this error and before the tablespace gets full(autoextend + maxsize reached)
i hope u've understood my query ...if not please ask more questions
and what do you mean by alert????
thanks
|
|
|
|
|
| Gitesh |
| Posted: May 13, 2008 05:33:36 AM | |
|
Total Post: 322
Joined: May, 2005
|
Make a script for checking tablespace space and keep threshold with 85 to 90%.Schedule it with alert given in mail.
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 05:38:10 AM | |
|
Total Post: 334
Joined: Apr, 2008
|
When the tablespace is full at that time only the oracle will generate the error ORA-1654.then how is is possible to get it early ?
The only thing you can do is you can avoid the situation to occur the error.
|
|
|
|
|
| Murtuja |
| Posted: May 13, 2008 05:39:16 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
This script can help you monitor tablespace space threshold
http://firstdba.googlepages.com/monitor_tbs.sh
|
|
|
|
|
| Napster |
| Posted: May 13, 2008 05:44:31 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
Hi Gopu,
I want to avoid it before it gives the error...how do i do that??
by autoextend-----done that
but i will have to set maxsize --else fragmentation---
so wats the workaround for this ???
thanks
|
|
|
|
|
| GOPU |
| Posted: May 13, 2008 05:51:03 AM | |
|
Total Post: 334
Joined: Apr, 2008
|
Check what Gitesh said,
you have to do that only,monitor the tablespaces and avoid the error.Oracle will throw the error when the sitiations comes,Other wise how it will throw error....
go through the link Murtuja posted....
http://firstdba.googlepages.com/monitor_tbs.sh
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 14, 2008 05:26:19 AM | |
|
Total Post: 132
Joined: Apr, 2008
|
use enterprise manager to set alert on tablespace size.
Your tablespace has auto extend on but have have set the max_size so when the size of the tablespace cross the max_size then you face the problem..
so set heigh max_size or unlimited it (32 GB) if you have physical space avilable
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
