I want to write a PL/SQL script to query index statistics data and update tracking entries.

Question

I have created a table: INDEX_SIZE_TRACKING with the following attributes:

• Index Name: name of the index. Type: VARCHAR(255). This is the primary key of the table.

• Allocated Space: the memory space (in bytes) allocated to the index. Type: NUMBER

• Used Space: the memory space used by the index. Type: NUMBER

• Last Update: the time when index details are updated to this table. Type: VARCHAR(255)

I want to write a PL/SQL script to query index statistics data and update tracking entries in the INDEX_SIZE_TRACKING table. If there is no existing entry for the index, create a new one; otherwise, update the existing one. Can I please have a PL/SQL statement that can do this in oracle XE? Thanks in advance! :-)