Select * from view_name trace is giving me the query output which is the view data but I’m unable to get the execution trace as data. Please hlp me to get the execution trace or EXECUTION PLAN() as output so that I can redirect the same to a file for further analysis or manipulation. Is there any API available for the same? Please let me know if my further information is required.
Thank you in advance.