Re: Interrupting SQL*Plus queries on NT.

Ctrl+C and File|Cancel do not work, only for queries which have already finished and are spending lots of time spooling the results to the screen. But when a query is still chugging through an access path, the SQL*Plus 8 and 8i client windows just freeze. You can't do anything until the query is done. In this case we have to go to some other desktop and kill the session from an account that has the DBA privilege. I've trained my team to run, read and understand explain plans finally, so the need to do this emergency cancellation has lessened.

Oracle supports tells me it has something to do with Net8 not being non-blocking or something like that. They have no idea when they'll fix it. This means we highly value our old 7.3.2 client disk 'cause it's the only copy of SQL*Plus 3.3 we have left. On the other hand, 3rd party tools seem to have a found a way around the problem (unless they are using the old SQL*Net protocol). I am able to cancel queries in both our SQL-Station and TOAD tools.

<igalt_at_my-deja.com> wrote in message news:893qrs$1ir$1_at_nnrp1.deja.com...
> In article <893ob7$vbs$1_at_nnrp1.deja.com>,
> devdev_at_my-deja.com wrote:
> > I don't know about SQL*Plus 8.05 but for a while I am using a tool
> > called DB Tools that let me stop execution and even kill the session
> > while my queries are running. It works for both Oracle 7 and 8. Check
> it
> > out at http://www.softtretech.com It's a very handy feature.
> >
> > Dev
> >
> > In article <38B542B3.FA63BE94_at_cam.ac.uk>,
> > Charles Jardine <cj10_at_cam.ac.uk> wrote:
> > > I have ttwo versions of SQL*Plus installed on an NT4
> > > workstation - version 3.3.4.0.0 and version 8.0.5.0.0.
> > >
> > > The older version has a facility for interrupting long
> > > running queires. The newer version does not.
> > >
> > > This deficiency is mentioned in the release notes that
> > > came with version 8.0.5.
> > >
> > > My question is, is this fixed in yet newer versions of
> > > SQL*Plus?
> > >
> > > --
> > > Charles Jardine - Computing Service, University of Cambridge
> > > cj10_at_cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >

>

>
>