ORACLE ACTIVE SESSION IN SAP BG JOBS!!! KILL SESSIONS

AVTIVEV$SESSOINS:
===================


SELECT s.sid,s.serial#,
       s.osuser,
       s.program,
       s.status,
       S.CLIENT_IDENTIFIER,
       S.CLIENT_INFO,
       S.MODULE,
       S.MACHINE,
       S.LOGON_TIME,
       S.STATE
FROM   v$session s
   WHERE TYPE = 'USER'
   AND AUDSID != USERENV('SESSIONID')
   and s.status='ACTIVE'
order by  s.osuser


OUTPUT:

SID	SERIAL#	OSUSER	PROGRAM	STATUS	CLIENT_IDENTIFIER	CLIENT_INFO	MODULE	MACHINE	LOGON_TIME	STATE
566	57711	PRODUCTION\SAPServiceGEP	JDBC Thin Client	ACTIVE			JDBC Thin Client	GEEPASAPL3	01-NOV-15	WAITING

SQL> ALTER SYSTEM KILL SESSION '566,57711';


====================================================


UPD-PROCESS-IN DATABASE:
============================


SELECT
   LAST_UPDATE_TIME, to_char(start_time,'hh24:mi:ss') stimeopname,message,( sofar/totalwork)* 100 percent, sofar,
   totalwork,
   time_remaining,
    units,sid,USERNAME
FROM
   v$session_longops
   order by 1, 4


OUTPUT:

LAST_UPDATE_TIME	STIMEOPNAME	MESSAGE	PERCENT	SOFAR	TOTALWORK	TIME_REMAINING	UNITS	SID	USERNAME
31-OCT-15	17:56:23	Table Scan:  SAPSR3.TBTCO: 115284 out of 115284 Blocks done	100	115284	115284	0	Blocks	134	SAPSR3

ORACLE DATA FILE ALLOCATION( FOR SAP)
=======================================


SELECT SUBSTR (df.NAME, 1, 40) file_name, df.bytes / 1024 / 1024 allocated_mb,
((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0))
used_mb,
NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb
FROM v$datafile df, dba_free_space dfs
WHERE df.file# = dfs.file_id(+)
GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes
ORDER BY file_name




TOP 10 ORACLE TABLE DETAILS:
====================================


SELECT * FROM(select SEGMENT_NAME,
    SEGMENT_TYPE,
    BYTES/1024/1024/1024 GB,
    TABLESPACE_NAME
from
    dba_segments
order by 3 desc
) WHERE
ROWNUM <= 10





Thanks
Yoonus