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><SPAN=20
class=3D054211818-15112000>please, may you send them to me... I'm also = interested=20
in them...</DIV>
<DIV><SPAN=20
class=3D054211818-15112000> </DIV>
<DIV><SPAN=20
class=3D054211818-15112000>thanks!  ;-)</DIV>
<DIV>
<FONT face=3DVerdana=20

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

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

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

[mailto:BurtonL_at_prismplus.com] Sent: Wednesday, November = 15, 2000=20

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

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. SAFE =3D Simple Algorithm for Fragmentation = Elimination=20

I made a script which contain queries for the = rules=20

referenced in the article.  I'll send it to you if you want = it.=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>]=20

Sent: Tuesday, November 14, 2000 2:41 PM =
 <FONT=20

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

rules that you refer to? - Donna =


-----Original Message----- Sent:=20

Tuesday, November 14, 2000 5:06 AM To: = Multiple=20

recipients of list ORACLE-L Thank you for responding to my question.  = Yes to #4 and=20

#5.  An example of this is creating = a user=20

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

size=3D2>and have the tables located in one tablespace called = REFERENCE_DATA=20
(one for indexes as well).  I read = in a book=20

awhile back about how recovery might be easier if a=20

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

size=3D2>export option for tablespace.  When I created the tablespaces that I have I = didn't put a=20

whole lot of thought into the size, = extents,=20

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

tuning and fragmentation.  Needless = to say I=20

flunked about 7 of the 12 rules of SAFE.  Now I=20

want to correct earlier mistakes.  It would probably be = easier=20

to just call the tablespace something else and = cut out some=20

of the steps I listed, but I like the = naming=20

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

respond.  Although sometimes we get = a little=20

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

P.S.  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 personal and confidential use of the = addressee=20

only. It may also be privileged = information. If you=20

are not the intended recipient then you = are hereby=20

notified that you have received this = document in=20

error and that any review, distribution or copying=20

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

size=3D2>received  this communication in error, please notify=20 Celltech Group immediately on: =


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

Celltech Group plc 216 = Bath Road,=20

Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England = No.=20

2159282 -- Please see the=20

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

Author: Maser, Donna  (SEA) =
 <FONT=20

size=3D2>  INET: DonnaMaser_at_chiroscience.com Fat City Network Services    -- = (858)=20

538-5051  FAX: (858) 538-5051 San = Diego,=20

California        -- Public = Internet=20

access / Mailing Lists <FONT=20 =

size=3D2>---------------------------------------------------------------=

-----=20

To REMOVE yourself from this mailing list, send = an E-Mail=20

message to: ListGuru_at_fatcity.com (note = EXACT=20
spelling of 'ListGuru') and in the = message BODY,=20

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