OraFAQ Forum: Server Administration » Segment Space management

Home » RDBMS Server » Server Administration » Segment Space management (9.2.0.6.0-IBM AIX)

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

Segment Space management [message #315375]

Mon, 21 April 2008 05:52

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

The paramater SEGMENT SPACE MAMAGEMENT for UNDO Tablespace at my TEST database is "MANUAL".

How can I change the parameter "SEGMENT SPACE MAMAGEMENT" from "MANUAL" to "AUTO"?

Please suggest.

Pokhraj.

Report message to a moderator

Re: Segment Space management [message #315377 is a reply to message #315375]

Mon, 21 April 2008 05:57

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

Senior Member
Account Moderator

You can't do it:

SQL> create undo tablespace undo2 datafile 'C:\ORACLE\BASES\MIKA\UNDOTBS02.DBF' size 10m
  2  segment space management auto;
segment space management auto
*
ERROR at line 2:
ORA-30024: Invalid specification for CREATE UNDO TABLESPAC

Regards
Michel

Report message to a moderator

Re: Segment Space management [message #315379 is a reply to message #315375]

Mon, 21 April 2008 06:00

pokhraj_das
Messages: 64
Registered: February 2008

Member

So how can I change the parameter ?
please suggest me the solution for the same.

Pokhraj

Report message to a moderator

Re: Segment Space management [message #315380 is a reply to message #315375]

Mon, 21 April 2008 06:07

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

The paramater SEGMENT SPACE MAMAGEMENT for UNDO Tablespace at my TEST database is "MANUAL"

WHats the output of
SQL>show parameter undo_management

Report message to a moderator

Re: Segment Space management [message #315381 is a reply to message #315375]

Mon, 21 April 2008 06:09

pokhraj_das
Messages: 64
Registered: February 2008

Member

The parameter for sho paramater undo_management is "AUTO"

Report message to a moderator

Re: Segment Space management [message #315382 is a reply to message #315375]

Mon, 21 April 2008 06:12

varu123
Messages: 754
Registered: October 2007

Senior Member

SO the segment space management is auto.

From where did you see it is manual?

Report message to a moderator

Re: Segment Space management [message #315386 is a reply to message #315375]

Mon, 21 April 2008 06:22

pokhraj_das
Messages: 64
Registered: February 2008

Member

select tablespace_name, SEGMENT_SPACE_MANAGEMENT
from dba_tablespaces;

Report message to a moderator

Re: Segment Space management [message #315390 is a reply to message #315375]

Mon, 21 April 2008 06:40

varu123
Messages: 754
Registered: October 2007

Senior Member

So its the default.
system,undo temp have manual segment space management.

and extent management is local.

Report message to a moderator

Re: Segment Space management [message #315400 is a reply to message #315379]

Mon, 21 April 2008 07:11

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

Senior Member
Account Moderator

Quote:

So how can I change the parameter ?

You can't, you can't change, you can't create with auto, manual is mandatory.

Regards
Michel

Report message to a moderator

Re: Segment Space management [message #315480 is a reply to message #315375]

Mon, 21 April 2008 12:52

varu123
Messages: 754
Registered: October 2007

Senior Member

But if we create undo /temp tablespace later on then it is possible to specify segment space management to auto.

But why oracle defaults system tablespace to manual when there are benefits of automatic segment space management?

Report message to a moderator

Re: Segment Space management [message #315483 is a reply to message #315375]

Mon, 21 April 2008 12:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But why oracle defaults system tablespace to manual when there are benefits of automatic segment space management?

So are you claiming that you know better than Oracle how manage Oracle's resources?

SYSTEM is Oracle's tablespace & you should not waste your precious thoughts being concerned about how Oracle manages its own resources.

You seem to face enough challenges of your own making without trying to do Oracle's job too.

Report message to a moderator

Re: Segment Space management [message #315486 is a reply to message #315375]

Mon, 21 April 2008 13:05

varu123
Messages: 754
Registered: October 2007

Senior Member

Hey Ana,
I asked a simple question.
Why oracle does not follow what it recommends?
I know system is a special tablespace but it does grow as any other tablespace.

Does it mean the concept of bitmaps is not applicable to it?

Report message to a moderator

Re: Segment Space management [message #315491 is a reply to message #315375]

Mon, 21 April 2008 13:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Does it mean the concept of bitmaps is not applicable to it?
Why do you care?

How will the answer one way or the other change your behavior?

What prevents you from generating a SELECT against objects in SYSTEM tablespace & reporting object_type & COUNT(*) to answer your own question?

Report message to a moderator

Re: Segment Space management [message #315567 is a reply to message #315375]

Mon, 21 April 2008 22:25

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi Varu
>But if we create undo /temp tablespace later on then it is possible to specify segment space management to auto

Could you please let me know the COMMAND for the same?

pokhraj

Report message to a moderator

Re: Segment Space management [message #315574 is a reply to message #315567]

Tue, 22 April 2008 00:33

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

Senior Member
Account Moderator

Did you read my first post?

Michel Cadot wrote on Mon, 21 April 2008 12:57

You can't do it:

SQL> create undo tablespace undo2 datafile 'C:\ORACLE\BASES\MIKA\UNDOTBS02.DBF' size 10m
  2  segment space management auto;
segment space management auto
*
ERROR at line 2:
ORA-30024: Invalid specification for CREATE UNDO TABLESPAC

Regards
Michel

Did you read all my posts?

IT IS NOT POSSIBLE!

Is this clear?

Regards
Michel

Report message to a moderator

Previous Topic:	Mail from Oracle procedure
Next Topic:	recover deleted records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:50:48 CDT 2024