Share

Tag Archives: Siebel Tips & Tricks

Siebel Database optimization – Hidden init.ora parameter “_always_semi_join”

A Siebel Query with a Subquery is very Slow in an Oracle CBO Siebel Environment. The Slow Performance was improved by using the Hidden init.ora parameter “_always_semi_join”   SYMPTOMS Performance problems are observed within the system. A certain query is taking, on average, 7 minutes to be returned. The DBA has run that query exactly

Read More

ReportHTTPSleepTime – Optimize your BI Publisher Reports

This parameter is set at XMLP component and this is the time that user submits the report for report generation and gets a response that report was generated. If threshold is reached and report was not completed, report is going to fail saying that did not receive response from BIP Server.   Modifying the HTTP

Read More

error: Content is protected !!