I will explain v$sqltext and v$sqlstats in Oracle in this post.   You can read the following post to learn v$sql views. V$SQL and GV$SQL Views in Oracle         V$SQLTEXT in Oracle V$SQLTEXT is very important view for Oracle DBA that contains the text of SQL statements belonging to shared SQL cursors … Continue reading V$SQLTEXT and V$SQLSTATS in Oracle