Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2 Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At the client side it is very slow to open and refresh Design center and control center and table/dimension/cube mapping deployments made to a remote database are also slow. Several users (&lt;30) over the network are accessing OWB remote repository and make deployments to remote Oracle 10.2 DB using locally installed Design Center and Control Center.

Please suggest any performance optimization measures at Oracle DB level and at OWB level for the administrator.
Make sure that open_cursors is sufficient. What is the current value for open_cursors and session_cached_cursors? They should be high, start with 500.