Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ballot counting system - HELP!
In our last gripping episode jdarrah_co_at_my-deja.com wrote:
> Try setting this undocumented parameter: _skip_dimwit_voters = true.
> In article <4FMO5.1256$8e3.144741_at_nnrp3.sbc.net>,
> NOSPAM_jazztunes_at_yahoo.com (David H.) wrote:
> > We have been experiencing severe performance problems with our
ballot
counting
> > system over the last several days. Also the system appears to
return
> > inaccurate results sometimes. This seems to coincide with another
problem
> > where the output columns don't line up. While running TKPROF
against
a
> > session trace, I noticed this recursive call being executed:
> >
> > select count(votes)
> > from v$sess_pool
> > where state = 'FL'
> > and county = 'Palm Beach'
> > and iq < 75
> >
> > I've already contacted the DNC tech support line. The tech support
guy, J.
> > Jackson, gave me an LSI (law suit ID) for tracking purposes. He
said
it could
> > be up to 10 days until he has an answer for us. Has anyone else
experienced
> > this?
> >
> > --D. Umbass
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
I think the ultimate solution is to port this application to PostgreSQL to give it the performance it deserves.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Nov 10 2000 - 11:13:06 CST