March 2010 Blog Posts (13)

Retrieve SQL and Execution Plan from AWR Snapshots

A handy little script that queries the AWR Snapshots for
SQL statements and sorts them by elapsed time:

Added by Uwe Hesse on March 29, 2010 at 12:08am — No Comments

Oracle 10gR2 RAC Installation in RedHat 5 Linux Using VMware Server2

for more information and reference
please visit:

for more information and reference
please visit:

for more information and reference
please visit:

Added by Rajeshkumar Govindarajan on March 25, 2010 at 11:30pm — 2 Comments

Monitoring Alert & Delivery messages in EM grid control

1. Alert message (Warning, Critical)
2. Delivery messages
3. Delivery status

: Tested in EM grid control and Oracle 11g Release 1.

Added by Henry CHO on March 25, 2010 at 6:30pm — No Comments

Oracle Database HA Architecture Overview

Added that page to my Blog because the topic is frequently asked:

Added by Uwe Hesse on March 25, 2010 at 12:47am — No Comments

Monitoring Active Dataguard

1. monitoring processes about dataguard.
2. what is the lasted archived logfiles.
3. apply finish time and lags

Added by Henry CHO on March 23, 2010 at 4:00am — No Comments

iWare Logic becomes Oracle Gold Partner

Pune, India, March 2010.

We at iWare Logic are proud to announce our Gold partnership with Oracle, which allows us to offer the full spectrum of Oracle Products.

This strengthening of cooperation with Oracle has been enabled by continually improving competencies of iWare Logic’s endurance; the awarded status of Gold partnership will allow expanding the range of services offered to a large extent.…


Added by abhishek sharma on March 22, 2010 at 5:02am — No Comments


Step by step process of putting a RAC database in archive log mode and then enabling the flashback Database option.

Enabling archive log in RAC Database:

A database must be in archivelog mode before enabling flashback.

In this example database name is test and instances name are test1 and test2.

step… Continue

Added by Rajeshkumar Govindarajan on March 18, 2010 at 12:00am — No Comments

bad bind variable error in oracle 10g forms

how can retrive an image from the oracle database 10g through a select statement from front-end oracle 10g forms.

i have already created a table name myimage

with two columns one is image_id number

and another one is image_name blob

but my problem is that when i am going to write insert or select statements

for example


select image_name into…


Added by Kalpataru Rath on March 16, 2010 at 10:25am — No Comments

flashback table

Added by Henry CHO on March 14, 2010 at 5:45pm — No Comments

Knowledge sharing site


Check this knowledge sharing site "ORACLE RAC EXPERT"


Added by Satishbabu Gunukula on March 10, 2010 at 12:02pm — 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

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…


Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…


Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…


Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…


Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service