memory pools of onstat -g ses
Posted in 1997
Could Any one Please explain me the memmory Polls section of
onstat -g ses 12378
Is this the normal in informix
INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 13 days 18:11:16 --
416472 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
691 navuser console 1894 cali.fmr 1 344064 155496
tid name rstcb flags curstk status
16576 sqlexec c03fb58 Y--P--- 1872 c03fb58 cond wait(netnorm)
Memory pools count 4
name class addr totalsize freesize #allocfrag #freefrag
691 V c79a018 245760 108616 419 48
691_SORT_0 V c2c2018 32768 32024 12 5
691_SORT_1 V c91e018 32768 15904 7 2
691_SORT_2 V c9f0018 32768 32024 12 5
name free used name free
used
overhead 0 480 scb 0
128
opentable 0 8440 filetable 0
1000
ru 0 224 log 0
2136
temprec 0 3144 ralloc 0
85296
gentcb 0 8472 ostcb 0
2016
sort 0 18184 sqscb 0
8480
srtmembuf 0 216 rdahead 0
448
hashfiletab 0 280 osenv 0
2280
buft_buffer 0 10712 sqtcb 0
2448
fragman 0 544 shmblklist 0
568
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
691 - nav30prod NL Not Wait 0 0 7.20
Last parsed SQL statement :
select parent_type, parent_code,
child_sort_order,child_type,child_code,child_desc fromt_rollup_and_desc
where parent_type = 'FG' order by 1,2,3