Home » SQL & PL/SQL » Client Tools » toad related issue (oracle apps 11.5.10 erp,oracle 10g database)
toad related issue [message #300084] Thu, 14 February 2008 03:33 Go to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Hi,
We had recently upgraded our data base from oracle 9i to oracle 10g version for our oracle apps 11.5.10 environment.There is no problem with our front end i.e. application but we are using toad 8.0.0.47 version as sql and pl/sql client tool for development,And we had a performance problem here.Toad is taking too much time to open a procedure code in schema browser and taking lot more time for loading into procedure editor and compilation.could any one help us out.
regards
vizith
Re: toad related issue [message #300090 is a reply to message #300084] Thu, 14 February 2008 03:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Upgrade TOAD as well?
Re: toad related issue [message #300092 is a reply to message #300090] Thu, 14 February 2008 03:53 Go to previous messageGo to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Hi,
We did not upgraded toad version.Before upgradation itself we are using toad 8.0.0.47 and when i searched regarding comaptiable version for toad i found this version is comaptiable friend.


Re: toad related issue [message #300095 is a reply to message #300092] Thu, 14 February 2008 03:59 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to ask for help on TOAD's pages? Does this FAQ (Why can Toad sometimes seem to run slower on Oracle 10g?) help? Did you check other FAQs?
Re: toad related issue [message #300099 is a reply to message #300095] Thu, 14 February 2008 04:12 Go to previous messageGo to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Hi,
thank you sir,i am referring that document now and trying to purge that data in recycle bin.will look the status and update it
thank you so much .
regards
vizith
Re: toad related issue [message #300104 is a reply to message #300084] Thu, 14 February 2008 04:28 Go to previous messageGo to next message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Hi,
I tried this FAQ (Why can Toad sometimes seem to run slower on Oracle 10g?) page referenced steps,but still it is very much.

exec dbms_stats.gather_dictionary_stats;
exec dbms_stats.gather_fixed_objects_stats;


we all ready done these steps and new we did following steps which are specified in that page

PURGE RECYCLEBIN;

or if you are a DBA enabled user :

PURGE DBA_RECYCLEBIN;


but still it is giving us same trouble sir

regards
vizith

Re: toad related issue [message #300128 is a reply to message #300104] Thu, 14 February 2008 05:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I can't help you any further. Perhaps you should really ask for help at Quest Software.
Re: toad related issue [message #300142 is a reply to message #300128] Thu, 14 February 2008 07:12 Go to previous message
Vizith
Messages: 32
Registered: October 2007
Location: bangalore
Member
Hi,
Thank you sir,we made a call to quest software they will come and look into it.thank you so much for your valid information.
it as really helpful

regards
vizith
Previous Topic: SQL Developer and Multiple Oracle Homes
Next Topic: Isqlplus not opening in my Server
Goto Forum:
  


Current Time: Sat Dec 10 01:32:23 CST 2016

Total time taken to generate the page: 0.08367 seconds