Re: SQL stmt in SGA. Help!

My question still holds good...
In your SELECT there is a sql_text field which is 1000 long VARCHAR2 field. What happens to those statements that are longer than 1000 chars? What if a user uses a SQL statement that is 5000 chars long. Does it get stored in the SGA? or will it be truncated?
Thanks,
  Kittu.

: Try this in SQL*Plus, given to me by most excellent Oracle DBA, Ping
: Zhang
 

: ttitle CENTER "Current active SQL statements" skip 1 -
: CENTER "=========================" skip 1
: set pagesize 30
: set linesize 80
: set feedback off
: col sid format 999
: col username format A8
: break on sid on username skip 1
: select a.sid, a.username, b.sql_text from v$session a,
: v$sqltext b
: where a.sql_address = b.address and a.sql_hash_value=b.hash_value
: and a.username is not null and a.status = 'ACTIVE' and a.user# != uid
: order by a.sid, b.piece
: /
: set feedback on
: set pagesize 14
 

: Any typos are my own and not Ping's!
: Hope this helps.
 

: Mary Travis
: BellSouth Telecommunications
: Mary Travis
: BellSouth Telecommunications
: email: Mary.B.Travis_at_bridge.bellsouth.com
Received on Thu Dec 26 1996 - 00:00:00 CST