Oracle Database Discussions

Gents,

I am facing this issue for configuring GG initial load. I see Active transactions in GV$transaction with no sql-ids. The traansaction open time is 10 days and status is inactive in gv$session. But it still shows up in GV$transaction. Can you please suggest that:-
1. Are we good to ignore these transactions since their is no sql attached.
2. Kill those sessions as they are anyways not running any sql (But there is antry in GV$transaction)


Here is the query and its output

set lines 600 pages 1000
col MACHINE for a12
col USERNAME for a10
col inst_id for 999999
col sid for 9999
col PREV_SQL_ID for a13
col status for a8
col SERIAL# for 9999999
col USED_UREC for 99999 heading 'USED|UREC'
col USED_UBLK heading 'USED|UBLK' for 99999
col START_TIME for a17
col sql_id for a10
col COMMAND for 9999999
col last_work_time for 999999 heading 'LAST|WAKEUP'
select s.inst_id,s.sid,s.serial#,s.username,s.machine,s.module,t.status,s.status,s.command,s.sql_id,
s.last_call_et/60 last_work_time,
s.sql_id,t.used_ublk,
t.used_urec,t.start_time,t.START_SCN,SPACE,RECURSIVE,NOUNDO,PREV_SQL_ID,FLAG from gv$transaction t,
gv$session s where t.addr = s.taddr order by t.start_time desc;
LAST USED USED
INST_ID SID SERIAL# USERNAME MACHINE MODULE STATUS STATUS COMMAND SQL_ID WAKEUP SQL_ID UBLK UREC START_TIME START_SCN SPA REC NOU PREV_SQL_ID FLAG
------- ----- -------- ---------- ------------ ---------- -------- -------- -------- ---------- ------- ---------- ------ ------ ----------------- ---------- --- --- --- ------------- ----------
2 6549 186 FCDB fcemtfdas01. JDBC Thin ACTIVE INACTIVE 0 0 1 1 10/10/11 19:05:55 4572476454 NO NO NO bunvx480ynf57 4199939
esptest.aurt Client
est.national
.com.au