preload preload preload preload

Collecter des statistiques d'une base de données Oracle


Le mardi 02 juillet 2013 par madpellzo Oracle 67 commentaires
Cet article vous explique comment générer un beau rapport de statistiques sur une base de données Oracle. Le service de statistique Oracle collecte les stats toutes les heures (snapshot) par défaut. Nous allons extraire ces données sous forme d'une jolie page html grâce à AWR Report.

Se connecter à votre base avec le user sysdba. Nous prendrons pour exemple le nom d'instance "ORASID"

# export ORACLE_SID=ORASID
# sqlplus / as sysdba

Lancer AWR Report

SQL> @?/rdbms/admin/awrrpt


Sous quel format souhaitons-nous le rapport? Par défaut, html, presser la tocuhe entrée

Enter value for report_type:


Demande sur combien de jours on souhaite afficher les snapshots. Si vous tapez entrée, tous les snapshots seront affichés.

Enter value for num_days: 
Listing all Completed Snapshots
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
ORASID        ORASID            5873 23 Jun 2013 11:00      1
                               5874 23 Jun 2013 12:00      1
                               5875 23 Jun 2013 13:00      1
                               5876 23 Jun 2013 14:00      1
                               5877 23 Jun 2013 15:00      1
                               5878 23 Jun 2013 16:00      1
....
 6026 02 Jul 2013 12:10      1
                               6027 02 Jul 2013 13:00      1
                               6028 02 Jul 2013 14:00      1
                               6029 02 Jul 2013 15:00      1


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Tapez l'ID du snapshot à partir duquel on souhaite collecter les stats

Enter value for begin_snap: 6026
Begin Snapshot Id specified: 6026


Tapez ensuite l'ID du snapshot de fin:

Enter value for end_snap: 6029
End Snapshot Id specified: 6029


Rentrer enfin le nom du rapport. Par défaut, pour notre exemple, il s'appellera awrrpt_1_6026_6029.html) et sera stocké dans le répertoire courrant

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_6026_6029.html.  To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: Using the report name awrrpt_1_6026_6029.html


Votre rapport est près !

Si vous souhaitez déclencher vous même le snapshot pour borner dans le temps le rapport à votre convenance, toujours en tant que sysdba, exécutez la commande suivante:

SQL> exec dbms_workload_repository.create_snapshot();


Mots clés : aucun

  • Commentaires

  • Avatar Gravatar
     Judi Casino Online
     #1 Le 23 octobre 2017

    hey there and thank you for your information – I've
    definitely picked up something new from right here.

    I did however expertise some technical points using this site, as I experienced
    to reload the web site a lot of times previous to I could get it to load properly.

    I had been wondering if your hosting is OK? Not that I am complaining,
    but sluggish loading instances times will often affect your placement in google and could damage your quality score if advertising and marketing with Adwords.
    Well I am adding this RSS to my email and can look out
    for much more of your respective fascinating content.
    Ensure that you update this again very soon.

  • Avatar Gravatar
     Agen judi piala dunia
     #2 Le 27 octobre 2017

    My spouse and I absolutely love your blog and find almost
    all of your post's to be precisely what I'm looking for.

    Does one offer guest writers to write content to suit your needs?
    I wouldn't mind publishing a post or elaborating on some of the subjects you write about here.
    Again, awesome web site!

  • Avatar Gravatar
     Cblarchitecturalfiberglass.com
     #3 Le 06 novembre 2017

    Hi colleagues, its wonderful paragraph about tutoringand
    completely defined, keep it up all the time.

  • Avatar Gravatar
     Bandar Bola 168
     #4 Le 06 novembre 2017

    Awesome blog! Do you have any recommendations for aspiring writers?
    I'm planning to start my own website soon but I'm
    a little lost on everything. Would you recommend
    starting with a free platform like Wordpress or go for a paid option?
    There are so many options out there that I'm completely confused ..
    Any tips? Appreciate it!

  • Avatar Gravatar
     bola Tangkas
     #5 Le 23 novembre 2017

    There's certainly a lot to learn about this topic.

    I love all of the points you've made.

  • Avatar Gravatar
     backlink
     #6 Le 05 avril 2018

    I just like the helpful info yyou supply to your articles.

    I'll bookmark youur log and take a lok at again right here regularly.
    I am moderately sure I will be informed lots of new stuff right right here!
    Best off luck for the following!

  • Avatar Gravatar
     Bandarq Online
     #7 Le 09 avril 2018

    Yes! Fіnally someօne writes about dominoqq online.

  • Avatar Gravatar
     https://www.instagram.com/livescoreclub
     #8 Le 23 avril 2018

    Greetings from California! I'm bored to death at work so I decided to
    check out your blog on my iphonne during lunch break.
    I love the knowledge you present here and can't wait
    to take a look when I geet home. I'm surprised at how
    fast your blog loaded on my mobile .. I'm not even using WIFI, just
    3G .. Anyhow, wonderful site!

  • Avatar Gravatar
     asianbookie
     #9 Le 01 mai 2018

    Oh mу goodness! Amɑzing article dude! Thank you, However I am encountering issues with your RSS.
    I dߋn't know the reason why I am umable to join it. Is there anyone else
    having the same RSՏ issues? Anybody whho knows the solution can you kindlly respond?
    Thanks!!

  • Avatar Gravatar
     live skor bola
     #10 Le 03 mai 2018

    Ϝoor the reason that the admin off thiѕ weƄsite іs working, no hesitation very
    rapidlʏ it will be renowned, due to its ԛuality
    contеnts.

  • Avatar Gravatar
     prediksi paling jitu Brasil vs Swiss
     #11 Le 29 mai 2018

    Hi to all, how is the whole thing, I think every one is getting
    more from this web page, and your views are nice designed for new viewers.

  • Avatar Gravatar
     agen Judi Online
     #12 Le 07 juin 2018

    This is really interesting, You're an excessively skilled blogger.
    I have joined your rss feed and sit up for searching for more
    of your great post. Additionally, I have shared your web
    site in my social networks

  • Avatar Gravatar
     jasa backlink
     #13 Le 11 juin 2018

    Hi I am so thrilled I found your webpage, I really found you by
    error, while I was searching on Bing for something else, Anyways I am here now and would just like
    to say thank you for a marvelous post and a all round interesting blog (I also love the theme/design), I don’t have time to go
    through it all at the minute but I have saved it and also included
    your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the excellent b.

  • Avatar Gravatar
     Todd
     #14 Le 15 juin 2018

    І loved as much as you will receіve carried out rigһt here.
    The sketch is tasteful, your authored material stylish. nonetheless,
    үou command get Ьought an nervousness over that уou wish Ƅe delivering the following.
    unwell unquestіonably come further formerly again sіnce exactly the same
    nearly very often inside case you shield this increase.

  • Avatar Gravatar
     video sex indonesia
     #15 Le 15 juin 2018

    I have been exploring for a little bit for any high-quality articles or weblog posts on this kind of area
    . Exploring in Yahoo I ultimately stumbled upon this web site.

    Studying this info So i am glad to convey that I have a very good uncanny feeling
    I found out exactly what I needed. I such a lot undoubtedly will make sure to don?t disregard this website and
    provides it a glance on a continuing basis.

  • Avatar Gravatar
     Trevor
     #16 Le 15 juin 2018

    I like the helpful info you provide in your articles.
    I will bookmark your weblog and check again here regularly.
    I'm quite certain I will learn a lot of new
    stuff right here! Good luck for the next!

  • Avatar Gravatar
     Rodrick
     #17 Le 15 juin 2018

    Wiith havin so much written content do you ever run into
    any problems of plagorism or copyrigh violation? My blog has a lot of exclusive content I've either created myself
    or outsourced but it looks like a lot of it is popoing
    it up all over the web without my permission. Do you know any ways to help sgop content from being stolen? I'd certfainly appreciate it.

  • Avatar Gravatar
     koran bola
     #18 Le 15 juin 2018

    I'm really enjoying the design and layout of your site. It's a very easy on the eyes which makes
    it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme?

    Exceptional work!

  • Avatar Gravatar
     Joesph
     #19 Le 15 juin 2018

    Thanks for finally talking about >Collecter des statistiques d'une base
    de données Oracle - Madpellzo <Liked it!

  • Avatar Gravatar
     raja togel
     #20 Le 15 juin 2018

    Hi! I know this is kinda off topic but I was wondering which blog platform are you using for this website?
    I'm getting sick and tired of Wordpress because I've had
    issues with hackers and I'm looking at options for another platform.

    I would be great if you could point me in the direction of a good platform.

  • Avatar Gravatar
     dominobet2
     #21 Le 15 juin 2018

    Does your website have a contact page? I'm having problems locating
    it but, I'd like to send you an email. I've got some suggestions for your blog you might be interested in hearing.
    Either way, great blog and I look forward to seeing it
    improve over time.

  • Avatar Gravatar
     s128,s1288,s12888,daftar s128,agen s128,cara daftar s128
     #22 Le 15 juin 2018

    Hey would you mind stating which blog platform you're using?
    I'm looking to start my own blog in the near future but I'm having a tough time deciding between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design seems different then most blogs and I'm looking for something unique.
    P.S Sorry for being off-topic but I had to ask!

  • Avatar Gravatar
     download bokep baru
     #23 Le 18 juin 2018

    You really make it seem so easy with your presentation but I find this topic to
    be really something that I think I would never understand.
    It seems too complicated and very broad for me.
    I'm looking forward for your next post, I'll try to get the hang of it!

  • Avatar Gravatar
     BandarQ
     #24 Le 26 juin 2018

    Does your website have a contact page? I'm having trouble locating it but, I'd like to send you
    an e-mail. I've got some recommendations for your blog you might be interested in hearing.
    Either way, great website and I look forward too seeing it improve over time.

  • Avatar Gravatar
     Jonnie
     #25 Le 26 juin 2018

    Wow! After all I got a blog from where I can really obtaion valuable facts concerning mmy
    study and knowledge.

  • Avatar Gravatar
     Capsa Susun
     #26 Le 26 juin 2018

    Admiring the time andd energy you put into
    your website and in depth information you offer. It's great to come across
    a blog every once in a while that isn't the same unwahted rehashed information. Wonderful read!
    I've saved your site and I'm adding your RSS feeds to my Google account.

  • Avatar Gravatar
     http://marvicsupply.com
     #27 Le 27 juin 2018

    Great post but I was wanting to know if you could write a litte more on this subject?
    I'd be very grateful iff you could elaborate a little bit more.
    Cheers!

  • Avatar Gravatar
     Backlink Seo
     #28 Le 27 juin 2018

    Hi there! Do you know if they make any plugins to assist
    with SEO? I'm trying to get my blog to rank for some targeted keywords but I'm not seeing very good results.

    If you know of any please share. Thank you!

  • Avatar Gravatar
     Bandarq online
     #29 Le 28 juin 2018

    I visited many web sites but the audio feature for audio songs present
    at this website is truly wonderful.

  • Avatar Gravatar
     Capsa Susun
     #30 Le 28 juin 2018

    Heya i am for the primary time here. I fouynd this board and I to
    find It truly useful & itt helped me out a lot.
    I hope to offer something back and aid others like you helped me.

  • Avatar Gravatar
     QQ Online
     #31 Le 28 juin 2018

    Wow, this paragraph is nice, my younger sister iss nalyzing
    such things, so I am going to tell her.

  • Avatar Gravatar
     Capsa Susun
     #32 Le 28 juin 2018

    This is very interesting, You're a very skilled blogger.

    I've joined your rss feed and look forward to seeking more of your magnificent post.
    Also, I have shared your web site in my soicial networks!

  • Avatar Gravatar
     http://www.gpemax.com/
     #33 Le 28 juin 2018

    Touche. Soundd arguments. Keep upp thhe good effort.

  • Avatar Gravatar
     Alecia
     #34 Le 28 juin 2018

    At ths time it sounds like Movable Type is the preferred blogging platform out there right now.
    (from what I've read) Is that what you're using on your
    blog?

  • Avatar Gravatar
     DominoQQ
     #35 Le 28 juin 2018

    My brother recommended I might like this web site.
    He was totally right. This post actually made my day.
    You cann't imagine simply how much time I had sspent for this info!

    Thanks!

  • Avatar Gravatar
     AGUNGQQ
     #36 Le 29 juin 2018

    What's up, alll is going well here and ofcopurse ecery onne is sharing data,
    that's really fine, keep up writing.

  • Avatar Gravatar
     QQ Online
     #37 Le 30 juin 2018

    I used to be able to find good advice from your blog articles.

  • Avatar Gravatar
     BandarQ Online
     #38 Le 30 juin 2018

    Hi there everybody, here every one is sharing such knowledge, therefore it's nie
    to read this weblog, and I used to visit this web site daily.

  • Avatar Gravatar
     AGUNGQQ
     #39 Le 01 juillet 2018

    Hey would you mind letting me know which webhost you're using?
    I've loaded your blog in 3 completely different browsers and I must say this blog loads
    a lot fasfer then most. Can you recommend a good internet
    hosting provider at a fair price? Many thanks, I
    appreciate it!

  • Avatar Gravatar
     QQ Online
     #40 Le 04 juillet 2018

    It's actually a great and useful piece of information. I'm happy that you just shared this
    helpful info with us. Please stay us up to date like this.
    Thanks for sharing.

  • Avatar Gravatar
     asiabet66.net
     #41 Le 15 juillet 2018

    Write more, thats all I have to say. Literally,
    it seems as though you relied on the video to make your point.
    You definitely know what youre talking about, why
    waste your intelligence on just posting videos to your
    weblog when you could be giving us something
    enlightening to read?

  • Avatar Gravatar
     Linwood
     #42 Le 22 juillet 2018

    I know this if off topic but I'm looking into starting my own weblog and was curious what all is needed
    to get set up? I'm assuming having a blog like yours would cost a pretty penny?
    I'm not very web savvy so I'm not 100% sure. Any recommendations or advice would be greatly appreciated.

    Kudos

  • Avatar Gravatar
     beer777 mobile
     #43 Le 22 juillet 2018

    I do not even know how I stopped up here, however I thought this submit was good.
    I don't understand who you might be but definitely you are
    going to a famous blogger if you happen to aren't already.
    Cheers!

  • Avatar Gravatar
     fredatsauny.mihanblog.com
     #44 Le 22 juillet 2018

    I do agree with all of the ideas you've presented for your post.

    They're really convincing and will certainly work. Nonetheless, the posts are too
    short for newbies. May just you please lengthen them a little from next time?
    Thanks for the post.

  • Avatar Gravatar
     bokep hana anisa
     #45 Le 22 juillet 2018

    It is the best time to make some plans for the future and it's time to be happy.
    I have read this post and if I could I want to suggest you some interesting things or tips.

    Maybe you can write next articles referring to this article.

    I desire to read more things about it!

  • Avatar Gravatar
     daftar game togel
     #46 Le 23 juillet 2018

    Nice response in return of this difficulty with solid arguments and explaining everything
    concerning that.

  • Avatar Gravatar
     Hilario
     #47 Le 23 juillet 2018

    I pay a visit daily a few websites and websites to read content, but this webpage gives feature based posts.

  • Avatar Gravatar
     Kathi
     #48 Le 23 juillet 2018

    Hey! 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 results.
    If you know of any please share. Many thanks!

  • Avatar Gravatar
     Lida
     #49 Le 23 juillet 2018

    Quality postts is the main to attract the people to visit the site, that's what
    this site is providing.

  • Avatar Gravatar
     togel angka jadi
     #50 Le 23 juillet 2018

    I'm extremely pleased to discover this web site. I wanted to thank you
    for ones time for this particularly fantastic read!!
    I definitely liked every little bit of it and i also have you book marked
    to check out new things in your site.

  • Avatar Gravatar
     Connor
     #51 Le 23 juillet 2018

    It's truly very complex in this full of activity life
    to listen news on TV, thus I only use the web for that reason,
    and get the hottest news.

  • Avatar Gravatar
     nagasaon minggu
     #52 Le 24 juillet 2018

    This paragraph is genuinely a pleasant one it helps new web viewers, who are wishing
    in favor of blogging.

  • Avatar Gravatar
     totobet
     #53 Le 24 juillet 2018

    Hello there! Do you use Twitter? I'd like to follow you if that would be ok.
    I'm undoubtedly enjoying your blog and look forward to new posts.

  • Avatar Gravatar
     prediksi togel hk
     #54 Le 25 juillet 2018

    Just wish tto say yiur article is as amazing. The clarity in your
    submit is simply excellent and i could think you're a professional in this subject.
    Well together with your permission let me too take hold
    of yur RSS feed tto stay up to dawte with drawing close post.
    Thanks 1,000,000 and please kee upp the gratifying work.

  • Avatar Gravatar
     nagasaon minggu
     #55 Le 25 juillet 2018

    I get pleasure from, lead to I found just what I used to be having a look for.

    You've ended my four day lengthy hunt! God Bless you man. Have a great day.
    Bye

  • Avatar Gravatar
     Bandarq Online
     #56 Le 26 juillet 2018

    Very nice post. I simply stumbled upon your blog and wished to mention that I have truly enjoyed surfing around your blog
    posts. After all I'll be subscribing to your rss feed and
    I am hoping you write once more very soon!

  • Avatar Gravatar
     domino99
     #57 Le 28 juillet 2018

    You've made some really good points there. I checked on the
    web for more information about the issue and
    found most people will go along with your views on this
    website.

  • Avatar Gravatar
     data Sgp
     #58 Le 28 juillet 2018

    Thanks for the auspicious writeup. It if truth be told used
    to be a enjoyment account it. Look complicated to more introduced agreeable from you!

    However, how can we communicate?

  • Avatar Gravatar
     Judi online
     #59 Le 29 juillet 2018

    This is very interesting, You are a very skilled blogger.

    I have joined your rss feed and look forward to seeking more of your great post.

    Also, I have shared your website in my social networks!

  • Avatar Gravatar
     Poker Online
     #60 Le 29 juillet 2018

    I feel that is among the most significant information for
    me. And i am satisfied studying your article. But should statement on some normal things, The site taste is wonderful, the
    articles is actually nice : D. Good job, cheers

  • Avatar Gravatar
     bandarqq
     #61 Le 29 juillet 2018

    What's up to every one, the contents present at this web page are genuinely amazing for
    people experience, well, keep up the nice work fellows.

  • Avatar Gravatar
     Poker Online
     #62 Le 30 juillet 2018

    For latest news you have to pay a visit world-wide-web and on world-wide-web I
    found this website as a most excellent site for most recent updates.

  • Avatar Gravatar
     Togel Hongkong
     #63 Le 03 août 2018

    It's very straightforward to find out any topic on web as compared
    to books, as I found this paragraph at this web page.

  • Avatar Gravatar
     Judi togel
     #64 Le 06 août 2018

    Hi tһere I am so glad I found your site, I reɑⅼly found you by error,
    whiⅼe I was resеafching on Yɑhoo for something else, Regardless I am here now and would juyst like to
    say thank you for a гemarkaƅle post and a all round exciting blog (I also love tһe theme/design),
    I don’t haѵе time to read throսgh it all at the momkent but I have bօokmarked it and аⅼso added in your RSS feeds, so
    when I have time I wіll ƅe back to read a lot more, Please do keep
    uр the superb jo.

  • Avatar Gravatar
     dominobet
     #65 Le 08 août 2018

    I'm amazed, I must say. Seldom do I encounter a blog
    that's both educative and amusing, and let me tell
    you, you've hit the nail on the head. The issue is an issue
    that not enough men and women are speaking intelligently about.

    I am very happy that I stumbled across this during my search for something regarding this.

  • Avatar Gravatar
     Qq online
     #66 Le 11 août 2018

    Ɗefinitely believe that which you saiԀ.
    Your favorite reason seemed to be on the web
    the sіmplest thing to be awar of. I ssay to you, I certainly gett annoyed whiⅼe
    people think aƅout worries that they just don't know about.

    Yⲟu managed to hit the nail upon the top and defined out thе
    whole thing without haѵing side-effects , people could taқe a signal.
    Will likеly be back to get more. Thanks

  • Avatar Gravatar
     www.Gem365.Cn
     #67 Le 16 août 2018

    I think tһat what you said maԀe a lot of sense.
    But, wᴡhat about this? what if you were tⲟ create a killer title?

    I am not suggesting your information is not solid, but what if you aԁded a рost title thɑt makes peoρle desire more?
    I mean Collecter dess statistiques d&#039;une base
    dde données Oracle - Madpellzo is a little plain.
    You coᥙlɗ look ɑt Υahoo's hߋme page and see how they create post titles to get viewers interested.
    You migһt try adding a video or a picture or two to get rеaders interested about everything've
    got to say. Just my opiniоn, it would bring your blog
    a little livelier.

  • Ecrire un commentaire








    Quelle est la troisième lettre du mot znbw ?