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: Oracle Transactions at Max Utilization

Re: Oracle Transactions at Max Utilization

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Thu, 14 Feb 2002 13:53:08 +0100
Message-ID: <a4gbvi$s5r$1@news.mch.sbs.de> 





Maybe it's the known oracle bug, which increments this counter to the limit
if db_links are used in your database.



Your may use this query instead:


select count(*) max_concurrent_tx from x$ktcxb where ktcxbflg != 0;



Regards


Stephan
Received on Thu Feb 14 2002 - 06:53:08 CST












Original text of this message













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