He tells you why no autotune.
Again and again and again.
To reiterate: When you use SQL every time it runs a statement it checks
to see if the environment has changed before running the statement and may
decide a different way to run it.
For example, at memory size X a full table scan may be better than at
memory size Y where it may use a different technique.
Therefore if you have auto tune set on and it's constantly changing memory
sizes then it has to constantly re-evaluate how to run an sql statement.
If the tuning is done manually and not quite so frequently, then you don't
have this issue.
Rob Berendt
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
