From ctrassens@yahoo.com Mon, 24 Sep 2001 09:00:21 -0700 From: Christian Trassens Date: Mon, 24 Sep 2001 09:00:21 -0700 Subject: RE: coalesce tablespace Message-ID: MIME-Version: 1.0 Content-Type: text/plain And the fragmentation of both. Is the same in both places ??. Have you seen the script ?. It creates 3 temp views and then makes an union of then joining with other sys tables. So, you can see it isn't an easy view. I don't discard a bug on NT. However I haven't found any for this problem. Regards. --- Skurský_Michal wrote: > Yes, the release is the same. > Michal > > > > -----Původní zpráva----- > Od: Christian Trassens [mailto:ctrassens@yahoo.com] > Odesláno: 24. září 2001 17:05 > Komu: Multiple recipients of list ORACLE-L > Předmět: RE: coalesce tablespace > > > The releases are the same too ?. Also , maybe the NT > one is more fragmented than the VMS one. However the > script that creates the view it is a little > complicated. It is based on fet$, ts$, etc... And > depends on the release it is located in the script > named as catspace.sql > > Regards. > > --- Skurský_Michal wrote: > > Hi, > > how is defined view dba_free_space_coalesced? > > What reason can be, that SELECT response on this > > view takes me in databese > > on Win NT several seconds while in database on > > OpenVMS it takes several > > minutes (databases are similar). > > Thanks for suggestions > > Michal > > > > > > > > > > > > > > -----Původní zpráva----- > > Od: Mohammad Rafiq [mailto:rafiq9857@hotmail.com] > > Odesláno: 20. září 2001 22:51 > > Komu: Multiple recipients of list ORACLE-L > > Předmět: RE: coalesce tablespace > > > > > > Following script may be used to check whether > > coalesing is required or not. > > If lasr column not 100% then coalesce that tbs.... > > > > select > > substr(tablespace_name,1,10)TS_NAME,total_extents > > > "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) > > from dba_free_space_coalesced > > / > > > > > > MOHAMMAD RAFIQ > > > > > > > > Reply-To: ORACLE-L@fatcity.com > > To: Multiple recipients of list ORACLE-L > > > > Date: Thu, 20 Sep 2001 12:21:21 -0800 > > > > It would take contiguous free extents and make > them > > larger extents, which > > would be more likely to reuse. Especially if > there > > are many smaller ones, > > this moot if using LMT. > > > > It is a very quick procedure and good to do > > occasional, you can check in > > dba_data_files_coalesced to see if the number is > far > > from 100%, if it is > > less than 75% or so, just throw a coalesce on the > > tablespace. > > > > "Do not criticize someone until you walked a mile > in > > their shoes, that way > > when you criticize them, you are a mile a way and > > have their shoes." > > > > Christopher R. Spence > > Oracle DBA > > Phone: (978) 322-5744 > > Fax: (707) 885-2275 > > > > Fuelspot > > 73 Princeton Street > > North, Chelmsford 01863 > > > > > > > > -----Original Message----- > > Sent: Thursday, September 20, 2001 3:40 PM > > To: Multiple recipients of list ORACLE-L > > > > We have tablespaces in acceptance and production > > that are being resized for > > growth. Pctincrease is set at 0. Would it also > > help to coalesce the > > tablespace? What are the benefits of this > command? > > Thanks, > > Sandi > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: > > INET: Sandi.McClary@flyingj.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@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: Christopher Spence > > INET: cspence@FuelSpot.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@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). > > > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at > > http://explorer.msn.com/intl.asp > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Mohammad Rafiq > > INET: rafiq9857@hotmail.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@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: =?ISO-8859-2?Q?Skurský_Michal? INET: > > skursky@brn.pvt.cz > > > > 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@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). > > > ===== > Eng. Christian Trassens > Senior DBA > Systems Engineer > ctrassens@yahoo.com > ctrassens@hotmail.com > Phone : 541149816062 > > __________________________________________________ > Do You Yahoo!? > Get email alerts & NEW webcam video instant > messaging with Yahoo! Messenger. > http://im.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Christian Trassens > INET: ctrassens@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@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: =?ISO-8859-2?Q?Skurský_Michal? INET: > skursky@brn.pvt.cz > > 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@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). ===== Eng. Christian Trassens Senior DBA Systems Engineer ctrassens@yahoo.com ctrassens@hotmail.com Phone : 541149816062 __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: ctrassens@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@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).