Brian Peasland

Author's posts

Oct 06

LOB RETENTION

In the past, one would use the PCTVERSION storage parameter for their LOB segments to reserve a percentage of storage space for read consistency of LOB segments. In Oracle 11g, you can now use the RETENTION parameter. The RETENTION parameter will use the UNDO_RETENTION parameter for determining how long to keep LOB data for read-consistency …

Continue reading

Oct 05

Upgrading Grid Control After Manual DB Upgrade

I recently went through multiple database upgrades. Some of the databases were upgraded using the DBUA utility. The DBUA utility does a nice job of modifying the database’s information in Grid Control to match the new database version. When doing the database upgrades, I also had to perform some manual upgrades. When you manually upgrade …

Continue reading

Sep 26

ORA-29902 and 28578 with ST_GEOMETRY

I was working on a sticky problem of which I had a hard time resolving so I figured I would write up my issue and my solution. Recently, we were running a ST_INTERSECTION query on a spatial dataset using ESRI SDE’s ST_GEOMETRY. In Oracle 11.2.0.2, the ST_INTERSECTION query hit the following error stack: ORA-29902: error …

Continue reading

Sep 09

Standby Audit Dest Full

I recently ran into an issue where my Standby audit destination (adump) became full. The disk was not full. Rather, there were too many files in the directory. I did “ls -l | wc -l” and it came back with more than 1 million files in the directory. And it took a very long time …

Continue reading

Sep 08

ORA-1031 EXEC IMMED Rebuild Index

I recently ran into a problem that did not make any sense until I delved into a a bit further. I had a stored procedure which did an online index rebuild: CREATE PROCEDURE scott.rebuild_idx_proc AS BEGIN EXEC IMMED ‘ALTER INDEX scott.emp_pk REBUILD ONLINE’; END; / The artery which carries blood to the penis is very …

Continue reading

Sep 06

Clone ORACLE_HOME

I have begun a major upgrade of our primary production Oracle database from 11.1.0.7 to 11.2.0.2. We have 5 test environments and 12 development environments. This is small compared to many shops, but is big enough to make installing Oracle 11.2.0.2 on each and every environment a big of a pain. I tried to use …

Continue reading

Aug 09

Checker Run

I’ve noticed after I refresh some of my development databases from production, I am getting a “Checker Run” alert for the newly refreshed database. There is not much information out there, so I figured I would write up how to determine what exactly the cause is. In Grid Control, I see alerts similar to the …

Continue reading

Aug 01

Dumping Data Blocks

I was recently working on some data block corruptions and I needed to dump some data blocks to verify its contents. I had to brush off a paper I wrote a long time ago which showed how to do this. What follows is a portion of that paper: To dump a block belonging to a …

Continue reading

Jul 28

11.2.0.2 Upgrade with Standby on RAC

I have been working on upgrading an existing 11.1.0.7 database to 11.2.0.2. This database is on a RAC cluster on Oracle Enterprise Linux 5. After successfully upgrading Oracle Clusterware to Oracle Grid Infrastructure 11.2.0.2, I was looking towards upgrading the database next. The last piece you need to know is that this database is part …

Continue reading

Jul 19

ORA-4031 errors with Direct NFS

This is an old problem for me which I resolved quite a while ago, but I figured I’d finally write it up. When I started at my new company, the production database would crash about once a month with ORA-4031 memory errors. The current DBA figured the problem was lack of bind variables in application …

Continue reading