OraFAQ Forum: Server Administration » Oracle allocate extent size strategy

Home » RDBMS Server » Server Administration » Oracle allocate extent size strategy (Solaris + ORACLE 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle allocate extent size strategy [message #413570]

Thu, 16 July 2009 08:27

ganludong
Messages: 5
Registered: July 2009
Location: SICHUAN NORMAL UNIVERSITY...

Junior Member

The first

I check the size of Block_size
select block_size from user_tablespace;
the block size of tablespace t1 is 8K

then I create a table

create table student (id int)
tablespace t1
storage(
initial 40K
next 40K
);

moreover

select bytes/1024 from dba_extents where segment_name='STUDENT';
I get the first extent size is 60K instand of 40K? it confused me for a long time

please help me
Very Appriciate!!

[Updated on: Thu, 16 July 2009 08:31]

Report message to a moderator

Re: Oracle allocate extent size strategy [message #413572 is a reply to message #413570]

Thu, 16 July 2009 08:31

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> desc user_tablespaces
 Name                         
 -----------------------------
 TABLESPACE_NAME              
 BLOCK_SIZE                   
 INITIAL_EXTENT               
 NEXT_EXTENT                  
 MIN_EXTENTS                  
 MAX_EXTENTS                  
 PCT_INCREASE                 
 MIN_EXTLEN                   
 STATUS                       
 CONTENTS                     
 LOGGING                      
 FORCE_LOGGING                
 EXTENT_MANAGEMENT            
 ALLOCATION_TYPE              
 SEGMENT_SPACE_MANAGEMENT     
 DEF_TAB_COMPRESSION          
 RETENTION                    
 BIGFILE

Check the other parameters of the view.

Also a good reading: Database Concepts

Regards
Michel

Report message to a moderator

Re: Oracle allocate extent size strategy [message #413573 is a reply to message #413570]

Thu, 16 July 2009 08:32

ganludong
Messages: 5
Registered: July 2009
Location: SICHUAN NORMAL UNIVERSITY...

Junior Member

I have check the user_tablespace view

the result is what i have setted

Report message to a moderator

Re: Oracle allocate extent size strategy [message #413583 is a reply to message #413573]

Thu, 16 July 2009 08:58

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes but you didn't check the OTHER columns.
Can you read what I post?

Regards
Michel

Report message to a moderator

Previous Topic:	USER_OBJECTS lists BIN$* objects
Next Topic:	Number of permissable sessions in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:18:15 CDT 2024