monitoring user activity

《monitoring user activity》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Module17MonitoringUserActivityMonitoringUserActivity03-200317-1©2001,2003InternationalBusinessMachinesCorporationObjectivesAttheendofthismodule,youwillbeableto:®Useonstatandthesysmasterdatabasetomonitoruseractivityonthedatabaseserver®Identifytheresourcesheldbyausersession®DisplaythelastSQLcom

2、mandrunbyausersession®Identifywhichusersessionshavecreatedtemporarytables®Describehowtoidentifythetypesoflocksheldbyusersessions®Identifyandterminateaspecificusersession®Explainthepurposeofthedynamiclockmanager17-217-2MonitoringUserActivityMonitoringUserActivityUseractivitiesthatcanbemonitore

3、dinclude:®Readsandwritespersession®Numberandtypesoflocksheld®ThelastSQLstatement®Thenumberofthreadsallocatedtoasession®Thesizeoftemporarytablescreatedbyasession®Thesizeofthelargesttransactionrunbyasession17-3Thesystemadministratorcanmonitorindividualuser-sessionactivities.Someoftheactivitiest

4、hatcanbemonitoredarelistedabove.Fromthisinformation,youcandetermineifaproblemexistsintheapplicationcodethatshouldbeaddressedbytheapplicationdevelopers.MonitoringUserActivity17-3DisplayingSessionInformation$onstat-gsessession#RSAMtotalusediduserthreadttypidhostnamethreadsmemorymemory14informix

5、-0-08192479211metcalfttypa33436orion112288010200810metcalfttyp933420orion11310721124649metcalfttyp833404orion157344485128metcalfttyp733388orion157344485127metcalfttyp633372orion157344443166metcalfttyp133356orion173728500525metcalfttyp533353orion165536485124metcalfttyp433337orion173728505803me

6、tcalfttyp033321orion181920508162metcalfttyp333316orion190112453721metcalfttyp233310orion1163841220817-4Togetinformationaboutthesession,runonstat-gses.ThisoptionisusefulforfindinginformationabouttheclientapplicationincludingtheprocessID,loginname,andhostname.Thisoptionincludesthefollowinginfor

7、mationaboutthesession:sessionIDAuniqueIDforthesession;thisIDisusedinotheronstatreportsuserthreadTheloginnameoftheclientapplicationprocessttyTheTTYportoftheclientapplicationprocesspidTheprocessIDoftheclientapplicationprocesshostnameThehostname