Appendix A. Dynamic Performance Views
In this book, we have been presented with many dynamic performance views, used to access a wide spread of details about an Oracle database, regarding different aspects from the sessions to the SQL statement executed.
In this appendix, we present a summary of these views, in alphabetical order, which can be used as a reference. For each view, there is a brief description and a list of the most useful fields of the view.
ALL_OBJECTS
This view lists all the database objects the current user can access. As for many ALL_ views, there are similar DBA_OBJECTS and USER_OBJECTS views; they have the same fields but DBA_OBJECTS shows all the objects in the database, while USER_OBJECTS shows information only on the objects ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
