Re: onstat -g afr

In article <37F0DC73.4CFE0BF6@bloomberg.net>, kagel@bloomberg.net wrote: > Check out the syspools view the sysscblst column poolp (also in view > syssessions) should correspond to the syspools column po_address for > identifying the pools belonging to a particular session. > > Art S. Kagel Actualy po_name column in same view has session id as string. It's not exactly what I want. Original meaning of my question was - is it possible to list all allocated fragments of session memory pools using "sysmaster" database. I need it to automate investigation for what sessions are holding shared memory segment. Little bit of explanation why I need this. We have mixed OLTP and DS system. When DS applications are running(usualy at night) they grab new SHM segments and in same time long running OLTP applications allocating new small memory fragments in these segments. So, when DS applications are gone I have more segments with few blocks allocated from OLTP applications. I can stop these OLTP applications, but I need to know what to stop and I don't what to stop all of them. I don't want to allocate more memory for engine because it may increase swap activity during the day time when more OLTP sessions are running. > > ddv1@my-deja.com wrote: > > > > Hello, > > > > Does anyone know how to get information same as "onstat -g afr" from > > "sysmaster" database. > > > > Thank you, > > Dmitry > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.