Originally posted by pareshg
Thanks Pipo .

2. I wont worry about instance recovery which Oracle is doing.
But One of my interview, that buddy asked me that question about Instance Rec. .Also if suppose Power failure occured,then also it will do Inst. Rec.How it is come to know that Inst. Rec. is requied?????
Oracle uses something called SCN (System Change Number) and would record it on its control file. So when you perform a crash recovery, oracle would basically use the SCN to apply all the redo logs inorder to recover from the crash. more


3. I know the Installation of Oracle on Unix. but how will I determine size of database , size of db block , no of datafiles, size of all files etc....
Normally it depends on the type of operation you would be doing on the database. For OLTP it would be from 2-8K for DSS it would be 16K and etc...


4.In our DB , there should be diff. tablespace for data, index , rollback segs, temp, tools...this is to follow OFA, and to reduce I/O contention on files. But what r adv. of this OFA other than to reduce I/O contention??
Paresh
I/O contention would drastically reduce your database performance. Appart from having multiple tablespaces, you should also remember to spread them across multiple disks. Otherwise you would get into hot spots...