No question at this time
DBA Top 10
1 M. Cadot 22600
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8100
5 P. Wisse 6000
6 T. Boles 5200
7 J. Schnackenberg 3300
8 G. Lambregts 2200
8 P. Knibbs 2200
8 K. Pagadala 2200
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 users48017
Total active users1850
Act. users last 24h5
Act. users last hour0
Registered user hits last week339
Registered user hits last month1183
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
Please post top 10 background wait event and foreg...... Raj thakur May 31, 2017, 07:22

Follow up by mail Click here


Subject: Data base slowness issue
Author: Mahesh Eedunuri, India
Date: Mar 10, 2017, 14:35, 162 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, 162 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, 162 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, 162 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, 162 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, 161 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, 157 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, 148 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

Subject: Re: Data base slowness issue
Author: Raj thakur, India
Date: May 31, 2017, 07:22, 80 days ago
Message: Please post top 10 background wait event and foreground wait event.? any error/warning in alert log then paste here.

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