Waits - Waiting Session's SQL

[jimb]

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;

[xaeresis]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

[xaeresis]

Чехо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

[xaeresis]

Ротт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Белкдруг