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"
> Pls tell me how to see wht will be the size of Output of current Query.
I'm not sure what you are looking for. Are you trying to figure the number of bytes returned from a query? Or the number of rows returned from a query?
> How to size of a single row and column.
I quit worrying about sizing of rows and columns a long, long time ago. It used to be that there were complex spreadsheets DBA's would use to determine the row sizes, which in turn helped them determine values for INITIAL and NEXT. But we quit worrying about that a very long time ago. I have not had to size a row or column in forever....
> How to change Default values like while "Creating Table" pctfree is 10
> and pctused is 40. I want to change these default
> values.How.....................
Look at creating a Locally Managed Tablespace. When you create this tablespace, create it using Automatic Storage Space Management (ASSM).
To change the PCTFREE and PCTUSED values, you do that in the STORAGE clause:
CREATE TABLE foo (bar NUMBER)
STORAGE (PCTFREE 1 PCTUSED 9);
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu May 11 2006 - 09:38:22 CDT