Thank you for the reply i appreciate it i would like to know what does the online option on/off do, and what are the possible reasons for taking a database...

Thank you, i appreciate it

ok thanks ll try that

THANKs i appreciate

i also wanted to know what the TNSNAMES.ORA means or what it does in your reply to my post, what is it for?

thank you so much i appreciate it

Thanks really appreaciate all your help

Thanks guys i really appreciate all your info on this

i dont know how to get to the error log files to see the problem could you tell me how to get to the error log files.

The entire server reboots and then instance of sql server restarts

i want to track stored procedures on the production server that are hampering performance by running slowly