Points to Consider while creating a Database for DSS??

[ronnie]

Hi,

We need to create a database primarily for a DSS.

Where do I get information on various issues such as sizing of DB block size, SGA , extent sizes etc etc for a database holding a date warehouse .

Thanks

[Sureshy]

http://otn.oracle.com/docs/products/..._eval.htm#2727

[ronnie]

Originally posted by Sureshy
http://otn.oracle.com/docs/products/..._eval.htm#2727

Thanks for the link sureshy.
But it doesnt talk about database configuration/setup for a DSS.

[sreddy]

http://docs.oracle.com/cd_database_g...ogical.htm#745

http://docs.oracle.com/cd_database_g...ysical.htm#745

[yoda]

Originally posted by ronnie


But it doesnt talk about database configuration/setup for a DSS.

Anyone? Anyone?
Economics Teacher (Ben Stein), Ferris Bueller's Day Off

Please point me to the exact place in the documentation I am looking for. I need somebody to hold my hand and do my work for me!

Hard work never killed anybody, but why take a chance?
Charlie McCarthy (1903 - 1978), (Edgar Bergen)



[Edited by yoda on 07-17-2002 at 12:54 PM]

[sreddy]

Originally posted by yoda
Anybody, anybody?

Please point me to the exact place in the documentation I am looking for. I need somebody to hold my hand and do my work for me!

Thats what I always wonder. Why don't new born DBAs think, Oracle Documentation is the best resource to start with...

How come I know that there is necessary info about data warehousing? I'm pretty confidant that Oracle will be having a manual for DSS support and I have searched for it before when I was in need of it...

[pando]

dba or dbbs?

[marist89]

Originally posted by pando
dbbs

I love it!

my $dbbs = q{Database Baby Sitter};

[Edited by marist89 on 07-17-2002 at 01:31 PM]

[ronnie]

Thanks a lot Guys.

I'll try to learn to be a DBA and not a DBSS as you all have said.


All I was looking for was for something outside of the oracle documentation .... some white paper or technical article or something which talks about setting up the various parameters for a DSS and/or block sizes and various other issues relating to a DSS.

Also I posted the question after looking at the documentation first. It has information but in bits n pieces and scatterred everywhere.

If everyone could read the documentation and understand each and every topic from it then why are Books for. There should be no books available in the market and if they are nobody should buy them because the information is already there in the Oracle manuals.


Correct me if I am wrong.

Thanks for all the Help and motivation you guys provide on this forum.

[pando]

do you think we all learn by asking others in a forum?

and yes I have around 15 Oracle books, I read them and I read documentations. Documentations are books FYI, if you can afford $4000 to buy them