One of the more powerful data analysis features introduced in Oracle Database 12c is SQL models. SQL models allow a user to create multidimensional arrays from query results. Formulas, both simple and complex, can then be applied to the arrays to generate results in which the user is interested. SQL models allow inter-row calculations to […]
Read More
In this article, we discuss a feature of the Oracle Database that you can include in your arsenal: materialized views. Originally called snapshots, materialized views were introduced in Oracle8i and are only available in the Enterprise Edition. Like a regular view, the data in a materialized view results from a query. However, the results of a […]
Read More
The different modes of setup for Oracle 12c Data Guard allow for different configurations that are adaptive and that are dependent on available hardware, processes, and ultimately business needs. The modes for the Data Guard configuration include maximum protection, maximum availability, and maximum performance. The Data Guard configuration can also have more than one standby […]
Read More
Improving performance (and by this we usually mean query performance) is always a hot item with database administrators and users. One of the best and easiest ways to boost performance is to take advantage of the parallel processing option offered by Oracle Database 12c (Enterprise Edition only). Using normal (that is, serial) processing, the data involved […]
Read More
As user communities require more and more detailed information to remain competitive, it has fallen to database designers and administrators to help ensure that the information is managed effectively and can be retrieved for analysis efficiently. In this section, we discuss partitioning data and the reasons why it is so important when working with large […]
Read More
Migrating an Oracle instance from regular storage to ASM is actually a simple task, but only if the ASM instance has already been created. Using Oracle Enterprise Manager is probably the most straightforward way to do this. Start by opening up Oracle Enterprise Manager and choosing the option to migrate to ASM. The screen shown […]
Read More
Oracle RAC environments should first be created for testing and proving concepts for how the failover works for different applications. The RAC test environments should continue to be available for testing for production systems because different workloads and failover can’t be tested against a single node. After the installs of the Oracle Clusterware and database […]
Read More
Oracle Real Application Clusters (RAC) provides a database environment that is highly available as well as scalable. If a server in the cluster fails, the database instance will continue to run on the remaining servers or nodes in the cluster. With Oracle Clusterware, implementing a new cluster node is made simple. RAC provides possibilities for […]
Read More
What does high availability mean to the business? What is the level of risk tolerance? How much data loss is acceptable? Are there current issues with backups or reporting? These are all questions that need to be asked to start mapping out the components that are needed. You may decide that absolutely no data loss […]
Read More
Let’s have a look at a few scripts that will take advantage of Oracle RMAN. Backup Script The following script groups together RMAN commands in a RUN block to take a full backup of a database and its archivelogs. It assumes that you have configured the control file autobackup on in the RMAN configuration settings, and […]
Read More
Backups are very important, but they have a shelf life, too. You cannot just keep taking backups and retain all of them forever. You need to decide how long you would like to retain your backups before you can safely remove them in order to make space for more backups. Storage on a disk or […]
Read More
When you create backups with RMAN, they get created in one or more backupsets; these backupsets are in proprietary format. In order to use them again for recovery, first you need to extract them from this proprietary format. This process is called restore. You use the RESTORE command of RMAN to restore the backup. For […]
Read More