Hi all,
I am new Oracle DBA in industry, not much experience in Database. I have some confusion. May be these are stupid question but these revolving in my mind. please help resolve these.
1) When new projects comes, i am confuse about required RAM/cache and CPU. although i can calculate capacity of hard disk. for example - my Application user tell we have total TPS (transaction per second) is 1000 (200 update, 300 delete, 200 insert and 100 selects), so in that case how can i calculate hardware capacity and how can i answer to them.
2) This point is revers of first question. Suppose a database running and everything is running fine. i want to calculate TPS (transaction per second) . means how much select/update/insert/delete running in second. how to calculate or identified TPS.
thanks in advance .....
Reg,
Harsh