What leads to server crash? [message #339393] |
Thu, 07 August 2008 07:27  |
Suwarna
Messages: 10 Registered: August 2008 Location: Mumbai
|
Junior Member |
|
|
Hello,
Just wanted to know what kind of queries can lead to server crash... and how do we come to know that it has crashed?...
will doing 'explain plan' before firing the query be a good precaution?.. i am new to oracle and it would be great if there were some suggestions on what to do after such a crash.
thanks
|
|
|
|
|
|
Re: What leads to server crash? [message #339445 is a reply to message #339409] |
Thu, 07 August 2008 09:11   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
After a crash, you let someone who knows what he's doing investigate the cause of the crash, and restart/restore & recover the database.
Doing an explain plan will have no effect at all on the liklihood of the server coming down.
|
|
|
|
|
Re: What leads to server crash? [message #339450 is a reply to message #339446] |
Thu, 07 August 2008 09:21   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I had to take the server out from underneath an 8i instance a couple of times.
The client had a lovingly handcrafted Dll that they were calling via Extproc, and it would occasionally crash while holding a lot of locks, and not respond to Kill session commands.
It actually left the database in such a state that a Shutdown Abort wouldn't take it down.
|
|
|
|
Re: What leads to server crash? [message #339607 is a reply to message #339393] |
Thu, 07 August 2008 22:52   |
Suwarna
Messages: 10 Registered: August 2008 Location: Mumbai
|
Junior Member |
|
|
well,
What i meant was...
wat if we write a code such as -
while x<10
loop
insert into tempp values (x,'in while loop');
x:=x+1
end loop
Now,if we omit the condition x:=x+1, the program goes into an infinite loop..inserting values into tempp, hence occupying the entire HDD and leading to server failure...
pls post your thoughts.. am i thinking rite?.
P.S My apologies for the unformatted code .. its just a snippet i havent tried out..
|
|
|
|
|