View oracle session

[Former Member]

Hello,

If I run a SQL command like "Alter database..." and I want to know if it is still running, I can use ST04 to check the Oracle session.

Can someone tell me how I can monitor the activity via SQL or OS level? I think can see from v$session but not sure about the exact SQL syntax.

Thanks!

[former_member204746]

[message deleted]

[Former Member]

Hi,

The below sql statements should give the currently executing SQL statements, Not sure if it captures 'alter database' statement as well but you could try it out.

I use it mostly to terminate some oracle session which can't be terminate from within SAP.

select c.spid, b.sid, b.serial#, b.process, a.sql_text from v$sqltext a, v$session b, v$process c

where b.status = 'ACTIVE'

and a.address = b.sql_address

and c.pid = b.sid

and c.serial# = b.serial#

order by a.address, a.piece

/

Thanks and Best Regards,

Sunil.

[stefan_koehler]

Hello,

not really sure about your request.. but:

>shell> sqlplus "/ as sysdba"

>SQL> SELECT * FROM V$SESSION;

Regards

Stefan