preload preload preload preload

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


Le mardi 02 juillet 2013 par madpellzo Oracle 23 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!

  • Ecrire un commentaire








    Quelle est la dernière lettre du mot glajmf ?