Hello All,
Just a quicky, does anyone use the Payroll Interface for ADP
connection that is mentioned in customer connection. We are looking
at possibly using this interface, as our payroll is run through ADP,
and I just wanted any feedback or comments from anyone that was using
it.
Thanks
Justin

Sure are. And lets leave it at that.

Dick Goulet
Senior Oracle DBA/Oracle Certified 8i DBA

____________________Reply Separator____________________
Subject:    PeopleSoft DBA Forum Payroll Interface for ADP
Author: "gaffman90 <justin_v_gaffney@...>"
<justin_v_gaffney@...>
Date:       2/11/2003 3:49 PM

Hello All,
Just a quicky, does anyone use the Payroll Interface for ADP
connection that is mentioned in customer connection. We are looking
at possibly using this interface, as our payroll is run through ADP,
and I just wanted any feedback or comments from anyone that was using
it.
Thanks
Justin



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

At the recent PSFT UK Tech SIG I asked for a show of hands for which
webserver were people using.
The result was that the vast majority were using weblogic.

There is a poll running on the forum website
(http://groups.yahoo.com/group/psftdba/surveys?id=430731)
where I am asking the same question.  The poll will run until the end of the
month.

Currently results:
Apache 4
Weblogic 9
Websphere 0
others

_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44 7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

Hello,

I saw from the poll results on David's forum that there are still
some of you that run PeopleSoft on the apache webserver. We currently
have a big problem here at NEC with our PS8 environment(Oracle/Win2K
with Financials/Distribution/Manufacturing for about 900 users).

The problem is that Apache restarts its child process on a frequent
basis, causing the active connections to be reset and (some) users to
receive a 'page cannot be displayed' error. The proof that this is
happening is easy to obtain, just have a look in the Windows task
manager of your webserver where you have the two Apache executables.
One of them is the parent (with 2 threads), the other the child with
the 50-1024 threads depending on your setting of ThreadsPerChild. The
PID's of these two executables should remain the same as long as
Apache is up, and in our case the child PID changes every few hours,
showing that it has restarted.

Another way of showing if this is happening is looking at the apache
server-status page (http://<your_webserver>/server-status). Normally
the server uptime should indicate the actual uptime of the webserver
(usually weeks or months). In our case this is never more than 1-2
hours.

I'm wondering if anybody else is having this problem, perhaps we can
share some ideas on how to tackle it.

Thanks a lot in advance,

Pierre

Pierre,
We are actually using the Weblogic webserver, so I
don't know much about the Apache. Did you look in the
www.PeopleSoft.com discussion groups and on
www.Slerp.com.?
-Roger

--- "pierrevanelswijk
<pierre.vanelswijk@...>"
<pierre.vanelswijk@...> wrote:
> Hello,
>
> I saw from the poll results on David's forum that
> there are still
> some of you that run PeopleSoft on the apache
> webserver. We currently
> have a big problem here at NEC with our PS8
> environment(Oracle/Win2K
> with Financials/Distribution/Manufacturing for about
> 900 users).
>
> The problem is that Apache restarts its child
> process on a frequent
> basis, causing the active connections to be reset
> and (some) users to
> receive a 'page cannot be displayed' error. The
> proof that this is
> happening is easy to obtain, just have a look in the
> Windows task
> manager of your webserver where you have the two
> Apache executables.
> One of them is the parent (with 2 threads), the
> other the child with
> the 50-1024 threads depending on your setting of
> ThreadsPerChild. The
> PID's of these two executables should remain the
> same as long as
> Apache is up, and in our case the child PID changes
> every few hours,
> showing that it has restarted.
>
> Another way of showing if this is happening is
> looking at the apache
> server-status page
> (http://<your_webserver>/server-status). Normally
> the server uptime should indicate the actual uptime
> of the webserver
> (usually weeks or months). In our case this is never
> more than 1-2
> hours.
>
> I'm wondering if anybody else is having this
> problem, perhaps we can
> share some ideas on how to tackle it.
>
> Thanks a lot in advance,
>
> Pierre
>
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

Hi,

I would like to know what to do to change SYSADM password.

I know i must change the database password of SYSADM (RDBMS=Oracle for
me) and the Access profile in App. Designer.

But what about the web server (weblogic here)?
What must I change ? How ?
Which config files ?
Something else to change ?

(With HRMS 8.3, it seems that I only need to change the access profile
in App Designer.)

Config: FSCM 8.4; PTools 8.41; HP-UX 11i; Oracle 8.1.7.2

Thanks

Hi,

I've read from the paper "PeopleSoft for the Oracle DBA", that it is not
advisable to make PSTEMP a temporary tablespace bc Peoplesofts stores
some tables in PSTEMP temporarily.

In my Oracle database for Financials 8.4 / PTools 8.41 , I have a
locally managed temporary tablespace for PSTEMP.
and :

USERNAME        DEFAULT_TABLE TEMPORARY_TAB
------------- ------- -------------
PS               PSDEFAULT     PSTEMP
SYSADM           PSTEMP        PSTEMP
PEOPLE           PSDEFAULT     PSTEMP
..

Should i change to a permanent tblsp ?
Will i have errors with PeopleSoft when it tries to create tables in
PSTEMP ?
Any experience ?

I'm a complete beginner with PS.


Thanks.

SYSADM, or whatever schema owner id you are using, shouldn't exist
anywhere on the webserver. The only possibility is if you're using
the id for a batch process to connect, and you have it stored in a
password file somewhere on your system, but that wouldn't be a very
smart design...

As far as PeopleSoft itself goes, SYSADM is just for the database. If
you change it through appdesigner -> tools -> misc -> access
profiles, this will propogate down to the database level, and you
won't need to change it directly in oracle.

--- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
<lehuyluan@h...> wrote:
> Hi,
>
> I would like to know what to do to change SYSADM password.
>
> I know i must change the database password of SYSADM (RDBMS=Oracle
for
> me) and the Access profile in App. Designer.
>
> But what about the web server (weblogic here)?
> What must I change ? How ?
> Which config files ?
> Something else to change ?
>
> (With HRMS 8.3, it seems that I only need to change the access
profile
> in App Designer.)
>
> Config: FSCM 8.4; PTools 8.41; HP-UX 11i; Oracle 8.1.7.2
>
> Thanks

Hi,

With PTools 8.18, just need to use Access Profile.

But with Ptools 8.41, changing the Access profile does not change the
password of the user SYSADM in the Oracle database.

Is it a bug ???
I have to change it with 'alter user SYSADM identified by ...'
I have to open App Designer before I alter the password in the db
  because after, I can't open app Designer (it says invalid pass)



--- In psftdba@yahoogroups.com, "CBenson <charles.benson@b...>"
<charles.benson@b...> wrote:
> SYSADM, or whatever schema owner id you are using, shouldn't exist
> anywhere on the webserver. The only possibility is if you're using
> the id for a batch process to connect, and you have it stored in a
> password file somewhere on your system, but that wouldn't be a very
> smart design...
>
> As far as PeopleSoft itself goes, SYSADM is just for the database. If
> you change it through appdesigner -> tools -> misc -> access
> profiles, this will propogate down to the database level, and you
> won't need to change it directly in oracle.
>

Peoplesoft temporary tables (ending in TMP) are "permanent" as far as Oracle is
concerned, and reside in a tablespace which must be defined as permament.
Peoplesoft calls them "temporary" because they hold transient data.

Oracle temporary tables exist only for the duration of a session and are used
for sort operations. The tablespace assigned for this purpose should be defined
as temporary. No permanent objects can be created in a temporary tablespace.
This is the one that is linked to your oracle user which you can see in view
user_users.

So, you need 2 tablespaces:
TEMP, created as temporary for your sorts which you specify as the
temporary_tablespace when you create a user;
PSTEMP, created as permanent for your Peoplesoft temporary tables, and NOT
specified when you create a user.

Thanks Sean.

I understand : PSTEMP must be a permanent tablespace for Oracle
because Peoplesoft stores some Oracle tables in in a temporarily manner.

Can I have a example to see that Peoplesoft tries to create in PSTEMP ?

{ I just want to believe what i see :) }

Not all Peoplsoft installations necessarily have a PSTEMP tablespace, you can
name it want you want. But by default it's used to house the _TMP and _TAO
tables.
Do

select recname, ddlspacename from psrecdefn

to see what tables would be created in PSTEMP (assuming you haven't already
changed any of the ddlspacename values in psrecdefn). If the result is zero, you
don't need to create the tablespace.

In 8.41 PTools, ddlspacename is no longer a field in psrecdefn.

Henry

--- In psftdba@yahoogroups.com, sroderick1@a... wrote:
> Not all Peoplsoft installations necessarily have a PSTEMP
tablespace, you can name it want you want. But by default it's used
to house the _TMP and _TAO tables.
> Do
>
> select recname, ddlspacename from psrecdefn
>
> to see what tables would be created in PSTEMP (assuming you haven't
already changed any of the ddlspacename values in psrecdefn). If the
result is zero, you don't need to create the tablespace.

Hi

We run the script below in Datamover after changing at Oracle level.


Rgs

Shirley

update PSSTATUS set OWNERID = 'SYSADM';
update PSOPRDEFN set SYMBOLICID = 'SYSADM', OPERPSWD = OPRID, ENCRYPTED =
0;
update PSACCESSPRFL set ACCESSID = 'SYSADM', SYMBOLICID = 'SYSADM',
ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0;
encrypt_password *;





                     "litbighor
                     <lehuyluan@hot       To:     psftdba@yahoogroups.com
                     mail.com>"           cc:
                     <lehuyluan           bcc:
                                          Subject:     PeopleSoft DBA Forum Re:
How to change SYSADM password with
                     18/02/2003            PTools 8.41 (FSCM 8.4) ?
                     11:10 PM
                     Please respond
                     to psftdba






Hi,

With PTools 8.18, just need to use Access Profile.

But with Ptools 8.41, changing the Access profile does not change the
password of the user SYSADM in the Oracle database.

Is it a bug ???
I have to change it with 'alter user SYSADM identified by ...'
I have to open App Designer before I alter the password in the db
  because after, I can't open app Designer (it says invalid pass)



--- In psftdba@yahoogroups.com, "CBenson <charles.benson@b...>"
<charles.benson@b...> wrote:
> SYSADM, or whatever schema owner id you are using, shouldn't exist
> anywhere on the webserver. The only possibility is if you're using
> the id for a batch process to connect, and you have it stored in a
> password file somewhere on your system, but that wouldn't be a very
> smart design...
>
> As far as PeopleSoft itself goes, SYSADM is just for the database. If
> you change it through appdesigner -> tools -> misc -> access
> profiles, this will propogate down to the database level, and you
> won't need to change it directly in oracle.
>





To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/








           "The information contained in this email and any attached files
           is strictly private and confidential.  This email should be read
           by the intended addressee only.  If the recipient of this message
           is not the intended addressee, please call Aon Risk Services
           Australia, Aon Consulting, Aon Re Australia Ltd and other
           associated Aon Companies on +61 2 92537000 and promptly delete
           this email and any attachments.

           The intended recipient of this email may only use, reproduce,
           disclose or distribute the information contained in this email
           and any attached files with Aon's permission.  If you are not the
           intended addressee, you are strictly prohibited from using,
           reproducing, disclosing or distributing the information contained
           in this email and any attached files.

           Aon advises that this email and any attached files should be
           scanned to detect viruses.  Aon accepts no liability for loss or
           damage (whether caused by negligence or not) resulting from the
           use of any attached files."

------------------------------------------------------------

With PT 8.18 :
SQL> select RECNAME,DDLSPACENAME from psrecdefn where
DDLSPACENAME='PSTEMP';
no rows selected

=> So I don't need to have a permanent tablespace for PSTEMP. Right ?

-------------------------------------------------------------

With PT 8.41 :
SQL> select DDLSPACENAME,RECNAME from PSRECTBLSPC where
DDLSPACENAME='PSTEMP';
no rows selected

=> So I don't need to have a permanent tablespace for PSTEMP. Right
again ?

For information :
DDLSPACENAME col is in others tables :
PSSPCDDLPARM ==> it seems interesting for INIT,NEXT etc...
PSTBLSPCCAT ==> ?
PSTBLSPCCAT_VW ==> ?

Conclusion :

For my install, the "temporary" Peoplesoft tables are not in PSTEMP.
So I can let my PSTEMP being a "Oracle temporary tablespace".
( proof : select distinct (TABLESPACE_NAME) from user_segments
  where SEGMENT_NAME like '%TAO' or SEGMENT_NAME like '%TMP'; doesn't
give PSTEMP )

Hi,

I would like to have feedback/experience about PS with a
Oracle database with Loc. Managed Tablespaces ?

Do you use autoallocate ?
It seems difficult to me to use uniform size with Peoplesoft ...

Any performance improvement ?

I have a LMT database but it's not in production yet.

Thanks Shirley.
Can you explain the lines "encrypt_password *;" ?
I understand SQL but not "encrypt_password *;".

LMTs really add more to ease of administration rather than a benefit
in performance. See the following article from Jonathan Lewis
http://www.dbazine.com/jlewis8.html
Henry

--- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
<lehuyluan@h...> wrote:
> Hi,
>
> I would like to have feedback/experience about PS with a
> Oracle database with Loc. Managed Tablespaces ?
>
> Do you use autoallocate ?
> It seems difficult to me to use uniform size with Peoplesoft ...
>
> Any performance improvement ?
>
> I have a LMT database but it's not in production yet.

Just wondering if anyone is using Data Guard or standby database with
PeopleSoft.  We are interested if there are problems or pitfalls in using
the above two.  We are currently running Oracle 8.1.7.3 with PS8/PT8.1.8 on
Higher Ed.  We're going to Oracle 9iR2 in the near future.

Thanks

Ron Cetnar

Oracle DBA
SUNY Albany
rcetnar@...

***********************************************************************
Ron Cetnar
Supervising Programmer/Analyst/Oracle DBA
University Applications Development

State University of New York at Albany
MSC 100
1400 Washington Ave
Albany, NY 12222

Email: rcetnar@...
Work: (518) 437-4535
Fax:   (518) 437-4540

***********************************************************************

Just wondering if anyone is using Data Guard or standby database with
PeopleSoft.  We are interested if there are problems or pitfalls in using
the above two.  We are currently running Oracle 8.1.7.3 with PS8.1.8 on
Higher Ed.  Planning to go to Oralce 9iR2 in the very near future.

Thanks

Ron Cetnar

Oracle DBA
SUNY Albany
rcetnar@...

Henry,

Worked with it a bit while tuning a WF process that was running long in a HR environment.  PeopleSoft was called in to help and after initial look at the system (db response time), decided that the database might be the issue, and using loc. managed tblspcs would speed the database up.  I don't think autoallocate was used, but that was due to the setup/management of the the Oracle DB.  In the end, the problem turned out to be a qmail server problem, but the time spent in the database went down to nothing with the use of LMT.

Cheers,

JCD

 "Henry Poras <hporas@...>" <hporas@...> wrote:

LMTs really add more to ease of administration rather than a benefit
in performance. See the following article from Jonathan Lewis
http://www.dbazine.com/jlewis8.html
Henry

--- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
<lehuyluan@h...> wrote:
> Hi,
>
> I would like to have feedback/experience about PS with a
> Oracle database with Loc. Managed Tablespaces ?
>
> Do you use autoallocate ?
> It seems difficult to me to use uniform size with Peoplesoft ...
>
> Any performance improvement ?
>
> I have a LMT database but it's not in production yet.



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

James,

LMT should help with performance if there is contention for ST
enqueues. ( a Space Transaction enqueue. Basically a data dictionary
lock used when extending or shrinking objects.) Most tables and
indexes, if sized properly shouldn't grow frequently enough to have
this problem. It could also come from frequent extending and
shrinking of rollback segments (again, if sized properly, not a
problem), or lots of activity in a temporary tablespace (frequent
sorts, ... If the temporary tablespace is of type temporary, not
permanent, the extents, once created, remain. So again, the ST
contention is reduced). Another possibility is frequent CREATE and
DROP of temporary (scratch pad) tables.

So my guess is that even though there was a performace boost, there
probably was some other underlying problem that was masked by the LMT.

Any ideas?

Henry

--- In psftdba@yahoogroups.com, James De Atley <jamesdeatley@y...>
wrote:
>
> Henry,
> Worked with it a bit while tuning a WF process that was running
long in a HR environment.  PeopleSoft was called in to help and after
initial look at the system (db response time), decided that the
database might be the issue, and using loc. managed tblspcs would
speed the database up.  I don't think autoallocate was used, but that
was due to the setup/management of the the Oracle DB.  In the end,
the problem turned out to be a qmail server problem, but the time
spent in the database went down to nothing with the use of LMT.
> Cheers,
> JCD
>  "Henry Poras <hporas@a...>" <hporas@a...> wrote:LMTs really add
more to ease of administration rather than a benefit
> in performance. See the following article from Jonathan Lewis
> http://www.dbazine.com/jlewis8.html
> Henry
>
> --- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
> <lehuyluan@h...> wrote:
> > Hi,
> >
> > I would like to have feedback/experience about PS with a
> > Oracle database with Loc. Managed Tablespaces ?
> >
> > Do you use autoallocate ?
> > It seems difficult to me to use uniform size with Peoplesoft ...
> >
> > Any performance improvement ?
> >
> > I have a LMT database but it's not in production yet.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
> To unsubscribe from this group, send an email to:
> psftdba-unsubscribe@yahoogroups.com
>
> The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day

We are using Data Guard (8.1.7.2 oracle version), on all of our production
Oracle DB's - some Peoplesoft, some not.  It works fine.  We had Oracle
sales out here a couple of weeks ago for a product update and they seemed
to be really surprised that we were using it - I think it's more stable on
version 9.

Pitfalls would be the destination server being rebooted and no-one telling
you ;-)   We have found the need to write a synchronising script of our own
on the main server ensuring the "push" of the archive logs to the standby
(in case of a reboot, or networking fault).


Regards

Shirley







                     Ron Cetnar
                     <rcetnar@...       To:     "'psftdba@yahoogroups.com'"
<psftdba@yahoogroups.com>
                     lbany.edu>              cc:
                                             bcc:
                     20/02/2003 03:39        Subject:     PeopleSoft DBA Forum
Data Guard / Standby Database
                     AM
                     Please respond to
                     psftdba






Just wondering if anyone is using Data Guard or standby database with
PeopleSoft.  We are interested if there are problems or pitfalls in using
the above two.  We are currently running Oracle 8.1.7.3 with PS8/PT8.1.8 on

Higher Ed.  We're going to Oracle 9iR2 in the near future.


Thanks


Ron Cetnar


Oracle DBA
SUNY Albany
rcetnar@...






***********************************************************************
Ron Cetnar
Supervising Programmer/Analyst/Oracle DBA
University Applications Development


State University of New York at Albany
MSC 100
1400 Washington Ave
Albany, NY 12222


Email: rcetnar@...
Work: (518) 437-4535
Fax:   (518) 437-4540


***********************************************************************



                Yahoo! Groups Sponsor



                    ADVERTISEMENT








To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





           "The information contained in this email and any attached files
           is strictly private and confidential.  This email should be read
           by the intended addressee only.  If the recipient of this message
           is not the intended addressee, please call Aon Risk Services
           Australia, Aon Consulting, Aon Re Australia Ltd and other
           associated Aon Companies on +61 2 92537000 and promptly delete
           this email and any attachments.

           The intended recipient of this email may only use, reproduce,
           disclose or distribute the information contained in this email
           and any attached files with Aon's permission.  If you are not the
           intended addressee, you are strictly prohibited from using,
           reproducing, disclosing or distributing the information contained
           in this email and any attached files.

           Aon advises that this email and any attached files should be
           scanned to detect viruses.  Aon accepts no liability for loss or
           damage (whether caused by negligence or not) resulting from the
           use of any attached files."

I'm not a Peoplesoft "technical" person, so I'll point you at a link that
explains things a lot better than I can......

http://www.peoplesoftpros.net/net/tips/tip.asp?tipid=34



Regards

Shirley





                     "litbighor
                     <lehuyluan@hot       To:     psftdba@yahoogroups.com
                     mail.com>"           cc:
                     <lehuyluan           bcc:
                                          Subject:     PeopleSoft DBA Forum Re:
How to change SYSADM password with
                     19/02/2003            PTools 8.41 (FSCM 8.
                     09:20 PM
                     Please respond
                     to psftdba






Thanks Shirley.
Can you explain the lines "encrypt_password *;" ?
I understand SQL but not "encrypt_password *;".







To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/








           "The information contained in this email and any attached files
           is strictly private and confidential.  This email should be read
           by the intended addressee only.  If the recipient of this message
           is not the intended addressee, please call Aon Risk Services
           Australia, Aon Consulting, Aon Re Australia Ltd and other
           associated Aon Companies on +61 2 92537000 and promptly delete
           this email and any attachments.

           The intended recipient of this email may only use, reproduce,
           disclose or distribute the information contained in this email
           and any attached files with Aon's permission.  If you are not the
           intended addressee, you are strictly prohibited from using,
           reproducing, disclosing or distributing the information contained
           in this email and any attached files.

           Aon advises that this email and any attached files should be
           scanned to detect viruses.  Aon accepts no liability for loss or
           damage (whether caused by negligence or not) resulting from the
           use of any attached files."

Thanks Shirley

The procedure you describe is only for "PT 7.03 and 7.52 and below"
and for "2 tier env" only.
I have a "Pure Internet Architecture" .
What is strange about PT 8.41 is : changing Access profile
do not change the password in the database...

Data Guard / Standby DatabaseRon,
good morning ( uk time ).

We run peoplesoft 8.18 on AIX 4.3.3 using oracle 8.1.7.4. We have a server
running oracle/peoplesoft and another with the ( apache ) webserver on.
This is then duplicated for the development environment where I've bolted
on the standby environment.

I've implemented a standard oracle 'managed recovery' standby environment
( using log_archive_dest_N and log_archive_dest_state_N initSID
parameters). It works very well and is simple to implement and support. We
run the database under a different unix account to the application domain
so additionally, I use the 'rdist' command to keep the application domain
in line between the two servers. Finally, I use rdist to keep the web
servers in line too ( a.k.a the cache mainly ).

We run a simple check 'select max(recid) from v$log_history'; on the
standby every so many hours to check if the 'last log applied' number has
increased. Sending an email out if it hasn't.
If you want any scripts just ask.

At the time I was under the impression that dataguard was a 9i product so
I didn't even look into it.
It comes down to the business needs of course. We can manage with email
alerts for the standby database. We've done three standby tests including
running for 2 full days on the standby environment while some hardware
upgrades were performed on the production system.

A question for yourself Ron, what peoplesoft version is 9iR2 supported
with ?

Regards
Ken.
   -----Original Message-----
   From: Ron Cetnar [mailto:rcetnar@...]
   Sent: Wednesday, February 19, 2003 4:40 PM
   To: 'psftdba@yahoogroups.com'
   Subject: PeopleSoft DBA Forum Data Guard / Standby Database


   Just wondering if anyone is using Data Guard or standby database with
   PeopleSoft.  We are interested if there are problems or pitfalls in
using
   the above two.  We are currently running Oracle 8.1.7.3 with PS8/PT8.1.8
on
   Higher Ed.  We're going to Oracle 9iR2 in the near future.

   Thanks

   Ron Cetnar

   Oracle DBA
   SUNY Albany
   rcetnar@...




   ***********************************************************************
   Ron Cetnar
   Supervising Programmer/Analyst/Oracle DBA
   University Applications Development

   State University of New York at Albany
   MSC 100
   1400 Washington Ave
   Albany, NY 12222

   Email: rcetnar@...
   Work: (518) 437-4535
   Fax:   (518) 437-4540

   ***********************************************************************


         Yahoo! Groups Sponsor
               ADVERTISEMENT




   To unsubscribe from this group, send an email to:
   psftdba-unsubscribe@yahoogroups.com

   The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Henry,

It was a few years ago and I wasn't that close to the Oracle end of things.  I was just relaying the fact that during this tuning exercise of WF, we saw an improvement on the database when using LMT's.

Bonne Chance,

James

 "Henry Poras <hporas@...>" <hporas@...> wrote:

James,

LMT should help with performance if there is contention for ST
enqueues. ( a Space Transaction enqueue. Basically a data dictionary
lock used when extending or shrinking objects.) Most tables and
indexes, if sized properly shouldn't grow frequently enough to have
this problem. It could also come from frequent extending and
shrinking of rollback segments (again, if sized properly, not a
problem), or lots of activity in a temporary tablespace (frequent
sorts, ... If the temporary tablespace is of type temporary, not
permanent, the extents, once created, remain. So again, the ST
contention is reduced). Another possibility is frequent CREATE and
DROP of temporary (scratch pad) tables.

So my guess is that even though there was a performace boost, there
probably was some other underlying problem that was masked by the LMT.

Any ideas?

Henry

--- In psftdba@yahoogroups.com, James De Atley <jamesdeatley@y...>
wrote:
>
> Henry,
> Worked with it a bit while tuning a WF process that was running
long in a HR environment.  PeopleSoft was called in to help and after
initial look at the system (db response time), decided that the
database might be the issue, and using loc. managed tblspcs would
speed the database up.  I don't think autoallocate was used, but that
was due to the setup/management of the the Oracle DB.  In the end,
the problem turned out to be a qmail server problem, but the time
spent in the database went down to nothing with the use of LMT.
> Cheers,
> JCD
>  "Henry Poras <hporas@a...>" <hporas@a...> wrote:LMTs really add
more to ease of administration rather than a benefit
> in performance. See the following article from Jonathan Lewis
> http://www.dbazine.com/jlewis8.html
> Henry
>
> --- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
> <lehuyluan@h...> wrote:
> > Hi,
> >
> > I would like to have feedback/experience about PS with a
> > Oracle database with Loc. Managed Tablespaces ?
> >
> > Do you use autoallocate ?
> > It seems difficult to me to use uniform size with Peoplesoft ...
> >
> > Any performance improvement ?
> >
> > I have a LMT database but it's not in production yet.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
> To unsubscribe from this group, send an email to:
> psftdba-unsubscribe@yahoogroups.com
>
> The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day



To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hello

I haven't recreated PeopleSoft delivered tables as LMTs in a production
environment, but that is mainly due to not getting there early enought.

I have experimented with LMTs on a demo database.  All the PS delivered
tablespaces were created as LMT with autoallocate - so the segments are
sized as 64K, 1M and 8M.  Even A PeopleSoft HR database delivered several
thousand tables, Financials is over 10000!  Many of these tables will be
empty.  The resultant demo database will be larger, but I am fairly sure
that if this was done in a real database there would not be any additional
space overhead, there might even be a saving.

The problem is that PeopleSoft chooses all sorts of sizes for its tables,
and with the continual flow of updates causing tables to be altered by
recreation (which you should always do in production to avoid chaining) you
end up with free space fragments scattered through the tablespace.  In an
LMT the spaces will be of a uniform size (3 uniform sizes for autoallocate)
or multiples thereof, so they are more likely to be reused.  In Financials
especially, this effect is magnified by the use of temporary working storage
tables which grow, and if you are attentive are periodically truncated, thus
dropping all but the first extent in the object.

In a dictionary managed tablespace continguous free space extents may be
reported separately on DBA_FREE_SPACE, and so may be reused separately
unless the free space is coalesced.  This can actually promote fragmentation
of free space.

Jonathan Lewis generally recommends using a uniform extent size over
autoallocate because you can then redistribute the tables into different
tablespaces with different uniform extents sizes.  This is probably a better
approach, but if you want to retain the PS tablespace model then I think you
are probably forced into autoallocate for at least the xxAPP tablespaces.
You might choose a uniform extent size for some of the xxLARGE tablespaces.

(Since I have mentioned Jonathan his website is well worth a look -
www.jlcomp.demon.co.uk)

The best part of this is that you don't have to do anything to PeopleSoft in
order to implement LMTs.  Although the PS DDL will have a storage clause
specify in initial, next etc this will be SILENTLY ignored by Oracle when
the tablespace is LM.  Note that if you use SETTABLE.sqr and SETINDEX.sqr to
backport the storage options from USER_TABLES and USER_INDEXES back into the
PeopleTools tables, the storage values in Oracle will be NULL and they will
become 0 in the PeopleSoft database.  Storage options on at least user
specified indexes will be moved to the target database during an upgrade and
if you are upgrading from database with LMTs to a database without LMTs the
index create may fail with an invalid storage clause.  So, you might choose
to comment the storage clause out of the PS DDL model just to be on the safe
side.

I have used LMTs on two Global Payroll projects where I introduced new
tablespaces.  The GP result tables become very large and so I partitioned
them to match the GP streams.  So at one site we have 30 payroll streams (ie
there are 30 payroll calculation processes running in parallel) and each
stream corresponds to one of 30 partitions.  I created two new tablespaces
for each stream (one for tables, and one for indexes).  The indexes are
locally partitioned.  Partition 1 of each table goes into the same
tablespace, etc.  All the new tablespaces are locally managed with uniform
extent sizes of 20M.  This was chosen because some of the partitions were
expected to reach several hundred Mb.



_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44 7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> Message: 1
>    Date: Wed, 19 Feb 2003 14:40:43 -0000
>    From: "Henry Poras <hporas@...>" <hporas@...>
> Subject: Re: Any experience with a Oracle database with Loc. Managed
Tablespaces ?
>
> LMTs really add more to ease of administration rather than a benefit
> in performance. See the following article from Jonathan Lewis
> http://www.dbazine.com/jlewis8.html
> Henry
>
> --- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
> <lehuyluan@h...> wrote:
> > Hi,
> >
> > I would like to have feedback/experience about PS with a
> > Oracle database with Loc. Managed Tablespaces ?
> >
> > Do you use autoallocate ?
> > It seems difficult to me to use uniform size with Peoplesoft ...
> >
> > Any performance improvement ?
> >
> > I have a LMT database but it's not in production yet.

-----Original Message-----
From: David Kurtz [mailto:david.kurtz@...]
Sent: Thursday, 20 February, 2003 10:58 PM
To: psftdba@yahoogroups.com
Subject: PeopleSoft DBA Forum Some limited experience with PeopleSoft/Oracle database with LMT

Hello

I haven't recreated PeopleSoft delivered tables as LMTs in a production
environment, but that is mainly due to not getting there early enought.

I have experimented with LMTs on a demo database.  All the PS delivered
tablespaces were created as LMT with autoallocate - so the segments are
sized as 64K, 1M and 8M.  Even A PeopleSoft HR database delivered several
thousand tables, Financials is over 10000!  Many of these tables will be
empty.  The resultant demo database will be larger, but I am fairly sure
that if this was done in a real database there would not be any additional
space overhead, there might even be a saving.

The problem is that PeopleSoft chooses all sorts of sizes for its tables,
and with the continual flow of updates causing tables to be altered by
recreation (which you should always do in production to avoid chaining) you
end up with free space fragments scattered through the tablespace.  In an
LMT the spaces will be of a uniform size (3 uniform sizes for autoallocate)
or multiples thereof, so they are more likely to be reused.  In Financials
especially, this effect is magnified by the use of temporary working storage
tables which grow, and if you are attentive are periodically truncated, thus
dropping all but the first extent in the object.

In a dictionary managed tablespace continguous free space extents may be
reported separately on DBA_FREE_SPACE, and so may be reused separately
unless the free space is coalesced.  This can actually promote fragmentation
of free space.

Jonathan Lewis generally recommends using a uniform extent size over
autoallocate because you can then redistribute the tables into different
tablespaces with different uniform extents sizes.  This is probably a better
approach, but if you want to retain the PS tablespace model then I think you
are probably forced into autoallocate for at least the xxAPP tablespaces.
You might choose a uniform extent size for some of the xxLARGE tablespaces.

(Since I have mentioned Jonathan his website is well worth a look -
www.jlcomp.demon.co.uk)

The best part of this is that you don't have to do anything to PeopleSoft in
order to implement LMTs.  Although the PS DDL will have a storage clause
specify in initial, next etc this will be SILENTLY ignored by Oracle when
the tablespace is LM.  Note that if you use SETTABLE.sqr and SETINDEX.sqr to
backport the storage options from USER_TABLES and USER_INDEXES back into the
PeopleTools tables, the storage values in Oracle will be NULL and they will
become 0 in the PeopleSoft database.  Storage options on at least user
specified indexes will be moved to the target database during an upgrade and
if you are upgrading from database with LMTs to a database without LMTs the
index create may fail with an invalid storage clause.  So, you might choose
to comment the storage clause out of the PS DDL model just to be on the safe
side.

I have used LMTs on two Global Payroll projects where I introduced new
tablespaces.  The GP result tables become very large and so I partitioned
them to match the GP streams.  So at one site we have 30 payroll streams (ie
there are 30 payroll calculation processes running in parallel) and each
stream corresponds to one of 30 partitions.  I created two new tablespaces
for each stream (one for tables, and one for indexes).  The indexes are
locally partitioned.  Partition 1 of each table goes into the same
tablespace, etc.  All the new tablespaces are locally managed with uniform
extent sizes of 20M.  This was chosen because some of the partitions were
expected to reach several hundred Mb.



_________________________
David Kurtz
Go-Faster Consultancy Ltd.
phone: +44 7771 760660
fax: +44 7092 348865
mailto:david.kurtz@...
web: www.go-faster.co.uk
sms: sms@...
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> Message: 1
>    Date: Wed, 19 Feb 2003 14:40:43 -0000
>    From: "Henry Poras <hporas@...>" <hporas@...>
> Subject: Re: Any experience with a Oracle database with Loc. Managed
Tablespaces ?
>
> LMTs really add more to ease of administration rather than a benefit
> in performance. See the following article from Jonathan Lewis
> http://www.dbazine.com/jlewis8.html
> Henry
>
> --- In psftdba@yahoogroups.com, "litbighor <lehuyluan@h...>"
> <lehuyluan@h...> wrote:
> > Hi,
> >
> > I would like to have feedback/experience about PS with a
> > Oracle database with Loc. Managed Tablespaces ?
> >
> > Do you use autoallocate ?
> > It seems difficult to me to use uniform size with Peoplesoft ...
> >
> > Any performance improvement ?
> >
> > I have a LMT database but it's not in production yet.




To unsubscribe from this group, send an email to:
psftdba-unsubscribe@yahoogroups.com

The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd. http://www.go-faster.co.uk

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Ken, as of today pt 8.1.8 with OS of AIX 4.3.3  Go to PeopleSoft connection
and check the DBMS certification list.

If you don't mind, send me all the scripts that you have for standby db.

Also may I email you in the future, asking questions on the how to's.

Thanks

Ron

***********************************************************************
Ron Cetnar
Supervising Programmer/Analyst/Oracle DBA
University Applications Development

State University of New York at Albany
MSC 100
1400 Washington Ave
Albany, NY 12222

Email: rcetnar@...
Work: (518) 437-4535
Fax:   (518) 437-4540

***********************************************************************


-----Original Message-----
From: Ken Warren [mailto:ken.warren@...]
Sent: Thursday, February 20, 2003 6:03 AM
To: psftdba@yahoogroups.com
Subject: RE: PeopleSoft DBA Forum Data Guard / Standby Database


Data Guard / Standby DatabaseRon,
good morning ( uk time ).

We run peoplesoft 8.18 on AIX 4.3.3 using oracle 8.1.7.4. We have a server
running oracle/peoplesoft and another with the ( apache ) webserver on.
This is then duplicated for the development environment where I've bolted
on the standby environment.

I've implemented a standard oracle 'managed recovery' standby environment
( using log_archive_dest_N and log_archive_dest_state_N initSID
parameters). It works very well and is simple to implement and support. We
run the database under a different unix account to the application domain
so additionally, I use the 'rdist' command to keep the application domain
in line between the two servers. Finally, I use rdist to keep the web
servers in line too ( a.k.a the cache mainly ).

We run a simple check 'select max(recid) from v$log_history'; on the
standby every so many hours to check if the 'last log applied' number has
increased. Sending an email out if it hasn't.
If you want any scripts just ask.

At the time I was under the impression that dataguard was a 9i product so
I didn't even look into it.
It comes down to the business needs of course. We can manage with email
alerts for the standby database. We've done three standby tests including
running for 2 full days on the standby environment while some hardware
upgrades were performed on the production system.

A question for yourself Ron, what peoplesoft version is 9iR2 supported
with ?

Regards
Ken.
   -----Original Message-----
   From: Ron Cetnar [mailto:rcetnar@...]
   Sent: Wednesday, February 19, 2003 4:40 PM
   To: 'psftdba@yahoogroups.com'
   Subject: PeopleSoft DBA Forum Data Guard / Standby Database


   Just wondering if anyone is using Data Guard or standby database with
   PeopleSoft.  We are interested if there are problems or pitfalls in
using
   the above two.  We are currently running Oracle 8.1.7.3 with PS8/PT8.1.8
on
   Higher Ed.  We're going to Oracle 9iR2 in the near future.

   Thanks

   Ron Cetnar

   Oracle DBA
   SUNY Albany
   rcetnar@...




   ***********************************************************************
   Ron Cetnar
   Supervising Programmer/Analyst/Oracle DBA
   University Applications Development

   State University of New York at Albany
   MSC 100
   1400 Washington Ave
   Albany, NY 12222

   Email: rcetnar@...
   Work: (518) 437-4535
   Fax:   (518) 437-4540

   ***********************************************************************


         Yahoo! Groups Sponsor
               ADVERTISEMENT




   To unsubscribe from this group, send an email to:
   psftdba-unsubscribe@yahoogroups.com

   The PeopleSoft DBA Forum is managed by Go-Faster Consultancy Ltd.
http://www.go-faster.co.uk

   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.