cancel
Showing results for 
Search instead for 
Did you mean: 

What is PSAPUNDO and PSAPSR3?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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:

http://www.databasejournal.com/features/oracle/article.php/3820841/Failures-within-Your-UNDO-Tablesp...

How To Extend Table space on oracle:

http://scn.sap.com/docs/DOC-29484.

Regards,

Krishnaiah

Answers (2)

Answers (2)

Shubham1
Employee
Employee

Hello,

Please refer to SAP note  - 355771 (Oracle explanation of new table space layouts)

Shubham

Former Member
0 Kudos

Hi,

PSAPUNDO: is the tablespace to keep intermediate/non committed transaction in this way it ensures data consistency and read consistency in database system.

PSAPSR3: is the tablespace that hold the actual data of any abap sap system.

Regards

Prithviraj.

SSShrotriya
Discoverer
0 Kudos

What is the purpose of tablespace PSAPSR3USR .?