Search

Top 60 Oracle Blogs

Recent comments

August 2018

Acticin | Online Purchase

Looking for a acticin? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

Tags:

  • discount acticin online us
  • buy brand name acticin
  • no prescription cod acticin
  • buy acticin cod pharmacy online
  • acticin discount order
  • order online acticin
  • acticin lowest price india
  • Aciphex | Order Online From Canada

    Looking for a aciphex? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • canadian aciphex order online
  • buy aciphex fedex shipping
  • aciphex online purchase
  • buy aciphex online only
  • buy aciphex fast shipped
  • overnight aciphex no rx foreign
  • cheap aciphex with no prescription
  • Accutane | Cheapest Uk Cheap

    Looking for a accutane? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • purchase online accutane rxs
  • purchase online without accutane
  • mail order accutane without prescription
  • generic accutane order online
  • cheap pill accutane
  • cod legal accutane in chicago
  • Abilify | Buy Free Fedex Shipping

    Looking for a abilify? Not a problem! Guaranteed Worldwide Shipping Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. Visit This Website...

    Tags:

  • order quality abilify
  • #abilify
  • buy cheap abilify overnight
  • discount price for abilify
  • buy abilify pill on line
  • abilify buy american express
  • order abilify online buy cheap
  • ATP vs ADW – the Autonomous Database lockdown profiles

    By Franck Pachot

    .
    The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services.

    To show how this is old, here is how they were defined in the Oracle7 Tuning Book:

    CaptureOLTPvsDSS

    The definition has not changed a lot. But the technology behind DSS/DWH has improved. Now, with In-Memory Column Store, Smart Scan, Result Cache we can even see that indexes, materialized views, star transformation, hints,.. are disabled in the Autonomous Datawarehouse cloud service.

    MERGE JOIN CARTESIAN: a join method or a join type?

    By Franck Pachot

    .
    I’ll present about join methods at POUG and DOAG. I’ll show how the different join methods work in order to better understand them. The idea is to show Nested Loops, Hash Join, Sort Merge Join, Merge Join Cartesian on the same query. I’ll run a simple join between DEPT and EMP with the USE_NL, USE_HASH, USE_MERGE and USE_MERGE_CARTESIAN hints. I’ll show the execution plan, with SQL Monitoring in text mode. And I’ll put some gdb breakpoints on the ‘qer’ (query execution rowsource) functions to run the plan operations step by step. Then I’ll do the same on a different query in order to show in detail the 12c adaptive plans.

    Creating a RAC 12.1 Data Guard Physical Standby environment (3b)

    Huh, what is this I hear you ask? Part 3b? Oracle 12.1? Well, there’s a bit of a story to this post. Back in December 2016 I started to write a series of blog posts (part 1 | part 2 | part 3 | part 4) about how I created a standby database on RAC 12.1. For some reason I forgot to post this part. Up until now the step where I am creating the broker configuration was missing. Thanks to a friend I discovered my mistake.

    How much free space can be reclaimed from a segment?

    By Franck Pachot

    .
    You have the feeling that your table takes more blocks than it should? Here are the queries I use to quickly check the free space. The idea is to call DBMS_SPACE.SPACE_USAGE and infer the minimum space from the percentages. For example, a block in FS3 (defined as having at least 50 to 75% free space) is supposed to have at least 50% of free space. Of course it can have more, but you don’t know.

    CQRS, Event Sourcing and the Oracle Database

    By Franck Pachot

    .
    This blog post relates my thoughts when reading about Command Query Responsibility Separation and Event Sourcing, in the context of the Oracle Database (but it can probably apply to any database). We see those terms in the new software architecture diagrams, but they are actually quite old:

    Command-Query separation

    Command-Query separation was defined by Bertrand Meyer 15 years ago, not for the database but for the Eiffel language. See page 22-44 of Eiffel: a language for software engineering.