OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Performance issue (oracle 11g r2 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performance issue [message #604469]

Tue, 31 December 2013 04:15

kurki
Messages: 22
Registered: December 2013

Junior Member

Hello All,

On every year october my database performance will be down with existing data.
Not doing any bulk insertions/updates or any transactions on that month.
but the performance will be down during that time.

Can any body suggest the root cause.

I am trying to find out which oracle CPU Patch applied.

Thanks in Advance,
Kishore

Report message to a moderator

Re: Performance issue [message #604474 is a reply to message #604469]

Tue, 31 December 2013 05:19

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

Going by the information you have provided, it would seem possible that the slow down is caused by increased paranormal activity preceding Halloween.

Report message to a moderator

Re: Performance issue [message #604486 is a reply to message #604474]

Tue, 31 December 2013 07:11

kurki
Messages: 22
Registered: December 2013

Junior Member

Hi john,

there is no change in the data and not doing any inserts/updates.
still unable to figure it out.

Thanks,
Kishore

Report message to a moderator

Re: Performance issue [message #604910 is a reply to message #604469]

Mon, 06 January 2014 01:36

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

If performance goes down (only) in October, surely you need to isolate what is changed / additional in October.
Additional (once-a-year) reports being executed, causing additional load on the database server ?

Hemant K Chitale

Report message to a moderator

Re: Performance issue [message #605102 is a reply to message #604486]

Tue, 07 January 2014 06:52

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

How many Octobers has this happened? Is it for the entire month of October (Midnight on 1st to midnight on 31st) or does it miss out the public holidays, what about weekends. What is the nature of the slowdown ;
reports are returned more slowly,
logins take more time
dml takes forever
Do your users notice this or is it just you?
Is anybody on holiday every october.
How much slower? 10% 50% 200%
What have you ruled out so far and why?
Is the database equally zippy for all other months (you say that performance degrades ONLY for October, so presumbly performance is excellent (equally so) across all other months?
Did you get the job for which this was an interview question?
Can you answer me this:
Every year, on the 17th of July, I seem to wake up with a really bad headache. What's the reason for this?

Report message to a moderator

Re: Performance issue [message #605120 is a reply to message #605102]

Tue, 07 January 2014 08:29

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

pablolee wrote on Tue, 07 January 2014 12:52

Every year, on the 17th of July, I seem to wake up with a really bad headache. What's the reason for this?

You're an alcoholic and it's a trick question as the other 364 days are the same?

I jest...mostly Laughing

Report message to a moderator

Re: Performance issue [message #605121 is a reply to message #605120]

Tue, 07 January 2014 08:35

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

I have a day off every now and again (and you're one to talk, how many corona did you tuck away last night?)
Wink

[Updated on: Tue, 07 January 2014 08:35]

Report message to a moderator

Re: Performance issue [message #605128 is a reply to message #605121]

Tue, 07 January 2014 08:53

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

pablolee wrote on Tue, 07 January 2014 14:35

I have a day off every now and again (and you're one to talk, how many corona did you tuck away last night?)

None. None at all!

Perhaps this is why I had a headache...

Report message to a moderator

Re: Performance issue [message #605139 is a reply to message #605102]

Tue, 07 January 2014 09:34

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Is your birthday on the 16th?

Report message to a moderator

Re: Performance issue [message #605144 is a reply to message #605139]

Tue, 07 January 2014 10:06

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

gazzag wrote on Tue, 07 January 2014 15:34

Is your birthday on the 16th?

That is definitely what I was implying, yes. (although roachcoach's proposition isn't too far away either Wink

)

Report message to a moderator

Re: Performance issue [message #605156 is a reply to message #605144]

Tue, 07 January 2014 12:01

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

And people wished you on Oct, 10th Sad

Report message to a moderator

Re: Performance issue [message #605161 is a reply to message #605156]

Tue, 07 January 2014 12:34

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Lalit Kumar B wrote on Tue, 07 January 2014 18:01

And people wished you on Oct, 10th

I implied that my birthday was 16th, doesn't mean that it is

Report message to a moderator

Re: Performance issue [message #605162 is a reply to message #605161]

Tue, 07 January 2014 13:06

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

pablolee wrote on Wed, 08 January 2014 00:04

I implied that my birthday was 16th, doesn't mean that it is

And unlike Roachcoach mentioned, not necessarily you would booze on Oct,10th or July,16/17th.

And hopefully, OP's issue has nothing to do with October(10th precisely) /forum/fa/1985/0/

Report message to a moderator

Re: Performance issue [message #605202 is a reply to message #605162]

Wed, 08 January 2014 00:39

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Lalit Kumar B wrote on Tue, 07 January 2014 19:06

And hopefully, OP's issue has nothing to do with October(10th precisely)

Of course; post hoc ergo propter hoc

Report message to a moderator

Previous Topic:	Please help me merge query is taking more time
Next Topic:	Tuning suggestions on query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 12:16:02 CST 2025