PL/SQL view background Database execution statement

Because of the project, you need to look at the query statements executed by the background code and check that the logic is correct;

Steps:
(1). First refresh the database to share this

--Refresh Shared pool
alter system flush Shared_pool;

(2). Operation in the interface you want to view the function directly in the background;

(3) Execute the following statement in the PL/SQL database;

--Query the user's recently executed SQL
Select Sql_fulltext from v$sql where parsing_schema_name = ' database name ' ORDER by Last_load_time;

PL/SQL view background Database execution statement