Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query sbt events throws an error ORA-00918: column ambiguously defined
Am Mon, 26 Mar 2007 20:38:41 +0200 schrieb sybrandb:
> On 26 Mar 2007 18:20:49 GMT, Marcus Stumm <marcus.stumm_at_arcor.de> > wrote: >
> > The state column occurs in more than one table, so SQL doesn't know > from which one. > You need to run > DESC <table> > and find out in which tables it occurs, choose the right one and > prefix state with the alias of this table. > > Hth
Hello
following yur suggestions done the trick:
select p.SPID, sw.EVENT, sw.SECONDS_IN_WAIT AS SEC_WAIT,
sw.STATE, CLIENT_INFO
FROM V$SESSION_WAIT sw, v$SESSION s, V$PROCESS p
where sw.EVENT LIKE 'sbt%'
and s.SID=sw.SID
and s.PADDR=p.ADDR
How ever I tried all combinations but all coming back with:
now rows selected
so the MML can not be the issue.
Thansk for your help. Received on Wed Mar 28 2007 - 14:04:48 CDT