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

Giganews Newsgroups
Subject: Re: what's wrong with the result of the query on v$sql
Posted by:  Michel Cadot (micadot{at}altern{dot}org)
Date: Sat, 25 Nov 2006

"cobra" <rock2…@126.com> a ¨¦crit dans le message de news: 1164446240.473894.3054…@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

Replies

None

In response to

what's wrong with the result of the query on v$sql posted by cobra on 25 Nov 2006