Start Oracle SQL Developer 1. Use SELECT * FROM dictionary; to find all available dictionary views SELECTFROM dictionary; Script Output x Query... x SQL I All Rows Fetched: 3228 in 1.736 seconds TABLE NAME COMMENTS 1 DBA CONS COLUMNS 2 DBA LOG GROUP COLUMNS 3 DBA LOBS 4 DBA CATALOG 5 DBA CLUSTERS 6 DBA_CLU_COLUMNS 7 DBA COL_COMMENTS 8 DBA COL PRIVS Information about accessible columns in constr Information about columns in log group definit Description of LOBs contained in all tables All database Tables, Views, Synonyms, Sequence Description of all clusters in the database Mapping of table columns to cluster columns Comments on columns of all tables and views All qrants on columns in the database 1. Find all tables that keep information about roles 2. Use found tables to check what privileges does role CONNECT have? 3. Find all dictionarv views that contain information about indexes 4. How many indexes are defined on DVSYS.RULE_SET_RULES table? (Hint: all views have meaningful name, just search the page) For each index you found in #3 how many distinct keys? Describe the purpose of VSTHREAD Use VSTHREAD to find enable time and las redo time Describe the purpose of VSBACKUP Use VSBACKUP to find details about backups Find VS... view that will tell you what size of the following data types: DOUBLE FLOAT, BOOLEAN Use V:stat views to find information about "free memory" and "DB time" 5. 6. 7. 8. 9. Hint: DB time is system parameter free memory is SGA (System Global Area) parameter 10. From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples Include code and results of the execution (Ctrl