-
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
-
what happened when you created a tablespace and found out?
-
9i -Dictionary managed TS + Manual SSM
10g - Locally managed TS + ASSM
-
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 12:49 PM.
-
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 01: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|