We have migrated from an oracle 10g to an oracle 11g Database.
The instance of Database 11g is totally new an installed on a VirtualMachine in a different HW. The new DB is on Windows Server 2013 while the old one is on Windows Server 2008 sp2.
We have imported the old 10g database to the new 11g database.
The overall performance of the new DB is much faster than the old on sqlplus but not when queried through web services.
The WebService is the same. Calling the same qry the DataSet.Fill on the old DB is 3 time faster than the new DB.
Calling the same query with sqlplus on the PC hosting the web server, the query is fast on both sides and faster on the new side.
So I think that the problem could be in the listener configuration but I haven't a clue where to start configuring it in order to increase the websevice performances...