SQL query stack trace of execution

Question

Is there a way to get the stack trace of the sql query that is given in awr, i mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both show only the sql and the elspased time, parse and fetches. –

anyone help on this ?

anudeepks
– anudeepks

2015-03-30 06:41:59 +00:00
Commented Mar 30, 2015 at 6:41 — anudeepks
– anudeepks, Commented Mar 30, 2015 at 6:41

Jon Heller · Accepted Answer · 2015-04-22 00:43:29Z

1

As far I know - there are no other way than full code search - either select from Oracle internal views (USER_SOURCE/ALL_SOURCE/DBA_SOURCE):

SELECT name, text
FROM dba_source
WHERE lower(text) LIKE ('%some representative text from query%)

or text search in code repository, if you have it.

edited Apr 22, 2015 at 0:43

Jon Heller

36.9k6 gold badges84 silver badges150 bronze badges

answered Apr 21, 2015 at 20:48

Janis Baiza

9616 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query stack trace of execution

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related