Reply from bmacmillan on Mar 4 at 8:51 AM Ok, thank you. That does help, but I still don't understand why I need to manually add datafiles to this (PSAPUNDO) tablespace, but I don't have to add datafiles to any of the other tablespaces.
I was under the impression that the AUTOEXTEND would do that for me, but as you said, that pertains to the datafiles within the tablespace.
Is there an option I'm missing that allows datafiles to be added automatically?
| | | ---------------Original Message---------------
From: bmacmillan
Sent: Thursday, March 03, 2016 9:27 AM
Subject: Proper Usage/Configuration Of PSAPUNDO
Good morning,
I hope someone can help me with some advice.
A while back, we started having issues in SAP, and traced it back to the PSAPUNDO tablespace being full.
Since then, we have been monitoring it, and adding datafiles as needed,
I now have a bit more time to look into this properly, and I discovered that when the PSAPUNDO tablespace was initially created (when we went live with ECC 6.0), the consultant created the datafiles using the "autoextend" option.
See below:
CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 20000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 32700M
Sat Apr 12 17:21:40 2014
[21306] Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 20000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 32700M
ALTER TABLESPACE PSAPUNDO ADD DATAFILE
'/oracle/PRD/sapdata2/undo_2/undo.data2' SIZE 32000M AUTOEXTEND ON NEXT 20M MAXSIZE 32700M,
'/oracle/PRD/sapdata3/undo_3/undo.data3' SIZE 32000M AUTOEXTEND ON NEXT 20M MAXSIZE 32700M,
'/oracle/PRD/sapdata4/undo_4/undo.data4' SIZE 32000M AUTOEXTEND ON NEXT 20M MAXSIZE 32700M
Now, when we first experienced the issues, we added new datafiles without using the "autoextend" option (we didn't know any better), but when I added the last 4, I started using the option again:
My question is - what, exactly, does the autoextend option do for us?
I was under the impression that this would ensure that datafiles would get added automatically, as required. But, if that is the case, why did we all of a sudden start to need to add datafiles, given the manner in which our consultant created the initial datafiles within PSAPUNDO?
Note that we have never needed to add datafiles, manually, to any of the other tablespaces - they have been added automatically, as we'd expect.
Please explain, if you can. Or, let me know if you need more information.
Thanks,
Bruce
. |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.    _.____.__ |
