Hi,
We have many sql profiles created in our database, and we want to check whether these profiles are used or not and whether they have become stale over time and wanted to drop them.
Few sql profiles are used reguarily and we can confirm from SQL_profile column in v$sql or v$sqlarea but we are not sure whether how many of them are really of any use now/stale. SQL tuning advisor often suggests creating sql profiles on few same SQL statements on which profiles are already present.
Is there any way we can find whether when these SQL profiles are last used by optimizer for a particular SQL and whether they are valid/stale now.
Thanks,