Skip to content

Category Archives: Uncategorized

Oracle E-Learning Resources

There is a lot of new stuff out there nowadays, regarding products and/or functionality or others. This is also true for Oracle and in short it’s not easy to follow all those innovations and/or new products. So from time to time I have a watch on…

Posted 12 May 2012 † Marco Gralike § Oracle ‡ Comments Off °

Optimizer Funkiness…

I have two simple tables that I want to join in an outer join:

SQL> @bug32052.sql
SQL> set feedback on
SQL> 
SQL> drop table jh1;

Table dropped.

SQL> create table jh1 (x number(10));

Table created.

SQL> 
SQL> drop table jh2;

Table dropped.

SQL> create table jh2 (x number(10));

Table created.

SQL> 
SQL> insert into jh1 values (1);

1 row created.

SQL> commit;

Commit complete.

SQL> 
SQL

Posted 11 May 2012 † Jeff Hunter § ‡ Comments Off °

It’s Yes Time!

Finally after many years of being complicit in the poisoning of our own bodies, many people are coming to realize that lots of the food products (as opposed to food) that we buy in supermarkets are bad for us, make us sick. Thanks, Michael Pollan and o…

Posted 11 May 2012 † Steven Feuerstein § ‡ Comments Off °

My first .NET gui in Powershell

I managed to interface Oracle and a GUI via powershell. First, load the Oracle and the .NET assemblies [void] [Reflection.Assembly]::LoadFile("C:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll") [void] [Reflection.Assembly]::LoadWithPartialName("Drawing") [void] [Reflection.Assembly]::LoadWithPartialName("Windows.Forms") Now, let’s retrieve EMP in a powershell array. I hope one of my reader will advise me on a better way $connection=New-Object Oracle.DataAccess.Client.OracleConnection("Data Source=DB01; User Id=scott; password=tiger") $connection.open() $command=new-object Oracle.DataAccess.Client.OracleCommand("select ename [...]

Posted 11 May 2012 † Laurent Schneider § ‡ Comments Off °

Exadata

Enkitec have just announced the call for papers for their E4 conference to be held in Irving, Texas this August. (See this link for the announcement.)
I’ll be there … playing the devil’s advocate.

Posted 11 May 2012 † Jonathan Lewis § Oracle ‡ Comments Off °

Log Buffer #271, A Carnival of the Vanities for DBAs

They say, “April showers bring May flowers.”  They basically say that nature brings different things in different colors aimed at improving the things. That is so true for the blogging world too. This Log Buffer Edition also brings out different b…

Posted 11 May 2012 † Fahd Mirza § Oracle ‡ Comments Off °

Oracle’s Timeline, Copious Benchmarks And Internal Deployments Prove Exadata Is The Worlds First (Best?) OLTP Machine – Part II

There Is No Such Thing As “Pure OLTP” There is no such thing as “pure OLTP.” How true! And that’s why you are supposed to buy Exadata for your Oracle OLTP/ERP deployment—at least that’s what I’ve heard. Part I of this series on the topic of Oracle OLTP/ERP on Exadata Database Machine has brought quite [...]

Posted 11 May 2012 † kevinclosson § Oracle ‡ Comments Off °

MySQL news in a spot

A calm week this time, I was really busy on daily work, but had some spare time that I have use to do simple implementation and tests. My work was related to Tablespace management in 5.6 and Table partition EXCHANGE, you can read the articles here . I…

Posted 11 May 2012 † Marco Tusa § ‡ Comments Off °

Hardware Components Failures — Survey Results

When preparing for the the IOUG Collaborate 12 deep dive on deploying Oracle Databases for high Availability, I wanted to provide some feedback on what hardware components are failing most frequently and which ones are less frequently. I believe I have…

Posted 10 May 2012 † Alex Gorbachev § Oracle ‡ Comments Off °

Pokemon and When Others…

Question: What do Pokemon and When Others in PL/SQL have in common?For many developers the answer is:Asnwer: You gotta catch ‘em all.I saw this other blog post on “Dodgy Coder” and was greatly amused by the comparison of Pokemon and catching all except…

Posted 10 May 2012 † Thomas Kyte § ‡ Comments Off °