Oracle 9 slow database write

Post by **Giraffe }{unter** » Sat Jul 01, 2006 7:04 pm

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?

Post by **AmIdYfReAk** » Sat Jul 01, 2006 7:09 pm

have you tryed flat out removing the AV Software and seeing if it takes that long?

Post by **Foo** » Sat Jul 01, 2006 8:42 pm

Even writing locally, or just across a network conn?

Post by **Giraffe }{unter** » Sun Jul 02, 2006 5:10 pm

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...

Post by **Underpants?** » Wed Jul 19, 2006 10:37 pm

any updates? I've seen network performance issues due to Oracle's love-hate relationship with AD/ dns.

Post by **Giraffe }{unter** » Thu Jul 20, 2006 12:54 am

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.

Post by **Underpants?** » Thu Jul 20, 2006 2:18 am

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?