Re: Tablespace Usage and Performance
Date: Fri, 7 Nov 2008 08:40:19 -0800 (PST)
On Nov 7, 11:04 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10g 10.2.0.3
> Windows 2003 Server
> I have someone who made the following statement:
> "any time a tablespace is > 85% [ of capacity ] we experience performance
> Is there any validity in that or not?
No, the tablespace space being 85% allocated should have no effect on performance unless perhaps dictionary extent management was in use and the objects in the tablespace in question were undergoing heavy extent allocation. Proper object sizing (or better yet use of locally managed tablespaces) would eliminate this issue.
If the objects in the tablespace never needed to expand the tablespace could be 100% full and the queries on the tables in the tablespace should run at the same level of performance if an additional file was added or extended making the total space allocation 50%.
The statement is just not logical based on how Oracle data files are created and managed.
HTH -- Mark D Powell -- Received on Fri Nov 07 2008 - 10:40:19 CST