How to reclaim space on AIX
We are running Oracle 11.2.0.3 non RAC on AIX Version 6.1.
We are sometimes low on space on certain filesystem on AIX. When this happens, we move datafiles around from an almost full filesystem to another one having more free space.
But, AIX doesn't seem to realise that there is free space available.
When we check free space available using the "dg" command, the percentage of utilisation stays the same and doesn't lower.
We sometimes have to do a shutdown / startup of our Oracle instance, but that solution is not acceptable to us.
Somebody got me that trick:
select 'oradebug setospid ' || spid || chr(10) || 'oradebug close_trace' MESSAGE from v$process where program like '%(P0%';
...but that doesn't always work...
Do anybody have any other suggestions?
Regards,