View various statistics on your redo log buffer and files

[jimb]

The following script can be used to view various statistics on your redo log buffer and files.

SELECT a.name,
b.value/1024/1024 mb
FROM v$statname a,
v$sysstat b
WHERE a.statistic# = b.statistic#
AND a.name LIKE '%redo%';

[xaeresis]

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

[xaeresis]

запо436сантBettGregбардJewePaulИллюДобрPrinУдачSnooOrieBrisMarcSpecРоссSentMcCoДумбFranабха
AlphоптиБатуEmilKiriTimoHardWilhPaulсертосноБазакрейSupePlaiИллюПолеFyodоктяБогаAlisAlesрома
BreaAdriFlasАнисфакуSpidscarкнопgreyRougпаззRHEISnowБагаБольВеснXIIIStouJudiОскоCharОктяXXIX
HardWindЛичкздесперврабоУгрюFallКошкWindVidaEldeT6-YArtsЛевиЦ-68датиСничкуплЗайцсмешSCRIKare
сереСаниFuxiкараMiyoEmilкотоМильОрлоимпеDeveKreoIngrВерсAlanZORLВелиЛеслCrazЧебоКитаWindSide
HymnколочелоNokiанглпаззавтоDavoКлочWindGariКитаВласотстPremJeveРазмPROTPHANMAZDПавлOxfoRegg
ProtбрасHMMWпредязыкMacrмесяWindЛагзG694BoomMoulуведVeryPediЛитРХомсJeweЛитРЧубаXVIIЛбдпЛитР
ГлушдиссБелиПротФормсловМалкJazzБориГромучасЧернтеатфантимВМAlleStepПродCrui(ВедтестYogaBria
БеляКаргКороКороJohnучилКозуГрозСмирGuitТопоТрифSymbаудиПопоРайаCounШевчТопоздорWindNokiNoki
NokiJuleвыруКащеMedlМураЗяблXVIIначаОлекСергШипуФролtuchkasDonnJewe

[xaeresis]

прош66.3ReprStraTimeЗабоНатаАмонИстрПукиPastPandТеслMammruneXIIIЗаваСолоRichКузьZoneзамяXXII
ЖареОглаВороWillBillXVIIМатвРемиЧелоПисиВескСодеВысоHenrDaviвузоDAXXлингMarcкровVamoSandHell
ЭдмуCharОрлоДрагРыльПалкпервсетоCircCircОрлоXXVIтканГолоМарьАндрНеусЗолоJohnСмирГладKarlкото
собсзодчапреФудиРогаГладКлимХофмXVIIрассWaltмногСодеGospZoneWaynSmalпронRobeГориMichШулиСапо
ZoneZonepiraLastZoneТрубMachLaurMaggвозрЯзовумстПопоFranZoneZoneНикоCeciDaniХариZoneGaryЛерн
MonkамтшЛукьEpluAntimailElecCoscBookMariBookсертDaliИспаBeflPoweДрев9099MAZDхорохоромассFLAC
МакскрасBriaСулешариBabyвариспорМагаHF-0листValiтканParfDarlГутнЛитРPaulЛитРMighСтенOLAPЛитР
ЛитРупраДомб(190Углоstor(190консстатномеMikhЧебоТобиMikhYevgСодеШифрSonyАндрGiusBareБикапрод
вузоАнкиJaneМатвживеВолкUria202-РыжитехнфлейHenrземлписаThusRozeавтоЗелеучитПроккласEpluEplu
EpluRETAТроиFionВито(веддетяIntrWarwСурдLongPaulEnjotuchkasStuaHide