Oracle: DBA_STATEMENTS

dba_statements lists SQL statements that are found in PL/SQL objects.

This data dictionary view comes in all four variants: user_statements, all_statements, dba_statements and cdb_statements.

In order for this view to be populated with the information about statements, the init parameter plscope_settings must be set to statements:all.