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 <skursky_at_brn.pvt.cz> wrote:
> Yes, the release is the same.
> Michal
>
>
>
> -----Původní zpráva-----
> Od: Christian Trassens [mailto:ctrassens_at_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 <skursky_at_brn.pvt.cz> 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_at_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_at_fatcity.com
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > 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_at_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_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: Christopher Spence
> > INET: cspence_at_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_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).
> >
> >
> >
>
> > 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_at_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_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: =?ISO-8859-2?Q?Skurský_Michal? INET:
> > skursky_at_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_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).
>
>
> =====
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> ctrassens_at_yahoo.com
> ctrassens_at_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_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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?ISO-8859-2?Q?Skurský_Michal? INET:
> skursky_at_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_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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_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_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 Mon Sep 24 2001 - 11:00:21 CDT
