Tutorials

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading
Oracle upgrades: Tips and trends

If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades. Continue Reading
Oracle virtualization introduction guide

This introductory guide to Oracle virtualization is designed to help you define and understand the basics of Oracle virtualization including Oracle's VM. Continue Reading
Oracle applications learning guide

This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle ... Continue Reading
Comparing servers for Oracle database 11g upgrades

An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance. Continue Reading

Oracle database performance tuning guide

Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common ... Continue Reading
Relational Database Management System (RDBMS) fundamentals tutorial

New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system. Continue Reading
SQL guide for Oracle users

Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide to the structured query language (SQL) has something for you. These seven chapters can help you figure out how to get the data you need by looking ... Continue Reading
Learning Guide: Backup and recovery

Backup and recovery is arguably the DBA's most important responsibility. This Learning Guide covers everything from the basics of creating a backup and recovery plan to the specifics of using RMAN and other methods of hot and cold backups. Samples ... Continue Reading
Oracle PL/SQL tutorial

This PL/SQL tutorial can help both newbies and veterans become better acquainted with the Oracle development language and hone their developer skills. Continue Reading