First page Back Continue Last page Graphics

Data Dictionary Workshop

Data Dictionary

Notes:

Data Dictionary Workshop
Connect to SQL*Plus with your DBA user (or the SYSTEM user).
Display the username and account status of all users on your database.
Display the name and status of all tablespaces on your database.
For each data file on your database, display the tablespace name, file name, number of bytes used and number of blocks used. If you are familiar with the SQL*Plus BREAK and COMPUTE commands, display the sum of the BYTES column - this is the size of your database (excluding logs, control files and parameter files).
Use a V$ view to determine the name of the database you are connected to.
Use a V$ view to determine the name of the instance you are connected to.
What is the current value of the BACKGROUND_DUMP_DEST parameter?
Locate the alert log and view its contents.