SQL PI reports tables changes in Oracle databases but the user is not aware of any schema changes having been made.
In Oracle versions below 11g and below, information on modified objects are determined by comparing the last_ddl_time and change_time for objects in the database object view.
In Oracle versions 12c and higher, information on modified objects are determined by comparing the last_ddl_time and change_time for objects in the container object views.
Dropped objects are determined in all releases by reviewing the objects found in the recycle bin at the database or container database levels.