Perfomning Finetuning

From: Johnson <syner_at_pd.jaring.my>
Date: Wed, 6 Sep 2000 14:46:43 +0100
Message-ID: <8p4opc$dgh$1@news6.jaring.my>

Hello DBA,

In Oracle 8i, I would like to add the new datafile to my Data Tablespace, do I need to shutdown the database. or I can add datafile and modified the tablespace while the system is still up and running (user are using the database).

What are the procedure , if I would like to performing the Oracle finetuning, such as tuning SGA, Modified extent and so fore. Do I need to perform this only when no user are accessing the database?? After each change, do I need to restart the database??

Generally what are the area I should look into , if the performance is drop in NT platform. anything in particular ?

Regards. Received on Wed Sep 06 2000 - 08:46:43 CDT