Data Warehousing Community Forum
February 08, 2012, 11:24:31 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
Databases
>
Oracle
>
PCTFREE and PCTUSED parameters ?
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: PCTFREE and PCTUSED parameters ? (Read 823 times)
Sipra
Founder
Reputation: +59/-0
Offline
Posts: 323
Am the King...
PCTFREE and PCTUSED parameters ?
«
on:
June 25, 2007, 12:19:21 pm »
Hi,
Can anyone please tell me about
PCTFREE
and
PCTUSED
parameters?
Where they can be used?
I guess these parameters relates to data blocks.
Please share your thoughts....
Thanks in advance
Logged
Sipra
Founder
www.dwforum.net
Whoever
Administrator
Reputation: +34/-0
Offline
Posts: 124
Re: PCTFREE and PCTUSED parameters ?
«
Reply #1 on:
June 28, 2007, 10:49:51 am »
I am mentioning the definitions of both
PCTFREE
and
PCTUSED
parameters
A
PCTFREE
is a partition of the data bolck that is not filled by rows as tehy are inserted into a table, but is reserved for later updates made to the rows in that block.
PCTUSED
is the percentage of space in a data block, which ORACLE attempts to fill before it allocates another block.
Hope I am also not sure about these parameters, But for you, I refered for these...
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA