Tere is some differences as it applies to oracle. Refer to this link: http://www.dba-oracle.com/art_so_oracle_standard_enterprise_edition.htm
We have about the same datadump excluding vaulted content as you do. Our database never run any better. Just make sure you put enough RAM to your allocated memory of your database. For us, we have:
- one deticated Linux blade server with 8 cores and 48 GIGs of ram.
- The database is installed will an allocation of 40% of the ram. See attached document.
- Make sure that each table space is only 50% full so you always have a contiguous datafile and not fragmented all over the place. Yes, there are SANs that do it for you, but you can't be lazy and rely on auto-extending. Sometimes/most timesWindchil can't wait for autoextenting and times out
- All of our installation and datafiles are mounted from an HP EVA.
- because we use a blade configuration, our database server, windchill server, CAD worker, and document worker are all connected via a 10GIGE switch.
We like the fact that all the alerts and oracle dbconsole tools are available in oracle enterprise with:
- table space utilization
- performace graphs
- advisor for:
- need more SGA
- or other issues with Windchill indexes
- etc.
We were able to instantly send the SQL and find the origin of the issue to PTC when we had issues in Windchill 9.0. I really don't know if SQL Server can beat the performance of a Linux server with Oracle Enterprise. I just wish PTC supported Windchill on PostgreSQL which is free like Linux butsupported by a company like RedHat. I always find that Oracle DBAs have to know Windchill application in order to tune Windchill. Thus, these Oracle DBAs are specialized in Windchill.
Good luck,
Patrick
