-
Alter Session
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
Thanx
Sam
Life is a journey, not a destination!
-
Alter session set timezone = ...
-
You could ...
Code:
select OWNER,NAME,TYPE,LINE,text
from dba_source
where upper(text) like '%ALTER%SESSION%SET%TIMEZONE%'
... to find out if there is a trigger or procedure that might be doing this.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|