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:-)
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:
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
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/
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
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
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
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
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
This really answered my drawback, thanks!
Feel free to visit my webpage - http://en.netlog.com/
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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-
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
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
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
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
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
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
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/
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
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
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
There is apparently a lot to know about this.
I consider you made certain nice points in
features also.
my website - robygiup.blogspot.fr
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
Really great work, I think this post would like to participate in thinking that this is a blog good very good anyway.
Oracle SQL
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
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
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
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,
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
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
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
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/
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.
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
gucci shoes
ugg outlet
ugg outlet
versace jeans
michael kors handbags
bills jerseys
coach factory outlet
true religion outlet
pandora outlet
polo ralph lauren
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
تركيب الجبسشركة سحر اللمسات
- شركة تشطيبات -
مصمم ديكور
معلم دهانات بالرياض ت
ا
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
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
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
golden goose
goyard handbags
golden goose
golden goose
golden goose
golden goose outlet
moncler jackets
goyard
adidas yeezy
goyard
Post a Comment