Re: Performance tuning

You have two CPUs so the degree for large tables could be specified as 2 (or more) to take advantage of PQO.

This can be done during table creation or afterwards. [alter table $table (parallel degree 2)]

Tablespaces that contain tables that will only be queried, not updated should be placed in read only mode. In this mode, there is less overhead as ORACLE immediately knows that no redo entries will be generated.

Make sure the sort_area size is sized large enough for the majority of your sorts
Sorting using disk (i.e. temporary tablespace) is considerably slower than sorting using memory.
.
Make sure temporary tablespace is sized large enough to handle the biggest sorts you expect to do
Otherwise those sorts could fail. Received on Wed Nov 18 1998 - 23:44:40 CST