I found out today that not only do I have GV$SQLTEXT, but another tool in the toolbox is DBA_HIST_SQLTEXT which will give me some historical data according to I believe our retention options and since SGA or PGA have been cleared. Speaking of SGA and PGA, did you know there are some DBA_HIST tables related to them as well?
Do yourself a favor, and query your ALL_OBJECTS table for DBA_HIST objects to learn more things that can be put in the toolbox for later!
No comments:
Post a Comment