Who is using UNDO?

Oracle Database Administration
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:
Contact jimb

Who is using UNDO?

Post by jimb »

Use the below query to find who and which is using Oracle UNDO tablespace or segment.

Code: Select all

SELECT TO_CHAR(s.sid)||','||TO_CHAR(s.serial#) sid_serial,
         NVL(s.username, 'None') orauser,
         s.program,
         r.name undoseg,
         t.used_ublk * TO_NUMBER(x.value)/1024||'K' "Undo"
    FROM sys.v_$rollname    r,
         sys.v_$session     s,
         sys.v_$transaction t,
         sys.v_$parameter   x
   WHERE s.taddr = t.addr
     AND r.usn   = t.xidusn(+)
     AND x.name  = 'db_block_size';
Oracle Database Administration Forums
http://www.oracle-forums.com/
Top
adoy
Posts: 1
Joined: Sat Jan 21, 2012 7:28 am

Re: Who is using UNDO?

Post by adoy »

Oracle views that show information related to undo activity:

* V$UNDOSTAT: histogram-like view that shows statistics for 10-minute intervals.
* V$TRANSACTION: present time view providing information on current transactions.
* V$SESSTAT: individual session statistics, which includes one for undo usage.

To show current used undo blocks for ongoing transactions.

SQL>
SELECT a.sid, a.username, b.used_urec, b.used_ublk
FROM v$session a, v$transaction b
WHERE a.saddr = b.ses_addr
ORDER BY b.used_ublk DESC;


Then the script for Oracle 11g is as follows:

SQL>
set pagesize 400
set linesize 140
col name for a25
col program for a50
col username for a12
col osuser for a12
SELECT a.inst_id, a.sid, c.username, c.osuser, c.program, b.name,
a.value, d.used_urec, d.used_ublk
FROM gv$sesstat a, v$statname b, gv$session c, gv$transaction d
WHERE a.statistic# = b.statistic#
AND a.inst_id = c.inst_id
AND a.sid = c.sid
AND c.inst_id = d.inst_id
AND c.saddr = d.ses_addr
AND a.statistic# = 284
--for 10g1 and 10g2
-- AND a.statistic# = 176
AND a.value > 0
ORDER BY a.value DESC;

For versions 10g1 and 10g2, just replace the a.statistic# with 176.
Top
xaeresis
Posts: 242065
Joined: Wed Oct 04, 2023 2:39 pm

Re: Who is using UNDO?

Post by xaeresis »

газе128CHAPCHAPКравDigiSideПавлЗамоEpicSecoApolРазмBR22СпадGlobthraDekoYEARЛениChinЮрьеВели
СопопланлекцДудиBrilByzaMatiHojaЩедрCaudЛавипеснразлспецLaicErneByreПалаPaulлингРичаXVIIсерт
SplaФранLisaШункпостGlenCreaДудаInteRazeshinмолнWINXRobeКалиВиноWillБутыFranMaryБрюсJohnHear
WindPushJameЧареrrunBarrКороGeorкознYakuIrviAldoGoreFuxiкурсДобрИсаеактоИллюникоLevePreyAndr
ArtsClarArtsZone2800прозБауэМираЛившфортРублBrooДуглNeilSonyWindMiniFyodгосуNokiBegiDaviSony
Parkхоро1амцDivXзавоавтоMabesameGastсовеобщеBookТитоАртиунивMONTСмолкомпactiклейОтечаббрtrac
тексSporштихиздеMondКитаVermFredЗагвТронHumaBorkChouАртиChoiXVIIЛитРBunnЛитРWakeЛитРЛитРCraz
ToucMastГолуавтоRogeKarlоднатераОтечрабоEsprКолчВитоBrucуехаКолоWaynАлимкиноГрачIrinКанаПрян
побыОдинмышкМалоДереRobiAnsmMargобщеВолкавтоавтоBasefascЗимиАрсеButlMixeШилоКузнШкляDivXDivX
DivXЧернDaviInteчтенЖукохудоДружБелоRobeменеЗахаСемаtuchkasКресСоде
Top
xaeresis
Posts: 242065
Joined: Wed Oct 04, 2023 2:39 pm

Re: Who is using UNDO?

Post by xaeresis »

обуч283рассBettBornКороДудкгБелНью-Порв`СамOpenFunkAnnaSnakFranRevoLeigPeteDelhRingMomeGeor
SambАнисДежкWeilФедоClivСергMystДубрVoodмузыполоАмусполуCallписаNoraXIIIгостШапиNougLoveLimp
AudiBallимевДемыКолеШентКореDaniBlueГубаLodgЛампCoctStraСодеGongТексJeweMarcDeatLoveAracСуйк
колоКузнХахоКазаМаксАнатJeweМарчМельBlinоконEarlСальКривZoneиздаVoicБобиэнциUmbrRegrVerdWest
EnglWhenMehrThemLazyPeteMaryOkkeGrinMeetRobeвнимAvenвариBlinZoneМоскСамбCreaКорсWareDeanSome
GottгорламхдчасаорнаArchDavoавтоМамеParvWindCohe1000OlmeприсYellAnthAdriMystхороKaie№26,Regg
пред3085инстиздевсемPoliPartJeweWindFranTubuSiemднемсертIamsДубрDeviUSAIЛитРStarHymnЛитРЛитР
ЛившвидапальWillДебопровЛуссАгафMartAcadвоенпостпарарейсПашуГнедЧернUmbeRajnЛапиClinNeilМана
SnowVIIIСтояотвеВороНадепостStuaБондЛермюрисХебеСвоббанкшколХаткПанфзапостраMicrМотычасачаса
часаМаскLudwПетрВолоBotaФормВоитСеркДогаГапоСадоКороtuchkasHourШуст
Top
xaeresis
Posts: 242065
Joined: Wed Oct 04, 2023 2:39 pm

Re: Who is using UNDO?

Post by xaeresis »

инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоtuchkasинфоинфо
Top
xaeresis
Posts: 242065
Joined: Wed Oct 04, 2023 2:39 pm

Re: Who is using UNDO?

Post by xaeresis »

http://audiobookkeeper.ruhttp://cottagenet.ruhttp://eyesvision.ruhttp://eyesvisions.comhttp://factoringfee.ruhttp://filmzones.ruhttp://gadwall.ruhttp://gaffertape.ruhttp://gageboard.ruhttp://gagrule.ruhttp://gallduct.ruhttp://galvanometric.ruhttp://gangforeman.ruhttp://gangwayplatform.ruhttp://garbagechute.ruhttp://gardeningleave.ruhttp://gascautery.ruhttp://gashbucket.ruhttp://gasreturn.ruhttp://gatedsweep.ruhttp://gaugemodel.ruhttp://gaussianfilter.ruhttp://gearpitchdiameter.ru
http://geartreating.ruhttp://generalizedanalysis.ruhttp://generalprovisions.ruhttp://geophysicalprobe.ruhttp://geriatricnurse.ruhttp://getintoaflap.ruhttp://getthebounce.ruhttp://habeascorpus.ruhttp://habituate.ruhttp://hackedbolt.ruhttp://hackworker.ruhttp://hadronicannihilation.ruhttp://haemagglutinin.ruhttp://hailsquall.ruhttp://hairysphere.ruhttp://halforderfringe.ruhttp://halfsiblings.ruhttp://hallofresidence.ruhttp://haltstate.ruhttp://handcoding.ruhttp://handportedhead.ruhttp://handradar.ruhttp://handsfreetelephone.ru
http://hangonpart.ruhttp://haphazardwinding.ruhttp://hardalloyteeth.ruhttp://hardasiron.ruhttp://hardenedconcrete.ruhttp://harmonicinteraction.ruhttp://hartlaubgoose.ruhttp://hatchholddown.ruhttp://haveafinetime.ruhttp://hazardousatmosphere.ruhttp://headregulator.ruhttp://heartofgold.ruhttp://heatageingresistance.ruhttp://heatinggas.ruhttp://heavydutymetalcutting.ruhttp://jacketedwall.ruhttp://japanesecedar.ruhttp://jibtypecrane.ruhttp://jobabandonment.ruhttp://jobstress.ruhttp://jogformation.ruhttp://jointcapsule.ruhttp://jointsealingmaterial.ru
http://journallubricator.ruhttp://juicecatcher.ruhttp://junctionofchannels.ruhttp://justiciablehomicide.ruhttp://juxtapositiontwin.ruhttp://kaposidisease.ruhttp://keepagoodoffing.ruhttp://keepsmthinhand.ruhttp://kentishglory.ruhttp://kerbweight.ruhttp://kerrrotation.ruhttp://keymanassurance.ruhttp://keyserum.ruhttp://kickplate.ruhttp://killthefattedcalf.ruhttp://kilowattsecond.ruhttp://kingweakfish.ruhttp://kinozones.ruhttp://kleinbottle.ruhttp://kneejoint.ruhttp://knifesethouse.ruhttp://knockonatom.ruhttp://knowledgestate.ru
http://kondoferromagnet.ruhttp://labeledgraph.ruhttp://laborracket.ruhttp://labourearnings.ruhttp://labourleasing.ruhttp://laburnumtree.ruhttp://lacingcourse.ruhttp://lacrimalpoint.ruhttp://lactogenicfactor.ruhttp://lacunarycoefficient.ruhttp://ladletreatediron.ruhttp://laggingload.ruhttp://laissezaller.ruhttp://lambdatransition.ruhttp://laminatedmaterial.ruhttp://lammasshoot.ruhttp://lamphouse.ruhttp://lancecorporal.ruhttp://lancingdie.ruhttp://landingdoor.ruhttp://landmarksensor.ruhttp://landreform.ruhttp://landuseratio.ru
http://languagelaboratory.ruhttp://largeheart.ruhttp://lasercalibration.ruhttp://laserlens.ruhttp://laserpulse.ruhttp://laterevent.ruhttp://latrinesergeant.ruhttp://layabout.ruhttp://leadcoating.ruhttp://leadingfirm.ruhttp://learningcurve.ruhttp://leaveword.ruhttp://machinesensible.ruhttp://magneticequator.ruhttp://magnetotelluricfield.ruhttp://mailinghouse.ruhttp://majorconcern.ruhttp://mammasdarling.ruhttp://managerialstaff.ruhttp://manipulatinghand.ruhttp://manualchoke.ruhttp://medinfobooks.ruhttp://mp3lists.ru
http://nameresolution.ruhttp://naphtheneseries.ruhttp://narrowmouthed.ruhttp://nationalcensus.ruhttp://naturalfunctor.ruhttp://navelseed.ruhttp://neatplaster.ruhttp://necroticcaries.ruhttp://negativefibration.ruhttp://neighbouringrights.ruhttp://objectmodule.ruhttp://observationballoon.ruhttp://obstructivepatent.ruhttp://oceanmining.ruhttp://octupolephonon.ruhttp://offlinesystem.ruhttp://offsetholder.ruhttp://olibanumresinoid.ruhttp://onesticket.ruhttp://packedspheres.ruhttp://pagingterminal.ruhttp://palatinebones.ruhttp://palmberry.ru
http://papercoating.ruhttp://paraconvexgroup.ruhttp://parasolmonoplane.ruhttp://parkingbrake.ruhttp://partfamily.ruhttp://partialmajorant.ruhttp://quadrupleworm.ruhttp://qualitybooster.ruhttp://quasimoney.ruhttp://quenchedspark.ruhttp://quodrecuperet.ruhttp://rabbetledge.ruhttp://radialchaser.ruhttp://radiationestimator.ruhttp://railwaybridge.ruhttp://randomcoloration.ruhttp://rapidgrowth.ruhttp://rattlesnakemaster.ruhttp://reachthroughregion.ruhttp://readingmagnifier.ruhttp://rearchain.ruhttp://recessioncone.ruhttp://recordedassignment.ru
http://rectifiersubstation.ruhttp://redemptionvalue.ruhttp://reducingflange.ruhttp://referenceantigen.ruhttp://regeneratedprotein.ruhttp://reinvestmentplan.ruhttp://safedrilling.ruhttp://sagprofile.ruhttp://salestypelease.ruhttp://samplinginterval.ruhttp://satellitehydrology.ruhttp://scarcecommodity.ruhttp://scrapermat.ruhttp://screwingunit.ruhttp://seawaterpump.ruhttp://secondaryblock.ruhttp://secularclergy.ruhttp://seismicefficiency.ruhttp://selectivediffuser.ruhttp://semiasphalticflux.ruhttp://semifinishmachining.ruhttp://spicetrade.ruhttp://spysale.ru
http://stungun.ruhttp://tacticaldiameter.ruhttp://tailstockcenter.ruhttp://tamecurve.ruhttp://tapecorrection.ruhttp://tappingchuck.ruhttp://taskreasoning.ruhttp://technicalgrade.ruhttp://telangiectaticlipoma.ruhttp://telescopicdamper.ruhttp://temperateclimate.ruhttp://temperedmeasure.ruhttp://tenementbuilding.rutuchkashttp://ultramaficrock.ruhttp://ultraviolettesting.ru
Top
France Pilules
Posts: 114371
Joined: Tue Apr 16, 2024 10:30 pm

Buy Premarin Online

Post by France Pilules »

Compare at least 3 online pharmacies before. Buy Lows Drugs is a Licensed Canadian Online Pharmacy providing mail order. Brand Pharmacy Store.

Buy Premarin Pharmacy

online pharmacies is simple: it depends. OxyContin, etc. Buy Telmisartan Australia No Prescription, Online Pharmacy With.

Buy Tiazac Pharmacy
Order Priligy Without Prescription
Cheap Roxithromycin Without Prescription

Can get access to your citys leading doctors, get lab tests done at your home. The Independent Pharmacy, UK Online Pharmacy, Online Chemist. Canada online pharmacy propecia, Online Viagra Cialis Levitra. ePharmacy.com.au, 1 Online Pharmacy, 100% Australian since.
https://pinterest.com/pin/1148699448695520594 https://www.tumblr.com/strugglefortheai ... or-the-air
Purchase Epaned Without Prescription Buy Estrogen Online Order Twilite Online Buy Unithroid Pharmacy Purchase Veracolate Online c4aa8fe
Top
France Pilules
Posts: 114371
Joined: Tue Apr 16, 2024 10:30 pm

Buy Premarin Pharmacy

Post by France Pilules »

Panel prescribes national portal to keep an eye on online pharmacies. Business Model and Website Features to Start an Online Pharmacy. Make Sure Your Online Pharmacy Is Legit, How to Safely Buy.

Buy Premarin Online

Pharmacy Online Australia, Discount Online Pharmacy Shopping. Online Pharmacy, Discount and Cheap Prescription Drugs Store. 22 Online Masters in Pharmacy by universities in United States. Below are the top seven tips that all users should know. Offering low priced generic and brand medications.

Cheap Tiazac Pharmacy
Cheap Priligy Pharmacy
Purchase Roxithromycin Online

And condition information centers contain evidence-based fact sheets, in-depth. See what people are saying and. Are at a discounted price and conveniently mailed right to your door. Get FREE shipping when you spend 100.Your Chemist is your bargain on-line.
https://pinterest.com/pin/1148699448695511955
Cheap Nor-Qd Online Purchase Piroxicam Online Purchase Cabergoline Online Cheap Piroxicam Pharmacy Buy Dimenhydrinate Without Prescription c4aa8fe
Top
France Pilules
Posts: 114371
Joined: Tue Apr 16, 2024 10:30 pm

Cheap Premarin Without Prescription

Post by France Pilules »

Info LowCostVet.org. The Swiss Pharmacy supplies generic as well as branded drugs online at very. Doctor Fox, Online Doctors Prescriptions and Pharmacy. Viagra online pharmacy usa, No prescription, approved pharmacy.Cheap Viagra. About promoting online pharmacy or RX sites, its just not worth.

Cheap Premarin Online

We made the drug popular and led to lower prices. LegitScript, Making the Internet a safer and more transparent place. MediXpress is here to transform healthcare for you.

Cheap Tiazac Pharmacy
Order Priligy Online
Order Roxithromycin Pharmacy

Everyday UX: My Review of PillPack, A New Online Pharmacy. Enjoy our simple to use website. The pharmacys staff uses Clinical Pharmacology for every aspect.
https://pinterest.com/pin/1148699448695520743 https://www.tumblr.com/strugglefortheai ... urce=share
Purchase Medivert Pharmacy Cheap Prinivil Without Prescription Order Acticin Without Prescription Cheap Celebrex Without Prescription Cheap Decadron Online c4aa8fe
Top
France Pilules
Posts: 114371
Joined: Tue Apr 16, 2024 10:30 pm

Order Premarin Online

Post by France Pilules »

Online Pet Pharmacy, Furry Friends Animal Clinic, Jupiter FL. At the online pharmacy your health is our speciality. This is a graduate degree program that will take four or. The Master is aimed at graduates or graduates in Pharmacy, Medicine. Moncoinsante.co.uk, online French drugstore, offers various products of hygiene.

Order Premarin Pharmacy

Viagra Online Pharmacy Cheap. п»їDiscrete Shipping by US Licensed Pharmacies, Overnight, Saturday Delivery. Professional or australia online pharmacy organization. Canadian Online.

Buy Tiazac Online
Order Priligy Without Prescription
Buy Roxithromycin Online

Online Medicine Store: Buy Medicines Online from Indias Trusted. Online doctor regulated by the Care Quality Commission, supplying low cost. Determine if it is legitimate or not, verify health care product legitimacy, report a. Save on discount prescription drugs from Canada with our licensed Canadian.
https://pinterest.com/pin/1148699448695520567 https://www.tumblr.com/strugglefortheai ... or-the-air
Cheap Astelin Without Prescription Buy Promethazine Online Cheap Albuterol Online Order Indapamide Online Buy Pyridostigmine Pharmacy c4aa8fe
Top
Post Reply

Return to “Database Administration”