BenA
Member
We have several sql statements that are virtually locked into the SGA of our database due to the frequency which they are executed. They range from once a centi-second to 3 to 4 times a centi-second. From looking at snap-shots of our database, they appear to be coming from oexplorer, jdequeues and jdenet_k type of connections.
I'm trying to figure out if this is a bug in the reporting of the number of times they are being executed or if they actually are being executed that often and if so, then how and why. This happens on our production and our test systems. The test system should be almost dormant as compared to our production system, but the issue still shows up.
Anyone else notice this behavior on their system?
I'm trying to figure out if this is a bug in the reporting of the number of times they are being executed or if they actually are being executed that often and if so, then how and why. This happens on our production and our test systems. The test system should be almost dormant as compared to our production system, but the issue still shows up.
Anyone else notice this behavior on their system?