Running TOAD remotely.

Toad for Oracle
1

Hi All,

I can retrieve my query results in a second, if I run my TOAD session using LAN
IP.
But if I use an external IP and launch TOAD and run the same query, it take an
unusually long time ( like 55 minutes ) and I’d have to kill the session.

For instance :

select * from mtl_parameters order by organization_id ( 1 second to fetch
results on my LAN ; 1 hour and still no results from my external IP TOAD
connection ).

What am I missing here ? Some queries work fine remotely, most dont. ( Tried
with Toad 9.0 and Toad 9.7 as well )

Thanks,
Sam.

2

This may or may not help. However,

We do not as a rule allow remote connections except for a handfull of people
that have VPN’s.

Remote desktop does not work outside our network.

I connect remotely to my desktop via Logmein ( www.logmein.com ) and I run TOAD
as if I was sitting at my desk (because TOAD thinks I am at my desk. I USE THE
FREE VERSION AND IT WORKS FINE.

If you are not familiar with it, you download it to your office desktop before
going home. When you get home you simply connect using the internet.

Let me know if this helps you.

On Wed, Sep 22, 2010 at 8:27 AM, Sam M. Koshy wrote:

Hi All,

I can retrieve my query results in a second, if I run my TOAD session using
LAN IP.
But if I use an external IP and launch TOAD and run the same query, it take
an unusually long time ( like 55 minutes ) and I'd have to kill the
session.

For instance :

select * from mtl_parameters order by organization_id ( 1 second to fetch
results on my LAN ; 1 hour and still no results from my external IP TOAD
connection ).

What am I missing here ? Some queries work fine remotely, most dont. ( Tried
with Toad 9.0 and Toad 9.7 as well )

Thanks,
Sam.
3

And what happens if you run the same query in SQL-Plus? Does it change when you
do select count(*) from…? (then you can see if it is the data or the query
itself).
Groetjes,
Wim

On Wed, Sep 22, 2010 at 15:27, Sam M. Koshy wrote:

Hi All,

I can retrieve my query results in a second, if I run my TOAD session using
LAN IP.
But if I use an external IP and launch TOAD and run the same query, it take
an unusually long time ( like 55 minutes ) and I'd have to kill the
session.

For instance :

select * from mtl_parameters order by organization_id ( 1 second to fetch
results on my LAN ; 1 hour and still no results from my external IP TOAD
connection ).

What am I missing here ? Some queries work fine remotely, most dont. ( Tried
with Toad 9.0 and Toad 9.7 as well )

Thanks,
Sam.