-
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
-
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
-
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|