Page 1 of 1
Oracle 9 slow database write
Posted: Sat Jul 01, 2006 7:04 pm
by Giraffe }{unter
Fresh new Windows 2000 Server (updated all the way)
P4 2.4GHz
1.5gig ram
Symantec antivirus 10 corp (database excluded)
Oracle 9.2.0.1.0
Got an emergency issue with our payroll software, viweing the database is fine, but writing to it takes about 30 seconds to 2 minutes. Even with the AV services disabled.
Any suggestions?
Posted: Sat Jul 01, 2006 7:09 pm
by AmIdYfReAk
have you tryed flat out removing the AV Software and seeing if it takes that long?
Posted: Sat Jul 01, 2006 8:42 pm
by Foo
Even writing locally, or just across a network conn?
Posted: Sun Jul 02, 2006 5:10 pm
by Giraffe }{unter
Writing locally takes long as well, when I get back I am going to remove SAV, but assuming that disableing the services is almost the same...
At this poing I'll try everything. Yesterday both the company that creates the software and the company that sold is the software had their websites offline
18 hours till payroll...
Posted: Wed Jul 19, 2006 10:37 pm
by Underpants?
any updates? I've seen network performance issues due to Oracle's love-hate relationship with AD/ dns.
Posted: Thu Jul 20, 2006 12:54 am
by Giraffe }{unter
Sadly I have three different groups working on this issue.
After replacing the System's memory and drives, Our support company called in the program developers, who now have Oracle techs working on it.
yes 2 payrolls submitted to HR in excel format for over 300 employees. HR is not verry happy.
Posted: Thu Jul 20, 2006 2:18 am
by Underpants?
300 employees?
, that's insane! hourly as well as salary? Who's going to play catch up when it becomes available again? Good lord, the company doesn't generate their own paychecks?