How to find object name given in a problematic query I want to know the name of database object which is running the part of my query which is causing problem

From the awr report, I found one query which is making some performance issue, but I am not able to find that query anywhere in the database. Is there any way to find where that is being used in the DB in Oracle 10g? Like in which view or package or procedure.
The AWR report will contain the SQL_ID.  You can query V$SQL with this to locate additional metadata such as the MODULE, ACTION, PARSING_USER_ID.  Also, if the SQL came from a stored procedure, the PROGRAM_ID, PROGAM_LINE# columns point to the (stored procedure) object concerned.

I've got an example of the latter on my blog

https://connor-mcdonald.com/2016/01/20/problematic-sql-plsql-is-your-friend/