Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Size of Query, Row, Column" and "Change Default Values"
peter wrote:
> Hello DBAs ,
>
> Pls tell me how to see wat will be the size of Output of current
> Query. How to determine the size of a single row and column. How to
> change Default values like while "Creating Table" pctfree is 10 and
> pctused is 40. I want to change these default
> values.How........................
Size of what and in what units? Row length? Bytes? Display size?
You can only change the default values ofr PCTFREE/PCTUSED at the tablespace or cluster level as part of CREATE TABLESPACE or CREATE CLUSTER. Demos in Morgan's Library at www.psoug.org.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu May 11 2006 - 11:11:22 CDT