Perfomning Finetuning

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


[Quoted] Hello DBA,

[Quoted] In Oracle 8i, I would like to add the new datafile to my Data Tablespace, do [Quoted] 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).

[Quoted] [Quoted] 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??

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

Regards. Received on Wed Sep 06 2000 - 15:46:43 CEST

Original text of this message