insstance crashed when creating a view

[learning_bee]

I have a view and this view is huge. everytime I ran this view, the database crashed. I didn't get much out of the alert log file, all I got is :

LGWR: terminating instance due to error 472
Tue Nov 11 13:45:01 2003
Instance terminated by LGWR, pid = 3888

no trace file is generated.

anyone had this issue before, I am on 9.2.0.4

thanks

[bhallar]

Try to generate a trace file using event trace in init.ora file
event='472 trace name errorstack level 12'

Pls post the View also if possible for you.

Also check the value of cursor_sharing if it's FORCE or SIMILAR pls make it default and then try

[learning_bee]

thanks for your reply,

the view is too long and to post it here, honest it's longggggg.

about cursor_sharing,it set to EXACT now.

any other advises???

[abhaysk]

Originally posted by learning_bee
the view is too long and to post it here, honest it's longggggg.

Guess u can attach it as a file !!