Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo a Tablespace

RE: Redo a Tablespace

From: Javier Morales <Javier_at_infojobs.net>
Date: Wed, 15 Nov 2000 19:14:44 +0100
Message-Id: <10681.122145@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04F30.E937F560
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

please, may you send them to me... I'm also interested in them... =20
thanks! ;-)

 ---------------------------------------=20
 Javier Morales - javier_at_infojobs.net=20  Administraci=F3n Bases de Datos Oracle - InfoJobs.net=20  Tel. +34 902 10 60 90 Ext. 2067=20
 Fax. +34 (93) 580 56 60=20
 =20

-----Mensaje original-----
De: Anandarao, KrishnamurthyX =
[mailto:krishnamurthyx.anandarao_at_intel.com] Enviado el: mi=E9rcoles 15 de noviembre de 2000 18:01 Para: Multiple recipients of list ORACLE-L Asunto: RE: Redo a Tablespace

Laura, I would definitely be interested in it. Can you forward me = those
scripts please.
=20
Thanks
Krish

-----Original Message-----
From: Burton, Laura L. [mailto:BurtonL_at_prismplus.com] Sent: Wednesday, November 15, 2000 7:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo a Tablespace

It comes from an article 'How to Stop Defragmenting and Start Living: = The
Definitive Word on Fragmentation' by B. Himatsingka and J. Loaiza from = the
Oracle Corporation.

SAFE =3D Simple Algorithm for Fragmentation Elimination=20

I made a script which contain queries for the rules referenced in the article. I'll send it to you if you want it.=20

Laura=20

-----Original Message-----=20
From: Maser, Donna (SEA) [ mailto:DonnaMaser_at_chiroscience.com
<mailto:DonnaMaser_at_chiroscience.com> ]=20
Sent: Tuesday, November 14, 2000 2:41 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: RE: Redo a Tablespace=20

Laura,=20
  What are the 'ofSAFE' rules that you refer to?=20 - Donna=20

-----Original Message-----=20
Sent: Tuesday, November 14, 2000 5:06 AM=20 To: Multiple recipients of list ORACLE-L=20

Thank you for responding to my question. Yes to #4 and #5. An example = of=20
this is creating a user REFERENCE to own all the reference (static) = tables=20
and have the tables located in one tablespace called REFERENCE_DATA = (one for

indexes as well). I read in a book awhile back about how recovery = might be=20
easier if a user is contained in one tablespace because there is not a=20 export option for tablespace. =20

When I created the tablespaces that I have I didn't put a whole lot of=20 thought into the size, extents, etc. It's been about a year now since = I=20
started this, and now I am finding articles which address issues on = tuning=20
and fragmentation. Needless to say I flunked about 7 of the 12 rules = of=20
SAFE. Now I want to correct earlier mistakes. It would probably be = easier=20
to just call the tablespace something else and cut out some of the = steps I=20
listed, but I like the naming convention I'm using and want to use the = same=20
names.=20

I really appreciate this list and the people like you who respond. = Although

sometimes we get a little 'testy', it is still a great window of the = 'real'=20
world that classes just never seem to get too.=20

Sorry for the book....Laura =20

P.S. Thanks for the 'offline' suggestion...that would be easier.=20

<snip>=20

The information contained in this email is intended for the=20
personal and confidential use of the addressee only. It may=20
also be privileged information. If you are not the intended=20
recipient then you are hereby notified that you have received=20 this document in error and that any review, distribution or=20 copying of this document is strictly prohibited. If you have=20 received this communication in error, please notify Celltech=20 Group immediately on:=20

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'=20

Celltech Group plc=20
216 Bath Road, Slough, SL1 4EN, Berkshire, UK=20

Registered Office as above. Registered in England No. 2159282=20 --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com> =20

--=20
Author: Maser, Donna (SEA)=20
  INET: DonnaMaser_at_chiroscience.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20
San Diego, California        -- Public Internet access / Mailing Lists=20
--------------------------------------------------------------------=20
To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------_=_NextPart_001_01C04F30.E937F560
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: Redo a Tablespace</TITLE>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D054211818-15112000>please, may you send them to me... I'm also = interested=20
in them...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D054211818-15112000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D054211818-15112000>thanks!&nbsp; ;-)</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN =
class=3D054211818-15112000>
<P><FONT face=3DVerdana=20

size=3D2>&nbsp;---------------------------------------</FONT> <BR><FONT =

face=3DVerdana size=3D2>&nbsp;Javier Morales&nbsp; - = javier_at_infojobs.net</FONT>=20
<BR><FONT face=3DVerdana size=3D2>&nbsp;Administraci=F3n Bases de Datos =
Oracle -=20
InfoJobs.net</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Tel. = +34&nbsp;</FONT>=20
<FONT face=3DVerdana size=3D2>902 10 60 90</FONT><FONT face=3DVerdana =
size=3D2>&nbsp;=20
Ext. 2067</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Fax. +34 (93) = 580 56=20
60</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;</FONT>=20
</P><BR></SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Mensaje original-----<BR><B>De:</B> Anandarao, = KrishnamurthyX=20
  [mailto:krishnamurthyx.anandarao_at_intel.com]<BR><B>Enviado el:</B> = mi=E9rcoles 15=20
  de noviembre de 2000 18:01<BR><B>Para:</B> Multiple recipients of = list=20
  ORACLE-L<BR><B>Asunto:</B> RE: Redo a Tablespace<BR><BR></DIV></FONT>   <DIV><FONT color=3D#0000ff face=3D"MS Sans Serif"><SPAN=20   class=3D860375916-15112000>Laura, I would definitely be interested in = it.&nbsp;=20
  Can you forward me those scripts please.</SPAN></FONT></DIV>   <DIV><FONT color=3D#0000ff face=3D"MS Sans Serif"><SPAN=20   class=3D860375916-15112000></SPAN></FONT>&nbsp;</DIV>   <DIV><FONT color=3D#0000ff face=3D"MS Sans Serif"><SPAN=20   class=3D860375916-15112000>Thanks</SPAN></FONT></DIV>   <DIV><FONT color=3D#0000ff face=3D"MS Sans Serif"><SPAN=20   class=3D860375916-15112000>Krish</SPAN></FONT></DIV>   <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">     <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20

    size=3D2>-----Original Message-----<BR><B>From:</B> Burton, Laura = L.=20

    [mailto:BurtonL_at_prismplus.com]<BR><B>Sent:</B> Wednesday, November = 15, 2000=20

    7:11 AM<BR><B>To:</B> Multiple recipients of list=20     ORACLE-L<BR><B>Subject:</B> RE: Redo a = Tablespace<BR><BR></DIV></FONT>

    <P><FONT size=3D2>It comes from an article 'How to Stop = Defragmenting and=20

    Start Living: The Definitive Word on Fragmentation' by B. = Himatsingka and J.=20

    Loaiza from the Oracle Corporation.</FONT></P>     <P><FONT size=3D2>SAFE =3D Simple Algorithm for Fragmentation = Elimination</FONT>=20

    </P>
    <P><FONT size=3D2>I made a script which contain queries for the = rules=20

    referenced in the article.&nbsp; I'll send it to you if you want = it.</FONT>=20

    </P>
    <P><FONT size=3D2>Laura</FONT> </P>
    <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20

    Maser, Donna (SEA) [<A=20
    =
href=3D"mailto:DonnaMaser_at_chiroscience.com">mailto:DonnaMaser_at_chiroscien= ce.com</A>]</FONT>=20

    <BR><FONT size=3D2>Sent: Tuesday, November 14, 2000 2:41 PM</FONT> =
<BR><FONT=20

    size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT=20     size=3D2>Subject: RE: Redo a Tablespace</FONT> </P><BR>     <P><FONT size=3D2>Laura,</FONT> <BR><FONT size=3D2>&nbsp; What are = the 'ofSAFE'=20

    rules that you refer to?</FONT> <BR><FONT size=3D2>- Donna</FONT> =
</P>

    <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>Sent:=20

    Tuesday, November 14, 2000 5:06 AM</FONT> <BR><FONT size=3D2>To: = Multiple=20

    recipients of list ORACLE-L</FONT> </P><BR><BR>     <P><FONT size=3D2>Thank you for responding to my question.&nbsp; = Yes to #4 and=20

    #5.&nbsp; An example of</FONT> <BR><FONT size=3D2>this is creating = a user=20

    REFERENCE to own all the reference (static) tables</FONT> <BR><FONT =

    size=3D2>and have the tables located in one tablespace called = REFERENCE_DATA=20
    (one for</FONT> <BR><FONT size=3D2>indexes as well).&nbsp; I read = in a book=20

    awhile back about how recovery might be</FONT> <BR><FONT = size=3D2>easier if a=20

    user is contained in one tablespace because there is not a</FONT> =
<BR><FONT=20

    size=3D2>export option for tablespace.&nbsp; </FONT></P>     <P><FONT size=3D2>When I created the tablespaces that I have I = didn't put a=20

    whole lot of</FONT> <BR><FONT size=3D2>thought into the size, = extents,=20

    etc.&nbsp; It's been about a year now since I</FONT> <BR><FONT=20     size=3D2>started this, and now I am finding articles which address = issues on=20

    tuning</FONT> <BR><FONT size=3D2>and fragmentation.&nbsp; Needless = to say I=20

    flunked about 7 of the 12 rules of</FONT> <BR><FONT = size=3D2>SAFE.&nbsp; Now I=20

    want to correct earlier mistakes.&nbsp; It would probably be = easier</FONT>=20

    <BR><FONT size=3D2>to just call the tablespace something else and = cut out some=20

    of the steps I</FONT> <BR><FONT size=3D2>listed, but I like the = naming=20

    convention I'm using and want to use the same</FONT> <BR><FONT=20     size=3D2>names.</FONT> </P>
    <P><FONT size=3D2>I really appreciate this list and the people like = you who=20

    respond.&nbsp; Although</FONT> <BR><FONT size=3D2>sometimes we get = a little=20

    'testy', it is still a great window of the 'real'</FONT> <BR><FONT=20     size=3D2>world that classes just never seem to get too.</FONT> </P>     <P><FONT size=3D2>Sorry for the =
book....Laura&nbsp;&nbsp;&nbsp;&nbsp;=20

    </FONT></P>
    <P><FONT size=3D2>P.S.&nbsp; Thanks for the 'offline' = suggestion...that would=20

    be easier. </FONT></P>
    <P><FONT size=3D2>&lt;snip&gt;</FONT> </P><BR><BR>
    <P><FONT size=3D2>The information contained in this email is =
intended for=20

    the</FONT> <BR><FONT size=3D2>personal and confidential use of the = addressee=20

    only. It may</FONT> <BR><FONT size=3D2>also be privileged = information. If you=20

    are not the intended</FONT> <BR><FONT size=3D2>recipient then you = are hereby=20

    notified that you have received</FONT> <BR><FONT size=3D2>this = document in=20

    error and that any review, distribution or</FONT> <BR><FONT = size=3D2>copying=20

    of this document is strictly prohibited. If you have</FONT> =
<BR><FONT=20

    size=3D2>received&nbsp; this communication in error, please notify=20     Celltech</FONT> <BR><FONT size=3D2>Group immediately on:</FONT> =
</P>

    <P><FONT size=3D2>+44 (0)1753 534655, or email = 'is_at_celltech.co.uk'</FONT> </P>

    <P><FONT size=3D2>Celltech Group plc</FONT> <BR><FONT size=3D2>216 = Bath Road,=20

    Slough, SL1 4EN, Berkshire, UK</FONT> </P>     <P><FONT size=3D2>Registered Office as above. Registered in England = No.=20

    2159282</FONT> <BR><FONT size=3D2>-- </FONT><BR><FONT = size=3D2>Please see the=20

    official ORACLE-L FAQ: <A href=3D"http://www.orafaq.com"=20     target=3D_blank>http://www.orafaq.com</A></FONT> <BR><FONT = size=3D2>--=20

    </FONT><BR><FONT size=3D2>Author: Maser, Donna&nbsp; (SEA)</FONT> =
<BR><FONT=20

    size=3D2>&nbsp; INET: DonnaMaser_at_chiroscience.com</FONT> </P>     <P><FONT size=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- = (858)=20

    538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20

    California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists</FONT> <BR><FONT=20     =

size=3D2>---------------------------------------------------------------=
-----</FONT>=20

    <BR><FONT size=3D2>To REMOVE yourself from this mailing list, send = an E-Mail=20

    message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note = EXACT=20
    spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the = message BODY,=20

    include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT = Received on Wed Nov 15 2000 - 12:14:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US