Tag: Oracle 11g

Oracle 12c – Adaptive Query Optimization

Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution…

Read More >

Room for Improvement – Using DBMS_REDEFINITION with Spatial Data

Using DBMS_REDEFINITION to reconfigure a table can be a simple way to modify table structure. But that is not always the case. Consider this example of what is necessary to modify a table when Spatial data is included in the table.

Read More >

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as oracle-rdbms-server-11gR2-preinstall RPM can be used to configure the server, right? So simple that I did not read the documentation….

Read More >

RMAN – Validating Archivelog Backup

There are many posts out there about validating backup. However, none seem to address some recent concerns a client of mine had. Currently, backup validation is performed once a week and the question asked,  “How to validate all archivelog backup?”…

Read More >

Oracle Free Block Corruption – Test Case

My very first blog post at Pythian – Trick or Treat? So there I was, faced with more that 4000 block corruptions as shown from v$database_block_corruption. The script  corrupt_seg.sql identified the corruption as Free Block Corruption (block not associated with any segments)….

Read More >

OEM Notification on Generated Trace Files

The predefined metric “Dump Area Used (%)” can monitor space consumption for dump destination of oracle database. However, it just triggers on percentage occupied, and if there are several databases on the host using the same file system for trace…

Read More >

Insider’s Guide to ODA Performance

If you are interested in the topic of ODA performance but missed the webinar or if you want to hear it again, you can view our recording here. I also uploaded the slides to slideshare, so you can take a better look at our benchmark results and study our consolidation methods at your own pace.

Read More >

Deferrable constraints in Oracle 11gR2 may lead to corrupted data

I’ve hit a bug in Oracle 11.2.0.1 when working with deferrable constraints which I think is worth sharing as it may have profound consequences under certain scenarios.Here it is.

Read More >

Oracle 11g: The Perfection of a Masterpiece – Open World 2007

This was the presentation I gave at Open World 2007. It went pretty well, judging by how full the room was. I estimate more than 300 people attended. Although the title may sound a bit like a sales pitch, the content is more substantial. Read more here.

Read More >

Oracle 11g Solaris/AIX/HP-UX/Win64 are out

The 11g platforms are now coming out fast and furious, In addition to the previously-released platforms.So download away, after checking your platform certification first, of course. Links to platforms in this post.

Read More >