No question at this time
DBA Top 10
1 B. Vroman 14500
2 M. Cadot 14200
3 A. Kavsek 6900
4 T. Boles 6100
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3600
7 G. Lambregts 1100
7 T. P 1100
7 P. Wisse 1100
10 B. Derous 500
10 R. Wauben 500
10 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48226
Total active users1641
Act. users last 24h5
Act. users last hour0
Registered user hits last week344
Registered user hits last month1464
Go up

sql query performance
Next thread: startup failure
Prev thread: Clusterware state back to ONLINE state

Message Score Author Date
Hi Masters, I am facing one problem here. on...... javed akhtar Jun 21, 2018, 10:37
Hi, Check the execution plan. I bet this is whe...... Joël Péran Jun 27, 2018, 09:12

Follow up by mail Click here


Subject: sql query performance
Author: javed akhtar, India
Date: Jun 21, 2018, 10:37, 30 days ago
Os info: linux
Oracle info: 12.1
Message: Hi Masters,

I am facing one problem here.

one of my reporting queries was running fine but all of sudden it is taking more than 10 mins for fetching 10 records, I have checked and rerun the query, again the query run absolutely fine, after 20 mins I rerun the query again it is taking time.

means sometimes it is running in the time frame, but sometimes it is taking a long time.

any idea.

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

Subject: Re: sql query performance
Author: Joël Péran, France
Date: Jun 27, 2018, 09:12, 24 days ago
Message: Hi,

Check the execution plan. I bet this is where your problem is coming from. Do you use bind variables ? Did you check the stats ? What is the oracle version you are using ... many questions without answers. So you will definitely not receive a valid answer for your question ...

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