Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsxfer.visi.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: High IO Waiting... Date: Tue, 06 May 2003 06:40:56 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <45febvglh7t9mociqtaf1c0lir4uajdlp5@4ax.com> Reply-To: postbus@sybrandb.demon.nl References: <78cf0572.0305051254.5738d9f8@posting.google.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 14 Xref: core-easynews comp.databases.oracle.server:185359 X-Received-Date: Mon, 05 May 2003 21:40:10 MST (news.easynews.com) On 5 May 2003 13:54:14 -0700, shoad316@hotmail.com (Dave) wrote: >If you have any other suggestions it would be greatly appreciated. Check out from the v$ tables WHAT it is waiting for, and tune from there. The other approach doesn't make sense, as it never won't identify bottlenecks Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address