Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what's wrong with the result of the query on v$sql

Re: what's wrong with the result of the query on v$sql

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 25 Nov 2006 10:35:46 +0100
Message-ID: <45680e73$0$11692$426a74cc@news.free.fr>

"cobra" <rock252_at_126.com> a ¨¦crit dans le message de news: 1164446240.473894.305480_at_j72g2000cwa.googlegroups.com...
| Hi:
| I execut the statement in sqlplus as follow:
|
| select sql_text,username, from v$sql a,dba_users b where
| a.PARSING_USER_ID = b.user_id ;
|
| Many results of the username returned are 'SYS',But in fact 'SYS'
| never do something.
| What's wrong?
| Thanks in advance.
|

SYS executes recursive statements on dictionary. Have a look at the statements returned by your query (which contains a syntax error, it'd be better to always post *exactly* what you do AND your Oracle version).

Regards
Michel Cadot Received on Sat Nov 25 2006 - 03:35:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US