Jeff
Jeff

Reputation: 21

oracle APEX page loads slow because of alter session

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

enter image description here

Upvotes: 1

Views: 887

Answers (1)

Gary Myers
Gary Myers

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

Related Questions