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 -> what's wrong with the result of the query on v$sql

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

From: cobra <rock252_at_126.com>
Date: 25 Nov 2006 01:17:20 -0800
Message-ID: <1164446240.473894.305480@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.
Received on Sat Nov 25 2006 - 03:17:20 CST












Original text of this message













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