Skip to Content
0
Aug 01, 2012 at 06:40 AM

To extend Tablespace

224 Views

Hi,

In one of our production system, the tablespace size of one of the tablespace named as PSAPSR3 is showing as 94.

If we check it in DB02 -> tablespace -> overview -> main data , the information is as below -

Tablespace name PSAPSR3

Size(MB) 58,600.00

Free(MB) 3,801.81

Used(%) 94

Autoextend YES

Total size considering Autoextend(MB) 66,000.00

Total free space considering Autoextend( 11,201.81

Total used (%) 83

Number of datafiles 16

Number of Segments 74,338

Number of Extents 141,021

Status ONLINE

Contents PERMANENT

Default table compression DISABLED

Compression for operation type n.a.

Tablespace encryption n.a.

Tablespace encryption algorithm n.a.

While i we check in Data/Temp files for these tablespace, there are data1,2,....16 files are there

for data 1 to 6 information is as follows

File name /oracle/BID/sapdata3/sr3_5/sr3.data5

File Id 17

Tablespace name PSAPSR3

Size(MB) 4,180.00

Number of blocks 535,040

Status AVAILABLE

Relative file number 17

Autoextensible YES

Maxsize(MB) 6,000.00

Maxblocks 768,000

Increment by 2,560

User size(MB) 4,179.94

User blocks 535,032

For data 7 to 16, information is as follows

File name /oracle/BID/sapdata3/sr3_14/sr3.data14

File Id 26

Tablespace name PSAPSR3

Size(MB) 2,000.00

Number of blocks 256,000

Status AVAILABLE

Relative file number 26

Autoextensible NO

User size(MB) 1,999.94

User blocks 255,992