|
|
|
|
|
|
|
|
Re: FTS - Full Table Scan - [message #416965 is a reply to message #416964] |
Wed, 05 August 2009 07:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
satish2130
Messages: 5 Registered: August 2009 Location: India
|
Junior Member |
![satish_orre20%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![satishorre20](/forum/theme/orafaq/images/google.png)
|
|
Ok.
Is there any negative impact on the other jobs if they are running simultaneously??
Is there any chance to increase the buffer size/Temporary Segement for this Query or anything else?
Please let me know your valuable suggestions,
Thanks,
Satish
[Updated on: Wed, 05 August 2009 07:44] Report message to a moderator
|
|
|
Re: FTS - Full Table Scan - [message #416971 is a reply to message #416965] |
Wed, 05 August 2009 08:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ You use more blocks but you need them so you will anyway use them but as you load them in few you lock less the SGA and so it is positive
2/ I don't understand what you mean
Regards
Michel
|
|
|