Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to "Defragment" Tablespaces ?
Jonathan Lewis wrote:
>
> 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
I'll dig up the Metalink history (once I find it)...
Cheers
Connor
-- =========================================== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue"Received on Tue Apr 10 2001 - 06:56:27 CDT