Basic question?

[Anonymous]

I Have 16GB Ram

in oracle data base I have size of the data is 50 gb  then how much time it will take to load the data ?

how much ram it will consume ?

Note: No user is hitting to the database . I am the person who is connecting to DB

[andrespa · Accepted solution]

Hi, it depends on the complexity of the queries and how the data model is build but I would say that it will take not less than 5-6 hours.

But again, this is a rough aprox, cause it depends of a lot of factors (like your I/O bandwith if you're loading from a server)

Hope it helps,

Andrés

[Anonymous]

The answer is the infamous "it all depends.....".

Generally to load the data the bottleneck will be the constraints of extracting it from your database and transferring it where the QV load process is running.  Without a good understanding of your infrastructure it is impossible to even guess.  But for your data volumes an incremental load would recommended.

For RAM here is some guesswork with assumptions :

• Half of your 50 Gbytes is indices which leave 25 Gbytes
• Only 40% percent of you data will actually be needed which leaves 10 Gbytes
• QlikView data de-duping [aka compression] will reduce it by 90% when loaded into memory which gives 1 Gbyte RAM consumed

This really is guessing given the limited info given so I make no promises at all that is even vaguely correct.

[Anonymous]

Yes I agree

can u give some size of ram like in avg cases

I have the I/o are meadium range parameters

[andrespa]

I agree with Bill. It depends, but maybe what he says make sense.

Cheers,

Andrés

[Anonymous]

... and then you would have to add on 10% to the RAM for each user that access it via AccessPoint.