Default SELECT locking

This is a request for some "warm-and-fuzzy" reassurance information:

I have written a number of SELECTs into PHP3-based web pages. These SELECTs return statistics about the information in our database, how many records, etc., etc.. Now that I've done all this work, it occurred to me (belatedly) that there might be some locking issues if the database was heavily used and one of these SELECTS hit a busy table.

My question(s): I believe Oracle's default behavior is to have NO read locks when selecting data, is this correct? This would mean no locking problems, right? Is there a way to verify this in actual usage?

Thanks in advance -

Tom Williamson Received on Tue Sep 14 1999 - 12:16:30 CDT