This video presents the capabilities of the Oracle Data Dictionary providing valuable information about the current state of the Oracle database. We will use SQL*Plus to view important information about the database directly from the Data Dictionary.
- [Instructor] The Oracle data dictionary…is a collection of tables and views…managed by the Oracle database…and which allows us to retrieve very insightful information…about the Oracle database and its core and state.…What kind of information?…Well, users which have been created,…tables which have been created,…tablespaces and data files, configuration,…and more.…We can actually use regular SQL language…to quarry the data dictionary,…which by itself is very very cool.…
Data dictionary tables and views in Oracle…start with either at dba_ or at v$ prefix.…The data dictionary has over 6,000 views…and over 2,000 tables.…Now, not all of them are super useful,…and for sure we won't cover all of them in this video,…but let's take a look at some of the more interesting ones.…Let's start off by opening a connection…to our Oracle database as the sysdba user.…
And for our first example, let's show a simple one,…viewing users in the database.…In order to do that,…we are going to retrieve data…from the dba users data dictionary view.…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.