Submitted by rajeevkdba on Tue, 2011-11-15 00:38
Oracle 220.127.116.11, the second patch set for the 11gR2 database, is now certified with with E-Business Suite and is available for download in 32 and 64-bit.
You can download it from only your meta link account credential.
Patch No: 10404530
Oracle E-Business Suite Release 11i
* 18.104.22.168 + ATG PF.H RUP 6 and higher
Submitted by treacyjane on Mon, 2011-11-14 05:31
EPractize Labs Software, an emerging global provider for Java Certification Preparation released world’s first exam study guide (Training Lab) for Oracle Certified Associate, Java SE 7 Programmer certification. Download your FREE copy today and empower your preparation.
Oracle offers variety of Java Certifications for all Java Editions (Java SE, Java EE and Java ME). Oracle Certified Associate, Java SE 7 Programmer certification provides basic knowledge required to develop a Java application.
What is EPractize Labs Java SE 7 OCA Training Lab?
Submitted by John Watson on Mon, 2011-11-07 08:46
Why do you sometimes not get partitionwise joins? Because the optimizer isn't clever enough. Reference partitioning has many benefits, one of which is that the optimizer understands it. You will always get a partitionwise join if your tables are reference partitioned.
Submitted by treacyjane on Thu, 2011-10-20 02:34
Oracle offers variety of Java Certifications for all Java Editions (Java SE, Java EE and Java ME). Oracle Certified Expert, Java Platform, Enterprise Edition 6 Enterprise JavaBeans Developer (Formerly Sun Certified EJB Developer for the Java EE6 Platform (SCEJBD 6)) certification provides knowledge required to develop Java EE 6 Enterprise applications using EJB.
What exam I need to pass to achieve OCE for Java EE 6 EJB Developer Certification?
Submitted by David Lozano Lucas on Fri, 2011-10-07 09:12
When we launch a long operation, such as a RMAN backup or rebuild of a large index, we can come to despair of not having an estimate of the time it may take. We can even come to think that is doing nothing.
For the progress of a long operation we can query the view V$SESSION_LONGOPS, first obtaining the process ID from V$SESSION. In the case of DBA, we know exactly which user is rebuilding the index, so we can simplify it into a single query.
Submitted by John Watson on Sun, 2011-09-18 11:14
Several times I have had to deal with people who do not want to define constraints. I have never understood why they don't, because my experience is that the more constraints you can define, the better Oracle will perform. If anyone knows where the idea that not defining constraints is a Good Thing comes from, I would be interested to know.
Following are two very simple examples of constraints allowing the optimizer to develop better plans.
Submitted by saibalguha on Wed, 2011-09-07 05:12
One of the great features about partitioning, and most specifically range-based partitioning, is the ability to load data quickly and easily with minimal impact on the current users using:
alter table call exchange partition data_2007 with table call_temp;
Submitted by subrata.dass on Tue, 2011-08-23 04:42
Star Transformation in Siebel Analytics (OBIEE)
Star Transformation is a join method mostly used in Data Warehousing Environments to fine tune typical query performance. It is of utmost importance in DB environments where reporting tools like Siebel Analytics (OBIEE) is in use. It can also be used for other tools such as Business Objects. The conventional join mechanisms that the star transformation seeks to supersede are Hash join, nested-loops and sort merge join.
Submitted by zahid9999 on Thu, 2011-08-11 04:31
In this article I will tell you how you can make a dynamic List of values in oracle forms builder, most developer use many techniques to make List of values. I will tell you a simple and very suitable method for making List item dynamically.
You can use this code in NEW-FORM-INSTANCE
Submitted by satishbabugunukula on Tue, 2011-08-02 20:26
This post is to discuss about the Best Practices that was followed in implementing a new Self Service Applications using OA Framework.
A College needed a web based enrollment system for its students to enroll online without needing to fill up a paper. This was designed for a new i-module for Student Enrolment was developed in OA Framework, using jDeveloper,Rapid Application Development Environment. The benefits of the RAD environment and OA Framework Technology was well utilized to meet the deadlines.
The main challenges faced by the project were , I identification of a roadmap to transform existing system and there was no proper oracle documentation on how to develop a transaction page in OA Framework.