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.
Tag Archives: 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
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.
Oracle Database Enterprise Edition Version 126.96.36.199 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