Thursday, July 10, 2014


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