Re: Perfomning Finetuning

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 06 Sep 2000 10:15:05 GMT
Message-ID: <39b62129.2548442_at_news-server>


On Wed, 6 Sep 2000 14:46:43 +0100, "Johnson" <syner_at_pd.jaring.my> wrote:
>
>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).

You can add a data file any time you want, without having to shutdown the database. Just don't go overboard on this, there are other considerations. Don't expect performance to improve while you're doing this...

>
>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??

some changes you need to restart, others you don't. Have a look at the performance tuning guide that should be in your doc CD. It is a good start. Also, start by tuning the SQL in your application(s). That's where 99.999% of the time the biggest performance gains can be made. Do not assume that it is well coded, even if it is third party: most 3rd party stuff for Oracle is abismally designed/coded.

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

I was going to say: replace by Unix. But there are a few things to look for. Use the MS Performance Monitor. Check disk queue lengths and CPU queue lengths. Anything over 2 means a problem with that resource. Check paging and swaping. Are you getting any? Is the system paging at all? Add memory!
Also, make sure that the system is defined as an "network application server" (!) and there is NOTHING else running on it except the database. By that I mean, no print server, no file server, no BDC/PDC, nothing to do with NT security except the most basic domain logon stuff. The database server has to be TOTALLY dedicated to ORACLE and nothing else. This is extremely important: MS recommends it for SQL Server, it does apply as well to Oracle.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Sep 06 2000 - 12:15:05 CEST

Original text of this message