| If you read most of the Oracle topics in the conference in the last
3-5 months, I believe you'll find your answers... but here goes:
>> Does Oracle provide a database server with their product mix (with
>> TPS and without TPS) or does each user attach to their database?
Each user attaches to the database. Depending on the version, there
are detached processes which run to do things like buffer writing,
AIJ and BI file work, etc. I'm not sure your question was very
clear.
> When Oracle publishes their benchmark information are they using
> primarily 3GL code or 4GL code or is it just SQL with no forms?
Don't give their benchmark numbers the time of day !!! It doesn't
matter what they used because they don't match any business environment
I've ever seen. Also, I can tell you from a recent experience that
Oracle V6 w/TPS **DID NOT** run faster on the 6240 than the 8820
or the 8840 in a batch processing benchmark so don't believe for
a minute that crap that Oracle puts out about how fast they are
on the 6240 vs the 88xx series. You and the customer must decide
by yourselves !!
Gerry
|
| I talked to the Database Manager for Mercury Comm in UK who did
a benchmark that Oracle is displaying to all their customers and
prospective customers. They did all the benchmark in 3GL fortran
I believe, and while they are thrilled with the results themselves,
they admitted to spending months getting the machine tuned to work
at these levels, both in the VMS params and Oracle params. I suspect
by the time you get your VAX working at these levels nothing well
written will run on it. I do know that they partitioned off 6 meg
of memory for Oracles SGA.
Sparky
|