Oracle 8i Internal Services for Waits, Latches, Locks, and Memory by Steve Adams The unconfirmed error reports are from readers. They have not yet been approved or disproved by the author or editor and represent solely the opinion of the reader. If you have technical questions or error reports, you can send them to booktech@oreilly.com. This page was updated February 20, 2003. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification UNCONFIRMED errors and comments from readers: [53] 1st and 2nd paragraphs; 1st para. According to documentation, DML_LOCKS must be set to *a positive number* or all zero in all instances. DISABLE TABLE LOCKS should be DISABLE TABLE LOCK 2nd para. sub-shared mode table locks normally associated with queries *which have FOR UPDATE [with or without NOWAIT]* Maybe in old old versions of Oracle, subshared TM locks are taken with normal queries?