Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't find the sql text from v$sql via the hash value
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-lReceived on Tue Jun 27 2006 - 14:43:43 CDT
![]() |
![]() |