on 05-20-2016 5:07 AM
Hi Experts,
I have so many doubts regarding tablespace.
Can someone please explain what is PSAPUNDO and PSAPSR3 in table space?
what does it mean by reaching 100%?
What causes the table sapce to increase?
Please explain.
Thanks in advance
Hi Abhishek,
A database is divided into logical storage units called tablespaces, which group together related logical structures (such as tables, views, and other database objects). For example, all application objects can be grouped into a single tablespace to simplify maintenance operations.
A tablespace consists of one or more physical datafiles. Database objects assigned to a tablespace are stored in the physical datafiles of that tablespace.
The tablespace PSAP<SID> is the standard tablespace where transparent tables are saved (big chunk of tables and indexes)
If your PSAPSR3 table sapce is 100% then your DB will creash automatically. If you want to avoid this, we have to add the datailes to tablespace.
PSAPUNDO: Oracle standard and it is simply the information stored by Oracle to rollback or undo changes to the databaseinformation. Every database must have an undo tablespace. If this table is full then your jobs will fail.
If you want to avoid theh issues you have to extedn the table sapce.
For UNDO:
How To Extend Table space on oracle:
http://scn.sap.com/docs/DOC-29484.
Regards,
Krishnaiah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Please refer to SAP note - 355771 (Oracle explanation of new table space layouts)
Shubham
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What is the purpose of tablespace PSAPSR3USR .?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.