Search

Top 60 Oracle Blogs

Recent comments

September 2012

OOW 2012 – AMIS Insider Tips (Dutch)

San Francisco is de city of love. Iedereen is er vriendelijk en geeft je het gevoel dat je elkaar al jaren kent. San Francisco is ook de city of fog. In de ochtend is de stad bedekt met een koele zeemist die de stad in nevelen hult en je dwingt om voorzichtig te rijden. Tijdens …

Continue reading »

Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output

Jagjeet Singh mentioned that he has built a V2 of his cool SQL Dashboard sqlplus-based monitoring script, which now also shows a nice colored ASH graph output. Yes, right inside sqlplus!
This reminded me that I demoed color output in sqlplus when I delivered the Hotsos Symposium training day a few years ago, when introducing the MOATS tool the first time. I never got to colorize it as I had hoped to though… as MOATS was more of a fun project I worked on with Adrian Billington just to prove that it is possible to build a monitoring tool purely based on SQL and PL/SQL with a TOP-like self-refreshing screen output.

Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output

Jagjeet Singh mentioned that he has built a V2 of his cool SQL Dashboard sqlplus-based monitoring script, which now also shows a nice colored ASH graph output. Yes, right inside sqlplus!
This reminded me that I demoed color output in sqlplus when I delivered the Hotsos Symposium training day a few years ago, when introducing the MOATS tool the first time. I never got to colorize it as I had hoped to though… as MOATS was more of a fun project I worked on with Adrian Billington just to prove that it is possible to build a monitoring tool purely based on SQL and PL/SQL with a TOP-like self-refreshing screen output.

Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output

Jagjeet Singh mentioned that he has built a V2 of his cool SQL Dashboard sqlplus-based monitoring script, which now also shows a nice colored ASH graph output. Yes, right inside sqlplus!

Indexes: Oracle11g New Features Presentation (Get Back)

I’m in the early stages of compiling an Oracle12c Indexes New Features presentation so I thought I might make available the 11g version I’ve presented previously at Oracle OpenWorld and InSync conferences: http://richardfoote.files.wordpress.com/2012/09/oracle-indexing-new-feat... Enjoy

OOW 2012 – OakTable World 2012

Slight name change, but still the same venue and OakTable people presenting on 1st and 2nd of October. If you not yet have heard, thanks to sponsoring / the help of Pythian, Miracle, Delphix and OakTable people, there will be a conference during the conference, Oracle Open World that is. With sessions, presentations and demo’s …

Continue reading »

Loving VirtualBox 4.2…

I’m loving VirtualBox 4.2.

I’ve been throwing some RAC, WebLogic and Cloud Control installations on it at home and it’s been coping just fine. I’m especially loving the grouping stuff. I’ve got quite a lot of VMs and scrolling down the list can get a little tiresome. Grouping them and collapsing the group is great!

So far I’ve only see one issue with the groups and I’ve not been able to repeat it. When I dragged one Windows VM (with 2 virtual disks) into a group, both virtual disks were physically moved into the new group sub-directory, but the interface “lost” one of the disks. I went into the Virtual Media Manager, deleted the reference to the “missing” disk, then added it by re-selecting the file from the file system. Everything then worked fine.

Minimum stats

Occasionally I come across complaints that dbms_stats is not obeying the estimate_percent when sampling data and is therefore taking more time than it “should” when gathering stats. The complaint, when I have seen it, always seems to be about the sample size Oracle chose for indexes.

There is a simple but (I believe) undocumented reason for this: because indexes are designed to collate similar data values they are capable of accentuating any skew in the data distribution, which means a sample taken from a small number of leaf blocks can be highly misleading as a guide to the whole index – so Oracle aims for a minimum sample size for gathering index stats.

UKOUG Day 1

My tasks for today

  1. Make sure everyone knows about the Unconference – you’ve got Monday and Tuesday to sign up for a time-slot of 20 or 40 minutes. The event itself is on Wednesday, on the left-hand wing of the balcony in the Exhibition hall. Seating for 30, with a projector, A0 flipchart, and loudspeaker system available. The sign-up sheet / Agenda is up against the wall in the registration area, to the far left – just past the hideous pink pillar. I’ll keep an update of speakers and topics on the blog whenever I can, and you can always tweet your own entry on the #ukoug2012 tag.
  2. Spend some time on the UKOUG Council stand (just to the right of the right-hand door of the Exhition hall) – I’ve signed up for the time-slot that overlaps the exhibition reception drinks (18:30 – 19:30) but I’ll be there by about 18:00

Presentations etc.

Undo Quiz – Bringing the Right Tools for the Job

September 17, 2012 Sometimes humor is a good recipe for undo.  A mid-50s man was driving down the road, riding a purple mule, when he saw a house with a new window.  Uninvited, the man decided to take a closer look using an obvious tool of choice, a tire iron (YPDNTI).  Elapsed time, roughly 60 seconds.  [...]