Skip to Content
avatar image
Former Member

Table shows 100% in DB02 (Prod)

Dear all,

In production one of the Table space shows 100% .

Pls check below DB02 details :

Table space name "PSAPSR3

Size (MB)=199,080.00

free (MB)84.19

used % =100%

Auto extend =YES

Total Space(MB)=200,000.00

Sum of all free fregments (MB)=1,004.19

Total USed % =99

Files =20

Segments=157,305

226,157

ONLINE

PERMANENT

Kindl

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 03, 2010 at 07:27 AM

    Hi,

    Extend the table space using brtools.

    Thanks

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 03, 2010 at 07:56 AM

    Hi,

    yes, you have to extend the existing Tablespace (PSAPSR3)

    OR

    you can add one more datafile and add that to the PSAPSR3 tablespace

    refresh DB02

    regards

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 03, 2010 at 12:48 PM

    I am locking this.

    basic training would cover this.

    go get training.

    Add comment
    10|10000 characters needed characters exceeded