DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How do you manage free space for Oracle on NT?

  1. #1
    Join Date
    Mar 2001

    How do you manage free space for Oracle on NT?

    How do you manage free space for Oracle on NT?

    Our DBA team has a goal to let the tablespace grow as long as each datafile is below 2GB. What we did is setting the autoextend on for all tablespaces and watch the free space on the OS level very closely. As long as the disk space is less than 90% full, we are fine. Currently, we monitor the free space by watching the free space on the "Windows Explorer." This is something I think we can improve.

    Question: Is there a way to write a script on the OS level to check the disk space usage info? On unix, I can use "df -k." Do you have any suggestion on NT? Thanks!

  2. #2
    Join Date
    Nov 2000
     Volume in drive E is TEMP
     Volume Serial Number is ECB1-1C6B
     Directory of E:\
    01/10/02  09:44a        DIR          Patches
    01/31/02  01:48p        DIR          Doc
    03/22/02  10:24a        DIR          Tars
    03/26/02  12:58p        DIR          oradata
    03/26/02  12:58p        DIR          oracle
                   5 File(s)              0 bytes
                                129,990,656 bytes free
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Thank you. I know that. Is there anything like "df -k" that show you all drives at the same time. We have more than 10 drives on the NT servers. Thanks!

  4. #4
    Join Date
    Nov 2000
    Pittsburgh, PA
    You can write a Winbatch program that will give you whatever you want.

    You can also write a sql script that will look at the dba_data_files. This of course won't tell you about the archive logs.

  5. #5
    Join Date
    Apr 2002
    Shenzhen, China
    Have MAXSIZE 2G for each datafiles.

    On windows, you can use WMI on Windows Script Host to accomplish all administrator's tasks. The attachment is an example for monitoring diskspace.
    Attached Files Attached Files
    Last edited by Calvin_Qiu; 11-24-2002 at 10:11 PM.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width