Oracle 9i &10G Performance Issue from 2000-2003 Server?

Question

Hi,

Since upgrading our database machine to 2003 server we noticed that the time to perform certian tasks with Oracle takes a lot more time. We've created a test environment in which we have a Windows 2000 Server with oracle 9i and a windows 2003 server with Oracle 9i. Both have identical hardware, software is just the OS and oracle. After monitoring the application while having it run here's what we found. The execute time in Oracle 9i/10G for updates and procedures in 2003 Server takes about twice as long vs in 2000 Server. Has anyone ran into this problem and know how to fix it?

Answer 1

Oracletutorials.info is your gateway to the best

sites on the Internet for Oracle tutorials!

Looking for Oracle tutorials, Oracle, or

Computers?Browse our recommended resources or

just try the Oracletutorials.info search.

http://oracletutorials.info/

Answer 2

Oracletutorials.info is your gateway to the best

sites on the Internet for Oracle tutorials!

Looking for Oracle tutorials, Oracle, or

Computers?Browse our recommended resources or

just try the Oracletutorials.info search.

http://oracletutorials.info/

Answer 3

hi oralce 10g is greater version of oracle 9i, oracle 10g has further a follwoing beneficial aspects sparkling information Encryption Async commits connect function can no longer basically connect Passwords for DB hyperlinks are encrypted New asmcmd application for handling ASM storage Grid computing - an extension of the clustering characteristic (actual application Clusters) Manageability advancements (self-tuning beneficial aspects) overall performance and scalability advancements computerized storage administration (ASM) computerized Workload Repository (AWR) computerized Database Diagnostic visual demonstrate unit (ADDM) Flashback operations obtainable on row, transaction, table or database point potential to UNDROP a table from a recycle bin potential to rename tablespaces potential to transport tablespaces in the time of gadget kinds (E.g abode windows to Unix) New 'drop database' assertion New database scheduler - DBMS_SCHEDULER DBMS_FILE_TRANSFER equipment help for bigfile tablespaces it is as much as eight Exabytes in length information Pump - speedier information circulate with expdp and impdp.