Re: parallel query
Date: 1996/10/16
Message-ID: <NEWTNews.845528000.25923.dafis_at_ppp.test.jccbi.gov>#1/1
In article <rp1399-1610961044320001_at_m12cim15.sps.mot.com>,
<rp1399_at_email.sps.mot.com> writes:
> Path:
news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!news.u.washingt
on.edu!uw-beaver!nntp.cs.ubc.ca!news.cyberstore.ca!skypoint.com!newshub.tc.umn.
edu!spool.mu.edu!uwm.edu!cs.utexas.edu!howland.erols.net!news.mathworks.com!uun
et!in1.uu.net!spstimes.sps.mot.com!newsdist.sps.mot.com!newsgate.sps.mot.com!m1
2cim15.sps.mot.com!user
> From: rp1399_at_email.sps.mot.com (Steve Lemme)
> Newsgroups: comp.databases.oracle
> Subject: Re: parallel query
> Date: Wed, 16 Oct 1996 10:44:32 -0700
> Organization: Motorola
> Lines: 33
> Message-ID: <rp1399-1610961044320001_at_m12cim15.sps.mot.com>
> References: <325ca6a2.2452126_at_n5.gbso.net>
<NEWTNews.845016912.3493.dafis_at_ppp.test.jccbi.gov> <32636daa.14657340_at_n5.gbso.net> <NEWTNews.845357109.26963.dafis_at_ppp.test.jccbi.gov> <32638d03.2588120_at_n5.gbso.net> <NEWTNews.845441591.23296.dafis_at_ppp.test.jccbi.gov>
> NNTP-Posting-Host: m12cim15.sps.mot.com
>
> In article <NEWTNews.845441591.23296.dafis_at_ppp.test.jccbi.gov>, Martin
> Douglas <dafis_at_ppp.test.jccbi.gov> wrote:
>
>
> > >
> > > Martin Douglas <dafis_at_ppp.test.jccbi.gov> wrote:
> > >
> > > >I have three processors on a DEC 2100 Alpha. And when I'm running
parallel
> > > >query, I get multiple sessions for a users login. These are just the
etc..
> > Martin Douglas
>
> WIth our HP T500, 4 CPUS and Parallel query I see trace files generated
> with the message " Received undandled signal" or resignalling error"
>
> When called, ORACLE seems to think these come from users who turn off
> their machines during a query or cancelling them in midstream.
>
> Has anyone else seen these?
>
> Thanks
>
> Steve Lemme
> DBA
> MOTOROLA
>
> See ya at IOUW/ORACLEWORLD 96 and hope you catch my paper on ORACLE
monitoring
>
> --
> When you are in it up to your ears....
> Keep your mouth shut!
> rp1399_at_email.sps.mot.com
>
I never noticed those error messages. I will look and see, but from what the errors messages suggest, It appears ORACLE cannot get back to the user. We get that type of user problems all of the time because we let them come in with whatever software they have. "Leverage their Investments". This means lots of BAD quiries. I think ORACLE could be more a little more sure of themselves.
P.S.
If we get much deeper I WILL need to keep my mouth shut.
Martin Douglas Received on Wed Oct 16 1996 - 00:00:00 CEST