Friday, 16 May 2014

How to - Check the table size in Oracle 10g /11g

              To check actual tale size of oracle is really can be hectic for you if you dont know much about oracle blocks, extents, segment and specially PCT free and PCT used concepts, and there is no actual function in oracle to check the table size,
First, we must remember that Oracle table size is constantly changing as DML adds and re moves rows.  Also, we have many other factors that determine the "actual" size of a table:



Friday, 2 May 2014

How to - Connect LUNs From EMC Storage HostAgent to Linux Server

EMC VNX Series is the huge storage to work with, High-performing unified storage with unsurpassed simplicity and efficiency, optimized for virtual applications. With the VNX Series, you’ll achieve new levels of performance, protection, compliance, and ease of management. In this writeup I am going to share an experience of working with EMC VNX 5700 and IBM Server for Database and I have created some luns for my database and now I want those luns in my DB server so that I can start my database and grid installation on that luns. There is a thing named "HOST AGENT" which is required to complete the process it is an rpm package for RHEL linux 64 bit, I have this package coz I was using the same database servers, so lets start the process.

Tuesday, 15 April 2014

LinkedIn Disaster


Hello every one as you guys know linked is one of the best professional networks in the world now days, and helping everyone to extend their professional network although every professional person is using LinkedIn frequently for new opportunities for their professional, career and financial growth. The reason for being huge usage of LinkedIn is the giant companies also using it for sharing there technologies update and so many things and everyone like it.


Monday, 7 April 2014

SQL Databases Vs NoSQL Databases


When people are comparing SQL and noSQL, and concluding the upsides and downsides of each one, what I never hear anyone talking about is the speed.
Isn't performing SQL queries generally faster than performing noSQL queries?
I mean, for me this would be a really obvious conclusion, because you should always be able to find something faster if you know the structure of your database than if you don't.
But people never seem to mention this, So I have decided to go with this writeup it would help everyone to select best database in the war between SQL vs NoSQL Databases.