Have you also cleared the pga_aggregate_target.
If this is set (even when the work_area_policy is manual)
then Oracle may be using the 'real free' memory routines,
which could be the root cause of your problem.
--
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
____Finland__September 22nd - 24th
____Norway___September 25th - 26th
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"James Williams" <willjamu_at_mindspring.com> wrote in message
news:3f384a27.8897639_at_nntp.mindspring.com...
> /u01/app/oracle//admin/GISX/bdump/alert_GISX.log:ORA-00600: internal
> error code, arguments: [qesmmCValStat4], [3], [1], [], [], [], [],
[]
>
> Alter system set sql_workarea_policy = manual (not at work so the
> parm is close)
>
> alter system set sort_area_size = xxxx scope=spfile;
>
> Recycle instance:
>
>
> The above error becomes less frequent but not completely stamped
out.
>
>
> Am I missing anything with regards to going back to 8i memory
> management.
>
>
> Solaris 2.8
> Oracle 9.2.0.3
>
>
Received on Fri Aug 22 2003 - 08:52:18 CDT
