Typically running close to 100% storage doesn't cause a performance problem,
though a good DBA will allocate more storage as necessary since hitting 100%
storage in a non-expanding tablespace does cause a performance problem (the
db stops <g>). I'd start by seeing what operations perform slowly and
tracing and optimising the sql statements for them.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"konopam" <konopam_at_yahoo.com> wrote in message news:%1%q8.2$l%.101_at_client...
> Hello,
>
> I was wondering if anyone could let me know if having your tablespace
> percentage
> above 80 is bad? Should I make the extents bigger?
>
> We are having some performance problems w/ an Oracle 8.0.5 db and this has
> been in production for about 5 months, the only thing that I can see from
> storage manager is that there are 3 data files that are about fully
used --
> 95% or better should I increase these
> tablespaces to help
>
> Any other ideas on what I can do to check performance of the database
>
> Appreciate any input
>
> Thanks
> Andy
>
>
Received on Thu Apr 04 2002 - 14:41:27 CST
