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----- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] =================================================== http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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. ========================================================= <!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: [EMAIL PROTECTED] [<A HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</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" <[EMAIL PROTECTED]></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: [EMAIL PROTECTED]</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: [EMAIL PROTECTED]</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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]</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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]</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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).