Oracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console

b2ap3_thumbnail_1_20150416-081626_1.jpg

IssueOracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console. On the contrary, the Oracle VM Server is up and running.

Investigation DoneThis is probably due to a failed event that has happened in the recent past.

Continue reading
  0 Comments

Index on Database Tables- Performance Benefits and Costs

Why Indexes?

Basic use of index is to find data in a table more quickly by speeding up the query searches. Consider an employees table with 1 million records. If I query the table to extract data for 1 employee based on emp_id, all the records are compared for the emp_id. This approach will be very time taking in real time when many queries are searching for records. Thus we should use indexes to speed up the searching process.

Continue reading
  0 Comments

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

b2ap3_thumbnail_SQLFREECourse.png

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

Use Coupon Code BIGFRIDAY415 on checkout to get 100% free.

Continue reading
  0 Comments

CASE statement and expressions: usage in PL/SQL

CASE statement is used to select one out of many set of statements to execute.

Types of CASE statements:

Continue reading
  0 Comments

How to use Linux Install media as depot to install software

DVD repo01
DVD repo02
DVD repo03

On this document I will go through a series of steps to add a local DVD to a RPM based Linux server and then use it as a Yum repository to install software.

Step 1 - Insert the Linux DVD containing the required software and then issue the command scsi-rescan NOTE: For help on how to add a Linux DVD to a Virtual Box VM check this other blog.

Continue reading
  0 Comments