Can some one shed some light on what determines the MAXBLOCKS a data file
can have

I got bit by a developer that created a table space with a 2k block size and
the DB is 16k. What happen is the backblocks for this db is 4194302 so all
my other DBF 's can auto extend to 16K*4194302= 64GB (not That I would let
them get this big but I new the limit) the 2K table space can only auto
extend to 2K*4194302=8GB (I was not aware it had a 8GB limit)

Also what would be a good way to monitor this I guess a script that looks at
a table spaces block size and MAX blocks?

DB=9.2.0.5
OS=2003

Opinions are greatly appreciated

Thanks


Oracle LazyDBA home page