Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance problems
Depends.
If the tables are going to grow larger ... you have no choice but to make the tablespaces larger. But were they set up to autoexpand when they were created?
But I am lost by your comment about making extents bigger? There is no relationship between extent size on your concern about tablespace usage.
Daniel Morgan
konopam wrote:
> 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 - 10:58:06 CST