Re: Tablespace Usage and Performance
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Nov 2008 11:36:12 -0800
Message-ID: <1226518556.654540@bubbleator.drizzle.com>
>> 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 degragation".
>>
>> Is there any validity in that or not?
>>
>> Thanks
>>
> Of course there is! Or would you call that > person a liar?!?
Date: Wed, 12 Nov 2008 11:36:12 -0800
Message-ID: <1226518556.654540@bubbleator.drizzle.com>
Frank van Bortel wrote:
> Dereck L. Dietz 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 degragation".
>>
>> Is there any validity in that or not?
>>
>> Thanks
>>
> Of course there is! Or would you call that > person a liar?!?
I wouldn't call that person I liar.
I might, however, point out to them that they were misinformed.
And then follow it up with a demonstration that proves it.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Nov 12 2008 - 13:36:12 CST