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;
View Long Running Operations
Re: View Long Running Operations
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting
Re: View Long Running Operations
согл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Кабапазл
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Кабапазл
Re: View Long Running Operations
фило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Шмакдруз
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Шмакдруз