I have a cursor which is in a function in a Oracle package.

I call the Function with a C# process and the cursor takes about 5 min to fetch something.

When I restart the process the cursor takes less than 100 milliseconds… Than after 3 or 4 days the cursor takes 5 min again.

The whole database are slow. When I see the logs of other process, some update or select that takes normally less than 100 milliseconds takes more than 2 or 3 seconds.

When I execute the select in a worksheet in SQLDeveloper it takes less than 100 milliseconds.

Have someone an idea in which way can I analyse this problem ?