Archive for June, 2009
dbms_stats.copy_table_stats does not alter low/high value
I was working on a performance issue arising due to missing table stats on a new partition for large Partitioned table.This was a 10.2.0.4 database on IBM AIX 5L. So as to resolve the issue , I used dbms_stats.copy_table_stats to copy the stats to new parition from the [Read More]
Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
Few days back I got a request from development team to generate hourly export dumps of few schemas. Following were the requirements: 1. Dumpfile name should contain current date and timestamp information. 2. The generated dumpfile should be moved to a specific location. 3. [Read More]
Link: Best practices for AIX RAC Database on OTN
A new whitepaper has been published on OTN which primarily discusses best practices for AIX 5.2,5.3 and 6.1 for RAC database for avoiding node eviction due to Oprocd. It also mentions recommended AIX VMO parameters and recommended patches for Oracle RAC. You can find the [Read More]
WordPress 2.8 “Baker” Released
WordPress version 2.8 has been released. Following link contains video demo of changes in V2.8. I found option of installing theme directly from WordPress themes the coolest feature. It is not new for people using the free wordpress account’s but for people using [Read More]
Cloning database..Just do some Post checks !!
Well I will be covering some points which I believe should be part of post checklist for any cloned database environment. This might not be complete list as it contains point which I have encountered or heard of. 1) Change database Name and Database Id You should try to [Read More]
