Oracle Server Tuning

 

ORACLE SERVER TUNING

 

Server Tuning:- server tuning refers that the server on which database resides is proper tuned i.e.

 

Here I am using a example of how a server is tuned properly and how input/output response from server should be at best performance rate.

 

Example:- let us suppose a database named TESTDB and there are 7 tablespaces are associated with that database.

 

These 7 Tablespaces has 7 data files there  roles in the database are:-

 

1.      testtbl_1.dbf  for previous year data( for read )

2.      testtbl_2.dbf  for current year data (read and write both)

3.      testtbl_3.dbf for index data(for read)

4.      system.dbf for database information.

5.      Testtemp_1.dbf for temporary data

6.      testundo_1.dbf for undo tablespace

7.      testtbl_7.dbf for history data more then one year

 

here some tablespace are for previous year data which is now using as history tablespaces and they are only for read purpose some tablespaces are for indexes and some for writable purpose and some for read and write both.

 

 

Just remember these main points while creating tablespaces

 

1.      tablespaces for read purpose are always on different disk

 

2.      tablespace for write purpose are on different disk

 

3.      indexes tablespaces are on different disk you can also create them with read only tablespace disk.

 

4.      Always trying to maintain the input/output management

because if read and write tablespace are on same disk I.e if input and output are performing on same disk in a database then it will degrade the system performance because input output are running on same disk if they are on different disks then you will notice the big improvement in speed.

 

5.      Always create objects on their respectively tablespace not on SYSTEM tablespace if system tablespace contains users objects like tables,triggers etc. then it create lack of performance.