|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 15th, 2005, 04:03 AM
|
|||
|
|||
|
Database operaton becoming slow
I am working in linux. One of my process quering a table is taking some huge time (not all the time) but some rare cases.
In that time my another process which is inserting and deleting in a differnet table becomes slow. Why is it happening ????? Is the first process taking all DB resources or what else may be the reason.... Suggest me some good solutions or the way to analyse 
|
|
#2
February 15th, 2005, 12:47 PM
|
|||
|
|||
|
Learn to use tkprof to see Oracle is doing - if you are searching on a column that is not indexed it slows things down a lot.
You may have contention for update - one of the processes is doing Code:
select * from mytable for update; and the other table needs to reference mytable.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Database operaton becoming slow |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
