FEATURED

ALL POSTS

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation. However, I did review Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit…

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved…

The Growing Trend Toward Data Infrastructure Outsourcing

Outsourcing White Paper graphic - blog post

Today’s blog post is the first of three in a series dedicated to data infrastructure outsourcing, with excerpts from our latest white paper. Despite the strong push to outsource corporate functions that began more than two decades ago, many IT shops have been hesitant to outsource their data management requirements. Generally, the more mission-critical the…

Oracle RMAN Restore to the Same Machine as the Original Database

Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In such situations, the biggest fear is overwriting the original database. Here is a simple procedure…

Paul Vallée’s Interview with Oracle Profit Magazine

Aaron Lazenby, Editor at Oracle’s Profit Magazine interviewed Pythian Founder, Paul Vallée this week to discuss the growing risk of internal threats to IT. “What we need to create is complete accountability for everything that happens around a data center, and that’s where our industry is not up to snuff right now. We tend to…

4 Things Every CMO Should Do Before Approaching IT About Big Data

Read the full article, 4 Things Every CMO Should Do Before Approaching IT About Big Data.   “You’ve likely heard the whispers (or shouts) about Big Data’s potential, how it’s the holy grail of marketing—and it can be. But to uncover this information and take action on it, marketing needs to partner closely with all…

RMAN Infatuation?

Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear datafile fuzziness If you are, then I will demonstrate this for you. RMAN LEVEL0 backup…

Page 1 of 24112345...102030...Last »