Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Waelz, Dean on Mar 4 at 4:30 PM Hi Bruce
As per Snowy:
"
for undo_retention, 24 hours seems too high. SAP recommends 12 hours and this still is too high for most systems. to find out how much time is needed, run this command every hour. after a few weeks, use the biggest value +10 %.
select max(maxquerylen) from v$undostat;
"
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/psapundo-size-calculator-1645321
The (more comprehensive) script you mentioned hits that same table but a different element. Maybe check both.
Regards,
| | | ---------------Original Message---------------
From: bmacmillan
Sent: Friday, March 04, 2016 2:10 PM
Subject: Proper Usage/Configuration Of PSAPUNDO
Thanks.
I have seen that note, but it doesn't tell me (unless I'm missing something - possible) how big I should make the tablespace.
Thanks,
Bruce |
| Reply to this email to post your response. __.____._ |    _.____.__ |
