DBASupportEight Reasons Why Oracles Acquisition of Sun isn't All Bad
Much has been said about why Oracle acquired Sun, how it will be the demise of the free world and produce a one-world database monopoly. While there is probably a little truth in the statement, we should keep in mind that much of what is happening can be beneficial for the end customer.
Oracle Database to SQL Server Comparisons
One of the initial obstacles a database administrator encounters is learning where features of his/her system live or reside on a less familiar system. Steve Callan approaches this feature comparison by taking SQL Server and mapping its features back into Oracle.
Oracle Database 11gR2: Installing Grid Infrastructure
Jim Czuprynski demonstrates how to install and configure a new Oracle Database 11g Release 2 (11gR2) Grid Infrastructure home as the basis for the majority of the grid computing features that were only available in a Real Application Clusters (RAC) clustered database environment in previous releases.
Oracle DBA Job Interview - Nailing a Fairly Common Question
While not that technical in nature, this one question gives you an opportunity to list reasons or possibilities of a technical nature, which in turn allow you to demonstrate your knowledge and understanding of how Oracle Database works, and perhaps in this case, how it may not be working.
Pay Attention to your Oracle Database Archive Logging Function
Ignore your archive logging function and your Oracle database will soon become crippled and unusable. Learn how to pay attention, starting with ensuring that Automatic archival is Enabled, how to switch into archive log mode if it's not enabled and how to locate where redo logs are archived.
Configuring Oracle as a Data Source for SQL Server
Discover what happens within SQL Server during and after configuring Oracle as a data source. Quite a few objects are created, including a system-level database, numerous jobs running under the SQL Server agent, and flat files created on the file system. Read on to learn more.
When tuning Oracle is not an option
Before you start monitoring your Oracle database, make sure you understand some of the behind-the-scenes issues of using Oracle monitoring.
Leveraging Logical Standby Databases in Oracle 11g Data Guard
Oracle Data Guard still offers support for the venerable logical standby database in Oracle Database 11g. This article, investigates how data warehouse and data mart environments can effectively leverage logical standby database features, but simultaneously provide a final destination when failover from a primary database is mandated during disaster recovery.
Building an Oracle (and other RDBMS) Server Environment
In previous articles discussing Oracle and VMware, the hardware and software components consisted of a Windows-based PC and the Oracle RDBMS. Steve Callan expands upon the "Oracle in a virtualized environment" concept by looking at other alternatives for the hardware and software.
Oracle 11g Security Guidelines for Auditing
Oracle focuses on the default settings for just about all of the security setup in "The Oracle 2-Day Security Guide". As we draw near the close of the book, we'll examine a few guidelines for auditing.
Setting up Oracle as a Data Source for SQL Server
The requirements for setting up Oracle as a data source for SQL Server include some obstacles and one major showstopper. Read on to learn a work-a-round that allows you to continue the setup.
Setting default auditing as recommended by Oracle
If you dont know where to start when setting Oracle auditing parameters, just start with what Oracle recommends. In this article, we set the default auditing as recommended by Oracle.
The Second 5 top new features in Oracle Database 11gR2
The second part of this two-part article completes a high-level evaluation of Oracle 11gR2's new features to assist Oracle DBAs to decide whether to upgrade their Oracle 9i, 10g, and 11gR1 databases to Oracle 11g Release 2 in the near term.
Oracle in the Cloud?
Oracle will also outline how it plans to use the assets brought by newly acquired Sun Microsystems, which includes helping customers build private clouds.
Bulk File Edit
This script will go through each file with the *.dat extension in a directory and fill the 3rd pattern "<>" in the line that contains a specified directory, with a specified path.
FULL OUTER JOIN LOOP
This script displays matched records from two tables when constraints prevent a full outer join.
IF EXISTS/IF NOT EXISTS
This script creates a user, if the user does not exist in the db and drops the user, if the user exists in the db.
Killing Sessions
Use this script to kill a job and re-run it fter incorporating HINTS.
Debugging Column Length
This script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join.
