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.

Creating a standard audit trail in Oracle Database 11g
Turning on auditing is easy; knowing what to do with it is entirely different. Learn how to create a standard audit trail using Oracles Enterprise Manager.

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 as a Data Source
This article takes a quick look at Oracle database's materialized view and extends the concept of that feature to a case where Oracle is the data source for another relational database management system.

Getting started with standard auditing in Oracle Database 11g
Database auditing is big business. Are you ready for the challenge to pass an audit? This article begins with an introduction to Oracles standard auditing that we can build on to answer that question.

To Partition or Not to Partition in E-Business Suite
As a database administrator, there are two kinds of databases you are likely to own: those you design and those you inherit. This article looks at what takes place during the design phase, and then applies the lessons learned to a real world implementation, courtesy of Oracle E-Business Suite.

Secure Sockets Layer and Oracle 11g Security
In an Oracle environment, much of the communication between client and server is unsecured and clear-text. Learn how Oracle Advanced Security and Secure Sockets Layer (SSL) can be used to tighten security for both network traffic and for communication between user and database.

Printing Barcodes in Oracle Reports
No, really, you may have to do this one day: enable the use of barcodes in Oracle Reports. Is this a database administration or administrator responsibility?

Fast-Start Failover in Oracle 11g Data Guard
Learn how to set up and control automatic failover using the Fast-Start Failover Observer, so that DBA intervention is no longer required during a disaster recovery scenario.

» More Features...

Receive articles via our XML/RSS feed

Oracle Loses Open Source Advocate in Ken Jacobs
Seen as the man to ease tension between MySQL and Oracle, Ken Jacobs decides to leave Oracle.

Netezza and NEC partner up in building database computers
Oracle & Sun may not be the only game in town for database computers.

Oracle database; not so unbreakable as one would think
Zero-day vulnerability exposed in Oracle 11g gives user full and complete control.

Division within the Oracle / MySQL debate
Many believe that Oracle will have the upper hand within proprietary and open-source database markets.

Oracle on Linux versus Oracle on Sun
As Oracle embraces Sun hardware, will commodity hardware go out the window.

A little hardware banter between Oracle and IBM
Oracles Ellison and IBM's director of product strategy, Bernie Spang sling some mud.

MySQL lives on
The whole world was watching as Oracle laid plans for Sun products, especially the future of MySQL.

Oracle Technology homepage goes mobile
Go to oracle.com/otn if youd like to start using OTN mobile.

Oracle Completes Acquisition of Sun
Its official! Now we can get on with business.

Forming alliances against Oracle and Sun; HP and Microsoft will give it a go
Are newly formed alliances coming too late to head off Oracles powerful lineup of systems and software?

To improve performance, availability, and scalability, Georgian College uses Oracle 11g Grid
Beefing up with Oracle 11g and RAC help Georgian College improve the performance, availability, and scalability of its Oracle PeopleSoft Enterprise applications.

Mueller still fighting the Oracle-Sun acquisition
Oracle / Sun deal moves to China and Russia as Mueller prays for rain.

Dont miss the Oracle & Sun Strategy Event January 27
Oracle will be hosting a live event for customers, partners, press and analysts on January 27, 9:00 AM 2:00 PM PT, at its headquarters in Redwood Shores, California.

Oracle gets unconditional approval from European Commission
Oracle has announced today that it has received regulatory approval from the European Commission for its acquisition of Sun Microsystems, Inc.

How well do you know the software giant Oracle?
Take a few minutes to browse through 40 quick facts about Oracle.

» More News...

Receive news via our XML/RSS feed

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.

» More Scripts...

Latest Database Articles from DevX

Overview of Sybase ASE In-Memory Database Feature Use Comparison Operators in SQL to Remove/Return Columns with Null Values Displaying the Row Number in a SELECT Query with SQL Server 2005 More Table View Tricks for the iPhone Retrieving Table Size in SQL Server

Database Administration Forum	Latest Forum Threads
Topic	By	Replies	Updated
oracle 10g installation problem in redhat linux 5	madhugp	3	February 8th, 04:35 PM
sga_target is set but v$sga_target_advice doesn't exist	mahajanakhil198	0	February 8th, 07:43 AM
Index not used after gather_table_stat, but used if..	katripon	3	February 7th, 11:03 PM
Oracle apps 11 using 8i database	hanselrl	4	February 7th, 10:21 PM

Database Development Forum	Latest Forum Threads
Topic	By	Replies	Updated
SQL Control file	anijan	2	February 9th, 04:10 AM
date query for previous months	prodadmin	1	February 8th, 01:01 PM
PL/SQL block to populate a table	keerthi11	3	February 4th, 03:28 PM
display multiple rows into one value	prodadmin	1	February 3rd, 05:32 PM