Search

Top 60 Oracle Blogs

Recent comments

September 2014

Openworld bound..

I’ll be in Openworld again this year, and have a couple of speaking slots…

I’ll talk about new features for developers in 12c on Sunday, Sep 28, 2:30 Moscone South 303

https://oracleus.activeevents.com/2014/connect/sessionDetail.ww?SESSION_ID=2244

and of course, at the awesome Oaktable world..

http://www.oraclerealworld.com/oaktable-world/agenda/

Drop in, learn some cool things, or just pop up and say Hello!

The #SAFE_DEAL: On the road to Equal Taxation with a baseline of the poverty level

Twenty-two years ago, when I previously ran for US Senate and began writing about reviving the idea of full support of persons legally in the country to the poverty level, we were in much better overall financial shape. An actual maximum tax would have been possible with some budget discipline. Eventually and philosophically, I think that is still the goal. If everyone made enough money to pay an equal share of the country’s budget and still be above the poverty level, that is what we should do. The philosophy is clear: One Person, One Vote; One Person, One Tax.

Oracle IO wait events: db file sequential read

(the details are investigated and specific to Oracle’s database implementation on Linux x86_64)

Exadata IO: This event is not used with Exadata storage, ‘cell single block physical read’ is used instead.
Parameters:
p1: file#
p2: block#
p3: blocks

Despite p3 listing the number of blocks, I haven’t seen a db file sequential read event that read more than one block ever. Of course this could change in a newer release.

FARNHAM for US Senate Campaign 4 Hashtags, 3 Key concepts

One of my friends noticed that I am trying to push forward campaign finance reform by trying to win without a TV media budget, and he asked what was my hash tag. DOH! I should have created hash tags long ago. Okay, there is still time to go viral. I’ve registered four hash tag definitions with hashtag.org, and I’ll explain them here, first with just the snapshot definitions I could get to stick without the site complaining : Stop! You’re posting too fast and then with the full story as individual blog posts. Hang in there. This is important.

Oh, and my top priority is establishing the #SAFE_DEAL.

#SAFE_DEAL

A system where the government makes sure all persons legally resident start with a base minimum income of at least the poverty level and get to retain at least 65 cents on each dollar they earn. See rsiz.wordpress.com for the details.

#WRONG_GAP and #CORRECT_GAP

WordPress 4.0

WordPress 4.0 “Benny” has been released. The download is in the usual place, but you are probably going to upgrade by clicking the auto-upgrade button.

I did 4 upgrades and all went fine. I can’t say things look that different after it, but you’ve got to keep on top of these upgrades I guess.

Cheers

Tim…

 


WordPress 4.0 was first posted on September 4, 2014 at 10:30 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

RESULT_CACHE Hint in 12.1.0.2

Every new Oracle Database patch introduces not only documented features, but also undocumented ones. In this short post I would like to provide information about an enhancement of the RESULT_CACHE hint.

According the documentation, the RESULT_CACHE hint has no parameter. But, as of 12.1.0.2, at least the SNAPSHOT parameter is supported. Its purpose is to specify how much time (in seconds) after the creation the result cache entry has to expire. In other words, you can specify that a specific entry expires even though the objects is based on doesn’t change.

The following example illustrates:

Group By Bug

This just in from OTN Database Forum – a surprising little bug with “group by elimination” exclusive to 12c.


alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss';

select
       /* optimizer_features_enable('12.1.0.1')*/
       trunc (ts,'DD') ts1, sum(fieldb) fieldb
from (
  select
        ts, max(fieldb) fieldb
  from (
  select trunc(sysdate) - 1/24 ts, 1 fieldb from dual
  union all
  select trunc(sysdate) - 2/24 ts, 2 fieldb from dual
  union all
  select trunc(sysdate) - 3/24 ts, 3 fieldb from dual
  union all
  select trunc(sysdate) - 4/24 ts, 4 fieldb from dual
  union all
  select trunc(sysdate) - 5/24 ts, 5 fieldb from dual
  )
  group by ts
)
group by trunc (ts,'DD')
/

You might expect to get one row as the answer – but this is the result I got, with the execution plan pulled from memory:

EM12c and Windows OS Failover Cluster- Keep it Simple

This is going to be a “KISS”, (Keep it Simple, Silly) post.  I was offered a second Windows cluster to test on when my original one was required for QA.  It was a gracious offer, but I also found out why a cluster should be kept simple and this cluster was anything but simple.  Many times, issues are created and we’ll never see them coming until we go through the pain and the EM

5 secrets 10% of Fortune 500 use to double application development output

#222222;">#808080;">This article liberally uses sections from #0000ff;">#0000ff;">The Threat That Lies Within  by Yaniv Yehuda

#000000;">

Databases receive much attention so they will not become THE risk factor of IT. Budgeting DRPs, backups, top of the line DBAs – and yet, they still pose a major threat. Why?