On Mar 26, 2:20 pm, Marcus Stumm <marcus.st..._at_arcor.de> wrote:
> Hello,
>
> I am suspecting an issue with a Media Management Library. The Backup and
> Recovery Advanced User's Guide from oracle states the the follwoing query
> can be used to monitor sbt events.
>
> SELECT p.SPID, EVENT, SECONDS_IN_WAIT AS SEC_WAIT,
> 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;
>
> When I run this statement:
>
> SQL> SELECT p.SPID, EVENT, SECONDS_IN_WAIT AS SEC_WAIT,
> 2 STATE, CLIENT_INFO
> 3 FROM v$Session_WAIT sw,V$session s, v$process p
> 4 WHERE sw.EVENT LIKE 'SBT%'
> 5 and s.SID=sw.SID
> 6 and s.PADDR=p.ADDR;
>
> it throws an error
>
> STATE, CLIENT_INFO
> *
> ERROR at line 2:
> ORA-00918: column ambiguously defined
>
> But I can not see the reason why as my SQL-knowledge is not straight
> enough. I would be greateful id somebody can help me out.
>
> Thanks in advance
>
> Marcus
Compare the output of:
DESC V$SESSION_WAIT
and
DESC V$SESSION
You probably want to indicate where these columns should come from:
SECONDS_IN_WAIT, STATE, CLIENT_INFO, EVENT.
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Mon Mar 26 2007 - 13:44:23 CDT
