Partitioning Peoplesoft tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Partitioning Peoplesoft tables

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448

    Partitioning Peoplesoft tables

    Hi

    Has anyone used partitioning in Peoplesoft (v8) tables?

    Cheers

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    ps_proj_resourcce an 80gb little bitty table in PS finacials

    steve
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    I have been using Peoplesoft 8.1.4 very extensively for a very big company is US. The DB size is around 600 GB now.
    There are about 20 big tables partitioned.

    What is up?

    Tamil

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Hi

    A collegue is working with Peoplesoft CRM (The old Vantive), there are a couple of tables which are quite big (around 300 million of rows) and we are thinking to use partitions for these tables. What partitioning options did you guys use? Range, Hash?

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Range Partition.

    Tamil

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    it's been a few months but I think we did range by effective date

    steve
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    ok, will have a look at that column


    cheers

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by stmontgo
    it's been a few months but I think we did range by effective date

    steve
    range partition by month i beleive on effective date.
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width