The Really Cool NTILE() Window Function

If you regularly code queries and have never been introduced to the windowing functions, then you are in for a treat. I've been meaning to write about these for over a year, and now it's time to get down to it.

Support in Major Servers

SQL Server calls these (more...)

My Steps to Implement Exadata EHCC

Add to Technorati Favorites


Ver este articulo en EspañolSubscribe to Oracle Database Disected by Email

Last time I was engaged with an Exadata migration, customer asked me about EHCC and how to implement it for their datamarts.

My approach (at that time) consisted on the following:
1) Get a sample of very big objects to play with
2) Used DBMS_COMPRESSION in order to get estimations for compression rates
3) Try every compression type: Basic, Query Low, Query High, Archive Low, Archive High and recorded size reductions, time to import and time for FTS.
4) Recorded and compared timings for various batch processes and (more...)

Loops Without Cursors

Looping Without Cursors

Sometimes you need to process a table row-by-row, and the established approach is to use cursors, which are verbose, slow, and painful to code and use.

The Cursor Example

Here is the basic minimum syntax required to loop through a table and get something done. The (more...)

How to refresh MVIEW in parallel

Refresh TYPES are COMPLETE/FAST/ON COMMIT/ON DEMAND
Couple of things you should do to make a mview to refresh in parallel:
1.) Alter the master table to make sure it allows parallelism:

alter table parallel (degree 4);
To check
select degree from dba_tables where table_name='
';

2.) When you create the mview log (incase of FAST refresh mviews), create it with a parallel clause:

create materialized view log on parallel (degree 4);
OR
Incase (more...)

You can always learn something new.

It’s high time for this blog to come off hiatus.  I really don’t know why I let it go so long, just pre-occupied with work and extra curricular activities I guess.

One of those activities was to contribute two chapters to a new book from Apress, Pro Oracle SQL.  Though it was only two chapters, it did consume a significant amount of time.  Some folks seem to be able to bang out well written prose and code with seemingly little effort.  It seems that I labor over it more than most, at least it feels that (more...)

Revisiting Normalization and Denormalization

In this blog I have done at many articles on Normalization and Denormalization, but I have never put all of the arguments together in one place, so that is what I would like to do today.

There are links to related essays on normalization and denormalization at the bottom of (more...)

UKOUG 2010 APEX meetup!

Venue: Pennyblack’s at The Mailbox – http://www.pennyblacksbar.com

Time: Monday 29th November arrive 8:00pm – 8:30pm

Be there!


OT: Good value first class fare?

From the NationalRail website:




One million squids for a day return?

Speaker Awards and a Pantomime…..

>Before you think this is something completely random (which it probably is) yes, I am indeed talking about this year’s UKOUG TEBS Conference.

The Inspiring Presentation Awards (IPA’s) will be handed out for the first time at this year’s UKOUG Technology and E-Business Suite Conference.

The event will be taking (more...)

Our second official book review in on its way…

by Fábio Souza Hi everyone, are you doing well? I'm fine, thanks for asking. Well, I was wondering these days : "It would be a good idea to change the topic for a little while and talk about a...

This is a summary only. Please, visit the blog for full (more...)

Calling an Oracle database procedure from Java with only ONE line of code

About a year ago I was working on an ADF application for one of our clients. One of the problems they faced was that they needed to call a lot of database procedures. It is not very hard to call a database procedure if you are familiar with the JDBC (more...)

Oracle Database 11g Interactive Quick Reference

Just a quick note about the Oracle Database 11g Interactive Quick Reference That was released today to the public. This Interactive Quick Reference, created by Oracle University and the Server Technology Curriculum group, is your Essential Guide to Oracle Database 11g Release 2. This interactive quick reference includes an architecture diagram, a comprehensive list of [...]

From 3Tb to 1.5Tb Using standard COMPRESS and PCTFREE

Add to Technorati Favorites

Ver este articulo en Español

I've been working on a migration project, with very aggressive dates and a couple of requirements that increase difficulty: switch from filesystem to ASM, using 50% of new storage... yes, you got the right picture, we don't have full set of disks for ASM to fit all data, therefore I need to move data trying to release complete datafiles in order to free those logical volumes or LUNs, and later add them to ASM.

Anyway, I realized that given this is a DSS or Datawarehouse, there is some margin to increase "data density" per block, (more...)

Some Great New Features

I've been off exploring Oracle 11g for a little bit trying to figure out a strategy to upgrade my environment. Oracle 11g has a ton of new features, most of which are now "options" (in other words they cost more money). When Oracle came out with compression at the segment level in 9i, I thought it was a great feature, at least in theory. But as I got to use compression, I found out that DDL

SQL Developer 3.0 Early Adopter now available

Early Adopter (EA) releases of SQL Developer and SQL Developer Data Modeler EA 2 are now available for download from OTN.

SQL Developer new features are described here. The marque SQL Developer 3.0 is improved migrations. You can see an enhanced migration wizard in our EA release, however you (more...)

APEX 4.0.2 is here, and its got two new themes!

Oracle Application Express (APEX) 4.0.2 patch is now available on MySupport and a re-release is available on OTN as of last Friday November 19th, 2010. You can read all about Oracle APEX 4.0.2 here. In addition to fixing 111 bugs (thanks to all who made the (more...)

Prepare Now For Possible Future Head Transplant

This is the Database Programmer blog, for anybody who wants practical advice on database use.

There are links to other essays at the bottom of this post.

This blog has two tables of contents, the Topical Table of Contents and the list of Database Skills.

Planning For The Unlikely

We (more...)

SQL Developer 3.0 Migration Features

Uncategorized
| Nov 19, 2010
Barry McGillin has a breakdown of the new migration features of SQL Developer 3.0
http://barrymcgillin.blogspot.com/2010/10/migration-features-in-sql-developer-30.html


And an article on the new Estimation Report
http://barrymcgillin.blogspot.com/2010/10/migration-estimation-from-sql-developer.html

I'm going to flesh out some of these on this blog

culture shock ;-)

This week's DOAG 2010 conference in Nuremberg finally gave me an opportunity again to visit Germany after not having been there in a few years, and to present to a very engaged local APEX community in my native tongue. I think the conference was a great success and I was (more...)

R12: You can make a payment run across multiple OU’s

Uncategorized
| Nov 18, 2010
In R12, the payments process has undergone quite a bit of change. Earlier in R11i, one could only process payments for one OU, because the internal (disbursing) bank was associated to an OU. However, in R12, internal banks are set for an LE which could be in turn associated to one or more OU's. Hence, its possible that while doing a payment run, you can process all invoices from your internal bank across invoices raised under different OU's.