Error :Specify KERN_DIR= while Installing VirtualBox Guest Additions

Error :Specify KERN_DIR= while Installing VirtualBox Guest Additions
04-failed-to-install
05-install-success

Issue Description

While installing Guest Additions faced with the following error

Continue reading
  0 Comments

How to search a new line character and remove it from your database?

How to search a new line character and remove it from your database?

Introduction

While working on the Database, I encountered an unique issue where I found a new line character ('\n' or Enter) at the end of my data. This leads to wrong output.

Continue reading
  0 Comments

Temporary tables in Oracle Database

Temporary tables in Oracle Database

Consider the following situation - a customer goes to a travel website to find out the different options for travelling to his vacation spot. For this, he/she creates a number of iteneraries out of which only one will be finalized at the end or all of them will be discarded. These iteneraries donot need to be stored in the database on a permanent basis. Storing them in a temporary table to be discarded/deleted at the end of session/transaction makes sense in such cases.

Simply put, temporary tables are used to store data temporarily during a transaction or session.

Continue reading
  0 Comments

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

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

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