Home » SQL & PL/SQL » SQL & PL/SQL » in which way to tune my database
in which way to tune my database [message #258744] Mon, 13 August 2007 09:00 Go to next message
Messages: 4
Registered: June 2007
Location: chennai
Junior Member

hi all,
In my company, every month after 20, the performance of
database goes slower.... what could be the impact... since we are
doing payroll processing, the month end will have huge transcations
and my database is running on linux platform. tell me wat are all the
tuning steps to do.. i am checking the sga size, Max_process and
monitoring the database....
Re: in which way to tune my database [message #258746 is a reply to message #258744] Mon, 13 August 2007 09:08 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The first step I always do is have a look what the actual bottleneck is.

- CPU load
- Disk I/O
- Memory

Maybe something is mis-configured there. E.g. it could be slow because the machine is starting to swap or a disk controller is mis-configured.

If that looks OK on the OS side, have a look at the Performance Tunig Sticky :

Previous Topic: How to Analyze the table
Next Topic: why oracle writes first redolog after commit was issued?
Goto Forum:

Current Time: Thu Jul 27 17:54:23 CDT 2017

Total time taken to generate the page: 0.12722 seconds