You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for PCTFREE


1 to 20 of 92 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Specifying the PCTFREE ParameterThe PCTFREE parameter is used to set the percentage of a block to be reserved for possible updates … parameter within a CREATE TABLE statement: PCTFREE 20 This indicates that 20% of each data block … existing rows already within each block. Figure 13-1 illustrates PCTFREE. Figure 13-1 PCTFREE … Description of

Concepts, 10g Release 1 (10.1)

2 Data Blocks, Extents, and Segments

PCTFREE, PCTUSED, and Row ChainingFor manually managed tablespaces, two space management parameters, PCTFREE and PCTUSED, enable you … own data segment). You can also specify the storage parameter PCTFREE when creating or altering an … ( BLOB, CLOB, NCLOB, and BFILE ). They do not use the PCTFREE storage parameter or free lists. See … "Overview of LOB Datatypes"

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Selecting Associated PCTUSED and PCTFREE ValuesIf you decide not to use the default values for PCTFREE or PCTUSED, keep the following guidelines … in mind: The sum of PCTFREE and PCTUSED must be equal to or less than 100. If the sum equals 100 … , then the database attempts to keep no more than PCTFREE free space, and processing costs are highest … . The smaller the difference

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02212: duplicate PCTFREE option specificationCause: The specified value for PCTFREE or PCTUSED is not an integer between 0 and 100. Action … : Choose an appropriate value for the option. ORA-02212: duplicate PCTFREE option specification

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02211: invalid value for PCTFREE or PCTUSEDCause: No ALTER TABLE option was specified. Action: Specify at least one alter table option. ORA-02211: invalid value for PCTFREE or PCTUSED

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14161: subpartition number string : sum of PCTUSED and PCTFREE may not exceed 100; TABLESPACE is the only valid option Action: remove invalid option(s) ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14057: partition " string ": sum of PCTUSED and PCTFREE may not exceed 100Cause: the sum of PCTUSED and PCTFREE for a partition whose number (partitions are numbered … starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for … be used. If, in turn, default PCTUSED and/or PCTFREE values for the partitioned table or index were … not specified, system defaults

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100stack. ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14162: subpartition " string ": sum of PCTUSED and PCTFREE may not exceed 100Cause: the sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered … starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values … used. If, in turn, default PCTUSED and/or PCTFREE values at partition-level were not specified, default … explicitly, system

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14056: partition number string : sum of PCTUSED and PCTFREE may not exceed 100-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on the using_index_clause You cannot specify this clause for a view constraint. You cannot…Handling Constraint Exceptions When defining the state of a constraint, you can specify a table into which Oracle places the rowids of all rows violating the constraint. exceptions_clause Use the exceptions_clause syntax to define exception handling. If you omit schema, then Oracle assumes the exceptions table is in your own schema. If you omit this clause altogether, then Oracle assumes that the

Administrator's Guide, 10g Release 1 (10.1)

17 Managing Clusters

Specify Data Block Space UseBy specifying the PCTFREE and PCTUSED parameters during the creation of a cluster, you can affect … of a cluster data segment. PCTFREE and PCTUSED parameters specified for tables created in a cluster … : "Managing Space in Data Blocks" for information about setting the PCTFREE and PCTUSED parameters

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Managing Space in Data Blocksdiscussed in "Specifying Database Block Sizes". The PCTFREE and PCTUSED parameters are physical … and updates of rows of data. The PCTFREE and PCTUSED parameters allow you to: Improve performance … section: Specifying the PCTFREE Parameter Specifying the PCTUSED Parameter Selecting Associated … PCTUSED and PCTFREE

Guide, 10g Release 1 (10.1)

9 Advanced Materialized Views

Partitioning a Materialized View) (PARTITION month1 VALUES LESS THAN (TO_DATE('31-12-1998', 'DD-MM-YYYY')) PCTFREE 0 PCTUSED 99 STORAGE … ', 'DD-MM-YYYY')) PCTFREE 0 PCTUSED 99 STORAGE (INITIAL 64k NEXT 16k PCTINCREASE 0) TABLESPACE sf2 … , PARTITION month3 VALUES LESS THAN (TO_DATE('31-12-2000', 'DD-MM-YYYY')) PCTFREE 0 PCTUSED 99 STORAGE

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

Altering Integrity Constraints) DEFERRABLE INITIALLY IMMEDIATE RELY USING INDEX PCTFREE = 30 ENABLE VALIDATE; ALTER TABLE X1_tab … MODIFY UNIQUE(A1) INITIALLY DEFERRED NORELY USING INDEX PCTFREE = 40 ENABLE NOVALIDATE; ALTER TABLE … PCTFREE = 30 ENABLE NOVALIDATE; ALTER TABLE T1_tab MODIFY PRIMARY KEY USING INDEX PCTFREE = 35 ENABLE

Packages and Types Reference, 10g Release 1 (10.1)

88 DBMS_SPACE

Usage Notesblock metadata, pctfree etc. The alloc_bytes represent the size of the table when it is created in

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02213: duplicate PCTUSED option specificationCause: PCTFREE option specified more than once. Action: Specify PCTFREE at most once. ORA-02213: duplicate PCTUSED option specification

Administrator's Guide, 10g Release 1 (10.1)

14 Managing Tables

Specify How Data Block Space Is to Be UsedBy specifying the PCTFREE and PCTUSED parameters during the creation of each table, you can affect … the data blocks of a table data segment. The PCTFREE and PCTUSED parameters are discussed in

Administrator's Guide, 10g Release 1 (10.1)

13 Managing Space for Schema Objects

Specifying the PCTUSED Parameterdetermined by PCTFREE, the database does not consider the block for the insertion of new rows until … less (assuming that the used space in the block has previously reached PCTFREE ). Figure 13-2 … PCTUSED is 40 percent. After the free space in a data block reaches PCTFREE, no new rows are … integer between 0 and 99 (inclusive)

User's Guide, 10g Release 1 (10.1)

8 Tuning Tips for the DBA

8.2.3 Segment Attributes and Physical Attributesand consequently achieving optimum retrieval performance. PCTFREE Parameter The PCTFREE parameter … data block, you must set the PCTFREE parameter value to a proper value especially if the BLOB data will … PCTFREE parameter, determine the average size of the BLOB data being stored inline in each row, and then