Database Experts

Oracle 10g/11g:Install & deploy interim patch ::19148376 for bug fixes Dear User, In this post, We will apply small sized interim patch for bug fixes that affect the business. This interim patch specially developed for specific operating system level. This interim patch doesn't affect any major release or update the software  binaries. Its developed to fix the particular ORA errors comes in production to affect the problems. This patch can be deployed easy steps to follow. Pr-requisites. 1.   PSU Patch 11.2.0.4.0 AIX64(any other OS) Bit database software 2.   Free space of around 20 GB for taking oracle binary Backup and installing Patch sets during patching 3.   Take TAR Backup of the ORACLE_HOME post DATABASE stop 4.   Root, Grid, Oracle OS user password 5.   OPatch utility version 11.2.0.4.0 or later 6.   Hot/Cold backup of database.    1.Check the running database. [oracl...

Oracle 11g:SYSAUX Tablespace purging when abnormally increases by size   It is very obvious when we enable feature of sql profiler by OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES or increases the retention period of awr reports. We can get the all info of space utilization of sysaux tablespace by awrinfo.sql . Collect the space occupied by objects. Report o/p look something like this... ############################## #########################   (I) AWR Snapshots Information   ############################## ##########################   ****************************** ***********************   (1a) SYSAUX usage - Schema breakdown (dba_segments)   ****************************** ***********************   |   | Total SYSAUX size 36,037.3 MB ( 88% of 40,937.9 MB MAX with AUTOEXTEND OFF )   |   | Schema SYS occupies 35,717.3 MB ( 99.1% )   | Schema SYSMAN occupies 123.3 MB ( 0.3% )   | Schema SYSTEM ...