Re: Oracle on Sun Solaris vs. Digital Alpha

From: F Lange <flange_at_pt.lu>
Date: 1997/07/03
Message-ID: <01bc87ed$81da5660$7ad79ac2@LangeFrancois>#1/1

Hi,

        I have to go back at work we have both, I know there is some different parameters for alpha than for sun.

        on sun run

        AS SYS

		Create view all_parameters as
		select x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf, 

decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE'),   decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED','FALSE'),

decode(bitand(ksppstvf,7),1,
'MODIFIED',4,'SYSTEM_MOD','FALSE'), 
decode(bitand(ksppstvf,2),2,'TRUE','FALSE'),   ksppdesc from x$ksppi x,

x$ksppcv y where x.indx = y.indx ;

                grant select on all_parameters to system ;

                create synonym system.all_parameters for all_parameters ;

        On digital run

        AS SYS

		Create view all_parameters as
		select x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf, 

decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE'),   decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED','FALSE'),

decode(bitand(ksppstvf,7),1,
'MODIFIED',4,'SYSTEM_MOD','FALSE'), 
decode(bitand(ksppstvf,2),2,'TRUE','FALSE'),   ksppdesc from x$ksppi x,

x$ksppcv y where x.indx = y.indx ;

                grant select on all_parameters to system ;

                create public database link sun using '....' ;

                create synonym system.all_parameters for all_parameters ;

        AS SYSTEM                 create public database link sun connect to system identified by .... ;

		prompt missing on digital.
		select ksppinm from all_parameters
		minus
		select ksppinm from all_parameters_at_sun ;

		prompt missing on sun.
		select ksppinm from all_parameters_at_sun 
		minus
		select ksppinm from all_parameters;
				

Regards Francois.

Ben Harmon <benh_at_dascom.com> wrote in article <5pbp53$pqs_at_news9.noc.netcom.net>...
> Can anyone comment on any significant differences regarding Oracle 7 on
 Sun
> Solaris versus Digital Alpha? This could include performance,
 administration,
> stability, etc. etc.
>
> Any feedback would be greatly appreciated!
>
> Thanks,
>
> ________________________________________________
> Ben Harmon
> ben_at_dascom.com.nospam
> **Please remove .nospam suffix if you want to mail me**
> ________________________________________________
>
Received on Thu Jul 03 1997 - 00:00:00 CDT