Oracle Virtualization and Cloud Consulting
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.

Block size

I knew that failing to have a db_Nk_cache_size setting for your database could cause a statement to crash when it tried to address an object (or tablespace) using a non-standard block size, reporting errors like:

Real-World Performance Videos on YouTube – OLTP

In addition, here are some OLTP demos that demonstrate how much performance and throughput can be wasted by poor design and suboptimal database programming. OLTP Performance – The Trouble with Parsing OLTP Performance – Concurrent Mid-Tier Connections {lang: 'ar'}

Real-World Performance Videos on YouTube – Data Warehousing

Here are some videos of a data warehouse demo that the Real-World Performance Group has been running for a while now and we thought it was time to put them on YouTube. Hope you find them informative. Migrate a 1TB Data warehouse in 20 Minutes (Part 1) Migrate a 1TB Data warehouse in 20 Minutes (Part 2) Migrate a 1TB Data warehouse in 20 Minutes (Part 3) Migrate a 1TB Data warehouse in 20 Minutes (Part 4) {lang: 'ar'}

Oracle GoldenGate 11g direction

Oracle GoldenGate is great for heterogeneous environments by replicating and integrating data across different systems.

This post is about Oracle GoldenGate 11g and implementing a simple replication method. Installing and configuring GoldenGate is quite straightforward. I will not cover this just mention that the source database should be in archivelog mode, have supplemental logging enabled, another thing is to create golden gate user gg_owner. This post will show simple example how to replicate source schema to target, both located on the same Oracle database 11.2.0.2.

Moving SPFILE from file system to ASM (ORACLE RAC11g)

  • There are two nodes in oracle RAC database [rac1] and [rac2]
  • Below tasks has to be executed from the first node [rac1]

1. Create spfile in ASM "+RACDB_DATA" disk group

Read more...

Moving SPFILE from file system to ASM (ORACLE RAC11g)

  • There are two nodes in oracle RAC database [rac1] and [rac2]
  • Below tasks has to be executed from the first node [rac1]

1. Create spfile in ASM "+RACDB_DATA" disk group

Read more...

Open VPN for the Road Warrior

As a consultant it is important to have a test lab, something which is your own, where you can play with new versions and concepts to your heart’s delight without disturbing anyone else. Or worse, causing problems for the customer. For this reason I like to have an Internet facing machine which I can connect to from anywhere. In case the corporate network doesn’t let you out, consider getting mobile broadband on a PAYG basis-it works a dream!

Moving SPFILE from file system to ASM (ORACLE RAC11g)

  • There are two nodes in oracle RAC database [rac1] and [rac2]
  • Below tasks has to be executed from the first node [rac1]

1. Create spfile in ASM “+RACDB_DATA” disk group

SQL> connect / as sysdba

Have you seen ? CONSTRAINT_TYPE ?

When I was testing DBMS_REDEFINITION to convert a non-partitioned table to a partitioned table, I came across constraint_type “?” from TOAD.

WTH! I have must have done something wrong.

It turns out that TOAD used the following SQL to determine constraint_type and does not label non-constraints:

5 days left – vote for Pythian sessions at Oracle OpenWorld 2011 on Oracle Mix

Summer’s here, and that means it’s time to start thinking about Oracle OpenWorld 2011, October 2-6th, 2011 in San Francisco.

Pythian’s plans are well underway. We have been busily planning since March, have submitted a number of abstracts on all sorts of topics: Exadata, ASM, GoldenGate, ADR, ASM, many based on real world experiences with Pythian clients.

Some have been accepted, but we’re hoping for a few more and we’re asking Pythian fans to vote for our sessions on Oracle Mix.

view counter