kill session Options

[Rekha Anupati]

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

[burleson]

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

[Rekha Anupati]

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,