Re: after running a query (count, select...like) i don't get the prompt back

Hi,

Thanks all....i've solved the problem is an old fashion windows way. I stopped and started the whole database and it seems to be working fine. But is still don't know what the actual problem was.

Thanks,
Cihat

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0208072029.5a8f0bd3_at_posting.google.com>...
> Can you send the output after running this SQL on your server
>
> col name form a35
> col value form a20
> set head off
> set feedback off
> select ' '||upper(name)name,value
> from v$parameter
> where name = 'timed_statistics'
> /
> set feedback on
> set head on
> col event form a13 trunc head "Event| Waiting For"
> col p2 form 99999 trunc
> col wait_time form 999 trunc head "Last|Wait|Time"
> col program form a13 trunc
> col command form a7 trunc head "Command"
> col username form a8 trunc
> col state form a10
> col sid form 999 trunc
> col last_call_et form 9999999 trunc head "Last Call|In Secs"
> select a.sid,username,b.program program,
> decode(command,0,'None',2,'Insert',3,'Select',
> 6,'Update',7,'Delete',10,'Drop Index',12,'Drop Table',
> 45,'Rollback',47,'PL/SQL',command) command,
> last_call_et,
> event,p1,p2,state,wait_time
> from v$session_wait a,V$session b
> where b.sid=a.sid
> order by 1
> /
Received on Thu Aug 08 2002 - 07:24:22 CDT