Query is running slow

Hello,

In my 600GB database, following query is giving output in 5 seconds but in my 18Tb of database the same query is taking 2 mins to give output

SELECT/*+ordered */ 'ALTER SYSTEM KILL SESSION '''||S.SID||','||S.SERIAL#||''' IMMEDIATE',p.spid,s.username,s.machine,osuser,s.last_call_et/60,s.logon_time,s.program,s.terminal,s.event,A.sql_textFROM v$session s ,v$sqlarea A,v$process pWHERE s.sql_hash_value= A.hash_value and s.paddr = p.addr

AND s.status  ='ACTIVE'

Thanks,