The social network for Oracle people

Wissem EL KHLIFI Male Barcelona Spain: Share on Facebook

Share Twitter

Blog Posts (60)
Discussions
Events
Groups
Featured Photos (1)
Photo Albums
Featured Videos

Wissem EL KHLIFI's Apps (1)

Wissem EL KHLIFI's Friends

View All

Gifts Received

Wissem EL KHLIFI has not received any gifts yet

Give a Gift

Wissem EL KHLIFI's Page

Latest Activity

Wissem EL KHLIFI posted a blog post

My experience with ORA-07445: exception encountered: core dump [kglic0()+1086]

Introduction:Oracle defines the ORA-7445 as an unhandled exception error that could be result of an Oracle bug. The ORA-7445 errors depend on the version of the Oracle software, OS version. For more details about the error, you need to check the trace files generated. The ORA-7445 exception generates a trace file located under the CORE_DUMP_DEST directory for oracle versions prior to 11g and under the ADR Home / cdump (Automatic Diagnostic Repository) for 11g versions. This article is not…See More

Apr 22

0 Comments

Wissem EL KHLIFI posted blog posts

Feb 4

Wissem EL KHLIFI updated their profile

Feb 3

Wissem EL KHLIFI shared their blog post on Twitter

CBO unnests subqueries

Feb 3

Wissem EL KHLIFI posted a blog post

Troubeshooting Oracle Backup to Tape Problem;

Problem:We realized Oracle RMAN Backups to Tape for small and big databases are waiting for days and showing running status in V$RMAN_BACKUP_JOB_DETAILS. RMAN backup job logs are stopped to show tape channels allocation which indicates tape backup issue not disk.Troubleshoot the issue:Oracle provides a diagnostic tool named “sbttest”. This utlity test media management software by attempting to communicate with the media manager just like the Oracle Database.Read the complete post here:…See More

Jan 18

0 Comments

Wissem EL KHLIFI posted a blog post

Export Table statistics from one user to another

Introduction:This article describes how to export / import table statistics from one user to another. The goal is to import table statistics of the user wissem to a user wiss. The table conserned is named W_WRKFC_EVT_FS. Both users are in the same database. In the case of the users are created in different databases, the same steps can be used by using export/import datapump instead of create the table statistics using CTAS (Create Table As Select).Please find the complete article here:…See More

Dec 13, 2012

0 Comments

Wissem EL KHLIFI posted a blog post

11g; Sql Plan Management

Introduction:This article describes how to manage optimal SQL execution plans using SQL plan management. SQL plan management preserves efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc …). SQL plan management (SPM) is a proactive way to guarantee stable performance when system changes.This article…See More

Dec 3, 2012

0 Comments

Eddie Awad liked Wissem EL KHLIFI's blog post 11gR2; Troubleshooting OHAS error – autorun file for ohasd is missing

Oct 28, 2012

Eddie Awad liked Wissem EL KHLIFI's blog post Troubleshooting ASM error – ORA-15063: ASM discovered an insufficient number of disks for diskgroup

Oct 28, 2012

Wissem EL KHLIFI posted blog posts

Oct 27, 2012

Saikat Banerjee is attending Wissem EL KHLIFI's event

try my Oracle education website ; www.oracle-class.com at online

January 28, 2011 at 6pm to January 31, 2013 at 7pm

Hello,I am happy to announce you that I just finished my new website: http://www.oracle-class.comFeel free to visit and find a variety of useful Oracle resources such as:Video Tutorials on topics such as general database administration in 10g and 11g, RMAN backup and recovery,database performance, dataguard, Real Application Clusters, PL SQL programming, Oracle Certifications (OCA and OCP), Secure Oracle databases.Articles on various…See More

Oct 18, 2012

0 Comments

Eddie Awad liked Wissem EL KHLIFI's blog post Reallocate Enterprise Manager 11g Master Node in RAC 11gR2 ;

Sep 7, 2012

Wissem EL KHLIFI posted a blog post

Reallocate Enterprise Manager 11g Master Node in RAC 11gR2 ;

In this post, I am going to show you how to reconfigure the DB Console master node to a new existing node in the cluster. This is a 3 node Real Application Clusters environment. We are using Enterprise manager db console 11g to monitor the 3 nodes RAC as opposed to Oracle Enterprise Manager grid control or EM cloud Control.First of all, you need to check the actual configuration; the following output is showing ca25db01 is the actual master enterprise manager node, and only the Enterprise…See More

Sep 7, 2012

0 Comments

Thoa liked Wissem EL KHLIFI's blog post Auto Restart Enterprise Manager Cloud Control Agent 12c;

Jul 11, 2012

Wissem EL KHLIFI posted a blog post

11gR2; RAC + Clusterware Silent Installation

I have received many e-mails asking for examples of how to install the clusterware and the RAC database using the silent method. In this post I am going to show you how to perform the silent installation of an 11.2.0.2.0 clusterware and RAC database in Linux based system.The steps below were performed on an RAC one host, composed of one node only, but, the same commands can be performed on N nodes without problems.1- Prerequisites:Before clusterware installation, you have to prepare the servers…See More

May 31, 2012

0 Comments

Wissem EL KHLIFI posted a blog post

Auto Restart Enterprise Manager Cloud Control Agent 12c;

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 easily added to the Oracle Restart using the crsctl add command.In this article, I am going to show you how to add the Enterprise Manager Agent 12c component to the Oracle Restart.The…See More

Mar 5, 2012

0 Comments

Profile Information

About Me:: A Computer Science Engineer / Oracle ACE / Oracle OCP / Oracle DBA / Oracle App DBA / Oracle Developer / Linux Admin /Java Developer ...

My Website:: http://oracle-class.com

Wissem EL KHLIFI's Photos

Loading…

Wissem EL KHLIFI's Blog

My experience with ORA-07445: exception encountered: core dump [kglic0()+1086]

Introduction:

Oracle defines the ORA-7445 as an unhandled exception error that could be result of an Oracle bug. The ORA-7445 errors depend on the version of the Oracle software, OS version.

For more details about the error, you need to check the trace files generated. The ORA-7445 exception generates a trace file located under the CORE_DUMP_DEST directory for oracle versions prior to 11g and under the ADR Home / cdump (Automatic Diagnostic Repository) for 11g…

Continue

Posted on April 22, 2013 at 1:54pm

Incremental updated backup failed after database restore.

Find the complete post here:

http://www.oracle-class.com

@orawiss

Posted on February 4, 2013 at 1:54am

CBO unnests subqueries

Problem:
In production database with exact version 11.2.3.0, a single execution of the query took about 3.7 minutes to run (144 executions), lately, one execution takes 20 minutes.
Find complete post here: http://www.oracle-class.com/?p=2754

@orawiss

Posted on February 3, 2013 at 3:05am

Troubeshooting Oracle Backup to Tape Problem;

Problem:

We realized Oracle RMAN Backups to Tape for small and big databases are waiting for days and showing running status in V$RMAN_BACKUP_JOB_DETAILS.

RMAN backup job logs are stopped to show tape channels allocation which indicates tape backup issue not disk.

Troubleshoot the issue:

Oracle provides a diagnostic tool named “sbttest”. This utlity test media management software by attempting to communicate with the media manager…

Continue

Posted on January 18, 2013 at 2:19am

Comment Wall (1 comment)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

At 1:19pm on December 8, 2011, Asadullah fazli said…: Hi Wissem
plz kindly solve my problem:-
How to find even and odd number without any function in plsql.