Reputation: 21
Anyone know what to check to find out why alter session statement take a long time when loading an APEX page. In the debug report, most things run fast. All alter session statements take a lot of time in comparison. A bunch of alter statements are adding up to cause the page to load slow. Here is the first few lines of the debug
Upvotes: 1
Views: 887
Reputation: 35401
I'd see if you've got auditing enabled. If so, turn it off
SELECT * FROM DBA_STMT_AUDIT_OPTS WHERE audit_option = 'ALTER SESSION';
Upvotes: 1