March 2009 Blog Posts (20)

We Now have a nice DBA 2.0 community

To all who have joined the community I hope you have had occasions to post questions to others in the community. My purpose in creating this was to create a specific forum and meetinplace for those Oracle DBAs who have or wish to attain or improve their skills in OS, storage and networks. Whilst Harald van Bfreederode and myself continue to blog on our own blogs the Message of DBA 2.0 skills is still very important. Please help us all by sharing ideas and knowledge for members of this… Continue

Added by Joel Goodman on March 31, 2009 at 10:17am — 5 Comments

Start & Stop 11i Process Details

ORACLE_HOME/appsutil/scripts - start or stop the database - start or stop the database listener

COMMON_TOP/admin/scripts - start or stop the APPS listener - start or stop the Apache web listener - start or stop the concurrent manager - start or stop Forms Metrics Server - start or stop Forms Metrics Server - start or stop the forms server -… Continue

Added by Jiltin on March 31, 2009 at 7:36am — No Comments

How to Verify a Patch applied? Handy SQL

Just run this sample sql changing the patch number (3061831) in sqlplus or Toad.

SELECT DISTINCT rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4)


ad_bugs a,

ad_patch_run_bugs b,

ad_patch_runs c,

ad_patch_drivers d,

ad_applied_patches e

WHERE a.bug_id = b.bug_id

AND b.patch_run_id = c.patch_run_id

AND c.patch_driver_id = d.patch_driver_id

AND d.applied_patch_id =… Continue

Added by Jiltin on March 31, 2009 at 7:30am — No Comments

How do you check the profile option values using sql - Oracle Applications?

How do you check the profile option values using sql - Oracle Applications? -> profile option values

Profile Options provide flexibility to Oracle Apps. They are a key component of Oracle Applications, hence these much be understood properly. I will be taking multiple examples here to explain what profile options mean. I will also try to explain by stepping into Oracle shoes “How will you design a program that is flexible”, by using Profile… Continue

Added by Jiltin on March 30, 2009 at 8:00am — No Comments

List of Reposibilities for an user - Handy sql reference

I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities.

Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql.

SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id


fnd_user_resp_groups furg,


fnd_responsibility_tl… Continue

Added by Jiltin on March 24, 2009 at 8:00am — No Comments

Two new(ish) blog posts: EBS log files and still more EBS and Grid Control

Whose log file is it, anyway?

I wrote a quick and dirty script to query FND_PROFILE tables to get information about a log file I found on an E-Business Suite app tier. Not particularly revolutionary, but on the off-chance that it helps someone, I'm sharing.

More fun with Grid Control and EBS

After two months of… Continue

Added by John Piwowar on March 23, 2009 at 7:44am — No Comments

Blog'n courtesy - provide print.css

This is just a thought about making our information more accessible. I've adopted a print.css on my main blog to expand all content on an entry and strip unnecessary header, footer, and sidebar information.

Aside from the striping the useless page stuff, a print.css let me unfold all my entries. This was important since I adopted JQuery folding on the pages based on feedback from readers. The folding forces me to reflect a bit more before I post something and hopefully avoids… Continue

Added by Michael McLaughlin on March 22, 2009 at 8:06am — No Comments

Pipelined Table Functions Examples

When I presented the concept at the Utah Oracle User’s Group (UTOUG) Training Days 3/12-3/13/2009 it became clear the community could benefit from more detail about table and pipelined table functions. I updated my old entry, more or less rewrote it entirely, now there's a 16 page post. Hope you enjoy it.

Also, about a month or so ago I began tweeting. You can find me at MacLochlainn… Continue

Added by Michael McLaughlin on March 22, 2009 at 7:47am — No Comments

Enterprise Data Auditing

Securing sensitive data in database environments is only one piece of the compliance puzzle. Ensuring that you are alerted when unusual activity is occurring and keeping a secure and searchable audit log of database changes is critical to maintaining compliance with regulatory requirements as well as ensuring adherence to corporate information governance policies. Database audit tools allow enterprises to mitigate security risks with real-time… Continue

Added by lorryins on March 17, 2009 at 9:53pm — No Comments

Migration methodology with measurable performance milestones

The need for migration of applications in enterprises arises from changes in business demands or technology challenges to improve operational efficiency and to manage risk. Addressing the growing need of enterprise application networks to migrate data across applications, protocols and proprietary data structures; enterprise data migration solution enables seamless data migration across enterprise applications.

Maintaining… Continue

Added by lorryins on March 17, 2009 at 9:40pm — No Comments

Architect Survey

In the interest of learning more about the architect community within the larger Oracle community, I've created a short survey on Survey Monkey.

Click Here to take survey

You'll notice that there's not a single question about what Oracle products you use, or when your company plans to make a purchase. I don't ask for your email address or telephone number, or anything more specific than city,… Continue

Added by Bob Rhubart on March 16, 2009 at 4:56am — No Comments

Hint parallel

This time the subject is how Oracle evaluates NOT EXISTS and NOT IN clauses and hints that influence anti-join query optimization.

Below query had no respond for hours before I started to work on it, two table have some 100 millions of rows in this example;

-- original query

SELECT /*+ parallel (q1,16) */ count(*)

FROM party PARTITION(party_01) q1

WHERE party_id NOT IN (SELECT /*+ hash_aj */ party_id

FROM party_new… Continue

Added by Hossein Heidarpour on March 13, 2009 at 7:20am — No Comments

Data Privacy Pack for Oracle E-Business Suite

Data in production systems use highly available redundant Tier 1 storage systems. Enterprise data archiving is a proven strategy to relocate data to less expensive Tier 2 storage, reducing the need to continuously add to storage to production systems. Most experts conclude up to 80% of production data is no longer mission critical. Using data archiving reduces overall storage costs while maintaining access through the native… Continue

Added by lorryins on March 10, 2009 at 5:12am — No Comments

Application performance for improvement of business

Enterprise class business applications require multiple copies be made to support test data management processes such as patch, test, QA, and training. Most companies make 6-8 full size clones for every production application, not only wasting storage and time in cloning but potentially exposing sensitive application data to the test environment. Data masking provides companies with a centralized solution to manage the test data… Continue

Added by lorryins on March 10, 2009 at 5:08am — No Comments

Change VIP (2)

4. Verify the correct interface subnet is in use by re-running oifcfg with the 'getif' option:

% $ORA_CRS_HOME/bin/oifcfg getif

eth0 global public

eth1 global cluster_interconnect

Notes for Windows Systems

The syntax for changing the interfaces on Windows/RAC clusters is the same as on Unix or Linux, but the interface names will be slightly different. On Windows systems, the default names assigned to the interfaces are generally… Continue

Added by Hossein Heidarpour on March 9, 2009 at 5:03am — No Comments

Change VIP


Applies to:

Oracle Server - Enterprise Edition - Version:

Information in this document applies to any platform.



The purpose of this note is to describe how to change or update the interconnect and/or public interface IP that is stored in the OCR. This may be necessary if there is a network change affecting the servers, or if the original information that was input during the installation was incorrect. It may also be the case that for… Continue

Added by Hossein Heidarpour on March 9, 2009 at 5:00am — No Comments

Data Management Solutions for Telecom

The wireless technology, the Internet, the convergence of data, voice and media and industry consolidations driven by mergers and acquisitions has led to a major metamorphosis in the telecom industry in the last fifteen years. This resulted in a number of challenges for the telecommunication industry like declining revenue, customer churn and growth in regulatory requirements.

Due to millions of subscribers and massive operations, data… Continue

Added by lorryins on March 5, 2009 at 12:39am — No Comments

Data Management Solutions for Large Enterprises

Enterprise data management solutions are ideal for large enterprise companies that manage voluminous business critical data. Data management tools enable companies to more efficiently classify, manage and secure applications, maintain information governance, implement tiered storage strategies and consolidate data.

Data management solutions provide organizations with the tools to mitigate risk, reduce storage costs, enforce consistent security… Continue

Added by lorryins on March 5, 2009 at 12:30am — No Comments

Newly certified Oracle Demantra consultant looking for first gig.

Newly certified in Oracle Demantra Demand planning product. I'm looking for an opportunity here in the US. If you are looking for a eager and qualified candidate please send me your requirements.
Thank you.

Added by Gary Salvadore on March 4, 2009 at 8:09am — No Comments

Date dimension with one SQL statement



n AS Date_ID,

TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day') AS Full_Date,

TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'DD') AS Days,

TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'Mon') AS Month_Short,

TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'MM') AS Month_Num,

TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') +… Continue

Added by uli on March 1, 2009 at 1:15am — No Comments

Monthly Archives










Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Apple Opens Its First iOS App Development Centre in Italy

Apple aims at making things rounder and sleeker. With iPhone 7 out in the field, Apple is now investing its time and resources in organizing workshops and opening new iOS app development centers to educate people in advanced methods of iOS app building.

Apple’s highlight of the year? It’s first-ever iOS development Centre in Naples!…


Posted by Alvaro Dee on October 20, 2016 at 12:33am

Outsource Your Data Conversion Services to Get an Edge over Your Competitors

The process of converting data from one standard format to any desired file format, Data conversion makes the data more precise, convenient, and retrievable, while keeping the core data unchanged. The precious asset to an organization, data helps in effective decision making if digitized, organized, and managed properly. Whereas the inefficient management of data makes it a burden on the business enterprise.

If the data is structured and digitized efficiently, it can help in achieving…


Posted by Alvaro Dee on October 19, 2016 at 5:54am

Data Mining Can Help Your Business Get a Competitive Edge

Data mining services are a vital part of business growth. Data mining, sometimes referred as knowledge discovery in databases, is the process of digging through data to discover hidden connections, patterns, and anomalies so that future trends can be predicted. The mined data can help businesses in cutting costs, increasing revenues, reducing risks, improving customer relationships, and more.

The diversity and volume of data that is being captured by companies today is staggering. The…


Posted by Alvaro Dee on September 29, 2016 at 2:17am

7 Benefits of Amazon Product Data Entry Services

An Optimized Creation, Processing and Maintenance of your Amazon Products’ E-catalog Gives you an Edge in the Competitive eCommerce Market.

When you upload your inventory on one of the world’s biggest online marketplaces, what strategy do you employ to survive the competition put forth by popular brands? You optimize your listings to enhance the discoverability of the product. Amazon Product data entry services ensures your product is available in the virtual…


Posted by Alvaro Dee on September 6, 2016 at 3:08am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service