I am getting ORA:600 error when trying to select * from a particular view. If I directly query the base table on which the view is based then this error is not coming. the query is fetching rows properly from the view but at the end of it waits for few seconds and gives the error ORA:600. I don't know how to tackle this problem. Can anybody pls guide me to solve this problem.
I am running oracle 22.214.171.124 on win NT (service pack 5). I am also runnig oracle 9iAPS and APACHE on linux servers. We are not using OPS (for info pls).
[Edited by parijat67 on 01-24-2002 at 07:25 AM]
ORA:600 is something you need to contact oracle support about.
They'll ask you to send in some trace files and run a utility or two to gather info for them to decide what's wrong.
This error means a space (memory) leak has been detected in the UGA. The argument is the number of bytes leaked.
There is NO data corruption as a result of this error. It is purely an internal memory housekeeping problem.
So, Please try to bounce your Database and Restart your Server.
Since "ORA-00600" is internal error code, We can not find the exact solution. So, if you send the trace file, we can further explore...
Before vall to oracle suport u can little bit explain problem.
U need - 1 number in error message - ora-600 ... [1 number],,...
and alert log files.
1 number can say to u layer where error occured, for example -
 - service layer
 - generic layer
(all list u can find on metalink)
and u can check alert files in $ORACLE_BASE/$ORACLE_SID/bdump/...
Click Here to Expand Forum to Full Width