Database Tuning (MOSC)

MOSC Banner

using OLAP and OLTP together (DB 12c)

edited Mar 14, 2017 5:00AM in Database Tuning (MOSC) 7 commentsAnswered

Hi Experts,

We have a requirement, where we have to use OLAP and OLTP simultaneously. Basically in a single Database. I need to come up with a design or plan for the same.

As per my understanding, we have couple of options. Like, in 12c we have In-Memory option, we can put those OLAP tables into the memory (column wise scan).

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 1590726.1), where it is written that, we can use OLAP and OLTP together in a single DB.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center