Imperva Cyber Community

communities_1.jpg
 View Only
Back to discussions
Expand all | Collapse all

Tablespace SYSAUX filling up!

  • 1.  Tablespace SYSAUX filling up!

    Posted 10-01-2025 02:51

    We have noticed that our SYSAUX table is filling up and is no longer reducing. 

    Does anyone have ideas?


    #On-PremisesWAF(formerlySecuresphere)

    ------------------------------
    Renaz Pirhan
    ------------------------------


  • 2.  RE: Tablespace SYSAUX filling up!

    Posted 10-01-2025 07:48

    Hello Renaz Pirhan, 

    To resolve this issue, you need to re-index a table in the SYSAUX tablespace on the Management Server.

    This re-indexing will rebuild the indexes on the table, making them usable again and improving performance.



    ------------------------------
    Regards,
    𝐌𝐢𝐭𝐞𝐬𝐡 𝐌𝐞𝐡𝐭𝐚
    Senior Security Consultant
    Mumbai
    ------------------------------



  • 3.  RE: Tablespace SYSAUX filling up!

    Posted 10-02-2025 07:37

    Thank you for your feedback.


    Do you have a guide for re-indexing?



    ------------------------------
    Renaz Pirhan
    ------------------------------

    Original Message


  • 4.  RE: Tablespace SYSAUX filling up!

    Posted 10-02-2025 00:44

    we have same issue and we opened the case, imperva support team suggested to increase tablespace for SYSAUX



    ------------------------------
    Rev1
    ------------------------------



  • 5.  RE: Tablespace SYSAUX filling up!

    Posted 10-02-2025 07:39

    Did the support team tell you how to increase the tablespace and whether it will lead to the same problem in a few weeks or months?



    ------------------------------
    Renaz Pirhan
    ------------------------------

    Original Message


  • 6.  RE: Tablespace SYSAUX filling up!

    Posted 10-03-2025 08:40

    As support mentioned that this is bug and not sure which version they will fix . for temp fix you can use auto extend

    EX-

    To increase tablespace for SYSAUX
    ➔ Login to oracle as sysdba and run the following: su - oracle
    ➔ sqlplus / as sysdba
    ➔ ALTER DATABASE DATAFILE '/var/dbstorage/sysaux01.dbf' AUTOEXTEND ON NEXT 2G MAXSIZE 16G;
    This command will auto extend the tablespace with 2GB once the actual SYSAUX tablespace
    is maxed out until it reaches the max size 16GB allocated.



    ------------------------------
    Rev1
    ------------------------------

    Original Message


  • 7.  RE: Tablespace SYSAUX filling up!

    Posted 10-07-2025 13:46
    Edited by SBISOC 4430 10-07-2025 13:59

    Hi Renaz,

    Please open a support case and they will share a workaround (fix_sysaux.sql) which you have to implement manually on all impacted MXs.

    Regards,



    ------------------------------
    SBISOC 4430
    Manager
    Mumbai
    ------------------------------

    Original Message


  • 8.  RE: Tablespace SYSAUX filling up!

    Posted 10-13-2025 03:12

    Hi,

    To be able to compare the steps we have applied to fix the issue, could you possibly send the content of fix_sysaux.sql file. 

    Thank you for your time,

    Kind regards,



    ------------------------------
    Emirhan Ozdemir
    Data Security Consultant
    Secure Future
    Istanbul
    ------------------------------

    Original Message


  • 9.  RE: Tablespace SYSAUX filling up!

    Posted 10-14-2025 07:47

    Hi Emirhan,

    It is better to take assistance from Imperva Support to verify whether the issue is caused by that bug (DM-355) or not.

    Regards,



    ------------------------------
    SBISOC 4430
    Manager
    Mumbai
    ------------------------------

    Original Message


  • 10.  RE: Tablespace SYSAUX filling up!

    Posted 10-05-2025 06:13

    Hello Renax Prihan,

    In earlier versions, there was a known issue related to the SYSAUX table. I recommend upgrading your SecureSphere (SeS) version to resolve it.

    If you require an immediate workaround, please raise a case with Imperva Support, and we'll assist you further.

    Note: Increasing table space or reindexing is not recommended, as it may lead to issues in the future.

    I hope this clarifies the concern.

    KR,
    Raunak



    ------------------------------
    Raunak Tiwari
    ------------------------------



  • 11.  RE: Tablespace SYSAUX filling up!

    Posted 10-06-2025 07:38

    Hello Raunax Twiari, 

    thank you for your feedback. 



    ------------------------------
    Renaz Pirhan
    ------------------------------

    Original Message


  • 12.  RE: Tablespace SYSAUX filling up!

    Posted 10-06-2025 09:30

    please share the SeS version  where this issues is fixed ? 



    ------------------------------
    Rev1
    ------------------------------

    Original Message


  • 13.  RE: Tablespace SYSAUX filling up!

    Posted 10-07-2025 07:21

    We have the same issue and we are running version 14.15 right now. 



    ------------------------------
    Joe C
    PNC Bank
    ------------------------------

    Original Message


  • 14.  RE: Tablespace SYSAUX filling up!

    Posted 10-07-2025 13:43

    Hi Rev1,

    That issue was fixed with the release of DAM 14.16.1.10.

    Regards,



    ------------------------------
    SBISOC 4430
    Manager
    Mumbai
    ------------------------------

    Original Message