Wednesday, September 11, 2013

Quick configuration of TSM Data Protection for Oracle on an AIX

›
Prerequests TDP for  Oracle  must  be  installed before Policy,domain,backup copy,storage pools  ...etc  must be defined  on TSM server...
Friday, August 2, 2013

11g Release 2 RMAN Backup Compression

›
Oracle Compression With Oracle 11g Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types...
Tuesday, March 19, 2013

Configure NTP (Network Time Protocol) clients on AIX

›
How to configure NTP on client with a NTP server .Our NTP servers  are   time_server01 and  time_server02 Verify that you have a server s...
Friday, February 22, 2013

Disk performance test with IBM ndisk64 tool

›
ndisk64 is  an IBM free tool to measure  IO performance of   your  disk . You can download  and  get information  from http://www.ibm.com/d...
Tuesday, July 17, 2012

Disable or Enable all Oracle jobs

›
There  are two  kinds  of  jobs  dbms_job and  dbms_scheduler  jobs Disable dbms_job alter system set  job_queue_processes=0; dbms_sche...
Tuesday, January 10, 2012

ORA-08104: this index object 136450 is being online built or rebuilt

›
Problem: While running an online index rebuild your session was killed  so  second attemp will give  following error. alter index MARDATA....
Thursday, November 17, 2011

How to flush a single SQL from shared pool

›
Use  DBMS_SHARED_POOL.purge exec  DBMS_SHARED_POOL.purge('ADRESS,HASH_VALUE','C',1); Example :  select address,hash_value...