Tuesday, August 16, 2011

Monitoring redo log switches

You can use the below query to find-out the number of redo log switches per hour in a day: -


select to_char(first_time,'DD-MON') day,  

sum(decode(to_char(first_time,'hh24'),'00',1,0)) "00",  
sum(decode(to_char(first_time,'hh24'),'01',1,0)) "01",  
sum(decode(to_char(first_time,'hh24'),'02',1,0)) "02",  
sum(decode(to_char(first_time,'hh24'),'03',1,0)) "03",  
sum(decode(to_char(first_time,'hh24'),'04',1,0)) "04",  
sum(decode(to_char(first_time,'hh24'),'05',1,0)) "05",  
sum(decode(to_char(first_time,'hh24'),'06',1,0)) "06",  
sum(decode(to_char(first_time,'hh24'),'07',1,0)) "07",  
sum(decode(to_char(first_time,'hh24'),'08',1,0)) "08",  
sum(decode(to_char(first_time,'hh24'),'09',1,0)) "09",  
sum(decode(to_char(first_time,'hh24'),'10',1,0)) "10",  
sum(decode(to_char(first_time,'hh24'),'11',1,0)) "11",  
sum(decode(to_char(first_time,'hh24'),'12',1,0)) "12",  
sum(decode(to_char(first_time,'hh24'),'13',1,0)) "13",  
sum(decode(to_char(first_time,'hh24'),'14',1,0)) "14",  
sum(decode(to_char(first_time,'hh24'),'15',1,0)) "15",  
sum(decode(to_char(first_time,'hh24'),'16',1,0)) "16",  
sum(decode(to_char(first_time,'hh24'),'17',1,0)) "17",  
sum(decode(to_char(first_time,'hh24'),'18',1,0)) "18",  
sum(decode(to_char(first_time,'hh24'),'19',1,0)) "19",  
sum(decode(to_char(first_time,'hh24'),'20',1,0)) "20",  
sum(decode(to_char(first_time,'hh24'),'21',1,0)) "21",  
sum(decode(to_char(first_time,'hh24'),'22',1,0)) "22",  
sum(decode(to_char(first_time,'hh24'),'23',1,0)) "23",  
count(to_char(first_time,'MM-DD')) Switches_per_day  
from v$log_history  
where trunc(first_time) between trunc(sysdate) - 6 and trunc(sysdate)  
group by to_char(first_time,'DD-MON')   
order by to_char(first_time,'DD-MON') ;  


Output would be like this : -





Enjoy:-)

53 comments:

Anonymous said...

Good day! Do you know if they make any plugins to help with

Search Engine Optimization? I'm trying to get my blog to rank for some targeted keywords but I'm not seeing very good

success. If you know of any please share. Cheers!
Feel free to surf my page : subtribe

Anonymous said...

Hi there! Would you mind if I share your blog with my facebook group?
There's a lot of people that I think would really appreciate your content.

Please let me know. Many thanks
Also visit my site : http://www.thespainforum.com/f204/

Anonymous said...

I was just looking for this information for some time.
After 6 hours of

continuous Googleing, finally I got it in your site. I wonder what is the lack of

Google strategy that don't rank this type of informative sites in top of the list.

Normally the top websites are full of garbage.
My site: space wallpaper photography

Anonymous said...

Excellent post. I was checking constantly this blog and I'm impressed! Extremely

useful information specially the last part :) I care for such info a lot. I was seeking this particular information for a long time. Thank you and good luck.
My site - fishingspain.net

Anonymous said...

Pretty section of content. I just stumbled upon your site and in accession

capital to assert that I get in fact enjoyed account your blog posts.
Anyway I’ll

be subscribing to your augment and even I achievement you access consistently rapidly.
Also visit my web page : http://www.trjettyfuneralhomeinc.com

Anonymous said...

It's a pity you don't have a donate button! I'd without a doubt donate to

this superb blog! I suppose for now i'll settle for book-marking and adding your RSS feed to my Google account.

I look forward to brand new updates and will talk

about this blog with my Facebook group. Talk soon!
Here is my homepage - hackerspace.nawaat.org

Anonymous said...

I’m no longer certain the place you are getting your

information, however great topic. I must spend some time learning


much more or working out more. Thanks for

magnificent info I was searching for

this info for my mission.
Also see my web page: More Help

Anonymous said...

This really answered my drawback, thanks!
Feel free to visit my webpage - http://en.netlog.com/

Anonymous said...

The subsequent time I read a weblog, I hope that it doesnt disappoint me as much as this one.
I mean, I do know it was my choice to learn, but I

really thought youd have one thing interesting to say. All I

hear is a bunch of whining about one thing that you might fix if you happen

to werent too busy searching for attention.
Also see my web page :: their

Anonymous said...

Excellent items from you, man. I've take into accout your stuff

prior to and you're simply extremely wonderful. I actually like what you have obtained right here,

certainly like what you're stating and the way wherein you assert it. You're making


it enjoyable and you still care for to keep it

wise. I can't wait to learn much more from you. That is actually a

terrific site.
Have a look at my website : rallylink

Anonymous said...

It is appropriate time to make some plans for the future and it is time to be happy.
I've read this post and if I could I desire to suggest you few interesting things or

tips. Perhaps you can write next articles referring to this article. I wish

to read even more things about it!
Here is my web blog ; customer support solution

Anonymous said...

Wonderful work! That is the type of info that are supposed to be shared across the internet.

Shame on the

search engines for now not positioning this post upper!
Come on

over and talk over with my website . Thanks

=)
my web page > wiki.dsmu.edu.ua

Anonymous said...

Magnificent website. Lots of useful information here.
I am sending it to some pals ans also sharing in delicious.
And certainly, thank you for your sweat!

Also visit my site ... http://www.tempsde.punttic.cat/wiki/index.php?title=Thinking_About_Quick_Methods_In_Ultimate_Demon
my web site: Organic Seo

Anonymous said...

What's up to every body, it's my first visit of this blog; this blog carries amazing
and in fact fine material in support of visitors.

Also visit my site ... degogo.de

Anonymous said...

First off I would like to say superb blog! I had a quick question that I'd like to ask if you do not mind. I was interested to know how you center yourself and clear your head before writing. I have had difficulty clearing my thoughts in getting my thoughts out. I do take pleasure in writing but it just seems like the first 10 to 15 minutes tend to be wasted simply just trying to figure out how to begin. Any ideas or hints? Cheers!

Here is my site :: http://villwockweb.de/
Also see my web site :: flood insurance

Anonymous said...

Very great post. I simply stumbled upon your weblog and wanted to say that I have really enjoyed
surfing around your blog posts. In any case I will be subscribing for
your feed and I am hoping you write once more very
soon!

My site: Writing Online
My site - online businesses

Anonymous said...

Have you ever thought about adding a little bit more than just your
articles? I mean, what you say is important and all.
However think about if you added some great pictures or videos
to give your posts more, "pop"! Your content is excellent but with pics and
videos, this site could definitely be one of the greatest in its niche.
Excellent blog!

Also visit my webpage; sales seo

Anonymous said...

Having read this I believed it was extremely informative.
I appreciate you taking the time and effort to put this short article together.
I once again find myself personally spending a significant amount
of time both reading and posting comments. But so what,
it was still worthwhile!

my blog; marketing techniques

Anonymous said...

I will immediately grab your rss feed as I

can't in finding your email subscription hyperlink or newsletter service. Do

you have any? Kindly allow me recognise in

order that I may just subscribe. Thanks.
my webpage > www.mase7e.com

Anonymous said...

I have recently started a web site, the info you provide on this website has helped me greatly.
Thanks for all of your time & work.
My web site - tournai-ecolo.be

Anonymous said...

I'm not certain the place you're getting your information, however good
topic. I must spend a while finding out more or figuring out more.
Thanks for wonderful information I was on the lookout for this information for my mission.


Also visit my web site therapy quit smoking
Also see my web page :: afroglobe.net

Anonymous said...

Hi there, just turned into alert to your blog thru Google, and located that it's really informative. I’m gonna

be careful for brussels. I will be grateful when you continue this in future. A lot of folks will likely be benefited

out of your writing. Cheers!
My web site ... http://Juanboulter.com/media/school-13-игрооргии-эпизод-21-skyrim-d3-media

Anonymous said...

Hmm it appears like your site ate my first comment (it was super
long) so I guess

I'll just sum it up what I had written and say, I'm thoroughly enjoying your blog.
I too am an

aspiring blog blogger but I'm still new to everything. Do you have any

recommendations for rookie blog

writers? I'd certainly appreciate it.
Here is my page ... http://socialcircle.stock-options-picks.com/story.php?title=everything-at-one-click-b-

Anonymous said...

Thank you a lot for sharing this with all folks you
really recognize what you are speaking about!

Bookmarked. Kindly

also seek advice from my site =). We

will have a link change agreement among us!
Also see my web page - senas.sklandymas.lt

Anonymous said...

advertising and ***********

with Adwords. Well I am adding this RSS to my e-mail
and can glance out

for a lot more of your respective interesting content. Ensure

that you update this again very soon..
Look into my homepage ... timeboy.pixnet.net

Anonymous said...

I've been browsing on-line greater than three hours as of late, yet I never discovered any interesting article like yours. It’s beautiful worth enough for me. In my

opinion, if all site owners and bloggers made excellent content as you did, the net might

be a lot more helpful than ever before.
Feel free to surf my blog :: jinovsvet.com

Anonymous said...

Hi there, I found your site via Google while looking for a related topic,

your website came up, it looks good. I have bookmarked it in my
google bookmarks.
Here is my web-site : http://socialcircle.stock-options-picks.com/story.php?title=a-mind-full-of-questions-but-a-teacher-in-my-soul-edens-rose-foundation-2

Anonymous said...

Great weblog right here! Also your site quite a bit up fast!
What web host are you using? Can

I get your associate link in your host? I desire my web site loaded up as fast as yours lol

my homepage blogspot.com
my web site > Www.Attractwomen.com

Anonymous said...

Thank you for another wonderful

post. Where else may anybody get that kind of information

in such a perfect approach of writing? I've a presentation next

week, and I'm at the look for such information.
Also visit my blog post : new-york-city.italiangreyhound.us

Anonymous said...

Nice post. I was checking constantly this blog and I am impressed!
Very

helpful info specially the last part :) I care for such

information a lot. I was seeking this particular info for
a long time. Thank you and best of luck.
My web page > http://www.ringsidenews.com/

Anonymous said...

I think this is among the most important information for me.

And i am glad reading your article. But want to remark on some general things, The website style is
ideal, the articles is really excellent : D.
Good job, cheers

Here is my web page colombian coffee beans

Anonymous said...

I believe that is one of the so much important


info for me. And i am happy studying your article. But wanna remark
on few basic issues, The

web site taste is perfect, the articles is in reality nice : D.

Good task, cheers
My page :: www.linksbang.com

Anonymous said...

That is very attention-grabbing, You're an excessively skilled blogger. I have joined your feed and look ahead to looking for more of your

wonderful post. Also, I've shared your site in

my social networks!
My site > authenticlinks.com

Anonymous said...

There is apparently a lot to know about this.
I consider you made certain nice points in

features also.
my website - robygiup.blogspot.fr

Anonymous said...

That is the proper

weblog for anybody who wants to search out out about this topic.
You

understand a lot its virtually exhausting to

argue with you (not that I truly would need…HaHa). You definitely
put a

new spin on a topic thats been written about for years.
Great stuff, just great!
Feel free to surf my web-site skeletonadventures.com

Unknown said...

Really great work, I think this post would like to participate in thinking that this is a blog good very good anyway.
Oracle SQL

Anonymous said...

I cherished up to you'll receive carried out

proper here. The sketch is tasteful, your authored subject matter

stylish. nonetheless, you command get bought an edginess

over that you would like be delivering the following. in poor health unquestionably come more previously again

as exactly the same nearly very continuously within case you defend this hike.

Visit my web page; sahelweb.com

Anonymous said...

I have learn some good stuff here. Certainly

value bookmarking for revisiting. I wonder how much attempt you put to make
this kind of magnificent informative web site.



my web blog; navalady.in

Anonymous said...

Heya! I'm at work browsing your blog from my new apple iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Carry on the superb work!

Feel free to visit my page :: best weight loss diet

Anonymous said...

http://hermessale.finniwolf.com Luamkxx http://hermessale.finniwolf.com hermes birkin replica birkin hermes next you just put the machine golf bag outside to be waterless. front side encapsulate features a brilliant colorized illustration hermes assortment of the nightmare Baby taken from within the hermes nl manga, I have no idea if it actually was hermes 24 faubourg the address an individual. having said that others want to relieve constant worry, fatigue or a depressive disorder every one of views which were remarkably primary during special occasions,

Anonymous said...

With havin so much content do you ever run into any issues of plagorism

or copyright violation? My website has a lot of
completely unique content

I've either created myself or outsourced but it seems a lot of it is popping it up

all over the internet without my permission. Do you know any

methods to help reduce content from being stolen? I'd certainly appreciate
it.

Feel free to visit my page; http://facultea.com/profile/BasiliaStevens1984

Anonymous said...

Just desire to say your article is as astonishing. The


clearness in your put up is just

excellent and that i can suppose you're an expert in this subject. Fine together with your permission

allow me to take hold of your feed to keep updated

with imminent post. Thanks 1,000,000 and please carry on the gratifying work.

Feel free to visit my blog - www.bookmarkeasy.net

Anonymous said...

Paragraph writing is also a fun, if you know after that
you can write otherwise it is complex to write.

Also visit my webpage ... ford ranger forum

Anonymous said...

This post will assist the internet users for building up new web site or even a blog from start to end.


Review my blog post :: http://www.greyscustomgold.com/a-guide-to-sensible-modcloth-coupon-solutions/

Anonymous said...

Hi! I am a digital marketer. The previous seo guy working for my client left a spammy comment at your blog with the username Rosemarie Rana which links to my client's site.
Such comments are or might cause serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
If you don't remove it by 11:59 pm, Pacific Standard Time, 3rd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.

Anonymous said...

Pretty element of content. I simply stumbled upon your weblog and in accession capital to claim that I acquire actually loved account your blog posts.

Any way I'll be subscribing for your feeds and even I success you get entry to constantly rapidly.


Also visit my web page :: money robot

raybanoutlet001 said...

gucci shoes
ugg outlet
ugg outlet
versace jeans
michael kors handbags
bills jerseys
coach factory outlet
true religion outlet
pandora outlet
polo ralph lauren

jeje said...

kyrie irving shoes
jordan 13
adidas outlet
air jordan 11
adidas nmd
jordan retro
longchamp handbags
lacoste online shop
birkin bag
adidas eqt support adv

mohamed said...



تركيب الجبسشركة سحر اللمسات
- شركة تشطيبات -



مصمم ديكور
معلم دهانات بالرياض ت
ا

5689 said...

zzzzz2018.8.31
moncler online outlet
pandora
ferragamo shoes
pandora charms outlet
vibram five fingers
adidas football soldes
louboutin shoes
nike factory store
kate spade outlet online
mbt shoes outlet

Unknown said...

golden goose outlet
fila sneakers
adidas stan smith
golden goose sneakers
paul george shoes
yeezy boost 350
fila
yeezy boost 350
jordan sneakers
nike epic react

John said...

hermes
michael kors outlet clearance
ugg boots women
air jordan 14
coach outlet sale
hydro flask lids
canada goose outlet
christian louboutin sale
miu miu handbags
cheap snapbacks
yolo

yanmaneee said...

golden goose
goyard handbags
golden goose
golden goose
golden goose
golden goose outlet
moncler jackets
goyard
adidas yeezy
goyard