Add Oracle temp tablespace In the AIX System (bare device Mode)

Oracle queries the usage of temporary tablespace:

Select d. TABLESPACE_NAME, SPACE "SUM_SPACE (M)", BLOCKS SUM_BLOCKS,

USED_SPACE "USED_SPACE (M)", ROUND (NVL (USED_SPACE, 0)/SPACE * 100,2) "USED_RATE (% )",

NVL (FREE_SPACE, 0) "FREE_SPACE (M )"

FROM

(SELECT TABLESPACE_NAME, ROUND (SUM (BYTES)/(1024*1024), 2) SPACE, SUM (BLOCKS) BLOCKS

FROM DBA_TEMP_FILES

Group by TABLESPACE_NAME) D,

(SELECT TABLESPACE_NAME, ROUND (SUM (BYTES_USED)/(1024*1024), 2) USED_SPACE,

ROUND (SUM (BYTES_FREE)/(1024*1024), 2) FREE_SPACE

From v $ TEMP_SPACE_HEADER

Group by TABLESPACE_NAME) F

Where d. TABLESPACE_NAME = F. TABLESPACE_NAME (+ );

Oracle migration data table space

Table space management for bare devices on AIX

Oracle creates user tablespaces and users

Test the table space function for Oracle transmission (including detailed procedures)

Add bare devices (logical volumes) for Oracle tablespace In the AIX Environment)

------------------------------------------ Split line ------------------------------------------

It is found that the temp tablespace usage is 99%.

Enter the Operating System (AIX)

# Lsvg

Rootvg

Xyyvg

View vg usage

# Lsvg-l xyyvg

Lv_xyy1521312g raw 48 48 12 open/syncd N/

Lv_xyy152_12g raw 48 12 open/syncd N/

Lv_xyy153_12g raw 48 12 open/syncd N/

Lv_xyy154_12g raw 48 48 12 open/syncd N/

Lv_xyy155_12g raw 48 12 open/syncd N/

Lv_xyy156_12g raw 48 12 open/syncd N/

Lv_xyy157_12g raw 48 12 open/syncd N/

Lv_xyy158_12g raw 48 12 open/syncd N/

Lv_xyy159_12g raw 48 12 open/syncd N/

Lv_xyy160_12g raw 48 12 open/syncd N/

Lv_xyy1621312g raw 48 48 12 closed/syncd N/A (this lv is not used below)

Lv_xyy162_12g raw 48 12 closed/syncd N/

Lv_xyy163_12g raw 48 12 closed/syncd N/

Lv_xyy164_12g raw 48 12 closed/syncd N/

Lv_xyy165_12g raw 48 12 closed/syncd N/

Lv_xyy166_12g raw 48 12 closed/syncd N/

Lv_xyy167_12g raw 48 12 closed/syncd N/

Lv_xyy168_12g raw 48 12 closed/syncd N/

Lv_xyy169_12g raw 48 12 closed/syncd N/

Lv_xyy170_12g raw 48 12 closed/syncd N/

Lv_xyy1721312g raw 48 48 12 closed/syncd N/

Lv_xyy172_12g raw 48 12 closed/syncd N/

Lv_xyy173_12g raw 48 12 closed/syncd N/

Lv_xyy174_12g raw 48 12 closed/syncd N/

Lv_xyy175_12g raw 48 12 closed/syncd N/

Lv_xyy176_12g raw 48 12 closed/syncd N/

Lv_xyy177_12g raw 48 12 closed/syncd N/

Lv_xyy178_12g raw 48 12 closed/syncd N/

Lv_xyy179_12g raw 48 12 closed/syncd N/

1 2 Next Page