Wednesday, 2 July 2014

Oracle Report Server Queue Monitoring

This article explains how to store the Oracle Reports Server queue information into a database. It discusses the installation of the tables and packages and its setup. The RW_SERVER_JOB_QUEUE table and PL/SQL API is an excellent feature to easy conserve and analyze historic meta information of a Reports Server’s job queue by simple database functionality. This functionality should enable in all application servers in which more than 3000 reports per day to save the historic data




Monday, 16 June 2014

Oracle Forms 10g Vs Windows 7

Due to the late certification of Oracle Developer Suite 10g with Windows 7 32-bit environments, there is a known issue where opening some forms in 10g Forms Builder will crash the program making it unusable. The base installer for Oracle Developer Suite 10g is currently version 10.1.2.0.2. The Developer Suite will need to be patched to version 10.1.2.3 in order to be certified with Windows 7 32-bit. The following will need to be done to fix the problem:
  1. Reinstall Oracle Developer Suite using patch 10396165 (see detailed steps below)
  2. Install patch 5983622 on top of the newly-installed installation
  3. Apply Oracle patch 7047034 (OPatch) to the Oracle Home

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.