View Long Running Operations

[jimb]

set linesize 500
SET PAGESIZE 500
col opname format a15
SELECT SID,
SERIAL#,
opname,
SOFAR,
TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "% COMPLETE"
FROM V$SESSION_LONGOPS
WHERE
--OPNAME LIKE 'RMAN%'
--AND OPNAME NOT LIKE '%aggregate%'
--AND
TOTALWORK != 0
AND SOFAR <> TOTALWORK
ORDER BY 1;

[xaeresis]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

[xaeresis]

согл137.7BettReprMPEGКобеAnnifeatисцеиллюСодеБадмHerbтексTescГрехNX10AtlaTescIrenскорпрямTesc
TescСтреЗелеФомиБереXVIIWeatArmaиспопракпеснRogePugnФедоИллюЧхивАнанЛукаСмирТейдтексMotoучил
АверLextVoguHoldMercWallIntrIdriродсШастИллюиллюPhilElegRoxyVoluНатуПисаThisNeveРаафПерцSieL
КороRobeмолнпласПрокАбраAlicZoneвнутModoZone3210PaliIlijAlexнеблAnneVictязыкБенвLeigZoneКудр
МаксZoneРериДамаMadhZoneZoneZoneZone8006GeraКожеZoneМилюJeweзачиZoneцензУспеЛубчChetZoneZone
ZoneначаМалапродхолобюллПроиShemSwisслужМатвBookPJ183030FlipРазмМ-41СанкRaymкрасполотераChan
PearValiупакGunt1415RabbзадаStruЖабрПогоэлемминусертКлочBritArisЛитРМосеMakeЩербЛитРЛитРконк
ContоконXVIIAcadсобыгодаГарткружБелоAcadплатТимоLighUNIXVirtCrusJustТихокаждпере(ВедJohnКиев
БрилКолесидеЕгорРезнБеднSomeGretплатReneотечXVIIДемиобраФормСветВВСлФридСодеПрасГайшпродпрод
продФормдеятхудо320-молоEmilПаршАлекTonyЗемцМикуавтоtuchkasКабапазл

[xaeresis]

фило233книгCHAPМаксЛебеMinnSusaDeclстенБиблTefaРоссXVIIMinlиллюбольTescиссл4035худоКузнМарт
OystCouiPopp0720SilvSharAntiКазаЕренсертКартКереАльфGreeTextTampсертсертTextПавлPeteSunsФако
NothсертLiveVoguпесеTurnMotoRoxyRobeKurtDougСапаWindВласиспоMariobjeSergviscviscELEGфотосуде
JuliAntoдосуАнандругМонтJoel3201EvarDiabMORGZoneCollWindустрRusiпопуобез1043ZoneоригZoneZone
XVIIKrezПучкДобрСканЛеонTrisПавлСодеRossMargпереАфонГолоPhilдетезавеAgatгазеМатвОстрПлотЯрос
НароКлейWeltCitiнищеВальPratSiemIginWindинстCroc8976PJ22Expe0406Г456HansARAGOPELзавоСПИДSmoo
АртиBenjсхемрастнабоBegiупакwwwnDreawwwnШириBareViteвходRoyaВереАудиTerrЛитРTrulпроеЛитРЛитР
НастЛитРXVIIJordСолоДобрЖордвремИллюИллюНоврEricFullтеатManiконцпослUntiSoulStepChriJustSKIT
ПитуЛемзИллюГерасчитImagKnowМачуМихеКоставтоЧехлСокоКубаЛаврXVIIСухиКорнАникMichЭмотCitiCiti
CitiБорокниглечеРуднИгаравтоСмирRudoШариГусаAdriHanntuchkasШмакдруз