Share

Tuning Query without Changing Code by Using SQL Plan Baseline

In day to day application performance monitoring we encountered with Un-optimized SQL consuming significant Database time. Only solution comes to mind is to improve the performance of the SQL by making changes in siebel configuration or Scripting(adding/removing hints, changing the order of joins, removing unnecessary function calls etc.) to get optimized SQL. Sometimes it is

Read More

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

PRINCE2 – An Overview

“PRojects IN Controlled Environments” PRINCE2 is a structured project management method which emphasises dividing projects into manageable and controllable stages. PRINCE2 is principles driven project management framework that can be tailored to suite the size or type of a project. It is based on seven principles, seven themes and seven processes. In this article we will have a

Read More

The Agile Manifesto

Agile software development describes a set of values and principles for software development under which requirements and solutions evolve through the collaborative effort of self-organizing cross-functional teams. It advocates adaptive planning, evolutionary development, early delivery, and continuous improvement, and it encourages rapid and flexible response to change. The Manifesto for Agile Software Development, is a

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 !!