#2082

DECLARE

NB_UNLOCKED PLS_INTEGER := 0;
 
CURSOR C_TBL IS
    SELECT FILE_NAME, TABLESPACE_NAME 
    FROM DBA_DATA_FILES
    WHERE TABLESPACE_NAME LIKE 'AAA%';
 
BEGIN
 
    FOR tbl IN C_TBL LOOP
     
        dbms_output.put_line('Update TABLSPACE '||tbl.FILE_NAME ||''||tbl.TABLESPACE_NAME );
        EXECUTE IMMEDIATE 'ALTER DATABASE DATAFILE '''||tbl.FILE_NAME||''' AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED';
        NB_UNLOCKED := NB_UNLOCKED+1;
     
    END LOOP;
     
    dbms_output.put_line('Nb tablespace updated : '||NB_UNLOCKED );
 
END;

oracle

[How-To] Zabbix [Oracle] SGA /SHMMAX / SHMALL