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.