queries performing very slow from Toad,cognos and powerbuilder, but very fast from sql developer
Hi,
I am facing a weird issue for last couple of weeks. when we try to run queries from cognos , power builder ,sqlplus from windows
or toad,It is taking minutes even If I run simple query like "select * from dba_tables", where as the same query is running
within 1 sec if I use sql developer or using sqlplus from the db server or using sqlplus from any other hp server.
At the same If I run select sysdate from dual, It is faster in all the tools. I dont know where is the issue is...
I suspect It can be a issue with network. Also it is happing for all of our databases. There is no changes in db for sometime.
I am facing a weird issue for last couple of weeks. when we try to run queries from cognos , power builder ,sqlplus from windows
or toad,It is taking minutes even If I run simple query like "select * from dba_tables", where as the same query is running
within 1 sec if I use sql developer or using sqlplus from the db server or using sqlplus from any other hp server.
At the same If I run select sysdate from dual, It is faster in all the tools. I dont know where is the issue is...
I suspect It can be a issue with network. Also it is happing for all of our databases. There is no changes in db for sometime.
0