Re: guide on impact of system

Slow is a relative term. I have added 2G datafiles to my sysem in under 16 seconds. Considering that the command does not stop any other session from working on objects in the tablespace being expanded does it matter if the command takes 16 seconds or two minutes? I say no, as long as the disk IO farm is not near its IO load capacity so that other database session are basically unaffected.

A create index or alter index rebuild will lock DML against the base table. This could be a problem or it may be acceptable depending on the expected index build/rebuild time and the application. Both commands have online options depending on your version and the index type.

Like JG said, it depends.

• Mark D Powell --