Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 (<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.

share|improve this question
add comment

1 Answer 1

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.

share|improve this answer
    
Right now the value for open_cursors is 300. Do you think it has to be increased? –  AJM Apr 23 '11 at 6:56
    
yes, at least 500. –  ik_zelf Apr 23 '11 at 7:37
    
I kept it at 600 now. Still having same issues. Now TEMP tablespace is overflowing when deployments are happening. Is there a way to optimize the TEMP tablespace usage? –  AJM Apr 25 '11 at 3:08
    
how is v$open_cursor ? The extent sizes in temp should be right sized, compared to your most used activities. How big are the segments that are kept in TEMP and how big is the extent size fo the TEMP tablespace? If there is a lot of difference you might want to create a separate temp tablespace for the different tasks. –  ik_zelf Apr 25 '11 at 7:32
    
How do I check the segment size and extent size for TEMP tablespace? –  AJM Apr 26 '11 at 3:00
show 7 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.