oh Jared darling, you did it. you forced me to correct that typo!
not PCTFREE dear, PCTINCREASE. PCTFREE won't force anything to coalesce
ever.
sigh, and here I thought I was gonna have an easy evening :)
- Jared.Still_at_radisys.com wrote:
> Since SMON will coalesce anyway if needed when a request
> for extents is made, what's the point in setting PCTFREE to
> a value >0 to force periodic coalesces?
>
> An explanation of what takes place during a request for extents
> is in the concepts manual.
>
> Jared
>
>
>
>
>
> Rajesh.Rao_at_chase.com
> Sent by: root_at_fatcity.com
> 01/25/02 01:50 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: SMON - Does it cause a degrade?
>
>
> Hey Fellas,
>
> I have an application DBA who insists that the pctincrease at the
> data
> tablespace should be set to 0 so that SMON does not coalesce the
> tablespace. He says coalesce will be performed by using a scheduled
> batch
> job written for that purpose. He states that having SMON to perform
> an
> coalesce of the tablespace could cause an performance degrade??? I
> have
> never heard of such a thing, but then I dont wanna argue with him.
> He's
> got
> wrinkles on his face, and grey hair ;-)
>
> My argument would be, go back to the drawing board, get your tables
> sized
> properly, if you anticipate fragmentation. And SMON does not cause a
> performance degrade? It wakes up every 5 minutes, does hold ST
> enqueue
> locks if a tablespace needs coalescing, but it does not cause a
> performance
> degrade? Or does it???
>
> Now, can I have a definitive word on this? Any sites, white papers,
> to
> refer to that says so, or to the contrary. I need to convince the
> higher
> ups.
>
> Raj
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Rajesh.Rao_at_chase.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 25 2002 - 19:09:10 CST
