Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    michigan
    Posts
    17

    Unanswered: Actual physical file size

    Hi Everybody,
    I like to compute the actual physical database file size using queries.

    From the EM database properties, the file size shown is not matching with the master..sysaltfiles.size

    Ex. Actual file size is 12MB and 1MB for MDF & LDF respectively.
    'sysaltfiles' shows 1464 & 96 resp. Since they are shoing it as 8K Pages,
    96*8 = 768KB is not matching with 1024KB for the LDF file.
    Is there any overheads (additional space from the physical file for file headers) allocated?

    Thanks
    Babu

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    hm odd, I see the same thing. Additionaly, when calculating via sysaltfiles and comparing it with what a 'dir' shows, I have a match. The EM does show the size correctly in the Space allocated (taskpad), but not the Database Size. In my case it's a 4,56 MB off. Detaching the DB didn't change the size on disk either.

  3. #3
    Join Date
    Feb 2004
    Location
    michigan
    Posts
    17
    Hi Kaiowas,

    So you are getting the computation of sysaltfiles.size*8K pages matching with those of the physical OS file size. There is no difference in your system.
    Mine is not matching. Any idea?

  4. #4
    Join Date
    Feb 2004
    Posts
    492
    yes, I did size * 8 * 1024 to get a bytesize to compare against a dir/properties of the actual databasefile.

Posting Permissions

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