Login for Oracle employees only

Recent Posts

« previous | home | next »

MOS Note 1454618.1: Quick Reference to Database PS...

DBAPlanet | 12.1.0.2 | April 26, 05:00 AM PDT | By Mike Dietrich-Oracle

Sometimes my mouse arm gets tired by clicking myself through MOS notes just to download a specific PSU or BP - and as I experiment a lot with PSUs and BPs right now I clicked a lot in the past days and nights.  Usually I'd start with either MOS...

Greatly Improved SQL Index Performance for Oracle ...

Roller Planet | berkeley | April 25, 08:15 AM PDT | By Michael Schulman-Oracle

A new whitepaper has been published, "Greatly Improved SQL Index Performance for Oracle Berkeley Database, Version 6.2". Learn how to increase the performance of SQL Queries using BDB. Go to: http://www.oracle.com/technetwork/database/database-tech...

Greatly Improved SQL Index Performance for Oracle ...

DBAPlanet | berkeley | April 25, 08:15 AM PDT | By Michael Schulman-Oracle

A new whitepaper has been published, "Greatly Improved SQL Index Performance for Oracle Berkeley Database, Version 6.2". Learn how to increase the performance of SQL Queries using BDB. Go to: http://www.oracle.com/technetwork/database/database-tech...

SQL Pattern Matching Deep Dive - Part 3, greedy vs...

Roller Planet | matching | April 25, 07:43 AM PDT | By Klaker-Oracle

Picture courtesy of Pixabay Welcome to the third post in this deep-dive series on SQL pattern matching using the MATCH_RECOGNIZE feature that is part of Database 12c.  In the first part of this series we looked at a wide range of...

SQL Pattern Matching Deep Dive - Part 3, greedy vs...

DBAPlanet | matching | April 25, 07:43 AM PDT | By Klaker-Oracle

Picture courtesy of Pixabay Welcome to the third post in this deep-dive series on SQL pattern matching using the MATCH_RECOGNIZE feature that is part of Database 12c.  In the first part of this series we looked at a wide range of...

Oracle Open World 2016 - Call for Proposals

DBAPlanet | Berkeley DB | April 22, 08:21 AM PDT | By Michael Schulman-Oracle

The call for proposals for Oracle Open World 2016 is open.  Please submit your proposals by May 9, 2016.  The proposal web site is:  https://www.oracle.com/openworld/call-for-proposals.html  Submit if you have an interesting use of...

How to Use SQL Plan Management

DBAPlanet | 12c | April 22, 03:05 AM PDT | By nbayliss-Oracle

Introduction In December I posted an entry on the subject of SQL plan management (SPM). It was inspired by questions raised at Oracle Open World 2015 and since then I’ve been talking to more customers about it, particularly in the context of upgrades. As...

Web technology in APEX Development

DBAPlanet | April 22, 02:54 AM PDT | By Dimitri Gielis

How did you get started with developing your first APEX app? My guess is either you went to https://apex.oracle.com and got a free account or Oracle Application Express was already in your company and somebody told you the url you could connect to....

New PREUPGRD.SQL is available - Upgrade 12c - Apr1...

DBAPlanet | Best Practice | April 21, 08:00 PM PDT | By Mike Dietrich-Oracle

It's time for a new and improved version of our team's preupgrd.sql (comes with the preupgrade package utluppkg.sql).  The April 2016 preupgrd.sql  Please always download and use the most recent version from: MOS Note:884522.1How to...

New SQLcl Available for Download

DBAPlanet | sqlcl | April 21, 01:08 PM PDT | By thatjeffsmith

Tons of bug fixes, mostly. You can now ask for your working directory via the PWD command. And of course don’t forget we let you CD inside of SQLcl… Download is here . Scroll down to the bottom, link is on the right side. [ Read...

Common Distribution Methods in Parallel Execution

DBAPlanet | parallel_processing | April 21, 09:23 AM PDT | By Yasin.Baskan-Oracle

Parallel execution uses the producer/consumer model when executing a SQL statement. The execution plan is divided up into DFOs, each DFO is executed by a PX server set. Data is sent from one PX server set (producer) to another PX server set (consumer) using...

Oracle Database BP April16 applied successfully

DBAPlanet | Patch Recommendation | April 21, 05:42 AM PDT | By Mike Dietrich-Oracle

Usually I don't post twice a day but as my post scriptum for the previous blog post got longer and longer I decided to write an entry about it - maybe simply because I feel soooo happy that my patch application succeeded flawless. For many of you the...

Oracle April 2016 PSU and Proactive BPs are there

DBAPlanet | 12.1.0.2 | April 21, 12:37 AM PDT | By Mike Dietrich-Oracle

Hurray, it's Patching Day! Sounds a bit like D-Day But April 19, 2016 the most recent April PSUs (Patch Set Updates) and BPs (Bundle Patches) got released. Find all the necessary information with the below links:  Critical Patch Update -...

Data Pump - Exclude Stats differently for TTS and ...

DBAPlanet | Best Practice | April 19, 08:00 PM PDT | By Mike Dietrich-Oracle

Nice little best practice for statistics and Data Pump when doing either Transportable Tablespaces or Full Transportable Export-Import (credits to Roy and Dean Gagne).. Transport Statistics via a Staging Table First of all we always recommend to exclude...

« previous | home | next »