Oracle Common views and tables

1. View the current user's basic information

SELECT * FROM User_users

2. View the role of the current user

SELECT * FROM User_role_privs

3. View System permissions and table permissions for the current user

SELECT * from User_sys_privs;

SELECT * from User_tab_privs;

4. View all tables for the current user

SELECT * from User_tables;

5. View information for the current User table column

SELECT * FROM User_tab_columns

6. View all users of the system

SELECT * FROM Dba_users

7. View permissions for the current session

SELECT * from Session_privs;

8. View System Permissions

SELECT * FROM Dba_sys_privs

9. Querying Privileged Users

SELECT * FROM V$pwfile_users

10. View all objects of the current user

SELECT * FROM User_objects

11. View segment Information

SELECT * FROM User_segments

12. View the index of the table

SELECT * FROM User_indexes

13. View the fields that are indexed

SELECT * FROM User_ind_columns

14. View Sequence

SELECT * FROM User_sequences

15. View View

SELECT * FROM User_views

16. View synonymous words

SELECT * FROM user_synonyms

17. View Constraints

SELECT * FROM User_constraints

18. View source code (e.g. Function/procedure)

SELECT * FROM All_source

19. View Data Files

SELECT * FROM Dba_data_files

20, Inquiry Dblink

SELECT * FROM Dba_db_links

21. Querying the Database partition

SELECT * FROM Dba_extents

22, view the information of the paragraph

SELECT * FROM Dba_extents

23. Free partitions in all table spaces

SELECT * FROM Dba_free_space

24. Description of all indexes in the database

SELECT * FROM Dba_indexs

25. Columns that compress indexes on all tables and aggregates

SELECT * FROM Dba_ind_columns

26. All objects in the database

SELECT * FROM Dba_objects

27. Description of rollback section

SELECT * FROM Dba_rollback_segs

28. Storage space for all segments of the database segment

SELECT * FROM Dba_segments

29. Information query about synonyms

SELECT * FROM dba_synonyms

30. Description of all data tables in the database

SELECT * FROM Dba_tables

31. Information about table spaces

SELECT * FROM Dba_tablespaces

32. All table descriptions, views, and clustered columns

SELECT * FROM Dba_tab_columns

33. Permissions granted by the object

SELECT * FROM Dba_tab_privs

34. All User table space limits

SELECT * FROM Dba_ts_quotas

35. Information about all users of the data

SELECT * FROM Dba_users

36. Text for all views in the database

SELECT * FROM Dba_views

More Address: http://www.2cto.com/database/201207/142874.html

Oracle Common views and tables