| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: RE: Time for a reorg?
I agree with this! One of our biggest challenges is trying to stay ahead of
the game! Luckily we don't actually develop any of this software, so the
challenge is not ours to partake in ;P What we do have to try and do is pick
and choose those products that are ahead of the game, and we feel our
product set meets those challenges.. Especially Ari's PocketDBA/Admin tools,
and SQLExpert - which is streets ahead of *any* other SQL Optimisation tool
in the market - including Oracle's own..
I have to say though - even though I'm a "sales critter" - I wouldn't change my job for the world! I have thought long and hard about becoming a fully fledged DBA, and have nearly taken that step, but - with my job as is, I am not only challenged daily by keeping on top of the database market (focusing on Oracle, but including SQLServer, Sybase and DB2) but also challenged by trying to convince DBAs (*THE* most awkward bunch of people in the *world* to sell to! ;P) that these products can actually be good for them!
I loose on a daily basis - some propeller heads you just *can't* convince, but then we win a hell of a lot as well - it keeps me on my toes, and keeps my family fed and watered comfortably thank you very much.. ;) Plus, part running a company does have it's own very distinct benefits, and hell I get to play with all of these really "Cool Tools"! ;P
<GD&RLH>
-----Original Message-----
dgoulet_at_vicr.com
Sent: 13 March 2002 16:38
To: Multiple recipients of list ORACLE-L
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 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: 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 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). ========================================================= 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. =========================================================Received on Thu Mar 14 2002 - 09:03:33 CST
<!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>
<P><FONT SIZE=2>Thanks Dick,</FONT>
<BR><FONT SIZE=2>I think what you are saying ties in exactly with my post on
the matter </FONT>
</P>
<P><FONT SIZE=2>John</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: dgoulet_at_vicr.com [<A
HREF="mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]</FONT>
<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>
<P><FONT SIZE=2>Yes, I think databases still get reorg'd today. It is
just that our definition</FONT>
<BR><FONT SIZE=2>of a reorg and a database I think are changing. In
the past if you said you</FONT>
<BR><FONT SIZE=2>were going to reorg a database that a full export, possibly
a rebuild and an</FONT>
<BR><FONT SIZE=2>import. Way too time consuming for today's 24x7
requirements. Today I think we</FONT>
<BR><FONT SIZE=2>reorg at the object or schema level, not the entire
instance. BTW, I think our</FONT>
<BR><FONT SIZE=2>definition of a database is also changing from the entire
instance to a single</FONT>
<BR><FONT SIZE=2>schema.</FONT>
</P>
<P><FONT SIZE=2>Dick Goulet</FONT>
</P>
<P><FONT SIZE=2>____________________Reply
Separator____________________</FONT>
<BR><FONT SIZE=2>Author: "Mark Leith"
<mark_at_cool-tools.co.uk></FONT>
<BR><FONT SIZE=2>Date: 3/13/2002 3:38
AM</FONT>
</P>
<P><FONT SIZE=2>Wow - does nobody reorg databases anymore? ;P</FONT>
</P>
<P><FONT SIZE=2>Thanks for all your help guys.. I'll take that as a cue to
put some time</FONT>
<BR><FONT SIZE=2>aside..;0P</FONT>
</P>
<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>
<P><FONT SIZE=2>Does anyone have any "set limits" to know when it
would be time for object</FONT>
<BR><FONT SIZE=2>reorgs?</FONT>
</P>
<P><FONT SIZE=2>Firstly, I *know* that the reorg issue is viciously guarded
on two sides -</FONT>
<BR><FONT SIZE=2>those that say reorgs should be done, and those that argue
that they are</FONT>
<BR><FONT SIZE=2>unnecessary in todays environments. I agree with both sides
;P And don't</FONT>
<BR><FONT SIZE=2>intend this to break out the debate for the nth
time..</FONT>
</P>
<P><FONT SIZE=2>What I am really after is guidelines from people to their
own views of when</FONT>
<BR><FONT SIZE=2>a reorg is deemed necessary. Things such as percentage of
rows that are</FONT>
<BR><FONT SIZE=2>chained/migrated, or number of extents, or number of
extents as a percentage</FONT>
<BR><FONT SIZE=2>of maxextents or whatever..</FONT>
</P>
<P><FONT SIZE=2>Anybody come up with a really cool script that evaluates
this - instead of</FONT>
<BR><FONT SIZE=2>me re-inventing the wheel? I could do this - I just don't
really have the</FONT>
<BR><FONT SIZE=2>time at the moment - so your input is greatly
appreciated!</FONT>
</P>
<P><FONT SIZE=2>Thanks in advance</FONT>
</P>
<P><FONT SIZE=2>Mark</FONT>
</P>
<P><FONT SIZE=2>===================================================</FONT>
<BR><FONT SIZE=2> Mark
Leith   ; | T: +44 (0)1905 330 281</FONT>
<BR><FONT SIZE=2> Sales & Marketing |
F: +44 (0)870 127 5283</FONT>
<BR><FONT SIZE=2> Cool Tools UK Ltd | E:
mark_at_cool-tools.co.uk</FONT>
<BR><FONT SIZE=2>===================================================</FONT>
<BR><FONT
SIZE=2> <A HREF="http://www.cool-tools.co.uk" TARGET="_blank">http://www.cool-tools.co.uk</A></FONT>
<BR><FONT SIZE=2> Maximising throughput
& performance</FONT>
</P>
<BR>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Author: Mark Leith</FONT>
<BR><FONT SIZE=2> INET: mark_at_cool-tools.co.uk</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego,
California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT
SIZE=2>--------------------------------------------------------------------< /FON T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Mark Leith</FONT>
<BR><FONT SIZE=2> INET: mark_at_cool-tools.co.uk</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego,
California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT
SIZE=2>--------------------------------------------------------------------< /FON T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A
HREF="http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2> INET: dgoulet_at_vicr.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego,
California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT
SIZE=2>--------------------------------------------------------------------< /FON T>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of
'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB
ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed
from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like
subscribing).</FONT>
</P>
<CODE><FONT SIZE=3><BR>
<BR>
=========================================================<BR> This electronic message contains information from the mmO2 plc Group <BR> which may be privileged or confidential. The information is intended to be
<BR>
for the use of the individual(s) or entity named above. If you are not the
<BR>
intended recipient be aware that any disclosure, copying, distribution or
<BR>
use of the contents of this information is prohibited. If you have received
<BR>
this electronic message in error, please notify us by telephone or email
<BR>
(to the numbers or address above) immediately.<BR> =========================================================<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 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 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).
 |
 |