Hi,
We have heard about SPM and Plan Base line and how they help to improve the Database performance. Here I have little tricky question if some know for sure and I don’t think if Oracle has documented related to this.
We have Oracle db v 11.2.0.3 instance where we used to have a schema name :(say ‘DEVX’) and our application used to run against this schema. At some point in time, we stopped using this schema and dropped, instead we pointed our application against another schema called (say ‘DEV’), but it same application.
When I see sql plan base lines I see that plans were created by old schema (DEVX) and current schema (DEV) . But those plans created by old schema – DEVX had LAST_VERIFIED column blank where plans are ENABLED and some plans even have ACCEPTED : YES.
Saying that If LAST_VERIFIED column value is blank, are these plans are being used by optimizer and is it safe to delete plans created by old schema – DEVX ?
Leave a comment