Share

Category Archives: Siebel Tips & Tricks

Oracle Database 12c Feature: Multitenant Database

“Sometimes there was a Situation where you have to create two different schema in the same databases,but both with the same name.” A typical example is in this case of SIEBEL applications which have a specific schema name – SIEBEL, So if you want to install two SIEBEL applications in the same database, we always

Read More

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

error: Content is protected !!