TOAD and ORA10g

[Aci Polajnar]

Hi there!

After migrating ORA 10.2.0.3 to 10.2.0.4 we have extremely bad response
time while
trying to debug ORA stored procedures with TOAD. It takes several
minutes before
TOAD opens parameter window. It happens in all versions of TOAD from 9.0
to 9.6.1.1.
Strange thing is that users with DBA privileges doesn't have this problems.

Any help
Regards!

--
To elektronsko sporočilo in vse morebitne priloge so poslovna skrivnost in namenjene izključno naslovniku.
Če ste sporočilo prejeli pomotoma, Vas prosimo, da obvestite pošiljatelja, sporočilo pa takoj uničite.
Kakršnokoli razkritje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano.
Ni nujno, da to sporočilo odraža uradno stališče družbe.

Elektronsko sporočilo je pregledano z antivirusnim programom.

This e-mail and any attachments may contain confidential and/or privileged information and is intended solely for the addressee.
If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
This e-mail may not necessarily reflect the offical viewpoint of the company.

E-mail message is scanned by Anti-Virus Software.

 


begin:vcard
fn:Aci  Polajnar
n:Polajnar;Aci
org:MRI d.o.o.
adr;quoted-printable:;;A=C5=A1ker=C4=8Deva 14;CELJE;Slovenia;3000;Slovenia
email;internet:acip@...
title:IS Consultant
tel;work:[phone]
tel;fax:[phone]
tel;home:[phone]
tel;cell:[phone]
note;quoted-printable:=0D=0A=
       
url:http://www.mri.si
version:2.1
end:vcard

[Jeff Smith-7]

Try turning Database > Spool SQL > To Screen ON

Then walk through the process again.

Then go through the log and look for the SQL statement that's causing the bottleneck.

After your migration did your DBA refresh the STATS on the data dictionary?
________________________________________
From: toad@... [toad@...] On Behalf Of Aci Polajnar [acip@...]
Sent: Thursday, July 10, 2008 1:50 AM
To: toad@...
Subject: [toad] TOAD and ORA10g

Hi there!

After migrating ORA 10.2.0.3 to 10.2.0.4 we have extremely bad response
time while
trying to debug ORA stored procedures with TOAD. It takes several
minutes before
TOAD opens parameter window. It happens in all versions of TOAD from 9.0
to 9.6.1.1.
Strange thing is that users with DBA privileges doesn't have this problems.

Any help
Regards!

--
To elektronsko sporočilo in vse morebitne priloge so poslovna skrivnost in namenjene izključno naslovniku.
Če ste sporočilo prejeli pomotoma, Vas prosimo, da obvestite pošiljatelja, sporočilo pa takoj uničite.
Kakršnokoli razkritje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano.
Ni nujno, da to sporočilo odraža uradno stališče družbe.

Elektronsko sporočilo je pregledano z antivirusnim programom.

This e-mail and any attachments may contain confidential and/or privileged information and is intended solely for the addressee.
If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
This e-mail may not necessarily reflect the offical viewpoint of the company.

E-mail message is scanned by Anti-Virus Software.




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

Questions?  Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards?  Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! 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:
    mailto:toad-digest@...
    mailto:toad-fullfeatured@...

<*> To unsubscribe from this group, send an email to:
    toad-unsubscribe@...

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

[Bert Scalzo]

Yes - the stats is a good place to start (i.e. eliminate as a possible cause). Then try some other ideas from the links below. I know it seems like a Toad issue, but you've already said when we upgraded Oracle. So we need to eliminate some known Oracle things before we can assess this properly - because eliminating these issues will help us to better focus internally on toad code once you can confirm that none of these other things remain as potential problems.



http://asktoad.com/DWiki/doku.php/faq/answers/database_versions#why_can_toad_sometimes_seem_to_run_slower_on_10g



http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/135/Default.aspx



http://www.toadworld.com/Community/QuestExpertsBlogs/tabid/67/EntryID/162/Default.aspx









-----Original Message-----
From: toad@... [mailto:toad@...] On Behalf Of Jeff Smith
Sent: Thursday, July 10, 2008 5:49 AM
To: toad@...
Subject: RE: [toad] TOAD and ORA10g



Try turning Database > Spool SQL > To Screen ON



Then walk through the process again.



Then go through the log and look for the SQL statement that's causing the bottleneck.



After your migration did your DBA refresh the STATS on the data dictionary?

________________________________________

From: toad@... [toad@...] On Behalf Of Aci Polajnar [acip@...]

Sent: Thursday, July 10, 2008 1:50 AM

To: toad@...

Subject: [toad] TOAD and ORA10g



Hi there!



After migrating ORA 10.2.0.3 to 10.2.0.4 we have extremely bad response

time while

trying to debug ORA stored procedures with TOAD. It takes several

minutes before

TOAD opens parameter window. It happens in all versions of TOAD from 9.0

to 9.6.1.1.

Strange thing is that users with DBA privileges doesn't have this problems.



Any help

Regards!



--

To elektronsko sporočilo in vse morebitne priloge so poslovna skrivnost in namenjene izključno naslovniku.

Če ste sporočilo prejeli pomotoma, Vas prosimo, da obvestite pošiljatelja, sporočilo pa takoj uničite.

Kakršnokoli razkritje, distribucija ali kopiranje vsebine sporočila je izrecno prepovedano.

Ni nujno, da to sporočilo odraža uradno stališče družbe.



Elektronsko sporočilo je pregledano z antivirusnim programom.



This e-mail and any attachments may contain confidential and/or privileged information and is intended solely for the addressee.

If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail.

Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

This e-mail may not necessarily reflect the offical viewpoint of the company.



E-mail message is scanned by Anti-Virus Software.









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



Questions?  Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions



Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad



Do you know about the other TOAD Yahoo Message Boards?  Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links



    http://groups.yahoo.com/group/toad/



    Individual Email | Traditional



    http://groups.yahoo.com/group/toad/join

    (Yahoo! ID required)



    mailto:toad-digest@...

    mailto:toad-fullfeatured@...



    toad-unsubscribe@...



    http://docs.yahoo.com/info/terms/