We are hitting the alert from like "AutoExtended is in WARNING. Value is: 1.00" for on tablespace , but we have the sufficient space in tablespace and the OS mount point. It seemeent ,the Patrol agent is running and it's causing these alert to generate. I would appreciate , if you could offer your opinion , as on what basis , the Patrol is throwing these warning. is it file nearing to max size or something else.
++++++++++ Tablespace Status +++++++
TABLESPACE ACT_SIZE FREE_MB %FREE USED_MB %USED LARGEST_EXTENT_MB
------------------------- ------------- ------------- ---------- ------------- ------- -----------------
EFX_DATA 37,524.00 7,731.75 20.6048129 29,792.25 79.40 3,968.00
++++++++++++++++++++++++++
+++ All DBF in auto mode ++++++++
FILE_NAME BYTES/1024/1024 AUT
----------------------------------------------------------------- --------------- ---
/pefx1_devs/pefx1.efx_data.dev01.dbf 10000 YES
/pefx1_devs/pefx1.efx_data.dev02.dbf 8892 YES
/pefx1_devs/pefx1.efx_data.dev03.dbf 8392 YES
/pefx1_devs/pefx1.efx_data.dev04.dbf 10240 YES
+++++ DDL ++++++
CREATE TABLESPACE "EFX_DATA" DATAFILE
'/pefx1_devs/pefx1.efx_data.dev01.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10000M,
'/pefx1_devs/pefx1.efx_data.dev02.dbf' SIZE 1048576000
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10000M,
'/pefx1_devs/pefx1.efx_data.dev03.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10000M,
'/pefx1_devs/pefx1.efx_data.dev04.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10000M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DATAFILE
'/pefx1_devs/pefx1.efx_data.dev01.dbf' RESIZE 10485760000
ALTER DATABASE DATAFILE
'/pefx1_devs/pefx1.efx_data.dev02.dbf' RESIZE 9323937792
ALTER DATABASE DATAFILE
'/pefx1_devs/pefx1.efx_data.dev03.dbf' RESIZE 8799649792
ALTER DATABASE DATAFILE
'/pefx1_devs/pefx1.efx_data.dev04.dbf' RESIZE 10737418240
+++++++