Re: oracle9i performance on Windows Server

"Paul Brewer" <nothing_at_nowhere.com> wrote in message news:<40e1d369$1_3_at_mk-nntp-1.news.uk.worldonline.com>...
>
> We run Oracle 817 and 912 on hpux and Solaris.
> An anxious lead developer rang me on Friday evening. "I'm sorry, Paul; I
> submitted a stupid SQL select against Prod. I'm worried it won't finish, and
> will mess up batch jobs/shutdown/backups".
> "Don't worry, Greg", quoth I. "This is Oracle; you'll be OK. Just
> ctrl-alt-delete, kill your TOAD session, go home and enjoy your weekend. The
> database will clean up". And of course it did, as it has every time since at
> least 1997.
>
> Do I now have to start worrying again in this scenario if the instance is
> running on Winsucks?
>
> Regards,
> Paul

Hi, Paul,

You seemed to let Oracle PMON cleanup the session whose client program aborted. Do you remember approximately how long it took? Thanks.

Yong Huang Received on Wed Jun 30 2004 - 08:12:07 CDT