Monthly Archives

Articles indexed in March 2010

Page 4/2613 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Intro to MySQL Proxy

  It's no surprise that the concept of a proxy has made its way into the database arena. The MySQL Proxy sits between your application and your MySQL database. Future articles will discuss the myriad of uses for this technology.

  Read the article

• Fixing MySQL Replication

  Continuing last months article on "MySQL Replication Pitfalls," Sean Hull discusses what to do to make your replication setup more resilient.

  Read the article

• Oracle Database Archive Logging -- Where are my archive logs?

  Archive log destinations can be tricky when defining or viewing in Oracle Database. Stick to a few common rules and never get lost.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• 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.

  Read the article

• Oracle 11g Security &amp;#150; 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.

  Read the article

• 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.

  Read the article

• 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 Oracle&#146;s Enterprise Manager.

  Read the article

• Setting default auditing as recommended by Oracle

  If you don&#146;t 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.

  Read the article

• 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.

  Read the article

• Oracle Pledges MySQL Support, EU Warms Up

  The company may be winning over some critics as it seeks to get the OK on its purchase of Sun, but it also made some sizable commitments in return.

  Read the article

• Explicit GRANTs and ROLES in Oracle Database 11g

  Many database shops have no idea of the security breaches that occur across user granted privilege and floating unused synonyms. James Koopmann offers tips for granting privileges explicitly to a user or group of users, and assigning privileges to a role and then granting that role to users.

  Read the article

• Protecting Data from Users

  What is the best way to prevent unintended updates or deletes in a table? The small changes may not be so hard to recover from, but what if every record in the table underwent a change? How can you protect users from themselves and how do you protect yourself from you?

  Read the article

• Oracle 11g Object privileges and synonym usage

  Many security breaches occur across user granted privileges and floating unused synonyms. That being said, the question becomes, how can we get a handle on this. Read on to learn more...

  Read the article

• Oracle 11g Security &amp;#150; The Power of PROFILES

  Using profiles for password management is an effective way to restrict unsolicited database usage. Every DBA should verify the password restrictions and setup an appropriate number of profiles for the groups or types of users within the database.

  Read the article

• Performing Database Failover with Oracle 11g Data Guard

  This article - the sixth in this ongoing series - explores how to manually fail over a production database to its corresponding physical standby database, as well as reinstate a "failed" primary database to a physical standby.

  Read the article

• Oracle's Block Browser and Editor tool

  In a prior article on Oracle's Block Browser and Editor tool (BBED), the installation of the tool was covered. In this article, we'll look at starting a session using a simple database and see how to view data.

  Read the article

• Oracle 11g Security &amp;#150; Those Pesky Predefined Accounts

  How many users do you have in your database? Are they all being used? Come for a ride as we trim down the installed base of Oracle default users.

  Read the article

• SQL Performance Analyzer

  Any activity that may impact a statement's execution plan is a candidate for using SPA to investigate the possible consequences - both good and bad. Steve Callan discusses the workflow and provides a working example.

  Read the article

• Oracle 11g Security &amp;#150; Securing the Data Dictionary

  Protecting the data dictionary is quite easy. Follow along as we examine various methods.

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >