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

Giganews Newsgroups
Subject: what's wrong with the result of the query on v$sql
Posted by:  cobra (rock2…@126.com)
Date: 25 Nov 2006

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.

Replies