Home » RDBMS Server » Performance Tuning » Performance issue (oracle 11g r2 )
Performance issue [message #604469] Tue, 31 December 2013 04:15 Go to next message
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
Re: Performance issue [message #604474 is a reply to message #604469] Tue, 31 December 2013 05:19 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Performance issue [message #604486 is a reply to message #604474] Tue, 31 December 2013 07:11 Go to previous messageGo to next message
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
Re: Performance issue [message #604910 is a reply to message #604469] Mon, 06 January 2014 01:36 Go to previous messageGo to next message
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
Re: Performance issue [message #605102 is a reply to message #604486] Tue, 07 January 2014 06:52 Go to previous messageGo to next message
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?
Re: Performance issue [message #605120 is a reply to message #605102] Tue, 07 January 2014 08:29 Go to previous messageGo to next message
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
Re: Performance issue [message #605121 is a reply to message #605120] Tue, 07 January 2014 08:35 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?)
Wink


None. None at all!

Perhaps this is why I had a headache...
Re: Performance issue [message #605139 is a reply to message #605102] Tue, 07 January 2014 09:34 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Is your birthday on the 16th?
Re: Performance issue [message #605144 is a reply to message #605139] Tue, 07 January 2014 10:06 Go to previous messageGo to next message
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)
Re: Performance issue [message #605156 is a reply to message #605144] Tue, 07 January 2014 12:01 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
And people wished you on Oct, 10th Sad
Re: Performance issue [message #605161 is a reply to message #605156] Tue, 07 January 2014 12:34 Go to previous messageGo to next message
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 Sad

I implied that my birthday was 16th, doesn't mean that it is
Re: Performance issue [message #605162 is a reply to message #605161] Tue, 07 January 2014 13:06 Go to previous messageGo to next message
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


Smile

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/
Re: Performance issue [message #605202 is a reply to message #605162] Wed, 08 January 2014 00:39 Go to previous message
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
Previous Topic: Please help me merge query is taking more time
Next Topic: Tuning suggestions on query
Goto Forum:
  


Current Time: Thu Mar 28 09:49:11 CDT 2024