Oracle DBA commands

Some  Important Oracle DBA commands Hello there all of you. Today I am just going to jot down some essential DBA commands which are useful for every DBA in their day to day life. These commands can be as well handy for a Database developer The commands are specific to Oracle Database. Let start with knowing the version of your Oracle database To see the version of the Oracle database select * from v$version; select...

Read more ...

Spinning the BIG DATA boomerang

ITS ALL ABOUT BIG DATA So, After a long time back to my Blogs. This time with the latest trend in the IT industry. BIG DATA ...

Read more ...

A new breed of Database

Paradigm shift in Database Technology Gone are the days when organizations heavily used to rely on the their traditional RDBMS for keeping a track of all their transactions and operations. Today is the age of more smarter RDBMS which are made from ground zero for a specific purpose.We will be talking about the OLAP databases in particular, which unconditionally are necessary for every organization playing with large data. OLAP...

Read more ...

Know your tables in Oracle

DBA_TABLES View  Have you ever thought of knowing statistics about your tables in oracle. Statistics in terms of Owner,Tablespace, Number of Rows, Number of Blocks used, Number of Blocks empty,etc. I was just trying to see what system tables does oracle has with it. I tried select * from tab; BOOM BOOM what a surprise More then 2000 objects listed ................... some of these objects are tables and some of these...

Read more ...

Installing JDK on Linux

Installing SUN-JDK on Linux While many of our applications are based on java framework. We definitely need the Java development kit for running the java based applications. So Lets start with What actually is a JDK A Java Development Kit (JDK) is a program development environment for writing Java applets and applications. It consists of a runtime environment that "sits on top" of the operating system layer as well...

Read more ...

Passwordless SSH

Setting passwordless ssh for  users on Linux In this tutorial, I will be explaining how to setup passwordless ssh on multiple nodes In Data warehousing world when you come across distributed Massively parallel processing database products which are deployed in cluster environment, you will definitely need passwordless ssh access to the nodes through your admin user of the Database. Most of the time passwordless...

Read more ...

PostgreSQL Connection

"PostgreSQL ODBC Connection from Windows to Linux" is my very first blog. Hope you all will find it useful.  This blog will help you to create remote connections to PostgreSQL, as you all might know the PostgreSQL does not allow remote connections by default so it has to be configured accordingly. Please follow the steps mentioned below. Note: The below scenario we are trying to make a remote connection from...

Read more ...