Oracle Database Administration I - Lesson 1- Intro to the Data Dictionary скачать в хорошем качестве

Oracle Database Administration I - Lesson 1- Intro to the Data Dictionary

This tutorial will teach you the how to use the data dictionary to answer the questions every DBA is faced with on a daily basis, for example, how many tables are in schema "PROD"? Contents of this video: 01:12 - Lesson Objectives 01:24 - Introduction - Why is the Data Dictionary so important? First sample query. 03:17 - What is the data dictionary? Includes demonstration. 07:26 - Static dictionary views. Demonstration. 15:49 - Common (i.e. very helpful) data dictionary views. 18:10 - What users have been created in my database? What is their account status? Example: Querying DBA_USERS 19:09 - What system privileges have been granted to a user? Example: DBA_SYS_PRIVS 20:15 - What is the high value of some important space and usage statistics such as the number of user table or the size of the database? Example: DBA_HIGH_WATER_MARK_STATISTICS 21:26 - What database features and options have been used? Helpful in assessing / auditing use of Enterprise Edition Features. DBA_FEATURE_USAGE_STATISTICS. 23:05 - Introduction to dynamic performance views, e.g. V$PARAMETER. Demonstration. 31:50 - Miscellaneous Views. Other helpful dictionary views, e.g. SESSION_PRIVS, TABLE_PRIVILEGES. 33:25 - Querying the DICTIONARY View. In-depth demonstration. Presented by Dave Anderson, Oracle DBA, SkillBuilders. https://skillbuilders.com/oracle-dba-....