Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: February 09, 2018 - 5:10 pm UTC

Last updated: February 10, 2018 - 12:11 am UTC

Version: Oracle 12C

Viewed 1000+ times

You Asked

How to find a list of active views in an Oracle schema? The dba_objects, all_views and other sys tables included the dropped views as well, but we would like to get active list.

and Connor said...

How to find a list of active views in an Oracle schema?

I don't really know what you mean by "active"

The dba_objects, all_views and other sys tables included the dropped views as well


I don't what you mean by this either. Dropped objects don't appear in those views ?

SQL> create view my_view as select * from dual;

View created.

SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';

  COUNT(*)
----------
         1

SQL> drop view my_view;

View dropped.

SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';

  COUNT(*)
----------
         0



Perhaps take a look at v$segment_statistics. Maybe that is what you are after ?


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.