Day: July 9, 2024

ORA-1654: unable to extend index in tablespace

by

From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 2. Check the datafiles size and path present in respective tablespace: 4. Give a Log Switch and monitor the Alert Log:

Command to Check Archivelog Size

by

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are often managed by database administrators. Monitoring the size of archivelogs is essential to ensure optimal database performance and sufficient storage capacity. Here are some ways … Read more