Can you tell me when and why "Alter session" gets triggered?
I have a PHP/Oracle site where i dont use alter session anywhere in my PHP code. But still i see this getting triggered in database and freezes the database.
some sort or trigger perhaps
What is the full command?
Check your envrionment setup too
Life is a journey, not a destination!
Alter session set timezone = ...
You could ...
... to find out if there is a trigger or procedure that might be doing this.
where upper(text) like '%ALTER%SESSION%SET%TIMEZONE%'
what does "freezes the database" mean? What are you seeing?
"False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20
Click Here to Expand Forum to Full Width