Home » RDBMS Server » Performance Tuning » slow server (windows 2000)
slow server [message #327267] Sun, 15 June 2008 22:08 Go to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
My application server has become very slow (OS WINDOWS 2000). I scaned and found that there was no virus infection and so I was advised to reinstall the OS. My question is when I reinstall windows 2000 and give it back the same network configuration IP, address and so on will the previous mapping on the client hold good or should I remap for each client/machine. Windows 2000 is installed on the C drive where as the application programs are on the D drive. I will only format the C drive and reinstall windows.

Secondly if I do the same to the database server ie reinstall windows and oracle can I straight away carry on working with oracle. Windows is on C, Oracle is on D and the database files are on E and F. So only C will be formated and windows installed, then oracle will the reinstalled on D giving the same database name and sid.

Please tell me if doing things this way is alright.

Thank you


Alister.
Re: slow server [message #327270 is a reply to message #327267] Sun, 15 June 2008 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>Please tell me if doing things this way is alright.
It sounds like standard operating procedures on Windoze.
Re: slow server [message #327275 is a reply to message #327267] Sun, 15 June 2008 22:37 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
I really dont know. I just want some suggestions please because starting and shutting down windows takes time, so I thought may be windows is slowing things down.

Alister
Re: slow server [message #327276 is a reply to message #327267] Sun, 15 June 2008 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>I thought may be windows is slowing things down.
Ready, Fire, Aim. I hope you enjoy your guessing game.

Without verifiable metrics you are simply shooting in the dark hoping to get lucky.
Re: slow server [message #327465 is a reply to message #327267] Mon, 16 June 2008 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which have you done & what were the results?
Re: slow server [message #327476 is a reply to message #327267] Mon, 16 June 2008 09:04 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
I guess this is a 32bit windows and 32 bit oracle database. How much memory do you have in the server?

There is a physical limit to the SGA size in a 32bit system.
Do you have the parameters /3GB, /PAE included in your windows start script?

regards

Alan

[Updated on: Thu, 17 July 2008 11:18] by Moderator

Report message to a moderator

Re: slow server [message #327552 is a reply to message #327267] Mon, 16 June 2008 22:00 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Hi
The following is the specifcation of my server.
Quote:

52X CDROM IDE INT DRIVE
2- 36 GB NHS ULTRA -320 SCSI 10KRPM HDD
SANSUNG IDE 52X24X52X CDRW-2MB W/O MED
HCL Two Button Scroll Mouse PS/2
2 – 256MB DDR Registered PC2100 W/ECC
Intel XEON DP 2.4 GHz 533 FSB 512 K
HCL 107 Keys Membrane PS/2 KBD
15” HCL Colour Monitor – HCM 582



Regards.

Alister
Re: slow server [message #327553 is a reply to message #327267] Mon, 16 June 2008 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Are you ever going to tell us what version of Oracle you are running (to 4 decimal places)?

>2 – 256MB DDR Registered PC2100 W/ECC
Are you really expecting Oracle to perform well on 512MB RAM?

[Updated on: Mon, 16 June 2008 22:19] by Moderator

Report message to a moderator

Re: slow server [message #327556 is a reply to message #327267] Mon, 16 June 2008 22:24 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Hi

I am using Oracle 8.1.7. Since it was a small database 512 Mb did not give us any problems. Even now the fetching of queries etc are quiet fast. The main problem I encountered is when a form is being executed. It takes time for the main page to be displayed, after that things are normal.


Regards


Alister
Re: slow server [message #327560 is a reply to message #327267] Mon, 16 June 2008 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>I am using Oracle 8.1.7.
using CBO or RBO?
Re: slow server [message #327839 is a reply to message #327267] Wed, 18 June 2008 02:56 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
What is CBO/RBO?

Alister
Re: slow server [message #327841 is a reply to message #327839] Wed, 18 June 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Performance Tuning Guide and Reference
Chapter 1 Introduction to the Optimizer
Section Understanding the Cost-Based Optimizer (CBO)
Chapter 8 Using the Rule-Based Optimizer (RBO)

Regards
Michel
Re: slow server [message #328097 is a reply to message #327267] Wed, 18 June 2008 23:09 Go to previous message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Thank you for your guidance. I shall go through the documentation.

Regards

Alister
Previous Topic: Self join removal
Next Topic: Explain Plan
Goto Forum:
  


Current Time: Sat Dec 03 20:23:42 CST 2016

Total time taken to generate the page: 0.11054 seconds