Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

begin f(p=>:1 ); commit; end;

Matthew MorrisOct 8 2011 — edited Dec 28 2011
I was doing some tuning of my Oracle instance running Apex this morning, and the above text is the top by elapsed time, CPU time, and user wait time (with ~4500 executions in the past three days). It's not my SQL. By the look of it, it's probably a commit being performed by Apex itself. I'd just like to have an idea if that's what it is, if it's normal for it to be relatively expensive overal SQL operation, if there's any resource I can give that will make it faster, etc.
This post has been answered by Joel_C on Dec 28 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2023
Added on Oct 8 2011
3 comments
2,331 views