'How to view SQL_TEXT in V$SQL that are COMMITed in Oracle Database?
I am trying to look the SQL query that has Updated, Inserted, and Deleted rows in a table
SELECT
*
FROM V$SQL
WHERE
PARSING_SCHEMA_NAME = 'user_checking' and
SQL_TEXT like '%employees%'
order by FIRST_LOAD_TIME desc;
But this query also shows uncommitted queries. Is there a way to only show SQL_TEXT that has been commited?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|