Home » RDBMS Server » Server Utilities » increase performace of oracle server without upgrading hardware
increase performace of oracle server without upgrading hardware [message #70128] Thu, 18 April 2002 07:31 Go to next message
Loo Bin Soon
Messages: 8
Registered: April 2002
Junior Member
HI anyone know how to increase the performance of a database. Beside tunning the sql statement, upgrading the hardware. Is there any way to increase the performance of the oracle server. example speed up the execuation of a sql statement. I had tried to increase the temporary tablespace, create big rollback segment but performance is still the same. Anyone know how to increase the performace of an oracle server without upgrading the hardware?

Report message to a moderator

Re: increase performace of oracle server without upgrading hardware [message #70132 is a reply to message #70128] Thu, 18 April 2002 17:44 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
1. index object
2. shared pool, i/o tuning,cache the object on buffer.
3. network ability.
4. business operation logic. reschedule operation.

Report message to a moderator

Re: increase performace of oracle server without upgrading hardware [message #71868 is a reply to message #70128] Thu, 23 January 2003 04:35 Go to previous message
vairtung
Messages: 1
Registered: January 2003
Junior Member
one more step for increasing the performace of database is by adding the redolog file and increasing the total size of redo logs.

this will reduce the shifting of redo logs and decreases the waits and hence increasing the efficiency.

Report message to a moderator

Previous Topic: ORA-01475 error
Next Topic: Rollback
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 19:37:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.