Re: Can't find the sql text from v$sql via the hash value

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: eagle.f@xxxxxxxxx
  • Date: Tue, 27 Jun 2006 12:43:43 -0700

On 6/17/06, eagle fan <eagle.f@xxxxxxxxx> wrote:



The hang just last several seconds, after several seconds, the application
client cancel the operation and mark the database as unavaliable.

Then we took the application clients back and connected to database again,
but after a while ,the same problem happened again.



What you describe could be a number of things.

Network problems, enqueues, runaway query (think cartesian) killing the
database, etc.

During one of the 'hangs', are you able to use sqlplus to login remotely as
SYSTEM?

How about locally?

Does tnsping show that the listener is working?

Does the alert.log show any anomolies?


-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: