Search

Top 60 Oracle Blogs

Recent comments

January 2014

Spoiler

Here’s a little detail I could do without in my database:



select
       owner, object_type, object_name
from
        all_objects
where
        object_name like '_'
order by
        object_name, object_type
;

OWNER           OBJECT_TYPE         OBJECT_NAME
--------------- ------------------- --------------------
APEX_030200     PROCEDURE           F
PUBLIC          SYNONYM             F
APEX_030200     PROCEDURE           G
APEX_030200     PROCEDURE           P
PUBLIC          SYNONYM             P
APEX_030200     FUNCTION            V
PUBLIC          SYNONYM             V
APEX_030200     PROCEDURE           Z
PUBLIC          SYNONYM             Z

9 rows selected.


Public names like P and F for procedures or functions are just not on (unless I create them myself).

Analyzing IO at the Cell level with cellcli… a new and improved script

Recently I had the pleasure of corresponding with Hans-Peter Sloot.  After looking at my simple tool in this post to gather cell IO data from cellcli, he took it a several steps further and created a nice python version that goes to the next level to pull IO statistics from the cells.

current_rw_rq.py

This script provides breaks down the IO by “Small” and “Large” as is commonly done by the Enterprise manager.  It also provides a summary by cell.  Here is a sample output from this script.

Analyzing IO at the Cell level with cellcli… a new and improved script

Recently I had the pleasure of corresponding with Hans-Peter Sloot.  After looking at my simple tool in this post to gather cell IO data from cellcli, he took it a several steps further and created a nice python version that goes to the next level to pull IO statistics from the cells.

current_rw_rq.py

This script provides breaks down the IO by "Small" and "Large" as is commonly done by the Enterprise manager.  It also provides a summary by cell.  Here is a sample output from this script.

If you’re not using hugepages, you’re doing it wrong!

Well, there’s been a bit of a delay in with my planned testing of dbVisit Replicate and Oracle GoldenGate for zero-downtime upgrades. So, I’ll be (hopefully) getting back to that within a couple of weeks.

Meanwhile, I recently ran across a discussion on the Oracle OTN Community forums, asking about performance and hugepages configuration, here in the Oracle Database – General Questions Forum.

I think my answer bears repeating, so, here is a slightly modified version:

First, I’m going to take a strong position on hugepages. I’m going to go as far as to say, for any non-trivial SGA size, if you’re not using hugepages, you’re doing it wrong. There are three main points to consider.

Fedora 20 : Upgrade from Fedora 19

It’s a little over a month since Fedora 20 was released, but during a terrible bout of insomnia last night I decided to upgrade my desktop PC.

The upgrades using “fedup” worked fine for the previous releases (Fedora 18, Fedora 19). Unfortunately, it failed abysmally for the upgrade to Fedora 20. I tried a few times, but I was not able to troubleshoot it, so I gave up and did a reinstall.

I’ve got an SSD for the system drive, but keep almost everything of importance on a second drive (and a backup drive). I tend to do most things in VMs, so I ended up doing the following:

OUGN Vårseminar 2014

I’ve had some papers selected for the OUGN Vårseminar 2014 event in April, so I will be there representing OTN and the Oracle ACE Program. There is an impressive array of speakers lined up for this event already. Should be fun!

I’ve got a couple of months to practice my Captain Jack Sparrow impression. I wouldn’t want to look out of place on the boat!

Cheers

Tim…

 

CSS and Squarespace: Getting Started

CSS style rules let you bust into full-on, creative mode when designing
websites on the Squarespace platform. The Squarespace promise is one of
gorgeous template designs that you build out with...



Read the full post at www.gennick.com/database.

CSS and Squarespace: Getting Started

CSS style rules let you bust into full-on, creative mode when designing
websites on the Squarespace platform. The Squarespace promise is one of
gorgeous template designs that you build out with...



Read the full post at www.gennick.com/database.

Speed up Import with TRANSFORM=DISABLE_ARCHIVE_LOGGING in #Oracle 12c

A very useful 12c New Feature is the option to suppress the generation of redo during Data Pump import. I was talking about it during my recent 12c New Features class in Finland and like to share that info with the Oracle Community here. My usual demo user ADAM owned a table named BIG with one index on it. Both were in LOGGING mode when I exported them. The Data Pump export did not use any 12c New Feature and is not shown therefore.

Free developer day in Perth

Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm.

There’s something for

  • database developers
  • Apex developers
  • ADF developers

See you all there …

http://bit.ly/oddperth20140218