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: How to get the SQL query of a blocking sid during a lock contention

Re: How to get the SQL query of a blocking sid during a lock contention

From: <bchorng_at_yahoo.com>
Date: 14 Jul 2005 12:04:04 -0700
Message-ID: <1121367844.788942.23930@g47g2000cwa.googlegroups.com> 





So you want to do a query across several  database instances for
a lock report. It certainly won't be 1 SQL session. You can use shell
script to connect each DB separately to generate report output then
grep,sort or aggregate anyway you want. It is not as easy as in SQL
but it should work from 1 single script.
Received on Thu Jul 14 2005 - 14:04:04 CDT












Original text of this message













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