Monday, April 25, 2011

Insignificant Payroll Run Results

Oracle Payroll process posts lot of data to database for each payroll run. This data grows exponentially as number of employees & number of payroll runs grow. Generally pay_run_results and pay_run_result_values are the tables which take most of the data during payroll run. As these tables grow, they start to cause performance degradation in processes/queries involving these tables. Oracle provides couple of different options to keep number of rows to minimum in these tables:





  1. Use "Suppress insignificant indirect results " pay action parameter to not create any zero or null indirect results. Oracle also provides a patch "5744549" to purge existing null or zero indirect results. I have seen around 17% savings in pay_run_results table and 26% savings in payr_run_result_values table after implementing this solution.


  2. You can also enable sparse matrix for specific legislation to not create some null indirect or direct run results. Oracle also provides a process to purge existing data eligible to to be purged by sparse matrix option. This process mainly supresses null data rows. I have seen additional 26% savings in pay_run_result_values table


Overall implementing one or both options will reduce payroll run results and slows down the growth of the tables over the time. By implementing both solutions, i have seen 17% savings in pay_run_results table & 45% savings in pay_run_result_values table.

14 comments:

  1. Anonymous1:21 AM

    It's very trouble-free to find out any topic on net as compared to books, as I found this paragraph at this website.
    My web page - Xxx Tube

    ReplyDelete
  2. Anonymous12:23 AM

    Usually I don't learn article on blogs, but I would like to say that this write-up very pressured me to take a look at and do so! Your writing taste has been surprised me. Thank you, very great article.
    My site > teenpornpost

    ReplyDelete
  3. Anonymous4:19 PM

    Hi i am kavin, its my first occasion to commenting anywhere, when i read this piece of writing i thought i could also create comment
    due to this brilliant post.
    Feel free to surf my homepage ... webcam sex

    ReplyDelete
  4. Anonymous6:09 PM

    Hiya very nice web site!! Guy .. Excellent .
    . Wonderful .. I'll bookmark your site and take the feeds also? I'm glad to seek out numerous useful info
    here within the publish, we want work out extra strategies on this regard,
    thank you for sharing. . . . . .
    My weblog ; http://www.crazyteenpics.com/shyla-jennings-riding-a-sybian-1-minute-trailer/2241

    ReplyDelete
  5. Anonymous4:36 AM

    I’m not that much of a internet reader to be honest but your
    blogs really nice, keep it up! I'll go ahead and bookmark your website to come back later. Cheers
    Also see my web page - teen sex videos

    ReplyDelete
  6. Anonymous10:07 PM

    Wow, awesome blog layout! How lengthy have you been running a blog for?
    you made blogging look easy. The overall look of your website is fantastic, as well as the content!


    Also visit my homepage: www.sexykoo.com

    ReplyDelete
  7. Anonymous12:29 PM

    If you want to obtain a good deal from this post then you have to apply such techniques to your won
    blog.

    Check out my web blog; www.daily-wet-tshirt.com

    ReplyDelete
  8. Anonymous11:45 PM

    Good day! I could have sworn I've been to this website before but after browsing through some of the articles I realized it's new to me.
    Anyways, I'm definitely pleased I found it and I'll be book-marking it and
    checking back regularly!

    My web site ... docs.oxwall.org

    ReplyDelete
  9. Anonymous8:26 AM

    I know this if off topic but I'm looking into starting my own weblog and was wondering what all is required to get set up? I'm assuming having
    a blog like yours would cost a pretty penny? I'm not very internet smart so I'm not 100% positive.
    Any suggestions or advice would be greatly appreciated. Thank you

    Also visit my webpage ... Code Psn Gratuit [dailymotion.com]

    ReplyDelete
  10. Anonymous11:19 PM

    Howdy! This post couldn't be written any better! Going through this article reminds me of my previous roommate! He continually kept preaching about this. I will forward this article to him. Fairly certain he'll have a good read.
    Thank you for sharing!

    my webpage - free online slot machines

    ReplyDelete
  11. Anonymous7:17 PM

    This info is priceless. When can I find out more?


    My homepage - nummerupplysningen - barneyfra.ireallylikefood.com -

    ReplyDelete
  12. Anonymous7:06 PM

    I really like what you guys tend to be up too. This type of clever work and exposure!
    Keep up the good works guys I've you guys to our blogroll.

    Review my blog post; Jackpot 6000

    ReplyDelete
  13. For best oracle hrms training, Check this site for trainings on emerging IT courses . Go here if you’re looking for training on Oracle Hrms.

    ReplyDelete
  14. helpful web site, concerning guidance along with oracle hrms, Check this site for indepth Oracle HRMSTraining Go here if you’re looking for information on Oracle HRMS Training

    ReplyDelete