hello I have a table FCM PARTITIONED ON (Q) Column BY RANGE INTERVAL( NUMTODSINTERVAL(7, 'DAY'))

i have an issue that "current/active" partition becomes stale several times a day
vast majority of DMLs on the table are INSERTS (basic inserts , with values , something like insert into table values :1 :2 )

while we do have a maintenance window , it is scheduled at night time , so during day we often have Stale statistics for current/active partition

here are the questions :
1.
is there any optimal way (something like trigger ) so that i can gather statistics on the partition AS SOON as it becomes stale ,

while it is possible to schedule a manual job to check for stale partitions , it still leaves the window between jobs , where partition can become stale , i dont really like the idea of a job running every 20 minutes , but as a last resort it can also be done .

create table t1 (
  id           number,
  my_varchar2  varchar2(50)
);

insert /*+ append */ into t1 (id, my_varchar2)
select level, 'some data ' || level
from   dual
connect by level <= 5000;
commit;

select table_name,
       num_rows,
       notes
from   user_tab_statistics
where  table_name = 'T1';

TABLE_NAME   NUM_ROWS NOTES
---------- ---------- -------------------------
T1               5000

insert into t1
select level+5000,
       'more data ' || level || level
from   dual
connect by level <= 1000;
commit;

select table_name,
       num_rows,
       notes
from   user_tab_statistics
where  table_name = 'T1';

TABLE_NAME   NUM_ROWS NOTES
---------- ---------- -------------------------
T1               5000
T1               6000 STATS_ON_CONVENTIONAL_DML