Fire, Floods And Hardware Failures Are No Match For Xynomix' Dr Solution

Xynomix deliver Support, Managed Services and Consultancy to Oracle users and have recently incorporated the ‘Xynomix Disaster Recovery’ solution to a portfolio of services designed to deliver maximum database availability.

Data Structures

Let’s discuss why we need data structures and what sort of problems can be solved with their use. Data structures help us to organize the data in the computer, resulting in more efficient programs. An efficient program executes faster and helps minimize the usage of resources like memory, disk. Computers are getting more powerful with the passage of time with the increase in CPU speed in GHz, availability of faster network and the maximization of disk space As discussed earlier, a solution is said to be efficient if it solves the problem within its resource constraints. What does it mean? In the computer, we have hard disk, memory and other hardware. Secondly we have time. Suppose you have some program that solves the problem but takes two months. It will be of no use. Usually, you don’t have this much time and cannot wait for two months. Suppose the data is too huge to be stored in disk. Here we have also the problem of resources. This means that we have to write programs considering the resources to achieve some solution as soon as possible. There is always cost associated with these resources. We may need a faster and better CPU which can be purchased. Sometimes, we may need to buy memory. As long as data structures and programs are concerned, you have to invest your own time for this. While working in a company, you will be paid for this. All these requirements including computer, your time and computer time will decide that the solution you have provided is suitable or not. If its advantages are not obtained, then either program or computer is not good.

How To Kill Session In Oracle Rac Database?

In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle RAC database. At this moment remote Oracle DBA should need to terminate session/process called as murder of session of any instance.  

Import Excel Data Into Mysql Using Phpmyadmin

So you have a bunch of data in Excel that you want to create a database from. But how do you import the Excel data in MySQL? With phpMyAdmin, the process is painless and easy. This tutorial will explain this process step by step. The various options for database setup and character sets are beyond the scope of this tutorial. Here are the steps to follow in order to import Excel data into MySQL using phpMyAdmin:

How To Kill Session In Oracle Using Command In Sqlplus?

In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. At this moment remote Oracle DBA should need to terminate session/process called as murder of session.