Skip to Content
avatar image
Former Member

Moving files around

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 31, 2008 at 07:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 02:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 09:08 AM

    Greetings all,

    Thank you so much for the help 😊

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded