Rao,
Somewhere on this list there is a fellow from Quest, I've seen his e-mail,
but can't remember who it is. Therefore If I'm leading down a wrong path he can
correct. Anyway, as I understand SharePlex it extracts the transactions from
the archived redo logs to replicate those transactions in another DB. Pretty
slick, but redo logs are an Oracle company secret and therefore subject to
change by them at will with no forewarning to anyone. Where can that leave you,
out in the cold with a corrupt staging area? Very possibly. I know of another
product that is suppose to help you analyze performance problems, but it
connects directly to the SGA bypassing the kernel. Problem, it works as long as
you don't change the starting address of the SGA and/or start paging it out of
memory. Also, I had a demo copy of a product that supposedly re-organized the
internals of the database files, while Oracle was shut down. Problem: A VERY
big warning that if the DB would not restart after they finished, sorry!!
Conclusion, any product that attaches to Oracle or it's files by other than the
normal methods will not make it through the door.
Dick Goulet
____________________Reply Separator____________________
Author: "Rao; Maheswara" <[EMAIL PROTECTED]>
Date: 5/29/2001 9:16 AM
List,
My company is considering Quest - Shareplex.
We are considering to use this in our dataware house. Basically, this will
pull all the transactions from OLTP database and populate staging area in
the dataware house.
Could you please give your experiences and the pros and cons of this
Shareplex product.
Thanks,
Rao
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
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).