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 tuning that were discussed in this video System Tuning and SQL Tuning. Roughly, System Tuning involves the appropriate system parameters configuration and SQL Tuning involves the individual SQL statement tuning.

Here are what were introduced in this video:

System Tuning

• Tuning log (redo log) switches
• pga_aggregate target (9i)
• Tuning advisors (views hints)
• Pinning packages in memory
• Statspack

SQL Tuning

• Indexes
• Oracle Optimizer
• Explain Plan
• Hints
• Stored Outlines

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:

1. Why PL SQL?
2. Types of PL/SQL Code
3. Data types - Variables
4. Statements control flow
5. Cursors
6. Exception handling

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 demonstration. What were presented in this tutorial were:

• Understand of Basic Explain Plan.
• How to setup Oracle Explain Plan and how to use it.
• Understand the Explain PLAN_TABLE, DBMS_XPLAN.DISPLAY
• How to generate and View Explain Plan
• How to read and interpret basic Explain Plan
• What is the limitation of the Explain Plan

Enjoy your watch.

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 in command prompt

    c:\sqlplus or $sqlplus

2. Enter your user and the service

    Enter user-name: user@service

3. Enter your password when prompted to do so, and you will get the error ORA-28001

    Enter password:

    ERROR:
    ORA-28001: the password has expired

4. Then it will prompt for password change, you need to enter your new password twice.

    Changing password for user
    New password:
    Retype new password:
    Password changed

Then you will be able to login to the system.

 

Read More