August 2011 Blog Posts (31)

Online IT Training / e - Learning Courses of SAP, BA, Java, Oracle, QA, Data Warehousing, .net, QTP, SAS etc @ Crescent IT Solutions

Crescent IT Solutions which is a high profiled Training Institute offers you SAP(All Modules),…
Continue

Added by Crescent IT Solutions on August 11, 2011 at 8:53pm — No Comments

11gR2; Silent installation in Oracle Solaris 10

1- Introduction:

In this step by step document, I am going to show you how to install Oracle 11gR2 (11.2.0.1) using the silent technique.

This document makes easier the installation; you should only change the directories to reflect your environment setup.

 

2- Prepare the environment;

In this section, we are going to prepare the system users and groups as well as the system parameters.

Create the dba group:…

Continue

Added by Wissem EL KHLIFI on August 11, 2011 at 1:58pm — No Comments

commit for update statements of base table a materialized view taking more time : help required asap

We are  using the following materialized view on trans@dev

 

***********************************************************

 

CREATE MATERIALIZED VIEW int_recon_mat_view( COUNTRY,

BRANCH, ACCOUNT_CCY, ACCOUNT_ID, ACCOUNT_NAME,

CATEGORY, APA_CODE, BATCH_NUMBER, DR_CR_IND,

HOST_SYSTEM_ID, HOST_TXN_CODE, LEDGER_DATE, LOCAL_CCY_LEDGER_AMOUNT,

ORIG_CCY_LEDGER_AMOUNT, TICKET_NUMBER, VALUE_DATE, CONTRACT_TYPE,

RECON_REFERENCE,…

Continue

Added by Murali Mohan on August 10, 2011 at 6:05am — 3 Comments

Testing RAC Check audit tool

Post written in 3 languages: English, French and Spanish.

 

Introduction:

RACcheck is a tool developed by Oracle to audit your RAC and clusterware configurations.

It gives suggestions and advices to modify your RAC Configuration to fit the Oracle best practices.

This tool checks the settings of the following configurations;

– OS kernel parameters, OS packages and OS settings

– CRS/Grid Infrastructure

– RDBMS ; memory and…

Continue

Added by Wissem EL KHLIFI on August 8, 2011 at 5:30am — 1 Comment

Interview with Debra Lilley – Oracle ACE Director and UKOUG President

Debra Lilley is Oracle Alliance Director for Fujitsu, she has worked with Oracle applications since 1996 (EBS 9.4.1) as Support Manager, Functional Consultant, Discoverer and then BI lead. Her role is now about strategy and education of both Fujitsu people and customers. She is President of UKOUG and Chairman of the Product Development Committee at the IOUC. She was User Group Evangelist of the Year in 2008.…

Continue

Added by Wissem EL KHLIFI on August 8, 2011 at 4:19am — 1 Comment

Monitoring Microsoft SQL Server using Enterprise Manager Grid Control

The Enterprise Manager offers several system monitoring plug-ins for third-party products. One of them is Microsoft SQL Server Plug-in. This plug-in supports Standard, Enterprise, and Workgroup editions of Microsoft SQL Server 2000, Microsoft SQL Server 2005, and Microsoft SQL Server 2008 (both 32 and 64bits).

 

I've wrote about how to monitor SQL Server using EM Grid Control. Read more: http://bit.ly/rnuYWK

 

 

Added by Gökhan Atıl on August 7, 2011 at 2:35pm — No Comments

Oracle DUL (Data UnLoader) //Life is DUL without it

When there is no other option to recover database, there is a great oracle internal program which naame is Oracle DUL (…

Continue

Added by Bugra Canbakal on August 7, 2011 at 2:30pm — No Comments

Interview with Eddie Awad – Oracle ACE Director and Oracle Expert

Eddie was introduced to Oracle in 1994. Since then, he has been developing software applications using Oracle databases and tools. In addition to his blog (http://awads.net/wp/) in which he shares his Oracle related experiences, news, views, tips and tricks, Eddie created the Oracle News Aggregator (http://orana.info/), a site that allows readers to monitor Oracle related blogs and news sources,… Continue

Added by Wissem EL KHLIFI on August 3, 2011 at 10:00am — No Comments

11gR2; Automatic restart of DB Console

I have written this article, in 3 different languages: English, Spanish and French.

 

Extract en English;

 

Introduction:

 

Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources.

Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts.

These components can be…

Continue

Added by Wissem EL KHLIFI on August 2, 2011 at 4:19am — No Comments

Interview with Kyle Hailey – Oracle ACE and Oracle Expert

Kyle Hailey has worked in the IT industry for 15 years and has been with Oracle for over 13 years. At Oracle he has worked in support, porting, benchmarking, and kernel development and has created tools to improve high-end performance monitoring such as direct SGA attach and interactive graphic displays of performance data. He has made major contributions to the redesign of the Oracle Enterprise Manager 10g by designing performance pages to be graphically oriented and wait-interface centric.… Continue

Added by Wissem EL KHLIFI on August 1, 2011 at 12:18am — No Comments

Blog Topics by Tags

Monthly Archives

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. 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

Badge

Loading…

Blog Posts

Verify and Fix Corruption in Oracle Databases, Efficiently

Oracle database system stores massive amounts of data, aiming for secure data storage and management. With a number of predefined queries, this database system lets you insert and retrieve data that is stored in multiple tables inside it. For smoother functioning of a database system and its respective databases, your machine must be free of every single issue that is supposed to cause adverse effects on the data. For…

Continue

Posted by Mark Willium on June 3, 2014 at 11:00pm

esProc Enables Oracle JDBC to Speed Up Retrieve Process

Recently, a performance issue occurs in a big detail report, where the original data volume in the two data tables as it involves has exceeded 3 million rows; the data volume that the report can retrieve after filtering remains at round 2 million rows. As we expected before, by using paged retrieve method, this report would present a much higher performance. However, for the fact that the user also needs to…

Continue

Posted by Jim King on May 29, 2014 at 7:00am

Oracle DBaaS in Private Database Cloud workshop

Designing Database as a Service (DBaaS) in own Database Cloud is very comprehensive topic and it requires a lot of things: clear concept and strategy, solid planning, important architecture decisions, considerable involvement of different stakeholders, extra budget, etc. To start talking about this topic I’ll give my own definition of DBaaS which is a managed database service, hosted and offered by DBaaS provider on pay-per-usage basis, which provides access to own database resource with…

Continue

Posted by Kirill Loifman on May 5, 2014 at 12:37am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service