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

From: Hallas John <John.Hallas_at_o2.com>
Date: Wed, 13 Mar 2002 06:33:34 -0800
Message-ID: <F001.004270E6.20020313063334@fatcity.com>

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.

--

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

Author: Hallas John
INET: John.Hallas_at_o2.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