my script was working yesterday but today it is slow why? it may be the reason below? 1- script does't find the database 2- it find the database 3- it eats the memory 4- cpu utilaization is too much give me the reason for each.why it is slow.

No it's not any of those reasons, but #3 was close. The real reason is because it didn't eat breakfast, so its brain cells aren't working. ;)

If this is a shell script, you can add set -x after the shell declaration line. Watch what is happening whil it runs. You might also try some echo statements to help you with the progress.

abhi, it may be the any one the below reason Have you used any find and grep command in the script which is generated the file in this script itself. Have you check the space in the file executable folder ,if its so high then the script output will be slow. etc