RE: Couple of foibles in Toad 11.6.0.43

I've not been able to reproduce case 1 here. After discussing with Bert I started mucking around with some SQLNET params I thought may cause the delay, but no joy. At any rate, do you have anything in sqlnet.ora that looks suspicious? You can also send user files offline. Perhaps it's option related.

Michael

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Michael Staszewski
Sent: Monday, January 28, 2013 3:07 PM
To: [email protected]
Subject: RE: [toad] Couple of foibles in Toad 11.6.0.43

Case 1. Does Toad ever shutdown? I just setup a test case and shutdown the server while Toad was connected. Got the editor prompts and what not and Toad just sat there for a period of time and finally shutdown. I didn't investigate much, but the time was about the same it takes to get an ORA exception due to the lost connection. I assume that Toad was polling to see if any transactions were outstanding and had to wait for the exception.

Michael

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar
Sent: Monday, January 28, 2013 2:35 PM
To: [email protected]
Subject: [toad] Couple of foibles in Toad 11.6.0.43

Evening all,

I have a strange problem. Not Toad's fault, but it gives Toad a headache.

1. A connection to a database has dropped, and attempting to test connections fails because the listener on the server has gone down.

Attempting to exit Toad at this point does the usual "are you sure?" and asks me to save a MOE tab. I choose "no" to the save prompts and then Toad fails to shut down because it cannot reconnect to the server. I am going to have to terminate it with extreme Task Manager in a second or two!


2. In the schema browser I'm needing to look at the auto tasks views, similar to the scheduler stuff already visible. These are present in
11.1.0.6 onwards. The views are DBA_AUTOTASK_%.

I can look at them in the MOE, but I'd like to be able to look via the Scheme Browser - because it's much much better that way.

Obviously, this might already be in the 12 Beta, in which case, I'll butt out!

There's a wee bit about these auto tasks on my blog at http://qdosmsq.dunbar-it.co.uk/blog/2013/01/oraat_sa_spc_sy-jobs-failing/ if anyone is interested.


Thanks.


Cheers,
Norm.

--
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/