Wednesday , May 29 2024

How To Resize Datafiles in Oracle


We ensure that unused space in the datafiles are reclaimed by the ASM disk group with the resize process. This ensures that unused areas are reused.

You can find the script below for the resize process:

You need to set the && blksize variable in the query according to the db_block_size parameter of your database.

As a result of the query, the savings column shows the amount of space to be earned. The sql column also specifies the query required for the resize operation.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *