Oracle buffer busy waits...let's debug it

This post can be longer indeed, but let's from scratch. First, identify from v$session_waits if there're buffer busy waits with this query:

select
   p1 "File ID",
   p2 "Block ID",
   p3 "Reason ID"
from
   v$session_wait
where
   event = 'buffer busy waits';

Now, you can find file id and block id of buffer busy. Using the following statement you can find the object belonging to waits:

select 
   owner,
   segment_name,
   segment_type
from 
   dba_extents
where 
   file_id = &P1
and 
  &P2 between block_id and block_id + blocks -1;

Now you have to find which session is using the object incriminated.

New PC...linux and PS3?

I'm really interested in this as PS3 has many resources but I'm locked only about RAM. It's possibile to add more RAM to PS3? 512 mb are really low, growing it can be usefull. I've read around some peoples used fast SD cards as swap devices but this solution is not a real alternative to hardware RAM.

RMAN problem and ORA-01023

From few days I've an RMAN backup that apparently fails with this error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql command at 03/12/2009 05:32:40
RMAN-06004: ORACLE error from recovery catalog database: ORA-01023: Cursor context not found (Invalid cursor number)

I'm trying to debug it, also looking into Metalink withot success. Metalink refers the problem in document 452946.1 to a wrong use of RMAN command release. Channel release is no more mandatory as it's done automatically after backup. I've commented release command without solving the problem. Looking deeper to solve it. Maybe I'll change Oracle TDP...

Tomorrow RTF exam

Yes, tomorrow I'll take part to the second exam needed to become a privat pilot. From this year it's also necessary to take another exam to prove English Language. Hope I'll able to pass this exam and schedule my Language proficency check for English Level 4 on 30th in Zurich

Soon online again

As filed.. I'll back in a small time. Stay tuned.