In this video, we will explain the concpets of Oracle physical and logical storage layout and specify the way Oracle uses storage interanlly using blocks, extens, segments and tablespaces
- View Offline
- Exercise Files
- [Instructor] Let's start our Oracle Database…storage discussion by talking about the Oracle Datafiles.…Lucky for us, they're also the most complex type…of Oracle file we need to learn about.…So be sure to have a nice cup of coffee on hand,…as we are about to go deep down the rabbit hole…on how Oracle manages storage.…The Oracle Database Datafiles actually contain…all of the user, or application, data in our database.…Tables, rows, they are stored inside datafiles.…Indexes, yep, inside our datafiles.…
Database metadata, such as the users…that have been created and their permissions,…or views, and stored procedures?…Yep, all database data, as well as metadata,…is stored inside the datafiles.…That is why the datafiles are such an important component…for Oracle database storage.…You lose them, you lose your database.…Each Oracle database will contain several datafiles.…Some are created automatically when we install Oracle,…and some are created by us, or users,…to store application data.…
Database files have physical properties,…
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 Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
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 58s
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?
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.