Oracle-L: Re:RE: RE: Time for a reorg?

From: <dgoulet_at_vicr.com>
Date: Wed, 13 Mar 2002 08:38:30 -0800
Message-ID: <F001.004275E8.20020313083830@fatcity.com>

Your welcome. The problem with these changing paradigms is that there are folks, like Mark, out there creating tools to make our lives easier but at the same time the shift makes theirs more difficult. It follows my theory on the balance of life. If you change the amount of effort required to do one task the amount effort to accomplish a different one must increase. In this case we win, Mark looses. :-)

Dick Goulet

____________________Reply Separator____________________
Author: Hallas John <John.Hallas_at_o2.com>
Date:       3/13/2002 6:33 AM

Thanks Dick,
I think what you are saying ties in exactly with my post on the matter

John

-----Original Message-----

Sent: 13 March 2002 13:53
To: Multiple recipients of list ORACLE-L

Yes, I think databases still get reorg'd today. It is just that our definition
of a reorg and a database I think are changing. In the past if you said you were going to reorg a database that a full export, possibly a rebuild and an import. Way too time consuming for today's 24x7 requirements. Today I think we
reorg at the object or schema level, not the entire instance. BTW, I think our
definition of a database is also changing from the entire instance to a single
schema.

Dick Goulet

____________________Reply Separator____________________
Author: "Mark Leith" <mark_at_cool-tools.co.uk>
Date:       3/13/2002 3:38 AM

Wow - does nobody reorg databases anymore? ;P

Thanks for all your help guys.. I'll take that as a cue to put some time aside..;0P

-----Original Message-----

Sent: 12 March 2002 11:43
To: Multiple recipients of list ORACLE-L

Does anyone have any "set limits" to know when it would be time for object reorgs?

Firstly, I *know* that the reorg issue is viciously guarded on two sides - those that say reorgs should be done, and those that argue that they are unnecessary in todays environments. I agree with both sides ;P And don't intend this to break out the debate for the nth time..

What I am really after is guidelines from people to their own views of when a reorg is deemed necessary. Things such as percentage of rows that are chained/migrated, or number of extents, or number of extents as a percentage of maxextents or whatever..

Anybody come up with a really cool script that evaluates this - instead of me re-inventing the wheel? I could do this - I just don't really have the time at the moment - so your input is greatly appreciated!

Thanks in advance

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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: Mark Leith
INET: mark_at_cool-tools.co.uk

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

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

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: RE: Time for a reorg?</TITLE>
</HEAD>
<BODY>

Thanks Dick,
 I think what you are saying ties in exactly with my post on the matter

John

-----Original Message----- From: dgoulet_at_vicr.com [<A HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]

<BR><FONT SIZE=2>Sent: 13 March 2002 13:53</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re:RE: Time for a reorg?</FONT>
</P>
<BR>

Yes, I think databases still get reorg'd today.  It is just that our definition
 of a reorg and a database I think are changing.  In the past if you said you
 were going to reorg a database that a full export, possibly a rebuild and an
 import.  Way too time consuming for today's 24x7 requirements.  Today I think we reorg at the object or schema level, not the entire instance.  BTW, I think our
 definition of a database is also changing from the entire instance to a single
 schema.

Dick Goulet

<P><FONT SIZE=2>____________________Reply Separator____________________</FONT>

Author: "Mark Leith" <mark_at_cool-tools.co.uk>
 Date:       3/13/2002 3:38 AM

Wow - does nobody reorg databases anymore? ;P

Thanks for all your help guys.. I'll take that as a cue to put some time
 aside..;0P

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: 12 March 2002 11:43</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

Does anyone have any "set limits" to know when it would be time for object
 reorgs?

Firstly, I *know* that the reorg issue is viciously guarded on two sides -
 those that say reorgs should be done, and those that argue that they are
 unnecessary in todays environments. I agree with both sides ;P And don't
 intend this to break out the debate for the nth time..

What I am really after is guidelines from people to their own views of when
 a reorg is deemed necessary. Things such as percentage of rows that are
 chained/migrated, or number of extents, or number of extents as a percentage
 of maxextents or whatever..

Anybody come up with a really cool script that evaluates this - instead of
 me re-inventing the wheel? I could do this - I just don't really have the
 time at the moment - so your input is greatly appreciated!

Thanks in advance

Mark

<P><FONT SIZE=2>===================================================</FONT>

Mark
Leith             | T: +44 (0)1905 330 281
  Sales & Marketing      | F: +44 (0)870 127 5283
  Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk

<BR><FONT SIZE=2>===================================================</FONT>

<A HREF="http://www.cool-tools.co.uk"
TARGET="_blank">http://www.cool-tools.co.uk</A>        Maximising throughput & performance

--
 Please see the official ORACLE-L FAQ: <A HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Author: Mark Leith</FONT>
<BR><FONT SIZE=2>&nbsp; INET: mark_at_cool-tools.co.uk</FONT>
</P>

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California       
-- Public Internet access / Mailing Lists
 <FONT

SIZE=2>--------------------------------------------------------------------</FON

T>
 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: <A HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Mark Leith</FONT>
<BR><FONT SIZE=2>&nbsp; INET: mark_at_cool-tools.co.uk</FONT>
</P>

SIZE=2>--------------------------------------------------------------------</FON

<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2>&nbsp; INET: dgoulet_at_vicr.com</FONT>
</P>

SIZE=2>--------------------------------------------------------------------</FON

<CODE>

=========================================================<BR>

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

=========================================================<BR>
</FONT></CODE>

</BODY>
</HTML>
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.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