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

Why Business Research Services are Important for your Business

Organizations doing systematic research about their target audience tend to grow faster as compared to their competitors who do not. Also, organizations conducting business research more frequently grow the fastest and are more profitable. Yes, it is indeed quite appealing. However, it is not as simple as it might look from a distance.

The first question that business owners face is regarding the type of research they should conduct and determining how is that particular research…


Posted by Alvaro Dee on May 13, 2016 at 9:48pm

List Building: Reach Out to the Target Audience and Boost Your Marketing Efforts

An accurate, relevant and up-to-date database is the bedrock of a successful email marketing campaign. So it is crucial to create and maintain correct and updated mailing lists that help in reaching out to potential customers and converting them into buyers, thereby generating…


Posted by Alvaro Dee on April 25, 2016 at 10:43pm

Scope of Data Entry from Images and their Range of Service

We all know that a document's image is valuable only when the information it contains is digitized and stored in a suitable format. Scanned images data entry calls for great amount of accuracy as inaccurate data can influence the entire database. Also, image data entry is a very tedious and time consuming process. Hence, it is best to take the help…


Posted by Alvaro Dee on March 30, 2016 at 9:30pm

Packt publishing releases "Advanced Oracle PL/SQL Developer Professional Guide-Second edition"

I am pleased to inform you all that Packt publishing has released the book "Advanced Oracle PL/SQL Developer Professional Guide-Second edition" after my second stint with them. This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this…


Posted by Saurabh K. Gupta on February 26, 2016 at 12:57am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service