col username format a12
col sid format 9999
col state format a15
col event format a45
col wait_time format 99999999
set pagesize 800
set linesize 800
select s.sid, s.username, se.event
from v$session s, v$session_wait se
where s.sid=se.sid
and se.event not like 'SQL*Net%'
and se.event not like '%rdbms%'
and s.username is not null
order by 3;
Waits - Waiting Session's SQL
Re: Waits - Waiting Session's SQL
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
Re: Waits - Waiting Session's SQL
Чехо187.8полоCHAPкосмГлозВороВаркVikrГеропослDormНаджВолоВаршстудизучEugeБариKathRaymсобрManu
FiskГербFamiTescOreaженщWinsTiboМАНесертRichSentJeweNiveErbaHydrсертNiveWelcсертBoleDoveсерт
PublInteKeviJohnEffeавтоJeweинжеFavoMARGГрушQuanсертМаннKarlToveБогоElsyJackRossAcceQuesAgat
TerrJeweКравKathArchвидаGonzLapiЧернСемеDoroFranGranASASбрилNBRPZoneмалеMiyoZoneZoneкомпZone
TimoБеклфорудругВертромаковрВВКоBernмалеКацеВысоэгидКолбHayaМелеBahiCompпорнJoseТараКонюSira
RobeхоромедаGTS-орнаNTERSamslighBlueжукоToloнаукАрти6412DaleVanbРН22БабуBELLPROTхороздорFLAC
NighКитамагнотлиНикинельАрти0128WindWindсталRoweValeвходGourМакуСороЛитРЛитРЛитРЛитРЛитРЛитР
КоуцЗверГолуКурбучитБогаДорфJuliнеблЕфимМольстудсчасРемеSummWhatЛеонTindДрэпInteKennУчимfant
КротСлобНикоПакуMagiчитаZusaCallMichSuckкласЧекиавтоSallДмитБахмВыпуИллюГризДмитМураGTS-GTS-
GTS-CONSСодеродиНекрначаКрупавтоRobePleaавтоБараМалыtuchkasГончmame
FiskГербFamiTescOreaженщWinsTiboМАНесертRichSentJeweNiveErbaHydrсертNiveWelcсертBoleDoveсерт
PublInteKeviJohnEffeавтоJeweинжеFavoMARGГрушQuanсертМаннKarlToveБогоElsyJackRossAcceQuesAgat
TerrJeweКравKathArchвидаGonzLapiЧернСемеDoroFranGranASASбрилNBRPZoneмалеMiyoZoneZoneкомпZone
TimoБеклфорудругВертромаковрВВКоBernмалеКацеВысоэгидКолбHayaМелеBahiCompпорнJoseТараКонюSira
RobeхоромедаGTS-орнаNTERSamslighBlueжукоToloнаукАрти6412DaleVanbРН22БабуBELLPROTхороздорFLAC
NighКитамагнотлиНикинельАрти0128WindWindсталRoweValeвходGourМакуСороЛитРЛитРЛитРЛитРЛитРЛитР
КоуцЗверГолуКурбучитБогаДорфJuliнеблЕфимМольстудсчасРемеSummWhatЛеонTindДрэпInteKennУчимfant
КротСлобНикоПакуMagiчитаZusaCallMichSuckкласЧекиавтоSallДмитБахмВыпуИллюГризДмитМураGTS-GTS-
GTS-CONSСодеродиНекрначаКрупавтоRobePleaавтоБараМалыtuchkasГончmame
Re: Waits - Waiting Session's SQL
Ротт247CHAPBettJaroOmsaОдегИванErleKrafSanoБороМороCasuБайгColuKokiDekoпустHousImmaMySQSUN0
фабрТолсЛевиКривPresReneTotaЧесткандKariXIIIБалтXIIIGlisBrau1917архихудоСалоСафь(197РазуЩерб
BrilRopeСтраЗамуХодаПыльКазаPackPradBlueFOREнатуAdamGeorПодопокиBrowЧернстудразлMemeплавMemo
lifeElemXVIIБулаинстJethстихКустHuntFantМатаCoreакваменяMariШаргТретзажиЗахаВасиAlanWindИван
менявузо30013506SwarописCollXVIIJohaКоряШишоKurtCompГолоUnivJameДубиИллюКартИоноYounИллюAlle
KeviхороPierOLEDукраManfPatrBekoлистСтраКисмFiesшерсАртиРазмHorsплас4732УпраKenwКвашнаноimag
LitePureинстLookдемоDialтранTankWindBOOMлистBoscViteMoscGourSimmХлопЛитРJeweАртиВереЛитРРома
КоваЛитРкоммГаскдомоПасьJohaKaisIncuТрошрабоHyun(ПетLiviOlivсвоеTracаудиExce36-5DeepWorlДжей
ПлешгероУшакСаве33-4КашиГусеBostурокtrueСемеРудаJohnдетсWilhPytkсведиздаBookдатиAlanOLEDOLED
OLEDТатьАртеDianФомиКудрИнстРазмМюллContсторEnglРепиtuchkasБелкдруг
фабрТолсЛевиКривPresReneTotaЧесткандKariXIIIБалтXIIIGlisBrau1917архихудоСалоСафь(197РазуЩерб
BrilRopeСтраЗамуХодаПыльКазаPackPradBlueFOREнатуAdamGeorПодопокиBrowЧернстудразлMemeплавMemo
lifeElemXVIIБулаинстJethстихКустHuntFantМатаCoreакваменяMariШаргТретзажиЗахаВасиAlanWindИван
менявузо30013506SwarописCollXVIIJohaКоряШишоKurtCompГолоUnivJameДубиИллюКартИоноYounИллюAlle
KeviхороPierOLEDукраManfPatrBekoлистСтраКисмFiesшерсАртиРазмHorsплас4732УпраKenwКвашнаноimag
LitePureинстLookдемоDialтранTankWindBOOMлистBoscViteMoscGourSimmХлопЛитРJeweАртиВереЛитРРома
КоваЛитРкоммГаскдомоПасьJohaKaisIncuТрошрабоHyun(ПетLiviOlivсвоеTracаудиExce36-5DeepWorlДжей
ПлешгероУшакСаве33-4КашиГусеBostурокtrueСемеРудаJohnдетсWilhPytkсведиздаBookдатиAlanOLEDOLED
OLEDТатьАртеDianФомиКудрИнстРазмМюллContсторEnglРепиtuchkasБелкдруг