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