view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Oracle IOT: when to use Index Organized Tables

When can we use IOT? That's a question I had when giving recently the Oracle DBA essentials workshop. the DBA Essential is very dense and there is only half a day about performance. We have the Oracle Performance Tuning workshop to go into those details. But IOTs are under used in my opinion, so I'll post a use case for them where they are a good idea.

Bug 8477973

I ran the following query on an Oracle 11.1.0.6 database but it failed with an ORA-02020:  SQL> SELECT ppc.sttlmnt_dt day_date  2  FROM   vrm_d18_ppc   ppc,

New Theme: Penscratch

Today we have a brand new free theme especially for writers and bloggers!

Penscratch

Penscratch WordPress Theme

Need Experts in Open Source Databases? [VIDEO]

Transcript

Have what it takes to enhance your open source databases?

Welcome back to the RDX blog. Whether you prefer to store your information in MySQL or PostgreSQL, we can provide you will a complete range of administrative support.

In addition to 24×7 onshore and remote service, our staff can deploy sophisticated monitoring architectures customized to fit both MySQL and PostgreSQL. This ensures your data is available at all times.

Deploying a Private Cloud at Home — Part 4

Today’s blog post is part four of seven in a series dedicated to Deploying Private Cloud at Home, where I will be demonstrating how to configure Imaging and compute services on controller node. See my previous blog post where we began configuring Keystone Identity Service.

How to make use of maps in Forms 11g?

Author: Cătălin Bulancea

This blog posting is about how easy it is to integrate your existing or new Oracle Forms 11g applications with map visualization and navigation capabilities.

DevOps and Databases?

I don’t know about you, but when I hear the term DevOps I have to roll my eyes and think “oh, the latest greatest tech industry buzzword.” So why would I as a DBA care about DevOps? With DevOps, as with most tech industry buzzwords, there is actually a worthy idea at the kernel. The kernel of DevOps has two parts.

DevOps

Error: ORA-16810: multiple errors or warnings detected

Today after restarting primary and standby database servers I faced with ORA-16810 errorDGMGRL> show configuration;Configuration - DGMANAGER  Protection Mode: MaxAvailability  Databases:    XXXPROD - Primary database      Error: ORA-16810: multiple errors or warnings detected for the database    XXXSTND - Physical standby database      Error: ORA-01017: invalid username/password; logon deniedFast-Start Failover: DISABLEDConfiguration Status:ERROR

Code can be scary when you simplify it

Disclaimer: I’m not posting to make me look better, we’ve all written code that we’re later ashamed of, and I’m no different!

This is some code from a system I was maintaining some time ago. I’ve kept it since then because it illustrates a number of things NOT to do:

SQL Server: Forced failover with AlwaysOn & Availability Groups

During a workshop at one of my customer about the implementation of SQL Server AlwaysOn and availability groups, I had an interesting discussion. It was about asynchronous replication between 2 replicas and the effect of the forced failover operation with allowed data loss. Does SQL Server resynchronize availability databases if I loose some transactions during the failover process?

view counter