PCTFREE/PCTUSED的最佳值是多少? [英] What is the Optimum value for PCTFREE/PCTUSED?

问题描述

在Oracle中特定表上的频繁更新的情况下，在表级和主键索引级上PCTFREE/PCTUSED的最佳值是什么?

感谢支持的参数.

解决方案

通常，除非您知道自己在做什么，否则不应该更改这些值.

阅读以下内容:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2556828000346627752

http://www.careerride.com/Oracle-DBA- what-are-PCT-Free-and-PCT-used.aspx [ http://www.orafaq.com/forum/t/39063/2/ [ ^ ]

In case of frequent updates on a specific table in Oracle, what is the optimum value for PCTFREE/PCTUSED at both Table-Level and Primary Key Index-Level?

Supporting arguments are appreciated.

解决方案

Generally you should not be changing these values unless you know what you are doing.

Read the following :

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2556828000346627752

http://www.careerride.com/Oracle-DBA-what-are-PCT-Free-and-PCT-used.aspx[^]

http://www.orafaq.com/forum/t/39063/2/[^]

这篇关于PCTFREE/PCTUSED的最佳值是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！