How to Read Oracle AWR Report | Oracle Automatic Workload Repository

Поділитися
Вставка
  • Опубліковано 12 лис 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.

  • @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.

  • @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!

  • @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

  • @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..

  • @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?

  • @Wantedmamwt
    @Wantedmamwt 28 днів тому

    Very good insightful

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

    crystal clear explanation

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

    Soo good analysis 👍

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

    Excellent, Excellent and Excellent, please keep continue sir

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

    Its very useful to understand AWR Report.

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

    Very helpful, thanks

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

      Thank you, Keep watching!

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

    Thank you so much for all....

  • @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

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

    Very informative..!!

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

    Excellent explanation, you are awesome. Keep it up

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

    Awesome, very helpful. Thank you😊

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

    Great 👍 , good explanation

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

    Excellent Explanation with patience...

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

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

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

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

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

    Great, Arun, awesome,

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

    Thank you.

  • @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?

  • @ritikarao6112
    @ritikarao6112 3 роки тому +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.

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

    Thanks for the informative video

  • @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.

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

    Thank you... Good information which will surely help

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

    DBA Genesis, best ever! Thanks:)

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

    beautiful.. thanks a ton

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

    Great. Very useful. Thank you!

  • @VMI33
    @VMI33 4 роки тому +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  4 роки тому +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

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

    Very nicely explained..👏

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

    Really good! Informative

  • @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

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

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

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

    Thank you 🙏 it really helped

  • @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?

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

    Thanks so much awesome explanation

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

    its a great explanation

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

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

  • @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.

  • @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.

  • @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.