| slow server [message #327267] |
Sun, 15 June 2008 22:08  |
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 #327275 is a reply to message #327267] |
Sun, 15 June 2008 22:37  |
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 #327476 is a reply to message #327267] |
Mon, 16 June 2008 09:04 |
alanm
Messages: 284
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 |
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 |
 |
BlackSwan
Messages: 26766
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 |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
