Sunday, August 24, 2014

Oracle 12c Data Dictionary Views

Oracle contains a wealth of information in its data dictionary views. I often find it is quicker and easier to query these views directly rather than going through a GUI in a tool like SQL developer. It is also possible to develop your own queries against these views to track conditions you care about.

 The data dictionary views are well documented by Oracle. Still though, with there being so many of them, I think it would be useful to have a quick reference to the most commonly used views. So that is what this post is all about. I've created easy to remember links to each view, but feel free to bookmark this page as a condensed table of contents.

View Name Documentation Link