Star Transformation in 11gR2

Star Transformation in 11gR2

 In the article we will review the prerequisites for the CBO to perform a star query transformation. We will use the SH samples schema. We will look at two cases with and without a bit map join index.

  1. Star transformation without a bitmap join index.
  2. Star transformation with a bitmap join index.

The prerequisites are as follows.

 

  1. Make sure that the primary and foreign keys are enabled.

 

 

(more...)

Using the SQL ACCESS Advisor PL/SQL interface

Using the SQL ACCESS Advisor PL/SQL interface

In the article you will have a look at an example of using the SQL Access Advisor PL/SQL interface to obtain the access path and object structures change recommendations.

Let’s look at the SQL query example:

SELECT /*+ monitor */ /* test SQL Tuning */

p.prod_category,

p.prod_subcategory,

t.calendar_year,

SUM( s.quantity_sold ) AS total_quantity_sold,

SUM( s.amount_sold ) AS total_amount_sold

FROM

sh.sales s, sh. (more...)

Configuring Fast Start Failover

Configuring Fast Start Failover

In the article you will have a look at an example of configuring Fast Start Failover (FSFO). Oracle 11gR2 has been used. The configuration is based on server zeus running the PRA database and server Apollo running the STBY2 database. The STBY2 is the standby database.

  1. Initial data guard configuration.

    DGMGRL> show database verbose stby2

    Database – stby2

    Role: PHYSICAL STANDBY

    Intended State: APPLY-ON

    Transport Lag: 0 seconds

    Apply Lag: 0 (more...)

Session failover using Data Guard 11gR2

Session failover using Data Guard 11gR2

 

In the article we will see the session failover using an Oracle 11gR2 Data Guard. The feature is available since Oracle 11gr2 when the services become a CRS resource. The software used is Oracle RDBMS 11gR2. There are two nodes zeus running the PRA primary database and a STBY1 standby database and apollo running the STBY” standby instance. We will demonstrate a connection failover of a connection to (more...)

Packt’s $5 eBonanza returns

Packt’s $5 eBonanza returns

Following the success of last year’s festive offer, Packt Publishing will be celebrating the holiday season with an even bigger $5 offer.

From Thursday 18th December, every eBook and video will be available on the publisher’s website for just $5. Customers are invited to purchase as many as they like before the offer ends on Tuesday January 6th, making it the perfect opportunity to try something new or (more...)

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 120,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 5 days for that many people to see it.

Click here to see the complete report.


Filed under: oracle

The best deals from Packt Publishing

This month marks 10 years since Packt Publishing embarked on its mission to deliver effective learning and information services to IT professionals.

To celebrate this huge milestone, Packt is offering all of its eBooks and Videos at just $10 each for 10 days – this promotion covers every title and customers can stock up on as many copies as they like until July 5th. Please visit Packt Publishing here.


Filed under: oracle

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5 – Download

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5 – Download

In the article you will have a look at the steps and guidelines for upgrading OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5. This initial configuration is described here. The OMR is Oracle 11.2.0.3 database. Looking at the certification (more...)

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5

Upgrade OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5

In the article you will have a look at the steps and guidelines for upgrading OEM Cloud Control 12cR1 no BP1 on OEL 6.1 to OEM Cloud Control 12cR4 on OEL 6.5. This initial configuration is described here. The OMR is Oracle 11.2.0.3 database. Looking at the certification matrix on (more...)

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5 – Download

Install Oracle Enterprise Manager Cloud control 12cR4 on OEL 6.5 – Download

In the article you will have a look at the guidelines and steps to install OEM Cloud Control 12cR4 on Oracle Linux 6.5 X86_64. You will have a glimpse at how to configure OEL 6.5 for OEM CC 12cR4 installation. Oracle 12.1.0.1 database is used as an Oracle Management Repository (OMR) database. I will provide pointers to (more...)