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

Thread: calculate the size whether its in MB or GB

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    calculate the size whether its in MB or GB

    hi

    can any one tell me how to calculate & find out what is the parameter size ? whether these parameters are in MB or GB ?

    Request u to tell me the calculation.

    os is linux

    EXAMPLE parameterS

    shared_pool_size string 553648128
    sort_area_retained_size integer 10485760
    sort_area_size integer 10485760

    thanks in advance
    Gajanan

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    They're in bytes.

    however in 9i you can use the "m" (for megabytes) or "g" (for gigabytes) identifyer. example...

    shared_pool_size=200m
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    i am using 8.1.7 not 9i

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    in that case the parameters are shown in bytes.

    so in your case shared_pool_size string 553648128 = approx 554 megs
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    Its pretty simple

    All are in bytes
    So, from the rightend cut 3digit and say KB, then cut the next 3 digit and say MB as 1024bytes is 1 KB.

    These are approx values, in this case:

    "shared_pool_size string 553648128"

    553648128 bytes, 553648 KB, 553 MB~
    Felix
    DBA

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