| 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: Space Manager vs. Live ReOrg vs TS ReOrg
I agree with Kevin. I always use hand-made scripts. There is a risk with any 3rd party tool. There are version issues, patches, OS issues, etc. Scripts, on the other hand, can be customized to do the exact amount of work at the exact time you want it done.
Cheers,
Earl
--- TheOracleDBA theoracledba_at_lycos.com On Fri, 15 Jun 2001 09:46:06 Kevin Lange wrote:Received on Mon Jun 18 2001 - 14:26:32 CDT
>I agree with Jesse.
>
>Although Live Reorg would be a great tool, it was extremely COST INTENSIVE.
>I would love to be able to reorg tables with essentially no down time but,
>so far, the cost does not outweigh the benefit.
>
>The nice thing with Space Manager is that it will create your DB scripts for
>you .... and then you can save them and re-use them the next itme those
>tables needed reorg. Even if you no longer have Space Manager. Either
>that, or you can let Space Manager schedule and run them for you in off
>hours.
>
>Of course, my personal favorite is the standard DBA Set of Scripts that you
>run on your scheduled maintenance days. We get what we can done ... and the
>rest, until such time as the on-line reorg software is cost effective, waits
>for the next window.
>
>Kevin
>
>>>Bottom Line:
>>> Space Manager: Cheap, but needs downtime.
>>> Live Reorg: Expensive, but no real downtime.
>>> TS Reorg: Now owned by CA, so I probably won't even look at it. :)
>
>
>-----Original Message-----
>Sent: Friday, June 15, 2001 12:33 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Space Manager is an "offline" tool -- It creates a script that will create a
>new table, populate it, and replace the old table with it, and during this
>time the table is not accessible.
>
>Live Reorg only has a "very short" window where the table is locked -- Quest
>says a few seconds -- while the table is reorg'd. And, while I haven't used
>it, I'm guessing that Live Reorg will not invalidate objects (like triggers)
>that have a dependency on the table being reorg'd, unlike Space Manager's
>brute force method.
>
>Space Manager 3 is OK. v4 should be much nicer once it's out of beta (read:
>more stable). There are enough major bugs in v4 (easy to reorg a 500K index
>to a 500M index) that I'm going to wait for an "official" version. :)
>
>Bottom Line:
> Space Manager: Cheap, but needs downtime.
> Live Reorg: Expensive, but no real downtime.
> TS Reorg: Now owned by CA, so I probably won't even look at it. :)
>
>Good luck!
>Rich Jesse System/Database Administrator
>Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
>-----Original Message-----
>Sent: Friday, June 15, 2001 12:11
>To: Multiple recipients of list ORACLE-L
>
>
>Sun Sparc Solaris 2.6/8
>Oracle DB 8.0.6, 8.0.5
>Oracle Apps 11.0.3
>
>My client and I are currently planning on re-orging some of our database -
>say about 90G out of a 120G database (2 schemas). We've identified 3
>tools and are seeking feedback on the pros/cons of each option.
>
>....
>
>anyone?
>
>Also, can anyone explain the difference between Space Manager and Live
>ReOrg? Both are marketed by Quest, making me wonder what, if anything, is
>the difference...
>
>TIA
>
>J
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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: Kevin Lange
> INET: kgel_at_ppoone.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).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: theoracledba_at_lycos.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).
 |
 |