Loading ...
Sorry, an error occurred while loading the content.

Re: Betr.: PeopleSoft DBA Forum SQLServer running under Peoplesoft

Expand Messages
  • David Kurtz
    Bert I know Andrew will fully understand this, but the rest of us are struggling! I think it is also appropriate to point out that the
    Message 1 of 11 , Sep 6, 2004
    • 0 Attachment
      Bert

      <MODERATOR>I know Andrew will fully understand this, but the rest of
      us are struggling!</MODERATOR>

      I think it is also appropriate to point out that the LEFT OUTER JOIN
      syntax is part of the transitional level of the SQL92 standard.
      Oracle supports this syntax from Oracle 9i (so not in 8i).

      PeopleSoft Query will generate this syntax from PeopleTools version
      8.44. It solves the problem of outer-joining query secure records in
      query, because Query will equi-join the record to the query security
      record.

      regards
      _________________________
      David Kurtz
      Go-Faster Consultancy Ltd.
      tel: +44 (0)7771 760660
      fax: +44 (0)7092 348865
      web: www.go-faster.co.uk
      mailto:david.kurtz@...
      Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
      PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba



      --- In psftdba@yahoogroups.com, "BL Barske" <BL.Barske@D...> wrote:
      > Hi, een hele stap. Zeker een management beslissing :>)
      >
      > Ik heb geen directe ervaring met de overstap (ook niet met PS 8).
      > Wij gebruiken nog de 7 serie voor HR, FIN en SA.
      >
      > Ik weet wel dat bij de vele patches die ik dit jaar voor SA heb
      moeten uitvoeren ( 64 patches met 8 bundle patches)
      > Vele scripts en queries die ik moet plaatsen zijn dan specifiek
      Oracle scripts.
      > Ik heb de SQLServer versies dan links laten liggen.
      > Het komt steeds vaker voor dat query's SQLServer en ORACLE
      specifieke commando's hebben.
      > Denk aan optimizer hints, triggers, speciale indexen en één van de
      grootste verschillen LEFT OUTER JOIN
      >
      > Ik weet niet in hoeverre je op de hoogte bent van SQLServer maar
      >
      > een select statement met een left outer join ziet er in SQLServer
      totaal anders uit dan in Oracle.
      > Dus je zult ALLE aanwezig queries, select, update, insert,
      subquery's die een where A.veldnaam (+) = B.veldnaam hebben moeten
      herschrijven.
      >
      > LEFT OUTER JOIN A=b moet worden A=B (+)
      >
      > en het FROM TABLE A ,B gedeelte moet in SQLServer ook anders
      geschreven worden.
      >
      > maak dus maar een goede impact analyse !!!!!
      >
      > Sterkte
      >
      >
      > Bert Barskè ( NICE, Oracle 10G meeting )
      >
      >
      > --------------------------------------------------------------------
      --------------------------------------------
      > We cannot solve problems by using the same kind of thinking we used
      when we created them
      > (Albert Einstein)
      >
      >
      >
      > >>> abaird@h... 3-9-2004 13:30:25 >>>
      > Hi All,
      >
      > there is a though here to start using SQlServer instead of Oracle
      as
      > the main choice of Database. Does anybody out there have experience
      > with Peoplesoft running SQLServer or like us changed from Oracle to
      > SQLServer.
      >
      > Thanks in advance
      >
      > Andy Baird
      > (Oracle DBA - Holland Casino)
      >
      >
      >
      >
      > PeopleSoft for the Oracle DBA will be published by Apress in
      September. The PeopleSoft DBA Forum is managed by http://www.go-
      faster.co.uk.
      >
      >
      >
      > Yahoo! Groups SponsorADVERTISEMENT
      >
      > Yahoo! Groups Links
      > To visit your group on the web, go to:
      > http://groups.yahoo.com/group/psftdba/
      > To unsubscribe from this group, send an email to:
      > psftdba-unsubscribe@yahoogroups.com
      > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
      Service.
      >
      >
      >
      >
      > ------------------------------->
      > Website van het Drenthe College:
      > www.drenthecollege.nl
      >
      > Vrijwaring/Disclaimer
      > De gegevens in dit elektronisch document en de eventuele bijlagen
      zijn
      > uitsluitend bedoeld voor de geadresseerde(n). De informatie wordt
      > zorgvuldig samengesteld. Het Drenthe College kan echter niet
      garanderen
      > dat de informatie absoluut juist, volledig en tijdig overkomt via
      het
      > Internet. Voor belangrijke beslissingen aangaande de verstrekte
      > informatie dient u een en ander rechtstreeks bij het Drenthe
      College te
      > controleren.
    • kclew@yahoo.com
      Hi All, I ve tested between Oracle 9i and Informix 11 (not exactly sure which version) for the PeopleSoft ping function, running in the same box on exactly
      Message 2 of 11 , Sep 6, 2004
      • 0 Attachment
        Hi All,
         
        I've tested between Oracle 9i and Informix 11 (not exactly sure which version) for the PeopleSoft ping function, running in the same box on exactly same infrastructure.
         
        According to the result that I collected, all the listed components in the PeopleSoft Ping performed very similar, apart from Apps Server and DB Server component.
         
        Apps Server component is about slightly slower for Informix compare to Oracle, but DB Server Component, the difference is huge, about 1.5 secs.
         
        Just wanna share this result with you guys.
         
        BTW, it is PeopleTools 8.43.14.
         
        Cheers
         


        Regards
        Chow!!!


        Do you Yahoo!?
        Win 1 of 4,000 free domain names from Yahoo! Enter now.
      • Baird, Andrew (ICT) (HK)
        Yep :-) of :-( Andy ... From: BL Barske [mailto:BL.Barske@DrentheCollege.nl] Sent: maandag 6 september 2004 8:52 To: abaird@hollandcasino.nl;
        Message 3 of 11 , Sep 6, 2004
        • 0 Attachment
          Yep :-) of :-(

          Andy

          -----Original Message-----
          From: BL Barske [mailto:BL.Barske@...]
          Sent: maandag 6 september 2004 8:52
          To: abaird@...; psftdba@yahoogroups.com
          Subject: Betr.: PeopleSoft DBA Forum SQLServer running under Peoplesoft


          Hi, een hele stap. Zeker een management beslissing :>)

          Ik heb geen directe ervaring met de overstap (ook niet met PS 8).
          Wij gebruiken nog de 7 serie voor HR, FIN en SA.

          Ik weet wel dat bij de vele patches die ik dit jaar voor SA heb moeten
          uitvoeren ( 64 patches met 8 bundle patches)
          Vele scripts en queries die ik moet plaatsen zijn dan specifiek Oracle
          scripts.
          Ik heb de SQLServer versies dan links laten liggen.
          Het komt steeds vaker voor dat query's SQLServer en ORACLE specifieke
          commando's hebben.
          Denk aan optimizer hints, triggers, speciale indexen en één van de grootste
          verschillen LEFT OUTER JOIN

          Ik weet niet in hoeverre je op de hoogte bent van SQLServer maar

          een select statement met een left outer join ziet er in SQLServer totaal
          anders uit dan in Oracle.
          Dus je zult ALLE aanwezig queries, select, update, insert, subquery's die
          een where A.veldnaam (+) = B.veldnaam hebben moeten herschrijven.

          LEFT OUTER JOIN A=b moet worden A=B (+)

          en het FROM TABLE A ,B gedeelte moet in SQLServer ook anders geschreven
          worden.

          maak dus maar een goede impact analyse !!!!!

          Sterkte


          Bert Barskè ( NICE, Oracle 10G meeting )


          ----------------------------------------------------------------------------
          ------------------------------------
          We cannot solve problems by using the same kind of thinking we used when we
          created them
          (Albert Einstein)



          >>> abaird@... 3-9-2004 13:30:25 >>>
          Hi All,

          there is a though here to start using SQlServer instead of Oracle as
          the main choice of Database. Does anybody out there have experience
          with Peoplesoft running SQLServer or like us changed from Oracle to
          SQLServer.

          Thanks in advance

          Andy Baird
          (Oracle DBA - Holland Casino)




          PeopleSoft for the Oracle DBA will be published by Apress in September. The
          PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk



          Yahoo! Groups SponsorADVERTISEMENT

          Yahoo! Groups Links
          To visit your group on the web, go to:
          http://groups.yahoo.com/group/psftdba/
          To unsubscribe from this group, send an email to:
          psftdba-unsubscribe@yahoogroups.com
          Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




          ------------------------------->
          Website van het Drenthe College:
          www.drenthecollege.nl

          Vrijwaring/Disclaimer
          De gegevens in dit elektronisch document en de eventuele bijlagen zijn
          uitsluitend bedoeld voor de geadresseerde(n). De informatie wordt
          zorgvuldig samengesteld. Het Drenthe College kan echter niet garanderen
          dat de informatie absoluut juist, volledig en tijdig overkomt via het
          Internet. Voor belangrijke beslissingen aangaande de verstrekte
          informatie dient u een en ander rechtstreeks bij het Drenthe College te
          controleren.





          PeopleSoft for the Oracle DBA will be published by Apress in September. The
          PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk

          Yahoo! Groups Links






          This communication is intended for the exclusive use of the addressee. It
          may contain confidential or privileged information. You may not divulge this
          information to any unauthorized third party. Please inform us immediately if
          this communication was received unintentionally. Thank you.
        • David Kurtz
          PeopleSoft Ping is not a good test of database performance, because the same rows are repeatedly read by successive pings and so they are likely to be cached
          Message 4 of 11 , Sep 6, 2004
          • 0 Attachment

            PeopleSoft Ping is not a good test of database performance, because the same rows are repeatedly read by successive pings and so they are likely to be cached by the database. Therefore, there is unlikely to be any physical I/O for these queries, and so their performance is unlikely to be affected by the disk sub-system. If, however, the database server becomes CPU bound I would expect an increase in database time.

            This argument applies to any database.

             

            The Ping transaction is defined in the DERIVED_PTP.HTMLCTLEVENT.FieldChange PeopleCode. Queries on the records PTP_TABLE1_VW and PTP_TABLE1 are run and timed in the PeopleCode. The PeopleCode system variable %PerfTime returns the time on the application server, rather than the database server, and is used to calculate the duration of the Fill and Select operations.

             
            There is a presentation, given to the PSFT Tech SIG about PS Ping on the Go-Faster website (www.go-faster.co.uk -> Presentations)
             
            regards
            _________________________
            David Kurtz
            Go-Faster Consultancy Ltd.
            tel: +44 (0)7771 760660
            fax: +44 (0)7092 348865
            web: www.go-faster.co.uk
            mailto:david.kurtz@...
            Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
            PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
            -----Original Message-----
            From: kclew@... [mailto:kclew@...]
            Sent: 06 September 2004 10:04
            To: psftdba@yahoogroups.com
            Subject: Re: Betr.: PeopleSoft DBA Forum SQLServer running under Peoplesoft

            Hi All,
             
            I've tested between Oracle 9i and Informix 11 (not exactly sure which version) for the PeopleSoft ping function, running in the same box on exactly same infrastructure.
             
            According to the result that I collected, all the listed components in the PeopleSoft Ping performed very similar, apart from Apps Server and DB Server component.
             
            Apps Server component is about slightly slower for Informix compare to Oracle, but DB Server Component, the difference is huge, about 1.5 secs.
             
            Just wanna share this result with you guys.
             
            BTW, it is PeopleTools 8.43.14.
             
            Cheers
             


            Regards
            Chow!!!


            Do you Yahoo!?
            Win 1 of 4,000 free domain names from Yahoo! Enter now.

            PeopleSoft for the Oracle DBA will be published by Apress in September.  The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk.



          • David Kurtz
            Hello Is anyone out there using any version of PeopleSoft on an Oracle RAC cluster? regards _________________________ David Kurtz Go-Faster Consultancy Ltd.
            Message 5 of 11 , Sep 6, 2004
            • 0 Attachment
              Hello
               
              Is anyone out there using any version of PeopleSoft on an Oracle RAC cluster?
               

              regards
              _________________________
              David Kurtz
              Go-Faster Consultancy Ltd.
              tel: +44 (0)7771 760660
              fax: +44 (0)7092 348865
              web: www.go-faster.co.uk
              mailto:david.kurtz@...
              Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
              PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

               
            • Henry Poras
              I know someone who will be within the next few months, but not yet. Henry
              Message 6 of 11 , Sep 7, 2004
              • 0 Attachment
                I know someone who will be within the next few months, but not yet.

                Henry

                --- In psftdba@yahoogroups.com, "David Kurtz" <info2@g...> wrote:
                > Hello
                >
                > Is anyone out there using any version of PeopleSoft on an Oracle RAC
                > cluster?
                >
                > regards
                > _________________________
                > David Kurtz
                > Go-Faster Consultancy Ltd.
                > tel: +44 (0)7771 760660
                > fax: +44 (0)7092 348865
                > web: www.go-faster.co.uk
                > mailto:david.kurtz@g...
                > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
              • mattmcclernon
                ... No, but I am seriously considering it for next year... Do you have any specific questions. Matt
                Message 7 of 11 , Sep 8, 2004
                • 0 Attachment
                  >
                  > Is anyone out there using any version of PeopleSoft on an Oracle RAC
                  > cluster?
                  >

                  No, but I am seriously considering it for next year... Do you have
                  any specific questions.

                  Matt
                • David Kurtz
                  OK. So why is you friend doing this? what is the rationale? what do you hope to achieve? How are you planning to structure the PeopleSoft infrastructure? Are
                  Message 8 of 11 , Sep 8, 2004
                  • 0 Attachment
                    OK. So why is you friend doing this? what is the rationale? what do you hope
                    to achieve?
                    How are you planning to structure the PeopleSoft infrastructure?
                    Are you going to organise different modules on different nodes (AP on one
                    instance, AR on another)?
                    Or what?

                    regards
                    _________________________
                    David Kurtz
                    Go-Faster Consultancy Ltd.
                    tel: +44 (0)7771 760660
                    fax: +44 (0)7092 348865
                    web: www.go-faster.co.uk
                    mailto:david.kurtz@...
                    Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                    PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

                    -----Original Message-----
                    From: Henry Poras [mailto:hporas@...]
                    Sent: 07 September 2004 21:16
                    To: psftdba@yahoogroups.com
                    Subject: PeopleSoft DBA Forum Re: PeopleSoft on Oracle RAC?


                    I know someone who will be within the next few months, but not yet.

                    Henry

                    --- In psftdba@yahoogroups.com, "David Kurtz" <info2@g...> wrote:
                    > Hello
                    >
                    > Is anyone out there using any version of PeopleSoft on an Oracle RAC
                    > cluster?
                    >
                    > regards
                    > _________________________
                    > David Kurtz
                    > Go-Faster Consultancy Ltd.
                    > tel: +44 (0)7771 760660
                    > fax: +44 (0)7092 348865
                    > web: www.go-faster.co.uk
                    > mailto:david.kurtz@g...
                    > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                    > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba





                    PeopleSoft for the Oracle DBA will be published by Apress in September. The
                    PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk

                    Yahoo! Groups Links
                  • Henry Poras
                    Unfortunately, nothing is as well thought out as that. The RAC system will be at the site I am currently at (but about to leave). It s going RAC because it s
                    Message 9 of 11 , Sep 9, 2004
                    • 0 Attachment
                      Unfortunately, nothing is as well thought out as that. The RAC system
                      will be at the site I am currently at (but about to leave). It's going
                      RAC because it's an upgrade from OPS. Why OPS? I'm not sure, it was
                      here when I got here. It's for High Availability and quick failover,
                      not distributing workload (two instances, one pretty much idle). Of
                      course the cluster and OPS are actually yielding the opposite effect.
                      Cluster bugs and other complexities have led to increased, not
                      decreased, downtime. (this contradiction has been mentioned, but the
                      decision has been made).

                      If there are any interesting points I hear of during the switch to
                      RAC, I'll post them.

                      Henry

                      --- In psftdba@yahoogroups.com, "David Kurtz" <info2@g...> wrote:
                      > OK. So why is you friend doing this? what is the rationale? what do
                      you hope
                      > to achieve?
                      > How are you planning to structure the PeopleSoft infrastructure?
                      > Are you going to organise different modules on different nodes (AP
                      on one
                      > instance, AR on another)?
                      > Or what?
                      >
                      > regards
                      > _________________________
                      > David Kurtz
                      > Go-Faster Consultancy Ltd.
                      > tel: +44 (0)7771 760660
                      > fax: +44 (0)7092 348865
                      > web: www.go-faster.co.uk
                      > mailto:david.kurtz@g...
                      > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                      > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
                      >
                      > -----Original Message-----
                      > From: Henry Poras [mailto:hporas@c...]
                      > Sent: 07 September 2004 21:16
                      > To: psftdba@yahoogroups.com
                      > Subject: PeopleSoft DBA Forum Re: PeopleSoft on Oracle RAC?
                      >
                      >
                      > I know someone who will be within the next few months, but not yet.
                      >
                      > Henry
                      >
                      > --- In psftdba@yahoogroups.com, "David Kurtz" <info2@g...> wrote:
                      > > Hello
                      > >
                      > > Is anyone out there using any version of PeopleSoft on an Oracle RAC
                      > > cluster?
                      > >
                      > > regards
                      > > _________________________
                      > > David Kurtz
                      > > Go-Faster Consultancy Ltd.
                      > > tel: +44 (0)7771 760660
                      > > fax: +44 (0)7092 348865
                      > > web: www.go-faster.co.uk
                      > > mailto:david.kurtz@g...
                      > > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                      > > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
                      >
                      >
                      >
                      >
                      >
                      > PeopleSoft for the Oracle DBA will be published by Apress in
                      September. The
                      > PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk
                      >
                      > Yahoo! Groups Links
                    • chawk10
                      We already implemented a 2 node RAC database on AIX for both PS FDM and HRMS apps,which are live since May 15 Regards Kal ... RAC
                      Message 10 of 11 , Sep 14, 2004
                      • 0 Attachment
                        We already implemented a 2 node RAC database on AIX for both PS FDM
                        and HRMS apps,which are live since May 15

                        Regards

                        Kal

                        --- In psftdba@yahoogroups.com, "David Kurtz" <info2@g...> wrote:
                        > Hello
                        >
                        > Is anyone out there using any version of PeopleSoft on an Oracle
                        RAC
                        > cluster?
                        >
                        > regards
                        > _________________________
                        > David Kurtz
                        > Go-Faster Consultancy Ltd.
                        > tel: +44 (0)7771 760660
                        > fax: +44 (0)7092 348865
                        > web: www.go-faster.co.uk
                        > mailto:david.kurtz@g...
                        > Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
                        > PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
                      Your message has been successfully submitted and would be delivered to recipients shortly.