Re: Tuning RMAN: what is rsr_l0key?

Thanks to those that responded. I thought to make a "group" reply to answer you all at once, but also to make this info available to anyone else. Unfortunately, I have not learned anything else about rsr_l0key; the jury is still out for that one.

However, after looking over my SR and hearing back from some of you, we will be applying bug patch 5620640 over the weekend and hopefully that will help.

On 10/11/07, Charles Schultz <sacrophyte_at_gmail.com> wrote:
>
> We are having some serious performance problems with the RMAN catalog;
> Oracle suggested that we upgraded to 10.2.0.3 but I think that has only
> moved the bottlenecks to different parts of the architecture. Right now, we
> are getting killed by this rman query:
> SELECT NVL (MAX(SESSION_KEY ), 0) FROM RC_RMAN_STATUS WHERE SESSION_STAMP
> < :B1
>
> Our RC_RMAN_STATUS has ~500 k rows. Looking at the view, there is a union
> for rows were rsr.rsr_l0key is null. A third of our rows have a null value
> for that column. What is rsr_l0key? It is not documented.
>
> I am sure our problem is related to volume, but I am not convinced that
> this should be the problem. I mean, come on, this is a measly 500,000
> rows.
> We are in the progress of creating a colocated catalog to partition the
> load a little. But I am still curious about the internals of rman,
> especially since it is not documented.
>
> --
> Charles Schultz

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l