| toad related issue [message #300084] |
Thu, 14 February 2008 03:33  |
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 #300092 is a reply to message #300090] |
Thu, 14 February 2008 03:53  |
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 #300099 is a reply to message #300095] |
Thu, 14 February 2008 04:12 |
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 |
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 #300142 is a reply to message #300128] |
Thu, 14 February 2008 07:12 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
