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

Re: PSQRYSRV logs

Expand Messages
  • rrikame
    In Oracle you can run v$session query and check for program= PSQUERY and get the SQL. -Rajan
    Message 1 of 7 , Apr 4 8:37 PM
    View Source
    • 0 Attachment
      In Oracle you can run v$session query and check for program='PSQUERY' and get the SQL.

      -Rajan

      --- In psftdba@yahoogroups.com, "jagat" <jagadatma@...> wrote:
      >
      > The best possible option is to set the sql trace for PSQRYSRV. In your application server config file (psappsrv.cfg), set the sqltrace value for reading sql queries.
      >
      > Thanks
      > Jagadatma
      >
      > --- In psftdba@yahoogroups.com, "raviprasad16386" <vishwahadagali@> wrote:
      > >
      > > Hi,
      > >
      > > Is there any option to log the record of queries(Ex: SQL of query) that run on online especially through PSQRYSRV or PSAPPSRV. I want to track the queries that run online by users.
      > >
      > > Thanks
      > > Ravi
      > >
      >
    • the_dragon Draco
      There is a way to grab them down in peopletools: ?? Query manager ?? peace, clark the dragon willis To: psftdba@yahoogroups.com From: rrikame@yahoo.com
      Message 2 of 7 , Apr 15 12:44 PM
      View Source
      • 0 Attachment
        There is a way to grab them down in peopletools: ??  Query manager ??
         
        peace,
        clark 'the dragon' willis




         

        To: psftdba@yahoogroups.com
        From: rrikame@...
        Date: Thu, 5 Apr 2012 03:37:58 +0000
        Subject: PeopleSoft DBA Forum Re: PSQRYSRV logs

         
        In Oracle you can run v$session query and check for program='PSQUERY' and get the SQL.

        -Rajan

        --- In psftdba@yahoogroups.com, "jagat" <jagadatma@...> wrote:
        >
        > The best possible option is to set the sql trace for PSQRYSRV. In your application server config file (psappsrv.cfg), set the sqltrace value for reading sql queries.
        >
        > Thanks
        > Jagadatma
        >
        > --- In psftdba@yahoogroups.com, "raviprasad16386" <vishwahadagali@> wrote:
        > >
        > > Hi,
        > >
        > > Is there any option to log the record of queries(Ex: SQL of query) that run on online especially through PSQRYSRV or PSAPPSRV. I want to track the queries that run online by users.
        > >
        > > Thanks
        > > Ravi
        > >
        >


      Your message has been successfully submitted and would be delivered to recipients shortly.