Thursday, October 19, 2006

Tablespace 101% full!



Today I had a strange effect in my DBA class:
I filled up my UNDO TABLESPACE which has only one non autoextensible datafile and waited for the alert to show up in DATABASE CONTROL console.
And it did.
See what it showed: => tablespace 101% full.
How can this be?
This is funny, eh!

6 Comments:

At Wed Oct 25, 08:57:00 PM, Anonymous Anonymous said...

It might want to aware you that even if you try extend it to certain size you should extend it to a size much bigger than you thought in the very first time. :-)

I am kidding :-)

Did you contact Oracle for this?

 
At Thu Oct 26, 09:35:00 PM, Blogger lutz_hartmann said...

Hi, yes I will file a bug!
=;-)

 
At Sat Sep 29, 10:33:00 PM, Blogger ilknur KÖKSAL said...

hi,i had same problem a few months ago. my datamarts data and index tablespaces filled up more than %100..at first i think enterprise manager files have some bug or corrupt i control it another tools and sqlplus commands still problem continuing. i look segments and show bin$ objects too much because of warehouse update. than i purge it so tablespaces became normal and look almost %80s.

 
At Sat Sep 29, 10:33:00 PM, Blogger ilknur KÖKSAL said...

hi,i had same problem a few months ago. my datamarts data and index tablespaces filled up more than %100..at first i think enterprise manager files have some bug or corrupt i control it another tools and sqlplus commands still problem continuing. i look segments and show bin$ objects too much because of warehouse update. than i purge it so tablespaces became normal and look almost %80s.

 
At Mon Oct 01, 06:02:00 PM, Blogger lutz_hartmann said...

Merhaba Ilknur,
bir yildanberi yeni bir blogum var, buraya bak:
http://sysdba.wordpress.com
Hepsi notler orada de var!
Ikitane bloga calismak istemiyorum, çünkü yenim blogu al lütfen.
=;)
Teşekkür ederim

 
At Mon Oct 01, 06:02:00 PM, Blogger lutz_hartmann said...

Merhaba Ilknur,
bir yildanberi yeni bir blogum var, buraya bak:
http://sysdba.wordpress.com
Hepsi notler orada de var!
Ikitane bloga calismak istemiyorum, çünkü yenim blogu al lütfen.
=;)
Teşekkür ederim

 

Post a Comment

<< Home