No question at this time
DBA Top 10
1 M. Cadot 25100
2 A. Kavsek 16900
3 B. Vroman 11000
4 M. Hidayathullah ... 10500
5 T. Boles 7600
6 F. Diaz 6700
7 P. Wisse 6600
8 J. Schnackenberg 4700
9 A. Hudspith 4300
10 P. Knibbs 2500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47901
Total active users1905
Act. users last 24h9
Act. users last hour0
Registered user hits last week254
Registered user hits last month1168
Go up

Data base slowness issue
Next thread: Querying with CONTAINS is giving error
Prev thread: full data pump import

Message Score Author Date
Since 27 Feb 2017 same issue. There are is no upda...... Mahesh Eedunuri Mar 10, 2017, 14:35
Dear Mahesh, what issue you are exactly facing....... Mirza Hidayathullah Baig Mar 10, 2017, 14:39
Thanks for reply, Actually we are facing databa...... Mahesh Eedunuri Mar 10, 2017, 14:49
Please go through below links, you may get some id...... Mirza Hidayathullah Baig Mar 10, 2017, 16:43
Also, check following mos notes. How to Inves...... Mirza Hidayathullah Baig Mar 10, 2017, 17:20
Thank you Mirza Hidayathullah Baig... Mahesh Eedunuri Mar 11, 2017, 06:13
Hi , Is the slowness issue resolved , Is your d...... saumya das Mar 15, 2017, 10:26
Hi , Please paste AWR report so that everybody ...... naresh kumar Mar 24, 2017, 06:03

Follow up by mail Click here


Subject: Data base slowness issue
Author: Mahesh Eedunuri, India
Date: Mar 10, 2017, 14:35, 17 days ago
Os info: 10.0.2.4
Oracle info: 10G
Message: Since 27 Feb 2017 same issue. There are is no update in the DB side.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Data base slowness issue
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 10, 2017, 14:39, 17 days ago
Message: Dear Mahesh,

what issue you are exactly facing.

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

Subject: Re: Data base slowness issue
Author: Mahesh Eedunuri, India
Date: Mar 10, 2017, 14:49, 17 days ago
Message: Thanks for reply,

Actually we are facing database slowness issue. But i don't know is it issue of network or any configuration problem.

Before 27th Feb 2017 it is working smoothly. But now every query taking more time to fetch data from the database.

We are generate AWR report but i am not understand where exactly the problem.

Please guide me how to rectify this 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: Data base slowness issue
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 10, 2017, 16:43, 17 days ago
Message: Please go through below links, you may get some idea.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2817104300346634070

http://www.orafaq.com/wiki/Oracle_database_Performance_Tuning_FAQ

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

Subject: Re: Data base slowness issue
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 10, 2017, 17:20, 17 days ago
Message:
Also, check following mos notes.

How to Investigate Slow or Hanging Database Performance Issues (Doc ID 1362329.1)

Master Note: Troubleshooting Structured Query Language (SQL) (Doc ID 1517773.1)

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

Subject: Re: Data base slowness issue
Author: Mahesh Eedunuri, India
Date: Mar 11, 2017, 06:13, 17 days ago
Message: Thank you Mirza Hidayathullah Baig
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Data base slowness issue
Author: saumya das, India
Date: Mar 15, 2017, 10:26, 12 days ago
Message: Hi ,

Is the slowness issue resolved , Is your database running in archive Mode ?

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

Subject: Re: Data base slowness issue
Author: naresh kumar, India
Date: Mar 24, 2017, 06:03, 4 days ago
Message: Hi ,

Please paste AWR report so that everybody can analyze.
if you only write database is slow..nobody could help you.
and plz reply.


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