Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 Name Null Type TABLE_ NAME NOT NULL VARCHAR2 128 NUM_ ROWS NUMBER LAST_ ANALYZED DATE The dynamic data dictionary views are typically used by a database administrator to monitor the database and its performance These views have a V prefix which is why they are commonly referred to as V dollar tables and are continuously updated by Oracle Database background processes rather than database users Much as with the DBA_ views you need to have special database administrator privileges such as the DBA role or the SELECT ANY DICTIONARY privilege granted to you to give you access to the dynamic data dictionary views Alternatively a database administrator can grant you privileges to access specific individual dynamic data dictionary views youd like to query To learn more about the data dictionary and dynamic performance views refer to the documentation ORACLE MAGAZINE JULY AUGUST 2017 105
You must have JavaScript enabled to view digital editions.