| 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:Your views on Quest - Shareplex
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" <Maheswara.Rao_at_Sungardp3.com> 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: Maheswara.Rao_at_Sungardp3.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).
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). Received on Tue May 29 2001 - 12:11:54 CDT
 |
 |