Devart Forums

While attempting to optimise performance on our oracle servers, two queries keep cropping up as using a significant amount of system resources:

select PIPELINED from sys.user_procedures where object_name = :packname and procedure_name = :procname

select PIPELINED from sys.all_procedures where owner = :schemaname and object_name = :procname and procedure_name is null


Can you please explain how and why these queries are used and if there is anything we can do to reduce the actions that cause these queries to run.

Thanks

Darren Coles

These queries are executed by provider in the background when you are:
1) assigning the CommandType property of OracleCommand/OracleDataTable to CommandType.StoredProcedure, and
2) setting function (not strored procedure) name in CommandText, and
3) not creating parameter collection manually (but using cmd.ParameterCheck = true;).

Please create parameter collection manually in this case to avoid executing the mentioned queries by the provider.

i had a feeling it might be something like that. I can manually populate the parameters and that should solve my problem.

Cheers

Darren