Re: What is RPI calls (user calls from statspack)

Hi Barbara,

It stands for "Recursive Program Interface" and corresponds to the "recursive calls" statistic.

BTW, this ratio is close to useless in my opinion.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/         - For DBAs
@   http://www.christianity.net.au/  - For all

-----Original Message-----
Date: Fri, 1 Jun 2007 13:55:16 -0600
From: "Barbara Baker" <barb.baker_at_gmail.com> To: oracle-l_at_freelists.org
Subject: What is RPI calls (user calls from statspack)

> I found a couple of references to the statistic "User Calls" in
> statspack reports as follows:
> "Oracle allocates resources to keep track of relevant user call data
> structures every time you log in, parse, or execute. When determining
> activity, the ratio of user calls to RPI calls indicates how much
> internal work gets generated as a result of the type of requests the
> user is sending to Oracle."
>
> I cannot find a description of RPI.
>
> Does anyone know what it refernces?
> Thanks.
> Barb
>

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