File_System_Full Error
Hi Friends,
In my production system of ECC 6.0, AIX, Oracle 10g, while doing the DB check, I've encountered the following error messages
BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/RP1/sapdata1, value: 99.74% (> 99%)
BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/RP1/sapdata4, value: 99.75% (> 99%)
The datafiles that are currently being accessed are in the sapdata6 directory where there is ample space.
When I access any table which is in the datafile on the sapdata1, then in that condition will not create a problem. Can I identify what tables are store in which of the datafiles in sapdata1 for eg.
Will the above situation cause a problem on the performance of the DB....
Request you to kindly guide
Thanks....
Aliila