We are looking for validating our product upgrade changes.
As part of product upgrade, there will be changes to the schema.
Like addition of tables, addition of columns to existing tables, change the length of character columns, add new index, etc.
We want to verify on the database, that these SQL are run successfully on the database.
Is there a table/view, that can be queried to figure out whether such sql was run and the status of the execution, after some time (day or two) after these are actually run on the database.
What do you want to achieve? You need to be little more clear. Once all the objects are created ,you can query DBA_OBJECTS and check if these objects are there or not. If all the objects you want are there, it means your sql scripts ran successfully. OR you can do *"set spool on"* and run your script. You will be able to see the queries and their output.
This might help too
This is useful. This would require some processing to pick up the object being created/changed from the sql being run.
Is there a way to track the sql (in whole) in the db and know its status from any of the view/tables.
Came across V$SQL, V$SQLAREA, but i thought it contains those queries that are present on the shared sql area.
Looking for some table/view that can hold all the sql that are run on the database for last n days.