Skip to content





Daily Archives Tuesday, May 2008

Configuring Weblogic For Restart After Reboot on Windows

I have been working on a customer project involving new installations of Oracle Database (a two-node failover cluster using Oracle Clusterware–good stuff) and two load-balanced BEA Oracle Weblogic servers for the middle tier. The middle tier environment runs on Windows Server 2003 Enterprise x64 Edition and is managed by an outsourced hosting facility.
I had worked [...]

Posted 06 May 2008 † Dan § Uncategorized ‡ Comments Off °

Testing a No-statistics Environment.

I am absolutely sick and tired of dealing with issues where misleading partition statistics (for example) cause ETL queries to go crazy and try to sort-merge tables with tens of millions of rows each.
Since we’re about to run a test load on production data I’m going to drop all table and index statistics and lock [...]

Posted 06 May 2008 † David Aldridge § Uncategorized ‡ Comments Off °

Suggest a Session is a Hit

Less than a week since we deployed it, the Suggest a Session for OpenWorld 2008 offer made by the Events team on Mix has been a big hit.
Traffic was up over 250% over the weekend, and the voting page is already among the top pages on Mix in terms of pageviews over the past 30 [...]

Posted 06 May 2008 † Jake § Uncategorized ‡ Comments Off °

select distinct collect

I answered a question on otn today about distinct.
Reprased, how to select distinct collection?

select job, collect(distinct deptno) deptnos
from emp group by job;

JOB       DEPTNOS
——— ——————————————-
ANALYST   SYSTPTJCzBffh0AjgQ59n0o3QCA==(20)
CLERK     SYSTPTJCzBffh0AjgQ59n0o3QCA==(10, 20, 30)
MANAGER   SYSTPTJCzBffh0AjgQ59n0o3QCA==(10, 20, 30)
PRESIDENT SYSTPTJCzBffh0AjgQ59n0o3QCA==(10)
SALESMAN  SYSTPTJCzBffh0AjgQ59n0o3QCA==(30)

5 rows selected.

select distinct collect(distinct deptno) deptnos
from emp group by job;

ERROR at line 1:
ORA-22950: cannot ORDER objects without MAP or ORDER [...]

Posted 06 May 2008 † Laurent Schneider § Uncategorized ‡ Comments Off °

Download a Free Copy of EnterpriseDB: The Definitive Reference (PDF)

The publisher of my book, EnterpriseDB: The Definitive Reference, recently made the book available on the web in PDF format. You can also download

Posted 06 May 2008 † An Expert's Guide to Oracle Technology § Uncategorized ‡ Comments Off °

Dates and times comment

A few days ago, Farooq posted some comments on an old post of mine. The final comment in our exchange concerned storing activities in our data warehouse by time (actual hour and minute). This is quite a common requirement, especially where the performance of customer service agents is being measured (as in Farooq’s question)
I would [...]

Posted 06 May 2008 † Peter Scott § Uncategorized ‡ Comments Off °