Home » RDBMS Server » Performance Tuning » degradation after restart
degradation after restart [message #273854] Fri, 12 October 2007 00:21 Go to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
Hi all!

I have Oracle 10.1.0.5 running on Solaris 9 SPARC.
The DB is about 500 Gbs.
We are restarting it every week, for cold backup. And after the backup we are gathering statistics.
All is fine, but:
sometime we have to restart the db, during the week (hardware change, e.t.c) after the restart the performance becomes very bad...
Some people said: "Upon restart, you should let your instance warm up first." But, the performance is bad, even 2 days after restart...

What should i do?

Re: degradation after restart [message #273871 is a reply to message #273854] Fri, 12 October 2007 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't stop your database and take hot backup.

Regards
Michel
Re: degradation after restart [message #273891 is a reply to message #273854] Fri, 12 October 2007 02:13 Go to previous messageGo to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
sunday night:
1. Taking cold backup
2. Gathering stats
All is OK. No performance problems.

But,
Sometime i have to schedule downtime, during the week to change the hardware or to change some DB parameters. And, after that restart i have problems.
Re: degradation after restart [message #273898 is a reply to message #273891] Fri, 12 October 2007 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't change hardware or db parameters every week, so it is not a real problem.

Regards
Michel
Re: degradation after restart [message #273960 is a reply to message #273854] Fri, 12 October 2007 06:26 Go to previous messageGo to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
But, when i have to change hardware or db parameter it becomes a real problem.
Because that db is our financial system.

Do you think it is normal (performance degradation after restart)? Or, you just don't want to answer my question?

Re: degradation after restart [message #274037 is a reply to message #273960] Fri, 12 October 2007 18:37 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:

Do you think it is normal (performance degradation

Yes. No. Maybe. (Most likely yes, or maybe "blue") For a start, you haven't quantified the problem. It's like me telling my doctor "I don't feel as well today as I did yesterday" what exactly would you expect the doc to do with that info?
How about you give some useful info
Re: degradation after restart [message #274247 is a reply to message #273854] Mon, 15 October 2007 04:01 Go to previous messageGo to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
I have oracle database - it works fine and I'm satisfied with the performance. I'm gathering the statistics every Sunday.

BUT, if i restart the database during the week - it becomes very slow.

Questions:
Why it becomes so slow after the restart?
How can i fix that?

Re: degradation after restart [message #274253 is a reply to message #274247] Mon, 15 October 2007 04:18 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
OK, once again, I will compare the info that you have given, to a visit to the doctors.

I have a leg. Most of the time I'm quite happy with this leg. Sometimes when I jump up and down, the leg is a little bit wobbly. What medicine do I need?

Please read the sticky at the top of the forum list to help you ask a question that can actually be answered. (Based on the info that you have supplied the only advice that we can give you is not to restart your database.- just as all the doc would have been able to tell me was to NOt jump up and down)
Re: degradation after restart [message #274304 is a reply to message #274247] Mon, 15 October 2007 08:39 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Give me answer for below question.

1. which db parameter you modify so you need to restart oracle server ?

2. Why you gather statistics every week ?

3. Did you generate STATPACK/AWR report.
if not then please generate and post here TOP 5 TIMED EVENT.


Regards
Taj
Previous Topic: search on text column
Next Topic: while taking performance measeure ?
Goto Forum:
  


Current Time: Sun Dec 04 00:18:46 CST 2016

Total time taken to generate the page: 0.17704 seconds