Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> kill session
Rekha Anupati
post Apr 30 2012, 02:32 PM
Post #1


Advanced Member
***

Group: Members
Posts: 130
Joined: 19-April 12
From: california
Member No.: 47,104



Can somebody please answer why my alter system kill is not been listed when i do an sql_text on v$sqlarea? my understanding all the sql's should be listed here. am i missing something?



SQL> alter system kill session '144,19311';

System altered.

SQL> select sql_text from v$sqlarea where sql_text like 'alter system%';

no rows selected
Go to the top of the page
 
+Quote Post
burleson
post Apr 30 2012, 03:01 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,623
Joined: 26-January 04
Member No.: 13



Hi,

>> alter system kill is not been listed when i do an sql_text on v$sqlarea?

The "alter session" is not a SQL statement! All SQL's begin with either select, merge, with, update, delete insert or delete.

Please read, this may help:

http://www.dba-oracle.com/t_alter_system_kill_session.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Rekha Anupati
post Apr 30 2012, 03:36 PM
Post #3


Advanced Member
***

Group: Members
Posts: 130
Joined: 19-April 12
From: california
Member No.: 47,104



thank you so much for the contribution. I looked at your provided URL and its clear to me why alter sessions can not be tracked.

thanks again,
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th October 2014 - 04:15 PM