Search

Top 60 Oracle Blogs

Recent comments

Events

How To Cancel A Query Running In Another Session

This is not really anything new - in fact Tanel Poder has already blogged about it a while ago. Tanel has specifically covered the handling of "urgent" TCP packets and how this could be used to signal a "cancel" to another process, however this only works on Unix environments and not with Windows SQL*Plus clients. In Tanel's article it is also mentioned that there is an officially documented way of doing this via the Resource Manager if you happen to have an Enterprise Edition license.

In my quick tests however the call to DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS using "CANCEL_SQL" as consumer group only errors out with ORA-29366 saying that the specified consumer group is invalid.

UKOUG 2011: Using your Database as a Fileserver

One of the coolest things in Oracle 11g and onwards is a functionality called XDB Repository Events. Most of you probably know that based on XMLDB functionality in the database, the database also can be used in a File server kind of way by enabling the XDB Repository HTTP/FTP or WebDAV functionality via DBMS_XDB. XDB

Read More…

The UKOUG 2011 Conference: OakTable Sunday !

Do I need to say more………. Why not join us for OakTable day on Sunday 4th December? In a smaller setting, you can attend a dedicated set of sessions directly from a selection of OakTable members away from any potential session contention of the main conference. The sessions will be presented in just two streams, …

Continue reading »

OOW 2011 – Oracle XML DB and Big Data

Last day of Oracle Open World and I am currently attending the last presentations. The first presentation, “Oracle XMLDB: A noSQL Approach to Managing all your Unstructured Data”, deals with the no-SQL approach and using Oracle XML DB in the context of using it with “Big Data”, that is unstructured data. The title of the …

Continue reading »

OOW 2011 – Oracle Enterprise Manager Cloud Control 12c

After a long wait Oracle Enterprise Manager 12c, aka Oracle Enterprise Manager Cloud Control 12c is about to make it’s appearance. You can find information about the EM12c environment via following this link: http://www.oracle.com/technetwork/oem/grid-control/overview/index.html This will not only bring you to the documentation and download URL’s but also to some ELearning YouTub movies that demonstrate …

Continue reading »

OOW 2011 – What’s New, Improved and Coming in Oracle Application Development

Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history APEX has gone thru and the current setup with the APEX Listener and even the “PL/SQL Gateway” was mentioned. I always have to laugh a bit because this last one touches the XDB Protocol Server …

Continue reading »

OOW 2011 – NoSQL Databases and Oracle Database Environments

I am currently at a presentation of Patrick Schwanke, Quest Germany, regarding easy and high speed connect between NoSQL and Oracle Databases. Not really what I planned but as mentioned by Alex Nuijten in an earlier post, unstructured data and it’s handling is gaining ground, so I thought it would a good start do start …

Continue reading »

OOW 2011 – On Our Way

Early mornings…really hate them, but can avoid it this time due to our flight going out towards San Francisco is scheduled at 9.50PM. Oracle Open World is near and a few days away from getting started. Alex, Lucas and I meet up this morning in Schiphol, Hollands main airport for our flight to the ACE …

Continue reading »

KSCOPE 2011: Keynote & Award Recognition

While the congrats are getting in via the usual virtual channels like Twitter and mail for being awarded the best speaker awards for the Database (Alex Nuijten) and Fusion Middleware (Luc Bors) tracks, I would like to mention that great Keynote session on Monday that was put together by the ODTUG Kaleidoscope board. The board created some hilarious movies while using these as a bridge to speak about the bit more serious topics like last years awards, “thank you”-s for the people out there that made it all work and for example the new location of Kaleidosope 2012. Via my YouTube channel you can see sketches of: “The Bachelorette”, “Big Brother” and others…

To give you a taste of what was shown:

Have fun and see us at Oracle Open World or at Kaleidoscope 2012

KSCOPE 2011: What do you mean “Agile”?

Currently in Cary Millsap’s session about his agile approach on things called “My Case for Agile Methods“. Agile is (not yet) my thing, but knowing Cary, and he is in to it, when he is enthusiastic about something its probably one of those things which you should look into. If not even due to, as far as I know, the Agile context Cary is using is not the Agile context referred to I see being used out there. The “agile” thing out there is the one, is the one, I will joke about. But that said, a lot of methods are not bad at all, but people implement them wrongly so trying to keep an open mind, this session of Cary was more or less mandatory to get my vision about this back on track once more.

Cary also mentioned this emotion that probably mainly goes around in the DBA world. But as Cary mentioned during his presentation, “Agile is not undisciplined”, so if it gets the wrong emotional context, then is mainly due to people not doing it correctly. Could be thats it has to do with not being correctly trained in Agile or maybe incorrectly “managed”. So what is Cary’s feeling about this, that is, “Agile” as is…

Incremental Design… “Plans fail, bit there are ways to prevent a failed plan from failing your project…” so you can prevent this by continuously design, build and construct your project. The main key here is “continuously”. So for example, you don’t design your house and then leave the project, but should continuously design and iterate on your design as needed by a customer. This counts, is needed, for every stage, so the design, build and construct part.

Rapid Integration… “The worst software in the world? …90% complete, but nobody can run it yet…”. So if you want incremental design to be implemented quickly is really a step to support this continuous integration regarding bringing in all those improved, new, altered designs, build and construct tests

Test-First Programming
… “Ever been afraid to improve your code?”. So how does test-first programming work?

  1. Add a case
  2. Add a test
  3. Run all test (and check off all tests and see what fails or not…)
  4. Write code
  5. Run all tests (and make sure it now all succeeds)
  6. Refactor

Pair Programming… Are you stuck? Not in the mood? Are you skipping steps? The fun part Cary here describing is that he is aware of how his office furniture is placed. It turned out that it is in such a way that its supports the buddy part where your buddy (wingman) can look at your code or comment on your code during your programming. Also your buddy can back you up when your stuck or tired. Of course its also more creative in the end due to the fact that you push each other in more creative and productive ways while doing your tasks, like programming.

Ten-Minute Build… This will mainly keep your energy up to create the best as you can do. You can’t continuously keep up the high level of concentration and if you can’t keep your pace your code level will deteriorate…

So keep in mind, if “Agile” looks stupid then most of the time its not the method that is “stupid”, but that it is implemented “stupid” by people. I indeed really believe that to make Agile work, that you need smart and disciplined people to make this work and a “customer” that continuously interacts with the team. Getting the hang of “it”, I indeed believe that most of the laughable stuff out there, is due to people, but then again, isn’t most IT/software/method out there based on what people do?. Its people, good people, that make it work, with a proper understanding of what the goals are you want to achieve…

I run into lately regarding a big project, if you are implementing very restrictive security rules in your development environment, then what is the “security goal” of doing this? If there is no balance into this kind of thinking, in the process, then its destructive to the overall goal. In such environment, probably, Agile methodology shouldn’t be applied in the first place. Think outside the box and give “Agile” a go, it might surprise you, but don’t underestimate the energy, flexibility, that is needed to implement it from each and every team member and the environment you work in.

There was more in Cary’s presentation, but have a look at Cary’s website, where most of this is way better explained anyway and a place to get into on topic discussions…