[Oracle] How to see last sql statements executed

Recently we get into scenario where we need to see that which sql statements are being executed by activity upload.

So here is an easy way to do this:

select sql_text from v$sql where rownum<=100 and parsing_schema_name='NC_SDA_1_301';

Parsing Schema Name ; should be your schema name for which you need to see the sql statements executed on.