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
Wednesday, 9 March 2011
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
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10736/usingpe.htm#i1008006
Subscribe to:
Posts (Atom)