RE: DBWR pegged out

  • From: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • To: <dag@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 8 Mar 2011 11:18:07 -0500

These are writes to temp. Is this a new problem or old? Are all these writes
for the same query? Find the queries that are writing to temp. I would try
to avoid the writes to temp in the first place. Sometimes an index is all
that's needed.



--
http://www.freelists.org/webpage/oracle-l


Other related posts: