Difference between v$sql v$sqltext v$sqltext_with_newlines
select * from x
if user A and B are executing (in shared pool ) above query then we will have 2 rows in v$sql
v$sqlarea:- aggregate of v$sql. It selects out DISTINCT sql.select * from x
will appear there.
v$sqltext:- for full text
v$sqltext_with_newlines: - without the white space replacement and tab.