RE: peoplesoft HRMS users

--0__=btMqMotxPbMpaJTYoYiw8nxKVhkjkrLSe6RqiQ3u2jWnNolZAWE1JtQ1 Content-type: text/plain; charset=us-ascii Content-Disposition: inline

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).
>

--0__=btMqMotxPbMpaJTYoYiw8nxKVhkjkrLSe6RqiQ3u2jWnNolZAWE1JtQ1 Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PXVzLWFzY2lpIj4NCjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0i TVMgRXhjaGFuZ2UgU2VydmVyIHZlcnNpb24gNS41LjI2NTAuMTIiPg0KPFRJVExFPlJFOiBwZW9w bGVzb2Z0IEhSTVMgdXNlcnM8L1RJVExFPg0KPC9IRUFEPg0KPEJPRFk+DQoNCjxQPjxGT05UIENP TE9SPSIjMDAwMEZGIiBTSVpFPTIgRkFDRT0iQXJpYWwiPkhvdyBkbyB3ZSBrbm93IHRoYXQgaXQg aXMgY2hhaW5pbmcuPC9GT05UPg0KPEJSPjxGT05UIENPTE9SPSIjMDAwMEZGIiBTSVpFPTIgRkFD RT0iQXJpYWwiPlJlZ2FyZHM8L0ZPTlQ+DQo8QlI+PEZPTlQgQ09MT1I9IiMwMDAwRkYiIFNJWkU9 MiBGQUNFPSJBcmlhbCI+U2l2YTwvRk9OVD4NCjwvUD4NCjxVTD4NCjxQPjxGT05UIFNJWkU9MSBG QUNFPSJNUyBTYW5zIFNlcmlmIj4tLS0tLS0tLS0tPC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9 MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5Gcm9tOjwvRk9OVD48L0I+ICZuYnNwOyA8Rk9OVCBTSVpF PTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+Q2FsZSwgUmljayBUIChSaWNoYXJkKVtTTVRQOlJJQ0hB UkQuVC5DQUxFQHNhaWMuY29tXTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMg U2FucyBTZXJpZiI+UmVwbHkgVG86PC9GT05UPjwvQj4gJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7IDxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5PUkFDTEUtTEBmYXRjaXR5 LmNvbTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+U2Vu dDo8L0ZPTlQ+PC9CPiAmbmJzcDsgPEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPk1v bmRheSwgSnVseSAzMSwgMjAwMCA3OjM1IFBNPC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9MSBG QUNFPSJNUyBTYW5zIFNlcmlmIj5Ubzo8L0ZPTlQ+PC9CPiAmbmJzcDsmbmJzcDsmbmJzcDsgPEZP TlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPk11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlz dCBPUkFDTEUtTDwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJp ZiI+U3ViamVjdDo8L0ZPTlQ+PC9CPiAmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgPEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPlJFOiBwZW9wbGVzb2Z0IEhSTVMg dXNlcnM8L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+V2hhdCBp cyB5b3VyIGJsb2NrIHNpemUgYW5kIGF2ZyByb3cgbGVuZ3RoIG9mIHRoZSBwc19wYXlfY2hlY2sg dGFibGUuJm5ic3A7IElzPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+dGhl IGxlbmd0aCAmZ3Q7IGJsb2NrIHNpemU/PC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpFPTIg RkFDRT0iQXJpYWwiPiZndDsgLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS08L0ZPTlQ+DQo8QlI+ PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7IEZyb206IEplZmZyZXkgQmVja3N0cm9tIFtT TVRQOkpCRUNLU1RST01AZ2NydGEub3JnXTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0i QXJpYWwiPiZndDsgU2VudDogTW9uZGF5LCBKdWx5IDMxLCAyMDAwIDk6MTUgQU08L0ZPTlQ+DQo8 QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7IFRvOiZuYnNwOyZuYnNwOyBNdWx0aXBs ZSByZWNpcGllbnRzIG9mIGxpc3QgT1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZB Q0U9IkFyaWFsIj4mZ3Q7IFN1YmplY3Q6Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IHBl b3BsZXNvZnQgSFJNUyB1c2VyczwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwi PiZndDsgPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyBJIGhhdmUg aW5jcmVhc2VkIHBjdGZyZWUgb24gdGhlIHBzX3BheV9jaGVjayB0YWJsZSB0byAyNyBidXQgc3Rp bGwgZ2V0PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyBjaGFpbmlu Zy4mbmJzcDsgV2hhdCBoYXZlIG90aGVycyB1c2VkIHRvIHN0b3AgdGhlIGNoYWluaW5nLjwvRk9O VD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDsgPC9GT05UPg0KPEJSPjxGT05U IFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyAtLSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZB Q0U9IkFyaWFsIj4mZ3Q7IEF1dGhvcjogSmVmZnJleSBCZWNrc3Ryb208L0ZPTlQ+DQo8QlI+PEZP TlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7Jm5ic3A7Jm5ic3A7IElORVQ6IEpCRUNLU1RST01A Z2NydGEub3JnPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyA8L0ZP TlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7IEZhdCBDaXR5IE5ldHdvcmsg U2VydmljZXMmbmJzcDsmbmJzcDsmbmJzcDsgLS0gKDg1OCkgNTM4LTUwNTEmbmJzcDsgRkFYOiAo ODU4KSA1MzgtNTA1MTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDsg U2FuIERpZWdvLCBDYWxpZm9ybmlhJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7IC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPC9GT05UPg0K PEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyAtLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvRk9OVD4NCjxC Uj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDsgVG8gUkVNT1ZFIHlvdXJzZWxmIGZyb20g dGhpcyBtYWlsaW5nIGxpc3QsIHNlbmQgYW4gRS1NYWlsIG1lc3NhZ2U8L0ZPTlQ+DQo8QlI+PEZP TlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7IHRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90 ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48L0ZPTlQ+DQo8QlI+PEZPTlQg U0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7IHRoZSBtZXNzYWdlIEJPRFksIGluY2x1ZGUgYSBsaW5l IGNvbnRhaW5pbmc6IFVOU1VCIE9SQUNMRS1MPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNF PSJBcmlhbCI+Jmd0OyAob3IgdGhlIG5hbWUgb2YgbWFpbGluZyBsaXN0IHlvdSB3YW50IHRvIGJl IHJlbW92ZWQgZnJvbSkuJm5ic3A7IFlvdSBtYXk8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZB Q0U9IkFyaWFsIj4mZ3Q7IGFsc28gc2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZv cm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZykuPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBTSVpF PTIgRkFDRT0iQXJpYWwiPi0tIDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwi PkF1dGhvcjogQ2FsZSwgUmljayBUIChSaWNoYXJkKTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIg RkFDRT0iQXJpYWwiPiZuYnNwOyBJTkVUOiBSSUNIQVJELlQuQ0FMRUBzYWljLmNvbTwvRk9OVD4N CjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5GYXQgQ2l0eSBOZXR3b3JrIFNl cnZpY2VzJm5ic3A7Jm5ic3A7Jm5ic3A7IC0tICg4NTgpIDUzOC01MDUxJm5ic3A7IEZBWDogKDg1 OCkgNTM4LTUwNTE8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5TYW4gRGll Z28sIENhbGlmb3JuaWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg LS0gUHVibGljIEludGVybmV0IGFjY2VzcyAvIE1haWxpbmcgTGlzdHM8L0ZPTlQ+DQo8QlI+PEZP TlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpF PTIgRkFDRT0iQXJpYWwiPlRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9tIHRoaXMgbWFpbGluZyBsaXN0 LCBzZW5kIGFuIEUtTWFpbCBtZXNzYWdlPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJB cmlhbCI+dG86IExpc3RHdXJ1QGZhdGNpdHkuY29tIChub3RlIEVYQUNUIHNwZWxsaW5nIG9mICdM aXN0R3VydScpIGFuZCBpbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPnRo ZSBtZXNzYWdlIEJPRFksIGluY2x1ZGUgYSBsaW5lIGNvbnRhaW5pbmc6IFVOU1VCIE9SQUNMRS1M PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+KG9yIHRoZSBuYW1lIG9mIG1h aWxpbmcgbGlzdCB5b3Ugd2FudCB0byBiZSByZW1vdmVkIGZyb20pLiZuYnNwOyBZb3UgbWF5PC9G T05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+YWxzbyBzZW5kIHRoZSBIRUxQIGNv bW1hbmQgZm9yIG90aGVyIGluZm9ybWF0aW9uIChsaWtlIHN1YnNjcmliaW5nKS48L0ZPTlQ+DQo8 Received on Mon Jul 31 2000 - 10:30:12 CDT