Re: Space Manager vs. Live ReOrg vs TS ReOrg

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: jweinshe_at_concentric.net
>
> 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).
>
>

-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
jhawkins_at_memc.com (work)
jhawkins_at_primary.net (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  INET: jhawkins_at_primary.net

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).