What is default in 9i and 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What is default in 9i and 10g

  1. #1
    Join Date
    Aug 2007
    Posts
    7

    What is default in 9i and 10g

    Hi, what is default of segment space management in 9i& and 10g.please help me.
    Thanx in advance,
    KVL Narayana

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what happened when you created a tablespace and found out?

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    9i -Dictionary managed TS + Manual SSM
    10g - Locally managed TS + ASSM

  4. #4
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    10g - Locally managed TS + ASSM

    bore,Are you sure ASSM is default in oracle 10g!!!

    C:\>sqlplus/nolog

    SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 13 22:33:55 2007

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    SQL> conn sys as sysdba
    Enter password:
    Connected.
    SQL> create tablespace test
    2 datafile 'e:\test.dbf' size 10m;

    Tablespace created.

    SQL> select tablespace_name,extent_management,segment_space_management
    2 from dba_tablespaces;

    TABLESPACE_NAME EXTENT_MAN SEGMEN
    ------------------------------ ---------- ------
    SYSTEM LOCAL MANUAL
    UNDOTBS1 LOCAL MANUAL
    SYSAUX LOCAL AUTO
    TEMP LOCAL MANUAL
    USERS LOCAL AUTO
    EXAMPLE LOCAL AUTO
    TEST LOCAL MANUAL
    11 rows selected.

    the default behavior of oracle 10g is MANUAL, for segment space management.
    Last edited by liakat; 08-13-2007 at 01:49 PM.

  5. #5
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Hmmmm,
    That's strange. In 10g release 2 default segment space management is AUTO as seen here
    http://download.oracle.com/docs/cd/B...s.htm#i1013496
    also tested:
    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 14 08:10:56 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options

    SQL> create tablespace test
    2 datafile '/u01/app/oracle/oradata/test.dbf' size 5m;

    Tablespace created.

    SQL> select tablespace_name,extent_management,segment_space_management
    2 from dba_tablespaces;

    TABLESPACE_NAME EXTENT_MAN SEGMEN
    ------------------------------ ---------- ------
    SYSTEM LOCAL MANUAL
    UNDOTBS1 LOCAL MANUAL
    SYSAUX LOCAL AUTO
    TEMP LOCAL MANUAL
    USERS LOCAL AUTO
    EXAMPLE LOCAL AUTO
    INVENTORY LOCAL AUTO
    HR_TEST LOCAL AUTO
    TEST LOCAL AUTO

    9 rows selected.


    Did not found that however in the rel 1 docs.
    Seems it's different

    So please avoid colloring in blue and upper case your conclusions

    Regards
    Last edited by Bore; 08-14-2007 at 02:43 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width