Home » RDBMS Server » Server Administration » table size
table size [message #63657] Mon, 25 October 2004 11:33 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
I have a Aggregate Table which is been created with follwoing statement

create table ABC123_AGG nologging
   TABLESPACE TBS01_AGG
   PCTFREE 5
   PCTUSED 90
   INITRANS 1
   MAXTRANS 255
  STORAGE (
   INITIAL 64M
   NEXT 16M
   PCTINCREASE 0
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 ) as

SELECT FROM THREE TABLES JOIN
......
/

WHEN my co-worker CREATE WITH ABOVE STATEMENT IT TAKES 64 MEGS.
WHEN I CRATE WITH THE BELOW STATEMENT IT TAKES ONLY .25 MEGS, AND TABLESPACE TBS01_AGG is localy managed and uniform Allocation
create table ABC123_AGG nologging
   TABLESPACE TBS01_AGG
SELECT FROM THREE TABLES JOIN
......
/
 can anyone tell me which way is the best way to create this table, why?

Report message to a moderator

Re: table size [message #63658 is a reply to message #63657] Mon, 25 October 2004 13:10 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
If your table fits into .25M and you don't intend to put a lot more data in it than that, then your structure is fine.

pctfree=5 is fine doe data which will receive few or no updates. pctused=90 is very high. See this link:

http://www.cs.umb.edu/cs634/ora9idocs/server.920/a96521/schema.htm#990

Report message to a moderator

Previous Topic: Stop a user from using over 18GB of Temp Space
Next Topic: desc table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:22:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.