Re: Tuning Nightmare - Advice Needed

The first bit of this advice is extreme.

This is a DSS system - the CPU time for
parsing every query could well be tiny
compared to the run time of the typical
query. The number of queries parsed could be so small that the time lost in latching could be non-existent.

Bind variable usage tends to be very good for OLTP systems where you execute millions of very small, nearly identical, queries per day.

Literal usage can be highly appropriate for DSS systems where you execute thousands
of very large, dramatically skewed, queries per day.

Somewhere in the middle you may want to
be picky about some queries using binds, some using heavy hinting, and some being recognised by the program that generates the SQL.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

mark wrote in message ...


>Always use binds.  Dont use literals.

>E Mail the Explain plan and the Table details with the SQL please.

>