I have a script that runs 7 days a week 24 hours a
day monitoring oracle databases. As time goes on,
it eats up more memory. The script would run for about a
day and a half before crashing. I installed the latest
version of perl and the DBI/DBD modules for oracle. The script
will make it about 3-4 days before failure. I can see the
memory size grow as the script runs. I assume, that I am
not de-allocating something properly? My questions are...
1. Is there anyway to determine what I am not de-allocating properly.
2. Is there anyway to easily have the script restart itself
after a certain period of time or a threshold is met?
3. Is there anyway to be sure you are de-allocating objects/variables
properly?
Thanks Robert