Home » RDBMS Server » Performance Tuning » Why Oracle 10g slows down Copmuter after few days (Oracle 10g 10.2.0.1.0)
icon4.gif  Why Oracle 10g slows down Copmuter after few days [message #432102] Sat, 21 November 2009 03:46 Go to next message
myinvention99
Messages: 3
Registered: November 2009
Location: INDIA
Junior Member

I've installed Oracle 10g on a PC by selecting all options in default. I've used it for 3 weeks. After that I've not used this PC. Still the PC has become very slow.

I've experienced this problem initially on one PC.

I've tested the same on 3 different PCs.

Can anyone help me to prevent this ?
Previously I was using Oracle 9i. I didn't face this system slow down problem.
Re: Why Oracle 10g slows down Copmuter after few days [message #432124 is a reply to message #432102] Sat, 21 November 2009 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
I believe they have caught the N1H1 influenza

Re: Why Oracle 10g slows down Copmuter after few days [message #432358 is a reply to message #432102] Mon, 23 November 2009 16:40 Go to previous messageGo to next message
coleing
Messages: 213
Registered: February 2008
Senior Member
OEM usually has some cleanup jobs which knacker a consumer PC.

Turn them all off, probably including OEM itself.

Cheers
Dan
Re: Why Oracle 10g slows down Copmuter after few days [message #432365 is a reply to message #432102] Mon, 23 November 2009 17:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Try installing something like Process Explorer and have a look at what's actually running.

I've had 10g running on by pc (with OEM switched off) for about 2 months now and everything's going quite smoothly.
Re: Why Oracle 10g slows down Copmuter after few days [message #433124 is a reply to message #432102] Mon, 30 November 2009 05:05 Go to previous messageGo to next message
DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai
Member
your serach ends here....

create two batch file(.bat) to start and stop oracle services and put them in manual mode. when you are not using oracle why to run it in the background.

when you wish to start oracle just double click the batch file start.bat and when want to stop just stop.bat.

Hope this will help you.

stop.bat
---------
net stop <service name>
net stop <service name>
net stop <service name>


start.bat
---------
net start <service name>
net start <service name>
net start <service name>



Re: Why Oracle 10g slows down Copmuter after few days [message #433414 is a reply to message #433124] Wed, 02 December 2009 03:44 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No - that's not a solution - that's simply trying to avoid the problem.
Re: Why Oracle 10g slows down Copmuter after few days [message #433857 is a reply to message #433414] Fri, 04 December 2009 10:13 Go to previous messageGo to next message
DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai
Member
I am still waiting for your problem solution. anyways i didn't mean ever to go away from any problem. just gave a solution for home pc not for a production server.
Re: Why Oracle 10g slows down Copmuter after few days [message #433859 is a reply to message #432102] Fri, 04 December 2009 10:23 Go to previous messageGo to next message
DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai
Member
Run AWR and ADDM report and solve the issue if you need to increase memory.
Re: Why Oracle 10g slows down Copmuter after few days [message #433861 is a reply to message #433859] Fri, 04 December 2009 10:31 Go to previous messageGo to next message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_SangramKeshari wrote on Fri, 04 December 2009 17:23
Run AWR and ADDM report and solve the issue if you need to increase memory.

And if the problem is elsewhere can he solve it?

Regards
Michel
Re: Why Oracle 10g slows down Copmuter after few days [message #434030 is a reply to message #432102] Sun, 06 December 2009 20:00 Go to previous messageGo to next message
DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai
Member
Can you please revert with your PC configuration details (hardware)on which you are facing problem.?

I think this is the first place from where we can start investigation.

Re: Why Oracle 10g slows down Copmuter after few days [message #434051 is a reply to message #432102] Mon, 07 December 2009 01:12 Go to previous messageGo to next message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Certainly pc specs will help. (Memory/disk/paging file locations)

Also, what else do you use the pc for? Websurfing ? DVD authoring? Email (and if so, what is your email client and version? )

Process Explorer is way cool, by the way. I never new exactly what svchost.exe was actually doing till I got my hands on procexp.

It is definately a must have for a Windows box -

If you *must* run a database on a PC platform, kick up the ram to 4gb and install linux. You'll be happier in the end.

Nets Edge
Re: Why Oracle 10g slows down Copmuter after few days [message #434162 is a reply to message #433857] Mon, 07 December 2009 09:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
I am still waiting for your problem solution


My solution was the same as @Coleing - if you're running on a resourse poor platform, try turning off the OEM processes.

Re: Why Oracle 10g slows down Copmuter after few days [message #435757 is a reply to message #432358] Thu, 17 December 2009 15:34 Go to previous message
myinvention99
Messages: 3
Registered: November 2009
Location: INDIA
Junior Member

Hi,
How to turn-off all OEM cleanup jobs including OEM itself.

will it affect the functionality of OEM on Client ?
Previous Topic: Queries in oracle indexing
Next Topic: sql tuning help
Goto Forum:
  


Current Time: Fri Sep 30 17:28:55 CDT 2016

Total time taken to generate the page: 0.18986 seconds