Re: now what??
- From: darrell@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Aug 2004 08:46:16 -0700 (PDT)
Robyn,
I'd be interested in knowing where the sysadmins are
seeing drive queueing. If they're seeing it in Glance,
I don't think this is as much file size / layout as
potentially an overworked path(s) between the HP box
and the EMC chassis. If it's on EMC monitoring tools,
that's a different factor, but to my knowledge, Glance
can't see beyond the OS and local hardware.
How big are the files they want you to break up?
If there is true disk queuing, then I'd ask what they
are doing to move 'hot' file systems to hypers on
lesser utilized disks. (EMC has tools to do this on
the fly, I'd inquire to see if that is available in
your environment.)
Also, given the increase in CPU count and speed, I
wonder if you might not benefit from system statistics
(if you're not already gathering them). Take a look at
Jonathon Lewis' (very informative) paper at:
http://www.oracle.com/technology/pub/articles/lewis_cbo.html
I'd also push forward with that 9.2.0.5 patch. You've
already seen that it can make a difference as well, I'd
be concerned that any work (tuning) you do now would
not behave the same after patching.
Yes, yes, yes to locally managed tablespaces. I don't
have any handy evidence of performance improvement, but
they are definitely easier administratively.
One more thought on the large files, if there is a lot
of concurrent use, you may benefit from multiple
smaller files. If you're on filesystems and not raw
devices, HP (and probably others) has some factor with
single use locking from the OS. I think this also is
in a Jonathon Lewis paper out there somewhere.
Good luck!
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
