DBA Hub

📋Steps in this guide1/1

Get sql_text from sid

col sql_text form a80 set lines 120 select sql_text from gv$sqltext where hash_value= (select sql_hash_value from gv$session where sid=&1 and inst_id=&inst_id) order by piece /

oracle configurationintermediate
by OracleDba
12 views
1

Get sql_text from sid

Code/Command (click line numbers to comment):

1
2
3
4
5
6
col sql_text form a80
set lines 120
select sql_text from gv$sqltext where hash_value=
(select sql_hash_value from gv$session where sid=&1 and inst_id=&inst_id)
order by piece
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!