Wednesday 9 March 2011

to log or not to log

In summary :-
If nologging is specified on a table or tablespace all operations against a table will still be logged except

Alter table...move partition
alter table...split partition
alter index...split partition
alter index...rebuild
alter index...rebuild partition
create table...as select (CTAS)
create index
direct load with SQL*Loader
direct load INSERT (using APPEND)

with nologging specified


http://www.dbasupport.com/oracle/ora10g/managing_tables.shtml

Tuesday 1 March 2011

parallel_max_servers

parallel_max_servers set the TOTAL maximum number of parallel processes that each server.


http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10736/usingpe.htm#i1008006