No question at this time
DBA Top 10
1 M. Cadot 9900
2 B. Vroman 9200
3 A. Kavsek 7500
4 T. Boles 6250
5 J. Schnackenberg 5100
6 P. Wisse 2700
7 M. Hidayathullah ... 1500
8 T. P 1200
9 G. Lambregts 1100
9 . Lauri 1100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48352
Total active users1553
Act. users last 24h2
Act. users last hour0
Registered user hits last week279
Registered user hits last month926
Go up

PERFORMANCE ISSUE
Next thread: Will be possible to patch standby first and prod after one week??
Prev thread: OEM13 Installation fail

Message Score Author Date
Hi Experts, Suddenly my warehouse performance w...... Raj thakur Jan 11, 2019, 03:12
Hi, What's the Version? Once I had a perform...... Philip Wisse Jan 13, 2019, 11:01
http://www.oracle-scripts.net/cleanup-orphaned-dat...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jan 14, 2019, 10:13

Follow up by mail Click here


Subject: PERFORMANCE ISSUE
Author: Raj thakur, India
Date: Jan 11, 2019, 03:12, 71 days ago
Message: Hi Experts,

Suddenly my warehouse performance was down. User are complaining about it. All stats for user query's tables are up to date. Same query ran 5 days back working fine but dont know why performance issue happen.

No DB/OS changes. Db size looks normal. all looks good but still perforamnce issue. Please help me out
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: PERFORMANCE ISSUE
Author: Philip Wisse, Netherlands
Date: Jan 13, 2019, 11:01, 69 days ago
Message: Hi,

What's the Version?

Once I had a performance drop because of an aborted export datapump (11.2).

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

Subject: Re: PERFORMANCE ISSUE
Author: Philip Wisse, Netherlands
Date: Jan 14, 2019, 10:13, 68 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: http://www.oracle-scripts.net/cleanup-orphaned-datapump-jobs/
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here