Dynamic logging with global application context

| Apr 30, 2009
Controlling logging output across sessions using global application context. September 2007 (updated April 2009)

Querying v$lock

There have been a number of scripts made available for querying v$lock to diagnose locking issues.

One example is one I got long ago from tsawmiller on Oracle-L. The original script showlock.sql, or something close to it is still available at OraFaq.com showlock.sql

showlock.sql has morphed over the years to keep up with changing versions of Oracle.

At one time the showlock.sql resembled the OH/rdbms/admin/utllockt.sql script, in that it created a temporary table to speed up the results, as the join on v$lock, dba_sessions and dba_waiters was so slow.

That was remedied at one (more...)

NZOUG Wellington Regional Meet this week 1-May-09: Public Appearance

NZOUG Regional Events this week and next week!

Yes, I'll be out of the cave for a change on Friday!

If you'd like to discuss anything from my recent bag of tricks:
OBIA/OBIEE with Oracle eBusiness Suite and all things Business Intelligence related, EBS and APEX Integration, advanced BI Publisher techniques, complex EBS auditing and AuditTrail, scanning documents to EBS, EBS and custom JSPs, Discoverer, OAF, Oracle VPD, CPU/Security Updates, EBS R12 on a Laptop, EBS with Firefox/Greasemonkey, hacking adpatch or even MySQL, Drupal, SugarCRM:
come down to the NZOUG Event at the the Oracle Wellington on Friday 3.30pm (more...)

Enhanced APEX Shuttle Item

Recently I have been really, really busy building some internal applications for my company. All of them using Oracle and APEX of course. To satisfy some of application’s requirements, and just for usability sake, I had to tweek the default behavior of the APEX shuttle item. The reason was the initial LOV that populated the shuttle contained over 500 values. About 490+ too many as far as I was concerned. The users felt the same way. They complained that it was too hard to find what they were looking for, even though the list was in alphabetical order and I (more...)

Looking Forward to Kaleidoscope

Watching this interview with Mike Riley of ODTUG reminds me of how proud he is of his user group’s annual conference, Kaleidoscope. He knows people get a lot out of attending, and he convinced me; I’ll be there. This was Mikes first interview as president of the group and he (more...)

Provisioning Active Directory – Best Practices

After the very popular Suncle series covering the Sun/Oracle identity and access portfolios, the blog went on a brief hiatus but we're baaaaaaack. Instead of giving y'all yet another dose of Identigral, we've got Martin Sandren as our guest blogger today.

Martin is a security architect at Genzyme in Boston. Prior to joining Genzyme he spent four years implementing Oracle Identity Manager for Sena Systems in both US and Europe. Martin is originally from Sweden where he received his Masters degree in computer science from Chalmers University of Technology. He also lived in Germany and the UK. You can reach (more...)

Oracle buys Java, Microsoft .NET will rule desktop

Since Oracle killed off client/server application development with Forms 6i, their position has been that new applications should be built building web technology. Oracle has invested heavily in JavaServer Faces together with ADF, which is what they are using for Oracle Fusion Applications. This approach (ADF Faces) is well supported (more...)

Obiee – How to configure the Mail server of Oracle BI Scheduler/Delivers

This article talk about the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as : * the sender address * the smtp server * the smtp port To be able to save an Ibot, you must have performed the [[dat:obiee:bi_scheduler:obiee_scheduler_configuration|initial [...]

OBIEE and Apex Integration

You may have sometime to change some data in your application. [[ide/apex|Apex]] is a great tool that allow you to develop and deploy rapidly a web based application. Here for our example, we must access to a vendor Apex form to change some values on it. Our goal is to have the report below in [...]

Flutter is the new Twitter

Worth a look, for those (like me) who find 140 characters too much to hande. Hat-tip to the BCS Oddit blog

The big bite

We at Identigral are a bit obsessed with Edward Lear so we couldn't help ourselves. Instead of writing another few pages worth of text on Sun/Oracle future, we thought it would be easier to summarize the last few days in two limericks:

There was a company whose name was Sun
That took Java out for a run
With NetBeans spilled
And MySQL forked
Larry the Yachtsman got the wine uncorked

There is a company in Redwood Shores
Whose appetite grew in fours
A fork in the left
A spoon in the right
And the Valley became one big bite

The rise of Suncle: Solaris, Java, ripple effects

In previous articles on this blog, we took a look at all 3 parts of Sun/Oracle identity and access management portfolio - identity administration, access management and directory services. This blog will talk about some of the other components of the acquisition.

Solaris. With Oracle gaining ownership of Solaris, Oracle Enterprise Linux (OEL) will no longer be an ever-present entity looking very forlorn on the list of supported/certified platforms for a particular Oracle identity or access product. I don't think Oracle will abandon OEL completely (RedHat and IBM need to be kept in check, after all) but it will (more...)

ruby-plsql new version – Ruby 1.9.1 support and more

I have released ruby-plsql gem (Ruby API for Oracle PL/SQL procedure calls) new version 0.3.0 which includes several new features.

Ruby 1.9.1

Probably the most important is support for Ruby 1.9.1 – now you can use both Oracle enhanced adapter and ruby-plsql gem on all three major Ruby plaforms:

  • MRI 1.8.6 with ruby-oci8 1.0.x library or gem
  • Ruby/YARV 1.9.1 with ruby-oci8 2.0 library or gem (currently just trunk version of ruby-oci8 2.0 contains the last bug fixes for Ruby 1.9.1)
  • JRuby (so (more...)

The rise of Suncle: Directory Services

I've covered identity administration and access management pieces of Sun/Oracle (affectionately referred to as Suncle on this blog) product portfolio in my previous blog posts. This one will address the remaining third - directory services. (Updated to correct the omission of virtual directory and identity synchronization from Sun's suite).

Oracle brings Oracle Internet Directory (OID) and Oracle Virtual Directory (OVD) to the party, Sun brings Sun Java System Directory Server (Sun DS) Enterprise Edition. Sun's Enterprise Edition packaging includes 3 pieces: Directory Server, Directory Proxy Server and Identity Synchronization for Windows. Sun's Directory Server corresponds to Oracle Internet Directory, Sun's (more...)

The rise of Suncle: Access Management

This post is a continuation of a series analyzing Sun/Oracle acquisition in the context of identity and access management. Read the Identity Administration article if you want to start from the very beginning.

Access Management. Oracle has quite a few pieces in this bucket but only three of them have a counterpart in Sun's world: Oracle Access Manager (OAM), Oracle Identity Federation (OIF) and Oracle Web Services Manager (OWSM). Sun's OpenSSO product contains web and federated single sign-on capabilities along with a bit of web services security. Oracle fields three separate products to answer the same needs - Access Manager (more...)

The rise of Suncle (volume 1)

With the news of Oracle acquiring Sun exploding like an errant bombshell on the peaceful identity management beach shores, it's a perfect opportunity for me to step into my analyst shoes (Jimmy Choos donations are welcome). For those of you who prefer your conversation in 140 character chunks, (more...)

The rise of Suncle (volume 1)

With the news of Oracle acquiring Sun exploding like an errant bombshell on the peaceful identity management beach shores, it's a perfect opportunity for me to step into my analyst shoes (Jimmy Choos donations are welcome). For those of you who prefer your conversation in 140 character chunks, you can follow us on Twitter; the proposed Twitter tag for Sun/Oracle discussions is #suncle; it's also the tag used on this blog.

Let's compare and contrast Oracle and Sun identity and access management portfolios. We'll use functional buckets because that's the easiest way to get apples-to-apples comparison. Here's what (more...)

Advanced Oracle Troubleshooting by Tanel Poder in Singapore

When I first saw that Tanel will conduct his seminar in Singapore, I told myself that I would even spend my own money just to be on that training! I’ve already read performance books like Optimizing Oracle Performance, Oracle 8i Internal Services, Forecasting Oracle Performance… And after that I still want more, and I still have questions that need to be answered. Well, if you’re on a tight budget you just opt to download some more docs/books to do multiple reads coupled with research/test cases and also reading through others blog…
But thanks to my boss for the funding, I (more...)

The Relational Model

If you look at any system that was born on and for the internet, like Ruby on Rails, or the PHP language, you find an immense wealth of resources on the internet itself, in endless product web sites, blogs, and forums. But when you look for the same comprehensive information (more...)

Obiee – Period to period comparison with the analytical function Lag/Lead

During [[http://forums.oracle.com/forums/message.jspa?messageID=3403773#3403773|this thread]] on the Obiee forum, [[http://108obiee.blogspot.com/|Goran]] point out a solution for a period to period comparison with the analytical function lag. It was time for me to drill down in this analytical function and to compare it with the obiee time function : ago. [[analytic:analytic_functions:analytic_function_lag|lag and lead]] are analytical functions that can be [...]