Seema,
This will show you all SQL in the SQL area for a certain SID, as well as
showing you the currently executing cursor.. Simply input the SID value you
are interested in where it says (*SID*)..
---
select s.sid sid,
Seema Singh wrote:
Hi
Does any one have sql scripts which show us sql text when we enter unix
process id or oracle SID ?
Please send if any one have.
Thx
-Seema
For the unix pid (of the server process) I think there is something of
the kind on http://www.oriole.com, in the free toolkit
Hi Sanjay,
Try the following:
-- this one will be faster but only shows the first 1000 characters of the
SQL
select username, q.*
from
v$session s , v$sql q
where
q.address = s . sql_address
and q.hash_value = s.SQL_HASH_VALUE
and s.username = 'user'
On Tue, 13 Feb 2001, Sanjay Kumar wrote:
hi,
I want to see the latest SQL Statements that I sent to Database. I know that I can
make use of V$sqlarea but it restricts only to first 1000 characters.
But my query is more than that.
Use v$sqltext or v$sqltext_with_newlines. Simple join