Q
Problem solve Get help with specific problems with your technologies, process and projects.

Getting best Oracle performance on Win2000

We are running Oracle 8.1.7.4 on Windows 2000 Advanced Server for our ERP (Oracle Apps 11.5.8). We are facing the problem of performance. Oracle.exe is not going beyong 3GB even if we have physical RAM of 6 GB. We use PAE and AWE switch. Please let us know the best method for Oracle to get the best performance on Win2K.
As you already know, you will not be able to address more than 3 GB of memory on Windows. That aside, the principles of Oracle performance optimization on Windows are no different than they are on other platforms: create a normalized database schema, write efficient SQL, use appropriate indexing, minimize parsing, minimize logical I/O. It is rarely the case in which just increasing the size of the SGA solves performance problems.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close