The current SQL (as reported in the SQL Text tab in the Tools->Sessions window) is:
select s.synonym_name as object_name, o.object_type
from sys.all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
The open cursors for that same session (Cursors tab in the Tools->Sessions window) are:
select col#,intcol#,reftyp,stabid,expctoid from refcon$ wher
select col#,intcol#,reftyp,stabid,expctoid from refcon$ wher
select timestamp, flags from fixed_obj$ where obj#=:1
select timestamp, flags from fixed_obj$ where obj#=:1
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
select /*+ index_ss(obj$ i_obj2) */ obj#,type#,ctime,mtime,s
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#
select parttype, partcnt, partkeycols, flags, defts#, defpct
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by
select con#,type#,condlength,intcols,robj#,rcon#,match#,refa
select con#,type#,condlength,intcols,robj#,rcon#,match#,refa
select con#,type#,condlength,intcols,robj#,rcon#,match#,refa
select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
select name,intcol#,segcol#,type#,length,nvl(precision#,0),d
select decode(u.type#, 2, u.ext_username, u.name), o.name,
select /*+ rule */ bucket, endpoint, col#, epvalue from hist
select /*+ rule */ bucket, endpoint, col#, epvalue from hist
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0
select increment$,minvalue,maxvalue,cycle#,order$,cache,high
select text from view$ where rowid=:1
select value$ from props$ where name = 'GLOBAL_DB_NAME'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,
select col#,intcol#,charsetid,charsetform from col$ where ob
select col#,intcol#,charsetid,charsetform from col$ where ob
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ whe
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ whe
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ whe
select intcol#, toid, version#, intcols, intcol#s, flags, sy
select intcol#, toid, version#, intcols, intcol#s, flags, sy
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla
select col#,intcol#,toid,version#,packed,intcols,intcol#s,fl
select col#,intcol#,toid,version#,packed,intcols,intcol#s,fl
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$
select privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2))
select privilege#,level from sysauth$ connect by grantee#=pr
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('U
select user#,password,datats#,tempts#,type#,defrole,resource
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t
select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECON
select privilege# from sysauth$ where (grantee#=:1 or grante
select cols,audit$,textlength,intcols,property,flags,rowid f
select cols,audit$,textlength,intcols,property,flags,rowid f
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid,
select node,owner,name from syn$ where obj#=:1
select node,owner,name from syn$ where obj#=:1
Is that what you're looking for?
).