Oracle Database Discussions

I am running a 10.2.0.1.0 server on Windows XP 64 with 4GB of memory.

When I connect with SQLPlus, the first time that I try any action across a database link (even a simple describe, for example), the memory usage for my Oracle process jumps by approximately 2GB until the request returns. Each subsequent action across any database link (not necessarily the same link as the first attempt) does not have this happen. That first action also is much slower than the subsequent actions (describes can take anywhere from five or so seconds to a few minutes for the first action, but less than a second for the subsequent actions... also, the network connection is fine during this time, so I don't think that is the problem).

There are no Oracle errors reported... the only error I get is a warning message from Windows saying that the virtual memory is full and all of my apps slow to a crawl until I either kill the Oracle process or the request over the database link returns.

If anyone has any ideas as to what may be the problem, I would appreciate hearing them.

Thank you,
James