Search

OakieTags

more tags

Who's online

There are currently 0 users and 26 guests online.

Recent comments

Affiliations

Home » Monthly archive

January 2012

Funny Cloud Computing Video…

Submitted by oraclebase on Mon, 2012-01-23 10:42

If you loved this,

And you loved this,

Then you will probably love this,

Cheers

Tim…




ASH Visualizations: R, ggplot2, Gephi, Jit, HighCharts, Excel ,SVG

Submitted by khailey on Sun, 2012-01-22 09:23

There is more and more happening in the world of visualization and visualizing Oracle performance specifically with v$active_session_history.

Of these visualizations,  the one pushing the envelope the most is Marcin Przepiorowski. Marcin is responsible for writing S-ASH , ie Simulated ASH versions 2.1,2.2 and 2.3. See

Here are some examples of what I have seen happening out there in the web with these visualizations grouped by the visualization tool.

Hotsos Symposium

Submitted by KarenMorton on Sat, 2012-01-21 20:01

My favorite conference of the year is just around the corner.

Underworld: Awakening…

Submitted by oraclebase on Sat, 2012-01-21 15:20

I went to watch the 3D version of Underworld: Awakening yesterday.

I’ve made my feeling know about 3D several times and this film changes nothing. The 3D element is an expensive gimmick I can live without. What’s more, the 3D in this film is pretty crappy. It looks like a post-production thing, rather than being filmed in 3D. It just so happens the cinema I went to was only showing it in 3D so I had little choice.

Friday Philosophy – Lead or Lag (When to Upgrade)?

Submitted by mwidlake on Fri, 2012-01-20 18:13

I was involved in a discussion recently with Debra Lilley which version of Oracle to use. You can see her blog about it here (and she would love any further feedback from others). Oracle now has a policy that it will release the quarterly PSUs for a given point release for 12 months once that point release is superseded. ie once 11.2.0.3 came out, Oracle will only guarantee to provide PSUs for 11.2.0.2 for 12 months. See “My Oracle Support” note ID 742060.1. However, an older Terminal release such as 11.1.0.7 is not superseded and is supported until 2015 – and will get the quarterly PSU updates. This left the customer with an issue. Should they start doing their development on the latest and theoretically greatest version of Oracle and be forced to do a point upgrade “soon” to keep getting the PSUs, or use an older version of Oracle and avoid the need to upgrade?

Video: deep review of LMS

Submitted by rshamsud on Fri, 2012-01-20 16:21

This video was created circa July 2011. Click the Read More link to review the video. Version Oracle Database 11.2.0.2

Synopsis: Essentially, we probe the importance of LMS processes using DTrace. Explain why LMS should run in elevated priority. How to review deep statistics about LMS processes and much more.

DataGuard Broker configuration backup

Submitted by pioro on Fri, 2012-01-20 14:31
Some time ago I have seen question on oracle-l list about DataGuard Broker configuration backup. There was no clear answer and there were some suggestions to use "dgmgrl" and perl script to display and parse output. This topic was very interesting for me and I decided to dig deeper and find out how Oracle is keeping these information. 
First step was to figure out how DataGuard Broker is gathering that data. You can enable debug option for dgmgrl tool and check how it works
piorovm$ dgmgrl -xml -debug
DGMGRL for Linux: Version 11.2.0.2.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle.

Finding the Next Primary Key Value, a Pre-fixed Solution

Submitted by Charles Hooper on Fri, 2012-01-20 07:00

January 20, 2012 A request for assistance came in from an ERP mailing list.  The original poster (OP) is running an unspecified version of Oracle Database 9i, and is in need of a solution to generate new part numbers with prefixed characters that describe the type of part, followed by a sequential number that is [...]

SCN – What, why, and how?

Submitted by rshamsud on Thu, 2012-01-19 21:48

In this blog entry, we will explore the wonderful world of SCNs and how Oracle database uses SCN internally. We will also explore few new bugs and clarify few misconceptions about SCN itself.

What is SCN?

SCN (System Change Number) is a primary mechanism to maintain data consistency in Oracle database. SCN is used primarily in the following areas, of course, this is not a complete list:

The strangest Oracle problem I ever encountered – can you guess the cause?

Submitted by oradebug on Thu, 2012-01-19 19:48

Before I joined Blue Gecko, I did independent remote DBA work, and called myself ORA-600 Consulting. Stemming from my hair-raising experiences in the trenches at Amazon in the late ’90s / early 2000s, I decided to specialize in emergency DBA work for companies in the midst of crises (I know, great idea for someone who wanted to get away from the Amazon craziness, right?).

One day in 2009, a company in Florida called my cell phone at 2AM. They described their problem as follows: