OraNA :: Oracle News Aggregator

Welcome to the 152^nd edition of Log Buffer, the weekly review of database blogs.

PostgreSQL

Courtesy the United States PostgreSQL Association, the big news: PostgreSQL 8.4 Released!.

Josh Berkus writes, “Now that PostgreSQL 8.4 is out, I thought I’d write a little about my favorite 8.4 feature. As Mr. Performance Whack-a-Mole, what makes me happy about 8.4 is the ability to whack moles faster … which is why I’m very fond of pg_stat_statements.”

On ad’s corner, Andreas Scherbaum says, “Up to PostgreSQL 8.3 it was only possible to grant (and revoke) permissions on the entire table. If column level permissions were needed, a workaround like a view solved (more or less) the problem . . .  This . . . is uneloquent, error prone and does not scale well.  . . .  PostgreSQL 8.4 solves the problem with a shiny new feature: column level permissions.”

David Fetter looks into WITH (so much drama in the CTE): ” By now, you’ve probably seen that PostgreSQL 8.4 can produce Mandelbrot sets . . . but what are Common Table Expressions really about? [They] are just views you create at run time. Oh, and they can refer to themselves. That latter capability is powerful and flexible (read confusing), so I’ll go over that one later. Run-time views are pretty handy, though.”

Andrew’s PostgreSQL blog introduces parallel pg_restore for PostgreSQL 8.4: “I try to complete at least one significant feature item per PostgreSQL release. This time the feature is making pg_restore run in parallel. This is quite important for many users, particularly some large enterprise users.”

SQL Server

Eric Johnson introduces SSIS 2008 and the new lookup: “SSIS is a pretty useful tool for designing ETL processes. One of the transformations I was disappointed with in 2005 was the lookup. I found it a little better than the lookup functionality in DTS, but not too much better. Well, Microsoft must have read my mind because SQL Server 2008 has a new shiny Lookup transformation that is, in my opinion, much improved.”

Kimberly L. Tripp was thinking about looking for security vulnerabilities in database code. “I’ve always been concerned with security and I’ve always stressed the importance of auditing the REAL user context not just the current user . . .  So, I generally try to avoid using dynamic string execution and if necessary create well tested/protected parameters . . .  Having said that, what if I’m looking at a database for the first time . . .  I’ve come up with a quick query… And, while it’s not going to “solve” your problem . . . or even truly verify if you’re vulnerable, it gives you a ‘quick list’ of where you should look first! ”

Adam Machanic exposed the hidden costs of INSERT EXEC, beginning, “INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post I will cover hidden penalties that a decision–seemingly purely aesthetic–can bring to the fore.”

Martin Bell offered the reminder, after disabling TDE you still requires the certificate to restore the database.

Data Management has a first-rate HOWTO on dynamic column names and fields in SSRS. “I had no choice but to do work with creating dynamic column headings and dynamically determine what field in my dataset should go where in a report today. Sense [sic] this is the second time I’ve gone through this exercise and knowing the lack of information out there on really how to do it, I thought it deserves a blog entry.  . . .  So here is the basis of the requirements. You have a query that uses PIVOT but thrown into the mix is the need for dynamic columns in the PIVOT.”

MySQL

Here on the Pythian Blog, Sheeri Cabral expressed some concerns and what does not work in XtraDB backup.

On xaprb, Baron Schwartz has a review of MySQL Administrator’s Bible. “I think that MySQL Administrator’s Bible is a very good complement to High Performance MySQL, 2nd Edition. The former is useful to people who have varying levels of knowledge, while the latter assumes a lot of experience and doesn’t cover introductory material much.  . . .  So if you’re new to databases, or if you’re new to MySQL, you might do well to start with Sheeri’s book . . . ”

Over on the MySQL Performance Blog, Baron looked into gathering queries from a server with Maatkit and tcpdump: “For the last couple of months, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s an observer of the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time resolution.”

Ronald Bradford looked at verifying MySQL replication in action, with “ . . . a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.”

The MySQL Workbench Team Blog says, Time To Upgrade - MySQL Workbench 5.1 Is Here on Win, Mac & Linux. Perty pictures follow.

Oracle

H. Tonguç Yilmaz asserted, Instrumented Code is Better: An Example on How to Generate Session Level ASH Reports. ” After 10g if you have its license ASH based performance monitoring is an alternative to the traditional SQL Tracing in my opinion. You may either use EM to generate ASH reports or directly query ASH dictionary. The handy additional hint here is that you can set filters to ASH data in order to focus on a specific session, the filter options at ASH report screen at EM can be used for this purpose or below is an example to monitor the waits from v$active_session_history view.”

Doug Burns responded with his item on session-level ASH reports: “I think [Tonguç's] post is really showing two different things, one more successfully than the other.”

Randolf Geist reports a Dynamic sampling and set current_schema anomaly: “If I’m now supposed to analyse a rather complex SQL with dozens of table and/or view references I like to use the ALTER SESSION SET CURRENT_SCHEMA command . . .  This basically works just fine, but I recently have come across an interesting anomaly in 10.2.0.4: If the optimizer uses dynamic sampling as part of the parsing then it doesn’t do so anymore if the CURRENT_SCHEMA has been altered to a non-default schema.”

On the Oramoss Blog, Jeff Moss looks at the case of no pruning for MIN/MAX of partition key column: “Recently, I wanted to work out the maximum value of a column on a partitioned table. The column I wanted the maximum value for, happened to be the (single and only) partition key column. The table in question was range partitioned on this single key column, into monthly partitions for 2009, with data in all the partitions behind the current date, i.e. January through mid June were populated. There were no indexes on the table.” Jeff and his readers examine the evidence and discuss some workarounds to the problem.

Oracle, MySQL, PostgreSQL, SQL Server. How’bout . . . 

NoSQL

(No SQL?!? Edwards, you’re mad!) Well, it’s not me. Here’s Curt Monash on NoSQL: “Eric Lai emailed today to ask what I thought about the NoSQL folks, and especially whether I thought their ideas were useful for enterprises in general, as opposed to just Web 2.0 companies. That was the first I heard of NoSQL, which seems to be a community discussing SQL alternatives popular among the cloud/big-web-company set, such as BigTable, Hadoop, Cassandra and so on.”

PostgreSQL stuff also had some thoughts on those who say No to SQL. “Every time I see something or hear something like this I sigh a little bit. Not only when it’s related to SQL but in the world of computer professionals in general. ‘The right tool for the job’ seems to be a hard concept to understand sometimes. I wonder why?”

Back to Oracle for a moment. Tanel Poder has a secret preview of Oracle 12g CBO leaked from Oracle labs. Would you like fries with your cost-based optimizer?

That’s all for now. See you in a week’s time!

Many of our readers are aware that we have had the "COREid Migration Service" available for public use for the past three years. This service has been a resounding success with several high profile North American OAM customers relying on it to maintain consistency across their environments. The expression, "If it ain't broke, don't fix it." best describes our attitude towards the initial release.

But the time was right for a platform upgrade, some rebranding, and some minor issue fixes.

Stitcher lives at the same address as the original service. If it sounds like something you've been missing, check it out.

Tweeting with Neil Ward-Dutton I had a thought about what he has written on public v private clouds and it made me think that the only real difference between them is in the who manages and pays. This might sound like a big thing but taking a leaf out of the retailers book it doesn't need to be that large.Vendor Managed Inventory is simply where a supplier takes over the management of a products

ASMLib provide an easy way to present storage to ASM on Linux, it takes care of device labeling and improves the performance of open-close calls to the devices. Is Oracle Best Practice for managing disks on Linux.

Lab2-Install-and-Configure-ASMLib.pdf

The following points are covered on this lab:

Install The ASMLib:

Cheking The Kernel Version
Downloading the Drivers for ASMLib
Installing the ASMLib Drivers

Configure ASMLib :

Create ASM Disks
ASMLib Directory Structures
ASM Directories
ASM files on /opt directory
Map ASMLib Disks to Physical Devices
File /etc/sysconfig/oracleasm
ASM init file

Annex:

Scripts

Oracle announce certification of the Oracle DB 10gR2 with IBM PowerVM Live Partition Mobility (LPM) on AIX 5.3 and AIX 6.1. Details are posted on the Oracle Technology Network Certify web site (Follow this path: View Certifications by Platform > IBM AIX POWER Systems > Database/Server >Oracle Database- Enterprise Edition.)
IBM is the first vendor to get Live Partition Mobility certified for use with Oracle.
With this announcement, IBM’s customers that run Oracle Database in a Single Instance Mode can take advantage of this key PowerVM feature. At the time of the publication, IBM and Oracle are working together to develop a plan to certify on RAC (Real Applications Cluster).
More information here

Oracle® products creates opportunities for hardware vendors that use infrastructures that are flexible, resilient, and cost effective. IBM offers true enterprise class storage support for Oracle deployments at a low total cost of ownership. With disk, tape, storage network hardware, consolidated management console, storage software, and security software, IBM can provide Oracle customers with the full spectrum of products to meet their availability, retention, security, and compliance requirements.
Services such as storage optimization and integration, information life cycle management, data mobility, business continuity and resiliency, security and privacy, product implementation, and managed services expand the IBM portfolio for Oracle customers. Solutions including storage virtualization, data warehousing, archiving, compliance, remote site replication, consolidation, and tape encryption complete the IBM portfolio, making IBM an excellent Oracle partner with a complete solution to offer our mutual customers.
You will find a lot of information into this documentation "Oracle and IBM storage solutions: Optimize yur Oracle investment with IBM".

List of IBM papers oriented storage with Oracle products.
I would like to focus on this list of document very useful for Oracle DBA and Unix engineer

. Cloning an Oracle database to the same server using FlashCopy and VolumeCopy
. Cloning an Oracle database using Enhanced Remote Mirroring
. Forward recovery of an Oracle database using Enhanced Remote Mirroring
. Migrating to Oracle 11g using Enhanced Remore Mirroring
. Recovering from catastrophic failures using Enhanced Remote MIrroring for data
replication
. Safely upgrading an Oracle database using Enhanced Remore Mirroring
. Selective restores using Enhanced Remote Mirroring with Oracle Flashback Database

Thanks to our good friends at NASA for the launch picture. This is the space shuttle Discovery blasting off on July 4 2006, click for the details of mission STS-121.

Our launch is at 8:00 AM, on Thursday July 9 at the Hilton Hotel - 488 George Street, Sydney.

We're launching Oracle Fusion Middleware 11g and you're invited, click here to register. We're going be joined by one of our product development Vice Presidents - Amit Jasuja - for the keynote session, and we'll follow that with overview sessions on the main product components of the 11g release - Identity Management, Enterprise 2.0, Application Grid and Service Oriented Architecture. Oh, and there's a lucky draw prize too!

7,350 years of development time have gone into this release so taking half a day out of your schedule seems a small price to pay. 7,350 years! That means that if you started developing today, you'd just be getting ready for your launch event in the year 9,359. By which time we will have all hung up our hydrogen powered personal jetpacks and just teleport oursleves everywhere right?

Once again, register here, and I look forward to seeing you there.

-sean

This post covers overview of Repository Creation Utility(RCU) which is first thing you need to do, if you are planning to implement/install Oracle Fusion Middleware 11g R1 (11.1.1.0).

Metadata Repository - contains metadata for Fusion Middleware Components (SOA, Webcenter, Identity Management) . There are various types of Repository - Metadata Services (MDS), Audit Services (IAU), Oracle Internet Directory (OID), Single Sign-On (SSO), SOA Infrastructure (SOAINFRA), Business Activity Monitoring (BAM) , User Messaging (ORASDPM) , Oracle WebCenter (WEBCENTER) , WebCenter Portlets (PORTLETS) , Oracle Content Server (OCSERVER) , Portal (PORTAL), Discoverer (DISCOVERER), Oracle Identity Federation (OIF) , Discussions (DISCUSSIONS) and Wiki and Blog (WIKI)

Repository could be Database-based or File-based, most component (Webcenter, SOA, OID…) requires Database-based Repository.
.

How to create Database-based repository ?
RCU - Repository Creation Utility is tool to create schema and load repository in existing database for Fusion Middleware components. 

Download RCU from here

.

Key points for Repository Creation Utility (RCU) in FMW

1. RCU can be run in two mode - GUI (Graphical User Interface) & CLI (Command Line Interface)

2. For Fusion Middleware 11g R1 (11.1.1.X) , RCU can only load schema in Oracle Database (version 10.2.0.4 and higher or 11.1.0.7 and higher)

3. You can run RCU locally (same machine where Database is running) or Remotely (Database is on remote machine)

4. By default RCU creates default schema and load repository in default tablespaces. RCU provides flexibility to change schema or tablespace name. (Only exception to this is Oracle Internet Directory (OID) schema)

5. You could load multiple repository (like Portal, webcenter, SOAINFRA) in single database. You could also load different version of same repository (like dev_soainfra, test_soainfra for DEV & Test instance resp.) in same database. (This is interesting feature for using single database for multiple Fusion Middleware Instances)

6. You can start RCU (Repository Creation Utility) from $RCU_SOFTWARE/bin/ rcu (for Unix) or rcu.bat (for Windows) ; This will start RCU in GUI mode. For CLI mode use “rcu [-silent | -interactive] {<command> <options>}”

7. RCU log file is written to the RCU_SOFTWARE_DIR/ rcu/ log/ logdir.<date_timestamp>/ rcu.log

8.For step by step Fusion Middleware Repository Creation Utility with screen-shots click here

.

What to do after creating Fusion Middleware Database-based Repository ?
Before you can use Repository for fusion middleware component (soa, webcenter), you need to register Repository with Oracle WebLogic Server domain . (How to register Database-based with WebLogic domain ? coming soon…)

. 

References

• RCU Download Link
• FMW Repository Creation Utility Documentation 
• RCU Database Requirement
• Managing Oracle Metadata Repository 

Share This

There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up.
These temporary segments in permanent tablespace can be created by DDL operations like CTAS and “alter index..rebuild” because
the new object is created as a temporary segment in the target tablespace and when the DDL action finishes it will be changed to permanent type.
These temporary segments take actual disk space when SMON fails to perform its assigned job to cleanup stray temporary segments.
Following query finds out these segments:

 SQL > select tablespace_name, owner, sum(bytes/1024/1024) from dba_segments
where segment_type = 'TEMPORARY' group by tablespace_name, owner;

TABLESPACE_NAME     OWNER          SEGMENT_NAME     SUM(BYTES/1024/1024)
------------------- ------------   ------------     --------------------
xxxx_DATA           SYS              123.8365          137706
BDEPST_INDEX        SYS              345.8756            8910
KMRPT_DATA          SYS                345.87       25284.875
BILL_INDEX          SYS                                   .25
DSS_DATA            SYS                                   798
MRKT_INDEX          SYS                                   208
SPCT_DATA           SYS                              69642.25
SPCT_INDEX          SYS                              956.4375

Here we can see that tablespace KMRPT_DATA, SPCT_INDEX and SPCT_DATA have large temporary segments.

To know if any DDL is active which can create temporary segments we can use the following:

SQL> conn / as sysdba
SQL> select owner FROM dba_segments WHERE segment_name='345.87';
SQL> select pid from v$process where username='owner from above query';
SQL> alter session set tracefile_identifier='TEMPORARY_SEGMENTS';
SQL> oradebug setorapid <pid obtained>
SQL> oradebug dump errorstack 3
SQL > oradebug tracefile_name

It will give you the tracefile name, open that file and check for the “current sql”
If it is a DDL like CTAS or index rebuild, then wait for the operation to complete. If there is no pid
returned then these segments are “stray segements” and needs to cleaned up manually.

There are two ways to force the drop of temporary segments:

1. Using event DROP_SEGMENTS
2. Corrupting the segments and dropping these corrupted segments.

1. Using DROP_segments:

Find out the tablespace number (ts#) which contains temporary segments:
SQL> select ts# from sys.ts$ where name = 'tablespace name';

Suppose it comes out to be 10, use the following command to cleanup temporary segments:

SQL> alter session set events 'immediate trace name DROP_SEGMENTS level 11';

level is ts#+1 i.e 10+1=11 in this case.

2. Corrupting temporary segments for drop:
For this following procedures are used:
- DBMS_SPACE_ADMIN.TABLESPACE_VERIFY
- DBMS_SPACE_ADMIN.SEGMENT_CORRUPT
- DBMS_SPACE_ADMIN.SEGMENT_DROP_CORRUPT

– Verify the tablespace that contains temporary segments (In this case it is KMRPT_DATA)

SQL> exec DBMS_SPACE_ADMIN.TABLESPACE_VERIFY('KMRPT_DATA');

– Corrupt the temporary segments in tablespace KMRPT_DATA

SQL> select 'exec DBMS_SPACE_ADMIN.SEGMENT_CORRUPT(' || chr(39) || tablespace_name || chr(39) || ',' || HEADER_FILE || ',' || HEADER_BLOCK || ');'  from dba_segments where SEGMENT_TYPE like 'TEMP%' and tablespace_name = 'KMRPT_DATA';

– Drop the corrupted temporary segments

SQL> select 'exec DBMS_SPACE_ADMIN.SEGMENT_DROP_CORRUPT (' || chr(39) || tablespace_name || chr(39) || ',' || HEADER_FILE || ',' || HEADER_BLOCK || ');' from dba_segments where SEGMENT_TYPE like 'TEMP%' and tablespace_name = 'KMRPT_DATA';

– Verify the tablespace again to update the new dictionary information:

SQL> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_VERIFY('KMRPT_DATA');

This will remove temporary segments from permanent tablespace.

Cheers!!!

Saurabh Sood

Related Posts

• Silent Install :OUI-10133:Invalid staging area Error (0)
• You Don’t need SysDBA privilege to run Awrrpt.. (0)
• Grid Control Fails to Start (2)
• Creating ASM devices on AIX (0)
• Recreating Database Link (4)

Charles Phillips launched the Oracle Fusion Middleware 11g two days ago in Washington D.C.

So now the Fusion stack is out and more and more products can use the new middleware. That is a good info for us, where we were waiting for the new platform for our Forms 11g.


Charles Phillips spoke about Key Partners, which helped him during the development of Fusion with beta testing and trainings. And here are two images from his presentation where we found our OPITZ CONSULTING logo on his main presentations:



Let's hope, that Forms 11g is launched in the next weeks
Gerd

If you have a trigger and you want to quickly disable him, then just use the "_"-technique :



In this case we have a Key-Create-Record-Trigger which should be disabled. Rename the "-" to "_" in the name of the trigger and from that point on the trigger is a user-named-trigger, which won't fire through an event.



Important: You can't rename the trigger to "KEY-CREREC2" or something else. The hyphen is in forms reserved for event-triggers.

To activate the trigger rename it back to "-" and that's all.

Have fun
Gerd

This is asked over and over in the forums, but why not proposing an 11g solution here

create table t(description varchar2(12) primary key, 
  numbers varchar2(4000));
insert into t(description, numbers) values ('PRIME','2,3,5,7');
insert into t(description, numbers) values ('ODD','1,3,5,7,9');
commit;

DESCRIPTION	NUMBERS
PRIME	2,3,5,7
ODD	1,3,5,7,9

Now I want to unpivot numbers in rows

select description,(column_value).getnumberval()  
from t,xmltable(numbers)

DESCRIPTION	(COLUMN_VALUE).GETNUMBERVAL()
PRIME	2
PRIME	3
PRIME	5
PRIME	7
ODD	1
ODD	3
ODD	5
ODD	7
ODD	9

It is that simple

Works also with strings :

select (column_value).getstringval() 
from xmltable('"a","b","c"');

(COLUMN_VALUE).GETSTRINGVAL()
a
b
c

Seems that Apple aside people are starting to find way to get java applications to run on the iPhone from the cheap and cheerful to the rather more high end products from people like Metismo. (Nice chaps, met them at JavaOne; but licenses were 10ks UKP but not for people just playing).

Perhaps I just need to bite the bullet and learn Objective-C...

Sometimes I get the question which Mac OSX software I use. So here's a list of programs I've installed. Some I use often others less often. If you use other nice software, feel free to add!

Standard Mac Software:

• Address Book
• AppleScript
• Automator
• Calculator
• Dashboard
• Dictionary
• Expose
• Font Book
• Image Capture
• TextEdit
• Unison
• Utilities
• Spaces
• iCal
• iSync
• Stickies
• Server - because we also have Mac OSX Server

Office:

• iWork
• iLife

Internet Applications:

• Adium - chat
• iChat - chat
• Colloquy - irc (not used that much)
• Cyberduck - ftp client
• DynDNS Updater - link a hostname to an ip
• Dropbox - online storage
• Firefox with different plugins (YSlow, LiveHTTPHeaders, Firebug, ColorPicker, ...)
• Safari - standard browser on OSX
• GoToMeeting - to do remote support and meetings
• SSH Tunnel Manager - ssh
• Meerkat - ssh
• Cisco VPNClient - vpn
• Viscosity - vpn
• Skype
• Mail
• Twitterrific - twitter reader
• Reader Notifier - get rss updates
• Yuuguu - connect to others
• Transmission - download files

Graphical Software:

• Adobe Acrobat 8 Professional
• Adobe Dreamweaver CS3
• Adobe Flash CS3
• Adobe Illustrator CS3
• Adobe InDesign CS3
• Adobe Photoshop CS3
• PDFpenPro - edit pdf
• Paintbrush
• OmniGraffle Professional 5 - make schemes
• iWeb - make websites

Games:

• Chess
• Quinn - tetris like
• MasterMind - dashboard plugin
  

Entertainment:

• DVD Player
• DivX Converter
• DivX Player
• EyeTV - makes it able to watch tv on my mac
• Flip4Mac - be able to play wmv
• GarageBand - audio
• Front Row - menu to all entertainment
• iDVD
• iMovie
• iPhoto
• iTunes
• ScreenFlow - record video
• Photo Booth
• VLC - play video
• QuickTime Broadcaster
• QuickTime Player
• VisualHub - convert video (not updated anymore)
• Spotify - play any song (only works when I'm in the UK)
• BookSmart - online creation of you photo albums
• WorldRadio widget - listen to radio as dashboard app
  

Local/External storage:

• ExpanDrive - Mount drives even through ftp etc
• Macfusion - extend to other filesystems
• SuperDuper! - backup your Mac

Phone:

• Missing Sync for Windows Mobile - I've an HTC and not an iPhone, so need extra software to sync agenda, contacts etc
• TomTom HOME - on my phone I have also GPS and navigation software

Oracle related:

• Oracle SQL DataModeler - SQL Modeler
• Power*Architect - SQL Modeler
• SQLEditor - SQL Modeler
• SQLDeveloper - my day to day tool to talk to the Oracle database
• Versions - SubVersion client
• VMware Fusion - to get access to my remote machines

Project Management:

• Merlin - allows to estimate the work and breakdown in pieces
• Mindjet MindManager - read MindMaps
• OmniFocus - to do list which is able to sync as well

Text Editor:

• SubEthaEdit - allows to work on a text with more persons, real time editing
• TextMate - favorite text editor

OSX Tools:

• OmniDazzle - mouse focus and effects
• Quicksilver - lunch commands fast
• StuffIt Expander - zip like
• 1Password - store passwords in a secure way
• Wallet - store passwords in a secure way
• World Clock Deluxe - to keep an eye when my clients get awake
• iBank - trying that, MS Money type app
• Caffeine - let your Mac never go in sleep mode
• Time Machine - automated backups
• iStat Pro widget - shows a lot of information about your Mac (ip, temperature etc)
• AccuWeather widget
• SysTran translation widget
• Currency converter widget
  

For the people who want to work faster, here's a good list of shortcuts for OSX.

Did you ever wonder where the balanced scorecard came from? It was created as part of a set of workshops by Drs. Kaplan and Norton with a group of companies who were looking for a way to combine financial and non-financial management information. The idea that emerged and that was finetuned over time was to group and connect four areas of performance: financial, customer, process and growth/learning.

I wasn’t in the room during those workshops that led to defining the four perspectives, but I have a hypothesis how it could have happened. In figuring out which non-financial areas to pick, someone may have mentioned the three value disciplines from Treacy and Wiersema: operational excellence, product innovation and customer intimacy. Treacy and Wiersema state that organizations need to score sufficient in all these areas, and need to excel at one.

These three value disciplines map 3 of the balanced scorecard perspectives perfectly: process, growth/learning (innovation) and customer. The fourth perspective had to be the financial outcome of those perspectives.

If it didn’t happen this way, at least it shows the logic of the four perspectives, as they align with other established management theory.

PS. Please take the survey that is part of the research for my new book on www.frankbuytendijk.com.

Contractors Network is pleased to announce the latest free of charge release into our extensive Oracle Apps related White Paper Library of:

“A Structured Approach to SQL Query Design”

Authored By Brendan Furey

About Brendan;

Brendan is an Oracle Applications Consultant with over nineteen years Oracle experience, across a wide range of projects and industries. He has worked with many Oracle modules, including Financials, Supply Chain, and CRM, up to 11.5.10. He is technically oriented, and has expert level knowledge of most of the Oracle development tools, as well as Unix and other tools, and also has good functional knowledge.

Recent projects have included: implementation of multi-org and intercompany invoicing within an existing single-org implementation; development of complex interfaces between Oracle instances using different CRM modules, with PO, AP AR; integration design (using middleware) for a European implementation of Oracle ERP (back-office) along with Siebel (front-office) and other systems.

The Purpose of Brendan’s Paper;

The purpose of this document is to describe a structured, graphical approach to the design of SQL queries that may be a useful way of handling complexity without reverting to procedural design. It focuses on sub query structure and join orders, rather than on other areas such as grouping and aggregation, or design patterns. The author has used it to design complex queries with up to 46 table instances, and the approach is demonstrated using a real (rather simpler) example of a custom report within Oracle’s Order Management and Inventory modules (see REF-2 for Oracle’s table specifications).

If you would like request a copy please email myself on rebecca.bragg@oraclecontractors.com or register via the White Paper library and request your copy today.

Retrouvez le webcast du lancement d'Oracle Fusion Middleware 11g

Plus d'informations :

• OTN
• Overview
• Press Release
• Launch Media Kit

La première release d'Oracle SQL Developer Data Modeler est enfin disponible en téléchargement sur OTN !

A hagyományosan minden évben (általunk is) megrendezett Fejleszt?i nap virtuális (válságbarát) verziójára: OTN Virtual Developer Day-re nemrég (május 27-29.) került sor. Azért szeretném felhívni erre a figyelmet, mert rengeteg hasznos el?adás tekinthet? meg felvételr?l:

• Building REA (Rich Enterprise Application) in the Cloud. Fusion middleware fejlesztés Amazon EC2 cloud infrastruktúrára.
• REA és Web 2.0 fejlesztés egyszer?en. Gazdag funkcionalitású webes alkalmazások fejlesztése JSF alapon, AJAX és Flash komponensekkel (ADF - Application Development Framework). WYSIWYG, deklaratív fejlesztés, egyszer?en és gyorsan.
• Adat gridr?l Java fejleszt?knek (els?, és második rész). Egy nagyon jó és alapos el?adás az adat gridr?l, Coherence-r?l! Ha valakinek nincs ideje megnézni, nem kell aggódni lesz még itt szó róla b?ven : )
• Oracle jöv?kép, stratégia és roadmap a felhasználói interakcióról (els?, második rész) A sok szolgáltatást nyújtó WebCenter használata, felületi integrációs képességei SOA környezetben, Web2.0-es alkalmazások egyszer? és gyors fejlesztése.
• Weblogic szerver: bemutatás, roadmap (els?, második rész). A jelenleg leggyorsabb JEE alkalmazás szerver képességei, jöv?je.
• 10 legjobb fejlesztést támogató technológiai elem a Weblogic Server 10gR3-ban (els?, második rész)
  . Mint például: Spring integráció, deployment plan, HTTP pub-sub képesség, stb.
• Nonintrusive (bocsi ezt nem fordítom le ; ) Java diagnosztika futás id?ben (els?, második rész). Egy professzionális diagnosztikai eszköz JRockit JVM-hez. Amely éles környezetben használható, tekintettel a nagyságrendileg ~1%-os többlet teljesítményigényre.

Egyetlen hátránya (ami a tartalmát tekintve el?ny), hogy viszonylag hosszúak (40-60 percesek). Tehát kell rá szánni némi id?t. De szerintem megéri.
A felvett el?adások egyébként letölthet?ek is, lehet offline is nézni. Továbbá elérhet? néhány hands-on-lab (HOL) leírás is.