No question at this time
DBA Top 10
1 M. Cadot 13000
2 B. Vroman 7000
3 A. Kavsek 5900
4 J. Schnackenberg 3200
5 P. Wisse 2600
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48600
Total active users1396
Act. users last 24h1
Act. users last hour0
Registered user hits last week51
Registered user hits last month385
Go up

AWR Report Analysis
Next thread:
Prev thread: How much number of records we should keep in the oracle table

Message Score Author Date
Hi, This query is based on AWR report analysis....... Balaji M Mar 25, 2021, 14:17
Hi Balaji, May be you should notice high di...... Joël Péran Mar 26, 2021, 08:54
Hi Joel, <b>May be you should notice high disk ...... Balaji M Mar 26, 2021, 11:27
Maybe in the way you "found there is disk perfor...... Michel Cadot Mar 26, 2021, 12:37
Poda dubukku!... Balaji M Mar 26, 2021, 13:35
Too bad the only thing you have learned in your ...... Michel Cadot Mar 26, 2021, 14:53
Michel, Whenever I ask questions in orafaq or d...... Balaji M Mar 27, 2021, 05:47
I insulted you? NEVER! Give a single link where ...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Michel Cadot Mar 27, 2021, 07:51
poda dubukku!... Balaji M Mar 27, 2021, 08:09

Follow up by mail Click here


Subject: AWR Report Analysis
Author: Balaji M, India
Date: Mar 25, 2021, 14:17, 28 days ago
Os info: AIX-Based Systems (64-bit)
Oracle info: 12.1.0.2.0
Message: Hi,

This query is based on AWR report analysis.
Is there any something due to disk performance issue and SQL queries are impacted?
Why I am asking is based on AWR report analysis, I found there is disk performance issue and
there are long running queries under section SQL ordered by elapsed time.
Could it be something that due to disk performance issue, queries are running longer.
If so how to proceed further to fix this issue.

This is Standalone Database.

Regards,
Balaji

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Joël Péran, France
Date: Mar 26, 2021, 08:54, 27 days ago
Message: Hi Balaji,

May be you should notice high disk reads or high disk writes on some queries. May be you have fragmented tables too, and I think you should ask your system team to check for disk latency ?
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Balaji M, India
Date: Mar 26, 2021, 11:27, 27 days ago
Message: Hi Joel,

May be you should notice high disk reads or high disk writes on some queries.
Could you please guide me how to check this.

Regards,
Balaji
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Michel Cadot, France
Date: Mar 26, 2021, 12:37, 27 days ago
Message:
Maybe in the way you "found there is disk performance issue"!

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Balaji M, India
Date: Mar 26, 2021, 13:35, 27 days ago
Message: Poda dubukku!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Michel Cadot, France
Date: Mar 26, 2021, 14:53, 27 days ago
Message:
Too bad the only thing you have learned in your latest 14 years is to insult people.
And you can't even do it in the forum language.
Is this a lack of skill or cowardice?

Ah, if you were able to learn Oracle and DBA work in the same way what a wonderful forum member you could be, helping people with your knowledge!

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Balaji M, India
Date: Mar 27, 2021, 05:47, 27 days ago
Message: Michel,

Whenever I ask questions in orafaq or dba-village forums to learn something new that was asked in the interview,
you insult me by writing something that irritates me. Thats why I replied like that.

You deserve such reply.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Michel Cadot, France
Date: Mar 27, 2021, 07:51, 26 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message:
I insulted you? NEVER! Give a single link where I did that!

I irritated you? of course! You don't support we tell you the truth: you proved you are a perpetual unskilled person.
After 14 years as a "DBA" you ask the same basic questions. You showed you didn't even understand your questions and what you posted.
When we asked you to explain your post, you didn't answer or did insult us.

For instance, in this thread, you said:
I found there is disk performance issue
and
Could you please guide me how to check this. (high disk reads or high disk writes).
Don't you think the answer to the second sentence is implied by the first one?
Otherwise, what do you mean by "I found there is disk performance issue"? What did you find? What made you say there was a "disk performance issue"?
This is what my post means! It was to make you think about what you posted and what you had to do.

During all these years, I tried to make you think, I tried to involve you in your questions (like searching in and reading the documentation), I tried to improve you.
But I have to admit I widely failed.

As you said: "you deserve such reply", trying to help you is just a waste of time.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: AWR Report Analysis
Author: Balaji M, India
Date: Mar 27, 2021, 08:09, 26 days ago
Message: poda dubukku!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here