Is Oracle Simply a Pig - The Worst I've Seen?

Is Oracle Simply a Pig?

While these questions were posted by the data base group, I have never seen an application require so much CPU to perform so little work.

Is it because of the tools selected?

Answers to these questions would be greatly appreciated, especially by the Oracle employees reading this group.

In article <1993Nov23.153648.1320_at_eisner>, comarow_at_eisner.decus.org (Bob Comarow) writes:
>
> Three Oracle Questions by our DB group running under VMS. Answer all three of
> them and win the prize-we won't hire you:-)
>
> Our Oracle applications being investigated use SQL Forms, SQL Report Writer,
> SQL Menu, PL/SQL, and SQL. They are running on a 6630, users are granted
> working sets greater than 15,000 pages, and we are ringing the bell.
>
> The questions posed by our DB group:
>
> 1: What kinds of things in an application (using the above tools) would
> require a very large page file quota. ( Users on some applications require
> a page file quota of 180,000).
>
>
> 2: In SQL Forms 3.0 , what is the relationship between amounts/location of
> memory used and the "Records Buffered" setting?
>
>
> 3: How do LONG fields affect performance with regard to array fetching, record
> buffering, etc.
>
> Send mail to comarow_at_eisner.decus.org and I will summarize and post results.
>
>
>
Received on Sat Nov 27 1993 - 14:46:28 CET