PARALLEL_ENABLE...Usage and Measurement...

From: alincoln <alincoln_at_edgewater.com>
Date: 10 Jan 2003 10:56:54 -0800
Message-ID: <3c5e17cb.0301101056.5cacc0b9@posting.google.com>

Hi, newbie to this news group...

I have a simple function that I wish to PARALLEL_ENABLE under Oracle 8.1.7...

CREATE OR REPLACE function cleanString (

     in_string     in     varchar2 
    ,in_verbose    in     number    default 0

)
return varchar2 parallel_enable is

    v_OutString VARCHAR2(50) := '';
    v_Char CHAR(1);

begin

    if ( in_string is null ) then

        v_OutString := '';
    else

        print.Value( in_string, 'Starting' );
        begin
            for v_ind in 1..length( in_string ) loop
                v_Char := SUBSTR(in_string, v_ind, 1);
        
                if( ('A' <= v_Char AND v_Char <= 'Z') OR ('0' <=
v_Char AND v_Char <= '9') ) then
                    v_OutString := v_OutString || v_Char;
                elsif( 'a' <= v_Char AND v_Char <= 'z' ) then
                    v_OutString := v_OutString || upper(v_Char);
                end if;
        
            end loop;
        exception
            when others then
                v_OutString := '';
        end;

    end if;

    print.Value( v_OutString, 'Returning' );

    return v_OutString;

end;
/

I am then using this in an INSERT statement in the 'Hope' that it will run in Parallel.

                insert into duplicate_check_superkey ( 
                     order_id


                    ,line_item

                    ,key

                    ,timestamp

                    ,forced_ind

                )
                values ( 
                     theLine.idOrder


                    ,theLine.lineItem

                    ,rtrim(ltrim(upper(theLine.idProduct))) 

                     || rtrim(ltrim(theLine.shipZip)) 
                     || theLine.shipState 
                     || cleanString(nvl(theLine.shipCity,' ')) 
                     || cleanString(nvl(theLine.shipFirstName,' ')) 
                     || cleanString(nvl(theLine.shipMiddleName,' ')) 
                     || cleanString(nvl(theLine.shipLastName,' ')) 
                     || cleanString(nvl(theLine.shipAddressOne,' '))


                    ,SYSDATE

                    ,0

                );

The code runs fine except that it appears to simply run in a sequential manner. How does one verify/confirm that a function is truely running in parallel?

Configuration :

- Solaris 2.4
- Sun 8500 Server
- Oracle 8.1.7

Thx in advance,

Adym Lincoln
Edgewater Technologies, Inc. Received on Fri Jan 10 2003 - 12:56:54 CST