Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: c.genc@interpay.nl (Cihat)
Newsgroups: comp.databases.oracle.server
Subject: Re: after running a query (count, select...like) i don't get the prompt back
Date: 8 Aug 2002 05:24:22 -0700
Organization: http://groups.google.com/
Lines: 42
Message-ID: <75fbbd1e.0208080424.6d98584a@posting.google.com>
References: <75fbbd1e.0208070058.2a11f64c@posting.google.com> <3d511331.1895536@news.jaapwvandijk.myweb.nl> <1a68177.0208072029.5a8f0bd3@posting.google.com>
NNTP-Posting-Host: 193.78.119.38
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028809463 20483 127.0.0.1 (8 Aug 2002 12:24:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 12:24:23 GMT
Xref: easynews comp.databases.oracle.server:157258
X-Received-Date: Thu, 08 Aug 2002 05:21:28 MST (news.easynews.com)

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@hotmail.com (srivenu) wrote in message news:<1a68177.0208072029.5a8f0bd3@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
> /