Database Administration (MOSC)

MOSC Banner

Get sql_text's executed by another user !

edited Oct 31, 2011 11:02PM in Database Administration (MOSC) 1 commentAnswered
 Hi all,
   I want view sql was executed by another user, I use bellow scipt:

--------------------------------------
   select sesion.sid,
       sesion.username,
       optimizer_mode,
       hash_value,
       address,
       cpu_time,
       elapsed_time,
       sql_text
  from v$sqlarea sqlarea, v$session sesion
 where sesion.sql_hash_value = sqlarea.hash_value
   and sesion.sql_address    = sqlarea.address
   and sesion.username is not null
--------------------------------------

   But in the sql_text, content of sql not enough ! Seem as it was cutted ! Ex: original content is abc123 --> after elect it has value is abc.

   Are there some methods that I can view completely sql text ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center