Write an SQL query to extract the following information from data dictionary: Fo

Question

Write an SQL query to extract the following information from data dictionary:

For each question you need to submit query and screenshot with results.

Start Oracle SQL Developer

Use SELECT * FROM dictionary; to find all available dictionary views.

Find all dictionary views that contain information about indexes.

How many indexes are defined on OE.CUSTOMERS table? (Hint: all views have meaningful name, just search the page)

For each index you found in #3 how many distinct keys?

Use V$...stat views to find information about "free memory" and "DB time"

Hint: DB time is system parameter
free memory is SGA (System Global Area) parameter

From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples.

Explanation / Answer

       For example:

      SELECT count (*) from DBA_INDEXES where table_owner = ‘My_Dictionary’;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.