Hoping someone can help me out. This may just be a user error.
I am trying to use the “Inspect SGA”. When I add an inspector, it will state that it is “In Queue to Inspect” in the status. Almost immediately it will go to “Complete” and there will be a 0 SQL count. Even if I specify a duration of 5 minutes. I have also tried all the combinations of current SQL, executed SQL, All SQL, selects only etc etc.
I can see I have the following table but it is empty: QUEST_SL_TEMP_EXPLAIN1. I have write access to the table.
My ID has privledges to all the SYS$ stuff except the ALTER SYSTEM privledge and the STORED OUTLINE privledges which I do not think I need to get results. DBA does not want to give me those.
BTW - the SCAN SQL does work for me.
Thanks in advance for any advice.
Message was edited by: cal.briden_437