Oracle Workspace manager

Hello,  

We have an Application Express application that makes pretty extensive use of workspace manager. My understanding is that it has provided the functionality that we need and saved the developer a fair amount of time. We've had to navigate some of the restrictions imposed by workspace manager but so far those restrictions haven't caused too many headaches.  

The one problem we do have is with performance. There is not much data in these tables (100's possibly 1000's of rows) but we are seeing some pretty dismal performance. It hasn't been a problem identifying what is slow, but we are struggling with how to make it fast and we are very concerned about scalability. I've captured some of the executions plans of resource intensive sql involving version enabled tables and because of the additional objects Oracle creates to enable the versioning capability, those execution plans are all close to 1000 lines making it very difficult to troubleshoot. Not only that but traditional indexing can't be used (although I think workspace manager does provide packages to index version enabled tables).  

Does anybody out there have experience with workspace manager? ...any war stories? ...any links to helpful whitepapers/articles/discussion threads?  

I myself am not very familiar with the functionality yet but I'm quickly being sucked into this and anything that would help me come up to speed quickly would be Greatly appreciated!  

thanks
chris

CONFIDENTIALITY NOTICE:
        This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l