calculate the size whether its in MB or GB

[gajananpkini]

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

[OracleDoc]

They're in bytes.

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

shared_pool_size=200m

[gajananpkini]

i am using 8.1.7 not 9i

[OracleDoc]

in that case the parameters are shown in bytes.

so in your case shared_pool_size string 553648128 = approx 554 megs

[Felix]

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~