You caught me at the perfect time. We are new customers of Quest's
LiveReorg for our 350GB SAP Oracle database. We run on AIX 4.3.3 and Oracle
8.0.4.3. We have an extremely transactional database (200,000+ transactions
per day), so a LiveReorg is really a task. I just reorg'd a 33GB table with
5 indexes in about 7 1/2 hours using the FastCopy feature. This was done
right in the middle of the working day, and we saw about a 20-30% CPU usage
footprint. It still was not enough to where users were complaining about
the system. After several tweaking runs, it ran fine yesterday and we are
now running on the newly reorg'd table. Myself and management are extremely
pleased.
As for Space Manager and LiveReorg, think of it this way:
LiveReorg = Space Manager + SharePlex
The GUI is based on Space Manager, but the technology behind being able to
mine archive logs for transactions posted against the table being reorg'd is
in SharePlex. All three are separately sold products.
Hope that helps.
Jim
> 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: Jay Weinshenker
> 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).
>
>
--
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO 633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Hawkins
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).
