Reclamation takes ages
1998-10-02 03:34:19
Richard,
> Mauro - There are two things that come to mind when I see reports of
> reclamation taking so long...
> 1. Tape drive problems. A "lost VCR data" condition is a conspicuous
> example of a drive problem which can aggravate access times by a
> factor of 10. See if you can find any errpt or other indications
> of a hardware problem.
>
normally you get a warning message at the console when the system detect
a "lost VCR data" and this is not the case.
> 2. Reclamation does a lot of database work. If your cache hit ratio
> ('q db f=d') is under 98%, boost dbbufpoolsize.
>
cache hit ratio seems to be ok, ==98%. But I'm going to monitor disks
activity through iostat ... there are other tools specific for DB
monitoring?
Thank you
Mauro
|
|
|