Monday, December 15, 2008

RAC Diagnostics Script - racdiag.sql

Oracle Support provides several tools for RAC diagnostics.

One of them is racdiag.sql available through metalink Note: 135714.1 Script to Collect RAC Diagnostic Information (racdiag.sql)

This script is broken up into SQL statements that can be used individually. Each SQL statement adds information to help in debugging RAC hangs/severe performance scenerios.

The script provide the following information:

- INITIALIZATION PARAMETERS (Non Default)
- WAITING SESSIONS
- EVENT PARAMETER LOOKUP
- GES LOCK BLOCKERS
- GES LOCK WAITERS
- LOCAL ENQUEUES
- LATCH HOLDERS
- LATCH STATS
- No Wait Latches
- GLOBAL CACHE CR PERFORMANCE
- GLOBAL CACHE LOCK PERFORMANCE
- RESOURCE USAGE
- DLM TRAFFIC INFORMATION
- DLM MISC
- LOCK CONVERSION DETAIL
- TOP 10 WRITE PINGING/FUSION OBJECTS
- TOP 10 READ PINGING/FUSION OBJECTS
- TOP 10 FALSE PINGING OBJECTS
- TOP 10 WAIT EVENTS ON SYSTEM
- SESSION/PROCESS REFERENCE
- SYSTEM STATISTICS
- CURRENT SQL FOR WAITING SESSIONS
- WAITING SESSIONS
Oracle Support provides several tools for RAC diagnostics.




This script is broken up into different SQL statements that can be used individually. Each SQL statement adds information to help in debugging an RAC hang/severe performance scenerio.


The script provide the following information:


- WAITING SESSIONS

- EVENT PARAMETER LOOKUP

- GES LOCK BLOCKERS

- GES LOCK WAITERS

- LOCAL ENQUEUES

- LATCH HOLDERS

- LATCH STATS

- No Wait Latches

- GLOBAL CACHE CR PERFORMANCE

- GLOBAL CACHE LOCK PERFORMANCE

- RESOURCE USAGE

- DLM TRAFFIC INFORMATION

- DLM MISC

- LOCK CONVERSION DETAIL

- TOP 10 WRITE PINGING/FUSION OBJECTS

- TOP 10 READ PINGING/FUSION OBJECTS

- TOP 10 FALSE PINGING OBJECTS

- INITIALIZATION PARAMETERS

- TOP 10 WAIT EVENTS ON SYSTEM

- SESSION/PROCESS REFERENCE

- SYSTEM STATISTICS

- CURRENT SQL FOR WAITING SESSIONS

- WAITING SESSIONS:

Thursday, November 20, 2008

10 things Oracle Developers should never do

Oracle developer tips: Ten things you should never do

For the Oracle developer, customizing Oracle E-Business Suite applications can be very dangerous, especially if that Oracle developer is prone to making common rookie errors.

1. Don't run non-select commands in production without testing first

Occasionally developers need to run non-select commands on standard tables, such as an update on an insert. The consultant said developers should never do this without testing the commands first on DEV or Test Instance.

"Make sure it works, and then run it in production.

2. Never change the definition of a standard database object

"You never should have a need to change a standard table," . "If you change a standard table, it's definite that the next relevant Patch you apply is going to break the system."

Developers may need to change a standard package to customize an application. Folks that need to do that should begin by creating a new package.

"But if you do change a standard package, I would say that in a 1,000-line standard package if you add five lines, make sure you add clear comments before the five lines you have added".

3. Don't leave open update commands in code editors

When developers have an open update command sitting in the Toad editor, there is a risk of running that update unintentionally.

"Have only your Select commands open in an editor". "When you have an update, just comment it out. When you need to run it, just uncomment for that time only."

All data manipulation commands will have to be built as scripts and tested thoroughly by the time they are run in production.

4. Don't execute scripts in production by yourself

When developers are faced with the task of running something in a production instance, it's always good to ask a colleague to sit next to you and watch out for any mistakes. Two pairs of eyes are better than one.

5. Don't forget how to deal with commands that take a long time to execute, that any command expected to take more than five minutes to execute will need to be built as a concurrent program or run under the VNC editor.

"Don't run [time-consuming commands] on a Toad or a SQL*Plus session". "It's good to run it in the background."

6. Don't forget to protect passwords

It's important not to give out production passwords to anyone unauthorized in the company or outside the company.

7. Do not leave your desk when you have a connection open on production

Before leaving the desk, execute the script needed and close the connection immediately.
In addition to the obvious security concerns, leaving a connection open and unattended can cause developers to forget the context of the session when they return.

"You might come back and start typing in commands thinking that it's a development instance [when it's not]" .

8. Don't give out customer data

Never give the data (financial numbers, credit cards, customer list, etc.) to anyone other than the authorized client personnel, especially via e-mail.

9. Don't forget to maintain version control

Maintain a good version control for all your code and document at least the essential details about your programs.

"Don't let the production instance be the only source of version control".

10. Develop Prod-sensitive connections to third party interfaces

Oracle systems have live connectivity with third party systems like POS, 3PLs, payment systems etc.

"Make sure that these interfaces get inactivated when production databases are copied to other instances". "One way to do is to check for the SID name from the v$session table and inactivate the connection if it is not a production one."

Tuesday, March 4, 2008

Oracle Acquisitions - Interesting

Oracle Acquisitions - What Oracle making out of all this?
The following acquistions by oracle is not for monopoly but for making the oracle grid and Oracle Cloud technology the best in the market. Read the following for the acquisitions and what reason behind each.

Reference: http://www.oracle.com/us/corporate/acquisitions/index.html

ACQUISITIONS 2008
Tacit Software November—The addition of Tacit Software's expertise location technology is expected to enhance Oracle Beehive.
Advanced Visual Technology (AVT) October—The combination of AVT products and Oracle Retail provides a comprehensive space planning and optimization solution that is expected to maximize profitability of one of the retail industry's most valuable assets—their retail store space.
Haley October—The combination of Oracle and Haley is expected to expand Oracle's offerings for social services, as well as add enterprise policy automation for other legislated and regulated industries.
Primavera October—The combination of Oracle and Primavera is expected to create the first, comprehensive Enterprise Project Portfolio Management solution for project-intensive industries.
ClearApp September—The combination of ClearApp products and Oracle Enterprise Manager is expected to provide customers with a comprehensive application management solution providing enhanced service levels, reduced system down-time and improved return on SOA investments.
Global Knowledge Software (GKS) July—The combination of Oracle and GKS is intended to provide customers a comprehensive, end-to-end enterprise solution for creating and deploying business process documentation, interactive system training and just-in-time support available within their Oracle and non-Oracle applications.
Skywire Software June—The acquisition of Skywire Software accelerates Oracle's formation of the most modern and complete software suite for the insurance industry and expands content management capabilities.
AdminServer May—The combination of Oracle and AdminServer is expected to result in the most modern, comprehensive, standards-based and well-integrated enterprise software suite for the insurance industry.
Empirix March—The acquisition of e-TEST suite is expected to strengthen Oracle Enterprise Manager with application load and functional testing technology.

BEA January—The addition of BEA is expected to accelerate innovation by bringing together two companies with a common vision of a modern service-oriented architecture (SOA) infrastructure.

Captovation January—With the addition of Captovation, Oracle expects to extend its comprehensive and integrated solution for Enterprise Content Management with transactional content processing.
ACQUISITIONS 2007
Agile
May—The combination of Oracle and Agile will create a best-in-class, integrated enterprise-wide PLM solution.
AppForge April—Oracle's acquisition of the intellectual property assets of AppForge extends Oracle's mobile applications product strategy.

Bharosa July—The combination of Oracle and Bharosa will deliver the next generation of adaptive, risk-based access management.

Bridgestream September—The addition of Bridgestream extends Oracle's Identity Management Suite with automated enterprise role management.

Hyperion March—The combination of Oracle and Hyperion will deliver the most complete, integrated end-to-end enterprise performance management system.
Interlace Systems October—The combination of Interlace Systems' technology and Oracle's Enterprise Performance Management (EPM) System is expected to enable fast and collaborative decision making by integrating functional operational and financial planning systems.
LODESTAR April—With the addition of LODESTAR, Oracle extends its Oracle Utilities applications suite with the addition of leading meter data management and energy operation solutions.

LogicalApps October—Oracle's acquisition of LogicalApps will strengthen its GRC application suite by integrating real-time policy enforcement for critical business processes.

Moniforce December—The combination of Oracle and Moniforce is expected to strengthen Oracle Enterprise Manager application performance management capabilities with real end-user monitoring.

Netsure Telecom Limited September—The acquisition of Netsure extends the Oracle Communications application product suite to include business intelligence and analytics for the network domain.

Tangosol March—The combination of Oracle and Tangosol will create the first integrated platform that enables extreme transaction processing.
ACQUISITIONS 2006
360Commerce January—The combination of Oracle and 360Commerce brings together the best merchandising, supply chain, and optimization solutions, from the enterprise to the store.
Demantra June—The combination of Oracle and Demantra sets the new standard in today's demand-driven planning solutions.

HotSip February—With the addition of HotSip, Oracle will build on its leadership in middleware and in carrier-grade communications infrastructures.
MetaSolv Software October—The combination of Oracle and MetaSolv Software will deliver a leading end-to-end packaged software solution addressing the key business processes of the communications industry.
Net4Call April—Oracle plans to continue to support and develop Net4Call's products within its new roadmap for a comprehensive, standards-based Service Delivery Platform (SDP) for the telecommunications industry.

Portal Software April—The combination of Oracle and Portal Software will deliver the first end-to-end packaged enterprise software suite for the communications industry.

Siebel January—Siebel CRM, Oracle ERP, Oracle Fusion Middleware, and Oracle 10g Database combine to form a complete, world-class set of customer-centric, information age applications. Together we are a stronger, more strategic partner, with complementary resources and maximum deployment flexibility.
Sigma Dynamics August—With the asset purchase of Sigma Dynamics technology, and in combination with Oracle Business Intelligence Suite and Oracle Fusion Middleware, businesses will be able to leverage the insight contained in both historical and real-time data sources to drive better decisions in practically any situation.
Sleepycat February—With its acquisition of Sleepycat, a privately held supplier of open source database software for developers of embedded applications, Oracle now offers a broader range of embedded database technologies for customers.
SPL WorldGroup November—The combination of Oracle and SPL will deliver the most complete, integrated end-to-end packaged solution to meet the unique needs of the utilities industry.
Stellent November—The combination of Oracle and Stellent will complement and extend Oracle's existing content management solution portfolio.
Sunopsis October—With the addition of Sunopsis, Oracle expands Oracle Fusion Middleware with high-performance, next-generation data integration capabilities.
Telephony Work June—With its acquistion of Telephony@Work, Oracle will become the first CRM applications provider to unify IP-based contact center technology and CRM software to deliver a complete "customer to agent" experience.

ACQUISITIONS 2005
Context Media
July—Oracle's acquistion of certain assets of Context Media, a leading provider of enterprise content integration (ECI) software, will extend Oracle Fusion Middleware and complement the enterprise content management (ECM) capabilities in Oracle Collaboration Suite.
G-Log September—With the acquisition of G-Log, Oracle plans to offer customers the first complete, information-driven Logistics Hub solution for global supply chain and logistics management.
i-flex August—Oracle's commitment to the business-critical functions of the banking industry is the foundation of the Oracle/i-flex agreement. By aligning the talents of both organizations, we will be better able to address the evolving needs of the banking industry.
Innobase October—With the acquisition of Innobase, a developer of discrete transactional open source database technology, InnoDB, Oracle plans to increase support for open source software.
Oblix March—The strength of Oblix's leading identity management solutions combined with Oracle's worldwide software and services business will give customers an unprecedented ability to build identity into their software infrastructure and applications.
OctetString November—The combination of Oracle and OctetString brings the industry's leading virtual directory solution into a suite of best-in-class identity and access management offerings.
PeopleSoft January—The combination of Oracle and PeopleSoft brings together the best and brightest talent in the enterprise software industry. We plan to accelerate innovation and offer customers a superior solution at a lower price.
ProfitLogic July—The combination of Oracle, ProfitLogic, and Retek will create the retail industry's most comprehesive software solution, helping create tightly integrated, customer- insight-driven retail enterprises.
Retek April—The combination of Oracle and Retek will provide a comprehensive retail solution that includes back-office functionality for finance and human resources and extends to planning, merchandising, supply chain, and retail channels.
TempoSoft December—With the acquisition of the former TempoSoft Workforce Management application and related intellectual property, Oracle offers customers a complete suite for managing time and labor, absences, and scheduling to meet a forecasted workload demand.
Thor Technologies November—The combination of Oracle and Thor brings the industry's leading enterprise-wide user provisioning solution into a suite of best-in-class identity and access management offerings.
TimesTen June—The combination of Oracle and TimesTen will provide the products, expertise and resources to satisfy the growing demands of real-time industries and the evolution of the Real-Time Enterprise.
TripleHop June—Oracle's acquisition of certain assets of TripleHop Technologies, Inc., a provider of context-sensitive enterprise search products and technology, will extend Oracle's development of comprehensive enterprise search.

For all the acquisitions visit the below links,
http://www.oracle.com/us/corporate/acquisitions/index.html
http://en.wikipedia.org/wiki/List_of_acquisitions_by_Oracle