Oracle Tuning for linking local table with remote table over DBLink

When we are working with multiple applications on Oracle, there might be a need to link those applications together. One of the way to integrate them is though bank end DB Link.  There is one technique I would like to introduce to help on the DBLink performance. This little...

Read More

Disable table indexes to boost up performance when doing insertion

There is pro and con for having indexes on the table. The pro is when you use select statement indexes will help boost up the query. However, when you do DML statement (insert, update, delete) you might run into performance issue. The work around of this when you need...

Read More

How to Boot Up Your Oracle Performance

This is a good Oracle Performance Tuning video I have came across on youtube. This is a good video for both Developer and DBA. The presenter gave a very good and clear explanation. This is one of the Oracle tutorial series from the same presenter. There were 2 different type of...

Read More

Oracle tutorial PL/SQL Basics

 I came a cross one video on PL/SQL tutorial, and it is a good one. This video give us picture of what oracle PL/SQL is with the very clear and simple presentation. This is a very recommended video for PL/SQL newbie. What were talked on the video were: Why PL SQL? Types of...

Read More

ORACLE EXPLAIN PLAN FUNDAMENTALS

I came across this basic Oracle Explain Plan fundamental tutorial on Youtube. The explain plan is the  basic knowledge that the developers and DBAs may consider getting to understand. The presenter in this video tutorial gave the theory and then went through the explain plan...

Read More

ORA-28001: the password has expired

  When you encounter an oracle error ORA-28001: the password has expired and you do not have sysdba priviledge, here is how to handle it. What you need is sqlplus, which is located in ORACLE_HOME/bin. The step to resolve this are: 1. Login to you account by using sqlplus...

Read More

How to check if your installed oracle client is 32bit or 64bit

The easy way to check the installed oracle client version in windows operating system: The first way to check  is checking from sqlplus binary. 1. Run sqlplus in command line, and leave it prompting for user name as shown below 2. Check oracle version from windows task...

Read More

Understanding Shared Pool Memory Structures: Tips on How to Optimize Usage and Avoid Errors

The Oracle shared pool provides critical services for sharing of complex objects among large numbers of users. Prior to 10g R1, DBAs often spent much time learning about the shared pool memory management to configure and tune shared pool usage; with the tight time constraints and...

Read More

ORA-06530: Reference to uninitialized composite

ORA-06530: Reference to uninitialized composite ORA-06512: at "PROCEDURE/PACKAGE", line 88 ORA-06512: at "PROCEDURE/PACKAGE", line 446 ORA-06512: at line 11 06530. 00000 -  "Reference to uninitialized composite" *Cause:    An object, LOB, or other composite was...

Read More

ORA-06052: PL/SQL: numeric or value error on PL/SQL Collections First and Last

Cause: The error ORA-06052: PL/SQL: numeric or value error would be found when using for loop on the type collection object, as shown below, and the collection is empty: FOR i IN type_variable.FIRST..t_variable.LAST LOOP      ----your code End Loop ; When the collection...

Read More

Migrate SUSE Linux to Oracle Linux

If you are thinking of migrating your SUSE to Oracle Linux, there are things to think of and things to be prepared before you do it. The preinstallation process and pro installation process need to be prepared. Below is the link to get information on the migration. Please...

Read More

The Reason to Upgrade to Oracle 11g Release 2

If you are using Oracle 9i, 10g, and decide to move forward to use 11g, below are what will you get form the 11g R2 upgrade:- Oracle Database 11g Release 2, the latest release of the award-winning Oracle Database 11g, enables IT professionals to deliver more information with higher...

Read More

How many database Indexes is too many?

Having a lot of indexes on your table will affect the performance of your table either bad side or good side. It depends on what operation you use most.         Index will help fasten your query, and at the same time might slow your query down. When you...

Read More

ORA-06512: at line

ORA-06512: at stringline string Cause: Backtrace message as the stack is unwound by unhandled exceptions. Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA. PostingPo...

Read More

For Loop in PL/SQL

One of the statement  in oracle I use most is for loop in pl/sql. This for loop is very handy to use and the basic statement comes like this: for variable in 1..x  loop    statement; end loop; The reverse loop statement is: for variable in reverse 1..x  loop  ...

Read More