| Neeraj |
Posted: Oct 05, 2007 06:04:32 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
in my server many proces r being processed, but one of them proces which r updating a table getting slow but running.
tell y it happened & how can i make it speed up again.
its a taking long time to updating a particular table.other proces running well.size is enough.
thxs |
|
|
 Ratnaker |
| Posted: Oct 08, 2007 03:05:17 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Hi,
take statspack report check the report.
ratnaker
|
|
|
|
|
| parthokonar |
| Posted: Oct 11, 2007 10:52:14 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
Get the query and tune it properly i.e sql tuning is required.
|
|
|
|
|
| suni |
| Posted: Oct 17, 2007 01:45:49 AM | |
|
Total Post: 11
Joined: Oct, 2007
|
Go for analayzing that table
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
