Database DataWarehousing (MOSC)

MOSC Banner

BI Database and Server

edited Jun 28, 2015 10:52PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi,

We are currently using one server to host one database for BI. We are doing 3 load per day in this database. During the incremental load, it's not possible to generate queries as the data is inconsistent.

We would like to use a second database with active data guard. One database will be used to load data and once the data is fully loaded (1H15 min) we will push to the second database.

My question is: Can we have the two databases on the same server according to the fact that our server uses four 10-core processors and 512GB of memory. The current database uses only 25GB of memory (5%)?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center