Welcome to our meetup #7! This meetup will be focused on Oracle Advanced Queuing (AQ) feature and its usage in Oracle E-Business Suite.
For inexperienced SOM members, we are starting with the meet & greet and pizza+drinks at 5:30 pm and move to smart things at 6:00 pm. We will be there until about 8:30pm (some are sticking around a bit longer while some might take off a bit earlier) and will have a break in the middle. The second half is generally more open-ended as most of you already know.
Every Oracle professional knows about Oracle Enterprise Manager’s extensive monitoring capability for Oracle products. However, only few realize that Oracle Enterprise Manager can be easily extended thanks to its Extensibility framework.
This presentation starts with an introduction of Enterprise Manager’s Extensibility features and walks the audience through the basics of creating a new plug-in. This session will also demonstrate some proven plug-in development steps based on the experience gained from developing MySQL management plug-in.
Session includes a demo of the plug-in development scenarios. After this presentation, attendees will be able to design and develop management plug-ins for their own applications.
The first videocast was quite popular — it has more than 300 views in couple weeks and considering no Hollywood stars were starring in that video and there were no nude scenes, I think it’s fair to say that this format was very much welcomed by the audience.
Today, I’m posting the follow up session on VIP’s (Virtual IP’s) with Oracle RAC. What I demonstrate today is a typical configuration mistake for a RAC databases created with Database Configuration Assistant (DBCA) and what’s the result of such omission.
It’s actually logged as a bug 4338578 on Metalink (thanks to Marcin Przepiorowski for reference). However, I believe it’s not a database issue but (1) misunderstanding how remote listener registration works, (2) documentation bug and (3) DBCA bug.
The init.ora parameter remote_listener defines the list of remote listeners that an instance should register with. The parameter local_listener sets the address for the local listener registration and if not specified, by default it’s hostname and the default port 1521. However, it turns out that the local_listener parameter is used not only for local registration but for something else as well… Read the rest of this entry »
I’ve been just sending the abstracts for UKOUG 2009 Conference before the extended deadline is over and realized that I hadn’t spread those exciting news. Actually, the news spread viaTwitter before I saw the official confirmation in my inbox. Well, I guess the blog post title says it all. It’s a pleasure to join this program and get engaged in its activities.
I should mention that the process actually involves the acceptance on my side and there are expectation from me such as participation in local, global and online events with Oracle and their product teams as well as participate in some OTN activities. Well, there is rather nothing I haven’t done before except maybe access to some special events where Oracle product teams share some pre-release information. Well, I surely won’t mind any additional info to satisfy my curiosity.
Finally, thanks to Francisco Munoz Alvarez for nominating me to become an Oracle ACE Director.
Now, I guess I will have to scout the internet and update all my online profiles. When is this magical Web 2.0 going to actually work?!
Where: Our usual location at Sydney CBD. Level 3 this time!
Details:
We will start at 5:30PM with pizza and drinks and roll on from there as usual.
Note that we are meeting at the level 3 this time!
This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order - quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.
Just got an interesting note on Twitter that you can’t call a stored procedure dynamically in Oracle from a PL/SQL block like passing the procedure name in a variable.
Well, yes we can!
And the answer is EXECUTE IMMEDIATE — it can be used to run anonymous PL/SQL blog and not just a SQL statement. However, you will want to think many many times before doing so… if you love your data.
Let’s create the test procedures:
SQL> create or replace procedure bingo as
2 begin
3 dbms_output.put_line('Bingo!');
4 end;
5 /
Procedure created.
SQL> create or replace procedure bambam as
2 begin
3 dbms_output.put_line('BAM BAM!');
4 end;
5 /
Procedure created.
I think it was the smallest group so far which is not surprising considering that Monday has been the least popular day in our internal poll. We had a tad less than 20 people but very good size for the informal discussion of Oracle 11g adoption that took place at the second half of the meetup.
Turned out that there are very few people running 11g in production. Besides us at Pythian with number of clients on 11g, we’ve had only couple people I think including Carl Young from Metcash. Carl shared their experience of running a multi-terabyte data-warehouse on Oracle 11g and how the migration happened. Thanks a lot Carl for your insights!
If you haven’t seen the case study from Oracle about this migration — see what benefits Metcash had with 11g migration. I myself took note of few areas — Query Cache helped a lot on dimension tables lookups and some popular reports, Materialized Views invalidation problems reduced, CBO becomes smarter.
Some of the things to pay attention to in 11g — Oracle Warehouse Builder 11g (11.1.0.6) has actually less features than the latest OWB 10g release. If you look at 11.1.0.7’s list of bugs fixed (Metalink Note 601739.1), you would see a few dozen bugs on “Wrong Results” Read the rest of this entry »
“Seeing it once is better than hearing about it a thousand times” — I think this is the closest translation from one Russian proverb. I may add that hearing and seeing might be often better then reading so let me try to start a series of small videocasts about Oracle database technology.
One of the topics that beginners RAC DBA’s (along with network engineers supporting Oracle database infrastructure) are confused about is the Virtual IP usage in Oracle RAC starting from Oracle Clusterware 10g.
With this videocast, I will try to clarify those concerns once and for all. I have embedded the video here in a smaller window so you might want to go directly to YouTube for the full-size version of “Pythian Video: Oracle RAC - Why VIPs“.
This is an experiment for now so let’s see how it goes. Let me know if you find this format useful and don’t forger to rate it on YouTube. Note that if you don’t leave any comments here, I’d never know whether you liked it or not so don’t be shy and comment away…
More than a month has passed since Sydney Oracle Meetup #2. We shot some video, but it took me a while to process it and publish a few interesting pieces, but I finally got it all.
Ric Van Dyke’s presentation on tuning SQL queries using 10046 trace is available on the SOM website in the Files section (you must be a member). However, there were no material from Tanel Poder’s session — it’s title started with “Zero Slides…” and Tanel demonstrated live some of his secrets of productivity in Oracle troubleshooting. Luckily, my colleague, Andrey Goryunov, managed to shoot some of it on the video and I’m publishing here a couple fragments on the visualization of Oracle performance troubleshooting.
Make sure you are watching them in HQ on YouTube to see more details and if you like these videos, make sure you rate them.
PerfSheet is a very handy solution based on Microsoft Excel scripting and let you automate extraction and charting of any data you can extract from an Oracle database (and generally speaking, any other database). The best thing is that Tanel has put great efforts in it and made it available to everyone for free. One demo is worth many words so here we go: Read the rest of this entry »
Oracle 11g SE Switch-Over Recently, I tested a switchover on Oracle 11g SE1.
As you know, Oracle Database Standard Edition One—as well as Standard Edition—does not more
Database Team Manager Service Delivery and Applications , Telstra
Pythian were recently engaged to take a lead role in a high end infrastructure build project at Telstra. Our requirements were a combination of... more
