Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.
GovindanK
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or,
Yesterday i posted a reply on this .. but did not reach.
Check if too much logging taking place. Avoid this with loading as
UNRECOVERABLE; Or else Presort the data on the index key to minimise
the use of Temp segment. As of now i am able to think of only these two.
HTH
GovindanK
Hi gurus,
we
Hello
Did you check alert.log for any unusual messages? May be it is using lot of
rollback / archiving.
You can use unrecoverable option to load. You have not mentioned whether
you are using direct load or not.
Check if too many extents are getting allocated at runtime. That is
going to slow
Check with
http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548
Make sure to shutdown/start related stuff (viz OAS) that might have been
installed too.
Also, on some UNIX systems, NFS file system from Server A might have been
mounted on Server B. If so, you need to
Back in India, the academic qualification is weighed more than anything
else. Guys from institutes like Indian Institute of Technology IITs
/ Indian Institue Management (IIT/IM) (to quote an example) are treated as
demi-godes and look at with awe (even if the guy doesn't know anything
about
May be Metalink note 111910.1 will help you.
HTH
GovindanK
Hi everybody,
I'm new to the list, I don't know anything about oracle. I have make a
script to get some informations by stored procedures on a remote server.
I can't access this server, and can't get logs from it.
Since 5
Yep. Forgot to mention that. But there is a catch. Sometimes the
Connection pooling logic doesn't make call to the same SID,Serial#
combination. Hence you might find quite a no.of SNIPEd sessions remaining
in v$session. Just keep an eye on it along with avbl shared_pool at
runtime. When you