Oracle Database 12c In‐memory feature for Siebel Reporting and MIS Queries Optimization

Siebel database is optimized all DML are working fine with awesome performance but still we receive complaints when we fetch reports (few columns but fetch huge number of rows). In this article we will explain you the behavior of OLTP database & New Oracle 12c feature of In-memory to optimize Reporting & MIS queries output.

Read More

How to EXTRACT SQL EXECUTION LOGS for specific User

In day to day life Siebel application developer has to deal with scenarios where few functionality or some configuration is making Siebel application latent. Developer has to extract the SQL queries to analyze the problematic functionality. We are sharing structured steps to analyze and extract the SQL queries which are leading to latency in Siebel application

Read More

How to capture the eCommunications logs for specific users in Siebel

Steps to set high level logs of Object manager for specific users to troubleshoot siebel performance issue. It is necessary to capture the high level logs to identify the root cause. It will help us to monitor the application performance by capturing the high level logs. We can identify the SQL quires which are causing latency

Read More

Top New features of Oracle 12c

Oracle 12c has brought smiles to many DBAs and Developers faces. In the series of article i will introduce you to all awesome new features of Oracle 12c. This will do wonder in Capacity planning, Cost Optimization and reduce maintenance cost. 1. Invisible Columns : Now no need to create Custom tables for reference data. With

Read More 32-bit Oracle Database Client Installation Crash on Windows 2008/2012R2/10 64-bit

Date with my bike but i am stuck with very strange installation problem at work. Oracle 12.10.2 database installation on Windows was crashing repeatedly without leaving any hint on the logs. Found the fix for the problem  and leaving a post for your reference. This will be very helpful during  Siebel IP 16 Installation.  

Read More

Parallel Index Creation with Data Pump Import in Oracle DB

Oracle Database Enterprise Edition Version Problem Statement : Indexes are not picking parallel processes while execution of impdp utility SOLUTION Parallelism is used for loading user data, package bodies and for building indexes.   It was noticed that the indexes are not created in parallel, since there is only one worker process executing this task. The

Read More

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

error: Content is protected !!