Default PCTFREE
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 13 Sep 2023 19:37:11 -0400
Message-ID: <79a013bb-cb90-e7e6-5f9b-e3bc3b1ae01e_at_gmail.com>
I am looking for a way of changing default PCTFREE for a tablespace or, if that is not possible, for the entire DB. My employer is a bank, very heavy on the OLTP side, and developers are creating objects without specifying PCTFREE. Normally, that can be cured by a baseball bat, but I am looking for more elegant and less violent solutions. I am unable to find anything to change the default PCTFREE for a tablespace or for a database. Any suggestion will be appreciated.
https://dbwhisperer.wordpress.com
Date: Wed, 13 Sep 2023 19:37:11 -0400
Message-ID: <79a013bb-cb90-e7e6-5f9b-e3bc3b1ae01e_at_gmail.com>
I am looking for a way of changing default PCTFREE for a tablespace or, if that is not possible, for the entire DB. My employer is a bank, very heavy on the OLTP side, and developers are creating objects without specifying PCTFREE. Normally, that can be cured by a baseball bat, but I am looking for more elegant and less violent solutions. I am unable to find anything to change the default PCTFREE for a tablespace or for a database. Any suggestion will be appreciated.
--
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 14 2023 - 01:37:11 CEST