few perf tuning related questions;

Hi, everybody;

i have a few questions which keep bothering me, so i decided to unload them here - thanks in advance for any feedback.

1. if you use RAID - how do you control your tablespace etc allocation? I mean, the idea is (both in Sybase & Oracle) to put objects on physical devices in a way that helps to avoid access collisions. With RAID i see no way to control this. If your database fits on one RAID box, is not it better to have a number of smaller devices so you can put different things on different spindles explicitly?
2. Locks issues. I have highly interactive web site with some 50 users doing selects on a table at the same time; a few updates/inserts (say up to 5) might be initiated in parallel with those selects. The question is twofold: do i have to explicitly lock the table? Or Oracle takes care of that? Important thing is that updates/inserts never ever collide, meaning they access ALWAYS different rows. They do collide though with selects, but i do not care as to what status is read - old or new. Second question is - if i do not use any explicit locking, is there a possibility of deadlocks because of the internal locking in the above scenario? And, also, what kind of performance would you expect on SunUltra2 with 4 cpu and some 256 RAM? The table accessed has some 15,000 rows. What i am seeng is that there are a lot of processes doing select running forever - just hanging.

Thanks a lot - sorry for this long post.

-- 


---------------------------------------------------------------------

                  he who hesitates is probably right

http://www.webvalue.com      Vlad Stavitsky          vlads_at_lvalue.com


---------------------------------------------------------------------