How to Read Oracle AWR Report | Oracle Automatic Workload Repository

Поділитися
Вставка
  • Опубліковано 29 лис 2024

КОМЕНТАРІ • 101

  • @shaileshsondawale8765
    @shaileshsondawale8765 5 років тому +5

    Wow..What a wonderful way AWR report explained here.. Excellent..!!!

  • @gourangapaul9623
    @gourangapaul9623 4 роки тому +4

    Very well explained. Ur way of explaining things are really appreciable.

  • @rominmaharjan2392
    @rominmaharjan2392 4 роки тому +4

    thank you very much. The examples and explanations were awesome. expecting more video and webinar

    • @dbagenesis
      @dbagenesis  4 роки тому +2

      We are all geared for same!

  • @kruttam76
    @kruttam76 3 роки тому +2

    Thanks Arun, appreciate your effort to explain AWR Report, It was very helpful for me for job responsibility, but at the same time expectation is more, pls create more session on AWR and most optimize oracle database configuration.

  • @cryptoseries3259
    @cryptoseries3259 2 роки тому +1

    This guy is very good in this analysis! Thank You!

  • @hanumankrishna03
    @hanumankrishna03 4 роки тому +5

    Excellent Explanation ,Crystal clear.

  • @pavankumarpatil7782
    @pavankumarpatil7782 2 роки тому +1

    Awesome ❤️❤️❤️❤️. You have lots of patience.. 🙏🙏🙏. Thank you for your time. 🙏

  • @ale.9479
    @ale.9479 3 роки тому +2

    I am totally impressed by this explanation. Thank you guys

  • @lovelyanil9776
    @lovelyanil9776 5 років тому +7

    Nice explanation 👌 I have one doubt let consider if in my db lot of schams are thare how can I find who running that huge query?

  • @nasarkhan8956
    @nasarkhan8956 3 роки тому +1

    Your videos give confidence.

  • @nmadhuleo
    @nmadhuleo 4 роки тому +2

    Thank you So much...very clean explanation on how to analyse AWR reports..

  • @mahmudurkhan5754
    @mahmudurkhan5754 5 років тому +1

    Excellent, Excellent and Excellent, please keep continue sir

  • @Wantedmamwt
    @Wantedmamwt Місяць тому

    Very good insightful

  • @santhoshkumaradhinarayanan9192
    @santhoshkumaradhinarayanan9192 5 років тому +2

    Its very useful to understand AWR Report.

  • @mahesh667
    @mahesh667 3 роки тому +1

    Excellent explanation, you are awesome. Keep it up

  • @veeru758
    @veeru758 4 роки тому +1

    Excellent Explanation with patience...

  • @binujaaugustine2682
    @binujaaugustine2682 3 роки тому +1

    crystal clear explanation

  • @maddireddysanapureddy2111
    @maddireddysanapureddy2111 2 роки тому +1

    Great people's are born in the woombs the great ones

  • @vishnutirthe6579
    @vishnutirthe6579 3 роки тому +1

    Awesome, very helpful. Thank you😊

  • @arifansari42
    @arifansari42 5 років тому +4

    Thank you so much for all....

  • @madhusudanaraonallamothu2792
    @madhusudanaraonallamothu2792 4 роки тому +1

    Thank you Very much for sharing knowledge. It’s very helpful .

  • @sandeepbhatia2298
    @sandeepbhatia2298 3 роки тому +1

    Great 👍 , good explanation

  • @balajiguduru9783
    @balajiguduru9783 4 роки тому +2

    Thank you... Good information which will surely help

  • @dineshtutorialhindi
    @dineshtutorialhindi 4 роки тому

    Excellent. I became your fan with this video.

    • @dbagenesis
      @dbagenesis  4 роки тому

      Many many thanks

    • @dineshtutorialhindi
      @dineshtutorialhindi 4 роки тому

      I was thinking that generating and understanding the AWR report is very difficult and complex. But, this video made me very clear in one shot.
      I have a request for you. Kindly upload videos for performance tuning. I got stuck in every interview when they ask about the performance tuning. Can you please guide step step from where to start the tuning of an existing code or sql. The various techniques that can be applied to solve a problem.
      Thank you in advance.

  • @vasilijzajcev7579
    @vasilijzajcev7579 2 роки тому +1

    Very helpful, thanks

    • @dbagenesis
      @dbagenesis  2 роки тому +1

      Thank you, Keep watching!

  • @gbrajes
    @gbrajes 3 роки тому +1

    Very informative..!!

  • @iamharisai
    @iamharisai 4 роки тому +2

    Thanks for the informative video

  • @mohammeduddin2117
    @mohammeduddin2117 3 роки тому +1

    Great, Arun, awesome,

  • @ritikarao6112
    @ritikarao6112 4 роки тому +2

    I have one question. If DB chache size is 2gb and i want to update 10gb data in DB , will the job be successsfull ???

    • @dbagenesis
      @dbagenesis  3 роки тому +2

      You must have space in tablespace to accommodate new data you loading.

  • @sai219cr
    @sai219cr 4 роки тому +1

    Very nicely explained..👏

  • @shayansarkar7570
    @shayansarkar7570 Рік тому

    Hi Arun: I have a Question!
    Like I got a perf issue where a migration script command was run in Dev env and it ran for almost 1 hrs and completed successfully. Now the same command was run on Staging (with the same infra configuration and indexes), it got stuck and took more than 10+ hrs and isn't getting completed. Checking Locks, ASH, and AWR didn't find a solution. What could be the possibilities for this issue?

  • @VMI33
    @VMI33 5 років тому +1

    when talking about increasing instance(as you check whether or not the instance needs to be tunned)....what specific parameter are you referring to? Thank you.

    • @dbagenesis
      @dbagenesis  5 років тому +1

      The instance specific %'s define if instance needs to be tuned.

    • @kaarmugilananddhivyesh241
      @kaarmugilananddhivyesh241 4 роки тому

      Instance is nothing but sga +bg process so there should be sga size to increase or decrese depentents on the statistics of awr analysis he mean to say i guess

  • @karanchauhan7316
    @karanchauhan7316 4 роки тому +1

    Hey can you explain a bit about DB CPU wait event and what to do to fix it. It is coming at the top of the Top 10 Foreground Events by Total Wait Time with 46.6K Total Wait Time (sec)

    • @nagababu9009
      @nagababu9009 4 роки тому

      Facing same issue any solution

  • @Hanzala_khan80
    @Hanzala_khan80 Рік тому

    Soo good analysis 👍

  • @travelingengineer7649
    @travelingengineer7649 3 роки тому

    My tomcat server is slow since few days now. I have the awr report.. i am just a beginner can you please help me. Which part of report i should take a look at in order to find root cause of slowness

  • @anandkanawade9895
    @anandkanawade9895 4 роки тому +1

    awesome explanation..Thank you
    please make video about statspack for oracle SE.

  • @Neellas
    @Neellas 3 роки тому +1

    Hi, very clean explanation.
    I have a question, if in Top 10 Foreground Events by Total Wait Time, my first event is DB CPU with %DB TIME 69.2 and total wait time (sec) is 55.3k, should I consider a problem?
    In the second event is latch free with %DB Time 7.7 and total wait time (sec) is 6187.6. What should I do with latch free, please?

  • @stablekaunglay1538
    @stablekaunglay1538 4 роки тому +2

    Why is AWR Report time late than system time? how many hours it will be late than system time?

    • @dbagenesis
      @dbagenesis  4 роки тому +1

      Are you comparing my WINDOWS machine time with AWR time? The AWR report will be generated as per the Linux server time. Probably Linux machine time might be different, in my case.

    • @stablekaunglay1538
      @stablekaunglay1538 4 роки тому

      @@dbagenesis
      how to generate AWR report with 30 min interval?

  • @dimithegreatest
    @dimithegreatest 4 роки тому +1

    Really good! Informative

  • @ziadfawzi
    @ziadfawzi Рік тому +1

    Thank you.

  • @antonrybakov85
    @antonrybakov85 4 роки тому +1

    Great. Very useful. Thank you!

  • @hwrvefokou5540
    @hwrvefokou5540 4 роки тому +2

    DBA Genesis, best ever! Thanks:)

  • @rajaa9979
    @rajaa9979 3 роки тому +1

    In the video, at times 56:00 and 1:05:00, your interpretation of %CPU is incorrect and misguiding. You are meaning, %CPU of 95 is a problem, which is not correct.
    Ideally a good query should have %CPU as 100.
    Queries running without any waits will have %CPU as 100 which is perfect from the database instance configuration.
    Usually queries blocked due to "row lock contention" will have the %CPU as almost zero which is a problem.

  • @alonso-zi5qu
    @alonso-zi5qu 4 роки тому +1

    Thanks so much awesome explanation

  • @vishwas22khare
    @vishwas22khare 4 роки тому

    Which version of linux it is and can we also generate in ms dos command prompt? Please answer .

  • @wasimdatabaseadmin7637
    @wasimdatabaseadmin7637 4 роки тому +1

    its a great explanation

  • @lalithavaranasi4643
    @lalithavaranasi4643 3 роки тому +1

    beautiful.. thanks a ton

  • @shashiso
    @shashiso 2 роки тому

    Thank you 🙏 it really helped

  • @deepthi3838
    @deepthi3838 5 років тому +1

    thanks a million, sir.

  • @ManiKanta-vc5xx
    @ManiKanta-vc5xx 5 років тому +1

    thank you very much

  • @pakhi3007
    @pakhi3007 3 роки тому +1

    Like the Video.

  • @prachibile2798
    @prachibile2798 5 років тому +1

    Thanks! It is helpful.

    • @dbagenesis
      @dbagenesis  2 роки тому

      Glad to hear!Keep watching.

  • @king0s
    @king0s Рік тому

    You should have had a real report, atleast from Perf env, and explained it, instead of showing a dataless report. I am grateful for the series but hearing that guy asking you for more info and you shutting him down makes me wonder, you could have explained it simply in the time you spent convincing him.