OBIEE 12c : Any place in RPD where we can assign/mark a physical …
Mar 9, 2020 · Hi Gurus, I would like to know if there is any place in OBIEE RPD where we can mention (assign/designate) a physical data source as OLTP ?
OLTP indexes vs ANALYTIC indexes — oracle-mosc
Hi , In 11g database , is there a method or tip to detect OLTP indexes and Analytic indexes (each list separately). Best regards. GD.
using OLAP and OLTP together (DB 12c) — oracle-mosc
Secondly, we can prepare two separate databases for OLAP and OLTP or two separate schemas within the same DB. Does that make any sense..? I have read one Metalink Doc (Doc ID …
How to setup Oracle OLAP Catalog in 19c — oracle-mosc
Aug 22, 2022 · I have created a new 19c database, when I select from dba_registry I do not see the OLAP components listed.
Is OBIEE all in one for ETL, Cubes Development n BI Reporting?
Oct 10, 2017 · OBIEE fetches data from different sources like Flat Files, Database (OLTP) or Essbase Cubes (MOLAP). You can do Canned or ADHOC reporting in the OBIEE, you can do …
What is the use of the table ENI_OLTP_ITEM_STAR — oracle-mosc
Oracle Applications 12.2.10 Related to Inventory: Could you tell about the purpose of the table ENI_OLTP_ITEM_STAR.
sga and pga size for 12c — oracle-mosc
May 28, 2014 · The transaction is 70%OLTP and 30%OLAP, please give advice for the SGA and PGA size for this case. Also give some advice for memory allocation of in-memory option.
Removing olap from CDB and all PDBs from default 19c EE …
Apr 30, 2021 · The Oracle database installation guide for Linux has a section for removing options that are installed by default on the Enterprise Edition database, one of them being olap.
CPU allocation between OLTP vs Warehouse DB — oracle-mosc
Aug 23, 2023 · Oracle Database Enterprise Edition v19.19. We currently have a single DB with schemas for transactional and warehouse. This was primarily done to save on costs.
i am getting the following error installing Oracle 19c
Aug 25, 2021 · Error in invoking target 'clean sdo_on rac_off dnfs_off' of makefile '/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/lib/ins_rdbms.mk'.