One guess in line.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"Mark" <marksgnga_at_yahoo.com> wrote in message
news:41d52a1a.0312022033.11eb99c1_at_posting.google.com...
> I can provide more detail if necessary. I partly suspect the DBA made
> a change and either doesn't know it or won't fess up. I'm hoping there
> is some other explaination ... 'learning optimizer'(ha!), etc. Why did
> the reboot change/reset things?
>
Someone did :
alter system set ..... scope = memory
to a parameter that affects the optimizer.
The reboot restarted the database using
the original init.ora / spfile settings.
> Thanks in an advance for any guidance,
> Mark
Received on Wed Dec 03 2003 - 02:38:53 CST
