4-ASSIGNMENTS ON DATA DICTIONARY (2)

4-ASSIGNMENTS ON DATA DICTIONARY (2) - tablespace Hint:...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENTS ON DATA DICTIONARY 1. Find a list of data dictionary views 2. Identify the database name, instance name and size of the database blocks Hint: use V$DATABASE, V$THREAD and V$PARAMETER 3. List the name and size of the data files Hint: V$DATAFILE 4. 4.Identify the data file that makes up the SYSTEM
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: tablespace Hint: DBA_DATA_FILES 5. How much free space is available in the database and how much is already used? Hint: DBA_FREE_SPACE, DBA_SEGMENTS 6. List the name and creation date of the database users. Hint: DBA_USERS...
View Full Document

Ask a homework question - tutors are online