[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

sybase sp_helpsegment


FRom results below, how do I convert total_pages     free_pages to MB ??


 total_size        total_pages     free_pages      used_pages      reserved_pages
 ----------------- --------------- --------------- --------------- ---------------
 10.0MB            2560            1698            862             0
(return status = 0)
1>
0
motioneye
Asked:
motioneye
1 Solution
 
alpmoonCommented:
From the output, it looks you are using 4K page size (10 MB is 2560 pages). Then you need to multiply free_pages by 4K:

1698*4/1024 = 6.63MB This is free pages as MB
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now