| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: peoplesoft HRMS users
--0__=FJTaukZ03jNLDZNZ1fBnLybIZD6oGhFKGllETd5W4uL6yJPqqR7Aj0Vw
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
Oops ... After reading Chuck Hamiliton's response, I realized I should have been more specific: PS_PAY_CHECK migrates alot of rows, PSACTIVITYMAP, PSBUSPROCMAP and PSHOMEPAGEMAP have chained rows even with an 8k block size.
Robyn
---------------------- Forwarded by Robyn Sands/US1/Lend Lease on 07/31/2000 02:51 PM ---------------------------
To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: peoplesoft HRMS users (Document link not converted)
Jeffrey,
PS_PAY_CHECK definitely chains - alot. We had over 4000 chained rows in a two month period, and this is a fairly small PeopleSoft installation. I'm still experimenting with various setting of pctfree and pctused, so I don't have an answer yet. Our average row length is 266, so it's not a block size issue, although there are three PeopleSoft tables that will chain even with an 8k block size. (You probably already knew that, but since the question was asked in the thread, I included the info.)
I just rebuilt the table this weekend, increased pctfree to 30, and decreased pctused to 60. If the amount of chaining decreases, I'll let you know, and if you find a setting that works, please pass it on.
Robyn
Siva_Chintalapati <Siva_Chintalapati_at_satyam.com> on 07/31/2000 10:56:16 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Robyn Sands/US1/Lend Lease)
Subject: RE: peoplesoft HRMS users
How do we know that it is chaining.
Regards
Siva
> ----------
> From: Cale, Rick T (Richard)[SMTP:RICHARD.T.CALE_at_saic.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, July 31, 2000 7:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: peoplesoft HRMS users
>
> What is your block size and avg row length of the ps_pay_check table. Is
> the length > block size?
>
> > -----Original Message-----
> > From: Jeffrey Beckstrom [SMTP:JBECKSTROM_at_gcrta.org]
> > Sent: Monday, July 31, 2000 9:15 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: peoplesoft HRMS users
> >
> > I have increased pctfree on the ps_pay_check table to 27 but still get
> > chaining. What have others used to stop the chaining.
> >
> > --
> > Author: Jeffrey Beckstrom
> > INET: JBECKSTROM_at_gcrta.org
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jul 31 2000 - 13:57:18 CDT
 |
 |