Mastering the Oracle Stack, One Post at a Time.
Biju For a long time, I searched for a comprehensive list of housekeeping jobs [Standard EBS jobs provided by Oracle] that should be scheduled periodically on the EBS instance. Since I could not find a single source, came up with my own after a lot of reading… There may be more, but these should be scheduled on the … Read more
Earlier, provided a small script to find the maximum growable size of a tablespace… Here is little more comprehensive script that shows more tablespace space info. Current size, growable size based on the autoextensible data files, free space, biggest chunk…All size is in MB. SELECT a.tablespace_name TSNAME, ROUND(SUM(a.growable)/1048576) growable, … Read more