What is PCT Increase setting?

What is PCT Increase setting?
by

1 Answer

Answer :

PCTINCREASE refers to the percentage by which each next extent (beginning with the third extend) will grow. The size of each subsequent extent is equal to the size of the previous extent plus this percentage increase. Preventing tablespace fragmentation
Try to set PCTINCREASE to 0 or 100. Bizarre values for PCTINCREASE will contribute to fragmentation. For example if you set PCTINCREASE to 1 you will see that your extents are going to have weird and wacky sizes:  100K, 100K, 101K, 102K, etc. Such extents of bizarre size are rarely re-used in their entirety. PCTINCREASE of 0 or 100 gives you nice round extent sizes that can easily be reused. Eg.100K, 100K, 200K, 400K,  etc.
Locally Managed tablespaces (available from Oracle 8i onwards) with uniform extent sizes virtually eliminates any  tablespace fragmentation.
Note that the number of extents per segment does not cause any performance issue anymore, unless they run into  thousands and thousands where additional I/O may be required to fetch the additional blocks where extent maps  of the segment are stored.
by

Related questions

What are the Pct Free and Pct Used

Description : What are the Pct Free and Pct Used

Last Answer : Pct Free is used to denote the percentage of the free space that is to be left when creating a table. Similarly Pct Used is used to denote the percentage of the used space that is to be used when creating a table eg.:: Pctfree 20, Pctused 40

Explain the use of setting GLOBAL_NAMES equal to TRUE.

Description : Explain the use of setting GLOBAL_NAMES equal to TRUE.

Last Answer : Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.

What is path setting for DLL?

Description : What is path setting for DLL?

Last Answer : Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the new F45XTB.DLL.

What are the built-ins that are used for setting the LOV properties at runtime?

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

What is COMPRESS and CONSISTENT setting in EXPORT utility?

Description : What is COMPRESS and CONSISTENT setting in EXPORT utility?

Last Answer : COMPRESS Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold the data. COMPRESS=y - The INITIAL extent of the table would be ... . To minimize this possibility, export those tables at a time when updates are not being done.

What is Automatic Management of Segment Space setting?

Description : What is Automatic Management of Segment Space setting?

Last Answer : Oracle9i New Feature Series: Automatic Segment Space Management Automatic Segment Space Management (ASSM) introduced in Oracle9i is an easier way of managing space in a segment using bitmaps. It ... . ASSM can be specified only with the locally managed tablespaces (LMT). Oracle uses bitmaps

What is PCTFREE and PCTUSED Setting?

Description : What is PCTFREE and PCTUSED Setting?

Last Answer : PCTFREE is a block storage parameter used to specify how much space should be left in a database block for future updates. For example, for PCTFREE=10, Oracle will keep on adding new rows to a block ... SQL> SELECT pct_free FROM user_tables WHERE table_name = 'EMP'; PCT_FREE ---------- 10

What are the best PCT sites in Bangladesh for mobile income ?

Last Answer : You can't make income with mobile, you need laptop

Assertion `:-` Proximal convoluted tubule is lined by brush-bordered cuboidal epithelium. Reason `:-` PCT is main site of selective reabsorption of us

Description : Assertion `:-` Proximal convoluted tubule is lined by brush-bordered cuboidal epithelium. Reason `:-` PCT is main site of selective reabsorption of us

Last Answer : Assertion `:-` Proximal convoluted tubule is lined by brush-bordered cuboidal epithelium. Reason `:-` ... D. If both Assertion & Reason are false.

Assertion `:-` In PCT all of the essential nutrient and 70-80 percent of electrolytes and water are reabsorbed. Reason `:-` PCT is lined by simple cub

Description : Assertion `:-` In PCT all of the essential nutrient and 70-80 percent of electrolytes and water are reabsorbed. Reason `:-` PCT is lined by simple cub

Last Answer : Assertion `:-` In PCT all of the essential nutrient and 70-80 percent of electrolytes and water are ... . D. If both Assertion & Reason are false.

Select the correct order of osmolarity changes in fillrate w.r.t. plasma in `:-` Bowmans capsul `rarr` PCT `rarr` Descending loop of henle `rarr `Asce

Description : Select the correct order of osmolarity changes in fillrate w.r.t. plasma in `:-` Bowmans capsul `rarr` PCT `rarr` Descending loop of henle `rarr `Asce

Last Answer : Select the correct order of osmolarity changes in fillrate w.r.t. plasma in `:-` Bowmans ... `rarr` Isotonic `rarr` Hypotonic `rarr` Hypertonic

Match the following `:-` `{:(,"Column-I",,"Column-II"),(A,"PCT",(i),"Selective secretion of " H^(o+) " and " K^(o+) "ions"),(B,"DCT",(ii),"70-80 perce

Description : Match the following `:-` `{:(,"Column-I",,"Column-II"),(A,"PCT",(i),"Selective secretion of " H^(o+) " and " K^(o+) "ions"),(B,"DCT",(ii),"70-80 perce

Last Answer : Match the following `:-` `{:(,"Column-I",,"Column-II"),(A,"PCT",(i),"Selective secretion of " H^(o+) " and " ... `A-(ii),B-(i),C-(iv),D-(v),E-(iii)`

PCT helps in secretion of______

Description : PCT helps in secretion of______

Last Answer : PCT helps in secretion of______

how much electrolytes are absorbed by PCT of nephron?

Description : how much electrolytes are absorbed by PCT of nephron?

Last Answer : how much electrolytes are absorbed by PCT of nephron?

PCT is lined by _____epithelium

Description : PCT is lined by _____epithelium

Last Answer : PCT is lined by _____epithelium

PCT helps in secretion of______

Description : PCT helps in secretion of______

Last Answer : PCT helps in secretion of______

how much electrolytes are absorbed by PCT of nephron?

Description : how much electrolytes are absorbed by PCT of nephron?

Last Answer : how much electrolytes are absorbed by PCT of nephron?

PCT is lined by _____epithelium

Description : PCT is lined by _____epithelium

Last Answer : PCT is lined by _____epithelium

can I find a cna or pct school in burlington NJIf not,help me to find the nearest cna or pct school in NJ.?

Description : can I find a cna or pct school in burlington NJIf not,help me to find the nearest cna or pct school in NJ.?

Last Answer : There is the Community colleges that offer cna in burlington, NJ?

Glucose is mainly absorbed in (a) PCT (b) DCT (c) Henle's loop (d) Nephron

Description : Glucose is mainly absorbed in (a) PCT (b) DCT (c) Henle's loop (d) Nephron

Last Answer : Ans:(a)

Concentration of urine depends upon which organ? (a) Bowman’s capsule (b) Length of Henle’s loop (c) PCT (d) Network of capillaries arising from glomerulus

Description : Concentration of urine depends upon which organ? (a) Bowman’s capsule (b) Length of Henle’s loop (c) PCT (d) Network of capillaries arising from glomerulus

Last Answer : (b) Length of Henle’s loop

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Where can one get more information about TCL? (for DBA

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

How does one start the Oracle Intelligent Agent? (for DBA

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

What is the Oracle Intelligent Agent? (for DBA

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How does one backout events and jobs during maintenance slots? (for DBA

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

What are the pre requisites ?

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

What kind of jobs can one schedule with OEM? (for DBA

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Difference between SUBSTR and INSTR ?

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Explain UNION,MINUS,UNION ALL, INTERSECT ?

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

WHAT IS RMAN ? (for DBA

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

What are the two parts of a procedure ?

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.