OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » why?

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

why? [message #55885]

Fri, 21 February 2003 10:59

JAC
Messages: 12
Registered: February 2003

Junior Member

Why?

I'm creating this table

create table blah
( dummy varchar2(100) )
logging
tablespace data
storage (initial 10M
next 10M)
nocache
/

select initial_extent,
next_extent,
tablespace_name,
extents
from user_segments where segment_name = 'BLAH';

INITIAL_EXTENT NEXT_EXTENT TABLESPACE_NAME EXTENTS
-------------- ----------- ------------------------------ ---------
10485760 16384 DATA 641

What happened with NEXT_EXTENT and number of EXTENTS?

I'm working with Oracle 9i on Solaris 9.2.0.1.0

Is there something different with oracle 8i using extents?

Note.
I'm using undo tablespaces.

Tx

Report message to a moderator

Re: why? [message #55886 is a reply to message #55885]

Fri, 21 February 2003 12:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

-- i believe, becuase by default the extent managment is local ..ie..tablespace is LOCAL TABLESPACE.
-- for a DICTIONARY TABLESPACE u can getit.
-- it is same in 8i
mag@itloaner1_local > select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production             

mag@itloaner1_local > ED
Wrote file afiedt.buf

  1  select SEGMENT_NAME,initial_extent,
  2   next_extent,
  3   tablespace_name,
  4   extents
  5*  from user_segments where segment_name in ('BLAH','BLAH1')
mag@itloaner1_local > /

SEGMENT_NA INITIAL_EXTENT NEXT_EXTENT TABLESPACE_NAME                   EXTENTS
---------- -------------- ----------- ------------------------------ ----------
BLAH             10485760    10485760 USERS                                   1
BLAH1            10485760             OEM                                    10

mag@itloaner1_local > SELECT TABLESPACE_NAME,extent_management from dba_tablespaces;

TABLESPACE_NAME                EXTENT_MAN
------------------------------ ----------
USERS                          DICTIONARY
OEM                            LOCAL

6 rows selected.

Report message to a moderator

Previous Topic:	Codd's Rules
Next Topic:	UNATTENDED patching of 9.2.0.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:48:03 CST 2025