Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction Gradually Slows to a crawl! (please help)

Re: Transaction Gradually Slows to a crawl! (please help)

From: BRob <member29599_at_dbforums.com>
Date: Thu, 29 May 2003 19:23:54 +0000
Message-ID: <2936901.1054236234@dbforums.com> 






I'm wondering about pctfree & pctused values on the table being updated.
Also, it might help to see a snapshot of v$sesstat at various points as
well as v$session_wait for that sid.  Of course, you can always run the
transaction under a level 8 trace to see what is going on.


--
Posted via http://dbforums.com


Received on Thu May 29 2003 - 14:23:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US