Let me guess - pread64() and random
latch back off ?
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Connor McDonald wrote in message <3AD19143.1755_at_yahoo.com>...
>
>As further reinforcement you can see a 'bug' on Metalink where a large
>Oracle user (who I happened to be working for at the time) got massively
>hit by "performance problems" when upgrading to 8i - and NONE of the
>explain plans had changed...the reason was due to a change in the calls
>made to the underlying disks (in a veritas file system) which brought
>the database to a standstill on internal locking issues (a variant on
>inode locks)...the only fix was to not use vxfs file systems (by moving
>to quick io)...
>
>Another reason I prefer to use raw on locally managed tspaces..
>
>Cheers
>Connor
Received on Mon Apr 09 2001 - 15:03:42 CDT
