What do you like best about SharePlex?
In my experience, Shareplex is fast, flexible, easy to install and configure, and easy to maintain. From my perspective, the conversion from Streams to Shareplex was amazingly simple and went very well. My feeling is that the overall experience has been very positive.
Streams Migration - I've worked with Streams for over 7 years and spent probably more time than I should have evaluating four different replacement products. With Shareplex, I found migration from Streams to be very simple. It was just plain easy.
Speed - In my own testing, Shareplex was significantly faster than three competing products that were evaluated utilizing real workloads.
Ease of Use - In my experience, installation couldn't be much simpler. Also, configuring tables for replication is also very easy for the roughly 2,000 tables configured in our environment.
Monitoring - We monitor Shareplex for errors using features built into the product. We monitor latency utilizing a custom heartbeat table to model the approach we had utilized with Streams. Both were very easy to configure based on my own experience.
RAC/Cluster - Our environment consists of several Exadata clusters. Shareplex seemed to integrate well with Oracle Clusterware and seems to support the built-in HA failover capability through the usage of application VIP's well.
Flexibility - Based on my own experience using and/or evaluating other products, Shareplex is among the easiest to configure when it comes to basic functionality such as: replicating to a different target table or schema name, excluding certain DML such as inserts, deletes, updates, etc.
Cruise Control - Based on my usage of the product, far less time will be required to keep it running smoothly compared to Streams. The way the product is configured out of the box to automatically retry operations that fail (maybe due to deadlock, etc.) and the type of operations that are excluded by default (but can be easily enabled), will require minimal human intervention. This is a big plus based on my own experience.
Conclusion - My opinion, as the primary DBA who evaluated various products, architected the Shareplex migration, and deployed the same, is that we made the right choice. I'm am personally very satisfied with our decision to choose Shareplex as our Streams replacement.
Review collected by and hosted on G2.com.
What do you dislike about SharePlex?
My feeling is the enterprise monitoring dashboard (GUI) could be improved to match the experience with the product in general. I'd like to see this portion of the overall Shareplex offering be simpler to install, more lightweight, and easier to configure.
If I had to nit-pick, my personal opinion is that a few key areas could be explained more clearly/thoroughly in the documentation. This deals mostly with instantiation of new tables for replication. Review collected by and hosted on G2.com.