I am running some set of jobs which includes updates, loading and selecting jobs. i am using 4 nodes in config file. The server is getting crashed and i have to re run the jobs. For the update jobs i am using hash partition on the o/p oracle enterprise stage.
Can someone tell me the possible reasons of the server getting crashed? this is happening regularly.
Can you explain what "server getting crashed" means? Does it mean that your job aborts or that the DS Engine stops? In either case, an error message posted here will go a long way towards getting a qualified response.
You need system level stats to see what is happening at the server level as well. Are you paging? How much RAM do you have? How much is being used? Is your database on the same server? Are you out of disk space or scratch space when you crash? Lots of things can cause this. Answer Arnd's question then these. We should be able to help you better.