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

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 27 Jun 2006 12:43:43 -0700
Message-ID: <bf46380606271243w6426ee6cgbfc24a0b6be545d1@mail.gmail.com>

On 6/17/06, eagle fan <eagle.f_at_gmail.com> 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

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

Received on Tue Jun 27 2006 - 14:43:43 CDT