(RADIATOR) PLSQL procedure parsing problem

[Jan Stanik]

Hugh Irvine wrote:
> 
> Hello Jan -
> 
> I'm sorry but I don't understand your question - could you please give 
> me a bit more detail?
> 
> regards

Of course. I use sessiondb.acct stored procedure to write radiator account logs into the oracle
database. When I look into the oracle statistics I see that this procedure is parsed every time it is called.
This slows the database response down.
Oracle hint is to use bind variables when the procedure is called but I don't know how to do it
in Radiator.


> 
> Hugh
> 
> 
> On 15 Nov 2004, at 01:20, Jan Stanik wrote:
> 
>>
>> Hi,
>>
>>     I have problem with high parsing when radiator calls acct stored
>> procedure from Oracle db. Can anyone help me to adapt the calling of
>> this procedure not be parsed every time?
>>
>> here is a part of config file:
>>
>> <AuthBy PLSQL>
>>         Identifier SessionDB
>>         NoDefault
>>         NoDefault
>>         DBSource        dbi:Oracle:%{GlobalVar:OraName1}
>>         DBUsername      %{GlobalVar:OraUser1}
>>         DBAuth          %{GlobalVar:OraPass1}
>>         FailureBackoffTime 180
>>
>>         AcctSQLStatement begin \
>>                          sessiondb.acct('%u', '%N',
>> 0%{NAS-Port},\                     '%{Acct-Session-Id}', 
>> '%{Framed-IP-Address}',\                
>> '%{NAS-Port-Type}','%{Service-Type}',\
>>                      0%{Acct-Session-Time},'%{Acct-Status-Type}',\
>>             '%{Class}', 0%{Acct-Input-Octets},\
>>         0%{Acct-Output-Octets},0%{Acct-Input-Gigawords},\            
>> 0%{Acct-Output-Gigawords}); \
>>                          end;
>> </AuthBy>
>>
>> -- 
>> Archive at http://www.open.com.au/archives/radiator/
>> Announcements on radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
>>
>>
> 
> NB:
> 
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive 
> (www.open.com.au/archives/radiator)?
> Have you had a quick look on Google (www.google.com)?
> Have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
> 

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.