Moving files around

[Former Member]

Hello all,

Currently have a Solution Manager 7.0 system installed in a Linux/Oracle environment.

Is there a way to see the largest files that are associated with Oracle as well as a way to move them to another disk? Any notes out there on the issue?

TIA

[Former Member]

Greetings all,

Thank you so much for the help

Cheers!

[Former Member]

Hi Cassey,

If you are doing a performance optimization activity, then you have to look at datafiles that are most used, rather then the largest files.

In older SAP releases, to look at database file system requests, go to ST06 -> detailed analysis -> Filesystem requests. It uses the same query as:

SELECT

b.file_name,a.PHYRDS,a.PHYWRTS,a.PHYBLKRD,a.PHYBLKWRT,a.READTIM,a.WRITETIM

FROM

V$FILESTAT a, dba_data_files b where a.file#=b.file_id order by a.PHYRDS;

Once you know the contention, you can move the files across. You can also use soft links at OS level to move the files across if you want to.

Cheers,

Nisch

[Former Member]

Hi Casey,

to find the largest files, there are at least two possibilities:

1. Go to transaction dbacockpit and look in subsections of the Space tree for data files and order them by size.

2. Open sqlplus / as sysdba and execute the statement

SELECT name, bytes / 1024 / 1024 FROM v$datafile ORDER BY bytes;

This will print out all datafiles with the largest at the end.

To move the file to another disk, I think you could use brtools, or you shutdown your database, move the file manually and rename the file after wards in mount state of your database:

startup mount
ALTER DATABASE RENAME FILE 'old path' TO 'new path';
ALTER DATABASE OPEN;

If you are unsure, try brtools for the move. If you move manually, it is better to copy the file and rename the old file before you restart the database. If your system is up and running you may delete the old file.

Regards

Ralph