Best practise for data warehousing database creation [message #526296] |
Mon, 10 October 2011 08:13 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Hi All,
Just wanted to create a dataware house database.
Just wanted to know the imporatnt parameter that required for datbware house database creation.
and also suggest me the mount point with size ... for 80 GB of dataware database.
i have create a database for 80gb of dataware db.
I have 16gb of RAM and When looking at the physical processors ...
grep 'physical id' /proc/cpuinfo | sort | uniq | wc -l
2
When looking at the virtual processers ...
grep ^processor /proc/cpuinfo | wc -l
16
Thanks in advance ..
Regards,
|
|
|
|
|
|
Re: Best practise for data warehousing database creation [message #526359 is a reply to message #526312] |
Mon, 10 October 2011 13:05 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Hi Michel,
The ETL jobs are starting the load and making approx of 200 sessions to the database.
And also wanted to know, do you have any recommendation for data warehousing database which is having 80GB of size.
I means. just wanted to know the
1. Recommended parameter in pfile.
2. Mount point allocation for the dbf,ctl and redos ..
Please let me know if you require any more info ..
Regards,
Vimlendu
|
|
|
|
Re: Best practise for data warehousing database creation [message #526363 is a reply to message #526361] |
Mon, 10 October 2011 13:21 |
crussed_sonu
Messages: 51 Registered: July 2007 Location: Delhi
|
Member |
|
|
Hi Swan,
200 sessions should do a fine job to bog down & overload the hardware.
Yes the jobs are doing fine but when i see the load through the top command it is showing very high.
Load Ava. :- 10
Please let me know what should i do in that case and also suggest me for
1. Recommended parameter in pfile.
2. Mount point allocation for the dbf,ctl and redos ..
Please let me know if you require any more info ..
|
|
|
|