Autonomous database defragmentation

A non-transitory, computer-readable medium having instructions stored thereon that are capable of being executed by a server system to cause operations comprising:

• autonomously performing defragmentation operations for one or more of a plurality of tablespaces in a database, including by:
• selecting a first tablespace, of the plurality of tablespaces, to defragment, wherein the first tablespace includes a first plurality of index objects;
• creating a new first tablespace that is at least a same size as an in-use portion of the first tablespace;
• prior to rebuilding the first plurality of index objects in the new first tablespace, creating a journal table for recording data modification operations performed on the first tablespace while performing the defragmentation operations on the first tablespace;
• rebuilding the first plurality of index objects, from the first tablespace, in the new first tablespace such that the rebuilt first plurality of index objects are stored in the new first tablespace without fragmentation;
• while performing the defragmentation operations on the first tablespace, servicing a data access request associated with at least one of the first plurality of index objects;
• and
• reclaiming storage space used to store at least a portion of the first tablespace.

A method, comprising:

• autonomously performing, by a computer system, defragmentation operations on one or more of a plurality of tables stored in a database, including by:
• based on fragmentation information corresponding to the plurality of tables, selecting a first table, of the plurality of tables, to defragment;
• prior to copying data from the first table to an interim table, creating a materialized view log based on the first table such that, for a given one of one or more data modification operations serviced while performing the defragmentation operations on the first table, a corresponding entry is created in the materialized view log;
• copying the data from the first table to the interim table such that the interim table is stored in the database without the fragmentation of the first table;
• monitoring the database to determine whether to interrupt the defragmentation operations on the first table;
• while performing the defragmentation operations on the first table, servicing one or more requests to perform a data modification operation on the first table;
• and
• subsequent to copying the data from the first table to the interim table, reclaiming storage space used to store the first table.