Sessions Memory Usage
The poster asked how to get per-session "Total Memory"/"Used Memory" (as shown by onstat -g ses) from sysmaster via SQL. Art Kagel and John Miller gave the query: select memtotal, memused from sysmaster:sysscblst where sid = <sessionid>, optionally wrapping the values in format_units() and joining user/sid for readability. However, when the poster said he was on 9.40.FC9 (and another user on 10.00.FC9), Miller replied that the session memory columns were added to the sysmaster session tables only in version 11, so an upgrade would be needed — no workaround for the older versions was offered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
I'm trying to get the amount of memory usage for sessions like "Total Memory"
and "Used Memory" from the onstat -g ses command, can I get this information
from the sysmaster?
Thanks in advance for your help.
select memtotal, memused from sysscblst where sid = <sessionid>;
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Fri, Jun 19, 2009 at 8:39 PM, PEDRO PEREZ <pedro2263@gmail.com> wrote:
> Hello,
>
> I'm trying to get the amount of memory usage for sessions like "Total
> Memory"
> and "Used Memory" from the onstat -g ses command, can I get this
> information
> from the sysmaster?
>
> Thanks in advance for your help.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b15432a0c7046cd22d18
If you are using version 11 you should find this
statement very helpful.
select user||"("||sid||")" as name
,format_units(memused) as memused
,format_units(memtotal) as memtotal
from sysmaster:sysscblst
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 06/19/2009 05:39:55 PM:
> [image removed]
>
> Sessions Memory Usage [16116]
>
> PEDRO PEREZ
>
> to:
>
> ids
>
> 06/19/2009 05:40 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hello,
>
> I'm trying to get the amount of memory usage for sessions like "Total
Memory"
> and "Used Memory" from the onstat -g ses command, can I get this
information
> from the sysmaster?
>
> Thanks in advance for your help.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thank you for your help, I forgot to write that I'm using Version 9.40.FC9 do you know how can I get this information in this version?
Thank you for your help, do you know how can I get this information on Version 9.4FC9?
I need to know this for 10.00 FC9 as well.
You will have to upgrade to version 11 to get this information in sysmaster. This addition of the users memory to the session tables was a new feature added to version 11. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 06/24/2009 04:04:00 AM: > [image removed] > > Re: Sessions Memory Usage [16146] > > AARON SMITH > > to: > > ids > > 06/24/2009 04:04 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > I need to know this for 10.00 FC9 as well. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g