Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Turning off PGA managment in 9i

Turning off PGA managment in 9i

From: James Williams <willjamu_at_mindspring.com>
Date: Tue, 12 Aug 2003 02:03:58 GMT
Message-ID: <3f384a27.8897639@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 Mon Aug 11 2003 - 21:03:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US