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.