Database Administration

Category

In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by plugging it as a pluggable database (PDB) into primary CDB (BOSTON). This method tremendously simplifies and speeds up the procedure to create a standby database without the need to set various initialization parameters or take backup or configure tnsnames.ora entries… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development

This is the last part of my series on Execution plans, and features an option which is only available if you have licensed the Diagnostic and Performance Packs. It’s a feature that allows you to watch the flow of data through an execution plan as the query is running, typically through the graphic interface supplied by Enterprise Manager  (or Grid… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

In parts 11 and 12 of this series I described the “rowsource execution statistics” that we can collect as Oracle runs a query, then described a strategy for generating and accessing these statistics in a way that was particularly convenient if you could use your own session to run the SQL you wanted to analyze. In this article we’re going… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to do the same with our legacy Informix database but I found that we did not have the Database Gateway licenses required for using Enterprise Manager Data Masking Pack on Informix. We also had a requirement to replace customer names and… Continue Reading →

Database Administration

Rolling Forward a Physical Standby Database Using the RECOVER Command A standby database is a transactionally-consistent copy of the production database. It enables production Oracle database to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch a standby database to the production role, minimizing the downtime associated… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database, Troubleshooting

Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN).  The Recovery Manager continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. In this article series, I will be explaining the new features and how they help the Oracle community. See new features around SYSBACKUP, pluggable databases, and the SQL interface… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Administration, Database Development

In the previous instalment of this series I introduced three ways of accessing the run-time statistics for a query and described, for one of the methods, the basics of the information we can get and how we can use it. In this article I want to expand on the use of one method to show it can help use identify… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

Friday January 23, 2015, 10:00 AM – 11:00 AM CST Register Featured Presenter: Martin Bach Fill the Glass Host: Cary Millsap Description: In Fill the Glass episode 2, Cary welcomes Enkitec engineered system specialist Martin Bach. In this action-packed hour, Martin will guide us on a tour of the magnificent collection of Oracle Exadata internal technologies commonly called Smart Scan…. Continue Reading →

Database Administration, Webinar

Wednesday January 28, 2015, 3:00 PM – 4:00 PM GMT Watch the recording Description: After a short introduction into what the Oracle Exadata Database Machine is, in this one-hour webinar Oracle expert Randolf Geist will look at an analysis of different database query profiles that are based on a real-world customer case, how these different profiles influence the efficiency of Exadata’s… Continue Reading →

Database Administration, Webinar

The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence. Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead. In 12c, it is now available with new features for all major operating… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development